Pasted

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) */