k-karuna/server

Game Server for refactoring

Перед запуском тестов нужно выполнить в mysql:

CREATE USER 'checkers'@'localhost' IDENTIFIED BY 'QSQ9D9BUBW93DK8A7H9FPXOB5OLOP84BA4CJRWK96VN0GPVC6P';

GRANT ALL PRIVILEGES ON . TO 'checkers'@'localhost' WITH GRANT OPTION;

DROP SCHEMA IF EXISTS checkers ; CREATE SCHEMA IF NOT EXISTS checkers DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ; USE checkers ;

DROP TABLE IF EXISTS checkers.Users ;

CREATE TABLE IF NOT EXISTS checkers.Users ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT , nickname VARCHAR(20) NOT NULL , password CHAR(64) NOT NULL, last_visit TIMESTAMP NOT NULL, registration_date TIMESTAMP NOT NULL, rating SMALLINT NOT NULL DEFAULT 500, win_quantity INT UNSIGNED NOT NULL DEFAULT 0, lose_quantity INT UNSIGNED NOT NULL DEFAULT 0, PRIMARY KEY (id) , INDEX full_idx (nickname ASC, password ASC, id ASC, rating ASC, win_quantity ASC, lose_quantity ASC), UNIQUE INDEX nickname_UNIQUE (nickname ASC) ) ENGINE = InnoDB;

USE checkers ;