XHTML fixes for Special:Upload

[lhc/web/wiklou.git] / maintenance / tables.sql

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 4f256c7..b726f75 100644 (file)
--- a/maintenance/tables.sql
+++ b/maintenance/tables.sql
@@ -12,11 +12,11 @@ CREATE TABLE user (
   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 ''
@@ -160,7 +160,8 @@ CREATE TABLE image (
   img_description tinyblob NOT NULL default '',
   img_user int(5) unsigned NOT NULL default '0',
   img_user_text varchar(255) binary NOT NULL default '',
-  img_timestamp char(14) binary NOT NULL default ''
+  img_timestamp char(14) binary NOT NULL default '',
+  UNIQUE KEY img_name (img_name)
 ) PACK_KEYS=1;
 
 CREATE TABLE oldimage (
@@ -174,6 +175,7 @@ CREATE TABLE oldimage (
 ) 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',
@@ -189,7 +191,10 @@ CREATE TABLE recentchanges (
   rc_last_oldid 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_moved_to_title varchar(255) binary 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 (
@@ -242,3 +247,22 @@ CREATE TABLE objectcache (
   unique key (keyname),
   key (exptime)
 );
+
+-- For storing revision text
+CREATE TABLE blobs (
+  blob_index char(255) binary NOT NULL default '',
+  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;