Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `twitter_statuses_new` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `status_twitter_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
- `twitter_id` bigint(20) DEFAULT NULL,
- `creator_twitter_identity_id` int(11) NOT NULL,
- `text` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
- `in_reply_to_status_id` bigint(20) DEFAULT NULL,
- `in_reply_to_user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
- `urls` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
- `hashtags` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
- `created_at` datetime DEFAULT NULL,
- `updated_at` datetime DEFAULT NULL,
- `sent_at` int(11) unsigned DEFAULT NULL,
- `user_mentions` varchar(2000) COLLATE utf8_unicode_ci DEFAULT NULL,
- PRIMARY KEY (`id`),
- UNIQUE KEY `status_twitter_id_index` (`status_twitter_id`),
- KEY `sent_index` (`sent_at`),
- KEY `creator_index` (`creator_twitter_identity_id`),
- KEY `twitter_id_index` (`twitter_id`),
- KEY `in_reply_to_status_id_index` (`in_reply_to_status_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement