SHARE
TWEET

create table twitter relationships

ran5000 Sep 27th, 2012 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `twitter_relationships` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `user_id` int(11) NOT NULL,
  4.   `source_twitter_id` bigint(20) NOT NULL,
  5.   `target_twitter_id` bigint(20) NOT NULL,
  6.   `relationship_status` tinyint(1) NOT NULL,
  7.   `status_change_date` int(11) unsigned DEFAULT NULL,
  8.   PRIMARY KEY (`id`,`user_id`),
  9.   UNIQUE KEY `source_and_target` (`user_id`,`source_twitter_id`,`target_twitter_id`),
  10.   KEY `target_status_and_change_date_index` (`user_id`,`target_twitter_id`,`relationship_status`,`status_change_date`),
  11.   KEY `user_id_index` (`user_id`,`status_change_date`)
  12. ) ENGINE=InnoDB AUTO_INCREMENT=116597775 DEFAULT CHARSET=latin1
  13. /*!50100 PARTITION BY HASH (user_id)
  14. PARTITIONS 1000 */
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top