CREATE TABLE bt_bugs ( bug_id integer PRIMARY KEY NOT NULL, bug_number integer, comment_content text(-5), comment_format varchar(200), parent_id integer, live_revision_id integer, summary varchar(1000), project_id integer, component_id integer, resolution varchar(50), user_agent varchar(500), found_in_version integer, fix_for_version integer, fixed_in_version integer, creation_date timestamp, creation_user integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT bt_bug_bt_bug_fk REFERENCES cr_items (), CONSTRAINT bt_bug_pk REFERENCES cr_items (), CONSTRAINT bt_bug_parent_id_bug_number_un REFERENCES cr_items () ); CREATE UNIQUE INDEX bt_bug_parent_id_bug_number_un ON bt_bugs (parent_id, bug_number); CREATE INDEX bt_bugs_bug_number_idx ON bt_bugs (bug_number); CREATE INDEX bt_bugs_creation_date_idx ON bt_bugs (creation_date); CREATE INDEX bt_bugs_creation_user_idx ON bt_bugs (creation_user); CREATE INDEX bt_bugs_fix_for_version_idx ON bt_bugs (fix_for_version); CREATE INDEX bt_bugs_proj_id_bug_number_idx ON bt_bugs (project_id, bug_number); CREATE INDEX bt_bugs_proj_id_crea_date_idx ON bt_bugs (project_id, creation_date); CREATE INDEX bt_bugs_proj_id_fix_for_idx ON bt_bugs (project_id, fix_for_version); CREATE TRIGGER bt_bug_search__dtrg AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE bt_bug_search__dtrg (disabled) CREATE TRIGGER bt_bug_search__itrg AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE bt_bug_search__itrg (disabled) CREATE TRIGGER bt_bug_search__utrg AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE bt_bug_search__utrg (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340869 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340870 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 2,678,784 bytes -- Table rows: 3,621
Begin main content
