CREATE TABLE bt_patches ( patch_id integer PRIMARY KEY NOT NULL, patch_number integer NOT NULL, project_id integer, component_id integer, summary text(-5), content text(-5), generated_from_version integer, apply_to_version integer, applied_to_version integer, status varchar(50) DEFAULT 'open'::character varying NOT NULL, CONSTRAINT bt_patches_components_fk REFERENCES bt_components (), CONSTRAINT bt_patchs_status_ck REFERENCES bt_components (), CONSTRAINT bt_patchs_apply_to_version_fk REFERENCES bt_components (), CONSTRAINT bt_patches_pid_fk REFERENCES bt_components (), CONSTRAINT bt_patchs_applied_to_version_fk REFERENCES bt_components (), CONSTRAINT bt_patches_vid_fk REFERENCES bt_components (), CONSTRAINT bt_patches_pk REFERENCES bt_components (), CONSTRAINT bt_patchs_status_ck REFERENCES acs_objects (), CONSTRAINT bt_patches_components_fk REFERENCES acs_objects (), CONSTRAINT bt_patches_pid_fk REFERENCES acs_objects (), CONSTRAINT bt_patches_pk REFERENCES acs_objects (), CONSTRAINT bt_patches_vid_fk REFERENCES acs_objects (), CONSTRAINT bt_patchs_applied_to_version_fk REFERENCES acs_objects (), CONSTRAINT bt_patchs_apply_to_version_fk REFERENCES acs_objects (), CONSTRAINT bt_patches_vid_fk REFERENCES bt_versions (), CONSTRAINT bt_patchs_status_ck REFERENCES bt_versions (), CONSTRAINT bt_patchs_apply_to_version_fk REFERENCES bt_versions (), CONSTRAINT bt_patchs_applied_to_version_fk REFERENCES bt_versions (), CONSTRAINT bt_patches_pk REFERENCES bt_versions (), CONSTRAINT bt_patches_pid_fk REFERENCES bt_versions (), CONSTRAINT bt_patches_components_fk REFERENCES bt_versions (), CONSTRAINT bt_patchs_status_ck REFERENCES bt_versions (), CONSTRAINT bt_patchs_apply_to_version_fk REFERENCES bt_versions (), CONSTRAINT bt_patchs_applied_to_version_fk REFERENCES bt_versions (), CONSTRAINT bt_patches_vid_fk REFERENCES bt_versions (), CONSTRAINT bt_patches_pk REFERENCES bt_versions (), CONSTRAINT bt_patches_pid_fk REFERENCES bt_versions (), CONSTRAINT bt_patches_components_fk REFERENCES bt_versions (), CONSTRAINT bt_patchs_status_ck REFERENCES bt_versions (), CONSTRAINT bt_patchs_apply_to_version_fk REFERENCES bt_versions (), CONSTRAINT bt_patchs_applied_to_version_fk REFERENCES bt_versions (), CONSTRAINT bt_patches_vid_fk REFERENCES bt_versions (), CONSTRAINT bt_patches_pk REFERENCES bt_versions (), CONSTRAINT bt_patches_pid_fk REFERENCES bt_versions (), CONSTRAINT bt_patches_components_fk REFERENCES bt_versions () ); CREATE UNIQUE INDEX bt_patches_un ON bt_patches (patch_number, project_id); CREATE TRIGGER RI_ConstraintTrigger_a_340932 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340933 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340937 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340938 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340949 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340950 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340954 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340955 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340959 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340960 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340964 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340965 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340969 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340970 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to bt_patches: --bt_patch_actions(bt_patches_components_fk) --bt_patch_actions(bt_patches_pid_fk) --bt_patch_actions(bt_patches_pk) --bt_patch_actions(bt_patches_vid_fk) --bt_patch_actions(bt_patchs_applied_to_version_fk) --bt_patch_actions(bt_patchs_apply_to_version_fk) --bt_patch_actions(bt_patchs_status_ck) --bt_patch_bug_map(bt_patches_components_fk) --bt_patch_bug_map(bt_patches_pid_fk) --bt_patch_bug_map(bt_patches_pk) --bt_patch_bug_map(bt_patches_vid_fk) --bt_patch_bug_map(bt_patchs_applied_to_version_fk) --bt_patch_bug_map(bt_patchs_apply_to_version_fk) --bt_patch_bug_map(bt_patchs_status_ck) -- Table size: 950,272 bytes -- Table rows: 987
Begin main content
