· 6 years ago · May 05, 2019, 11:38 PM
1 String UserDatabase = "CREATE TABLE IF NOT EXISTS players(\n"
2 + " id integer NOT NULL PRIMARY KEY,\n"
3 + " username TEXT NULL,\n"
4 + " DiscordRank TEXT NULL,\n"
5 + " DiscordID TEXT NULL,\n"
6 + " uuid binary(16) DEFAULT NULL UNIQUE);";
7 String CrashCoin = "CREATE TABLE IF NOT EXISTS crashcoin(\n"
8 + " id integer PRIMARY KEY,\n"
9 + " amount INTEGER NOT NULL,\n"
10 + " time DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,\n"
11 + " description TEXT NOT NULL,\n"
12 + " players_id integer NOT NULL,\n"
13 + " CONSTRAINT crashcoin_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
14
15 String Waypoint = "CREATE TABLE IF NOT EXISTS waypoints(\n"
16 + " id integer PRIMARY KEY,\n"
17 + " name TEXT collate nocase,\n"
18 + " posx DOUBLE,\n"
19 + " posy DOUBLE,\n"
20 + " posz DOUBLE,\n"
21 + " pitch smallint,\n"
22 + " yaw smallint,\n"
23 + " world TEXT,\n"
24 + " players_id integer NOT NULL,\n"
25 + " UNIQUE (players_id,name),\n"
26 + " CONSTRAINT waypoints_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
27 String Homes = "CREATE TABLE IF NOT EXISTS homes(\n"
28 + " id integer PRIMARY KEY,\n"
29 + " `name` TEXT,\n"
30 + " posx DOUBLE,\n"
31 + " posy DOUBLE,\n"
32 + " posz DOUBLE,\n"
33 + " pitch smallint,\n"
34 + " yaw smallint,\n"
35 + " world TEXT,\n"
36 + " players_id integer NOT NULL,\n"
37 + " UNIQUE (players_id,name),\n"
38 + " CONSTRAINT homes_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
39 String Shop = "CREATE TABLE IF NOT EXISTS shop(\n"
40 + " id INTEGER PRIMARY KEY, \n"
41 + " item_id INTEGER NOT NULL, \n"
42 + " purchase_price INTEGER NOT NULL,\n"
43 + " quantity INTEGER NOT NULL,\n"
44 + " `time` DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,\n"
45 + " players_id integer NOT NULL,\n"
46 + " CONSTRAINT shop_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
47 String Inventory = "CREATE TABLE IF NOT EXISTS inventory(\n"
48 + " item_id INTEGER PRIMARY KEY AUTOINCREMENT, \n"
49 + " `name` TEXT UNIQUE NOT NULL, \n"
50 + " price INTEGER NOT NULL);";
51 String ItemFilter = "CREATE TABLE IF NOT EXISTS itemFilter(\n"
52 + " id INTEGER PRIMARY KEY, \n"
53 + " `name` TEXT collate nocase, \n"
54 + " blacklist text NOT NULL,\n"
55 + " players_id integer NOT NULL,\n"
56 + " UNIQUE (players_id,`name`),\n"
57 + " CONSTRAINT itemFilter_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
58 String WorldController = "CREATE TABLE IF NOT EXISTS worldController(\n"
59 + " id INTEGER PRIMARY KEY, \n"
60 + " inventory TEXT, \n"
61 + " echest TEXT, \n"
62 + " health DOUBLE ,\n"
63 + " hunger DOUBLE,\n"
64 + " xp REAL,\n"
65 + " xpl INTEGER,\n"
66 + " posx DOUBLE,\n"
67 + " posy DOUBLE,\n"
68 + " posz DOUBLE,\n"
69 + " pitch smallint,\n"
70 + " yaw smallint,\n"
71 + " world TEXT NOT NULL,\n"
72 + " world_group TEXT NOT NULL,\n"
73 + " players_id integer NOT NULL,\n"
74 + " CONSTRAINT worldController_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
75 String Settings = "CREATE TABLE IF NOT EXISTS settings(\n"
76 + " id INTEGER PRIMARY KEY, \n"
77 + " `name` text, \n"
78 + " `value` text , \n"
79 + " players_id integer NOT NULL,\n"
80 + " UNIQUE (players_id,name),\n"
81 + " CONSTRAINT settings_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
82 String Claims = "CREATE TABLE IF NOT EXISTS claims(\n"
83 + " id INTEGER PRIMARY KEY, \n"
84 + " players_id integer NOT NULL,\n"
85 + " `name` text , \n"
86 + " `enterMessage` text , \n"
87 + " `exitMessage` text , \n"
88 + " NWCorner_x INTEGER , \n"
89 + " NWCorner_z INTEGER , \n"
90 + " SECorner_x INTEGER , \n"
91 + " SECorner_z INTEGER , \n"
92 + " world TEXT , \n"
93 + " globalContainerPermissions_id INTEGER, \n"
94 + " globalBuild INTEGER , \n"
95 + " globalEntities INTEGER , \n"
96 + " globalInteractions INTEGER , \n"
97 + " globalTeleportations INTEGER , \n"
98 + " globalExplosions INTEGER , \n"
99 + " UNIQUE (players_id, id),\n"
100 + " CONSTRAINT claims_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
101 String ClaimData = "CREATE TABLE IF NOT EXISTS claimData(\n"
102 + " id INTEGER PRIMARY KEY ,\n"
103 + " claim_id INTEGER NOT NULL ,\n"
104 + " players_id INTEGER NOT NULL ,\n"
105 + " coOwner INTEGER , \n"
106 + " Build INTEGER , \n"
107 + " Entities INTEGER , \n"
108 + " Interactions INTEGER , \n"
109 + " UNIQUE (players_id, claim_id),\n"
110 + " CONSTRAINT claimData_ibfk_2 FOREIGN KEY (claim_id) REFERENCES claims (id) ON DELETE CASCADE ON UPDATE CASCADE,"
111 + " CONSTRAINT claimData_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
112 String containerPermissions = "CREATE TABLE IF NOT EXISTS `containerPermissions` (\n"
113 + " `id` INTEGER PRIMARY KEY,\n"
114 + " `claim_id` INTEGER NOT NULL,\n"
115 + " `players_id` INTEGER,\n"
116 + " `container` TEXT NOT NULL,\n"
117 + " `enabled` INTEGER NOT NULL,\n"
118 + " UNIQUE (claim_id, players_id, container),\n"
119 + " CONSTRAINT containerPermissions_ibfk_2 FOREIGN KEY (claim_id) REFERENCES claims (id) ON DELETE CASCADE ON UPDATE CASCADE,\n"
120 + " CONSTRAINT containerPermissions_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
121 String claimPurchases = "CREATE TABLE IF NOT EXISTS claimPurchases(\n"
122 + " id INTEGER PRIMARY KEY ,\n"
123 + " claim_id INTEGER NOT NULL ,\n"
124 + " players_id INTEGER NOT NULL ,\n"
125 + " area INTEGER NOT NULL, \n"
126 + " UNIQUE (players_id, claim_id),\n"
127 + " CONSTRAINT claimPurchases_ibfk_2 FOREIGN KEY (claim_id) REFERENCES claims (id) ON DELETE CASCADE ON UPDATE CASCADE,"
128 + " CONSTRAINT claimPurchases_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
129 String friends = "CREATE TABLE IF NOT EXISTS friends(\n"
130 + " id INTEGER PRIMARY KEY ,\n"
131 + " players_id INTEGER NOT NULL ,\n"
132 + " friendPlayer_id INTEGER NOT NULL ,\n"
133 + " UNIQUE (players_id, friendPlayer_id),\n"
134 + " CONSTRAINT friends_ibfk_1 FOREIGN KEY (players_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";
135 String friendsSettings = "CREATE TABLE IF NOT EXISTS friendsSettings(\n"
136 + " id INTEGER PRIMARY KEY ,\n"
137 + " friend_id INTEGER NOT NULL ,\n"
138 + " `key` text, \n"
139 + " `value` text , \n"
140 + " UNIQUE (`key`, friend_id),\n"
141 + " CONSTRAINT friendsSettings_ibfk_1 FOREIGN KEY (friend_id) REFERENCES friends (id) ON DELETE CASCADE ON UPDATE CASCADE);";
142 String chatFilter = "CREATE TABLE IF NOT EXISTS chatFilter(\n"
143 + " id INTEGER PRIMARY KEY ,\n"
144 + " `word` text, \n"
145 + " `optional` INTEGER , \n"
146 + " UNIQUE (`word`));";
147 String chatFilterWhitelist = "CREATE TABLE IF NOT EXISTS chatFilterWhitelist(\n"
148 + " id INTEGER PRIMARY KEY ,\n"
149 + " `word` text, \n"
150 + " UNIQUE (`word`));";
151 String infractionLog = "CREATE TABLE IF NOT EXISTS infractionLog(\n"
152 + " id INTEGER PRIMARY KEY ,\n"
153 + " `player_id` INTEGER NOT NULL ,\n"
154 + " `maker_id` INTEGER NOT NULL ,\n"
155 + " `type` text NOT NULL, \n"
156 + " `date` DATE NOT NULL, \n"
157 + " `length` INTEGER, \n"
158 + " `desc` TEXT , \n"
159 + " `overrider_id` INTEGER ,\n"
160 + " `override_reason` TEXT , \n"
161 + " CONSTRAINT infractionLog_ibfk_3 FOREIGN KEY (overrider_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE, \n"
162 + " CONSTRAINT infractionLog_ibfk_2 FOREIGN KEY (maker_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE, \n"
163 + " CONSTRAINT infractionLog_ibfk_1 FOREIGN KEY (player_id) REFERENCES players (id) ON DELETE CASCADE ON UPDATE CASCADE);";