[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_user.user_status (
   2    `id` int unsigned NOT NULL AUTO_INCREMENT,
   3    `userPHID` varchar(64) NOT NULL,
   4    `dateFrom` int unsigned NOT NULL,
   5    `dateTo` int unsigned NOT NULL,
   6    `status` tinyint unsigned NOT NULL,
   7    `dateCreated` int unsigned NOT NULL,
   8    `dateModified` int unsigned NOT NULL,
   9    PRIMARY KEY (`id`),
  10    INDEX `userPHID_dateFrom` (`userPHID`, `dateTo`)
  11  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;