· 9 years ago · Nov 13, 2016, 08:20 PM
1DROP TABLE IF EXISTS `botvk`;
2
3CREATE TABLE `botvk` (
4 `N` INT NOT NULL DEFAULT '0',
5 `id` INT NOT NULL AUTO_INCREMENT,
6 `first_name` VARCHAR(250) NOT NULL,
7 `last_name` VARCHAR(250) NOT NULL,
8 `screen_name` VARCHAR(250) NOT NULL,
9 `admin` INT NOT NULL DEFAULT '0',
10 `coins` INT NOT NULL DEFAULT '1000',
11 `reports` INT NOT NULL DEFAULT '0',
12 `games_count` INT NOT NULL DEFAULT '0',
13 `wins` INT NOT NULL DEFAULT '0',
14 `losses` INT NOT NULL DEFAULT '0',
15 `reports_throw` INT NOT NULL DEFAULT '0',
16 PRIMARY KEY (`id`)
17) ENGINE=InnoDB DEFAULT CHARSET=utf8;