v2wic65P

1CREATE DATABASE IF NOT EXISTS Nolydia DEFAULT CHARACTER SET utf8;
2
3DROP TABLE IF EXISTS games;
4CREATE TABLE games
5(
6    id   SMALLINT AUTO_INCREMENT,
7    name VARCHAR(255),
8    PRIMARY KEY (id)
9);
10
11INSERT INTO games(name)
12VALUES ('Bedwars'),
13       ('Skywars')
14;
15
16DROP TABLE IF EXISTS `groups`;
17CREATE TABLE `groups`
18(
19    id        SMALLINT AUTO_INCREMENT,
20    name      VARCHAR(255),
21    tag       VARCHAR(255),
22    tag_color VARCHAR(5),
23    PRIMARY KEY (id)
24);
25
26INSERT INTO `groups`(name, tag, tag_color)
27VALUES ('Joueur', 'Joueur', '§f'),
28       ('VIP', 'VIP', '§a'),
29       ('VIP+', 'VIP+', '§b'),
30       ('Ami', 'Ami', '§d'),
31       ('Builder', 'Builder', '§9'),
32       ('Développeur', 'Dev', '§e'),
33       ('Modérateur', 'Modo', '§6'),
34       ('Administrateur', 'Admin', '§c')
35;
36
37DROP TABLE IF EXISTS maps;
38CREATE TABLE maps
39(
40    name      VARCHAR(255),
41    size      SMALLINT,
42    game_id   SMALLINT,
43    game_mode VARCHAR(255),
44    team_size SMALLINT
45);
46
47INSERT INTO maps (name, size, game_id, game_mode, team_size)
48VALUES ('Default', 12, 1, 'Solo', 1),
49       ('Default', 12, 2, 'Solo', 1)
50;
51
52DROP TABLE IF EXISTS players;
53CREATE TABLE players
54(
55    uuid                 VARCHAR(40) NOT NULL,
56    coins                INT         NOT NULL,
57    group_id             SMALLINT    NOT NULL,
58    last_connection_date DATETIME    NOT NULL,
59    registration_date    DATETIME    NOT NULL,
60    PRIMARY KEY (uuid)
61);
62
63DROP TABLE IF EXISTS proxy_permissions;
64CREATE TABLE proxy_permissions
65(
66    group_id              SMALLINT AUTO_INCREMENT,
67    proxy_command_party   BOOLEAN NOT NULL,
68    proxy_command_friends BOOLEAN NOT NULL,
69    proxy_command_server  BOOLEAN NOT NULL,
70    PRIMARY KEY (group_id)
71);
72
73INSERT INTO proxy_permissions(proxy_command_party, proxy_command_friends, proxy_command_server)
74VALUES (1, 1, 0),
75       (1, 1, 0),
76       (1, 1, 0),
77       (1, 1, 0),
78       (1, 1, 0),
79       (1, 1, 0),
80       (1, 1, 0),
81       (1, 1, 1)
82;
83
84DROP TABLE IF EXISTS servers_configuration;
85CREATE TABLE servers_configuration
86(
87    game_id      INT AUTO_INCREMENT,
88    model_folder VARCHAR(255),
89    min_ram      INT,
90    max_ram      INT,
91    PRIMARY KEY (game_id)
92);
93
94INSERT INTO servers_configuration(model_folder, min_ram, max_ram)
95VALUES ('Bedwars', 1024, 1024),
96       ('Skywars', 1024, 1024)
97;