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