-- -- This is general data for each category tree. -- CREATE TABLE category_trees ( -- -- ID of a tree. -- tree_id integer PRIMARY KEY NOT NULL, -- -- Declares if a tree is site-wide or local (only usable by users/groups -- that have permissions). -- site_wide_p bool DEFAULT true, ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cat_trees_tree_id_fk REFERENCES acs_objects (), CONSTRAINT category_trees_pkey REFERENCES acs_objects () ); CREATE TRIGGER RI_ConstraintTrigger_a_341097 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341098 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341112 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341113 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341122 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341123 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341129 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341130 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to category_trees: --categories(cat_trees_tree_id_fk) --categories(category_trees_pkey) --category_tree_map(cat_trees_tree_id_fk) --category_tree_map(category_trees_pkey) --category_tree_translations(cat_trees_tree_id_fk) --category_tree_translations(category_trees_pkey) -- Table size: 8,192 bytes -- Table rows: 4
Begin main content
