-- 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',
--
CREATE TABLE /*$wgDBprefix*/hitcounter (
hc_id int unsigned NOT NULL
-) TYPE=HEAP MAX_ROWS=25000;
+) ENGINE=HEAP MAX_ROWS=25000;
--
-- 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
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
FULLTEXT si_title (si_title),
FULLTEXT si_text (si_text)
-) TYPE=MyISAM;
+) ENGINE=MyISAM;
--
-- Recognized interwiki link prefixes
keyname varbinary(255) NOT NULL default '',
value mediumblob,
exptime datetime,
- UNIQUE KEY (keyname),
+ PRIMARY KEY (keyname),
KEY (exptime)
) /*$wgDBTableOptions*/;
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(1) 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