summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-fix-il_from.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/archives/patch-fix-il_from.sql')
-rw-r--r--maintenance/archives/patch-fix-il_from.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/maintenance/archives/patch-fix-il_from.sql b/maintenance/archives/patch-fix-il_from.sql
new file mode 100644
index 00000000..0a199e4d
--- /dev/null
+++ b/maintenance/archives/patch-fix-il_from.sql
@@ -0,0 +1,11 @@
+-- Fix a bug from the 1.2 -> 1.3 upgrader by moving away the imagelinks table
+-- and recreating it.
+RENAME TABLE /*_*/imagelinks TO /*_*/imagelinks_old;
+CREATE TABLE /*_*/imagelinks (
+ il_from int unsigned NOT NULL default 0,
+ il_to varchar(255) binary NOT NULL default ''
+) /*$wgDBTableOptions*/;
+
+CREATE UNIQUE INDEX /*i*/il_from ON /*_*/imagelinks (il_from,il_to);
+CREATE UNIQUE INDEX /*i*/il_to ON /*_*/imagelinks (il_to,il_from);
+