**DBA Update**
The change is prepared at https://docs.google.com/document/d/1mw4CQxYyNP2PruzlG30dPVQjVOqJTC3Q_DLViIhWrm0/edit?usp=sharing
The alter to run is:
```ALTER TABLE user DROP COLUMN IF EXISTS user_options;
```
Where to run the alter: s1, s2, s3, s4, s5, s6, s7, s8
When to run: start at 2018-11-14
If the schema change is backwards compatible: compatible with the current code deployed
If the schema change has been tested already on some of the test/beta wikis.: wikis created since 2011-09-28 doesn't have this column
If it is involves new columns to tables: no, it's a drop
**Phases**
**Testing**
[x] db2046
[x] db1088
**Execution**
[x] s1
[x] s2
[] s3
[x] s4
[x] s5
[x] s6
[x] s7
[x] s8
**s6**
[x] db2039 **codfw master**, execute with replication!
[x] db1088
[x] db1093
[x] db1113
[x] db1098
[x] db1096
[x] dbstore1002
[x] dbstore1001
[x] db1085 **Sanitarium master**, execute with replication!
[x] db1061 **MASTER**
**s2**
[x] db2035 **codfw master**, execute with replication!
[x] db1076
[x] db1090
[x] db1095
[x] db1103
[x] db1105
[x] db1122
[x] dbstore1002
[x] db1074 **Sanitarium master** , execute with replication!
[x] db1066 **MASTER**
**s5**
[x] db2052 **codfw master**, execute with replication!
[x] db1096
[x] db1097
[x] db1100
[x] db1102
[x] db1110
[x] db1113
[x] dbstore1002
[x] db1082 **Sanitarium master** , execute with replication!
[x] db1070 **MASTER**
**s4**
[x] db2051 **codfw master**, execute with replication!
[x] db1081
[x] db1084
[x] db1091
[x] db1097
[x] db1102
[x] db1103
[x] dbstore1002
[x] db1121 **Sanitarium master** , execute with replication!
[x] db1068 **MASTER**
**s7**
[x] db2040 **codfw master**, execute with replication!
[x] db1086
[x] db1090
[x] db1094
[x] db1098
[x] db1101
[x] db1116
[x] dbstore1002
[x] db1079 **Sanitarium master** , execute with replication!
[x] db1062 **MASTER**
**s8**
[x] db2045 **codfw master**, execute with replication!
[x] db1092
[x] db1099
[x] db1101
[x] db1104
[x] db1109
[x] db1116
[x] db1087 **Sanitarium master** , execute with replication!
[x] db1071 **MASTER**
**s1**
[x] db2048 **codfw master**, execute with replication!
[x] db1080
[x] db1083
[x] db1089
[x] db1099
[x] db1105
[x] db1114
[x] db1119
[x] dbstore1002
[x] dbstore1001
[x] db1106 **Sanitarium master** , execute with replication!
[x] db1067 **MASTER**
**s3**
[x] db2043 **codfw master**, execute with replication!
[x] db1075
[x] db1095
[x] db1123
[x] dbstore1002
[x] db1077 **Sanitarium master** , execute with replication!
[] db1078 **MASTER**
----------
In CODFW (Secondary datacenter) the alter table command we need to use is:
```
./wmfmariadbpy/wmfmariadbpy/osc_host.py --method=ddl --host <section_codfw_master>.codfw.wmnet --dblist mediawiki-config/dblists/<section>.dblist --table user "DROP COLUMN IF EXISTS user_options"
```
On EQIAD (primary datacenter) the alter command will be (on all hots one by one, depooled except sanitarium master where we need replication):
```
./wmfmariadbpy/wmfmariadbpy/osc_host.py --no-repicate --method=ddl --host <hostname>.codfw.wmnet --dblist mediawiki-config/dblists/<section>.dblist --table user "DROP COLUMN IF EXISTS user_options"
```
On Sanitarium hosts we need to recreate the TRIGGERS as:
```
/home/banyek/T85757/fix_triggers.sh db2094:3315 s5
```
----------
**Original text**
The column user.user_options is visible on ToolLabs (at least on dewiki_p). I assume that the field also exists on wmf wikis.
It was dropped with http://git.wikimedia.org/commit/mediawiki%2Fcore.git/eda06e8593c12b4359a46cf3b428c1a1a88e40c4 and should be dropped in production as well.
If it already dropped from production wikis, please move this task to ToolLabs to get the field also dropped there. Thanks.