CREATE TABLE ec_cat_mailing_lists ( user_id integer NOT NULL, category_id integer, subcategory_id integer, subsubcategory_id integer, CONSTRAINT ec_cat_mailing_lists_subcategory_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_cat_mailing_lists_subsubcategory_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_cat_mailing_lists_user_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_cat_mailing_lists_category_id_fkey REFERENCES ec_categories (), CONSTRAINT ec_cat_mailing_lists_subsubcategory_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_cat_mailing_lists_category_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_cat_mailing_lists_subcategory_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_cat_mailing_lists_user_id_fkey REFERENCES ec_subcategories (), CONSTRAINT ec_cat_mailing_lists_user_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_cat_mailing_lists_subsubcategory_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_cat_mailing_lists_subcategory_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_cat_mailing_lists_category_id_fkey REFERENCES ec_subsubcategories (), CONSTRAINT ec_cat_mailing_lists_user_id_fkey REFERENCES users (), CONSTRAINT ec_cat_mailing_lists_category_id_fkey REFERENCES users (), CONSTRAINT ec_cat_mailing_lists_subcategory_id_fkey REFERENCES users (), CONSTRAINT ec_cat_mailing_lists_subsubcategory_id_fkey REFERENCES users () ); CREATE INDEX ec_cat_mailing_list_idx ON ec_cat_mailing_lists (user_id); CREATE INDEX ec_cat_mailing_list_idx2 ON ec_cat_mailing_lists (category_id); CREATE INDEX ec_cat_mailing_list_idx3 ON ec_cat_mailing_lists (subcategory_id); CREATE INDEX ec_cat_mailing_list_idx4 ON ec_cat_mailing_lists (subsubcategory_id); CREATE TRIGGER RI_ConstraintTrigger_c_341719 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341720 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341724 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341725 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341729 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341730 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341734 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341735 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
