SHOW:
|
|
- or go back to the newest paste.
| 1 | - | CREATE TABLE `messages_new` ( |
| 1 | + | CREATE TABLE `twitter_statuses_new` ( |
| 2 | `id` int(11) NOT NULL AUTO_INCREMENT, | |
| 3 | - | `concrete_message_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, |
| 3 | + | `status_twitter_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL, |
| 4 | - | `concrete_message_id` int(11) DEFAULT 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 | - | KEY `index_messages_on_concrete_message_id` (`concrete_message_id`), |
| 7 | + | `in_reply_to_status_id` bigint(20) DEFAULT NULL, |
| 8 | - | KEY `sent_at_index` (`sent_at`) |
| 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`), | |
| 16 | UNIQUE KEY `status_twitter_id_index` (`status_twitter_id`), | |
| 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 AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci |
