· 5 years ago · Apr 01, 2020, 08:54 AM
1String sql = "CREATE TABLE IF NOT EXISTS bans"
2 + "("
3 + "ID Integer PRIMARY KEY,"
4 + "UUID varchar(200),"
5 + "tempBanned bit,"
6 + "banner varchar(200),"
7 + "type varchar(20),"
8 + "message varchar(1000),"
9 + "tempBanDate varchar(50),"
10 + "pureDate varchar(100)"
11 + ")";
12
13 Statement statement = connection.createStatement();
14
15 statement.executeUpdate(sql);
16 statement.close();
17
18 sql = "CREATE TABLE IF NOT EXISTS warns"
19 + "("
20 + "ID Integer PRIMARY KEY,"
21 + "UUID varchar(200),"
22 + "warner varchar(200),"
23 + "message varchar(1000),"
24 + "date varchar(50)"
25 + ")";
26
27 statement = connection.createStatement();
28
29 statement.executeUpdate(sql);
30 statement.close();
31
32 sql = "CREATE TABLE IF NOT EXISTS players"
33 + "("
34 + "ID Integer PRIMARY KEY,"
35 + "UUID varchar(200),"
36 + "address varchar(100),"
37 + "warnings int,"
38 + "playername varchar(50)"
39 + ")";
40
41 statement = connection.createStatement();
42
43 statement.executeUpdate(sql);
44 statement.close();
45
46 sql = "CREATE TABLE IF NOT EXISTS ipbans"
47 + "("
48 + "ID Integer PRIMARY KEY,"
49 + "ip varchar(100),"
50 + "banner varchar(200),"
51 + "type varchar(20),"
52 + "tempBanned bit,"
53 + "message varchar(1000),"
54 + "tempBanDate varchar(50),"
55 + "pureDate varchar(100)"
56 + ")";
57
58 statement = connection.createStatement();
59
60 statement.executeUpdate(sql);
61 statement.close();
62
63 sql = "CREATE TABLE IF NOT EXISTS logs"
64 + "("
65 + "ID Integer PRIMARY KEY,"
66 + "command varchar(50),"
67 + "sender varchar(1000),"
68 + "isConsole bit,"
69 + "args varchar(1000),"
70 + "date varchar(50)"
71 + ")";
72
73 statement = connection.createStatement();
74
75 statement.executeUpdate(sql);
76 statement.close();
77
78 sql = "CREATE TABLE IF NOT EXISTS mutes"
79 + "("
80 + "ID Integer PRIMARY KEY,"
81 + "UUID varchar(50),"
82 + "tempMuted bit,"
83 + "tempMuteDate varchar(50),"
84 + "reason varchar(1000),"
85 + "date varchar(50)"
86 + ")";
87
88 statement = connection.createStatement();
89
90 statement.executeUpdate(sql);
91 statement.close();
92
93 sql = "CREATE TABLE IF NOT EXISTS staff"
94 + "("
95 + "ID Integer PRIMARY KEY,"
96 + "UUID varchar(50)"
97 + ")";
98
99 statement = connection.createStatement();
100
101 statement.executeUpdate(sql);
102 statement.close();
103
104 } else {
105
106 String sql = "CREATE TABLE IF NOT EXISTS bans"
107 + "("
108 + "ID Integer NOT NULL AUTO_INCREMENT,"
109 + "UUID varchar(200),"
110 + "tempBanned bit,"
111 + "banner varchar(200),"
112 + "type varchar(20),"
113 + "message varchar(1000),"
114 + "tempBanDate varchar(50),"
115 + "pureDate varchar(100),"
116 + "PRIMARY KEY (id))";
117
118 Statement statement = connection.createStatement();
119
120 statement.executeUpdate(sql);
121 statement.close();
122
123 sql = "CREATE TABLE IF NOT EXISTS warns"
124 + "("
125 + "ID Integer NOT NULL AUTO_INCREMENT,"
126 + "UUID varchar(200),"
127 + "warner varchar(200),"
128 + "message varchar(1000),"
129 + "date varchar(50),"
130 + "PRIMARY KEY (id))";
131
132 statement = connection.createStatement();
133
134 statement.executeUpdate(sql);
135 statement.close();
136
137 sql = "CREATE TABLE IF NOT EXISTS players"
138 + "("
139 + "ID Integer NOT NULL AUTO_INCREMENT,"
140 + "UUID varchar(200),"
141 + "address varchar(100),"
142 + "warnings int,"
143 + "playername varchar(50),"
144 + "PRIMARY KEY (id))";
145
146 statement = connection.createStatement();
147
148 statement.executeUpdate(sql);
149 statement.close();
150
151 sql = "CREATE TABLE IF NOT EXISTS ipbans"
152 + "("
153 + "ID Integer NOT NULL AUTO_INCREMENT,"
154 + "ip varchar(100),"
155 + "banner varchar(200),"
156 + "type varchar(20),"
157 + "tempBanned bit,"
158 + "message varchar(1000),"
159 + "tempBanDate varchar(50),"
160 + "pureDate varchar(100),"
161 + "PRIMARY KEY (id))";
162
163 statement = connection.createStatement();
164
165 statement.executeUpdate(sql);
166 statement.close();
167
168 sql = "CREATE TABLE IF NOT EXISTS logs"
169 + "("
170 + "ID Integer NOT NULL AUTO_INCREMENT,"
171 + "command varchar(50),"
172 + "sender varchar(1000),"
173 + "isConsole bit,"
174 + "args varchar(1000),"
175 + "date varchar(50),"
176 + "PRIMARY KEY (id))";
177
178 statement = connection.createStatement();
179
180 statement.executeUpdate(sql);
181 statement.close();
182
183 sql = "CREATE TABLE IF NOT EXISTS mutes"
184 + "("
185 + "ID Integer NOT NULL AUTO_INCREMENT,"
186 + "UUID varchar(50),"
187 + "tempMuted bit,"
188 + "tempMuteDate varchar(50),"
189 + "reason varchar(1000),"
190 + "date varchar(50),"
191 + "PRIMARY KEY (id))";
192
193 statement = connection.createStatement();
194
195 statement.executeUpdate(sql);
196 statement.close();
197
198 sql = "CREATE TABLE IF NOT EXISTS staff"
199 + "("
200 + "ID Integer NOT NULL AUTO_INCREMENT,"
201 + "UUID varchar(50),"
202 + "PRIMARY KEY (id))";
203
204 statement = connection.createStatement();
205
206 statement.executeUpdate(sql);
207 statement.close();
208
209 sql = "CREATE TABLE IF NOT EXISTS updates"
210 + "("
211 + "ID Integer NOT NULL AUTO_INCREMENT,"
212 + "type varchar(20),"
213 + "data varchar(1000),"
214 + "date varchar(50),"
215 + "executed varchar(200),"
216 + "published varchar(50),"
217 + "PRIMARY KEY (ID))";