CREATE TABLE pa_collection_photo_map ( collection_id integer NOT NULL, photo_id integer NOT NULL, PRIMARY KEY (collection_id,photo_id), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT pa_collection_photo_map_pk REFERENCES pa_collections (), CONSTRAINT pa_collections_fk REFERENCES pa_collections (), CONSTRAINT pa_photos_fk REFERENCES pa_collections () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT pa_photos_fk REFERENCES cr_items (), CONSTRAINT pa_collection_photo_map_pk REFERENCES cr_items (), CONSTRAINT pa_collections_fk REFERENCES cr_items () ); CREATE TRIGGER RI_ConstraintTrigger_c_342754 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342755 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342774 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342775 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 18
Begin main content
