· 8 years ago · Mar 15, 2018, 05:48 PM
1DROP TABLE IF EXISTS `user_history`;
2CREATE TABLE `user_history` (
3 `historyid` int(10) unsigned NOT NULL auto_increment,
4 `userid` int(10) unsigned NOT NULL,
5 `delta` int(11) NOT NULL,
6 `rewarded` int(11) NOT NULL,
7 `date` int(11) NOT NULL,
8 `doctype` enum('wiki_revisions','guide_translation_revisions','guide_step_revisions','user_success','comments','posts','user_badges','user_votes','users') default NULL,
9 `docid` int(10) unsigned default NULL,
10 `event` varchar(255) default 'default',
11 PRIMARY KEY (`historyid`),
12 KEY `user_history_fk1` (`userid`),
13 KEY `docid` (`docid`),
14 KEY `doctype` (`doctype`),
15 KEY `event` (`event`),
16 CONSTRAINT `user_history_fk1` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE ON UPDATE CASCADE
17) ENGINE=InnoDB AUTO_INCREMENT=9325 DEFAULT CHARSET=utf8