ran5000 icon

Untitled

ran5000 | PRO | 10/19/12 12:27:19 PM UTC | 0 ⭐ | 520 👁️ | Never ⏰ | []
MySQL |

1.08 KB

|

None

|

0 👍

/

0 👎

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

Comments