1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
| CREATE TABLE categories
(
cat_id mediumint(8) UNSIGNED NOT NULL auto_increment,
name varchar(255) DEFAULT '' NOT NULL,
image_type tinyint(4) UNSIGNED DEFAULT '0',
location mediumint(8) UNSIGNED DEFAULT '0',
posttime int(11) UNSIGNED DEFAULT '0' NOT NULL,
postuser_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
module_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
cat_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
modified int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
is_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (cat_id),
KEY image_type(image_type),
KEY location(location),
KEY posttime(posttime),
KEY postuser_id(postuser_id),
KEY module_id(module_id),
KEY cat_order(cat_order),
KEY modified(modified),
KEY modified_count(modified_count)
)CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE attachments_categories
(
attachment_module_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
cat_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (attachment_module_id),
KEY cat_id(cat_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE wordlist
(
word_id mediumint(8) UNSIGNED NOT NULL auto_increment,
word_text varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (word_id),
UNIQUE word_text(word_text)
)CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE search_words_ids
(
module_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
type_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
word_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY module_id(module_id,word_id),
KEY type_id(type_id),
KEY word_id(word_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE modules_attachments
(
module_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
module_desc varchar(100) DEFAULT '' NOT NULL,
mimetype varchar(100) DEFAULT '' NOT NULL,
module_file varchar(255) DEFAULT '' NOT NULL,
module_class varchar(100) DEFAULT '' NOT NULL,
icon_mimetype varchar(100) DEFAULT '' NOT NULL,
icon_desc varchar(255) DEFAULT '' NOT NULL,
icon_name int(11) UNSIGNED DEFAULT '0' NOT NULL,
icon_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
icon_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
module_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
module_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (module_id),
KEY icon_name(icon_name),
KEY module_order(module_order),
KEY module_active(module_active)
)CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE languages
(
lang_id mediumint(8) UNSIGNED NOT NULL auto_increment,
lang_name varchar(50) DEFAULT '' NOT NULL,
lang_desc varchar(255) DEFAULT '' NOT NULL,
installtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified int(11) UNSIGNED DEFAULT '0' NOT NULL,
active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (lang_id),
KEY installtime(installtime),
KEY modified(modified)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE languages_array
(
langkey varchar(255) DEFAULT '' NOT NULL,
lang_value text DEFAULT '' NOT NULL,
lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
postuserid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
posttime int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (lang_id,langkey),
KEY lang_id(lang_id),
KEY modified_userid(modified_userid),
KEY modified(modified),
KEY postuserid(postuserid),
KEY posttime(posttime)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE config
(
config_name varchar(255) DEFAULT '' NOT NULL,
config_value text DEFAULT '' NOT NULL,
PRIMARY KEY config_name(config_name)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE modules
(
module_id mediumint(8) UNSIGNED NOT NULL auto_increment,
module_name varchar(255) DEFAULT '' NOT NULL,
module_desclang varchar(50) DEFAULT '',
module_file varchar(255) DEFAULT '',
module_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY(module_id),
KEY module_time(module_time),
KEY active(active)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE menu
(
menu_id mediumint(8) UNSIGNED auto_increment NOT NULL,
lang_key varchar(255) DEFAULT '' NOT NULL,
location_url text DEFAULT '' NOT NULL,
posttime int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified int(11) UNSIGNED DEFAULT '0' NOT NULL,
show_in_module_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (menu_id),
KEY posttime(posttime),
KEY modified(modified),
KEY show_in_module_id(show_in_module_id),
KEY active(active)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE users
(
userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
username varchar(32) NOT NULL DEFAULT '',
password varchar(33) NOT NULL DEFAULT '',
register_date int(11) UNSIGNED DEFAULT '0' NOT NULL,
download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
userlang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
login_in tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY userid(userid),
UNIQUE username(username),
KEY register_date(register_date),
KEY download_count(download_count),
KEY userlang_id(userlang_id),
KEY login_in(login_in),
KEY active(active)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE text_replace
(
pattern varchar(255) DEFAULT '' NOT NULL,
replaced mediumtext DEFAULT '' NOT NULL,
module_id mediumint(1) UNSIGNED DEFAULT '0' NOT NULL,
is_preg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (pattern),
KEY module_id(module_id),
KEY is_preg(is_preg)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE sites
(
site_id mediumint(8) UNSIGNED NOT NULL auto_increment,
site_host varchar(150) DEFAULT '' NOT NULL,
port smallint(4) UNSIGNED DEFAULT '80' NOT NULL,
site_ssl tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY site_id(site_id),
UNIQUE site_host(site_host),
KEY site_ssl(site_ssl),
KEY active(active)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE sites_paths
(
path_id mediumint(8) UNSIGNED NOT NULL auto_increment,
uri_path text DEFAULT '' NOT NULL,
PRIMARY KEY (path_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE sites_querys
(
query_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
site_query text DEFAULT '',
PRIMARY KEY query_id(query_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE attachments
(
fileid varchar(100) DEFAULT '' NOT NULL,
filename varchar(255) DEFAULT '' NOT NULL,
real_filename varchar(255) DEFAULT '' NOT NULL,
filedesc text DEFAULT '',
query_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
path_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
site_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified int(11) UNSIGNED DEFAULT '0' NOT NULL,
postuserip int(11) UNSIGNED DEFAULT '0' NOT NULL,
postuserid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
modified_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
module_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
modified_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
downloads mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
is_archive tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
is_audio tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
is_video tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY(fileid),
KEY query_id(query_id),
KEY path_id(path_id),
KEY site_id(site_id),
KEY filesize(filesize),
KEY filetime(filetime),
KEY modified(modified),
KEY postuserip(postuserip),
KEY postuserid(postuserid),
KEY module_id(module_id),
KEY modified_count(modified_count),
KEY downloads(downloads),
KEY is_archive(is_archive),
KEY is_audio(is_audio),
KEY is_video(is_video)
)CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE attachments_archive_files
(
afileid mediumint(8) UNSIGNED NOT NULL auto_increment,
attachment_id varchar(100) DEFAULT '' NOT NULL,
afilename varchar(255) DEFAULT '0' NOT NULL,
afilesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
afiletime int(11) UNSIGNED DEFAULT '0' NOT NULL,
afmodified int(11) UNSIGNED DEFAULT '0' NOT NULL,
afhidden tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
isdir tinyint(1) UNSIGNED DEFAULT '0' NOT NULl,
dir mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY afileid(afileid,attachment_id),
KEY afilesize(afilesize),
KEY afiletime(afiletime),
KEY afmodified(afmodified),
KEY afhidden(afhidden),
KEY isdir(isdir),
KEY dir(dir)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE modifications_artists
(
artist_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
modified_artist varchar(255) DEFAULT '0' NOT NULL,
artist_info text DEFAULT '',
modified_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
modified int(11) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY artist_id(artist_id,modified_userid),
KEY modified_userid(modified_userid),
KEY modified(modified)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE artists
(
artist_id mediumint(8) UNSIGNED NOT NULL auto_increment,
artist varchar(255) DEFAULT '' NOT NULL,
artist_info text DEFAULT '',
posttime int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
modified_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY artist_id(artist_id),
UNIQUE artist(artist),
KEY posttime(posttime),
KEY modified(modified),
KEY modified_userid(modified_userid),
KEY modified_count(modified_count),
KEY active(active)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE groups
(
group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
artist_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY group_id(group_id,artist_id),
KEY artist_id(artist_id)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE albums
(
album_id mediumint(8) UNSIGNED NOT NULL auto_increment,
name varchar(255) DEFAULT '' NOT NULL,
artist_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
posttime int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
post_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
modified_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (album_id),
UNIQUE name(name),
KEY artist_id(artist_id,group_id),
KEY posttime(posttime),
KEY modified(modified),
KEY modified_count(modified_count),
KEY post_userid(post_userid),
KEY modified_userid(modified_userid)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE pesni
(
pesen_id mediumint(8) UNSIGNED NOT NULL auto_increment,
name varchar(100) DEFAULT '' NOT NULL,
artist_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
album_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
pesen_text text DEFAULT '',
posttime int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified int(11) UNSIGNED DEFAULT '0' NOT NULL,
modified_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
post_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
modified_userid mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (pesen_id),
UNIQUE name(name),
KEY artist_id(artist_id,group_id),
KEY album_id(album_id),
KEY posttime(posttime),
KEY modified(modified),
KEY modified_count(modified_count),
KEY post_userid(post_userid),
KEY modified_userid(modified_userid)
) CHARACTER SET `utf8` COLLATE `utf8_bin`;
CREATE TABLE attachments_video
(
attachment_id varchar(100) DEFAULT '0' NOT NULL,
width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
has_video tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
videocodec tinyint(2) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (attachment_id),
KEY has_video(has_video),
KEY videocodec(videocodec)
) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
