Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `twitter_relationships` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `user_id` int(11) NOT NULL,
- `source_twitter_id` bigint(20) NOT NULL,
- `target_twitter_id` bigint(20) NOT NULL,
- `relationship_status` tinyint(1) NOT NULL,
- `status_change_date` int(11) unsigned DEFAULT NULL,
- PRIMARY KEY (`id`,`user_id`),
- UNIQUE KEY `source_and_target` (`user_id`,`source_twitter_id`,`target_twitter_id`),
- KEY `target_status_and_change_date_index` (`user_id`,`target_twitter_id`,`relationship_status`,`status_change_date`),
- KEY `user_id_index` (`user_id`,`status_change_date`)
- ) ENGINE=InnoDB AUTO_INCREMENT=116597775 DEFAULT CHARSET=latin1
- /*!50100 PARTITION BY HASH (user_id)
- PARTITIONS 1000 */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement