· 7 years ago · Oct 26, 2018, 08:32 PM
1CREATE TABLE IF NOT EXISTS `mydb`.`uzytkownicy` (
2 `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
3 `user_rang` ENUM('1', '2', '3', '4', '5', '6') NULL,
4 `premium` ENUM('Tak', 'Nie') NULL DEFAULT 'Nie',
5 `user` VARCHAR(20) CHARACTER SET 'utf8' COLLATE 'utf8_polish_ci' NOT NULL,
6 `pass` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_polish_ci' NOT NULL,
7 `email` VARCHAR(45) CHARACTER SET 'utf8' COLLATE 'utf8_polish_ci' NOT NULL,
8 `wzrost` DECIMAL(3,2) UNSIGNED NOT NULL,
9 `fundusze` DECIMAL(10,2) UNSIGNED NULL,
10 `pt` INT(4) UNSIGNED NOT NULL,
11 `forma` INT(3) UNSIGNED NOT NULL,
12 `zdrowie` INT(3) UNSIGNED NOT NULL,
13 `dnipremium` INT(4) UNSIGNED NOT NULL,
14 PRIMARY KEY (`id`),
15 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
16 UNIQUE INDEX `user_UNIQUE` (`user` ASC) VISIBLE)
17ENGINE = InnoDB
18DEFAULT CHARACTER SET = utf8
19COLLATE = utf8_polish_ci