CREATE TABLE bt_versions ( version_id integer PRIMARY KEY NOT NULL, project_id integer NOT NULL, version_name varchar(500) NOT NULL, description text(-5), anticipated_freeze_date date, actual_freeze_date date, anticipated_release_date date, actual_release_date date, maintainer integer, supported_platforms varchar(1000), active_version_p char(1) DEFAULT 'f'::bpchar NOT NULL, assignable_p char(1), CONSTRAINT bt_versions_active_version_p_ck REFERENCES users (), CONSTRAINT bt_versions_pk REFERENCES users (), CONSTRAINT bt_versions_maintainer_fk REFERENCES users (), CONSTRAINT bt_versions_assignable_p_ck REFERENCES users () ); CREATE TRIGGER RI_ConstraintTrigger_a_340882 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340883 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340887 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340888 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340892 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340893 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340957 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340958 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340962 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340963 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340967 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340968 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340997 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340998 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341009 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341010 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to bt_versions: --bt_bug_revisions(bt_versions_active_version_p_ck) --bt_bug_revisions(bt_versions_assignable_p_ck) --bt_bug_revisions(bt_versions_maintainer_fk) --bt_bug_revisions(bt_versions_pk) --bt_patches(bt_versions_active_version_p_ck) --bt_patches(bt_versions_assignable_p_ck) --bt_patches(bt_versions_maintainer_fk) --bt_patches(bt_versions_pk) --bt_user_prefs(bt_versions_active_version_p_ck) --bt_user_prefs(bt_versions_assignable_p_ck) --bt_user_prefs(bt_versions_maintainer_fk) --bt_user_prefs(bt_versions_pk) -- Table size: 8,192 bytes -- Table rows: 38
Begin main content
