YovoAds

Это старая версия документа!

---

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 AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8; ''