**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**
[] s1
[x] s2
[] s3
[x] s4
[x] s5
[x] s6
[] s7
[] 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!
[] db1062 **MASTER**
**s8**
[] db2045 **codfw master**, execute with replication!
[] db1092
[] db1099
[] db1101
[] db1104
[] db1109
[] db1116
[] db1087 **Sanitarium master** , execute with replication!
[] db1071 **MASTER**
**s1**
[] db2048 **codfw master**, execute with replication!
[] db1080
[] db1083
[] db1089
[] db1099
[] db1105
[] db1114
[] db1119
[] dbstore1002
[] dbstore1001
[] db1106 **Sanitarium master** , execute with replication!
[] db1066 **MASTER**
**s3**
[] db2043 **codfw master**, execute with replication!
[] db1078
[] db1095
[] db1123
[] dbstore1002
[] db1077 **Sanitarium master** , execute with replication!
[] db1075 **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.