Script for creating the validate-table
[lhc/web/wiklou.git] / maintenance / archives / patch-validate.sql
1 -- For article validation
2
3 CREATE TABLE `validate` (
4 `val_user` int(11) NOT NULL default '0',
5 `val_title` varchar(255) binary NOT NULL default '',
6 `val_timestamp` varchar(14) binary NOT NULL default '',
7 `val_type` int(10) unsigned NOT NULL default '0',
8 `val_value` int(11) default '0',
9 KEY `val_user` (`val_user`,`val_title`,`val_timestamp`)
10 ) TYPE=MyISAM;
11