dépôts
/
lhc
/
web
/
wiklou.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge "Adding interfaces for ORM row and table classes so these can be used for type...
[lhc/web/wiklou.git]
/
maintenance
/
archives
/
patch-validate.sql
diff --git
a/maintenance/archives/patch-validate.sql
b/maintenance/archives/patch-validate.sql
index
a404b3d
..
9701083
100644
(file)
--- a/
maintenance/archives/patch-validate.sql
+++ b/
maintenance/archives/patch-validate.sql
@@
-1,11
+1,13
@@
-- For article validation
-- For article validation
-CREATE TABLE `validate` (
+DROP TABLE IF EXISTS /*$wgDBprefix*/validate;
+CREATE TABLE /*$wgDBprefix*/validate (
`val_user` int(11) NOT NULL default '0',
`val_user` int(11) NOT NULL default '0',
- `val_
title` varchar(255) binary NOT NULL default '
',
- `val_
timestamp` varchar(14) binary NOT NULL default '
',
- `val_type` int(1
0
) unsigned 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(1
1
) unsigned NOT NULL default '0',
`val_value` int(11) default '0',
`val_value` int(11) default '0',
- KEY `val_user` (`val_user`,`val_title`,`val_timestamp`)
-) TYPE=MyISAM;
-
+ `val_comment` varchar(255) NOT NULL default '',
+ `val_ip` varchar(20) NOT NULL default '',
+ KEY `val_user` (`val_user`,`val_revision`)
+) /*$wgDBTableOptions*/;