Advertisement
ran5000

create d_messages

Mar 8th, 2012
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `d_messages` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `concrete_message_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  4.   `concrete_message_id` int(11) DEFAULT NULL,
  5.   `sent_at` int(11) unsigned DEFAULT NULL,
  6.   PRIMARY KEY (`id`,`sent_at`),
  7.   KEY `index_messages_on_concrete_message_id` (`concrete_message_id`),
  8.   KEY `sent_at_index` (`sent_at`)
  9. ) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_unicode_ci
  10. PARTITION BY RANGE (sent_at) (
  11.     PARTITION p122009 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-01-01 00:00:00') ),
  12.     PARTITION p012010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-02-01 00:00:00') ),
  13.     PARTITION p022010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-03-01 00:00:00') ),
  14.     PARTITION p032010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-04-01 00:00:00') ),
  15.     PARTITION p042010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-05-01 00:00:00') ),
  16.     PARTITION p052010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-06-01 00:00:00') ),
  17.     PARTITION p062010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-07-01 00:00:00') ),
  18.     PARTITION p072010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-08-01 00:00:00') ),
  19.     PARTITION p082010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-09-01 00:00:00') ),
  20.     PARTITION p092010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-10-01 00:00:00') ),
  21.     PARTITION p102010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-11-01 00:00:00') ),
  22.     PARTITION p112010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-12-01 00:00:00') ),
  23.     PARTITION p122010 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-01-01 00:00:00') ),
  24.     PARTITION p012011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-02-01 00:00:00') ),
  25.     PARTITION p022011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-03-01 00:00:00') ),
  26.     PARTITION p032011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-04-01 00:00:00') ),
  27.     PARTITION p042011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-05-01 00:00:00') ),
  28.     PARTITION p052011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-06-01 00:00:00') ),
  29.     PARTITION p062011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-07-01 00:00:00') ),
  30.     PARTITION p072011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-08-01 00:00:00') ),
  31.     PARTITION p082011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-09-01 00:00:00') ),
  32.     PARTITION p092011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-10-01 00:00:00') ),
  33.     PARTITION p102011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-11-01 00:00:00') ),
  34.     PARTITION p112011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-12-01 00:00:00') ),
  35.     PARTITION p122011 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-01-01 00:00:00') ),
  36.     PARTITION p012012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-02-01 00:00:00') ),
  37.     PARTITION p022012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-03-01 00:00:00') ),
  38.     PARTITION p032012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-04-01 00:00:00') ),
  39.     PARTITION p042012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-05-01 00:00:00') ),
  40.     PARTITION p052012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-06-01 00:00:00') ),
  41.     PARTITION p062012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-07-01 00:00:00') ),
  42.     PARTITION p072012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-08-01 00:00:00') ),
  43.     PARTITION p082012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-09-01 00:00:00') ),
  44.     PARTITION p092012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-10-01 00:00:00') ),
  45.     PARTITION p102012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-11-01 00:00:00') ),
  46.     PARTITION p112012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-12-01 00:00:00') ),
  47.     PARTITION p122012 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-01-01 00:00:00') ),
  48.     PARTITION p012013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-02-01 00:00:00') ),
  49.     PARTITION p022013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-03-01 00:00:00') ),
  50.     PARTITION p032013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-04-01 00:00:00') ),
  51.     PARTITION p042013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-05-01 00:00:00') ),
  52.     PARTITION p052013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-06-01 00:00:00') ),
  53.     PARTITION p062013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-07-01 00:00:00') ),
  54.     PARTITION p072013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-08-01 00:00:00') ),
  55.     PARTITION p082013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-09-01 00:00:00') ),
  56.     PARTITION p092013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-10-01 00:00:00') ),
  57.     PARTITION p102013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-11-01 00:00:00') ),
  58.     PARTITION p112013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-12-01 00:00:00') )
  59. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement