|
6
|
1 |
case 'mysql':
|
|
|
2 |
case 'mysqli':
|
|
|
3 |
CREATE TABLE {{TABLE_PREFIX}}bans (
|
|
|
4 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
5 |
username VARCHAR(200),
|
|
|
6 |
ip VARCHAR(255),
|
|
|
7 |
email VARCHAR(80),
|
|
|
8 |
message VARCHAR(255),
|
|
|
9 |
expire INT(10) UNSIGNED,
|
|
|
10 |
ban_creator INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
11 |
PRIMARY KEY (id)
|
|
|
12 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
13 |
|
|
|
14 |
case 'pgsql':
|
|
|
15 |
CREATE TABLE {{TABLE_PREFIX}}bans (
|
|
|
16 |
id SERIAL,
|
|
|
17 |
username VARCHAR(200),
|
|
|
18 |
ip VARCHAR(255),
|
|
|
19 |
email VARCHAR(80),
|
|
|
20 |
message VARCHAR(255),
|
|
|
21 |
expire INT,
|
|
|
22 |
ban_creator INT NOT NULL DEFAULT 0,
|
|
|
23 |
PRIMARY KEY (id)
|
|
|
24 |
)
|
|
|
25 |
|
|
|
26 |
case 'mysql':
|
|
|
27 |
case 'mysqli':
|
|
|
28 |
CREATE TABLE {{TABLE_PREFIX}}categories (
|
|
|
29 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
30 |
cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category',
|
|
|
31 |
disp_position INT(10) NOT NULL DEFAULT 0,
|
|
|
32 |
PRIMARY KEY (id)
|
|
|
33 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
34 |
|
|
|
35 |
case 'pgsql':
|
|
|
36 |
CREATE TABLE {{TABLE_PREFIX}}categories (
|
|
|
37 |
id SERIAL,
|
|
|
38 |
cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category',
|
|
|
39 |
disp_position INT NOT NULL DEFAULT 0,
|
|
|
40 |
PRIMARY KEY (id)
|
|
|
41 |
)
|
|
|
42 |
|
|
|
43 |
case 'mysql':
|
|
|
44 |
case 'mysqli':
|
|
|
45 |
CREATE TABLE {{TABLE_PREFIX}}censoring (
|
|
|
46 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
47 |
search_for VARCHAR(60) NOT NULL DEFAULT '',
|
|
|
48 |
replace_with VARCHAR(60) NOT NULL DEFAULT '',
|
|
|
49 |
PRIMARY KEY (id)
|
|
|
50 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
51 |
|
|
|
52 |
case 'pgsql':
|
|
|
53 |
CREATE TABLE {{TABLE_PREFIX}}censoring (
|
|
|
54 |
id SERIAL,
|
|
|
55 |
search_for VARCHAR(60) NOT NULL DEFAULT '',
|
|
|
56 |
replace_with VARCHAR(60) NOT NULL DEFAULT '',
|
|
|
57 |
PRIMARY KEY (id)
|
|
|
58 |
)
|
|
|
59 |
|
|
|
60 |
case 'mysql':
|
|
|
61 |
case 'mysqli':
|
|
|
62 |
CREATE TABLE {{TABLE_PREFIX}}config (
|
|
|
63 |
conf_name VARCHAR(255) NOT NULL DEFAULT '',
|
|
|
64 |
conf_value TEXT,
|
|
|
65 |
PRIMARY KEY (conf_name)
|
|
|
66 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
67 |
|
|
|
68 |
case 'pgsql':
|
|
|
69 |
CREATE TABLE {{TABLE_PREFIX}}config (
|
|
|
70 |
conf_name VARCHAR(255) NOT NULL DEFAULT '',
|
|
|
71 |
conf_value TEXT,
|
|
|
72 |
PRIMARY KEY (conf_name)
|
|
|
73 |
)
|
|
|
74 |
|
|
|
75 |
case 'sqlite':
|
|
|
76 |
CREATE TABLE {{TABLE_PREFIX}}config (
|
|
|
77 |
conf_name VARCHAR(255) NOT NULL DEFAULT '',
|
|
|
78 |
conf_value TEXT,
|
|
|
79 |
PRIMARY KEY (conf_name)
|
|
|
80 |
)
|
|
|
81 |
|
|
|
82 |
case 'mysql':
|
|
|
83 |
case 'mysqli':
|
|
|
84 |
CREATE TABLE {{TABLE_PREFIX}}extensions (
|
|
|
85 |
id VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
86 |
title VARCHAR(255) NOT NULL DEFAULT '',
|
|
|
87 |
version VARCHAR(25) NOT NULL DEFAULT '',
|
|
|
88 |
description TEXT,
|
|
|
89 |
author VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
90 |
uninstall TEXT,
|
|
|
91 |
uninstall_note TEXT,
|
|
|
92 |
disabled TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
93 |
PRIMARY KEY(id)
|
|
|
94 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
95 |
|
|
|
96 |
case 'pgsql':
|
|
|
97 |
CREATE TABLE {{TABLE_PREFIX}}extensions (
|
|
|
98 |
id VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
99 |
title VARCHAR(255) NOT NULL DEFAULT '',
|
|
|
100 |
version VARCHAR(25) NOT NULL DEFAULT '',
|
|
|
101 |
description TEXT,
|
|
|
102 |
author VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
103 |
uninstall TEXT,
|
|
|
104 |
uninstall_note TEXT,
|
|
|
105 |
disabled SMALLINT NOT NULL DEFAULT 0,
|
|
|
106 |
PRIMARY KEY(id)
|
|
|
107 |
)
|
|
|
108 |
|
|
|
109 |
case 'mysql':
|
|
|
110 |
case 'mysqli':
|
|
|
111 |
CREATE TABLE {{TABLE_PREFIX}}extension_hooks (
|
|
|
112 |
id VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
113 |
extension_id VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
114 |
code TEXT,
|
|
|
115 |
installed INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
116 |
PRIMARY KEY(id, extension_id)
|
|
|
117 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
118 |
|
|
|
119 |
case 'pgsql':
|
|
|
120 |
CREATE TABLE {{TABLE_PREFIX}}extension_hooks (
|
|
|
121 |
id VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
122 |
extension_id VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
123 |
code TEXT,
|
|
|
124 |
installed INT NOT NULL DEFAULT 0,
|
|
|
125 |
PRIMARY KEY(id, extension_id)
|
|
|
126 |
)
|
|
|
127 |
|
|
|
128 |
case 'mysql':
|
|
|
129 |
case 'mysqli':
|
|
|
130 |
CREATE TABLE {{TABLE_PREFIX}}forum_perms (
|
|
|
131 |
group_id INT(10) NOT NULL DEFAULT 0,
|
|
|
132 |
forum_id INT(10) NOT NULL DEFAULT 0,
|
|
|
133 |
read_forum TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
134 |
post_replies TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
135 |
post_topics TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
136 |
PRIMARY KEY (group_id, forum_id)
|
|
|
137 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
138 |
|
|
|
139 |
case 'pgsql':
|
|
|
140 |
CREATE TABLE {{TABLE_PREFIX}}forum_perms (
|
|
|
141 |
group_id INT NOT NULL DEFAULT 0,
|
|
|
142 |
forum_id INT NOT NULL DEFAULT 0,
|
|
|
143 |
read_forum SMALLINT NOT NULL DEFAULT 1,
|
|
|
144 |
post_replies SMALLINT NOT NULL DEFAULT 1,
|
|
|
145 |
post_topics SMALLINT NOT NULL DEFAULT 1,
|
|
|
146 |
PRIMARY KEY (group_id, forum_id)
|
|
|
147 |
)
|
|
|
148 |
|
|
|
149 |
case 'mysql':
|
|
|
150 |
case 'mysqli':
|
|
|
151 |
CREATE TABLE {{TABLE_PREFIX}}forums (
|
|
|
152 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
153 |
forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum',
|
|
|
154 |
forum_desc TEXT,
|
|
|
155 |
redirect_url VARCHAR(100),
|
|
|
156 |
moderators TEXT,
|
|
|
157 |
num_topics MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
158 |
num_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
159 |
last_post INT(10) UNSIGNED,
|
|
|
160 |
last_post_id INT(10) UNSIGNED,
|
|
|
161 |
last_poster VARCHAR(200),
|
|
|
162 |
sort_by TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
163 |
disp_position INT(10) NOT NULL DEFAULT 0,
|
|
|
164 |
cat_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
165 |
PRIMARY KEY (id)
|
|
|
166 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
167 |
|
|
|
168 |
case 'pgsql':
|
|
|
169 |
CREATE TABLE {{TABLE_PREFIX}}forums (
|
|
|
170 |
id SERIAL,
|
|
|
171 |
forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum',
|
|
|
172 |
forum_desc TEXT,
|
|
|
173 |
redirect_url VARCHAR(100),
|
|
|
174 |
moderators TEXT,
|
|
|
175 |
num_topics INT NOT NULL DEFAULT 0,
|
|
|
176 |
num_posts INT NOT NULL DEFAULT 0,
|
|
|
177 |
last_post INT,
|
|
|
178 |
last_post_id INT,
|
|
|
179 |
last_poster VARCHAR(200),
|
|
|
180 |
sort_by SMALLINT NOT NULL DEFAULT 0,
|
|
|
181 |
disp_position INT NOT NULL DEFAULT 0,
|
|
|
182 |
cat_id INT NOT NULL DEFAULT 0,
|
|
|
183 |
PRIMARY KEY (id)
|
|
|
184 |
)
|
|
|
185 |
|
|
|
186 |
case 'mysql':
|
|
|
187 |
case 'mysqli':
|
|
|
188 |
CREATE TABLE {{TABLE_PREFIX}}groups (
|
|
|
189 |
g_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
190 |
g_title VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
191 |
g_user_title VARCHAR(50),
|
|
|
192 |
g_moderator TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
193 |
g_mod_edit_users TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
194 |
g_mod_rename_users TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
195 |
g_mod_change_passwords TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
196 |
g_mod_ban_users TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
197 |
g_read_board TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
198 |
g_view_users TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
199 |
g_post_replies TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
200 |
g_post_topics TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
201 |
g_edit_posts TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
202 |
g_delete_posts TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
203 |
g_delete_topics TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
204 |
g_set_title TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
205 |
g_search TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
206 |
g_search_users TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
207 |
g_edit_subjects_interval SMALLINT(6) NOT NULL DEFAULT 300,
|
|
|
208 |
g_post_flood SMALLINT(6) NOT NULL DEFAULT 30,
|
|
|
209 |
g_search_flood SMALLINT(6) NOT NULL DEFAULT 30,
|
|
|
210 |
PRIMARY KEY (g_id)
|
|
|
211 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
212 |
|
|
|
213 |
case 'pgsql':
|
|
|
214 |
CREATE TABLE {{TABLE_PREFIX}}groups (
|
|
|
215 |
g_id SERIAL,
|
|
|
216 |
g_title VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
217 |
g_user_title VARCHAR(50),
|
|
|
218 |
g_moderator SMALLINT NOT NULL DEFAULT 0,
|
|
|
219 |
g_mod_edit_users SMALLINT NOT NULL DEFAULT 0,
|
|
|
220 |
g_mod_rename_users SMALLINT NOT NULL DEFAULT 0,
|
|
|
221 |
g_mod_change_passwords SMALLINT NOT NULL DEFAULT 0,
|
|
|
222 |
g_mod_ban_users SMALLINT NOT NULL DEFAULT 0,
|
|
|
223 |
g_read_board SMALLINT NOT NULL DEFAULT 1,
|
|
|
224 |
g_view_users SMALLINT NOT NULL DEFAULT 1,
|
|
|
225 |
g_post_replies SMALLINT NOT NULL DEFAULT 1,
|
|
|
226 |
g_post_topics SMALLINT NOT NULL DEFAULT 1,
|
|
|
227 |
g_edit_posts SMALLINT NOT NULL DEFAULT 1,
|
|
|
228 |
g_delete_posts SMALLINT NOT NULL DEFAULT 1,
|
|
|
229 |
g_delete_topics SMALLINT NOT NULL DEFAULT 1,
|
|
|
230 |
g_set_title SMALLINT NOT NULL DEFAULT 1,
|
|
|
231 |
g_search SMALLINT NOT NULL DEFAULT 1,
|
|
|
232 |
g_search_users SMALLINT NOT NULL DEFAULT 1,
|
|
|
233 |
g_edit_subjects_interval SMALLINT NOT NULL DEFAULT 300,
|
|
|
234 |
g_post_flood SMALLINT NOT NULL DEFAULT 30,
|
|
|
235 |
g_search_flood SMALLINT NOT NULL DEFAULT 30,
|
|
|
236 |
PRIMARY KEY (g_id)
|
|
|
237 |
)
|
|
|
238 |
|
|
|
239 |
case 'mysql':
|
|
|
240 |
case 'mysqli':
|
|
|
241 |
CREATE TABLE {{TABLE_PREFIX}}online (
|
|
|
242 |
user_id INT(10) UNSIGNED NOT NULL DEFAULT 1,
|
|
|
243 |
ident VARCHAR(200) NOT NULL DEFAULT '',
|
|
|
244 |
logged INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
245 |
idle TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
246 |
csrf_token VARCHAR(40) NOT NULL DEFAULT '',
|
|
|
247 |
prev_url VARCHAR(255)
|
|
|
248 |
) TYPE=HEAP;
|
|
|
249 |
|
|
|
250 |
case 'pgsql':
|
|
|
251 |
CREATE TABLE {{TABLE_PREFIX}}online (
|
|
|
252 |
user_id INT NOT NULL DEFAULT 1,
|
|
|
253 |
ident VARCHAR(200) NOT NULL DEFAULT '',
|
|
|
254 |
logged INT NOT NULL DEFAULT 0,
|
|
|
255 |
idle SMALLINT NOT NULL DEFAULT 0,
|
|
|
256 |
csrf_token VARCHAR(40) NOT NULL DEFAULT '',
|
|
|
257 |
prev_url VARCHAR(255)
|
|
|
258 |
)
|
|
|
259 |
|
|
|
260 |
case 'mysql':
|
|
|
261 |
case 'mysqli':
|
|
|
262 |
CREATE TABLE {{TABLE_PREFIX}}posts (
|
|
|
263 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
264 |
poster VARCHAR(200) NOT NULL DEFAULT '',
|
|
|
265 |
poster_id INT(10) UNSIGNED NOT NULL DEFAULT 1,
|
|
|
266 |
poster_ip VARCHAR(15),
|
|
|
267 |
poster_email VARCHAR(80),
|
|
|
268 |
message TEXT,
|
|
|
269 |
hide_smilies TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
270 |
posted INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
271 |
edited INT(10) UNSIGNED,
|
|
|
272 |
edited_by VARCHAR(200),
|
|
|
273 |
topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
274 |
PRIMARY KEY (id)
|
|
|
275 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
276 |
|
|
|
277 |
case 'pgsql':
|
|
|
278 |
CREATE TABLE {{TABLE_PREFIX}}posts (
|
|
|
279 |
id SERIAL,
|
|
|
280 |
poster VARCHAR(200) NOT NULL DEFAULT '',
|
|
|
281 |
poster_id INT NOT NULL DEFAULT 1,
|
|
|
282 |
poster_ip VARCHAR(15),
|
|
|
283 |
poster_email VARCHAR(80),
|
|
|
284 |
message TEXT,
|
|
|
285 |
hide_smilies SMALLINT NOT NULL DEFAULT 0,
|
|
|
286 |
posted INT NOT NULL DEFAULT 0,
|
|
|
287 |
edited INT,
|
|
|
288 |
edited_by VARCHAR(200),
|
|
|
289 |
topic_id INT NOT NULL DEFAULT 0,
|
|
|
290 |
PRIMARY KEY (id)
|
|
|
291 |
)
|
|
|
292 |
|
|
|
293 |
case 'mysql':
|
|
|
294 |
case 'mysqli':
|
|
|
295 |
CREATE TABLE {{TABLE_PREFIX}}ranks (
|
|
|
296 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
297 |
rank VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
298 |
min_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
299 |
PRIMARY KEY (id)
|
|
|
300 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
301 |
|
|
|
302 |
case 'pgsql':
|
|
|
303 |
CREATE TABLE {{TABLE_PREFIX}}ranks (
|
|
|
304 |
id SERIAL,
|
|
|
305 |
rank VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
306 |
min_posts INT NOT NULL DEFAULT 0,
|
|
|
307 |
PRIMARY KEY (id)
|
|
|
308 |
)
|
|
|
309 |
|
|
|
310 |
case 'sqlite':
|
|
|
311 |
CREATE TABLE {{TABLE_PREFIX}}ranks (
|
|
|
312 |
id INTEGER NOT NULL,
|
|
|
313 |
rank VARCHAR(50) NOT NULL DEFAULT '',
|
|
|
314 |
min_posts INTEGER NOT NULL DEFAULT 0,
|
|
|
315 |
PRIMARY KEY (id)
|
|
|
316 |
)
|
|
|
317 |
|
|
|
318 |
case 'mysql':
|
|
|
319 |
case 'mysqli':
|
|
|
320 |
CREATE TABLE {{TABLE_PREFIX}}reports (
|
|
|
321 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
322 |
post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
323 |
topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
324 |
forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
325 |
reported_by INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
326 |
created INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
327 |
message TEXT,
|
|
|
328 |
zapped INT(10) UNSIGNED,
|
|
|
329 |
zapped_by INT(10) UNSIGNED,
|
|
|
330 |
PRIMARY KEY (id)
|
|
|
331 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
332 |
|
|
|
333 |
case 'pgsql':
|
|
|
334 |
CREATE TABLE {{TABLE_PREFIX}}reports (
|
|
|
335 |
id SERIAL,
|
|
|
336 |
post_id INT NOT NULL DEFAULT 0,
|
|
|
337 |
topic_id INT NOT NULL DEFAULT 0,
|
|
|
338 |
forum_id INT NOT NULL DEFAULT 0,
|
|
|
339 |
reported_by INT NOT NULL DEFAULT 0,
|
|
|
340 |
created INT NOT NULL DEFAULT 0,
|
|
|
341 |
message TEXT,
|
|
|
342 |
zapped INT,
|
|
|
343 |
zapped_by INT,
|
|
|
344 |
PRIMARY KEY (id)
|
|
|
345 |
)
|
|
|
346 |
|
|
|
347 |
case 'pgsql':
|
|
|
348 |
CREATE TABLE {{TABLE_PREFIX}}search_cache (
|
|
|
349 |
id INT NOT NULL DEFAULT 0,
|
|
|
350 |
ident VARCHAR(200) NOT NULL DEFAULT '',
|
|
|
351 |
search_data TEXT,
|
|
|
352 |
PRIMARY KEY (id)
|
|
|
353 |
)
|
|
|
354 |
|
|
|
355 |
case 'pgsql':
|
|
|
356 |
CREATE TABLE {{TABLE_PREFIX}}search_matches (
|
|
|
357 |
post_id INT NOT NULL DEFAULT 0,
|
|
|
358 |
word_id INT NOT NULL DEFAULT 0,
|
|
|
359 |
subject_match SMALLINT NOT NULL DEFAULT 0
|
|
|
360 |
)
|
|
|
361 |
|
|
|
362 |
case 'pgsql':
|
|
|
363 |
CREATE TABLE {{TABLE_PREFIX}}search_words (
|
|
|
364 |
id SERIAL,
|
|
|
365 |
word VARCHAR(20) NOT NULL DEFAULT '',
|
|
|
366 |
PRIMARY KEY (word)
|
|
|
367 |
)
|
|
|
368 |
|
|
|
369 |
case 'mysql':
|
|
|
370 |
case 'mysqli':
|
|
|
371 |
CREATE TABLE {{TABLE_PREFIX}}subscriptions (
|
|
|
372 |
user_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
373 |
topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
374 |
PRIMARY KEY (user_id, topic_id)
|
|
|
375 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
376 |
|
|
|
377 |
case 'pgsql':
|
|
|
378 |
CREATE TABLE {{TABLE_PREFIX}}subscriptions (
|
|
|
379 |
user_id INT NOT NULL DEFAULT 0,
|
|
|
380 |
topic_id INT NOT NULL DEFAULT 0,
|
|
|
381 |
PRIMARY KEY (user_id, topic_id)
|
|
|
382 |
)
|
|
|
383 |
|
|
|
384 |
case 'mysql':
|
|
|
385 |
case 'mysqli':
|
|
|
386 |
CREATE TABLE {{TABLE_PREFIX}}topics (
|
|
|
387 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
388 |
poster VARCHAR(200) NOT NULL DEFAULT '',
|
|
|
389 |
subject VARCHAR(255) NOT NULL DEFAULT '',
|
|
|
390 |
posted INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
391 |
first_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
392 |
last_post INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
393 |
last_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
394 |
last_poster VARCHAR(200),
|
|
|
395 |
num_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
396 |
num_replies MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
397 |
closed TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
398 |
sticky TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
399 |
moved_to INT(10) UNSIGNED,
|
|
|
400 |
forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
401 |
PRIMARY KEY (id)
|
|
|
402 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
403 |
|
|
|
404 |
case 'pgsql':
|
|
|
405 |
CREATE TABLE {{TABLE_PREFIX}}topics (
|
|
|
406 |
id SERIAL,
|
|
|
407 |
poster VARCHAR(200) NOT NULL DEFAULT '',
|
|
|
408 |
subject VARCHAR(255) NOT NULL DEFAULT '',
|
|
|
409 |
posted INT NOT NULL DEFAULT 0,
|
|
|
410 |
first_post_id INT NOT NULL DEFAULT 0,
|
|
|
411 |
last_post INT NOT NULL DEFAULT 0,
|
|
|
412 |
last_post_id INT NOT NULL DEFAULT 0,
|
|
|
413 |
last_poster VARCHAR(200),
|
|
|
414 |
num_views INT NOT NULL DEFAULT 0,
|
|
|
415 |
num_replies INT NOT NULL DEFAULT 0,
|
|
|
416 |
closed SMALLINT NOT NULL DEFAULT 0,
|
|
|
417 |
sticky SMALLINT NOT NULL DEFAULT 0,
|
|
|
418 |
moved_to INT,
|
|
|
419 |
forum_id INT NOT NULL DEFAULT 0,
|
|
|
420 |
PRIMARY KEY (id)
|
|
|
421 |
)
|
|
|
422 |
|
|
|
423 |
case 'mysql':
|
|
|
424 |
case 'mysqli':
|
|
|
425 |
CREATE TABLE {{TABLE_PREFIX}}users (
|
|
|
426 |
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
|
427 |
group_id INT(10) UNSIGNED NOT NULL DEFAULT 4,
|
|
|
428 |
username VARCHAR(200) NOT NULL DEFAULT '',
|
|
|
429 |
password VARCHAR(40) NOT NULL DEFAULT '',
|
|
|
430 |
salt VARCHAR(12),
|
|
|
431 |
email VARCHAR(80) NOT NULL DEFAULT '',
|
|
|
432 |
title VARCHAR(50),
|
|
|
433 |
realname VARCHAR(40),
|
|
|
434 |
url VARCHAR(100),
|
|
|
435 |
jabber VARCHAR(80),
|
|
|
436 |
icq VARCHAR(12),
|
|
|
437 |
msn VARCHAR(80),
|
|
|
438 |
aim VARCHAR(30),
|
|
|
439 |
yahoo VARCHAR(30),
|
|
|
440 |
location VARCHAR(30),
|
|
|
441 |
signature TEXT,
|
|
|
442 |
disp_topics TINYINT(3) UNSIGNED,
|
|
|
443 |
disp_posts TINYINT(3) UNSIGNED,
|
|
|
444 |
email_setting TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
445 |
save_pass TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
446 |
notify_with_post TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
447 |
auto_notify TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
448 |
show_smilies TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
449 |
show_img TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
450 |
show_img_sig TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
451 |
show_avatars TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
452 |
show_sig TINYINT(1) NOT NULL DEFAULT 1,
|
|
|
453 |
timezone FLOAT NOT NULL DEFAULT 0,
|
|
|
454 |
dst TINYINT(1) NOT NULL DEFAULT 0,
|
|
|
455 |
time_format INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
456 |
date_format INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
457 |
language VARCHAR(25) NOT NULL DEFAULT 'English',
|
|
|
458 |
style VARCHAR(25) NOT NULL DEFAULT 'Oxygen',
|
|
|
459 |
num_posts INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
460 |
last_post INT(10) UNSIGNED,
|
|
|
461 |
registered INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
462 |
registration_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
|
|
|
463 |
last_visit INT(10) UNSIGNED NOT NULL DEFAULT 0,
|
|
|
464 |
admin_note VARCHAR(30),
|
|
|
465 |
activate_string VARCHAR(80),
|
|
|
466 |
activate_key VARCHAR(8),
|
|
|
467 |
PRIMARY KEY (id)
|
|
|
468 |
) ENGINE = MyISAM CHARACTER SET utf8
|
|
|
469 |
|
|
|
470 |
case 'pgsql':
|
|
|
471 |
CREATE TABLE {{TABLE_PREFIX}}users (
|
|
|
472 |
id SERIAL,
|
|
|
473 |
group_id INT NOT NULL DEFAULT 4,
|
|
|
474 |
username VARCHAR(200) NOT NULL DEFAULT '',
|
|
|
475 |
password VARCHAR(40) NOT NULL DEFAULT '',
|
|
|
476 |
salt VARCHAR(12),
|
|
|
477 |
email VARCHAR(80) NOT NULL DEFAULT '',
|
|
|
478 |
title VARCHAR(50),
|
|
|
479 |
realname VARCHAR(40),
|
|
|
480 |
url VARCHAR(100),
|
|
|
481 |
jabber VARCHAR(80),
|
|
|
482 |
icq VARCHAR(12),
|
|
|
483 |
msn VARCHAR(80),
|
|
|
484 |
aim VARCHAR(30),
|
|
|
485 |
yahoo VARCHAR(30),
|
|
|
486 |
location VARCHAR(30),
|
|
|
487 |
signature TEXT,
|
|
|
488 |
disp_topics SMALLINT,
|
|
|
489 |
disp_posts SMALLINT,
|
|
|
490 |
email_setting SMALLINT NOT NULL DEFAULT 1,
|
|
|
491 |
save_pass SMALLINT NOT NULL DEFAULT 1,
|
|
|
492 |
notify_with_post SMALLINT NOT NULL DEFAULT 0,
|
|
|
493 |
auto_notify SMALLINT NOT NULL DEFAULT 0,
|
|
|
494 |
show_smilies SMALLINT NOT NULL DEFAULT 1,
|
|
|
495 |
show_img SMALLINT NOT NULL DEFAULT 1,
|
|
|
496 |
show_img_sig SMALLINT NOT NULL DEFAULT 1,
|
|
|
497 |
show_avatars SMALLINT NOT NULL DEFAULT 1,
|
|
|
498 |
show_sig SMALLINT NOT NULL DEFAULT 1,
|
|
|
499 |
timezone REAL NOT NULL DEFAULT 0,
|
|
|
500 |
dst SMALLINT NOT NULL DEFAULT 0,
|
|
|
501 |
time_format INT NOT NULL DEFAULT 0,
|
|
|
502 |
date_format INT NOT NULL DEFAULT 0,
|
|
|
503 |
language VARCHAR(25) NOT NULL DEFAULT 'English',
|
|
|
504 |
style VARCHAR(25) NOT NULL DEFAULT 'Oxygen',
|
|
|
505 |
num_posts INT NOT NULL DEFAULT 0,
|
|
|
506 |
last_post INT,
|
|
|
507 |
registered INT NOT NULL DEFAULT 0,
|
|
|
508 |
registration_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
|
|
|
509 |
last_visit INT NOT NULL DEFAULT 0,
|
|
|
510 |
admin_note VARCHAR(30),
|
|
|
511 |
activate_string VARCHAR(80),
|
|
|
512 |
activate_key VARCHAR(8),
|
|
|
513 |
PRIMARY KEY (id)
|
|
|
514 |
)
|
|
|
515 |
|
|
|
516 |
case 'mysql':
|
|
|
517 |
case 'mysqli':
|
|
|
518 |
// mysql
|
|
|
519 |
ALTER TABLE {{TABLE_PREFIX}}online ADD UNIQUE INDEX {{TABLE_PREFIX}}online_user_id_ident_idx(user_id,ident(25));
|
|
|
520 |
ALTER TABLE {{TABLE_PREFIX}}online ADD INDEX {{TABLE_PREFIX}}online_user_id_idx(user_id);
|
|
|
521 |
ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_topic_id_idx(topic_id);
|
|
|
522 |
ALTER TABLE {{TABLE_PREFIX}}posts ADD INDEX {{TABLE_PREFIX}}posts_multi_idx(poster_id, topic_id);
|
|
|
523 |
ALTER TABLE {{TABLE_PREFIX}}posts ADD FULLTEXT {{TABLE_PREFIX}}posts_message_idx(message);
|
|
|
524 |
ALTER TABLE {{TABLE_PREFIX}}reports ADD INDEX {{TABLE_PREFIX}}reports_zapped_idx(zapped);
|
|
|
525 |
ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_forum_id_idx(forum_id);
|
|
|
526 |
ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_moved_to_idx(moved_to);
|
|
|
527 |
ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_last_post_idx(last_post);
|
|
|
528 |
ALTER TABLE {{TABLE_PREFIX}}topics ADD INDEX {{TABLE_PREFIX}}topics_first_post_id_idx(first_post_id);
|
|
|
529 |
ALTER TABLE {{TABLE_PREFIX}}topics ADD FULLTEXT {{TABLE_PREFIX}}topics_subject_idx(subject);
|
|
|
530 |
ALTER TABLE {{TABLE_PREFIX}}users ADD INDEX {{TABLE_PREFIX}}users_registered_idx(registered);
|
|
|
531 |
ALTER TABLE {{TABLE_PREFIX}}users ADD INDEX {{TABLE_PREFIX}}users_username_idx(username(8));
|
|
|
532 |
|
|
|
533 |
// pgsql
|
|
|
534 |
CREATE UNIQUE INDEX {{TABLE_PREFIX}}online_user_id_ident_idx ON {{TABLE_PREFIX}}online(user_id,ident);
|
|
|
535 |
CREATE INDEX {{TABLE_PREFIX}}online_user_id_idx ON {{TABLE_PREFIX}}online(user_id);
|
|
|
536 |
CREATE INDEX {{TABLE_PREFIX}}posts_topic_id_idx ON {{TABLE_PREFIX}}posts(topic_id);
|
|
|
537 |
CREATE INDEX {{TABLE_PREFIX}}posts_multi_idx ON {{TABLE_PREFIX}}posts(poster_id, topic_id);
|
|
|
538 |
CREATE INDEX {{TABLE_PREFIX}}reports_zapped_idx ON {{TABLE_PREFIX}}reports(zapped);
|
|
|
539 |
CREATE INDEX {{TABLE_PREFIX}}search_matches_word_id_idx ON {{TABLE_PREFIX}}search_matches(word_id);
|
|
|
540 |
CREATE INDEX {{TABLE_PREFIX}}search_matches_post_id_idx ON {{TABLE_PREFIX}}search_matches(post_id);
|
|
|
541 |
CREATE INDEX {{TABLE_PREFIX}}topics_forum_id_idx ON {{TABLE_PREFIX}}topics(forum_id);
|
|
|
542 |
CREATE INDEX {{TABLE_PREFIX}}topics_moved_to_idx ON {{TABLE_PREFIX}}topics(moved_to);
|
|
|
543 |
CREATE INDEX {{TABLE_PREFIX}}topics_last_post_idx ON {{TABLE_PREFIX}}topics(last_post);
|
|
|
544 |
CREATE INDEX {{TABLE_PREFIX}}topics_first_post_id_idx ON {{TABLE_PREFIX}}topics(first_post_id);
|
|
|
545 |
CREATE INDEX {{TABLE_PREFIX}}users_registered_idx ON {{TABLE_PREFIX}}users(registered);
|
|
|
546 |
CREATE INDEX {{TABLE_PREFIX}}users_username_idx ON {{TABLE_PREFIX}}users(username);
|
|
|
547 |
CREATE INDEX {{TABLE_PREFIX}}search_cache_ident_idx ON {{TABLE_PREFIX}}search_cache(ident);
|
|
|
548 |
CREATE INDEX {{TABLE_PREFIX}}search_words_id_idx ON {{TABLE_PREFIX}}search_words(id);
|
|
|
549 |
|