Split down patch-comment-table.sql
[lhc/web/wiklou.git] / maintenance / archives / patch-fix-il_from.sql
1 -- Fix a bug from the 1.2 -> 1.3 upgrader by moving away the imagelinks table
2 -- and recreating it.
3 RENAME TABLE /*_*/imagelinks TO /*_*/imagelinks_old;
4 CREATE TABLE /*_*/imagelinks (
5 il_from int unsigned NOT NULL default 0,
6 il_to varchar(255) binary NOT NULL default ''
7 ) /*$wgDBTableOptions*/;
8
9 CREATE UNIQUE INDEX /*i*/il_from ON /*_*/imagelinks (il_from,il_to);
10 CREATE UNIQUE INDEX /*i*/il_to ON /*_*/imagelinks (il_to,il_from);
11