CREATE TABLE "server" (
  "server_id" tinyint(3) unsigned NOT NULL,
  "online" tinyint(4) NOT NULL DEFAULT 0,
  "public_name" tinytext NOT NULL,
  "last_open_time" datetime DEFAULT NULL,
  "last_close_time" datetime DEFAULT NULL,
  "current_address" bigint(20) unsigned DEFAULT NULL,
  "active_players" int(10) unsigned DEFAULT 0,
  "active_games" int(10) unsigned DEFAULT 0,
  "active_matchmaking" int(10) unsigned DEFAULT 0,
  "last_update_time" datetime DEFAULT NULL,
  "build_version" int(10) unsigned DEFAULT NULL,
  "build_commit" varchar(32) DEFAULT NULL,
  "protocol_version" int(10) DEFAULT NULL,
  "respite_api_key" varchar(32) NOT NULL,
  "last_ip_address" varchar(128) NOT NULL,
  "public_key" mediumtext DEFAULT NULL,
  "steam_app_id" int(10) unsigned DEFAULT NULL,
  "steam_gs_token" tinytext NOT NULL,
  "steam_app_ticket" tinytext NOT NULL,
  PRIMARY KEY ("server_id")
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `dispute`.`server`
(`server_id`,
`online`,
`public_name`,
`last_open_time`,
`last_close_time`,
`current_address`,
`active_players`,
`active_games`,
`active_matchmaking`,
`last_update_time`,
`build_version`,
`build_commit`,
`protocol_version`,
`respite_api_key`,
`last_ip_address`,
`public_key`,
`steam_app_id`,
`steam_gs_token`,
`steam_app_ticket`)
VALUES
(1, 0, 'yeah', NULL,
NULL,
NULL,
0,
0,
0,
NULL,
100,
100,
100,
'asd',
'',
'asd',
1,
'asd',
'asd');
