keii.dev
1CREATE TABLE
2 IF NOT EXISTS `migrations` (
3 `id` INT PRIMARY KEY AUTO_INCREMENT,
4 `name` VARCHAR(16) NOT NULL
5 );
6
7INSERT INTO
8 `migrations` (`name`)
9VALUES
10 ("0001_init");
11
12CREATE TABLE
13 IF NOT EXISTS `users` (
14 `id` INT PRIMARY KEY AUTO_INCREMENT,
15 `username` VARCHAR(32) NOT NULL UNIQUE,
16 `email` VARCHAR(128) NOT NULL UNIQUE,
17 `updated_at` TIMESTAMP,
18 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
19 );
20
21CREATE TABLE
22 IF NOT EXISTS `servers` (
23 `id` INT PRIMARY KEY AUTO_INCREMENT,
24 `name` VARCHAR(64) NOT NULL UNIQUE,
25 `secret` VARCHAR(64) NOT NULL,
26 `server_address` VARCHAR(64) NOT NULL,
27 `user_id` INT NOT NULL,
28 `updated_at` TIMESTAMP,
29 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
30 );
31
32CREATE TABLE
33 IF NOT EXISTS `statistics` (
34 `id` INT PRIMARY KEY AUTO_INCREMENT,
35 `player_count` INT NOT NULL,
36 `game_version` VARCHAR(16) NOT NULL,
37 `server_environment` VARCHAR(32) NOT NULL,
38 `operating_system` VARCHAR(32) NOT NULL,
39 `arch` VARCHAR(32) NOT NULL,
40 `java_version` VARCHAR(16) NOT NULL,
41 `server_id` INT,
42 `updated_at` TIMESTAMP,
43 `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
44 );