Use null in wl_notificationtimestamp! The database provides this for a reason.

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

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index 6ce0173..4f9a26f 100644 (file)
--- 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)
@@ -736,6 +735,9 @@ CREATE TABLE /*$wgDBprefix*/interwiki (
   -- (used, for example, to detect redirect loops)
   iw_local BOOL NOT NULL,
   
+  -- Boolean value indicating whether interwiki transclusions are allowed.
+  iw_trans TINYINT(1) NOT NULL DEFAULT 0,
+  
   UNIQUE KEY iw_prefix (iw_prefix)
 
 ) TYPE=InnoDB;
@@ -772,14 +774,14 @@ CREATE TABLE /*$wgDBprefix*/objectcache (
 
 -- For article validation
 CREATE TABLE /*$wgDBprefix*/validate (
-  `val_user` int(11) NOT NULL default '0',
-  `val_page` int(11) unsigned NOT NULL default '0',
-  `val_revision` int(11) unsigned NOT NULL default '0',
-  `val_type` int(11) unsigned NOT NULL default '0',
-  `val_value` int(11) default '0',
-  `val_comment` varchar(255) NOT NULL default '',
-  `val_ip` varchar(20) NOT NULL default '',
-  KEY `val_user` (`val_user`,`val_revision`)
+  val_user int(11) NOT NULL default '0',
+  val_page int(11) unsigned NOT NULL default '0',
+  val_revision int(11) unsigned NOT NULL default '0',
+  val_type int(11) unsigned NOT NULL default '0',
+  val_value int(11) default '0',
+  val_comment varchar(255) NOT NULL default '',
+  val_ip varchar(20) NOT NULL default '',
+  KEY val_user (val_user,val_revision)
 ) TYPE=InnoDB;
 
 
@@ -826,3 +828,14 @@ CREATE TABLE /*$wgDBprefix*/logging (
 --  PRIMARY KEY  (gr_id)
 --
 --) TYPE=InnoDB;
+
+CREATE TABLE /*$wgDBprefix*/trackbacks (
+       tb_id           INTEGER AUTO_INCREMENT PRIMARY KEY,
+       tb_page         INTEGER REFERENCES page(page_id) ON DELETE CASCADE,
+       tb_title        VARCHAR(255) NOT NULL,
+       tb_url          VARCHAR(255) NOT NULL,
+       tb_ex           TEXT,
+       tb_name         VARCHAR(255),
+
+       INDEX (tb_page)
+);