ran5000

create table user_engagements

Jul 9th, 2012
297
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE `user_engagements` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `user_id` int(11) NOT NULL,
  4.   `member_id` int(11) NOT NULL,
  5.   `action_type` smallint(6) NOT NULL,
  6.   `created_at` datetime DEFAULT NULL,
  7.   `updated_at` datetime DEFAULT NULL,
  8.   PRIMARY KEY (`id`,`user_id`),
  9.   KEY `member_index` (`member_id`)
  10. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1
  11. /*!50100 PARTITION BY HASH (user_id)
  12. PARTITIONS 1000 */
RAW Paste Data