dépôts
/
lhc
/
web
/
wiklou.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge "(bug 37714) Use log type in target object when deleting logs of the same type"
[lhc/web/wiklou.git]
/
maintenance
/
archives
/
patch-watchlist.sql
diff --git
a/maintenance/archives/patch-watchlist.sql
b/maintenance/archives/patch-watchlist.sql
index
f491c53
..
83826b7
100644
(file)
--- a/
maintenance/archives/patch-watchlist.sql
+++ b/
maintenance/archives/patch-watchlist.sql
@@
-10,11
+10,11
@@
DROP TABLE IF EXISTS watchlist2;
CREATE TABLE watchlist2 (
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)
wl_title varchar(255) binary NOT NULL default '',
UNIQUE KEY (wl_user, wl_namespace, wl_title)
-)
ENGINE=MyISAM PACK_KEYS=1
;
+)
/*$wgDBTableOptions*/
;
INSERT INTO watchlist2 (wl_user,wl_namespace,wl_title)
SELECT DISTINCT wl_user,(cur_namespace | 1) - 1,cur_title
INSERT INTO watchlist2 (wl_user,wl_namespace,wl_title)
SELECT DISTINCT wl_user,(cur_namespace | 1) - 1,cur_title