-- -- Information about the categories in the tree structure. -- CREATE TABLE categories ( -- -- ID of a category. -- category_id integer PRIMARY KEY NOT NULL, -- -- ID of a tree (see category_trees). -- tree_id integer, -- -- Points to a parent category in the tree or null (if topmost category). -- parent_id integer, -- -- Marks categories to be no longer supported. -- deprecated_p bool DEFAULT false, -- -- Left index in nested set structure of a tree. -- left_ind integer, -- -- Right index in nested set structure of a tree. -- right_ind integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cat_category_id_fk REFERENCES acs_objects (), CONSTRAINT cat_parent_id_fk REFERENCES acs_objects (), CONSTRAINT cat_tree_id_fk REFERENCES acs_objects (), CONSTRAINT categories_pkey REFERENCES acs_objects (), CONSTRAINT categories_pkey REFERENCES categories (), CONSTRAINT cat_tree_id_fk REFERENCES categories (), CONSTRAINT cat_parent_id_fk REFERENCES categories (), CONSTRAINT cat_category_id_fk REFERENCES categories () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT categories_pkey REFERENCES category_trees (), CONSTRAINT cat_category_id_fk REFERENCES category_trees (), CONSTRAINT cat_parent_id_fk REFERENCES category_trees (), CONSTRAINT cat_tree_id_fk REFERENCES category_trees () ); CREATE INDEX categories_left_ix ON categories (tree_id, left_ind); CREATE INDEX categories_parent_ix ON categories (parent_id, category_id); CREATE INDEX categories_tree_id_idx ON categories (tree_id); CREATE TRIGGER RI_ConstraintTrigger_c_341069 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341070 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341072 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341073 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341082 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341083 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341084 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341085 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341087 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341088 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341099 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341100 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341107 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341108 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341132 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341133 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341137 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341138 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341167 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341168 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to categories: --categories(cat_category_id_fk) --categories(cat_parent_id_fk) --categories(cat_tree_id_fk) --categories(categories_pkey) --category_links(cat_category_id_fk) --category_links(cat_parent_id_fk) --category_links(cat_tree_id_fk) --category_links(categories_pkey) --category_object_map(cat_category_id_fk) --category_object_map(cat_parent_id_fk) --category_object_map(cat_tree_id_fk) --category_object_map(categories_pkey) --category_synonyms(cat_category_id_fk) --category_synonyms(cat_parent_id_fk) --category_synonyms(cat_tree_id_fk) --category_synonyms(categories_pkey) --category_translations(cat_category_id_fk) --category_translations(cat_parent_id_fk) --category_translations(cat_tree_id_fk) --category_translations(categories_pkey) --category_tree_map(cat_category_id_fk) --category_tree_map(cat_parent_id_fk) --category_tree_map(cat_tree_id_fk) --category_tree_map(categories_pkey) -- Table size: 16,384 bytes -- Table rows: 179
Begin main content
