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
Quick hacky script to initialize site_stats row where missing.
[lhc/web/wiklou.git]
/
maintenance
/
tables.sql
diff --git
a/maintenance/tables.sql
b/maintenance/tables.sql
index
e19f6e1
..
4f9a26f
100644
(file)
--- a/
maintenance/tables.sql
+++ b/
maintenance/tables.sql
@@
-439,13
+439,13
@@
CREATE TABLE /*$wgDBprefix*/site_stats (
ss_good_articles bigint(20) unsigned default '0',
-- Total pages, theoretically equal to SELECT COUNT(*) FROM page; except faster
ss_good_articles bigint(20) unsigned default '0',
-- Total pages, theoretically equal to SELECT COUNT(*) FROM page; except faster
- ss_total_pages bigint(20) default
-1
,
+ ss_total_pages bigint(20) default
'-1'
,
-- Number of users, theoretically equal to SELECT COUNT(*) FROM user;
-- Number of users, theoretically equal to SELECT COUNT(*) FROM user;
- ss_users bigint(20) default
-1
,
+ ss_users bigint(20) default
'-1'
,
-- Deprecated, no longer updated as of 1.5
-- Deprecated, no longer updated as of 1.5
- ss_admins int(10) default
-1
,
+ ss_admins int(10) default
'-1'
,
UNIQUE KEY ss_row_id (ss_row_id)
UNIQUE KEY ss_row_id (ss_row_id)
@@
-662,8
+662,7
@@
CREATE TABLE /*$wgDBprefix*/watchlist (
-- Timestamp when user was last sent a notification e-mail;
-- cleared when the user visits the page.
-- Timestamp when user was last sent a notification e-mail;
-- cleared when the user visits the page.
- -- FIXME: add proper null support etc
- wl_notificationtimestamp varchar(14) binary NOT NULL default '0',
+ wl_notificationtimestamp varchar(14) binary,
UNIQUE KEY (wl_user, wl_namespace, wl_title),
KEY namespace_title (wl_namespace,wl_title)
UNIQUE KEY (wl_user, wl_namespace, wl_title),
KEY namespace_title (wl_namespace,wl_title)