CREATE TABLE bt_bug_revisions ( bug_revision_id integer PRIMARY KEY NOT NULL, component_id integer, resolution varchar(50), user_agent varchar(500), found_in_version integer, fix_for_version integer, fixed_in_version integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT bt_bug_rev_bug_id_fk REFERENCES cr_revisions (), CONSTRAINT bt_bug_rev_resolution_ck REFERENCES cr_revisions (), CONSTRAINT bt_bug_rev_pk REFERENCES cr_revisions (), CONSTRAINT bt_bug_rev_components_fk REFERENCES cr_revisions (), CONSTRAINT bt_bug_rev_found_in_version_fk REFERENCES cr_revisions (), CONSTRAINT bt_bug_rev_fixed_in_version_fk REFERENCES cr_revisions (), CONSTRAINT bt_bug_rev_fix_for_version_fk REFERENCES cr_revisions (), CONSTRAINT bt_bug_rev_resolution_ck REFERENCES bt_components (), CONSTRAINT bt_bug_rev_bug_id_fk REFERENCES bt_components (), CONSTRAINT bt_bug_rev_components_fk REFERENCES bt_components (), CONSTRAINT bt_bug_rev_fix_for_version_fk REFERENCES bt_components (), CONSTRAINT bt_bug_rev_fixed_in_version_fk REFERENCES bt_components (), CONSTRAINT bt_bug_rev_found_in_version_fk REFERENCES bt_components (), CONSTRAINT bt_bug_rev_pk REFERENCES bt_components (), CONSTRAINT bt_bug_rev_fixed_in_version_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_resolution_ck REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_pk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_found_in_version_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_fix_for_version_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_components_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_bug_id_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_resolution_ck REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_pk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_found_in_version_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_fixed_in_version_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_fix_for_version_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_components_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_bug_id_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_resolution_ck REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_pk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_found_in_version_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_fixed_in_version_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_fix_for_version_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_components_fk REFERENCES bt_versions (), CONSTRAINT bt_bug_rev_bug_id_fk REFERENCES bt_versions () ); CREATE INDEX bt_bug_revisions_component_id_idx ON bt_bug_revisions (component_id); CREATE TRIGGER RI_ConstraintTrigger_c_340874 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340875 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340879 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340880 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340884 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340885 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340889 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340890 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340894 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340895 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 966,656 bytes -- Table rows: 7,200
Begin main content
