X-Git-Url: http://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Ftables.sql;h=d4a60af865d4957b18809a666a64b2197c46dabd;hb=8b8dae7f5352927b617407d57c5fa952b2199453;hp=08889b2031097b55ff87940a69dd80836d4b3252;hpb=19b85e4191285422b7547bdaf8ca5d79c4cc4621;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 08889b2031..d4a60af865 100644
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -596,6 +596,9 @@ CREATE TABLE /*$wgDBprefix*/site_stats (
 
   -- Number of users, theoretically equal to SELECT COUNT(*) FROM user;
   ss_users bigint default '-1',
+  
+  -- Number of users that still edit
+  ss_active_users bigint default '-1',
 
   -- Deprecated, no longer updated as of 1.5
   ss_admins int default '-1',
@@ -675,6 +678,9 @@ CREATE TABLE /*$wgDBprefix*/ipblocks (
   -- Block prevents user from accessing Special:Emailuser
   ipb_block_email bool NOT NULL default 0,
   
+  -- Block allows user to edit their own talk page
+  ipb_allow_usertalk bool NOT NULL default 0,
+  
   PRIMARY KEY ipb_id (ipb_id),
 
   -- Unique index to support "user already blocked" messages
@@ -904,7 +910,7 @@ CREATE TABLE /*$wgDBprefix*/recentchanges (
   rc_old_len int,
   rc_new_len int,
 
-  -- Visibility of deleted revisions, bitfield
+  -- Visibility of recent changes items, bitfield
   rc_deleted tinyint unsigned NOT NULL default '0',
 
   -- Value corresonding to log_id, specific log entries
@@ -1044,7 +1050,7 @@ CREATE TABLE /*$wgDBprefix*/objectcache (
   keyname varbinary(255) NOT NULL default '',
   value mediumblob,
   exptime datetime,
-  UNIQUE KEY (keyname),
+  PRIMARY KEY (keyname),
   KEY (exptime)
 
 ) /*$wgDBTableOptions*/;
@@ -1237,28 +1243,4 @@ CREATE TABLE /*$wgDBprefix*/updatelog (
   PRIMARY KEY (ul_key)
 ) /*$wgDBTableOptions*/;
 
--- A table to track link changes
--- Experimental: enable using $wgTrackLinkChanges
-CREATE TABLE /*$wgDBprefix*/recentlinkchanges (
-  rlc_id int unsigned NOT NULL auto_increment,
-
-  -- page, image, category, ...
-  rlc_type varchar(15) binary NOT NULL,
-  rlc_timestamp binary(14) NOT NULL default '',
-  -- 1: insert; 2: deletion;
-  -- should probably make this an enum...
-  rlc_action tinyint NOT NULL default 0,
-
-  -- page where the links are on
-  rlc_from int NOT NULL,
-
-  rlc_to_namespace int,
-  rlc_to_title varchar(255) binary,
-  rlc_to_blob blob,
-
-  PRIMARY KEY (rlc_id),
-  KEY from_timestamp (rlc_type, rlc_timestamp),
-  KEY to_timestamp (rlc_to_namespace, rlc_to_title, rlc_timestamp)
-) /*$wgDBTableOptions*/;
-
 -- vim: sw=2 sts=2 et