@Ladsgroup recently run a script to find the differences between production and code (T104459#6048024) and looks like `img_deleted` exists on most wikis and most replicas:
```
"image img_deleted field-mismatch-prod-extra": {
"s1": [
"db1083.eqiad.wmnet",
"db1106.eqiad.wmnet",
"db1080.eqiad.wmnet",
"db1089.eqiad.wmnet",
"db1119.eqiad.wmnet",
"db1118.eqiad.wmnet",
"db1107.eqiad.wmnet",
"db1099.eqiad.wmnet",
"db1134.eqiad.wmnet",
"db1105.eqiad.wmnet"
],
"s10": [
"db1133.eqiad.wmnet"
],
"s2": [
"db1122.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1076.eqiad.wmnet",
"db1129.eqiad.wmnet",
"db1074.eqiad.wmnet",
"db1105.eqiad.wmnet"
],
"s3": [
"db1123.eqiad.wmnet",
"db1075.eqiad.wmnet",
"db1112.eqiad.wmnet",
"db1078.eqiad.wmnet"
],
"s4": [
"db1138.eqiad.wmnet",
"db1091.eqiad.wmnet",
"db1121.eqiad.wmnet",
"db1103.eqiad.wmnet",
"db1081.eqiad.wmnet",
"db1084.eqiad.wmnet",
"db1097.eqiad.wmnet"
],
"s5": [
"db1100.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1130.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1110.eqiad.wmnet",
"db1097.eqiad.wmnet",
"db1082.eqiad.wmnet"
],
"s6": [
"db1131.eqiad.wmnet",
"db1088.eqiad.wmnet",
"db1085.eqiad.wmnet",
"db1093.eqiad.wmnet",
"db1096.eqiad.wmnet",
"db1113.eqiad.wmnet",
"db1098.eqiad.wmnet"
],
"s7": [
"db1086.eqiad.wmnet",
"db1079.eqiad.wmnet",
"db1098.eqiad.wmnet",
"db1136.eqiad.wmnet",
"db1090.eqiad.wmnet",
"db1101.eqiad.wmnet",
"db1094.eqiad.wmnet"
],
"s8": [
"db1109.eqiad.wmnet",
"db1101.eqiad.wmnet",
"db1126.eqiad.wmnet",
"db1111.eqiad.wmnet",
"db1099.eqiad.wmnet",
"db1087.eqiad.wmnet",
"db1092.eqiad.wmnet",
"db1104.eqiad.wmnet"
]
```
Full results: https://phabricator.wikimedia.org/P10956
I have done some checks on enwiki and wikidatawiki and there are no rows with `img_deleted =! 0`:
```
root@db1087.eqiad.wmnet[wikidatawiki]> select * from image where img_deleted != 0;
Empty set (0.00 sec)
root@db1089.eqiad.wmnet[enwiki]> select * from image where img_deleted != 0;
Empty set (1.53 sec)
```
There are no references on code to this column: https://codesearch.wmflabs.org/search/?q=img_deleted&i=nope&files=&repos=
It needs to be dropped in production
```
alter table image drop column if exists img_deleted;
```
[] s1
** [] codfw
** [] eqiad
*** db1089 already done
[] s2
** [x] codfw
** [] eqiad
[] s3
** [] codfw
** [] eqiad
[] s4
** [] codfw
** [] eqiad
*** db1081 already done
[] s5
** [] codfw
** [] eqiad
[] s6
** [] codfw
** [] eqiad
[] s7
** [] codfw
** [] eqiad
[x] s8
** [x] codfw
** [x] eqiad T250055#6071528
[] wikitech
[x] labtestwiki - `img_deleted` isn't there.