CREATE TABLE attachments ( object_id integer NOT NULL, item_id integer NOT NULL, approved_p bool DEFAULT true NOT NULL, PRIMARY KEY (object_id,item_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT attachments_item_id_fk REFERENCES acs_objects (), CONSTRAINT attachments_object_id_fk REFERENCES acs_objects (), CONSTRAINT attachments_pk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT attachments_pk REFERENCES acs_objects (), CONSTRAINT attachments_item_id_fk REFERENCES acs_objects (), CONSTRAINT attachments_object_id_fk REFERENCES acs_objects () ); CREATE INDEX attachments_item_id_idx ON attachments (item_id); CREATE TRIGGER RI_ConstraintTrigger_c_340769 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340770 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340774 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340775 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 20
Begin main content
