· 8 years ago · Jan 15, 2018, 06:14 AM
1CREATE TABLE IF NOT EXISTS `RoshanTextile`.`r_accounts` (
2 `userId` SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT ,
3 `user` VARCHAR(255) NOT NULL ,
4 `password` CHAR(40) NOT NULL ,
5 `salt` CHAR(40) NOT NULL ,
6 INDEX `user` (`user` ASC) ,
7 PRIMARY KEY (`userId`) ,
8 UNIQUE INDEX `user_UNIQUE` (`user` ASC) )
9ENGINE = InnoDB
10DEFAULT CHARACTER SET = utf8
11COLLATE = utf8_unicode_ci