CREATE TABLE `ac_users` (
  `pkID` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(16) COLLATE utf8_bin NOT NULL,
  `pass_word` varchar(60) COLLATE utf8_bin DEFAULT NULL,
  `atype` varchar(40) COLLATE utf8_bin DEFAULT NULL,
  `fldLongField` text COLLATE utf8_bin,
  `fldCheckbox` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`pkID`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=10 ;