Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement