Advertisement
ran5000

Untitled

Oct 19th, 2012
246
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `twitter_statuses_new` (
  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`),
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement