blob: 6442b6b5656fb3573c006b841c0135e02df0b384 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
CREATE TABLE `tmw_accounts`
(
`ID` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`USERNAME` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`PASSWORD` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`EMAIL` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`STATE` TINYINT UNSIGNED NOT NULL DEFAULT '0',
`REGISTRATION` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
`GENDER` TINYINT UNSIGNED NOT NULL DEFAULT '0',
--
INDEX ( `STATE` ) ,
UNIQUE ( `USERNAME` )
) ENGINE = InnoDB;
|