CREATE TABLE ec_email_templates ( email_template_id integer PRIMARY KEY NOT NULL, title varchar(100), subject varchar(200), message varchar(4000), variables varchar(1000), when_sent varchar(1000), issue_type_list varchar(100), last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_email_templates_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_email_templates_pkey REFERENCES users () ); CREATE TRIGGER ec_email_templates_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_email_templates_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341692 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341693 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341844 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341845 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_email_templates: --ec_automatic_email_log(ec_email_templates_last_modifying_user_fkey) --ec_automatic_email_log(ec_email_templates_pkey) -- Table size: 8,192 bytes -- Table rows: 6
Begin main content
