It seems {T68412} (2014) was never applied to production. For example, filearchive in enwiki is:
```
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart')
```
While locally it's:
```
fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical')
```
This has caused massive [[https://people.wikimedia.org/~ladsgroup/by_drift_type_drifts.json|drift reports]]:
```lang=json
[
"filearchive fa_major_mime field-size-mismatch": {
"s1": [
"db1083:enwiki",
"db1084:enwiki",
"db1169:enwiki",
"db1118:enwiki",
"db1163:enwiki",
"db1106:enwiki",
"db1164:enwiki",
"db1119:enwiki",
"db1134:enwiki"
],
"s2": [
"db1122:svwiki",
"db1129:svwiki",
"db1076:svwiki",
"db1074:svwiki"
],
"s3": [
"db1123:aswikibooks",
"db1166:aswikibooks",
"db1157:aswikibooks",
"db1175:aswikibooks",
"db1112:aswikibooks"
],
"s6": [
"db1131:ruwiki",
"db1168:ruwiki",
"db1085:ruwiki",
"db1173:ruwiki"
],
"s7": [
"db1086:cawiki",
"db1127:cawiki",
"db1136:cawiki",
"db1079:cawiki"
],
"s8": [
"db1104:wikidatawiki",
"db1172:wikidatawiki",
"db1109:wikidatawiki",
"db1114:wikidatawiki",
"db1126:wikidatawiki",
"db1111:wikidatawiki",
"db1087:wikidatawiki"
]
},
"image img_major_mime field-size-mismatch": {
"s1": [
"db1083:enwiki",
"db1084:enwiki",
"db1169:enwiki",
"db1118:enwiki",
"db1163:enwiki",
"db1106:enwiki",
"db1164:enwiki",
"db1119:enwiki",
"db1134:enwiki",
"db1135:enwiki"
],
"s2": [
"db1122:svwiki",
"db1129:svwiki",
"db1076:svwiki",
"db1074:svwiki"
],
"s3": [
"db1123:aswikibooks",
"db1166:aswikibooks",
"db1157:aswikibooks",
"db1175:aswikibooks",
"db1112:aswikibooks"
],
"s6": [
"db1131:ruwiki",
"db1168:ruwiki",
"db1085:ruwiki",
"db1173:ruwiki"
],
"s7": [
"db1086:cawiki",
"db1174:cawiki",
"db1127:cawiki",
"db1136:cawiki",
"db1079:cawiki"
],
"s8": [
"db1104:wikidatawiki",
"db1172:wikidatawiki",
"db1109:wikidatawiki",
"db1114:wikidatawiki",
"db1126:wikidatawiki",
"db1111:wikidatawiki",
"db1087:wikidatawiki"
]
},
"oldimage oi_major_mime field-size-mismatch": {
"s1": [
"db1083:enwiki",
"db1084:enwiki",
"db1169:enwiki",
"db1118:enwiki",
"db1163:enwiki",
"db1106:enwiki",
"db1164:enwiki",
"db1119:enwiki",
"db1134:enwiki",
"db1135:enwiki"
],
"s2": [
"db1122:svwiki",
"db1129:svwiki",
"db1076:svwiki",
"db1074:svwiki"
],
"s3": [
"db1123:aswikibooks",
"db1166:aswikibooks",
"db1157:aswikibooks",
"db1175:aswikibooks",
"db1112:aswikibooks"
],
"s6": [
"db1131:ruwiki",
"db1168:ruwiki",
"db1085:ruwiki",
"db1173:ruwiki"
],
"s7": [
"db1086:cawiki",
"db1174:cawiki",
"db1127:cawiki",
"db1136:cawiki",
"db1079:cawiki"
],
"s8": [
"db1104:wikidatawiki",
"db1172:wikidatawiki",
"db1109:wikidatawiki",
"db1114:wikidatawiki",
"db1126:wikidatawiki",
"db1087:wikidatawiki"
]
},
]
```
I assume wikis created after 2014 wouldn't have this drift. The project for this ({T18491}) is stalled so no rush in fixing this but I hope it gets picked up again. It's a cool project :(
The patches for it can be found in https://gerrit.wikimedia.org/r/c/mediawiki/core/+/135756/13/maintenance/archives/patch-img_major_mime-chemical.sql (and onwards) but I'm not 100% sure it would be work after all these years.
Also another reason why we should avoid using enums ({T119173})
ALTERs needed:
```
ALTER TABLE filearchive CHANGE fa_major_mime fa_major_mime ENUM('unknown','application','audio','image','text','video','message','model','multipart','chemical') default 'unknown';
ALTER TABLE image CHANGE img_major_mime img_major_mime ENUM('unknown','application','audio','image','text','video','message','model','multipart','chemical') default 'unknown';
ALTER TABLE oldimage CHANGE oi_major_mime oi_major_mime ENUM('unknown','application','audio','image','text','video','message','model','multipart','chemical') default 'unknown';
```
Needed on:
[x] s1
** [x] eqiad T277354#7568534
** [x] codfw
**** enwiki
[x] s2
** [x] eqiad T277354#7552093
** [x] codfw
**** all of them on s2.dblist
[x] s3
** [x] eqiad T277354#7566525
** [x] codfw
**** https://phabricator.wikimedia.org/P17887
[x] s5
** [x] eqiad T277354#7543202
** [x] codfw
**** cebwiki
**** dewiki
**** enwikivoyage
**** mgwiktionary
**** mhwiktionary
**** muswiki
**** shwiki
**** srwiki
[x] s6 T277354#7532985
** [x] eqiad
** [x] codfw
**** frwiki
**** jawiki
**** ruwiki
[x] s7
** [x] eqiad T277354#7562161
** [x] codfw
**** all of them on s7.dblist
[x] s8
** [x] eqiad T277354#7565498
** [x] codfw
**** wikidata