summaryrefslogtreecommitdiff
path: root/www/wiki/maintenance/mssql/archives/patch-add-3d.sql
blob: 51d2775f2813cd33aa316b1a57a08f27b9e001b0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
ALTER TABLE /*$wgDBprefix*/image
	DROP CONSTRAINT img_media_type_ckc;

ALTER TABLE /*$wgDBprefix*/image
	ADD CONSTRAINT img_media_type_ckc
	CHECK (img_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D"));

ALTER TABLE /*$wgDBprefix*/oldimage
	DROP CONSTRAINT oi_media_type_ckc;

ALTER TABLE /*$wgDBprefix*/oldimage
	ADD CONSTRAINT oi_media_type_ckc
	CHECK (oi_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D"));

ALTER TABLE /*$wgDBprefix*/filearchive
	DROP CONSTRAINT fa_media_type_ckc;

ALTER TABLE /*$wgDBprefix*/filearchive
	ADD CONSTRAINT fa_media_type_ckc
	CHECK (fa_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D"));

ALTER TABLE /*$wgDBprefix*/uploadstash
	DROP CONSTRAINT us_media_type_ckc;

ALTER TABLE /*$wgDBprefix*/uploadstash
	ADD CONSTRAINT us_media_type_ckc
	CHECK (us_media_type IN("UNKNOWN", "BITMAP", "DRAWING", "AUDIO", "VIDEO", "MULTIMEDIA", "OFFICE", "TEXT", "EXECUTABLE", "ARCHIVE", "3D"));