Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `s_relations_new` (
- `id` int(11) NOT NULL AUTO_INCREMENT,
- `source_persona_id` int(11) NOT NULL,
- `relation_type` int(11) NOT NULL,
- `message_id` int(11) DEFAULT NULL,
- `reply_to_message_id` int(11) DEFAULT NULL,
- `reshare_of_message_id` int(11) DEFAULT NULL,
- `target_object_id` int(11) DEFAULT NULL,
- `target_persona_id` int(11) DEFAULT NULL,
- `created_at` datetime DEFAULT NULL,
- `updated_at` datetime DEFAULT NULL,
- `sent_at` int(11) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`,`sent_at`),
- UNIQUE KEY `unique_target_persona` (`source_persona_id`,`relation_type`,`message_id`,`target_persona_id`,`sent_at`),
- UNIQUE KEY `unique_target_object` (`source_persona_id`,`relation_type`,`message_id`,`target_object_id`,`sent_at`),
- KEY `reshare_of_message_id_index` (`reshare_of_message_id`),
- KEY `reply_to_message_id_index` (`reply_to_message_id`),
- KEY `source_and_target_object_index` (`source_persona_id`,`target_object_id`),
- KEY `source_target_persona_index` (`source_persona_id`,`target_persona_id`),
- KEY `target_persona_relation_type_message_id_index` (`target_persona_id`,`relation_type`,`message_id`),
- KEY `sent_at_index` (`sent_at`),
- KEY `source_persona_sent_at_index` (`source_persona_id`,`sent_at`),
- KEY `target_persona_sent_at_index` (`target_persona_id`,`sent_at`),
- KEY `target_object_sent_at_index` (`target_object_id`,`sent_at`)
- ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
- /*!50100 PARTITION BY RANGE (sent_at)
- (PARTITION p082011 VALUES LESS THAN (1314835200) ENGINE = InnoDB,
- PARTITION p092011 VALUES LESS THAN (1317427200) ENGINE = InnoDB,
- PARTITION p102011 VALUES LESS THAN (1320105600) ENGINE = InnoDB,
- PARTITION p112011 VALUES LESS THAN (1322697600) ENGINE = InnoDB,
- PARTITION p122011 VALUES LESS THAN (1325376000) ENGINE = InnoDB,
- PARTITION p012012 VALUES LESS THAN (1328054400) ENGINE = InnoDB,
- PARTITION p022012 VALUES LESS THAN (1330560000) ENGINE = InnoDB,
- PARTITION p032012 VALUES LESS THAN (1333238400) ENGINE = InnoDB,
- PARTITION p042012 VALUES LESS THAN (1335830400) ENGINE = InnoDB,
- PARTITION p052012 VALUES LESS THAN (1338508800) ENGINE = InnoDB,
- PARTITION p072012 VALUES LESS THAN (1343779200) ENGINE = InnoDB,
- PARTITION p082012 VALUES LESS THAN (1346457600) ENGINE = InnoDB,
- PARTITION p092012 VALUES LESS THAN (1349049600) ENGINE = InnoDB,
- PARTITION p102012 VALUES LESS THAN (1351728000) ENGINE = InnoDB,
- PARTITION p112012 VALUES LESS THAN (1354320000) ENGINE = InnoDB,
- PARTITION p122012 VALUES LESS THAN (1356998400) ENGINE = InnoDB,
- PARTITION p012013 VALUES LESS THAN (1359676800) ENGINE = InnoDB,
- PARTITION p022013 VALUES LESS THAN (1362096000) ENGINE = InnoDB,
- PARTITION p032013 VALUES LESS THAN (1364774400) ENGINE = InnoDB,
- PARTITION p042013 VALUES LESS THAN (1367366400) ENGINE = InnoDB,
- PARTITION p052013 VALUES LESS THAN (1370044800) ENGINE = InnoDB,
- PARTITION p062013 VALUES LESS THAN (1372636800) ENGINE = InnoDB,
- PARTITION p072013 VALUES LESS THAN (1375315200) ENGINE = InnoDB,
- PARTITION p082013 VALUES LESS THAN (1377993600) ENGINE = InnoDB,
- PARTITION p092013 VALUES LESS THAN (1380585600) ENGINE = InnoDB,
- PARTITION p102013 VALUES LESS THAN (1383264000) ENGINE = InnoDB,
- PARTITION p112013 VALUES LESS THAN (1385856000) ENGINE = InnoDB,
- PARTITION p062012 VALUES LESS THAN (1395856000) ENGINE = InnoDB) */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement