DROP TABLE IF EXISTS `tmpusers`;

CREATE TABLE `tmpusers` (
  `tuid` int(6) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT COMMENT 'Temporary UID',
  `sex` bit(1) COMMENT 'user sex',
  `age` bit(1) COMMENT 'user age',
  `channel` varchar(30) COMMENT 'channel ID',
  `points` tinyint(2) UNSIGNED NOT NULL DEFAULT '60' COMMENT 'User Points',
  PRIMARY KEY(`tuid`),
  INDEX `tids`(`tuid`, `channel`),
  INDEX `search`(`sex`, `age`)
)
ENGINE=INNODB
MAX_ROWS = 99
COMMENT = 'Temporary users data'
CHARACTER SET latin1 ;
ALTER TABLE tmpusers AUTO_INCREMENT = 900001;