CREATE TABLE `sb_admins` (
`aid` INT(6) NOT NULL AUTO_INCREMENT,
`user` VARCHAR(64) NOT NULL,
`authid` VARCHAR(64) NOT NULL DEFAULT '',
`password` VARCHAR(128) NOT NULL,
`gid` INT(6) NOT NULL,
`email` VARCHAR(128) NULL DEFAULT NULL,
`validate` VARCHAR(128) NULL DEFAULT NULL,
`extraflags` INT(10) NOT NULL,
`immunity` INT(10) NOT NULL DEFAULT '0',
`srv_group` VARCHAR(128) NULL DEFAULT NULL,
`srv_flags` VARCHAR(64) NULL DEFAULT NULL,
`srv_password` VARCHAR(128) NULL DEFAULT NULL,
`lastvisit` INT(11) NULL DEFAULT NULL,
`lastdate` DATETIME NULL DEFAULT NULL,
PRIMARY KEY (`aid`),
UNIQUE INDEX `user` (`user`),
UNIQUE INDEX `authid` (`authid`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=50
;