Add patch to migrate rc_ip field to varbinary(40)
authorPaladox <thomasmulhall410@yahoo.com>
Wed, 12 Oct 2016 15:22:20 +0000 (16:22 +0100)
committerReedy <reedy@wikimedia.org>
Wed, 12 Oct 2016 22:15:13 +0000 (22:15 +0000)
This makes it match tables.sql, as it was modified previously but no
related database patch was made.

Bug: T117854
Change-Id: I239e7ee4d97fcc3cb96c98dc53d9371883aaf4fb

includes/installer/MysqlUpdater.php
maintenance/archives/patch-rc_ip_modify.sql [new file with mode: 0644]

index 497f273..a637ce0 100644 (file)
@@ -290,6 +290,7 @@ class MysqlUpdater extends DatabaseUpdater {
                        [ 'doNonUniquePlTlIl' ],
                        [ 'addField', 'change_tag', 'ct_id', 'patch-change_tag-ct_id.sql' ],
                        [ 'addField', 'tag_summary', 'ts_id', 'patch-tag_summary-ts_id.sql' ],
+                       [ 'modifyField', 'recentchanges', 'rc_ip', 'patch-rc_ip_modify.sql' ],
                ];
        }
 
diff --git a/maintenance/archives/patch-rc_ip_modify.sql b/maintenance/archives/patch-rc_ip_modify.sql
new file mode 100644 (file)
index 0000000..e889b5c
--- /dev/null
@@ -0,0 +1 @@
+ALTER TABLE /*_*/recentchanges MODIFY COLUMN rc_ip varbinary(40) NOT NULL default '';