Pasted

CREATE TABLE `twitter_identities` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `twitter_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `twitter_username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(4096) COLLATE utf8_unicode_ci DEFAULT NULL,
  `photo_url` varchar(1024) COLLATE utf8_unicode_ci DEFAULT NULL,
  `followers_count` int(11) DEFAULT NULL,
  `following_count` int(11) DEFAULT NULL,
  `listed_count` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `statuses_count` int(11) DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `verified` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
  `persona_id` int(11) DEFAULT NULL,
  `public_score` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `twitter_id_index` (`twitter_id`),
  KEY `updated_at_index` (`updated_at`),
  KEY `twitter_username_index` (`twitter_username`),
  KEY `followers_count_index` (`followers_count`),
  KEY `index_twitter_identities_on_persona_id` (`persona_id`),
  KEY `public_score_index` (`public_score`)
) ENGINE=InnoDB AUTO_INCREMENT=432218062 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci