CREATE TABLE bt_default_keywords ( project_id integer NOT NULL, parent_id integer NOT NULL, keyword_id integer NOT NULL, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT bt_default_keyw_keyword_fk REFERENCES cr_keywords (), CONSTRAINT bt_default_keyw_parent_keyw_fk REFERENCES cr_keywords (), CONSTRAINT bt_default_keywords_prj_par_un REFERENCES cr_keywords (), CONSTRAINT bt_default_keywords_project_fk REFERENCES cr_keywords () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT bt_default_keywords_project_fk REFERENCES cr_keywords (), CONSTRAINT bt_default_keywords_prj_par_un REFERENCES cr_keywords (), CONSTRAINT bt_default_keyw_parent_keyw_fk REFERENCES cr_keywords (), CONSTRAINT bt_default_keyw_keyword_fk REFERENCES cr_keywords () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT bt_default_keywords_project_fk REFERENCES bt_projects (), CONSTRAINT bt_default_keyw_keyword_fk REFERENCES bt_projects (), CONSTRAINT bt_default_keyw_parent_keyw_fk REFERENCES bt_projects (), CONSTRAINT bt_default_keywords_prj_par_un REFERENCES bt_projects () ); CREATE INDEX bt_default_keyw_keyword_id_idx ON bt_default_keywords (keyword_id); CREATE INDEX bt_default_keyw_parent_id_idx ON bt_default_keywords (parent_id); CREATE UNIQUE INDEX bt_default_keywords_prj_par_un ON bt_default_keywords (project_id, parent_id); CREATE TRIGGER RI_ConstraintTrigger_c_340914 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340915 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340919 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340920 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340924 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340925 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 2
Begin main content
