63Q4SW0z

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