-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy pathinstall.sql
267 lines (253 loc) · 10.4 KB
/
install.sql
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
DROP TABLE IF EXISTS wsif1_1_category;
CREATE TABLE wsif1_1_category (
categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
parentID INT(10) NOT NULL DEFAULT 0,
category VARCHAR(255) NOT NULL DEFAULT '',
allowDescriptionHtml TINYINT(1) NOT NULL DEFAULT 0,
categoryType TINYINT(1) NOT NULL DEFAULT 0,
icon VARCHAR(255) NOT NULL DEFAULT '',
externalURL VARCHAR(255) NOT NULL DEFAULT '',
time INT(10) NOT NULL DEFAULT 0,
styleID INT(10) NOT NULL DEFAULT 0,
enforceStyle TINYINT(1) NOT NULL DEFAULT 0,
daysPrune SMALLINT(5) NOT NULL DEFAULT 0,
sortField VARCHAR(20) NOT NULL DEFAULT '',
sortOrder VARCHAR(4) NOT NULL DEFAULT '',
clicks INT(10) NOT NULL DEFAULT 0,
entries INT(10) NOT NULL DEFAULT 0,
entryComments INT(10) NOT NULL DEFAULT 0,
entryImages INT(10) NOT NULL DEFAULT 0,
entryFiles INT(10) NOT NULL DEFAULT 0,
entryDownloads INT(10) NOT NULL DEFAULT 0,
enableRating TINYINT(1) NOT NULL DEFAULT -1,
entriesPerPage SMALLINT(5) NOT NULL DEFAULT 0,
showOrder INT(10) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_category_last_entry;
CREATE TABLE wsif1_1_category_last_entry (
categoryID INT(10) NOT NULL DEFAULT 0,
languageID INT(10) NOT NULL DEFAULT 0,
entryID INT(10) NOT NULL DEFAULT 0,
PRIMARY KEY (categoryID, languageID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_category_moderator;
CREATE TABLE wsif1_1_category_moderator (
categoryID INT(10) NOT NULL DEFAULT 0,
userID INT(10) NOT NULL DEFAULT 0,
groupID INT(10) NOT NULL DEFAULT 0,
canEditEntry TINYINT(1) NOT NULL DEFAULT -1,
canDeleteEntry TINYINT(1) NOT NULL DEFAULT -1,
canViewDeletedEntry TINYINT(1) NOT NULL DEFAULT -1,
canDeleteEntryCompletely TINYINT(1) NOT NULL DEFAULT -1,
canEnableEntry TINYINT(1) NOT NULL DEFAULT -1,
canMoveEntry TINYINT(1) NOT NULL DEFAULT -1,
canEditEntryComment TINYINT(1) NOT NULL DEFAULT -1,
canDeleteEntryComment TINYINT(1) NOT NULL DEFAULT -1,
canEditEntryImage TINYINT(1) NOT NULL DEFAULT -1,
canDeleteEntryImage TINYINT(1) NOT NULL DEFAULT -1,
canEditEntryFile TINYINT(1) NOT NULL DEFAULT -1,
canDeleteEntryFile TINYINT(1) NOT NULL DEFAULT -1,
KEY (userID),
KEY (groupID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_category_to_group;
CREATE TABLE wsif1_1_category_to_group (
categoryID INT(10) NOT NULL DEFAULT 0,
groupID INT(10) NOT NULL DEFAULT 0,
canViewCategory TINYINT(1) NOT NULL DEFAULT -1,
canEnterCategory TINYINT(1) NOT NULL DEFAULT -1,
canViewEntry TINYINT(1) NOT NULL DEFAULT -1,
canViewOwnEntry TINYINT(1) NOT NULL DEFAULT -1,
canAddEntry TINYINT(1) NOT NULL DEFAULT -1,
canAddEntryWithoutModeration TINYINT(1) NOT NULL DEFAULT -1,
canRateEntry TINYINT(1) NOT NULL DEFAULT -1,
canEditOwnEntry TINYINT(1) NOT NULL DEFAULT -1,
canDeleteOwnEntry TINYINT(1) NOT NULL DEFAULT -1,
canSetEntryPrefix TINYINT(1) NOT NULL DEFAULT -1,
canSetEntryTags TINYINT(1) NOT NULL DEFAULT -1,
canCommentEntry TINYINT(1) NOT NULL DEFAULT -1,
canEditOwnEntryComment TINYINT(1) NOT NULL DEFAULT -1,
canDeleteOwnEntryComment TINYINT(1) NOT NULL DEFAULT -1,
canDownloadEntryCommentAttachment TINYINT(1) NOT NULL DEFAULT -1,
canViewEntryCommentAttachmentPreview TINYINT(1) NOT NULL DEFAULT -1,
canUploadEntryCommentAttachment TINYINT(1) NOT NULL DEFAULT -1,
canEditOwnEntryImage TINYINT(1) NOT NULL DEFAULT -1,
canDeleteOwnEntryImage TINYINT(1) NOT NULL DEFAULT -1,
canDownloadEntryFile TINYINT(1) NOT NULL DEFAULT -1,
canEditOwnEntryFile TINYINT(1) NOT NULL DEFAULT -1,
canDeleteOwnEntryFile TINYINT(1) NOT NULL DEFAULT -1,
PRIMARY KEY (groupID, categoryID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_category_to_user;
CREATE TABLE wsif1_1_category_to_user (
categoryID INT(10) NOT NULL DEFAULT 0,
userID INT(10) NOT NULL DEFAULT 0,
canViewCategory TINYINT(1) NOT NULL DEFAULT -1,
canEnterCategory TINYINT(1) NOT NULL DEFAULT -1,
canViewEntry TINYINT(1) NOT NULL DEFAULT -1,
canViewOwnEntry TINYINT(1) NOT NULL DEFAULT -1,
canAddEntry TINYINT(1) NOT NULL DEFAULT -1,
canAddEntryWithoutModeration TINYINT(1) NOT NULL DEFAULT -1,
canRateEntry TINYINT(1) NOT NULL DEFAULT -1,
canEditOwnEntry TINYINT(1) NOT NULL DEFAULT -1,
canDeleteOwnEntry TINYINT(1) NOT NULL DEFAULT -1,
canSetEntryPrefix TINYINT(1) NOT NULL DEFAULT -1,
canSetEntryTags TINYINT(1) NOT NULL DEFAULT -1,
canCommentEntry TINYINT(1) NOT NULL DEFAULT -1,
canEditOwnEntryComment TINYINT(1) NOT NULL DEFAULT -1,
canDeleteOwnEntryComment TINYINT(1) NOT NULL DEFAULT -1,
canDownloadEntryCommentAttachment TINYINT(1) NOT NULL DEFAULT -1,
canViewEntryCommentAttachmentPreview TINYINT(1) NOT NULL DEFAULT -1,
canUploadEntryCommentAttachment TINYINT(1) NOT NULL DEFAULT -1,
canEditOwnEntryImage TINYINT(1) NOT NULL DEFAULT -1,
canDeleteOwnEntryImage TINYINT(1) NOT NULL DEFAULT -1,
canDownloadEntryFile TINYINT(1) NOT NULL DEFAULT -1,
canEditOwnEntryFile TINYINT(1) NOT NULL DEFAULT -1,
canDeleteOwnEntryFile TINYINT(1) NOT NULL DEFAULT -1,
PRIMARY KEY (userID, categoryID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_entry;
CREATE TABLE wsif1_1_entry (
entryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
categoryID INT(10) NOT NULL DEFAULT 0,
languageID INT(10) NOT NULL DEFAULT 0,
prefixID INT(10) NOT NULL DEFAULT 0,
userID INT(10) NOT NULL DEFAULT 0,
username VARCHAR(255) NOT NULL DEFAULT '',
subject VARCHAR(255) NOT NULL DEFAULT '',
message MEDIUMTEXT NOT NULL,
teaser TINYTEXT,
time INT(10) NOT NULL DEFAULT 0,
publishingTime INT(10) NOT NULL DEFAULT 0,
defaultImageID INT(10) NOT NULL DEFAULT 0,
defaultFileID INT(10) NOT NULL DEFAULT 0,
comments MEDIUMINT(7) NOT NULL DEFAULT 0,
images MEDIUMINT(7) NOT NULL DEFAULT 0,
files MEDIUMINT(7) NOT NULL DEFAULT 0,
downloads MEDIUMINT(7) NOT NULL DEFAULT 0,
views MEDIUMINT(7) NOT NULL DEFAULT 0,
ratings SMALLINT(5) NOT NULL DEFAULT 0,
rating MEDIUMINT(7) NOT NULL DEFAULT 0,
everEnabled TINYINT(1) NOT NULL DEFAULT 1,
isDisabled TINYINT(1) NOT NULL DEFAULT 0,
isDeleted TINYINT(1) NOT NULL DEFAULT 0,
deleteTime INT(10) NOT NULL DEFAULT 0,
deletedBy VARCHAR(255) NOT NULL DEFAULT '',
deletedByID INT(10) NOT NULL DEFAULT 0,
deleteReason TEXT,
enableSmilies TINYINT(1) NOT NULL DEFAULT 1,
enableHtml TINYINT(1) NOT NULL DEFAULT 0,
enableBBCodes TINYINT(1) NOT NULL DEFAULT 1,
enableComments TINYINT(1) NOT NULL DEFAULT 1,
ipAddress VARCHAR(15) NOT NULL DEFAULT '',
FULLTEXT KEY (subject, message),
KEY (languageID),
KEY (categoryID, isDeleted, isDisabled, time),
KEY (isDeleted),
KEY (isDisabled),
KEY (userID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_entry_comment;
CREATE TABLE wsif1_1_entry_comment (
commentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
entryID INT(10) NOT NULL DEFAULT 0,
userID INT(10) NOT NULL DEFAULT 0,
username VARCHAR(255) NOT NULL DEFAULT '',
subject VARCHAR(255) NOT NULL DEFAULT '',
message MEDIUMTEXT NOT NULL,
time INT(10) NOT NULL DEFAULT 0,
attachments SMALLINT(5) NOT NULL DEFAULT 0,
enableSmilies TINYINT(1) NOT NULL DEFAULT 1,
enableHtml TINYINT(1) NOT NULL DEFAULT 0,
enableBBCodes TINYINT(1) NOT NULL DEFAULT 1,
ipAddress VARCHAR(15) NOT NULL DEFAULT '',
KEY (entryID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_entry_file;
CREATE TABLE wsif1_1_entry_file (
fileID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
entryID INT(10) NOT NULL DEFAULT 0,
userID INT(10) NOT NULL DEFAULT 0,
username VARCHAR(255) NOT NULL DEFAULT '',
isDefault TINYINT(1) NOT NULL DEFAULT 0,
title VARCHAR(255) NOT NULL DEFAULT '',
description MEDIUMTEXT,
fileType TINYINT(1) NOT NULL DEFAULT 0,
filename VARCHAR(255) NOT NULL DEFAULT '',
filesize INT(20) NOT NULL DEFAULT 0,
externalURL VARCHAR(255) NOT NULL DEFAULT '',
mimeType VARCHAR(255) NOT NULL DEFAULT '',
uploadTime INT(10) NOT NULL DEFAULT 0,
views MEDIUMINT(7) NOT NULL DEFAULT 0,
downloads MEDIUMINT(7) NOT NULL DEFAULT 0,
lastDownloadTime INT(10) NOT NULL DEFAULT 0,
sha1Hash VARCHAR(40) NOT NULL DEFAULT '',
ipAddress VARCHAR(15) NOT NULL DEFAULT '',
KEY (entryID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_entry_file_downloader;
CREATE TABLE wsif1_1_entry_file_downloader (
fileID INT(10) NOT NULL,
userID INT(10) NOT NULL DEFAULT 0,
time INT(10) NOT NULL DEFAULT 0,
UNIQUE KEY (fileID, userID),
KEY (time)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_entry_image;
CREATE TABLE wsif1_1_entry_image (
imageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
entryID INT(10) NOT NULL DEFAULT 0,
userID INT(10) NOT NULL DEFAULT 0,
username VARCHAR(255) NOT NULL DEFAULT '',
isDefault TINYINT(1) NOT NULL DEFAULT 0,
title VARCHAR(255) NOT NULL DEFAULT '',
description TEXT NULL,
filename VARCHAR(255) NOT NULL DEFAULT '',
filesize INT(10) NOT NULL DEFAULT 0,
mimeType VARCHAR(255) NOT NULL DEFAULT '',
uploadTime INT(10) NOT NULL DEFAULT 0,
width SMALLINT(5) NOT NULL DEFAULT 0,
height SMALLINT(5) NOT NULL DEFAULT 0,
hasThumbnail VARCHAR(255) NOT NULL DEFAULT '',
thumbnailMimeType VARCHAR(255) NOT NULL DEFAULT '',
thumbnailFilesize INT(10) NOT NULL DEFAULT 0,
thumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
thumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
views MEDIUMINT(8) NOT NULL DEFAULT 0,
ipAddress VARCHAR(15) NOT NULL DEFAULT '',
KEY (entryID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_entry_prefix;
CREATE TABLE wsif1_1_entry_prefix (
prefixID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
prefix VARCHAR(255) NOT NULL DEFAULT '',
prefixMarking VARCHAR(255) NOT NULL DEFAULT '%s',
prefixType TINYINT(1) NOT NULL DEFAULT 0,
showOrder INT(10) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_entry_prefix_to_category;
CREATE TABLE wsif1_1_entry_prefix_to_category (
categoryID INT(10) NOT NULL,
prefixID INT(10) NOT NULL,
PRIMARY KEY (categoryID, prefixID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_entry_subscription;
CREATE TABLE wsif1_1_entry_subscription (
userID INT(10) NOT NULL DEFAULT 0,
entryID INT(10) NOT NULL DEFAULT 0,
PRIMARY KEY (userID, entryID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_entry_visitor;
CREATE TABLE wsif1_1_entry_visitor (
entryID INT(10) NOT NULL,
userID INT(10) NOT NULL DEFAULT 0,
time INT(10) NOT NULL DEFAULT 0,
UNIQUE KEY (entryID, userID),
KEY (time)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS wsif1_1_user;
CREATE TABLE wsif1_1_user (
userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
entries SMALLINT(5) NOT NULL DEFAULT 0,
KEY (entries)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;