[[mysql|Назад]]
----

<code>
CREATE TABLE `accounts` (
  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Email` varchar(50) NOT NULL,
  `Password` binary(32) NOT NULL,
  `State` enum('New','Confirmed','Blocked') NOT NULL,
  `Role` enum('User','Moderator','Admin') NOT NULL,
  `RegisterToken` binary(20) DEFAULT NULL,
  `ResetToken` binary(20) DEFAULT NULL,
  `Expires` int(11) unsigned NOT NULL,
  `PartnerID` int(11) NOT NULL,
  `FirstActive` int(11) NOT NULL,
  `LastActive` int(11) NOT NULL,
  `APIToken` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `Email` (`Email`),
  UNIQUE KEY `RegisterToken` (`RegisterToken`),
  UNIQUE KEY `ResetToken` (`ResetToken`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
</code>