X-Git-Url: http://git.cyclocoop.org/?a=blobdiff_plain;f=maintenance%2Ftables.sql;h=4f9a26f5b3f7fb01da258686bb033eb83b60088c;hb=48d5b739e940857c7a2c95f113ecc2e9c60a78b9;hp=fc1753313a91bbd612ccb7f0ac72e8be9d17cb77;hpb=bc36d810e796739c2bc5e8fec70a5c5bf530b21e;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/tables.sql b/maintenance/tables.sql
index fc1753313a..4f9a26f5b3 100644
--- 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)
@@ -831,12 +830,12 @@ CREATE TABLE /*$wgDBprefix*/logging (
 --) TYPE=InnoDB;
 
 CREATE TABLE /*$wgDBprefix*/trackbacks (
-        tb_id           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_id)
+	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)
 );
-