summaryrefslogtreecommitdiff
path: root/maintenance/mssql/archives/patch-img_major_mime-chemical.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/mssql/archives/patch-img_major_mime-chemical.sql')
-rw-r--r--maintenance/mssql/archives/patch-img_major_mime-chemical.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/maintenance/mssql/archives/patch-img_major_mime-chemical.sql b/maintenance/mssql/archives/patch-img_major_mime-chemical.sql
new file mode 100644
index 00000000..eed07869
--- /dev/null
+++ b/maintenance/mssql/archives/patch-img_major_mime-chemical.sql
@@ -0,0 +1,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')); \ No newline at end of file