DROP TABLE IF EXISTS `rwikihistory`;
CREATE TABLE `rwikihistory` (   `id` varchar(36) NOT NULL,   `version` datetime default NULL,   `name` varchar(255) NOT NULL,   `realm` varchar(255) default NULL,   `referenced` text,   `userid` varchar(64) default NULL,   `owner` varchar(64) default NULL,   `ownerRead` tinyint(1) default NULL,   `ownerWrite` tinyint(1) default NULL,   `ownerAdmin` tinyint(1) default NULL,   `groupRead` tinyint(1) default NULL,   `groupWrite` tinyint(1) default NULL,   `groupAdmin` tinyint(1) default NULL,   `publicRead` tinyint(1) default NULL,   `publicWrite` tinyint(1) default NULL,   `sha1` varchar(64) default NULL,   `revision` int(11) default NULL,   `rwikiobjectid` varchar(36) NOT NULL,   PRIMARY KEY  (`id`),   KEY `name_idx` (`name`),   KEY `rwikiobjectid_idx` (`rwikiobjectid`),   KEY `irwikihistory_name` (`name`),   KEY `irwikihistory_realm` (`realm`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT IGNORE INTO `rwikihistory` SET `id` = SUBSTR('crud\'s',1,36), `version` = '20560128132326', `name` = SUBSTR('infinitesimally',1,255), `realm` = IF(RAND()*100<20,NULL,SUBSTR('Persia\'s',1,255)), `referenced` = IF(RAND()*100<20,NULL,SUBSTR('Nam mi dui, porta in, consequat vitae, varius at, quam. Nulla suscipit scelerisque ipsum. In hac habitasse platea dictumst. Pellentesque varius. Sed ac dui. Maecenas consequat luctus augue. Cras nec magna. Proin felis augue, pellentesque at, vulputate lobortis, commodo molestie, massa. Morbi erat eros, rhoncus vitae, aliquam vitae, varius vitae, eros. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Aliquam accumsan nulla et ante. Mauris cursus. In dapibus turpis. Morbi est ante, lobortis sed, tincidunt eu, dignissim at, felis. Ut sit amet massa ut tellus convallis mattis. Suspendisse sit amet tortor. Donec eu libero id tortor posuere nonummy. Mauris lacus. Cras hendrerit est non nisl. Pellentesque interdum urna sed est.',1,65535)), `userid` = IF(RAND()*100<20,NULL,SUBSTR('Schott',1,64)), `owner` = IF(RAND()*100<20,NULL,SUBSTR('insurrectionist\'s',1,64)), `ownerRead` = '-96', `ownerWrite` = '88', `ownerAdmin` = '40', `groupRead` = '-110', `groupWrite` = '-56', `groupAdmin` = '-121', `publicRead` = '7', `publicWrite` = '-29', `sha1` = IF(RAND()*100<20,NULL,SUBSTR('bearishness',1,64)), `revision` = IF(RAND()*100<20,NULL,-1381389), `rwikiobjectid` = SUBSTR('precalculation',1,36);
alter table rwikihistory add index irwikihistory_ref (referenced(1024));