CREATE TABLE public.email_templates
(
    template_key character varying(50) NOT NULL,
    language character varying(5) NOT NULL DEFAULT 'es'::character varying,
    subject character varying(255) NOT NULL,
    body_html text NOT NULL,
    body_text text,
    active boolean NOT NULL DEFAULT true,
    updated_at valid_timestamp DEFAULT now(),
    CONSTRAINT email_templates_pkey PRIMARY KEY (template_key, language)
);