CREATE TABLE ec_templates ( template_id integer PRIMARY KEY NOT NULL, template_name varchar(200), template varchar(4000), last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_templates_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_templates_pkey REFERENCES users () ); CREATE TRIGGER ec_templates_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_templates_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341682 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341683 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341762 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341763 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342137 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342138 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342294 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342295 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to ec_templates: --ec_admin_settings(ec_templates_last_modifying_user_fkey) --ec_admin_settings(ec_templates_pkey) --ec_category_template_map(ec_templates_last_modifying_user_fkey) --ec_category_template_map(ec_templates_pkey) --ec_products(ec_templates_last_modifying_user_fkey) --ec_products(ec_templates_pkey) -- Table size: 8,192 bytes -- Table rows: 1
Begin main content
