X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=maintenance%2Ftables.sql;h=4f9a26f5b3f7fb01da258686bb033eb83b60088c;hb=48d5b739e940857c7a2c95f113ecc2e9c60a78b9;hp=e19f6e11710298ea61d7fcfebd48f900e95e4b95;hpb=7b810c22efaa1d46d70b43a45ef5ed01d2e49778;p=lhc%2Fweb%2Fwiklou.git diff --git a/maintenance/tables.sql b/maintenance/tables.sql index e19f6e1171..4f9a26f5b3 100644 --- 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_total_pages bigint(20) default -1, + ss_total_pages bigint(20) default '-1', -- 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 - ss_admins int(10) default -1, + ss_admins int(10) default '-1', 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. - -- 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)