CREATE TABLE bt_patch_actions ( action_id integer PRIMARY KEY NOT NULL, patch_id integer NOT NULL, action varchar(50) DEFAULT 'open'::character varying, actor integer NOT NULL, action_date timestamptz DEFAULT now() NOT NULL, comment_text text(-5), comment_format varchar(30) DEFAULT 'plain'::character varying NOT NULL, CONSTRAINT bt_patch_actions_action_ck REFERENCES users (), CONSTRAINT bt_patch_actions_actor_fk REFERENCES users (), CONSTRAINT bt_patch_actions_comment_format REFERENCES users (), CONSTRAINT bt_patch_actions_patch_fk REFERENCES users (), CONSTRAINT bt_patch_actions_pk REFERENCES users () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT bt_patch_actions_pk REFERENCES bt_patches (), CONSTRAINT bt_patch_actions_action_ck REFERENCES bt_patches (), CONSTRAINT bt_patch_actions_actor_fk REFERENCES bt_patches (), CONSTRAINT bt_patch_actions_comment_format REFERENCES bt_patches (), CONSTRAINT bt_patch_actions_patch_fk REFERENCES bt_patches () ); CREATE INDEX bt_patch_actions_actor_idx ON bt_patch_actions (actor); CREATE INDEX bt_patch_actions_patch_id_fk ON bt_patch_actions (patch_id); CREATE TRIGGER RI_ConstraintTrigger_c_340929 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340930 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340934 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340935 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 344,064 bytes -- Table rows: 1,918
Begin main content
