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)
-- 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)
-- (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;
-- 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;
-- 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)
+);