user_password tinyblob NOT NULL default '',
user_newpassword tinyblob NOT NULL default '',
user_email tinytext NOT NULL default '',
- user_options blob NOT NULL default '',
+ user_options blob NOT NULL default '',
user_touched char(14) binary NOT NULL default '',
UNIQUE KEY user_id (user_id)
) PACK_KEYS=1;
-
+
CREATE TABLE user_newtalk (
user_id int(5) NOT NULL default '0',
user_ip varchar(40) NOT NULL default ''
) PACK_KEYS=1;
CREATE TABLE recentchanges (
+ rc_id int(8) NOT NULL auto_increment,
rc_timestamp varchar(14) binary NOT NULL default '',
rc_cur_time varchar(14) binary NOT NULL default '',
rc_user int(10) unsigned NOT NULL default '0',
rc_type tinyint(3) unsigned NOT NULL default '0',
rc_moved_to_ns tinyint(3) unsigned NOT NULL default '0',
rc_moved_to_title varchar(255) binary NOT NULL default '',
- rc_ip char(15) NOT NULL default ''
+ rc_patrolled tinyint(3) unsigned NOT NULL default '0',
+ rc_ip char(15) NOT NULL default '',
+ PRIMARY KEY rc_id (rc_id)
) PACK_KEYS=1;
CREATE TABLE watchlist (
blob_data longblob NOT NULL default '',
UNIQUE key blob_index (blob_index)
);
+
+-- For article validation
+
+CREATE TABLE `validate` (
+ `val_user` int(11) NOT NULL default '0',
+ `val_title` varchar(255) binary NOT NULL default '',
+ `val_timestamp` varchar(14) binary NOT NULL default '',
+ `val_type` int(10) unsigned NOT NULL default '0',
+ `val_value` int(11) default '0',
+ `val_comment` varchar(255) NOT NULL default '',
+ KEY `val_user` (`val_user`,`val_title`,`val_timestamp`)
+) TYPE=MyISAM;