SHOW:
|
|
- or go back to the newest paste.
| 1 | - | CREATE TABLE `strategic_messages` ( |
| 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`), |
| 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 |
| 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 | ); |
