MySQL demo_template.accounts Table

CREATE TABLE IF NOT EXISTS `accounts` (
    `AccountsID` int(11) NOT NULL AUTO_INCREMENT,
    `ActivationKey` varchar(32) DEFAULT NULL,
    `AccountStatus` char(10) NOT NULL,
    `Groups` varchar(255) NOT NULL,
    `OrganizationID` int(11) DEFAULT NULL,
    `Type` char(2) DEFAULT NULL,
    `FirstName` varchar(100) NOT NULL,
    `LastName` varchar(100) NOT NULL,
    `Email` varchar(100) NOT NULL,
    `Password` varchar(255) NOT NULL,
    `Salt` char(32) NOT NULL,
    `PasswordResetKey` varchar(24) DEFAULT NULL,
    `PasswordResetStamp` datetime DEFAULT NULL,
    `NotifyEmail` char(10) DEFAULT NULL,
    `LastVisit` datetime DEFAULT NULL,
    `AddStamp` datetime NOT NULL,
    PRIMARY KEY (`AccountsID`),
    UNIQUE KEY `Email` (`Email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;