Decouple revision.rev_id from text.old_id
[lhc/web/wiklou.git] / maintenance / archives / patch-validate.sql
1 -- For article validation
2
3 DROP TABLE IF EXISTS `validate`;
4 CREATE TABLE `validate` (
5 `val_user` int(11) NOT NULL default '0',
6 `val_page` int(11) unsigned NOT NULL default '0',
7 `val_revision` int(11) unsigned NOT NULL default '0',
8 `val_type` int(11) unsigned NOT NULL default '0',
9 `val_value` int(11) default '0',
10 `val_comment` varchar(255) NOT NULL default '',
11 KEY `val_user` (`val_user`,`val_revision`)
12 ) TYPE=MyISAM;