summaryrefslogtreecommitdiff
path: root/maintenance/mssql/archives/patch-oi_major_mime-chemical.sql
blob: 35482edcdfcd6b6e9b73c28c0ccfb8cdff0b20f8 (plain)
1
2
3
4
ALTER TABLE /*_*/oldimage
DROP CONSTRAINT oi_major_mime_ckc;
ALTER TABLE /*_*/oldimage
WITH NOCHECK ADD CONSTRAINT oi_major_mime_ckc CHECK (oi_major_mime IN('unknown', 'application', 'audio', 'image', 'text', 'video', 'message', 'model', 'multipart', 'chemical'));