CREATE TABLE ec_categories ( category_id integer PRIMARY KEY NOT NULL, category_name varchar(100), sort_key numeric(65535, 65531), last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_categories_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_categories_pkey REFERENCES users () ); CREATE INDEX ec_categories_sort_idx ON ec_categories (sort_key); CREATE TRIGGER ec_categories_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_categories_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341717 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341718 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341739 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341740 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341742 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341743 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341757 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341758 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342057 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342058 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342217 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342218 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342242 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342243 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342322 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342323 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to ec_categories: --ec_cat_mailing_lists(ec_categories_last_modifying_user_fkey) --ec_cat_mailing_lists(ec_categories_pkey) --ec_category_product_map(ec_categories_last_modifying_user_fkey) --ec_category_product_map(ec_categories_pkey) --ec_category_template_map(ec_categories_last_modifying_user_fkey) --ec_category_template_map(ec_categories_pkey) --ec_product_recommendations(ec_categories_last_modifying_user_fkey) --ec_product_recommendations(ec_categories_pkey) --ec_spam_log(ec_categories_last_modifying_user_fkey) --ec_spam_log(ec_categories_pkey) --ec_subcategories(ec_categories_last_modifying_user_fkey) --ec_subcategories(ec_categories_pkey) --ec_user_session_info(ec_categories_last_modifying_user_fkey) --ec_user_session_info(ec_categories_pkey) -- Table size: 0 bytes -- Table rows: 0
Begin main content
