API tools faq
paste
View difference between Paste ID: SJHu8gn0 and sEFLrCPQ
SHOW: | | - or go back to the newest paste.
1-
CREATE TABLE `strategic_twitter_statuses` (
1+
CREATE TABLE `d_twitter_statuses` (
2
  `id` int(11) NOT NULL AUTO_INCREMENT,
3
  `status_twitter_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
4
  `twitter_id` bigint(20) DEFAULT NULL,
5
  `creator_twitter_identity_id` int(11) NOT NULL,
6
  `text` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
7
  `in_reply_to_status_id` bigint(20) DEFAULT NULL,
8
  `in_reply_to_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
9
  `urls` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
10
  `hashtags` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
11
  `created_at` datetime DEFAULT NULL,
12
  `updated_at` datetime DEFAULT NULL,
13
  `sent_at` int(11) unsigned DEFAULT NULL,
14
  `user_mentions` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
15-
  PRIMARY KEY (`id`),
15+
  PRIMARY KEY (`id`,`sent_at`),
16-
  UNIQUE KEY `status_twitter_id_index` (`status_twitter_id`),
16+
  UNIQUE KEY `status_twitter_id_index` (`status_twitter_id`,`sent_at`),
17
  KEY `sent_index` (`sent_at`),
18
  KEY `creator_index` (`creator_twitter_identity_id`),
19
  KEY `twitter_id_index` (`twitter_id`),
20
  KEY `in_reply_to_status_id_index` (`in_reply_to_status_id`)
21-
) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_unicode_ci
21+
) ENGINE=InnoDB CHARSET=utf8 COLLATE=utf8_unicode_ci
22
PARTITION BY RANGE (`sent_at`) (
23
    PARTITION p122009 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-01-01 00:00:00') ),
24
    PARTITION p012010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-02-01 00:00:00') ),
25
    PARTITION p022010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-03-01 00:00:00') ),
26
    PARTITION p032010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-04-01 00:00:00') ),
27
    PARTITION p042010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-05-01 00:00:00') ),
28
    PARTITION p052010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-06-01 00:00:00') ),
29
    PARTITION p062010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-07-01 00:00:00') ),
30
    PARTITION p072010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-08-01 00:00:00') ),
31
    PARTITION p082010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-09-01 00:00:00') ),
32
    PARTITION p092010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-10-01 00:00:00') ),
33
    PARTITION p102010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-11-01 00:00:00') ),
34
    PARTITION p112010 VALUES LESS THAN ( UNIX_TIMESTAMP('2010-12-01 00:00:00') ),
35
    PARTITION p122010 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-01-01 00:00:00') ),
36
    PARTITION p012011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-02-01 00:00:00') ),
37
    PARTITION p022011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-03-01 00:00:00') ),
38
    PARTITION p032011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-04-01 00:00:00') ),
39
    PARTITION p042011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-05-01 00:00:00') ),
40
    PARTITION p052011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-06-01 00:00:00') ),
41
    PARTITION p062011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-07-01 00:00:00') ),
42
    PARTITION p072011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-08-01 00:00:00') ),
43
    PARTITION p082011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-09-01 00:00:00') ),
44
    PARTITION p092011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-10-01 00:00:00') ),
45
    PARTITION p102011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-11-01 00:00:00') ),
46
    PARTITION p112011 VALUES LESS THAN ( UNIX_TIMESTAMP('2011-12-01 00:00:00') ),
47
    PARTITION p122011 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-01-01 00:00:00') ),
48
    PARTITION p012012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-02-01 00:00:00') ),
49
    PARTITION p022012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-03-01 00:00:00') ),
50
    PARTITION p032012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-04-01 00:00:00') ),
51
    PARTITION p042012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-05-01 00:00:00') ),
52
    PARTITION p052012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-06-01 00:00:00') ),
53
    PARTITION p062012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-07-01 00:00:00') ),
54
    PARTITION p072012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-08-01 00:00:00') ),
55
    PARTITION p082012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-09-01 00:00:00') ),
56
    PARTITION p092012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-10-01 00:00:00') ),
57
    PARTITION p102012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-11-01 00:00:00') ),
58
    PARTITION p112012 VALUES LESS THAN ( UNIX_TIMESTAMP('2012-12-01 00:00:00') ),
59
    PARTITION p122012 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-01-01 00:00:00') ),
60
    PARTITION p012013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-02-01 00:00:00') ),
61
    PARTITION p022013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-03-01 00:00:00') ),
62
    PARTITION p032013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-04-01 00:00:00') ),
63
    PARTITION p042013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-05-01 00:00:00') ),
64
    PARTITION p052013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-06-01 00:00:00') ),
65
    PARTITION p062013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-07-01 00:00:00') ),
66
    PARTITION p072013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-08-01 00:00:00') ),
67
    PARTITION p082013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-09-01 00:00:00') ),
68
    PARTITION p092013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-10-01 00:00:00') ),
69
    PARTITION p102013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-11-01 00:00:00') ),
70
    PARTITION p112013 VALUES LESS THAN ( UNIX_TIMESTAMP('2013-12-01 00:00:00') )
71
);
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!