X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-watchlist.sql;h=83826b72ef256efec91d030486438069666b2085;hb=83783cd93399fd7526aacf629e448ad3fa80e23c;hp=adee010b67205e12371baab1d675361174dedea3;hpb=d82c14fb4fbac288b42ca5918b0a72f33ecb1e69;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/archives/patch-watchlist.sql b/maintenance/archives/patch-watchlist.sql index adee010b67..83826b72ef 100644 --- a/maintenance/archives/patch-watchlist.sql +++ b/maintenance/archives/patch-watchlist.sql @@ -10,11 +10,11 @@ DROP TABLE IF EXISTS watchlist2; CREATE TABLE watchlist2 ( - wl_user int(5) unsigned NOT NULL, - wl_namespace tinyint(2) unsigned NOT NULL default '0', + wl_user int unsigned NOT NULL, + wl_namespace int unsigned NOT NULL default '0', wl_title varchar(255) binary NOT NULL default '', UNIQUE KEY (wl_user, wl_namespace, wl_title) -) TYPE=MyISAM PACK_KEYS=1; +) /*$wgDBTableOptions*/; INSERT INTO watchlist2 (wl_user,wl_namespace,wl_title) SELECT DISTINCT wl_user,(cur_namespace | 1) - 1,cur_title