slitaz-forge view forum/mysql/vanilla-2.0.16.sql @ rev 0

Adding system and vanilla config files for the forum
author Eric Joseph-Alexandre <erjo@slitaz.org>
date Wed Dec 22 10:25:56 2010 +0100 (2010-12-22)
parents
children
line source
1 -- MySQL dump 10.11
2 --
3 -- Host: localhost Database: slitaz_forum
4 -- ------------------------------------------------------
5 -- Server version 5.0.32-Debian_7etch12-log
6
7 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10 /*!40101 SET NAMES utf8 */;
11 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12 /*!40103 SET TIME_ZONE='+00:00' */;
13 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18 --
19 -- Table structure for table `GDN_Activity`
20 --
21
22 DROP TABLE IF EXISTS `GDN_Activity`;
23 CREATE TABLE `GDN_Activity` (
24 `ActivityID` int(11) NOT NULL auto_increment,
25 `CommentActivityID` int(11) default NULL,
26 `ActivityTypeID` int(11) NOT NULL,
27 `ActivityUserID` int(11) default NULL,
28 `RegardingUserID` int(11) default NULL,
29 `Story` text collate utf8_unicode_ci,
30 `Route` varchar(255) collate utf8_unicode_ci default NULL,
31 `CountComments` int(11) NOT NULL default '0',
32 `InsertUserID` int(11) default NULL,
33 `DateInserted` datetime NOT NULL,
34 PRIMARY KEY (`ActivityID`),
35 KEY `FK_Activity_CommentActivityID` (`CommentActivityID`),
36 KEY `FK_Activity_ActivityUserID` (`ActivityUserID`),
37 KEY `FK_Activity_InsertUserID` (`InsertUserID`)
38 ) ENGINE=MyISAM AUTO_INCREMENT=11612 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
39
40 --
41 -- Table structure for table `GDN_ActivityType`
42 --
43
44 DROP TABLE IF EXISTS `GDN_ActivityType`;
45 CREATE TABLE `GDN_ActivityType` (
46 `ActivityTypeID` int(11) NOT NULL auto_increment,
47 `Name` varchar(20) collate utf8_unicode_ci NOT NULL,
48 `AllowComments` tinyint(1) NOT NULL default '0',
49 `ShowIcon` tinyint(1) NOT NULL default '0',
50 `ProfileHeadline` varchar(255) collate utf8_unicode_ci NOT NULL,
51 `FullHeadline` varchar(255) collate utf8_unicode_ci NOT NULL,
52 `RouteCode` varchar(255) collate utf8_unicode_ci default NULL,
53 `Notify` tinyint(1) NOT NULL default '0',
54 `Public` tinyint(1) NOT NULL default '1',
55 PRIMARY KEY (`ActivityTypeID`)
56 ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
57
58 --
59 -- Table structure for table `GDN_Category`
60 --
61
62 DROP TABLE IF EXISTS `GDN_Category`;
63 CREATE TABLE `GDN_Category` (
64 `CategoryID` int(11) NOT NULL auto_increment,
65 `ParentCategoryID` int(11) default NULL,
66 `CountDiscussions` int(11) NOT NULL default '0',
67 `AllowDiscussions` tinyint(4) NOT NULL default '1',
68 `Name` varchar(30) collate utf8_unicode_ci NOT NULL,
69 `Description` varchar(250) collate utf8_unicode_ci default NULL,
70 `Sort` int(11) default NULL,
71 `InsertUserID` int(11) NOT NULL,
72 `UpdateUserID` int(11) default NULL,
73 `DateInserted` datetime NOT NULL,
74 `DateUpdated` datetime NOT NULL,
75 `UrlCode` varchar(30) collate utf8_unicode_ci default NULL,
76 PRIMARY KEY (`CategoryID`),
77 KEY `FK_Category_InsertUserID` (`InsertUserID`)
78 ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
79
80 --
81 -- Table structure for table `GDN_Comment`
82 --
83
84 DROP TABLE IF EXISTS `GDN_Comment`;
85 CREATE TABLE `GDN_Comment` (
86 `CommentID` int(11) NOT NULL auto_increment,
87 `DiscussionID` int(11) NOT NULL,
88 `InsertUserID` int(11) default NULL,
89 `UpdateUserID` int(11) default NULL,
90 `DeleteUserID` int(11) default NULL,
91 `Body` text collate utf8_unicode_ci NOT NULL,
92 `Format` varchar(20) collate utf8_unicode_ci default NULL,
93 `DateInserted` datetime default NULL,
94 `DateDeleted` datetime default NULL,
95 `DateUpdated` datetime default NULL,
96 `Flag` tinyint(4) NOT NULL default '0',
97 `ReplyCommentID` int(11) default NULL,
98 `CountReplies` int(11) NOT NULL default '0',
99 `Score` float default NULL,
100 `Attributes` text collate utf8_unicode_ci,
101 PRIMARY KEY (`CommentID`),
102 KEY `FK_Comment_DiscussionID` (`DiscussionID`),
103 KEY `FK_Comment_InsertUserID` (`InsertUserID`),
104 KEY `FK_Comment_ReplyCommentID` (`ReplyCommentID`),
105 KEY `FK_Comment_DateInserted` (`DateInserted`),
106 FULLTEXT KEY `TX_Comment` (`Body`)
107 ) ENGINE=MyISAM AUTO_INCREMENT=10904 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
108
109 --
110 -- Table structure for table `GDN_CommentWatch`
111 --
112
113 DROP TABLE IF EXISTS `GDN_CommentWatch`;
114 CREATE TABLE `GDN_CommentWatch` (
115 `UserID` int(11) NOT NULL,
116 `CommentID` int(11) NOT NULL,
117 `DateLastViewed` datetime NOT NULL,
118 `CountReplies` int(11) NOT NULL default '0',
119 PRIMARY KEY (`UserID`,`CommentID`)
120 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
121
122 --
123 -- Table structure for table `GDN_Conversation`
124 --
125
126 DROP TABLE IF EXISTS `GDN_Conversation`;
127 CREATE TABLE `GDN_Conversation` (
128 `ConversationID` int(11) NOT NULL auto_increment,
129 `Contributors` varchar(255) collate utf8_unicode_ci NOT NULL,
130 `FirstMessageID` int(11) default NULL,
131 `InsertUserID` int(11) NOT NULL,
132 `DateInserted` datetime default NULL,
133 `UpdateUserID` int(11) NOT NULL,
134 `DateUpdated` datetime NOT NULL,
135 `CountMessages` int(11) NOT NULL,
136 `LastMessageID` int(11) NOT NULL,
137 PRIMARY KEY (`ConversationID`),
138 KEY `FK_Conversation_FirstMessageID` (`FirstMessageID`),
139 KEY `FK_Conversation_InsertUserID` (`InsertUserID`),
140 KEY `FK_Conversation_UpdateUserID` (`UpdateUserID`),
141 KEY `FK_Conversation_DateInserted` (`DateInserted`)
142 ) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
143
144 --
145 -- Table structure for table `GDN_ConversationMessage`
146 --
147
148 DROP TABLE IF EXISTS `GDN_ConversationMessage`;
149 CREATE TABLE `GDN_ConversationMessage` (
150 `MessageID` int(11) NOT NULL auto_increment,
151 `ConversationID` int(11) NOT NULL,
152 `Body` text collate utf8_unicode_ci NOT NULL,
153 `Format` varchar(20) collate utf8_unicode_ci default NULL,
154 `InsertUserID` int(11) default NULL,
155 `DateInserted` datetime NOT NULL,
156 PRIMARY KEY (`MessageID`),
157 KEY `FK_ConversationMessage_InsertUserID` (`InsertUserID`),
158 KEY `FK_ConversationMessage_DateInserted` (`DateInserted`),
159 KEY `FK_ConversationMessage_ConversationID` (`ConversationID`)
160 ) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
161
162 --
163 -- Table structure for table `GDN_Discussion`
164 --
165
166 DROP TABLE IF EXISTS `GDN_Discussion`;
167 CREATE TABLE `GDN_Discussion` (
168 `DiscussionID` int(11) NOT NULL auto_increment,
169 `CategoryID` int(11) NOT NULL,
170 `InsertUserID` int(11) NOT NULL,
171 `UpdateUserID` int(11) NOT NULL,
172 `LastCommentID` int(11) default NULL,
173 `Name` varchar(100) collate utf8_unicode_ci NOT NULL,
174 `CountComments` int(11) NOT NULL default '1',
175 `CountBookmarks` int(11) default NULL,
176 `CountViews` int(11) NOT NULL default '1',
177 `Closed` tinyint(1) NOT NULL default '0',
178 `Announce` tinyint(1) NOT NULL default '0',
179 `Sink` tinyint(1) NOT NULL default '0',
180 `DateInserted` datetime default NULL,
181 `DateUpdated` datetime NOT NULL,
182 `DateLastComment` datetime default NULL,
183 `Attributes` text collate utf8_unicode_ci,
184 `CountReplies` int(11) NOT NULL default '0',
185 `Body` text collate utf8_unicode_ci NOT NULL,
186 `Format` varchar(20) collate utf8_unicode_ci default NULL,
187 `Tags` varchar(255) collate utf8_unicode_ci default NULL,
188 `LastCommentUserID` int(11) default NULL,
189 `Score` float default NULL,
190 PRIMARY KEY (`DiscussionID`),
191 KEY `FK_Discussion_CategoryID` (`CategoryID`),
192 KEY `FK_Discussion_InsertUserID` (`InsertUserID`),
193 KEY `FK_Discussion_LastCommentID` (`LastCommentID`),
194 KEY `IX_Discussion_DateLastComment` (`DateLastComment`),
195 FULLTEXT KEY `TX_Discussion` (`Name`,`Body`)
196 ) ENGINE=MyISAM AUTO_INCREMENT=2286 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
197
198 --
199 -- Table structure for table `GDN_Draft`
200 --
201
202 DROP TABLE IF EXISTS `GDN_Draft`;
203 CREATE TABLE `GDN_Draft` (
204 `DraftID` int(11) NOT NULL auto_increment,
205 `DiscussionID` int(11) default NULL,
206 `CategoryID` int(11) default NULL,
207 `InsertUserID` int(11) NOT NULL,
208 `UpdateUserID` int(11) NOT NULL,
209 `Name` varchar(100) collate utf8_unicode_ci default NULL,
210 `Tags` varchar(255) collate utf8_unicode_ci default NULL,
211 `Closed` tinyint(1) NOT NULL default '0',
212 `Announce` tinyint(1) NOT NULL default '0',
213 `Sink` tinyint(1) NOT NULL default '0',
214 `Body` text collate utf8_unicode_ci NOT NULL,
215 `Format` varchar(20) collate utf8_unicode_ci default NULL,
216 `DateInserted` datetime NOT NULL,
217 `DateUpdated` datetime default NULL,
218 PRIMARY KEY (`DraftID`),
219 KEY `FK_Draft_DiscussionID` (`DiscussionID`),
220 KEY `FK_Draft_CategoryID` (`CategoryID`),
221 KEY `FK_Draft_InsertUserID` (`InsertUserID`)
222 ) ENGINE=MyISAM AUTO_INCREMENT=9605 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
223
224 --
225 -- Table structure for table `GDN_Invitation`
226 --
227
228 DROP TABLE IF EXISTS `GDN_Invitation`;
229 CREATE TABLE `GDN_Invitation` (
230 `InvitationID` int(11) NOT NULL auto_increment,
231 `Email` varchar(200) collate utf8_unicode_ci NOT NULL,
232 `Code` varchar(50) collate utf8_unicode_ci NOT NULL,
233 `InsertUserID` int(11) default NULL,
234 `DateInserted` datetime NOT NULL,
235 `AcceptedUserID` int(11) default NULL,
236 PRIMARY KEY (`InvitationID`),
237 KEY `FK_Invitation_InsertUserID` (`InsertUserID`)
238 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
239
240 --
241 -- Table structure for table `GDN_Media`
242 --
243
244 DROP TABLE IF EXISTS `GDN_Media`;
245 CREATE TABLE `GDN_Media` (
246 `MediaID` int(11) NOT NULL auto_increment,
247 `Name` varchar(255) collate utf8_unicode_ci NOT NULL,
248 `Type` varchar(128) collate utf8_unicode_ci NOT NULL,
249 `Size` int(11) NOT NULL,
250 `StorageMethod` varchar(24) collate utf8_unicode_ci NOT NULL,
251 `Path` varchar(255) collate utf8_unicode_ci NOT NULL,
252 `InsertUserID` int(11) NOT NULL,
253 `DateInserted` datetime NOT NULL,
254 `ForeignID` int(11) default NULL,
255 `ForeignTable` varchar(24) collate utf8_unicode_ci default NULL,
256 PRIMARY KEY (`MediaID`)
257 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
258
259 --
260 -- Table structure for table `GDN_Message`
261 --
262
263 DROP TABLE IF EXISTS `GDN_Message`;
264 CREATE TABLE `GDN_Message` (
265 `MessageID` int(11) NOT NULL auto_increment,
266 `Content` text collate utf8_unicode_ci NOT NULL,
267 `Format` varchar(20) collate utf8_unicode_ci default NULL,
268 `AllowDismiss` tinyint(1) NOT NULL default '1',
269 `Enabled` tinyint(1) NOT NULL default '1',
270 `Application` varchar(255) collate utf8_unicode_ci default NULL,
271 `Controller` varchar(255) collate utf8_unicode_ci default NULL,
272 `Method` varchar(255) collate utf8_unicode_ci default NULL,
273 `AssetTarget` varchar(20) collate utf8_unicode_ci default NULL,
274 `CssClass` varchar(20) collate utf8_unicode_ci default NULL,
275 `Sort` int(11) default NULL,
276 PRIMARY KEY (`MessageID`)
277 ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
278
279 --
280 -- Table structure for table `GDN_Permission`
281 --
282
283 DROP TABLE IF EXISTS `GDN_Permission`;
284 CREATE TABLE `GDN_Permission` (
285 `PermissionID` int(11) NOT NULL auto_increment,
286 `RoleID` int(11) NOT NULL default '0',
287 `JunctionTable` varchar(100) collate utf8_unicode_ci default NULL,
288 `JunctionColumn` varchar(100) collate utf8_unicode_ci default NULL,
289 `JunctionID` int(11) default NULL,
290 `Garden.Email.Manage` tinyint(4) NOT NULL default '0',
291 `Garden.Settings.Manage` tinyint(4) NOT NULL default '0',
292 `Garden.Routes.Manage` tinyint(4) NOT NULL default '0',
293 `Garden.Messages.Manage` tinyint(4) NOT NULL default '0',
294 `Garden.Applications.Manage` tinyint(4) NOT NULL default '0',
295 `Garden.Plugins.Manage` tinyint(4) NOT NULL default '0',
296 `Garden.Themes.Manage` tinyint(4) NOT NULL default '0',
297 `Garden.SignIn.Allow` tinyint(4) NOT NULL default '0',
298 `Garden.Registration.Manage` tinyint(4) NOT NULL default '0',
299 `Garden.Applicants.Manage` tinyint(4) NOT NULL default '0',
300 `Garden.Roles.Manage` tinyint(4) NOT NULL default '0',
301 `Garden.Users.Add` tinyint(4) NOT NULL default '0',
302 `Garden.Users.Edit` tinyint(4) NOT NULL default '0',
303 `Garden.Users.Delete` tinyint(4) NOT NULL default '0',
304 `Garden.Users.Approve` tinyint(4) NOT NULL default '0',
305 `Garden.Activity.Delete` tinyint(4) NOT NULL default '0',
306 `Garden.Activity.View` tinyint(4) NOT NULL default '0',
307 `Garden.Profiles.View` tinyint(4) NOT NULL default '0',
308 `Vanilla.Settings.Manage` tinyint(4) NOT NULL default '0',
309 `Vanilla.Categories.Manage` tinyint(4) NOT NULL default '0',
310 `Vanilla.Spam.Manage` tinyint(4) NOT NULL default '0',
311 `Vanilla.Discussions.View` tinyint(4) NOT NULL default '0',
312 `Vanilla.Discussions.Add` tinyint(4) NOT NULL default '0',
313 `Vanilla.Discussions.Edit` tinyint(4) NOT NULL default '0',
314 `Vanilla.Discussions.Announce` tinyint(4) NOT NULL default '0',
315 `Vanilla.Discussions.Sink` tinyint(4) NOT NULL default '0',
316 `Vanilla.Discussions.Close` tinyint(4) NOT NULL default '0',
317 `Vanilla.Discussions.Delete` tinyint(4) NOT NULL default '0',
318 `Vanilla.Comments.Add` tinyint(4) NOT NULL default '0',
319 `Vanilla.Comments.Edit` tinyint(4) NOT NULL default '0',
320 `Vanilla.Comments.Delete` tinyint(4) NOT NULL default '0',
321 `Plugins.Debugger.View` tinyint(4) NOT NULL default '0',
322 `Plugins.Debugger.Manage` tinyint(4) NOT NULL default '0',
323 `Plugins.Attachments.Upload.Allow` tinyint(4) NOT NULL default '0',
324 `Plugins.Attachments.Download.Allow` tinyint(4) NOT NULL default '0',
325 PRIMARY KEY (`PermissionID`),
326 KEY `FK_Permission_RoleID` (`RoleID`)
327 ) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
328
329 --
330 -- Table structure for table `GDN_Photo`
331 --
332
333 DROP TABLE IF EXISTS `GDN_Photo`;
334 CREATE TABLE `GDN_Photo` (
335 `PhotoID` int(11) NOT NULL auto_increment,
336 `Name` varchar(255) collate utf8_unicode_ci NOT NULL,
337 `InsertUserID` int(11) default NULL,
338 `DateInserted` datetime NOT NULL,
339 PRIMARY KEY (`PhotoID`),
340 KEY `FK_Photo_InsertUserID` (`InsertUserID`)
341 ) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
342
343 --
344 -- Table structure for table `GDN_Role`
345 --
346
347 DROP TABLE IF EXISTS `GDN_Role`;
348 CREATE TABLE `GDN_Role` (
349 `RoleID` int(11) NOT NULL auto_increment,
350 `Name` varchar(100) collate utf8_unicode_ci NOT NULL,
351 `Description` varchar(500) collate utf8_unicode_ci default NULL,
352 `Sort` int(11) default NULL,
353 `Deletable` tinyint(1) NOT NULL default '1',
354 `CanSession` tinyint(1) NOT NULL default '1',
355 PRIMARY KEY (`RoleID`)
356 ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
357
358 --
359 -- Table structure for table `GDN_SearchDocument`
360 --
361
362 DROP TABLE IF EXISTS `GDN_SearchDocument`;
363 CREATE TABLE `GDN_SearchDocument` (
364 `DocumentID` int(11) NOT NULL auto_increment,
365 `TableName` varchar(50) collate utf8_unicode_ci NOT NULL,
366 `PrimaryID` int(11) NOT NULL,
367 `PermissionJunctionID` int(11) default NULL,
368 `Title` varchar(100) collate utf8_unicode_ci NOT NULL,
369 `Summary` varchar(200) collate utf8_unicode_ci NOT NULL,
370 `Url` varchar(255) collate utf8_unicode_ci NOT NULL,
371 `InsertUserID` int(11) NOT NULL,
372 `DateInserted` datetime NOT NULL,
373 PRIMARY KEY (`DocumentID`)
374 ) ENGINE=MyISAM AUTO_INCREMENT=5633 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
375
376 --
377 -- Table structure for table `GDN_SearchKeyword`
378 --
379
380 DROP TABLE IF EXISTS `GDN_SearchKeyword`;
381 CREATE TABLE `GDN_SearchKeyword` (
382 `KeywordID` int(11) NOT NULL auto_increment,
383 `Keyword` varchar(50) collate utf8_unicode_ci NOT NULL,
384 PRIMARY KEY (`KeywordID`),
385 KEY `FK_SearchKeyword_Keyword` (`Keyword`)
386 ) ENGINE=MyISAM AUTO_INCREMENT=26642 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
387
388 --
389 -- Table structure for table `GDN_SearchKeywordDocument`
390 --
391
392 DROP TABLE IF EXISTS `GDN_SearchKeywordDocument`;
393 CREATE TABLE `GDN_SearchKeywordDocument` (
394 `KeywordID` int(11) NOT NULL,
395 `DocumentID` int(11) NOT NULL,
396 PRIMARY KEY (`KeywordID`,`DocumentID`)
397 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
398
399 --
400 -- Table structure for table `GDN_TableType`
401 --
402
403 DROP TABLE IF EXISTS `GDN_TableType`;
404 CREATE TABLE `GDN_TableType` (
405 `TableName` varchar(50) collate utf8_unicode_ci NOT NULL,
406 `PermissionTableName` varchar(50) collate utf8_unicode_ci default NULL,
407 PRIMARY KEY (`TableName`)
408 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
409
410 --
411 -- Table structure for table `GDN_Tag`
412 --
413
414 DROP TABLE IF EXISTS `GDN_Tag`;
415 CREATE TABLE `GDN_Tag` (
416 `CountDiscussions` int(11) NOT NULL default '0',
417 `TagID` int(11) NOT NULL auto_increment,
418 `Name` varchar(255) collate utf8_unicode_ci NOT NULL default 'unique',
419 `InsertUserID` int(11) default NULL,
420 `DateInserted` datetime NOT NULL,
421 PRIMARY KEY (`TagID`),
422 KEY `FK_Tag_InsertUserID` (`InsertUserID`)
423 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
424
425 --
426 -- Table structure for table `GDN_TagDiscussion`
427 --
428
429 DROP TABLE IF EXISTS `GDN_TagDiscussion`;
430 CREATE TABLE `GDN_TagDiscussion` (
431 `TagID` int(11) NOT NULL,
432 `DiscussionID` int(11) NOT NULL,
433 PRIMARY KEY (`TagID`,`DiscussionID`)
434 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
435
436 --
437 -- Table structure for table `GDN_User`
438 --
439
440 DROP TABLE IF EXISTS `GDN_User`;
441 CREATE TABLE `GDN_User` (
442 `UserID` int(11) NOT NULL auto_increment,
443 `Name` varchar(20) collate utf8_unicode_ci NOT NULL,
444 `Password` varbinary(50) NOT NULL,
445 `About` text collate utf8_unicode_ci,
446 `Email` varchar(200) collate utf8_unicode_ci NOT NULL,
447 `ShowEmail` tinyint(1) NOT NULL default '0',
448 `Gender` enum('m','f') collate utf8_unicode_ci NOT NULL default 'm',
449 `CountVisits` int(11) NOT NULL default '0',
450 `CountInvitations` int(11) NOT NULL default '0',
451 `CountNotifications` int(11) default NULL,
452 `InviteUserID` int(11) default NULL,
453 `DiscoveryText` text collate utf8_unicode_ci,
454 `Preferences` text collate utf8_unicode_ci,
455 `Permissions` text collate utf8_unicode_ci,
456 `Attributes` text collate utf8_unicode_ci,
457 `DateSetInvitations` datetime default NULL,
458 `DateOfBirth` datetime default NULL,
459 `DateFirstVisit` datetime default NULL,
460 `DateLastActive` datetime default NULL,
461 `DateInserted` datetime NOT NULL,
462 `DateUpdated` datetime default NULL,
463 `HourOffset` int(11) NOT NULL default '0',
464 `CacheRoleID` int(11) default NULL,
465 `Admin` tinyint(1) NOT NULL default '0',
466 `CountDiscussions` int(11) default NULL,
467 `CountUnreadDiscussions` int(11) default NULL,
468 `CountComments` int(11) default NULL,
469 `CountDrafts` int(11) default NULL,
470 `CountBookmarks` int(11) default NULL,
471 `CountUnreadConversations` int(11) default NULL,
472 `HashMethod` varchar(10) collate utf8_unicode_ci default NULL,
473 `Photo` varchar(255) collate utf8_unicode_ci default NULL,
474 `Score` float default NULL,
475 `Deleted` tinyint(1) NOT NULL default '0',
476 `DateAllViewed` datetime default NULL,
477 PRIMARY KEY (`UserID`),
478 KEY `FK_User_Name` (`Name`)
479 ) ENGINE=MyISAM AUTO_INCREMENT=1893 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
480
481 --
482 -- Table structure for table `GDN_UserAuthentication`
483 --
484
485 DROP TABLE IF EXISTS `GDN_UserAuthentication`;
486 CREATE TABLE `GDN_UserAuthentication` (
487 `UniqueID` varchar(30) collate utf8_unicode_ci NOT NULL,
488 `UserID` int(11) NOT NULL,
489 `ForeignUserKey` varchar(255) collate utf8_unicode_ci NOT NULL,
490 `ProviderKey` varchar(64) collate utf8_unicode_ci NOT NULL,
491 PRIMARY KEY (`ForeignUserKey`,`ProviderKey`),
492 KEY `FK_UserAuthentication_UserID` (`UserID`)
493 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
494
495 --
496 -- Table structure for table `GDN_UserAuthenticationNonce`
497 --
498
499 DROP TABLE IF EXISTS `GDN_UserAuthenticationNonce`;
500 CREATE TABLE `GDN_UserAuthenticationNonce` (
501 `Nonce` varchar(200) collate utf8_unicode_ci NOT NULL,
502 `Token` varchar(128) collate utf8_unicode_ci NOT NULL,
503 `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
504 PRIMARY KEY (`Nonce`)
505 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
506
507 --
508 -- Table structure for table `GDN_UserAuthenticationProvider`
509 --
510
511 DROP TABLE IF EXISTS `GDN_UserAuthenticationProvider`;
512 CREATE TABLE `GDN_UserAuthenticationProvider` (
513 `AuthenticationKey` varchar(64) collate utf8_unicode_ci NOT NULL,
514 `AuthenticationSchemeAlias` varchar(32) collate utf8_unicode_ci NOT NULL,
515 `URL` varchar(255) collate utf8_unicode_ci default NULL,
516 `AssociationSecret` text collate utf8_unicode_ci NOT NULL,
517 `AssociationHashMethod` enum('HMAC-SHA1','HMAC-PLAINTEXT') collate utf8_unicode_ci NOT NULL,
518 `AuthenticateUrl` varchar(255) collate utf8_unicode_ci default NULL,
519 `RegisterUrl` varchar(255) collate utf8_unicode_ci default NULL,
520 `SignInUrl` varchar(255) collate utf8_unicode_ci default NULL,
521 `SignOutUrl` varchar(255) collate utf8_unicode_ci default NULL,
522 `PasswordUrl` varchar(255) collate utf8_unicode_ci default NULL,
523 `ProfileUrl` varchar(255) collate utf8_unicode_ci default NULL,
524 PRIMARY KEY (`AuthenticationKey`)
525 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
526
527 --
528 -- Table structure for table `GDN_UserAuthenticationToken`
529 --
530
531 DROP TABLE IF EXISTS `GDN_UserAuthenticationToken`;
532 CREATE TABLE `GDN_UserAuthenticationToken` (
533 `Token` varchar(128) collate utf8_unicode_ci NOT NULL,
534 `ProviderKey` varchar(64) collate utf8_unicode_ci NOT NULL,
535 `ForeignUserKey` varchar(255) collate utf8_unicode_ci default NULL,
536 `TokenSecret` varchar(64) collate utf8_unicode_ci NOT NULL,
537 `TokenType` enum('request','access') collate utf8_unicode_ci NOT NULL,
538 `Authorized` tinyint(4) NOT NULL,
539 `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
540 `Lifetime` int(11) NOT NULL,
541 PRIMARY KEY (`Token`,`ProviderKey`)
542 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
543
544 --
545 -- Table structure for table `GDN_UserComment`
546 --
547
548 DROP TABLE IF EXISTS `GDN_UserComment`;
549 CREATE TABLE `GDN_UserComment` (
550 `UserID` int(11) NOT NULL,
551 `CommentID` int(11) NOT NULL,
552 `Score` float default NULL,
553 `DateLastViewed` datetime default NULL,
554 PRIMARY KEY (`UserID`,`CommentID`)
555 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
556
557 --
558 -- Table structure for table `GDN_UserConversation`
559 --
560
561 DROP TABLE IF EXISTS `GDN_UserConversation`;
562 CREATE TABLE `GDN_UserConversation` (
563 `UserID` int(11) NOT NULL,
564 `ConversationID` int(11) NOT NULL,
565 `CountReadMessages` int(11) NOT NULL default '0',
566 `CountNewMessages` int(11) NOT NULL default '0',
567 `CountMessages` int(11) NOT NULL default '0',
568 `LastMessageID` int(11) default NULL,
569 `DateLastViewed` datetime default NULL,
570 `DateCleared` datetime default NULL,
571 `Bookmarked` tinyint(1) NOT NULL default '0',
572 `Deleted` tinyint(4) NOT NULL default '0',
573 PRIMARY KEY (`UserID`,`ConversationID`),
574 KEY `FK_UserConversation_LastMessageID` (`LastMessageID`)
575 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
576
577 --
578 -- Table structure for table `GDN_UserDiscussion`
579 --
580
581 DROP TABLE IF EXISTS `GDN_UserDiscussion`;
582 CREATE TABLE `GDN_UserDiscussion` (
583 `UserID` int(11) NOT NULL,
584 `DiscussionID` int(11) NOT NULL,
585 `Score` float default NULL,
586 `CountComments` int(11) NOT NULL default '0',
587 `DateLastViewed` datetime default NULL,
588 `Dismissed` tinyint(1) NOT NULL default '0',
589 `Bookmarked` tinyint(1) NOT NULL default '0',
590 PRIMARY KEY (`UserID`,`DiscussionID`),
591 KEY `FK_UserDiscussion_DiscussionID` (`DiscussionID`)
592 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
593
594 --
595 -- Table structure for table `GDN_UserMeta`
596 --
597
598 DROP TABLE IF EXISTS `GDN_UserMeta`;
599 CREATE TABLE `GDN_UserMeta` (
600 `UserID` int(11) NOT NULL,
601 `Name` varchar(255) collate utf8_unicode_ci NOT NULL,
602 `Value` text collate utf8_unicode_ci,
603 PRIMARY KEY (`UserID`,`Name`)
604 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
605
606 --
607 -- Table structure for table `GDN_UserRole`
608 --
609
610 DROP TABLE IF EXISTS `GDN_UserRole`;
611 CREATE TABLE `GDN_UserRole` (
612 `UserID` int(11) NOT NULL,
613 `RoleID` int(11) NOT NULL,
614 PRIMARY KEY (`UserID`,`RoleID`)
615 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
616
617 --
618 -- Table structure for table `GDN_Whosonline`
619 --
620
621 DROP TABLE IF EXISTS `GDN_Whosonline`;
622 CREATE TABLE `GDN_Whosonline` (
623 `UserID` int(11) NOT NULL default '11',
624 `Timestamp` int(11) NOT NULL default '11'
625 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
626
627 --
628 -- Table structure for table `access`
629 --
630
631 DROP TABLE IF EXISTS `access`;
632 CREATE TABLE `access` (
633 `aid` int(11) NOT NULL auto_increment,
634 `mask` varchar(255) NOT NULL default '',
635 `type` varchar(255) NOT NULL default '',
636 `status` tinyint(4) NOT NULL default '0',
637 PRIMARY KEY (`aid`)
638 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
639
640 --
641 -- Table structure for table `actions`
642 --
643
644 DROP TABLE IF EXISTS `actions`;
645 CREATE TABLE `actions` (
646 `aid` varchar(255) NOT NULL default '0',
647 `type` varchar(32) NOT NULL default '',
648 `callback` varchar(255) NOT NULL default '',
649 `parameters` longtext NOT NULL,
650 `description` varchar(255) NOT NULL default '0',
651 PRIMARY KEY (`aid`)
652 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
653
654 --
655 -- Table structure for table `actions_aid`
656 --
657
658 DROP TABLE IF EXISTS `actions_aid`;
659 CREATE TABLE `actions_aid` (
660 `aid` int(10) unsigned NOT NULL auto_increment,
661 PRIMARY KEY (`aid`)
662 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
663
664 --
665 -- Table structure for table `authmap`
666 --
667
668 DROP TABLE IF EXISTS `authmap`;
669 CREATE TABLE `authmap` (
670 `aid` int(10) unsigned NOT NULL auto_increment,
671 `uid` int(11) NOT NULL default '0',
672 `authname` varchar(128) NOT NULL default '',
673 `module` varchar(128) NOT NULL default '',
674 PRIMARY KEY (`aid`),
675 UNIQUE KEY `authname` (`authname`)
676 ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
677
678 --
679 -- Table structure for table `batch`
680 --
681
682 DROP TABLE IF EXISTS `batch`;
683 CREATE TABLE `batch` (
684 `bid` int(10) unsigned NOT NULL auto_increment,
685 `token` varchar(64) NOT NULL,
686 `timestamp` int(11) NOT NULL,
687 `batch` longtext,
688 PRIMARY KEY (`bid`),
689 KEY `token` (`token`)
690 ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
691
692 --
693 -- Table structure for table `blocks`
694 --
695
696 DROP TABLE IF EXISTS `blocks`;
697 CREATE TABLE `blocks` (
698 `bid` int(11) NOT NULL auto_increment,
699 `module` varchar(64) NOT NULL default '',
700 `delta` varchar(32) NOT NULL default '0',
701 `theme` varchar(64) NOT NULL default '',
702 `status` tinyint(4) NOT NULL default '0',
703 `weight` tinyint(4) NOT NULL default '0',
704 `region` varchar(64) NOT NULL default '',
705 `custom` tinyint(4) NOT NULL default '0',
706 `throttle` tinyint(4) NOT NULL default '0',
707 `visibility` tinyint(4) NOT NULL default '0',
708 `pages` text NOT NULL,
709 `title` varchar(64) NOT NULL default '',
710 `cache` tinyint(4) NOT NULL default '1',
711 PRIMARY KEY (`bid`),
712 UNIQUE KEY `tmd` (`theme`,`module`,`delta`),
713 KEY `list` (`theme`,`status`,`region`,`weight`,`module`)
714 ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
715
716 --
717 -- Table structure for table `blocks_roles`
718 --
719
720 DROP TABLE IF EXISTS `blocks_roles`;
721 CREATE TABLE `blocks_roles` (
722 `module` varchar(64) NOT NULL,
723 `delta` varchar(32) NOT NULL,
724 `rid` int(10) unsigned NOT NULL,
725 PRIMARY KEY (`module`,`delta`,`rid`),
726 KEY `rid` (`rid`)
727 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
728
729 --
730 -- Table structure for table `boxes`
731 --
732
733 DROP TABLE IF EXISTS `boxes`;
734 CREATE TABLE `boxes` (
735 `bid` int(10) unsigned NOT NULL auto_increment,
736 `body` longtext,
737 `info` varchar(128) NOT NULL default '',
738 `format` smallint(6) NOT NULL default '0',
739 PRIMARY KEY (`bid`),
740 UNIQUE KEY `info` (`info`)
741 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
742
743 --
744 -- Table structure for table `bueditor_buttons`
745 --
746
747 DROP TABLE IF EXISTS `bueditor_buttons`;
748 CREATE TABLE `bueditor_buttons` (
749 `bid` int(10) unsigned NOT NULL auto_increment,
750 `eid` int(10) unsigned NOT NULL default '0',
751 `title` varchar(255) NOT NULL default 'Notitle',
752 `content` text NOT NULL,
753 `icon` varchar(255) NOT NULL default '',
754 `accesskey` varchar(1) NOT NULL default '',
755 `weight` tinyint(4) NOT NULL default '0',
756 PRIMARY KEY (`bid`),
757 KEY `eid` (`eid`)
758 ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
759
760 --
761 -- Table structure for table `bueditor_editors`
762 --
763
764 DROP TABLE IF EXISTS `bueditor_editors`;
765 CREATE TABLE `bueditor_editors` (
766 `eid` int(10) unsigned NOT NULL auto_increment,
767 `name` varchar(255) NOT NULL default 'Noname',
768 `pages` text NOT NULL,
769 `excludes` text NOT NULL,
770 `iconpath` varchar(255) NOT NULL default '%BUEDITOR/icons',
771 `librarypath` varchar(255) NOT NULL default '%BUEDITOR/library',
772 PRIMARY KEY (`eid`)
773 ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
774
775 --
776 -- Table structure for table `cache`
777 --
778
779 DROP TABLE IF EXISTS `cache`;
780 CREATE TABLE `cache` (
781 `cid` varchar(255) NOT NULL default '',
782 `data` longblob,
783 `expire` int(11) NOT NULL default '0',
784 `created` int(11) NOT NULL default '0',
785 `headers` text,
786 `serialized` smallint(6) NOT NULL default '0',
787 PRIMARY KEY (`cid`),
788 KEY `expire` (`expire`)
789 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
790
791 --
792 -- Table structure for table `cache_block`
793 --
794
795 DROP TABLE IF EXISTS `cache_block`;
796 CREATE TABLE `cache_block` (
797 `cid` varchar(255) NOT NULL default '',
798 `data` longblob,
799 `expire` int(11) NOT NULL default '0',
800 `created` int(11) NOT NULL default '0',
801 `headers` text,
802 `serialized` smallint(6) NOT NULL default '0',
803 PRIMARY KEY (`cid`),
804 KEY `expire` (`expire`)
805 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
806
807 --
808 -- Table structure for table `cache_filter`
809 --
810
811 DROP TABLE IF EXISTS `cache_filter`;
812 CREATE TABLE `cache_filter` (
813 `cid` varchar(255) NOT NULL default '',
814 `data` longblob,
815 `expire` int(11) NOT NULL default '0',
816 `created` int(11) NOT NULL default '0',
817 `headers` text,
818 `serialized` smallint(6) NOT NULL default '0',
819 PRIMARY KEY (`cid`),
820 KEY `expire` (`expire`)
821 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
822
823 --
824 -- Table structure for table `cache_form`
825 --
826
827 DROP TABLE IF EXISTS `cache_form`;
828 CREATE TABLE `cache_form` (
829 `cid` varchar(255) NOT NULL default '',
830 `data` longblob,
831 `expire` int(11) NOT NULL default '0',
832 `created` int(11) NOT NULL default '0',
833 `headers` text,
834 `serialized` smallint(6) NOT NULL default '0',
835 PRIMARY KEY (`cid`),
836 KEY `expire` (`expire`)
837 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
838
839 --
840 -- Table structure for table `cache_gravatar`
841 --
842
843 DROP TABLE IF EXISTS `cache_gravatar`;
844 CREATE TABLE `cache_gravatar` (
845 `cid` varchar(255) NOT NULL default '',
846 `data` longblob,
847 `expire` int(11) NOT NULL default '0',
848 `created` int(11) NOT NULL default '0',
849 `headers` text,
850 `serialized` smallint(6) NOT NULL default '0',
851 PRIMARY KEY (`cid`),
852 KEY `expire` (`expire`)
853 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
854
855 --
856 -- Table structure for table `cache_menu`
857 --
858
859 DROP TABLE IF EXISTS `cache_menu`;
860 CREATE TABLE `cache_menu` (
861 `cid` varchar(255) NOT NULL default '',
862 `data` longblob,
863 `expire` int(11) NOT NULL default '0',
864 `created` int(11) NOT NULL default '0',
865 `headers` text,
866 `serialized` smallint(6) NOT NULL default '0',
867 PRIMARY KEY (`cid`),
868 KEY `expire` (`expire`)
869 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
870
871 --
872 -- Table structure for table `cache_page`
873 --
874
875 DROP TABLE IF EXISTS `cache_page`;
876 CREATE TABLE `cache_page` (
877 `cid` varchar(255) NOT NULL default '',
878 `data` longblob,
879 `expire` int(11) NOT NULL default '0',
880 `created` int(11) NOT NULL default '0',
881 `headers` text,
882 `serialized` smallint(6) NOT NULL default '0',
883 PRIMARY KEY (`cid`),
884 KEY `expire` (`expire`)
885 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
886
887 --
888 -- Table structure for table `cache_update`
889 --
890
891 DROP TABLE IF EXISTS `cache_update`;
892 CREATE TABLE `cache_update` (
893 `cid` varchar(255) NOT NULL default '',
894 `data` longblob,
895 `expire` int(11) NOT NULL default '0',
896 `created` int(11) NOT NULL default '0',
897 `headers` text,
898 `serialized` smallint(6) NOT NULL default '0',
899 PRIMARY KEY (`cid`),
900 KEY `expire` (`expire`)
901 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
902
903 --
904 -- Table structure for table `captcha_points`
905 --
906
907 DROP TABLE IF EXISTS `captcha_points`;
908 CREATE TABLE `captcha_points` (
909 `form_id` varchar(128) NOT NULL,
910 `module` varchar(64) default NULL,
911 `type` varchar(64) default NULL,
912 PRIMARY KEY (`form_id`)
913 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
914
915 --
916 -- Table structure for table `captcha_sessions`
917 --
918
919 DROP TABLE IF EXISTS `captcha_sessions`;
920 CREATE TABLE `captcha_sessions` (
921 `csid` int(11) NOT NULL auto_increment,
922 `uid` int(11) NOT NULL default '0',
923 `sid` varchar(64) NOT NULL default '',
924 `ip_address` varchar(128) default NULL,
925 `timestamp` int(11) NOT NULL default '0',
926 `form_id` varchar(128) NOT NULL,
927 `solution` varchar(128) NOT NULL default '',
928 `status` int(11) NOT NULL default '0',
929 `attempts` int(11) NOT NULL default '0',
930 PRIMARY KEY (`csid`),
931 KEY `csid_ip` (`csid`,`ip_address`)
932 ) ENGINE=MyISAM AUTO_INCREMENT=9318 DEFAULT CHARSET=utf8;
933
934 --
935 -- Table structure for table `comments`
936 --
937
938 DROP TABLE IF EXISTS `comments`;
939 CREATE TABLE `comments` (
940 `cid` int(11) NOT NULL auto_increment,
941 `pid` int(11) NOT NULL default '0',
942 `nid` int(11) NOT NULL default '0',
943 `uid` int(11) NOT NULL default '0',
944 `subject` varchar(64) NOT NULL default '',
945 `comment` longtext NOT NULL,
946 `hostname` varchar(128) NOT NULL default '',
947 `timestamp` int(11) NOT NULL default '0',
948 `status` tinyint(3) unsigned NOT NULL default '0',
949 `format` smallint(6) NOT NULL default '0',
950 `thread` varchar(255) NOT NULL,
951 `name` varchar(60) default NULL,
952 `mail` varchar(64) default NULL,
953 `homepage` varchar(255) default NULL,
954 PRIMARY KEY (`cid`),
955 KEY `pid` (`pid`),
956 KEY `nid` (`nid`),
957 KEY `status` (`status`)
958 ) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;
959
960 --
961 -- Table structure for table `files`
962 --
963
964 DROP TABLE IF EXISTS `files`;
965 CREATE TABLE `files` (
966 `fid` int(10) unsigned NOT NULL auto_increment,
967 `uid` int(10) unsigned NOT NULL default '0',
968 `filename` varchar(255) NOT NULL default '',
969 `filepath` varchar(255) NOT NULL default '',
970 `filemime` varchar(255) NOT NULL default '',
971 `filesize` int(10) unsigned NOT NULL default '0',
972 `status` int(11) NOT NULL default '0',
973 `timestamp` int(10) unsigned NOT NULL default '0',
974 PRIMARY KEY (`fid`),
975 KEY `uid` (`uid`),
976 KEY `status` (`status`),
977 KEY `timestamp` (`timestamp`)
978 ) ENGINE=MyISAM AUTO_INCREMENT=177 DEFAULT CHARSET=utf8;
979
980 --
981 -- Table structure for table `filter_formats`
982 --
983
984 DROP TABLE IF EXISTS `filter_formats`;
985 CREATE TABLE `filter_formats` (
986 `format` int(11) NOT NULL auto_increment,
987 `name` varchar(255) NOT NULL default '',
988 `roles` varchar(255) NOT NULL default '',
989 `cache` tinyint(4) NOT NULL default '0',
990 PRIMARY KEY (`format`),
991 UNIQUE KEY `name` (`name`)
992 ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
993
994 --
995 -- Table structure for table `filters`
996 --
997
998 DROP TABLE IF EXISTS `filters`;
999 CREATE TABLE `filters` (
1000 `fid` int(11) NOT NULL auto_increment,
1001 `format` int(11) NOT NULL default '0',
1002 `module` varchar(64) NOT NULL default '',
1003 `delta` tinyint(4) NOT NULL default '0',
1004 `weight` tinyint(4) NOT NULL default '0',
1005 PRIMARY KEY (`fid`),
1006 UNIQUE KEY `fmd` (`format`,`module`,`delta`),
1007 KEY `list` (`format`,`weight`,`module`,`delta`)
1008 ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
1009
1010 --
1011 -- Table structure for table `flood`
1012 --
1013
1014 DROP TABLE IF EXISTS `flood`;
1015 CREATE TABLE `flood` (
1016 `fid` int(11) NOT NULL auto_increment,
1017 `event` varchar(64) NOT NULL default '',
1018 `hostname` varchar(128) NOT NULL default '',
1019 `timestamp` int(11) NOT NULL default '0',
1020 PRIMARY KEY (`fid`),
1021 KEY `allow` (`event`,`hostname`,`timestamp`)
1022 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1023
1024 --
1025 -- Table structure for table `forum`
1026 --
1027
1028 DROP TABLE IF EXISTS `forum`;
1029 CREATE TABLE `forum` (
1030 `nid` int(10) unsigned NOT NULL default '0',
1031 `vid` int(10) unsigned NOT NULL default '0',
1032 `tid` int(10) unsigned NOT NULL default '0',
1033 PRIMARY KEY (`vid`),
1034 KEY `nid` (`nid`),
1035 KEY `tid` (`tid`)
1036 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1037
1038 --
1039 -- Table structure for table `history`
1040 --
1041
1042 DROP TABLE IF EXISTS `history`;
1043 CREATE TABLE `history` (
1044 `uid` int(11) NOT NULL default '0',
1045 `nid` int(11) NOT NULL default '0',
1046 `timestamp` int(11) NOT NULL default '0',
1047 PRIMARY KEY (`uid`,`nid`),
1048 KEY `nid` (`nid`)
1049 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1050
1051 --
1052 -- Table structure for table `i18n_blocks`
1053 --
1054
1055 DROP TABLE IF EXISTS `i18n_blocks`;
1056 CREATE TABLE `i18n_blocks` (
1057 `ibid` int(10) unsigned NOT NULL auto_increment,
1058 `module` varchar(64) NOT NULL,
1059 `delta` varchar(32) NOT NULL default '0',
1060 `type` int(11) NOT NULL default '0',
1061 `language` varchar(12) NOT NULL default '',
1062 PRIMARY KEY (`ibid`)
1063 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1064
1065 --
1066 -- Table structure for table `i18n_strings`
1067 --
1068
1069 DROP TABLE IF EXISTS `i18n_strings`;
1070 CREATE TABLE `i18n_strings` (
1071 `lid` int(11) NOT NULL default '0',
1072 `objectid` int(11) NOT NULL default '0',
1073 `type` varchar(255) NOT NULL default '',
1074 `property` varchar(255) NOT NULL default 'default',
1075 PRIMARY KEY (`lid`)
1076 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1077
1078 --
1079 -- Table structure for table `i18n_variable`
1080 --
1081
1082 DROP TABLE IF EXISTS `i18n_variable`;
1083 CREATE TABLE `i18n_variable` (
1084 `name` varchar(128) NOT NULL default '',
1085 `language` varchar(12) NOT NULL default '',
1086 `value` longtext NOT NULL,
1087 PRIMARY KEY (`name`,`language`)
1088 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1089
1090 --
1091 -- Table structure for table `image`
1092 --
1093
1094 DROP TABLE IF EXISTS `image`;
1095 CREATE TABLE `image` (
1096 `nid` int(10) unsigned NOT NULL default '0',
1097 `fid` int(10) unsigned NOT NULL default '0',
1098 `image_size` varchar(32) NOT NULL default '',
1099 PRIMARY KEY (`nid`,`image_size`),
1100 KEY `fid` (`fid`)
1101 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1102
1103 --
1104 -- Table structure for table `image_attach`
1105 --
1106
1107 DROP TABLE IF EXISTS `image_attach`;
1108 CREATE TABLE `image_attach` (
1109 `nid` int(10) unsigned NOT NULL default '0',
1110 `iid` int(10) unsigned NOT NULL default '0',
1111 `weight` int(11) NOT NULL default '0',
1112 PRIMARY KEY (`nid`,`iid`),
1113 KEY `iid` (`iid`)
1114 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1115
1116 --
1117 -- Table structure for table `languages`
1118 --
1119
1120 DROP TABLE IF EXISTS `languages`;
1121 CREATE TABLE `languages` (
1122 `language` varchar(12) NOT NULL default '',
1123 `name` varchar(64) NOT NULL default '',
1124 `native` varchar(64) NOT NULL default '',
1125 `direction` int(11) NOT NULL default '0',
1126 `enabled` int(11) NOT NULL default '0',
1127 `plurals` int(11) NOT NULL default '0',
1128 `formula` varchar(128) NOT NULL default '',
1129 `domain` varchar(128) NOT NULL default '',
1130 `prefix` varchar(128) NOT NULL default '',
1131 `weight` int(11) NOT NULL default '0',
1132 `javascript` varchar(32) NOT NULL default '',
1133 PRIMARY KEY (`language`),
1134 KEY `list` (`weight`,`name`)
1135 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1136
1137 --
1138 -- Table structure for table `locales_source`
1139 --
1140
1141 DROP TABLE IF EXISTS `locales_source`;
1142 CREATE TABLE `locales_source` (
1143 `lid` int(11) NOT NULL auto_increment,
1144 `location` varchar(255) NOT NULL default '',
1145 `textgroup` varchar(255) NOT NULL default 'default',
1146 `source` blob NOT NULL,
1147 `version` varchar(20) NOT NULL default 'none',
1148 PRIMARY KEY (`lid`),
1149 KEY `source` (`source`(30)),
1150 KEY `textgroup_location` (`textgroup`(30),`location`)
1151 ) ENGINE=MyISAM AUTO_INCREMENT=4355 DEFAULT CHARSET=utf8;
1152
1153 --
1154 -- Table structure for table `locales_target`
1155 --
1156
1157 DROP TABLE IF EXISTS `locales_target`;
1158 CREATE TABLE `locales_target` (
1159 `lid` int(11) NOT NULL default '0',
1160 `translation` blob NOT NULL,
1161 `language` varchar(12) NOT NULL default '',
1162 `plid` int(11) NOT NULL default '0',
1163 `plural` int(11) NOT NULL default '0',
1164 `status` int(11) NOT NULL default '0',
1165 PRIMARY KEY (`language`,`lid`,`plural`),
1166 KEY `lid` (`lid`),
1167 KEY `plid` (`plid`),
1168 KEY `plural` (`plural`)
1169 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1170
1171 --
1172 -- Table structure for table `menu_custom`
1173 --
1174
1175 DROP TABLE IF EXISTS `menu_custom`;
1176 CREATE TABLE `menu_custom` (
1177 `menu_name` varchar(32) NOT NULL default '',
1178 `title` varchar(255) NOT NULL default '',
1179 `description` text,
1180 PRIMARY KEY (`menu_name`)
1181 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1182
1183 --
1184 -- Table structure for table `menu_links`
1185 --
1186
1187 DROP TABLE IF EXISTS `menu_links`;
1188 CREATE TABLE `menu_links` (
1189 `menu_name` varchar(32) NOT NULL default '',
1190 `mlid` int(10) unsigned NOT NULL auto_increment,
1191 `plid` int(10) unsigned NOT NULL default '0',
1192 `link_path` varchar(255) NOT NULL default '',
1193 `router_path` varchar(255) NOT NULL default '',
1194 `link_title` varchar(255) NOT NULL default '',
1195 `options` text,
1196 `module` varchar(255) NOT NULL default 'system',
1197 `hidden` smallint(6) NOT NULL default '0',
1198 `external` smallint(6) NOT NULL default '0',
1199 `has_children` smallint(6) NOT NULL default '0',
1200 `expanded` smallint(6) NOT NULL default '0',
1201 `weight` int(11) NOT NULL default '0',
1202 `depth` smallint(6) NOT NULL default '0',
1203 `customized` smallint(6) NOT NULL default '0',
1204 `p1` int(10) unsigned NOT NULL default '0',
1205 `p2` int(10) unsigned NOT NULL default '0',
1206 `p3` int(10) unsigned NOT NULL default '0',
1207 `p4` int(10) unsigned NOT NULL default '0',
1208 `p5` int(10) unsigned NOT NULL default '0',
1209 `p6` int(10) unsigned NOT NULL default '0',
1210 `p7` int(10) unsigned NOT NULL default '0',
1211 `p8` int(10) unsigned NOT NULL default '0',
1212 `p9` int(10) unsigned NOT NULL default '0',
1213 `updated` smallint(6) NOT NULL default '0',
1214 PRIMARY KEY (`mlid`),
1215 KEY `path_menu` (`link_path`(128),`menu_name`),
1216 KEY `menu_plid_expand_child` (`menu_name`,`plid`,`expanded`,`has_children`),
1217 KEY `menu_parents` (`menu_name`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`),
1218 KEY `router_path` (`router_path`(128))
1219 ) ENGINE=MyISAM AUTO_INCREMENT=259 DEFAULT CHARSET=utf8;
1220
1221 --
1222 -- Table structure for table `menu_router`
1223 --
1224
1225 DROP TABLE IF EXISTS `menu_router`;
1226 CREATE TABLE `menu_router` (
1227 `path` varchar(255) NOT NULL default '',
1228 `load_functions` text NOT NULL,
1229 `to_arg_functions` text NOT NULL,
1230 `access_callback` varchar(255) NOT NULL default '',
1231 `access_arguments` text,
1232 `page_callback` varchar(255) NOT NULL default '',
1233 `page_arguments` text,
1234 `fit` int(11) NOT NULL default '0',
1235 `number_parts` smallint(6) NOT NULL default '0',
1236 `tab_parent` varchar(255) NOT NULL default '',
1237 `tab_root` varchar(255) NOT NULL default '',
1238 `title` varchar(255) NOT NULL default '',
1239 `title_callback` varchar(255) NOT NULL default '',
1240 `title_arguments` varchar(255) NOT NULL default '',
1241 `type` int(11) NOT NULL default '0',
1242 `block_callback` varchar(255) NOT NULL default '',
1243 `description` text NOT NULL,
1244 `position` varchar(255) NOT NULL default '',
1245 `weight` int(11) NOT NULL default '0',
1246 `file` mediumtext,
1247 PRIMARY KEY (`path`),
1248 KEY `fit` (`fit`),
1249 KEY `tab_parent` (`tab_parent`),
1250 KEY `tab_root_weight_title` (`tab_root`(64),`weight`,`title`)
1251 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1252
1253 --
1254 -- Table structure for table `node`
1255 --
1256
1257 DROP TABLE IF EXISTS `node`;
1258 CREATE TABLE `node` (
1259 `nid` int(10) unsigned NOT NULL auto_increment,
1260 `vid` int(10) unsigned NOT NULL default '0',
1261 `type` varchar(32) NOT NULL default '',
1262 `language` varchar(12) NOT NULL default '',
1263 `title` varchar(255) NOT NULL default '',
1264 `uid` int(11) NOT NULL default '0',
1265 `status` int(11) NOT NULL default '1',
1266 `created` int(11) NOT NULL default '0',
1267 `changed` int(11) NOT NULL default '0',
1268 `comment` int(11) NOT NULL default '0',
1269 `promote` int(11) NOT NULL default '0',
1270 `moderate` int(11) NOT NULL default '0',
1271 `sticky` int(11) NOT NULL default '0',
1272 `tnid` int(10) unsigned NOT NULL default '0',
1273 `translate` int(11) NOT NULL default '0',
1274 PRIMARY KEY (`nid`),
1275 UNIQUE KEY `vid` (`vid`),
1276 KEY `node_changed` (`changed`),
1277 KEY `node_created` (`created`),
1278 KEY `node_moderate` (`moderate`),
1279 KEY `node_promote_status` (`promote`,`status`),
1280 KEY `node_status_type` (`status`,`type`,`nid`),
1281 KEY `node_title_type` (`title`,`type`(4)),
1282 KEY `node_type` (`type`(4)),
1283 KEY `uid` (`uid`),
1284 KEY `tnid` (`tnid`),
1285 KEY `translate` (`translate`)
1286 ) ENGINE=MyISAM AUTO_INCREMENT=142 DEFAULT CHARSET=utf8;
1287
1288 --
1289 -- Table structure for table `node_access`
1290 --
1291
1292 DROP TABLE IF EXISTS `node_access`;
1293 CREATE TABLE `node_access` (
1294 `nid` int(10) unsigned NOT NULL default '0',
1295 `gid` int(10) unsigned NOT NULL default '0',
1296 `realm` varchar(255) NOT NULL default '',
1297 `grant_view` tinyint(3) unsigned NOT NULL default '0',
1298 `grant_update` tinyint(3) unsigned NOT NULL default '0',
1299 `grant_delete` tinyint(3) unsigned NOT NULL default '0',
1300 PRIMARY KEY (`nid`,`gid`,`realm`)
1301 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1302
1303 --
1304 -- Table structure for table `node_comment_statistics`
1305 --
1306
1307 DROP TABLE IF EXISTS `node_comment_statistics`;
1308 CREATE TABLE `node_comment_statistics` (
1309 `nid` int(10) unsigned NOT NULL default '0',
1310 `last_comment_timestamp` int(11) NOT NULL default '0',
1311 `last_comment_name` varchar(60) default NULL,
1312 `last_comment_uid` int(11) NOT NULL default '0',
1313 `comment_count` int(10) unsigned NOT NULL default '0',
1314 PRIMARY KEY (`nid`),
1315 KEY `node_comment_timestamp` (`last_comment_timestamp`)
1316 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1317
1318 --
1319 -- Table structure for table `node_counter`
1320 --
1321
1322 DROP TABLE IF EXISTS `node_counter`;
1323 CREATE TABLE `node_counter` (
1324 `nid` int(11) NOT NULL default '0',
1325 `totalcount` bigint(20) unsigned NOT NULL default '0',
1326 `daycount` mediumint(8) unsigned NOT NULL default '0',
1327 `timestamp` int(10) unsigned NOT NULL default '0',
1328 PRIMARY KEY (`nid`)
1329 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1330
1331 --
1332 -- Table structure for table `node_revisions`
1333 --
1334
1335 DROP TABLE IF EXISTS `node_revisions`;
1336 CREATE TABLE `node_revisions` (
1337 `nid` int(10) unsigned NOT NULL default '0',
1338 `vid` int(10) unsigned NOT NULL auto_increment,
1339 `uid` int(11) NOT NULL default '0',
1340 `title` varchar(255) NOT NULL default '',
1341 `body` longtext NOT NULL,
1342 `teaser` longtext NOT NULL,
1343 `log` longtext NOT NULL,
1344 `timestamp` int(11) NOT NULL default '0',
1345 `format` int(11) NOT NULL default '0',
1346 PRIMARY KEY (`vid`),
1347 KEY `nid` (`nid`),
1348 KEY `uid` (`uid`)
1349 ) ENGINE=MyISAM AUTO_INCREMENT=485 DEFAULT CHARSET=utf8;
1350
1351 --
1352 -- Table structure for table `node_type`
1353 --
1354
1355 DROP TABLE IF EXISTS `node_type`;
1356 CREATE TABLE `node_type` (
1357 `type` varchar(32) NOT NULL,
1358 `name` varchar(255) NOT NULL default '',
1359 `module` varchar(255) NOT NULL,
1360 `description` mediumtext NOT NULL,
1361 `help` mediumtext NOT NULL,
1362 `has_title` tinyint(3) unsigned NOT NULL,
1363 `title_label` varchar(255) NOT NULL default '',
1364 `has_body` tinyint(3) unsigned NOT NULL,
1365 `body_label` varchar(255) NOT NULL default '',
1366 `min_word_count` smallint(5) unsigned NOT NULL,
1367 `custom` tinyint(4) NOT NULL default '0',
1368 `modified` tinyint(4) NOT NULL default '0',
1369 `locked` tinyint(4) NOT NULL default '0',
1370 `orig_type` varchar(255) NOT NULL default '',
1371 PRIMARY KEY (`type`)
1372 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1373
1374 --
1375 -- Table structure for table `openid_association`
1376 --
1377
1378 DROP TABLE IF EXISTS `openid_association`;
1379 CREATE TABLE `openid_association` (
1380 `idp_endpoint_uri` varchar(255) default NULL,
1381 `assoc_handle` varchar(255) NOT NULL,
1382 `assoc_type` varchar(32) default NULL,
1383 `session_type` varchar(32) default NULL,
1384 `mac_key` varchar(255) default NULL,
1385 `created` int(11) NOT NULL default '0',
1386 `expires_in` int(11) NOT NULL default '0',
1387 PRIMARY KEY (`assoc_handle`)
1388 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1389
1390 --
1391 -- Table structure for table `permission`
1392 --
1393
1394 DROP TABLE IF EXISTS `permission`;
1395 CREATE TABLE `permission` (
1396 `pid` int(11) NOT NULL auto_increment,
1397 `rid` int(10) unsigned NOT NULL default '0',
1398 `perm` longtext,
1399 `tid` int(10) unsigned NOT NULL default '0',
1400 PRIMARY KEY (`pid`),
1401 KEY `rid` (`rid`)
1402 ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
1403
1404 --
1405 -- Table structure for table `poll`
1406 --
1407
1408 DROP TABLE IF EXISTS `poll`;
1409 CREATE TABLE `poll` (
1410 `nid` int(10) unsigned NOT NULL default '0',
1411 `runtime` int(11) NOT NULL default '0',
1412 `active` int(10) unsigned NOT NULL default '0',
1413 PRIMARY KEY (`nid`)
1414 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1415
1416 --
1417 -- Table structure for table `poll_choices`
1418 --
1419
1420 DROP TABLE IF EXISTS `poll_choices`;
1421 CREATE TABLE `poll_choices` (
1422 `chid` int(10) unsigned NOT NULL auto_increment,
1423 `nid` int(10) unsigned NOT NULL default '0',
1424 `chtext` varchar(128) NOT NULL default '',
1425 `chvotes` int(11) NOT NULL default '0',
1426 `chorder` int(11) NOT NULL default '0',
1427 PRIMARY KEY (`chid`),
1428 KEY `nid` (`nid`)
1429 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1430
1431 --
1432 -- Table structure for table `poll_votes`
1433 --
1434
1435 DROP TABLE IF EXISTS `poll_votes`;
1436 CREATE TABLE `poll_votes` (
1437 `nid` int(10) unsigned NOT NULL,
1438 `uid` int(10) unsigned NOT NULL default '0',
1439 `chorder` int(11) NOT NULL default '-1',
1440 `hostname` varchar(128) NOT NULL default '',
1441 PRIMARY KEY (`nid`,`uid`,`hostname`),
1442 KEY `hostname` (`hostname`),
1443 KEY `uid` (`uid`)
1444 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1445
1446 --
1447 -- Table structure for table `profile_fields`
1448 --
1449
1450 DROP TABLE IF EXISTS `profile_fields`;
1451 CREATE TABLE `profile_fields` (
1452 `fid` int(11) NOT NULL auto_increment,
1453 `title` varchar(255) default NULL,
1454 `name` varchar(128) NOT NULL default '',
1455 `explanation` text,
1456 `category` varchar(255) default NULL,
1457 `page` varchar(255) default NULL,
1458 `type` varchar(128) default NULL,
1459 `weight` tinyint(4) NOT NULL default '0',
1460 `required` tinyint(4) NOT NULL default '0',
1461 `register` tinyint(4) NOT NULL default '0',
1462 `visibility` tinyint(4) NOT NULL default '0',
1463 `autocomplete` tinyint(4) NOT NULL default '0',
1464 `options` text,
1465 PRIMARY KEY (`fid`),
1466 UNIQUE KEY `name` (`name`),
1467 KEY `category` (`category`)
1468 ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1469
1470 --
1471 -- Table structure for table `profile_values`
1472 --
1473
1474 DROP TABLE IF EXISTS `profile_values`;
1475 CREATE TABLE `profile_values` (
1476 `fid` int(10) unsigned NOT NULL default '0',
1477 `uid` int(10) unsigned NOT NULL default '0',
1478 `value` text,
1479 PRIMARY KEY (`uid`,`fid`),
1480 KEY `fid` (`fid`)
1481 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1482
1483 --
1484 -- Table structure for table `role`
1485 --
1486
1487 DROP TABLE IF EXISTS `role`;
1488 CREATE TABLE `role` (
1489 `rid` int(10) unsigned NOT NULL auto_increment,
1490 `name` varchar(64) NOT NULL default '',
1491 PRIMARY KEY (`rid`),
1492 UNIQUE KEY `name` (`name`)
1493 ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
1494
1495 --
1496 -- Table structure for table `sessions`
1497 --
1498
1499 DROP TABLE IF EXISTS `sessions`;
1500 CREATE TABLE `sessions` (
1501 `uid` int(10) unsigned NOT NULL,
1502 `sid` varchar(64) NOT NULL default '',
1503 `hostname` varchar(128) NOT NULL default '',
1504 `timestamp` int(11) NOT NULL default '0',
1505 `cache` int(11) NOT NULL default '0',
1506 `session` longtext,
1507 PRIMARY KEY (`sid`),
1508 KEY `timestamp` (`timestamp`),
1509 KEY `uid` (`uid`)
1510 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1511
1512 --
1513 -- Table structure for table `system`
1514 --
1515
1516 DROP TABLE IF EXISTS `system`;
1517 CREATE TABLE `system` (
1518 `filename` varchar(255) NOT NULL default '',
1519 `name` varchar(255) NOT NULL default '',
1520 `type` varchar(255) NOT NULL default '',
1521 `owner` varchar(255) NOT NULL default '',
1522 `status` int(11) NOT NULL default '0',
1523 `throttle` tinyint(4) NOT NULL default '0',
1524 `bootstrap` int(11) NOT NULL default '0',
1525 `schema_version` smallint(6) NOT NULL default '-1',
1526 `weight` int(11) NOT NULL default '0',
1527 `info` text,
1528 PRIMARY KEY (`filename`),
1529 KEY `modules` (`type`(12),`status`,`weight`,`filename`),
1530 KEY `bootstrap` (`type`(12),`status`,`bootstrap`,`weight`,`filename`),
1531 KEY `type_name` (`type`(12),`name`)
1532 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1533
1534 --
1535 -- Table structure for table `term_data`
1536 --
1537
1538 DROP TABLE IF EXISTS `term_data`;
1539 CREATE TABLE `term_data` (
1540 `tid` int(10) unsigned NOT NULL auto_increment,
1541 `vid` int(10) unsigned NOT NULL default '0',
1542 `name` varchar(255) NOT NULL default '',
1543 `description` longtext,
1544 `weight` tinyint(4) NOT NULL default '0',
1545 PRIMARY KEY (`tid`),
1546 KEY `taxonomy_tree` (`vid`,`weight`,`name`),
1547 KEY `vid_name` (`vid`,`name`)
1548 ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
1549
1550 --
1551 -- Table structure for table `term_hierarchy`
1552 --
1553
1554 DROP TABLE IF EXISTS `term_hierarchy`;
1555 CREATE TABLE `term_hierarchy` (
1556 `tid` int(10) unsigned NOT NULL default '0',
1557 `parent` int(10) unsigned NOT NULL default '0',
1558 PRIMARY KEY (`tid`,`parent`),
1559 KEY `parent` (`parent`)
1560 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1561
1562 --
1563 -- Table structure for table `term_node`
1564 --
1565
1566 DROP TABLE IF EXISTS `term_node`;
1567 CREATE TABLE `term_node` (
1568 `nid` int(10) unsigned NOT NULL default '0',
1569 `vid` int(10) unsigned NOT NULL default '0',
1570 `tid` int(10) unsigned NOT NULL default '0',
1571 PRIMARY KEY (`tid`,`vid`),
1572 KEY `vid` (`vid`),
1573 KEY `nid` (`nid`)
1574 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1575
1576 --
1577 -- Table structure for table `term_relation`
1578 --
1579
1580 DROP TABLE IF EXISTS `term_relation`;
1581 CREATE TABLE `term_relation` (
1582 `trid` int(11) NOT NULL auto_increment,
1583 `tid1` int(10) unsigned NOT NULL default '0',
1584 `tid2` int(10) unsigned NOT NULL default '0',
1585 PRIMARY KEY (`trid`),
1586 UNIQUE KEY `tid1_tid2` (`tid1`,`tid2`),
1587 KEY `tid2` (`tid2`)
1588 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1589
1590 --
1591 -- Table structure for table `term_synonym`
1592 --
1593
1594 DROP TABLE IF EXISTS `term_synonym`;
1595 CREATE TABLE `term_synonym` (
1596 `tsid` int(11) NOT NULL auto_increment,
1597 `tid` int(10) unsigned NOT NULL default '0',
1598 `name` varchar(255) NOT NULL default '',
1599 PRIMARY KEY (`tsid`),
1600 KEY `tid` (`tid`),
1601 KEY `name_tid` (`name`,`tid`)
1602 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1603
1604 --
1605 -- Table structure for table `translation_overview_priority`
1606 --
1607
1608 DROP TABLE IF EXISTS `translation_overview_priority`;
1609 CREATE TABLE `translation_overview_priority` (
1610 `tnid` int(10) unsigned NOT NULL,
1611 `lang_en` tinyint(3) unsigned NOT NULL default '1',
1612 `lang_fr` tinyint(3) unsigned NOT NULL default '1',
1613 `lang_de` tinyint(3) unsigned NOT NULL default '1',
1614 `lang_ptbr` tinyint(3) unsigned NOT NULL default '1',
1615 `lang_zhhant` tinyint(3) unsigned NOT NULL default '1',
1616 PRIMARY KEY (`tnid`),
1617 KEY `lang_en` (`lang_en`),
1618 KEY `lang_fr` (`lang_fr`),
1619 KEY `lang_de` (`lang_de`),
1620 KEY `lang_ptbr` (`lang_ptbr`),
1621 KEY `lang_zhhant` (`lang_zhhant`)
1622 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1623
1624 --
1625 -- Table structure for table `twitter`
1626 --
1627
1628 DROP TABLE IF EXISTS `twitter`;
1629 CREATE TABLE `twitter` (
1630 `twitter_id` decimal(20,0) unsigned NOT NULL default '0',
1631 `screen_name` varchar(255) NOT NULL default '',
1632 `created_at` varchar(64) NOT NULL default '',
1633 `created_time` int(11) NOT NULL,
1634 `text` varchar(255) default NULL,
1635 `source` varchar(255) default NULL,
1636 `in_reply_to_status_id` decimal(20,0) unsigned default NULL,
1637 `in_reply_to_user_id` decimal(20,0) unsigned default NULL,
1638 `in_reply_to_screen_name` varchar(255) default NULL,
1639 `truncated` int(10) unsigned NOT NULL default '0',
1640 PRIMARY KEY (`twitter_id`),
1641 KEY `screen_name` (`screen_name`)
1642 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1643
1644 --
1645 -- Table structure for table `twitter_account`
1646 --
1647
1648 DROP TABLE IF EXISTS `twitter_account`;
1649 CREATE TABLE `twitter_account` (
1650 `twitter_uid` decimal(20,0) unsigned NOT NULL default '0',
1651 `screen_name` varchar(255) default NULL,
1652 `name` varchar(64) NOT NULL default '',
1653 `description` varchar(255) default NULL,
1654 `location` varchar(255) default NULL,
1655 `followers_count` int(11) NOT NULL default '0',
1656 `profile_image_url` varchar(255) default NULL,
1657 `url` varchar(255) default NULL,
1658 `protected` int(10) unsigned NOT NULL default '0',
1659 `last_refresh` int(11) NOT NULL default '0',
1660 PRIMARY KEY (`twitter_uid`),
1661 KEY `screen_name` (`screen_name`)
1662 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1663
1664 --
1665 -- Table structure for table `twitter_user`
1666 --
1667
1668 DROP TABLE IF EXISTS `twitter_user`;
1669 CREATE TABLE `twitter_user` (
1670 `uid` int(11) NOT NULL,
1671 `screen_name` varchar(255) NOT NULL default '',
1672 `password` varchar(64) default NULL,
1673 `import` int(10) unsigned NOT NULL default '1',
1674 PRIMARY KEY (`uid`,`screen_name`),
1675 KEY `screen_name` (`screen_name`),
1676 KEY `uid` (`uid`),
1677 KEY `import` (`import`)
1678 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1679
1680 --
1681 -- Table structure for table `upload`
1682 --
1683
1684 DROP TABLE IF EXISTS `upload`;
1685 CREATE TABLE `upload` (
1686 `fid` int(10) unsigned NOT NULL default '0',
1687 `nid` int(10) unsigned NOT NULL default '0',
1688 `vid` int(10) unsigned NOT NULL default '0',
1689 `description` varchar(255) NOT NULL default '',
1690 `list` tinyint(3) unsigned NOT NULL default '0',
1691 `weight` tinyint(4) NOT NULL default '0',
1692 PRIMARY KEY (`vid`,`fid`),
1693 KEY `fid` (`fid`),
1694 KEY `nid` (`nid`)
1695 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1696
1697 --
1698 -- Table structure for table `url_alias`
1699 --
1700
1701 DROP TABLE IF EXISTS `url_alias`;
1702 CREATE TABLE `url_alias` (
1703 `pid` int(10) unsigned NOT NULL auto_increment,
1704 `src` varchar(128) NOT NULL default '',
1705 `dst` varchar(128) NOT NULL default '',
1706 `language` varchar(12) NOT NULL default '',
1707 PRIMARY KEY (`pid`),
1708 UNIQUE KEY `dst_language` (`dst`,`language`),
1709 KEY `src_language` (`src`,`language`)
1710 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1711
1712 --
1713 -- Table structure for table `users`
1714 --
1715
1716 DROP TABLE IF EXISTS `users`;
1717 CREATE TABLE `users` (
1718 `uid` int(10) unsigned NOT NULL auto_increment,
1719 `name` varchar(60) NOT NULL default '',
1720 `pass` varchar(32) NOT NULL default '',
1721 `mail` varchar(64) default '',
1722 `mode` tinyint(4) NOT NULL default '0',
1723 `sort` tinyint(4) default '0',
1724 `threshold` tinyint(4) default '0',
1725 `theme` varchar(255) NOT NULL default '',
1726 `signature` varchar(255) NOT NULL default '',
1727 `signature_format` smallint(6) NOT NULL default '0',
1728 `created` int(11) NOT NULL default '0',
1729 `access` int(11) NOT NULL default '0',
1730 `login` int(11) NOT NULL default '0',
1731 `status` tinyint(4) NOT NULL default '0',
1732 `timezone` varchar(8) default NULL,
1733 `language` varchar(12) NOT NULL default '',
1734 `picture` varchar(255) NOT NULL default '',
1735 `init` varchar(64) default '',
1736 `data` longtext,
1737 PRIMARY KEY (`uid`),
1738 UNIQUE KEY `name` (`name`),
1739 KEY `access` (`access`),
1740 KEY `created` (`created`),
1741 KEY `mail` (`mail`)
1742 ) ENGINE=MyISAM AUTO_INCREMENT=611 DEFAULT CHARSET=utf8;
1743
1744 --
1745 -- Table structure for table `users_roles`
1746 --
1747
1748 DROP TABLE IF EXISTS `users_roles`;
1749 CREATE TABLE `users_roles` (
1750 `uid` int(10) unsigned NOT NULL default '0',
1751 `rid` int(10) unsigned NOT NULL default '0',
1752 PRIMARY KEY (`uid`,`rid`),
1753 KEY `rid` (`rid`)
1754 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1755
1756 --
1757 -- Table structure for table `variable`
1758 --
1759
1760 DROP TABLE IF EXISTS `variable`;
1761 CREATE TABLE `variable` (
1762 `name` varchar(128) NOT NULL default '',
1763 `value` longtext NOT NULL,
1764 PRIMARY KEY (`name`)
1765 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1766
1767 --
1768 -- Table structure for table `vocabulary`
1769 --
1770
1771 DROP TABLE IF EXISTS `vocabulary`;
1772 CREATE TABLE `vocabulary` (
1773 `vid` int(10) unsigned NOT NULL auto_increment,
1774 `name` varchar(255) NOT NULL default '',
1775 `description` longtext,
1776 `help` varchar(255) NOT NULL default '',
1777 `relations` tinyint(3) unsigned NOT NULL default '0',
1778 `hierarchy` tinyint(3) unsigned NOT NULL default '0',
1779 `multiple` tinyint(3) unsigned NOT NULL default '0',
1780 `required` tinyint(3) unsigned NOT NULL default '0',
1781 `tags` tinyint(3) unsigned NOT NULL default '0',
1782 `module` varchar(255) NOT NULL default '',
1783 `weight` tinyint(4) NOT NULL default '0',
1784 PRIMARY KEY (`vid`),
1785 KEY `list` (`weight`,`name`)
1786 ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1787
1788 --
1789 -- Table structure for table `vocabulary_node_types`
1790 --
1791
1792 DROP TABLE IF EXISTS `vocabulary_node_types`;
1793 CREATE TABLE `vocabulary_node_types` (
1794 `vid` int(10) unsigned NOT NULL default '0',
1795 `type` varchar(32) NOT NULL default '',
1796 PRIMARY KEY (`type`,`vid`),
1797 KEY `vid` (`vid`)
1798 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1799
1800 --
1801 -- Table structure for table `watchdog`
1802 --
1803
1804 DROP TABLE IF EXISTS `watchdog`;
1805 CREATE TABLE `watchdog` (
1806 `wid` int(11) NOT NULL auto_increment,
1807 `uid` int(11) NOT NULL default '0',
1808 `type` varchar(16) NOT NULL default '',
1809 `message` longtext NOT NULL,
1810 `variables` longtext NOT NULL,
1811 `severity` tinyint(3) unsigned NOT NULL default '0',
1812 `link` varchar(255) NOT NULL default '',
1813 `location` text NOT NULL,
1814 `referer` text,
1815 `hostname` varchar(128) NOT NULL default '',
1816 `timestamp` int(11) NOT NULL default '0',
1817 PRIMARY KEY (`wid`),
1818 KEY `type` (`type`)
1819 ) ENGINE=MyISAM AUTO_INCREMENT=10149 DEFAULT CHARSET=utf8;
1820 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1821
1822 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1823 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1824 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1825 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1826 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1827 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1828 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1829
1830 -- Dump completed on 2010-12-22 8:55:59