-- -- Stores a subject taxonomy for classifying content items, analogous -- to the system used by a library. -- CREATE TABLE cr_keywords ( keyword_id integer PRIMARY KEY NOT NULL, parent_id integer, -- -- A subject heading. This will become a message ID in the next -- release so it should never be referenced directly (only through -- the API) -- heading varchar(600) NOT NULL, -- -- Description of a subject heading. This will be a message ID in the next -- release so it should never be referenced directly (only through -- the API) -- description text(-5), has_children bool, tree_sortkey varbit(-5), CONSTRAINT cr_keywords_hier REFERENCES cr_keywords (), CONSTRAINT cr_keywords_pk REFERENCES cr_keywords () ); CREATE INDEX cr_keywords_parent_id_idx ON cr_keywords (parent_id); CREATE TRIGGER cr_keywords_tree_insert_tr BEFORE INSERT FOR EACH ROW EXECUTE PROCEDURE cr_keywords_tree_insert_tr (disabled) CREATE TRIGGER cr_keywords_tree_update_tr AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE cr_keywords_tree_update_tr (disabled) CREATE TRIGGER cr_keywords_update_tr AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE cr_keywords_update_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340197 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340198 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340897 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340898 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340902 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340903 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340912 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340913 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340917 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340918 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340982 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340983 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341297 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341298 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341382 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341383 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341384 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341385 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to cr_keywords: --bt_default_keywords(cr_keywords_hier) --bt_default_keywords(cr_keywords_pk) --bt_keyword_component_map(cr_keywords_hier) --bt_keyword_component_map(cr_keywords_pk) --bt_projects(cr_keywords_hier) --bt_projects(cr_keywords_pk) --code_keyword_map_temp(cr_keywords_hier) --code_keyword_map_temp(cr_keywords_pk) --cr_item_keyword_map(cr_keywords_hier) --cr_item_keyword_map(cr_keywords_pk) --cr_keywords(cr_keywords_hier) --cr_keywords(cr_keywords_pk) -- Table size: 16,384 bytes -- Table rows: 158
Begin main content
