GuLXdkdG

1
2CREATE TABLE locations (
3  id int primary key,
4  x int NOT NULL,
5  y int NOT NULL,
6  z int NOT NULL
7);
8
9CREATE TABLE worlds (
10  id int primary key,
11  name nvarchar(64) NOT NULL
12);
13
14CREATE TABLE placement (
15  time long NOT NULL,
16  location_id int NOT NULL,
17  world_id int NOT NULL,
18  player_id int NOT NULL,
19  block_type int NOT NULL,
20  rolled_back bool NOT NULL
21);
22
23CREATE TABLE removal (
24  time long NOT NULL,
25  location_id int NOT NULL,
26  world_id int NOT NULL,
27  player_id int NOT NULL,
28  block_type int NOT NULL,
29  rolled_back bool NOT NULL
30);
31
32CREATE TABLE IF NOT EXISTS itemframe_placement (
33  time long NOT NULL,
34  itemframe_id int NOT NULL,
35  player_id int NOT NULL,
36  item_id int NOT NULL,
37  rolled_back int NOT NULL
38);
39
40CREATE TABLE IF NOT EXISTS itemframes (
41  id int NOT NULL,
42  world_id int NOT NULL,
43  location_id int NOT NULL
44);
45
46CREATE TABLE IF NOT EXISTS player_name (
47  id int primary key,
48  name nvarchar(16) NOT NULL
49);
50
51CREATE TABLE IF NOT EXISTS player_uuid (
52  id int primary key,
53  uuid nchar(36) NOT NULL
54);
55
56CREATE TABLE IF NOT EXISTS chats (
57  player_id int NOT NULL,
58  content nvarchar(256) NOT NULL
59);
60
61CREATE TABLE IF NOT EXISTS commands (
62  player_id int NOT NULL,
63  content nvarchar(256) NOT NULL
64);
65
66CREATE TABLE IF NOT EXISTS int2bool (
67  key int primary key,
68  value nvarchar(5)
69);
70
71/* useful */
72CREATE VIEW player as SELECT n.id, n.name, u.uuid
73FROM player_uuid as u, player_name as n
74WHERE u.id = n.id;