CREATE TABLE revision (                                                                                            
  rev_id int(8) unsigned NOT NULL AUTO_INCREMENT,                                                                                
  rev_page int(8) unsigned NOT NULL DEFAULT '0',                                                                                 
  rev_text_id int(8) unsigned NOT NULL DEFAULT '0',                                                                              
  rev_comment varbinary(255) DEFAULT NULL,                                                                                       
  rev_user int(5) unsigned NOT NULL DEFAULT '0',                                                                                 
  rev_user_text varbinary(255) NOT NULL DEFAULT '',                                                                              
  rev_timestamp varbinary(14) NOT NULL DEFAULT '',                                                                               
  rev_minor_edit tinyint(1) unsigned NOT NULL DEFAULT '0',                                                                       
  rev_deleted tinyint(1) unsigned NOT NULL DEFAULT '0',                                                                          
  rev_len int(8) unsigned DEFAULT NULL,                                                                                          
  rev_parent_id int(8) unsigned DEFAULT NULL,                                                                                    
  rev_sha1 varbinary(32) NOT NULL DEFAULT '',                                                                                    
  rev_content_model varbinary(32) DEFAULT NULL,                                                                                  
  rev_content_format varbinary(64) DEFAULT NULL,                                                                                 
  PRIMARY KEY (rev_id,rev_user),                                                                                               
  KEY rev_timestamp (rev_timestamp),                                                                                           
  KEY page_timestamp (rev_page,rev_timestamp),                                                                               
  KEY user_timestamp (rev_user,rev_timestamp),                                                                               
  KEY usertext_timestamp (rev_user_text,rev_timestamp),                                                                      
  KEY page_user_timestamp (rev_page,rev_user,rev_timestamp)                                                                
) ENGINE=InnoDB AUTO_INCREMENT=625862501 DEFAULT CHARSET=binary;

ALTER TABLE enwiki.revision
  PARTITION BY RANGE (rev_user) (
  PARTITION p1 VALUES LESS THAN (1),
  PARTITION p100000 VALUES LESS THAN (100000),
  PARTITION p200000 VALUES LESS THAN (200000),
  PARTITION p300000 VALUES LESS THAN (300000),
  PARTITION p400000 VALUES LESS THAN (400000),
  PARTITION p500000 VALUES LESS THAN (500000),
  PARTITION p700000 VALUES LESS THAN (750000),
  PARTITION p1000000 VALUES LESS THAN (1000000),
  PARTITION p1200000 VALUES LESS THAN (1500000),
  PARTITION p2000000 VALUES LESS THAN (2000000),
  PARTITION p3000000 VALUES LESS THAN (3000000),
  PARTITION p4000000 VALUES LESS THAN (4000000),
  PARTITION p5000000 VALUES LESS THAN (5000000),
  PARTITION p6000000 VALUES LESS THAN (6000000),
  PARTITION p7000000 VALUES LESS THAN (7000000),
  PARTITION p8000000 VALUES LESS THAN (8000000),
  PARTITION p9000000 VALUES LESS THAN (9000000),
  PARTITION p10000000 VALUES LESS THAN (10000000),
  PARTITION p12000000 VALUES LESS THAN (12000000),
  PARTITION p14000000 VALUES LESS THAN (14000000),
  PARTITION p16000000 VALUES LESS THAN (16000000),
  PARTITION p18000000 VALUES LESS THAN (18000000),
  PARTITION pMAXVALUE VALUES LESS THAN MAXVALUE );