70U7ckae

1CREATE DATABASE IF NOT EXISTS `exileEscape` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `exileEscape`;
3
4CREATE TABLE IF NOT EXISTS `account` (
5  `uid` varchar(32) NOT NULL,
6  `clan_id` int(11) unsigned DEFAULT NULL,
7  `name` varchar(64) NOT NULL,
8  `score` int(11) NOT NULL DEFAULT '0',
9  `wins` int(11) unsigned NOT NULL DEFAULT '0',
10  `matches` int(11) unsigned NOT NULL DEFAULT '0',
11  `kills` int(11) unsigned NOT NULL DEFAULT '0',
12  `deaths` int(11) unsigned NOT NULL DEFAULT '0',
13  `locker` int(11) NOT NULL DEFAULT '0',
14  `first_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
15  `last_connect_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
16  `last_disconnect_at` datetime DEFAULT NULL,
17  `total_connections` int(11) unsigned NOT NULL DEFAULT '1',
18  PRIMARY KEY (`uid`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8;
20
21
22CREATE TABLE IF NOT EXISTS `game_data` (
23  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
24  `game_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
25  `total_players` int(11) unsigned DEFAULT NULL,
26  `winner_uid` varchar(32) NOT NULL,
27  `win_type` varchar(32) NOT NULL,
28  `players` text NOT NULL,
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31
32CREATE TABLE IF NOT EXISTS `player` (
33  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
34  `name` varchar(64) NOT NULL,
35  `account_uid` varchar(32) NOT NULL,
36  `money` int(11) unsigned NOT NULL DEFAULT '0',
37  `damage` double unsigned NOT NULL DEFAULT '0',
38  `hunger` double unsigned NOT NULL DEFAULT '100',
39  `thirst` double unsigned NOT NULL DEFAULT '100',
40  `alcohol` double unsigned NOT NULL DEFAULT '0',
41  `temperature` double NOT NULL DEFAULT '37',
42  `wetness` double unsigned NOT NULL DEFAULT '0',
43  `oxygen_remaining` double unsigned NOT NULL DEFAULT '1',
44  `bleeding_remaining` double unsigned NOT NULL DEFAULT '0',
45  `hitpoints` varchar(1024) NOT NULL DEFAULT '[]',
46  `direction` double NOT NULL DEFAULT '0',
47  `position_x` double NOT NULL DEFAULT '0',
48  `position_y` double NOT NULL DEFAULT '0',
49  `position_z` double NOT NULL DEFAULT '0',
50  `spawned_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
51  `assigned_items` text NOT NULL,
52  `backpack` varchar(64) NOT NULL,
53  `backpack_items` text NOT NULL,
54  `backpack_magazines` text NOT NULL,
55  `backpack_weapons` text NOT NULL,
56  `current_weapon` varchar(64) NOT NULL,
57  `goggles` varchar(64) NOT NULL,
58  `handgun_items` text NOT NULL,
59  `handgun_weapon` varchar(64) NOT NULL,
60  `headgear` varchar(64) NOT NULL,
61  `binocular` varchar(64) NOT NULL,
62  `loaded_magazines` text NOT NULL,
63  `primary_weapon` varchar(64) NOT NULL,
64  `primary_weapon_items` text NOT NULL,
65  `secondary_weapon` varchar(64) NOT NULL,
66  `secondary_weapon_items` text NOT NULL,
67  `uniform` varchar(64) NOT NULL,
68  `uniform_items` text NOT NULL,
69  `uniform_magazines` text NOT NULL,
70  `uniform_weapons` text NOT NULL,
71  `vest` varchar(64) NOT NULL,
72  `vest_items` text NOT NULL,
73  `vest_magazines` text NOT NULL,
74  `vest_weapons` text NOT NULL,
75  `last_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
76  PRIMARY KEY (`id`),
77  KEY `player_uid` (`account_uid`),
78  CONSTRAINT `player_ibfk_1` FOREIGN KEY (`account_uid`) REFERENCES `account` (`uid`) ON DELETE CASCADE
79) ENGINE=InnoDB DEFAULT CHARSET=utf8;
80
81CREATE TABLE IF NOT EXISTS `player_history` (
82  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
83  `account_uid` varchar(32) NOT NULL,
84  `name` varchar(64) NOT NULL,
85  `died_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
86  `position_x` double NOT NULL,
87  `position_y` double NOT NULL,
88  `position_z` double NOT NULL,
89  PRIMARY KEY (`id`)
90) ENGINE=InnoDB DEFAULT CHARSET=utf8;