slitaz-forge 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 | 8c8667451eab |
files | forum/mysql/init-db.sql forum/mysql/vanilla-2.0.16.sql forum/system-config/apache/forum.slitaz.org.conf forum/system-config/awstats/awstats.forum.slitaz.org.conf forum/system-config/logrotate.d/slitaz-forum forum/vanilla-config/config.php |
line diff
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/forum/mysql/init-db.sql Wed Dec 22 10:25:56 2010 +0100 1.3 @@ -0,0 +1,9 @@ 1.4 +--- Create DB and DB User for slitaz forum 1.5 +--- 1.6 + 1.7 +USE Mysql; 1.8 +CREATE DATABASE slitaz_forum; 1.9 + 1.10 +GRANT ALL PRIVILEGES ON slitaz_forum.* TO slitaz IDENTIFIED BY 'slitaz'; 1.11 + 1.12 +
2.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 2.2 +++ b/forum/mysql/vanilla-2.0.16.sql Wed Dec 22 10:25:56 2010 +0100 2.3 @@ -0,0 +1,1830 @@ 2.4 +-- MySQL dump 10.11 2.5 +-- 2.6 +-- Host: localhost Database: slitaz_forum 2.7 +-- ------------------------------------------------------ 2.8 +-- Server version 5.0.32-Debian_7etch12-log 2.9 + 2.10 +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 2.11 +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 2.12 +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; 2.13 +/*!40101 SET NAMES utf8 */; 2.14 +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; 2.15 +/*!40103 SET TIME_ZONE='+00:00' */; 2.16 +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; 2.17 +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; 2.18 +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; 2.19 +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; 2.20 + 2.21 +-- 2.22 +-- Table structure for table `GDN_Activity` 2.23 +-- 2.24 + 2.25 +DROP TABLE IF EXISTS `GDN_Activity`; 2.26 +CREATE TABLE `GDN_Activity` ( 2.27 + `ActivityID` int(11) NOT NULL auto_increment, 2.28 + `CommentActivityID` int(11) default NULL, 2.29 + `ActivityTypeID` int(11) NOT NULL, 2.30 + `ActivityUserID` int(11) default NULL, 2.31 + `RegardingUserID` int(11) default NULL, 2.32 + `Story` text collate utf8_unicode_ci, 2.33 + `Route` varchar(255) collate utf8_unicode_ci default NULL, 2.34 + `CountComments` int(11) NOT NULL default '0', 2.35 + `InsertUserID` int(11) default NULL, 2.36 + `DateInserted` datetime NOT NULL, 2.37 + PRIMARY KEY (`ActivityID`), 2.38 + KEY `FK_Activity_CommentActivityID` (`CommentActivityID`), 2.39 + KEY `FK_Activity_ActivityUserID` (`ActivityUserID`), 2.40 + KEY `FK_Activity_InsertUserID` (`InsertUserID`) 2.41 +) ENGINE=MyISAM AUTO_INCREMENT=11612 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.42 + 2.43 +-- 2.44 +-- Table structure for table `GDN_ActivityType` 2.45 +-- 2.46 + 2.47 +DROP TABLE IF EXISTS `GDN_ActivityType`; 2.48 +CREATE TABLE `GDN_ActivityType` ( 2.49 + `ActivityTypeID` int(11) NOT NULL auto_increment, 2.50 + `Name` varchar(20) collate utf8_unicode_ci NOT NULL, 2.51 + `AllowComments` tinyint(1) NOT NULL default '0', 2.52 + `ShowIcon` tinyint(1) NOT NULL default '0', 2.53 + `ProfileHeadline` varchar(255) collate utf8_unicode_ci NOT NULL, 2.54 + `FullHeadline` varchar(255) collate utf8_unicode_ci NOT NULL, 2.55 + `RouteCode` varchar(255) collate utf8_unicode_ci default NULL, 2.56 + `Notify` tinyint(1) NOT NULL default '0', 2.57 + `Public` tinyint(1) NOT NULL default '1', 2.58 + PRIMARY KEY (`ActivityTypeID`) 2.59 +) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.60 + 2.61 +-- 2.62 +-- Table structure for table `GDN_Category` 2.63 +-- 2.64 + 2.65 +DROP TABLE IF EXISTS `GDN_Category`; 2.66 +CREATE TABLE `GDN_Category` ( 2.67 + `CategoryID` int(11) NOT NULL auto_increment, 2.68 + `ParentCategoryID` int(11) default NULL, 2.69 + `CountDiscussions` int(11) NOT NULL default '0', 2.70 + `AllowDiscussions` tinyint(4) NOT NULL default '1', 2.71 + `Name` varchar(30) collate utf8_unicode_ci NOT NULL, 2.72 + `Description` varchar(250) collate utf8_unicode_ci default NULL, 2.73 + `Sort` int(11) default NULL, 2.74 + `InsertUserID` int(11) NOT NULL, 2.75 + `UpdateUserID` int(11) default NULL, 2.76 + `DateInserted` datetime NOT NULL, 2.77 + `DateUpdated` datetime NOT NULL, 2.78 + `UrlCode` varchar(30) collate utf8_unicode_ci default NULL, 2.79 + PRIMARY KEY (`CategoryID`), 2.80 + KEY `FK_Category_InsertUserID` (`InsertUserID`) 2.81 +) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.82 + 2.83 +-- 2.84 +-- Table structure for table `GDN_Comment` 2.85 +-- 2.86 + 2.87 +DROP TABLE IF EXISTS `GDN_Comment`; 2.88 +CREATE TABLE `GDN_Comment` ( 2.89 + `CommentID` int(11) NOT NULL auto_increment, 2.90 + `DiscussionID` int(11) NOT NULL, 2.91 + `InsertUserID` int(11) default NULL, 2.92 + `UpdateUserID` int(11) default NULL, 2.93 + `DeleteUserID` int(11) default NULL, 2.94 + `Body` text collate utf8_unicode_ci NOT NULL, 2.95 + `Format` varchar(20) collate utf8_unicode_ci default NULL, 2.96 + `DateInserted` datetime default NULL, 2.97 + `DateDeleted` datetime default NULL, 2.98 + `DateUpdated` datetime default NULL, 2.99 + `Flag` tinyint(4) NOT NULL default '0', 2.100 + `ReplyCommentID` int(11) default NULL, 2.101 + `CountReplies` int(11) NOT NULL default '0', 2.102 + `Score` float default NULL, 2.103 + `Attributes` text collate utf8_unicode_ci, 2.104 + PRIMARY KEY (`CommentID`), 2.105 + KEY `FK_Comment_DiscussionID` (`DiscussionID`), 2.106 + KEY `FK_Comment_InsertUserID` (`InsertUserID`), 2.107 + KEY `FK_Comment_ReplyCommentID` (`ReplyCommentID`), 2.108 + KEY `FK_Comment_DateInserted` (`DateInserted`), 2.109 + FULLTEXT KEY `TX_Comment` (`Body`) 2.110 +) ENGINE=MyISAM AUTO_INCREMENT=10904 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.111 + 2.112 +-- 2.113 +-- Table structure for table `GDN_CommentWatch` 2.114 +-- 2.115 + 2.116 +DROP TABLE IF EXISTS `GDN_CommentWatch`; 2.117 +CREATE TABLE `GDN_CommentWatch` ( 2.118 + `UserID` int(11) NOT NULL, 2.119 + `CommentID` int(11) NOT NULL, 2.120 + `DateLastViewed` datetime NOT NULL, 2.121 + `CountReplies` int(11) NOT NULL default '0', 2.122 + PRIMARY KEY (`UserID`,`CommentID`) 2.123 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.124 + 2.125 +-- 2.126 +-- Table structure for table `GDN_Conversation` 2.127 +-- 2.128 + 2.129 +DROP TABLE IF EXISTS `GDN_Conversation`; 2.130 +CREATE TABLE `GDN_Conversation` ( 2.131 + `ConversationID` int(11) NOT NULL auto_increment, 2.132 + `Contributors` varchar(255) collate utf8_unicode_ci NOT NULL, 2.133 + `FirstMessageID` int(11) default NULL, 2.134 + `InsertUserID` int(11) NOT NULL, 2.135 + `DateInserted` datetime default NULL, 2.136 + `UpdateUserID` int(11) NOT NULL, 2.137 + `DateUpdated` datetime NOT NULL, 2.138 + `CountMessages` int(11) NOT NULL, 2.139 + `LastMessageID` int(11) NOT NULL, 2.140 + PRIMARY KEY (`ConversationID`), 2.141 + KEY `FK_Conversation_FirstMessageID` (`FirstMessageID`), 2.142 + KEY `FK_Conversation_InsertUserID` (`InsertUserID`), 2.143 + KEY `FK_Conversation_UpdateUserID` (`UpdateUserID`), 2.144 + KEY `FK_Conversation_DateInserted` (`DateInserted`) 2.145 +) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.146 + 2.147 +-- 2.148 +-- Table structure for table `GDN_ConversationMessage` 2.149 +-- 2.150 + 2.151 +DROP TABLE IF EXISTS `GDN_ConversationMessage`; 2.152 +CREATE TABLE `GDN_ConversationMessage` ( 2.153 + `MessageID` int(11) NOT NULL auto_increment, 2.154 + `ConversationID` int(11) NOT NULL, 2.155 + `Body` text collate utf8_unicode_ci NOT NULL, 2.156 + `Format` varchar(20) collate utf8_unicode_ci default NULL, 2.157 + `InsertUserID` int(11) default NULL, 2.158 + `DateInserted` datetime NOT NULL, 2.159 + PRIMARY KEY (`MessageID`), 2.160 + KEY `FK_ConversationMessage_InsertUserID` (`InsertUserID`), 2.161 + KEY `FK_ConversationMessage_DateInserted` (`DateInserted`), 2.162 + KEY `FK_ConversationMessage_ConversationID` (`ConversationID`) 2.163 +) ENGINE=MyISAM AUTO_INCREMENT=96 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.164 + 2.165 +-- 2.166 +-- Table structure for table `GDN_Discussion` 2.167 +-- 2.168 + 2.169 +DROP TABLE IF EXISTS `GDN_Discussion`; 2.170 +CREATE TABLE `GDN_Discussion` ( 2.171 + `DiscussionID` int(11) NOT NULL auto_increment, 2.172 + `CategoryID` int(11) NOT NULL, 2.173 + `InsertUserID` int(11) NOT NULL, 2.174 + `UpdateUserID` int(11) NOT NULL, 2.175 + `LastCommentID` int(11) default NULL, 2.176 + `Name` varchar(100) collate utf8_unicode_ci NOT NULL, 2.177 + `CountComments` int(11) NOT NULL default '1', 2.178 + `CountBookmarks` int(11) default NULL, 2.179 + `CountViews` int(11) NOT NULL default '1', 2.180 + `Closed` tinyint(1) NOT NULL default '0', 2.181 + `Announce` tinyint(1) NOT NULL default '0', 2.182 + `Sink` tinyint(1) NOT NULL default '0', 2.183 + `DateInserted` datetime default NULL, 2.184 + `DateUpdated` datetime NOT NULL, 2.185 + `DateLastComment` datetime default NULL, 2.186 + `Attributes` text collate utf8_unicode_ci, 2.187 + `CountReplies` int(11) NOT NULL default '0', 2.188 + `Body` text collate utf8_unicode_ci NOT NULL, 2.189 + `Format` varchar(20) collate utf8_unicode_ci default NULL, 2.190 + `Tags` varchar(255) collate utf8_unicode_ci default NULL, 2.191 + `LastCommentUserID` int(11) default NULL, 2.192 + `Score` float default NULL, 2.193 + PRIMARY KEY (`DiscussionID`), 2.194 + KEY `FK_Discussion_CategoryID` (`CategoryID`), 2.195 + KEY `FK_Discussion_InsertUserID` (`InsertUserID`), 2.196 + KEY `FK_Discussion_LastCommentID` (`LastCommentID`), 2.197 + KEY `IX_Discussion_DateLastComment` (`DateLastComment`), 2.198 + FULLTEXT KEY `TX_Discussion` (`Name`,`Body`) 2.199 +) ENGINE=MyISAM AUTO_INCREMENT=2286 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.200 + 2.201 +-- 2.202 +-- Table structure for table `GDN_Draft` 2.203 +-- 2.204 + 2.205 +DROP TABLE IF EXISTS `GDN_Draft`; 2.206 +CREATE TABLE `GDN_Draft` ( 2.207 + `DraftID` int(11) NOT NULL auto_increment, 2.208 + `DiscussionID` int(11) default NULL, 2.209 + `CategoryID` int(11) default NULL, 2.210 + `InsertUserID` int(11) NOT NULL, 2.211 + `UpdateUserID` int(11) NOT NULL, 2.212 + `Name` varchar(100) collate utf8_unicode_ci default NULL, 2.213 + `Tags` varchar(255) collate utf8_unicode_ci default NULL, 2.214 + `Closed` tinyint(1) NOT NULL default '0', 2.215 + `Announce` tinyint(1) NOT NULL default '0', 2.216 + `Sink` tinyint(1) NOT NULL default '0', 2.217 + `Body` text collate utf8_unicode_ci NOT NULL, 2.218 + `Format` varchar(20) collate utf8_unicode_ci default NULL, 2.219 + `DateInserted` datetime NOT NULL, 2.220 + `DateUpdated` datetime default NULL, 2.221 + PRIMARY KEY (`DraftID`), 2.222 + KEY `FK_Draft_DiscussionID` (`DiscussionID`), 2.223 + KEY `FK_Draft_CategoryID` (`CategoryID`), 2.224 + KEY `FK_Draft_InsertUserID` (`InsertUserID`) 2.225 +) ENGINE=MyISAM AUTO_INCREMENT=9605 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.226 + 2.227 +-- 2.228 +-- Table structure for table `GDN_Invitation` 2.229 +-- 2.230 + 2.231 +DROP TABLE IF EXISTS `GDN_Invitation`; 2.232 +CREATE TABLE `GDN_Invitation` ( 2.233 + `InvitationID` int(11) NOT NULL auto_increment, 2.234 + `Email` varchar(200) collate utf8_unicode_ci NOT NULL, 2.235 + `Code` varchar(50) collate utf8_unicode_ci NOT NULL, 2.236 + `InsertUserID` int(11) default NULL, 2.237 + `DateInserted` datetime NOT NULL, 2.238 + `AcceptedUserID` int(11) default NULL, 2.239 + PRIMARY KEY (`InvitationID`), 2.240 + KEY `FK_Invitation_InsertUserID` (`InsertUserID`) 2.241 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.242 + 2.243 +-- 2.244 +-- Table structure for table `GDN_Media` 2.245 +-- 2.246 + 2.247 +DROP TABLE IF EXISTS `GDN_Media`; 2.248 +CREATE TABLE `GDN_Media` ( 2.249 + `MediaID` int(11) NOT NULL auto_increment, 2.250 + `Name` varchar(255) collate utf8_unicode_ci NOT NULL, 2.251 + `Type` varchar(128) collate utf8_unicode_ci NOT NULL, 2.252 + `Size` int(11) NOT NULL, 2.253 + `StorageMethod` varchar(24) collate utf8_unicode_ci NOT NULL, 2.254 + `Path` varchar(255) collate utf8_unicode_ci NOT NULL, 2.255 + `InsertUserID` int(11) NOT NULL, 2.256 + `DateInserted` datetime NOT NULL, 2.257 + `ForeignID` int(11) default NULL, 2.258 + `ForeignTable` varchar(24) collate utf8_unicode_ci default NULL, 2.259 + PRIMARY KEY (`MediaID`) 2.260 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.261 + 2.262 +-- 2.263 +-- Table structure for table `GDN_Message` 2.264 +-- 2.265 + 2.266 +DROP TABLE IF EXISTS `GDN_Message`; 2.267 +CREATE TABLE `GDN_Message` ( 2.268 + `MessageID` int(11) NOT NULL auto_increment, 2.269 + `Content` text collate utf8_unicode_ci NOT NULL, 2.270 + `Format` varchar(20) collate utf8_unicode_ci default NULL, 2.271 + `AllowDismiss` tinyint(1) NOT NULL default '1', 2.272 + `Enabled` tinyint(1) NOT NULL default '1', 2.273 + `Application` varchar(255) collate utf8_unicode_ci default NULL, 2.274 + `Controller` varchar(255) collate utf8_unicode_ci default NULL, 2.275 + `Method` varchar(255) collate utf8_unicode_ci default NULL, 2.276 + `AssetTarget` varchar(20) collate utf8_unicode_ci default NULL, 2.277 + `CssClass` varchar(20) collate utf8_unicode_ci default NULL, 2.278 + `Sort` int(11) default NULL, 2.279 + PRIMARY KEY (`MessageID`) 2.280 +) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.281 + 2.282 +-- 2.283 +-- Table structure for table `GDN_Permission` 2.284 +-- 2.285 + 2.286 +DROP TABLE IF EXISTS `GDN_Permission`; 2.287 +CREATE TABLE `GDN_Permission` ( 2.288 + `PermissionID` int(11) NOT NULL auto_increment, 2.289 + `RoleID` int(11) NOT NULL default '0', 2.290 + `JunctionTable` varchar(100) collate utf8_unicode_ci default NULL, 2.291 + `JunctionColumn` varchar(100) collate utf8_unicode_ci default NULL, 2.292 + `JunctionID` int(11) default NULL, 2.293 + `Garden.Email.Manage` tinyint(4) NOT NULL default '0', 2.294 + `Garden.Settings.Manage` tinyint(4) NOT NULL default '0', 2.295 + `Garden.Routes.Manage` tinyint(4) NOT NULL default '0', 2.296 + `Garden.Messages.Manage` tinyint(4) NOT NULL default '0', 2.297 + `Garden.Applications.Manage` tinyint(4) NOT NULL default '0', 2.298 + `Garden.Plugins.Manage` tinyint(4) NOT NULL default '0', 2.299 + `Garden.Themes.Manage` tinyint(4) NOT NULL default '0', 2.300 + `Garden.SignIn.Allow` tinyint(4) NOT NULL default '0', 2.301 + `Garden.Registration.Manage` tinyint(4) NOT NULL default '0', 2.302 + `Garden.Applicants.Manage` tinyint(4) NOT NULL default '0', 2.303 + `Garden.Roles.Manage` tinyint(4) NOT NULL default '0', 2.304 + `Garden.Users.Add` tinyint(4) NOT NULL default '0', 2.305 + `Garden.Users.Edit` tinyint(4) NOT NULL default '0', 2.306 + `Garden.Users.Delete` tinyint(4) NOT NULL default '0', 2.307 + `Garden.Users.Approve` tinyint(4) NOT NULL default '0', 2.308 + `Garden.Activity.Delete` tinyint(4) NOT NULL default '0', 2.309 + `Garden.Activity.View` tinyint(4) NOT NULL default '0', 2.310 + `Garden.Profiles.View` tinyint(4) NOT NULL default '0', 2.311 + `Vanilla.Settings.Manage` tinyint(4) NOT NULL default '0', 2.312 + `Vanilla.Categories.Manage` tinyint(4) NOT NULL default '0', 2.313 + `Vanilla.Spam.Manage` tinyint(4) NOT NULL default '0', 2.314 + `Vanilla.Discussions.View` tinyint(4) NOT NULL default '0', 2.315 + `Vanilla.Discussions.Add` tinyint(4) NOT NULL default '0', 2.316 + `Vanilla.Discussions.Edit` tinyint(4) NOT NULL default '0', 2.317 + `Vanilla.Discussions.Announce` tinyint(4) NOT NULL default '0', 2.318 + `Vanilla.Discussions.Sink` tinyint(4) NOT NULL default '0', 2.319 + `Vanilla.Discussions.Close` tinyint(4) NOT NULL default '0', 2.320 + `Vanilla.Discussions.Delete` tinyint(4) NOT NULL default '0', 2.321 + `Vanilla.Comments.Add` tinyint(4) NOT NULL default '0', 2.322 + `Vanilla.Comments.Edit` tinyint(4) NOT NULL default '0', 2.323 + `Vanilla.Comments.Delete` tinyint(4) NOT NULL default '0', 2.324 + `Plugins.Debugger.View` tinyint(4) NOT NULL default '0', 2.325 + `Plugins.Debugger.Manage` tinyint(4) NOT NULL default '0', 2.326 + `Plugins.Attachments.Upload.Allow` tinyint(4) NOT NULL default '0', 2.327 + `Plugins.Attachments.Download.Allow` tinyint(4) NOT NULL default '0', 2.328 + PRIMARY KEY (`PermissionID`), 2.329 + KEY `FK_Permission_RoleID` (`RoleID`) 2.330 +) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.331 + 2.332 +-- 2.333 +-- Table structure for table `GDN_Photo` 2.334 +-- 2.335 + 2.336 +DROP TABLE IF EXISTS `GDN_Photo`; 2.337 +CREATE TABLE `GDN_Photo` ( 2.338 + `PhotoID` int(11) NOT NULL auto_increment, 2.339 + `Name` varchar(255) collate utf8_unicode_ci NOT NULL, 2.340 + `InsertUserID` int(11) default NULL, 2.341 + `DateInserted` datetime NOT NULL, 2.342 + PRIMARY KEY (`PhotoID`), 2.343 + KEY `FK_Photo_InsertUserID` (`InsertUserID`) 2.344 +) ENGINE=MyISAM AUTO_INCREMENT=105 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.345 + 2.346 +-- 2.347 +-- Table structure for table `GDN_Role` 2.348 +-- 2.349 + 2.350 +DROP TABLE IF EXISTS `GDN_Role`; 2.351 +CREATE TABLE `GDN_Role` ( 2.352 + `RoleID` int(11) NOT NULL auto_increment, 2.353 + `Name` varchar(100) collate utf8_unicode_ci NOT NULL, 2.354 + `Description` varchar(500) collate utf8_unicode_ci default NULL, 2.355 + `Sort` int(11) default NULL, 2.356 + `Deletable` tinyint(1) NOT NULL default '1', 2.357 + `CanSession` tinyint(1) NOT NULL default '1', 2.358 + PRIMARY KEY (`RoleID`) 2.359 +) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.360 + 2.361 +-- 2.362 +-- Table structure for table `GDN_SearchDocument` 2.363 +-- 2.364 + 2.365 +DROP TABLE IF EXISTS `GDN_SearchDocument`; 2.366 +CREATE TABLE `GDN_SearchDocument` ( 2.367 + `DocumentID` int(11) NOT NULL auto_increment, 2.368 + `TableName` varchar(50) collate utf8_unicode_ci NOT NULL, 2.369 + `PrimaryID` int(11) NOT NULL, 2.370 + `PermissionJunctionID` int(11) default NULL, 2.371 + `Title` varchar(100) collate utf8_unicode_ci NOT NULL, 2.372 + `Summary` varchar(200) collate utf8_unicode_ci NOT NULL, 2.373 + `Url` varchar(255) collate utf8_unicode_ci NOT NULL, 2.374 + `InsertUserID` int(11) NOT NULL, 2.375 + `DateInserted` datetime NOT NULL, 2.376 + PRIMARY KEY (`DocumentID`) 2.377 +) ENGINE=MyISAM AUTO_INCREMENT=5633 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.378 + 2.379 +-- 2.380 +-- Table structure for table `GDN_SearchKeyword` 2.381 +-- 2.382 + 2.383 +DROP TABLE IF EXISTS `GDN_SearchKeyword`; 2.384 +CREATE TABLE `GDN_SearchKeyword` ( 2.385 + `KeywordID` int(11) NOT NULL auto_increment, 2.386 + `Keyword` varchar(50) collate utf8_unicode_ci NOT NULL, 2.387 + PRIMARY KEY (`KeywordID`), 2.388 + KEY `FK_SearchKeyword_Keyword` (`Keyword`) 2.389 +) ENGINE=MyISAM AUTO_INCREMENT=26642 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.390 + 2.391 +-- 2.392 +-- Table structure for table `GDN_SearchKeywordDocument` 2.393 +-- 2.394 + 2.395 +DROP TABLE IF EXISTS `GDN_SearchKeywordDocument`; 2.396 +CREATE TABLE `GDN_SearchKeywordDocument` ( 2.397 + `KeywordID` int(11) NOT NULL, 2.398 + `DocumentID` int(11) NOT NULL, 2.399 + PRIMARY KEY (`KeywordID`,`DocumentID`) 2.400 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.401 + 2.402 +-- 2.403 +-- Table structure for table `GDN_TableType` 2.404 +-- 2.405 + 2.406 +DROP TABLE IF EXISTS `GDN_TableType`; 2.407 +CREATE TABLE `GDN_TableType` ( 2.408 + `TableName` varchar(50) collate utf8_unicode_ci NOT NULL, 2.409 + `PermissionTableName` varchar(50) collate utf8_unicode_ci default NULL, 2.410 + PRIMARY KEY (`TableName`) 2.411 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.412 + 2.413 +-- 2.414 +-- Table structure for table `GDN_Tag` 2.415 +-- 2.416 + 2.417 +DROP TABLE IF EXISTS `GDN_Tag`; 2.418 +CREATE TABLE `GDN_Tag` ( 2.419 + `CountDiscussions` int(11) NOT NULL default '0', 2.420 + `TagID` int(11) NOT NULL auto_increment, 2.421 + `Name` varchar(255) collate utf8_unicode_ci NOT NULL default 'unique', 2.422 + `InsertUserID` int(11) default NULL, 2.423 + `DateInserted` datetime NOT NULL, 2.424 + PRIMARY KEY (`TagID`), 2.425 + KEY `FK_Tag_InsertUserID` (`InsertUserID`) 2.426 +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.427 + 2.428 +-- 2.429 +-- Table structure for table `GDN_TagDiscussion` 2.430 +-- 2.431 + 2.432 +DROP TABLE IF EXISTS `GDN_TagDiscussion`; 2.433 +CREATE TABLE `GDN_TagDiscussion` ( 2.434 + `TagID` int(11) NOT NULL, 2.435 + `DiscussionID` int(11) NOT NULL, 2.436 + PRIMARY KEY (`TagID`,`DiscussionID`) 2.437 +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.438 + 2.439 +-- 2.440 +-- Table structure for table `GDN_User` 2.441 +-- 2.442 + 2.443 +DROP TABLE IF EXISTS `GDN_User`; 2.444 +CREATE TABLE `GDN_User` ( 2.445 + `UserID` int(11) NOT NULL auto_increment, 2.446 + `Name` varchar(20) collate utf8_unicode_ci NOT NULL, 2.447 + `Password` varbinary(50) NOT NULL, 2.448 + `About` text collate utf8_unicode_ci, 2.449 + `Email` varchar(200) collate utf8_unicode_ci NOT NULL, 2.450 + `ShowEmail` tinyint(1) NOT NULL default '0', 2.451 + `Gender` enum('m','f') collate utf8_unicode_ci NOT NULL default 'm', 2.452 + `CountVisits` int(11) NOT NULL default '0', 2.453 + `CountInvitations` int(11) NOT NULL default '0', 2.454 + `CountNotifications` int(11) default NULL, 2.455 + `InviteUserID` int(11) default NULL, 2.456 + `DiscoveryText` text collate utf8_unicode_ci, 2.457 + `Preferences` text collate utf8_unicode_ci, 2.458 + `Permissions` text collate utf8_unicode_ci, 2.459 + `Attributes` text collate utf8_unicode_ci, 2.460 + `DateSetInvitations` datetime default NULL, 2.461 + `DateOfBirth` datetime default NULL, 2.462 + `DateFirstVisit` datetime default NULL, 2.463 + `DateLastActive` datetime default NULL, 2.464 + `DateInserted` datetime NOT NULL, 2.465 + `DateUpdated` datetime default NULL, 2.466 + `HourOffset` int(11) NOT NULL default '0', 2.467 + `CacheRoleID` int(11) default NULL, 2.468 + `Admin` tinyint(1) NOT NULL default '0', 2.469 + `CountDiscussions` int(11) default NULL, 2.470 + `CountUnreadDiscussions` int(11) default NULL, 2.471 + `CountComments` int(11) default NULL, 2.472 + `CountDrafts` int(11) default NULL, 2.473 + `CountBookmarks` int(11) default NULL, 2.474 + `CountUnreadConversations` int(11) default NULL, 2.475 + `HashMethod` varchar(10) collate utf8_unicode_ci default NULL, 2.476 + `Photo` varchar(255) collate utf8_unicode_ci default NULL, 2.477 + `Score` float default NULL, 2.478 + `Deleted` tinyint(1) NOT NULL default '0', 2.479 + `DateAllViewed` datetime default NULL, 2.480 + PRIMARY KEY (`UserID`), 2.481 + KEY `FK_User_Name` (`Name`) 2.482 +) ENGINE=MyISAM AUTO_INCREMENT=1893 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.483 + 2.484 +-- 2.485 +-- Table structure for table `GDN_UserAuthentication` 2.486 +-- 2.487 + 2.488 +DROP TABLE IF EXISTS `GDN_UserAuthentication`; 2.489 +CREATE TABLE `GDN_UserAuthentication` ( 2.490 + `UniqueID` varchar(30) collate utf8_unicode_ci NOT NULL, 2.491 + `UserID` int(11) NOT NULL, 2.492 + `ForeignUserKey` varchar(255) collate utf8_unicode_ci NOT NULL, 2.493 + `ProviderKey` varchar(64) collate utf8_unicode_ci NOT NULL, 2.494 + PRIMARY KEY (`ForeignUserKey`,`ProviderKey`), 2.495 + KEY `FK_UserAuthentication_UserID` (`UserID`) 2.496 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.497 + 2.498 +-- 2.499 +-- Table structure for table `GDN_UserAuthenticationNonce` 2.500 +-- 2.501 + 2.502 +DROP TABLE IF EXISTS `GDN_UserAuthenticationNonce`; 2.503 +CREATE TABLE `GDN_UserAuthenticationNonce` ( 2.504 + `Nonce` varchar(200) collate utf8_unicode_ci NOT NULL, 2.505 + `Token` varchar(128) collate utf8_unicode_ci NOT NULL, 2.506 + `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 2.507 + PRIMARY KEY (`Nonce`) 2.508 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.509 + 2.510 +-- 2.511 +-- Table structure for table `GDN_UserAuthenticationProvider` 2.512 +-- 2.513 + 2.514 +DROP TABLE IF EXISTS `GDN_UserAuthenticationProvider`; 2.515 +CREATE TABLE `GDN_UserAuthenticationProvider` ( 2.516 + `AuthenticationKey` varchar(64) collate utf8_unicode_ci NOT NULL, 2.517 + `AuthenticationSchemeAlias` varchar(32) collate utf8_unicode_ci NOT NULL, 2.518 + `URL` varchar(255) collate utf8_unicode_ci default NULL, 2.519 + `AssociationSecret` text collate utf8_unicode_ci NOT NULL, 2.520 + `AssociationHashMethod` enum('HMAC-SHA1','HMAC-PLAINTEXT') collate utf8_unicode_ci NOT NULL, 2.521 + `AuthenticateUrl` varchar(255) collate utf8_unicode_ci default NULL, 2.522 + `RegisterUrl` varchar(255) collate utf8_unicode_ci default NULL, 2.523 + `SignInUrl` varchar(255) collate utf8_unicode_ci default NULL, 2.524 + `SignOutUrl` varchar(255) collate utf8_unicode_ci default NULL, 2.525 + `PasswordUrl` varchar(255) collate utf8_unicode_ci default NULL, 2.526 + `ProfileUrl` varchar(255) collate utf8_unicode_ci default NULL, 2.527 + PRIMARY KEY (`AuthenticationKey`) 2.528 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.529 + 2.530 +-- 2.531 +-- Table structure for table `GDN_UserAuthenticationToken` 2.532 +-- 2.533 + 2.534 +DROP TABLE IF EXISTS `GDN_UserAuthenticationToken`; 2.535 +CREATE TABLE `GDN_UserAuthenticationToken` ( 2.536 + `Token` varchar(128) collate utf8_unicode_ci NOT NULL, 2.537 + `ProviderKey` varchar(64) collate utf8_unicode_ci NOT NULL, 2.538 + `ForeignUserKey` varchar(255) collate utf8_unicode_ci default NULL, 2.539 + `TokenSecret` varchar(64) collate utf8_unicode_ci NOT NULL, 2.540 + `TokenType` enum('request','access') collate utf8_unicode_ci NOT NULL, 2.541 + `Authorized` tinyint(4) NOT NULL, 2.542 + `Timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, 2.543 + `Lifetime` int(11) NOT NULL, 2.544 + PRIMARY KEY (`Token`,`ProviderKey`) 2.545 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.546 + 2.547 +-- 2.548 +-- Table structure for table `GDN_UserComment` 2.549 +-- 2.550 + 2.551 +DROP TABLE IF EXISTS `GDN_UserComment`; 2.552 +CREATE TABLE `GDN_UserComment` ( 2.553 + `UserID` int(11) NOT NULL, 2.554 + `CommentID` int(11) NOT NULL, 2.555 + `Score` float default NULL, 2.556 + `DateLastViewed` datetime default NULL, 2.557 + PRIMARY KEY (`UserID`,`CommentID`) 2.558 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.559 + 2.560 +-- 2.561 +-- Table structure for table `GDN_UserConversation` 2.562 +-- 2.563 + 2.564 +DROP TABLE IF EXISTS `GDN_UserConversation`; 2.565 +CREATE TABLE `GDN_UserConversation` ( 2.566 + `UserID` int(11) NOT NULL, 2.567 + `ConversationID` int(11) NOT NULL, 2.568 + `CountReadMessages` int(11) NOT NULL default '0', 2.569 + `CountNewMessages` int(11) NOT NULL default '0', 2.570 + `CountMessages` int(11) NOT NULL default '0', 2.571 + `LastMessageID` int(11) default NULL, 2.572 + `DateLastViewed` datetime default NULL, 2.573 + `DateCleared` datetime default NULL, 2.574 + `Bookmarked` tinyint(1) NOT NULL default '0', 2.575 + `Deleted` tinyint(4) NOT NULL default '0', 2.576 + PRIMARY KEY (`UserID`,`ConversationID`), 2.577 + KEY `FK_UserConversation_LastMessageID` (`LastMessageID`) 2.578 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.579 + 2.580 +-- 2.581 +-- Table structure for table `GDN_UserDiscussion` 2.582 +-- 2.583 + 2.584 +DROP TABLE IF EXISTS `GDN_UserDiscussion`; 2.585 +CREATE TABLE `GDN_UserDiscussion` ( 2.586 + `UserID` int(11) NOT NULL, 2.587 + `DiscussionID` int(11) NOT NULL, 2.588 + `Score` float default NULL, 2.589 + `CountComments` int(11) NOT NULL default '0', 2.590 + `DateLastViewed` datetime default NULL, 2.591 + `Dismissed` tinyint(1) NOT NULL default '0', 2.592 + `Bookmarked` tinyint(1) NOT NULL default '0', 2.593 + PRIMARY KEY (`UserID`,`DiscussionID`), 2.594 + KEY `FK_UserDiscussion_DiscussionID` (`DiscussionID`) 2.595 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.596 + 2.597 +-- 2.598 +-- Table structure for table `GDN_UserMeta` 2.599 +-- 2.600 + 2.601 +DROP TABLE IF EXISTS `GDN_UserMeta`; 2.602 +CREATE TABLE `GDN_UserMeta` ( 2.603 + `UserID` int(11) NOT NULL, 2.604 + `Name` varchar(255) collate utf8_unicode_ci NOT NULL, 2.605 + `Value` text collate utf8_unicode_ci, 2.606 + PRIMARY KEY (`UserID`,`Name`) 2.607 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.608 + 2.609 +-- 2.610 +-- Table structure for table `GDN_UserRole` 2.611 +-- 2.612 + 2.613 +DROP TABLE IF EXISTS `GDN_UserRole`; 2.614 +CREATE TABLE `GDN_UserRole` ( 2.615 + `UserID` int(11) NOT NULL, 2.616 + `RoleID` int(11) NOT NULL, 2.617 + PRIMARY KEY (`UserID`,`RoleID`) 2.618 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.619 + 2.620 +-- 2.621 +-- Table structure for table `GDN_Whosonline` 2.622 +-- 2.623 + 2.624 +DROP TABLE IF EXISTS `GDN_Whosonline`; 2.625 +CREATE TABLE `GDN_Whosonline` ( 2.626 + `UserID` int(11) NOT NULL default '11', 2.627 + `Timestamp` int(11) NOT NULL default '11' 2.628 +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 2.629 + 2.630 +-- 2.631 +-- Table structure for table `access` 2.632 +-- 2.633 + 2.634 +DROP TABLE IF EXISTS `access`; 2.635 +CREATE TABLE `access` ( 2.636 + `aid` int(11) NOT NULL auto_increment, 2.637 + `mask` varchar(255) NOT NULL default '', 2.638 + `type` varchar(255) NOT NULL default '', 2.639 + `status` tinyint(4) NOT NULL default '0', 2.640 + PRIMARY KEY (`aid`) 2.641 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.642 + 2.643 +-- 2.644 +-- Table structure for table `actions` 2.645 +-- 2.646 + 2.647 +DROP TABLE IF EXISTS `actions`; 2.648 +CREATE TABLE `actions` ( 2.649 + `aid` varchar(255) NOT NULL default '0', 2.650 + `type` varchar(32) NOT NULL default '', 2.651 + `callback` varchar(255) NOT NULL default '', 2.652 + `parameters` longtext NOT NULL, 2.653 + `description` varchar(255) NOT NULL default '0', 2.654 + PRIMARY KEY (`aid`) 2.655 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.656 + 2.657 +-- 2.658 +-- Table structure for table `actions_aid` 2.659 +-- 2.660 + 2.661 +DROP TABLE IF EXISTS `actions_aid`; 2.662 +CREATE TABLE `actions_aid` ( 2.663 + `aid` int(10) unsigned NOT NULL auto_increment, 2.664 + PRIMARY KEY (`aid`) 2.665 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.666 + 2.667 +-- 2.668 +-- Table structure for table `authmap` 2.669 +-- 2.670 + 2.671 +DROP TABLE IF EXISTS `authmap`; 2.672 +CREATE TABLE `authmap` ( 2.673 + `aid` int(10) unsigned NOT NULL auto_increment, 2.674 + `uid` int(11) NOT NULL default '0', 2.675 + `authname` varchar(128) NOT NULL default '', 2.676 + `module` varchar(128) NOT NULL default '', 2.677 + PRIMARY KEY (`aid`), 2.678 + UNIQUE KEY `authname` (`authname`) 2.679 +) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8; 2.680 + 2.681 +-- 2.682 +-- Table structure for table `batch` 2.683 +-- 2.684 + 2.685 +DROP TABLE IF EXISTS `batch`; 2.686 +CREATE TABLE `batch` ( 2.687 + `bid` int(10) unsigned NOT NULL auto_increment, 2.688 + `token` varchar(64) NOT NULL, 2.689 + `timestamp` int(11) NOT NULL, 2.690 + `batch` longtext, 2.691 + PRIMARY KEY (`bid`), 2.692 + KEY `token` (`token`) 2.693 +) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8; 2.694 + 2.695 +-- 2.696 +-- Table structure for table `blocks` 2.697 +-- 2.698 + 2.699 +DROP TABLE IF EXISTS `blocks`; 2.700 +CREATE TABLE `blocks` ( 2.701 + `bid` int(11) NOT NULL auto_increment, 2.702 + `module` varchar(64) NOT NULL default '', 2.703 + `delta` varchar(32) NOT NULL default '0', 2.704 + `theme` varchar(64) NOT NULL default '', 2.705 + `status` tinyint(4) NOT NULL default '0', 2.706 + `weight` tinyint(4) NOT NULL default '0', 2.707 + `region` varchar(64) NOT NULL default '', 2.708 + `custom` tinyint(4) NOT NULL default '0', 2.709 + `throttle` tinyint(4) NOT NULL default '0', 2.710 + `visibility` tinyint(4) NOT NULL default '0', 2.711 + `pages` text NOT NULL, 2.712 + `title` varchar(64) NOT NULL default '', 2.713 + `cache` tinyint(4) NOT NULL default '1', 2.714 + PRIMARY KEY (`bid`), 2.715 + UNIQUE KEY `tmd` (`theme`,`module`,`delta`), 2.716 + KEY `list` (`theme`,`status`,`region`,`weight`,`module`) 2.717 +) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8; 2.718 + 2.719 +-- 2.720 +-- Table structure for table `blocks_roles` 2.721 +-- 2.722 + 2.723 +DROP TABLE IF EXISTS `blocks_roles`; 2.724 +CREATE TABLE `blocks_roles` ( 2.725 + `module` varchar(64) NOT NULL, 2.726 + `delta` varchar(32) NOT NULL, 2.727 + `rid` int(10) unsigned NOT NULL, 2.728 + PRIMARY KEY (`module`,`delta`,`rid`), 2.729 + KEY `rid` (`rid`) 2.730 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.731 + 2.732 +-- 2.733 +-- Table structure for table `boxes` 2.734 +-- 2.735 + 2.736 +DROP TABLE IF EXISTS `boxes`; 2.737 +CREATE TABLE `boxes` ( 2.738 + `bid` int(10) unsigned NOT NULL auto_increment, 2.739 + `body` longtext, 2.740 + `info` varchar(128) NOT NULL default '', 2.741 + `format` smallint(6) NOT NULL default '0', 2.742 + PRIMARY KEY (`bid`), 2.743 + UNIQUE KEY `info` (`info`) 2.744 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.745 + 2.746 +-- 2.747 +-- Table structure for table `bueditor_buttons` 2.748 +-- 2.749 + 2.750 +DROP TABLE IF EXISTS `bueditor_buttons`; 2.751 +CREATE TABLE `bueditor_buttons` ( 2.752 + `bid` int(10) unsigned NOT NULL auto_increment, 2.753 + `eid` int(10) unsigned NOT NULL default '0', 2.754 + `title` varchar(255) NOT NULL default 'Notitle', 2.755 + `content` text NOT NULL, 2.756 + `icon` varchar(255) NOT NULL default '', 2.757 + `accesskey` varchar(1) NOT NULL default '', 2.758 + `weight` tinyint(4) NOT NULL default '0', 2.759 + PRIMARY KEY (`bid`), 2.760 + KEY `eid` (`eid`) 2.761 +) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; 2.762 + 2.763 +-- 2.764 +-- Table structure for table `bueditor_editors` 2.765 +-- 2.766 + 2.767 +DROP TABLE IF EXISTS `bueditor_editors`; 2.768 +CREATE TABLE `bueditor_editors` ( 2.769 + `eid` int(10) unsigned NOT NULL auto_increment, 2.770 + `name` varchar(255) NOT NULL default 'Noname', 2.771 + `pages` text NOT NULL, 2.772 + `excludes` text NOT NULL, 2.773 + `iconpath` varchar(255) NOT NULL default '%BUEDITOR/icons', 2.774 + `librarypath` varchar(255) NOT NULL default '%BUEDITOR/library', 2.775 + PRIMARY KEY (`eid`) 2.776 +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; 2.777 + 2.778 +-- 2.779 +-- Table structure for table `cache` 2.780 +-- 2.781 + 2.782 +DROP TABLE IF EXISTS `cache`; 2.783 +CREATE TABLE `cache` ( 2.784 + `cid` varchar(255) NOT NULL default '', 2.785 + `data` longblob, 2.786 + `expire` int(11) NOT NULL default '0', 2.787 + `created` int(11) NOT NULL default '0', 2.788 + `headers` text, 2.789 + `serialized` smallint(6) NOT NULL default '0', 2.790 + PRIMARY KEY (`cid`), 2.791 + KEY `expire` (`expire`) 2.792 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.793 + 2.794 +-- 2.795 +-- Table structure for table `cache_block` 2.796 +-- 2.797 + 2.798 +DROP TABLE IF EXISTS `cache_block`; 2.799 +CREATE TABLE `cache_block` ( 2.800 + `cid` varchar(255) NOT NULL default '', 2.801 + `data` longblob, 2.802 + `expire` int(11) NOT NULL default '0', 2.803 + `created` int(11) NOT NULL default '0', 2.804 + `headers` text, 2.805 + `serialized` smallint(6) NOT NULL default '0', 2.806 + PRIMARY KEY (`cid`), 2.807 + KEY `expire` (`expire`) 2.808 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.809 + 2.810 +-- 2.811 +-- Table structure for table `cache_filter` 2.812 +-- 2.813 + 2.814 +DROP TABLE IF EXISTS `cache_filter`; 2.815 +CREATE TABLE `cache_filter` ( 2.816 + `cid` varchar(255) NOT NULL default '', 2.817 + `data` longblob, 2.818 + `expire` int(11) NOT NULL default '0', 2.819 + `created` int(11) NOT NULL default '0', 2.820 + `headers` text, 2.821 + `serialized` smallint(6) NOT NULL default '0', 2.822 + PRIMARY KEY (`cid`), 2.823 + KEY `expire` (`expire`) 2.824 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.825 + 2.826 +-- 2.827 +-- Table structure for table `cache_form` 2.828 +-- 2.829 + 2.830 +DROP TABLE IF EXISTS `cache_form`; 2.831 +CREATE TABLE `cache_form` ( 2.832 + `cid` varchar(255) NOT NULL default '', 2.833 + `data` longblob, 2.834 + `expire` int(11) NOT NULL default '0', 2.835 + `created` int(11) NOT NULL default '0', 2.836 + `headers` text, 2.837 + `serialized` smallint(6) NOT NULL default '0', 2.838 + PRIMARY KEY (`cid`), 2.839 + KEY `expire` (`expire`) 2.840 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.841 + 2.842 +-- 2.843 +-- Table structure for table `cache_gravatar` 2.844 +-- 2.845 + 2.846 +DROP TABLE IF EXISTS `cache_gravatar`; 2.847 +CREATE TABLE `cache_gravatar` ( 2.848 + `cid` varchar(255) NOT NULL default '', 2.849 + `data` longblob, 2.850 + `expire` int(11) NOT NULL default '0', 2.851 + `created` int(11) NOT NULL default '0', 2.852 + `headers` text, 2.853 + `serialized` smallint(6) NOT NULL default '0', 2.854 + PRIMARY KEY (`cid`), 2.855 + KEY `expire` (`expire`) 2.856 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.857 + 2.858 +-- 2.859 +-- Table structure for table `cache_menu` 2.860 +-- 2.861 + 2.862 +DROP TABLE IF EXISTS `cache_menu`; 2.863 +CREATE TABLE `cache_menu` ( 2.864 + `cid` varchar(255) NOT NULL default '', 2.865 + `data` longblob, 2.866 + `expire` int(11) NOT NULL default '0', 2.867 + `created` int(11) NOT NULL default '0', 2.868 + `headers` text, 2.869 + `serialized` smallint(6) NOT NULL default '0', 2.870 + PRIMARY KEY (`cid`), 2.871 + KEY `expire` (`expire`) 2.872 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.873 + 2.874 +-- 2.875 +-- Table structure for table `cache_page` 2.876 +-- 2.877 + 2.878 +DROP TABLE IF EXISTS `cache_page`; 2.879 +CREATE TABLE `cache_page` ( 2.880 + `cid` varchar(255) NOT NULL default '', 2.881 + `data` longblob, 2.882 + `expire` int(11) NOT NULL default '0', 2.883 + `created` int(11) NOT NULL default '0', 2.884 + `headers` text, 2.885 + `serialized` smallint(6) NOT NULL default '0', 2.886 + PRIMARY KEY (`cid`), 2.887 + KEY `expire` (`expire`) 2.888 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.889 + 2.890 +-- 2.891 +-- Table structure for table `cache_update` 2.892 +-- 2.893 + 2.894 +DROP TABLE IF EXISTS `cache_update`; 2.895 +CREATE TABLE `cache_update` ( 2.896 + `cid` varchar(255) NOT NULL default '', 2.897 + `data` longblob, 2.898 + `expire` int(11) NOT NULL default '0', 2.899 + `created` int(11) NOT NULL default '0', 2.900 + `headers` text, 2.901 + `serialized` smallint(6) NOT NULL default '0', 2.902 + PRIMARY KEY (`cid`), 2.903 + KEY `expire` (`expire`) 2.904 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.905 + 2.906 +-- 2.907 +-- Table structure for table `captcha_points` 2.908 +-- 2.909 + 2.910 +DROP TABLE IF EXISTS `captcha_points`; 2.911 +CREATE TABLE `captcha_points` ( 2.912 + `form_id` varchar(128) NOT NULL, 2.913 + `module` varchar(64) default NULL, 2.914 + `type` varchar(64) default NULL, 2.915 + PRIMARY KEY (`form_id`) 2.916 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.917 + 2.918 +-- 2.919 +-- Table structure for table `captcha_sessions` 2.920 +-- 2.921 + 2.922 +DROP TABLE IF EXISTS `captcha_sessions`; 2.923 +CREATE TABLE `captcha_sessions` ( 2.924 + `csid` int(11) NOT NULL auto_increment, 2.925 + `uid` int(11) NOT NULL default '0', 2.926 + `sid` varchar(64) NOT NULL default '', 2.927 + `ip_address` varchar(128) default NULL, 2.928 + `timestamp` int(11) NOT NULL default '0', 2.929 + `form_id` varchar(128) NOT NULL, 2.930 + `solution` varchar(128) NOT NULL default '', 2.931 + `status` int(11) NOT NULL default '0', 2.932 + `attempts` int(11) NOT NULL default '0', 2.933 + PRIMARY KEY (`csid`), 2.934 + KEY `csid_ip` (`csid`,`ip_address`) 2.935 +) ENGINE=MyISAM AUTO_INCREMENT=9318 DEFAULT CHARSET=utf8; 2.936 + 2.937 +-- 2.938 +-- Table structure for table `comments` 2.939 +-- 2.940 + 2.941 +DROP TABLE IF EXISTS `comments`; 2.942 +CREATE TABLE `comments` ( 2.943 + `cid` int(11) NOT NULL auto_increment, 2.944 + `pid` int(11) NOT NULL default '0', 2.945 + `nid` int(11) NOT NULL default '0', 2.946 + `uid` int(11) NOT NULL default '0', 2.947 + `subject` varchar(64) NOT NULL default '', 2.948 + `comment` longtext NOT NULL, 2.949 + `hostname` varchar(128) NOT NULL default '', 2.950 + `timestamp` int(11) NOT NULL default '0', 2.951 + `status` tinyint(3) unsigned NOT NULL default '0', 2.952 + `format` smallint(6) NOT NULL default '0', 2.953 + `thread` varchar(255) NOT NULL, 2.954 + `name` varchar(60) default NULL, 2.955 + `mail` varchar(64) default NULL, 2.956 + `homepage` varchar(255) default NULL, 2.957 + PRIMARY KEY (`cid`), 2.958 + KEY `pid` (`pid`), 2.959 + KEY `nid` (`nid`), 2.960 + KEY `status` (`status`) 2.961 +) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8; 2.962 + 2.963 +-- 2.964 +-- Table structure for table `files` 2.965 +-- 2.966 + 2.967 +DROP TABLE IF EXISTS `files`; 2.968 +CREATE TABLE `files` ( 2.969 + `fid` int(10) unsigned NOT NULL auto_increment, 2.970 + `uid` int(10) unsigned NOT NULL default '0', 2.971 + `filename` varchar(255) NOT NULL default '', 2.972 + `filepath` varchar(255) NOT NULL default '', 2.973 + `filemime` varchar(255) NOT NULL default '', 2.974 + `filesize` int(10) unsigned NOT NULL default '0', 2.975 + `status` int(11) NOT NULL default '0', 2.976 + `timestamp` int(10) unsigned NOT NULL default '0', 2.977 + PRIMARY KEY (`fid`), 2.978 + KEY `uid` (`uid`), 2.979 + KEY `status` (`status`), 2.980 + KEY `timestamp` (`timestamp`) 2.981 +) ENGINE=MyISAM AUTO_INCREMENT=177 DEFAULT CHARSET=utf8; 2.982 + 2.983 +-- 2.984 +-- Table structure for table `filter_formats` 2.985 +-- 2.986 + 2.987 +DROP TABLE IF EXISTS `filter_formats`; 2.988 +CREATE TABLE `filter_formats` ( 2.989 + `format` int(11) NOT NULL auto_increment, 2.990 + `name` varchar(255) NOT NULL default '', 2.991 + `roles` varchar(255) NOT NULL default '', 2.992 + `cache` tinyint(4) NOT NULL default '0', 2.993 + PRIMARY KEY (`format`), 2.994 + UNIQUE KEY `name` (`name`) 2.995 +) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; 2.996 + 2.997 +-- 2.998 +-- Table structure for table `filters` 2.999 +-- 2.1000 + 2.1001 +DROP TABLE IF EXISTS `filters`; 2.1002 +CREATE TABLE `filters` ( 2.1003 + `fid` int(11) NOT NULL auto_increment, 2.1004 + `format` int(11) NOT NULL default '0', 2.1005 + `module` varchar(64) NOT NULL default '', 2.1006 + `delta` tinyint(4) NOT NULL default '0', 2.1007 + `weight` tinyint(4) NOT NULL default '0', 2.1008 + PRIMARY KEY (`fid`), 2.1009 + UNIQUE KEY `fmd` (`format`,`module`,`delta`), 2.1010 + KEY `list` (`format`,`weight`,`module`,`delta`) 2.1011 +) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; 2.1012 + 2.1013 +-- 2.1014 +-- Table structure for table `flood` 2.1015 +-- 2.1016 + 2.1017 +DROP TABLE IF EXISTS `flood`; 2.1018 +CREATE TABLE `flood` ( 2.1019 + `fid` int(11) NOT NULL auto_increment, 2.1020 + `event` varchar(64) NOT NULL default '', 2.1021 + `hostname` varchar(128) NOT NULL default '', 2.1022 + `timestamp` int(11) NOT NULL default '0', 2.1023 + PRIMARY KEY (`fid`), 2.1024 + KEY `allow` (`event`,`hostname`,`timestamp`) 2.1025 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1026 + 2.1027 +-- 2.1028 +-- Table structure for table `forum` 2.1029 +-- 2.1030 + 2.1031 +DROP TABLE IF EXISTS `forum`; 2.1032 +CREATE TABLE `forum` ( 2.1033 + `nid` int(10) unsigned NOT NULL default '0', 2.1034 + `vid` int(10) unsigned NOT NULL default '0', 2.1035 + `tid` int(10) unsigned NOT NULL default '0', 2.1036 + PRIMARY KEY (`vid`), 2.1037 + KEY `nid` (`nid`), 2.1038 + KEY `tid` (`tid`) 2.1039 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1040 + 2.1041 +-- 2.1042 +-- Table structure for table `history` 2.1043 +-- 2.1044 + 2.1045 +DROP TABLE IF EXISTS `history`; 2.1046 +CREATE TABLE `history` ( 2.1047 + `uid` int(11) NOT NULL default '0', 2.1048 + `nid` int(11) NOT NULL default '0', 2.1049 + `timestamp` int(11) NOT NULL default '0', 2.1050 + PRIMARY KEY (`uid`,`nid`), 2.1051 + KEY `nid` (`nid`) 2.1052 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1053 + 2.1054 +-- 2.1055 +-- Table structure for table `i18n_blocks` 2.1056 +-- 2.1057 + 2.1058 +DROP TABLE IF EXISTS `i18n_blocks`; 2.1059 +CREATE TABLE `i18n_blocks` ( 2.1060 + `ibid` int(10) unsigned NOT NULL auto_increment, 2.1061 + `module` varchar(64) NOT NULL, 2.1062 + `delta` varchar(32) NOT NULL default '0', 2.1063 + `type` int(11) NOT NULL default '0', 2.1064 + `language` varchar(12) NOT NULL default '', 2.1065 + PRIMARY KEY (`ibid`) 2.1066 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1067 + 2.1068 +-- 2.1069 +-- Table structure for table `i18n_strings` 2.1070 +-- 2.1071 + 2.1072 +DROP TABLE IF EXISTS `i18n_strings`; 2.1073 +CREATE TABLE `i18n_strings` ( 2.1074 + `lid` int(11) NOT NULL default '0', 2.1075 + `objectid` int(11) NOT NULL default '0', 2.1076 + `type` varchar(255) NOT NULL default '', 2.1077 + `property` varchar(255) NOT NULL default 'default', 2.1078 + PRIMARY KEY (`lid`) 2.1079 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1080 + 2.1081 +-- 2.1082 +-- Table structure for table `i18n_variable` 2.1083 +-- 2.1084 + 2.1085 +DROP TABLE IF EXISTS `i18n_variable`; 2.1086 +CREATE TABLE `i18n_variable` ( 2.1087 + `name` varchar(128) NOT NULL default '', 2.1088 + `language` varchar(12) NOT NULL default '', 2.1089 + `value` longtext NOT NULL, 2.1090 + PRIMARY KEY (`name`,`language`) 2.1091 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1092 + 2.1093 +-- 2.1094 +-- Table structure for table `image` 2.1095 +-- 2.1096 + 2.1097 +DROP TABLE IF EXISTS `image`; 2.1098 +CREATE TABLE `image` ( 2.1099 + `nid` int(10) unsigned NOT NULL default '0', 2.1100 + `fid` int(10) unsigned NOT NULL default '0', 2.1101 + `image_size` varchar(32) NOT NULL default '', 2.1102 + PRIMARY KEY (`nid`,`image_size`), 2.1103 + KEY `fid` (`fid`) 2.1104 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1105 + 2.1106 +-- 2.1107 +-- Table structure for table `image_attach` 2.1108 +-- 2.1109 + 2.1110 +DROP TABLE IF EXISTS `image_attach`; 2.1111 +CREATE TABLE `image_attach` ( 2.1112 + `nid` int(10) unsigned NOT NULL default '0', 2.1113 + `iid` int(10) unsigned NOT NULL default '0', 2.1114 + `weight` int(11) NOT NULL default '0', 2.1115 + PRIMARY KEY (`nid`,`iid`), 2.1116 + KEY `iid` (`iid`) 2.1117 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1118 + 2.1119 +-- 2.1120 +-- Table structure for table `languages` 2.1121 +-- 2.1122 + 2.1123 +DROP TABLE IF EXISTS `languages`; 2.1124 +CREATE TABLE `languages` ( 2.1125 + `language` varchar(12) NOT NULL default '', 2.1126 + `name` varchar(64) NOT NULL default '', 2.1127 + `native` varchar(64) NOT NULL default '', 2.1128 + `direction` int(11) NOT NULL default '0', 2.1129 + `enabled` int(11) NOT NULL default '0', 2.1130 + `plurals` int(11) NOT NULL default '0', 2.1131 + `formula` varchar(128) NOT NULL default '', 2.1132 + `domain` varchar(128) NOT NULL default '', 2.1133 + `prefix` varchar(128) NOT NULL default '', 2.1134 + `weight` int(11) NOT NULL default '0', 2.1135 + `javascript` varchar(32) NOT NULL default '', 2.1136 + PRIMARY KEY (`language`), 2.1137 + KEY `list` (`weight`,`name`) 2.1138 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1139 + 2.1140 +-- 2.1141 +-- Table structure for table `locales_source` 2.1142 +-- 2.1143 + 2.1144 +DROP TABLE IF EXISTS `locales_source`; 2.1145 +CREATE TABLE `locales_source` ( 2.1146 + `lid` int(11) NOT NULL auto_increment, 2.1147 + `location` varchar(255) NOT NULL default '', 2.1148 + `textgroup` varchar(255) NOT NULL default 'default', 2.1149 + `source` blob NOT NULL, 2.1150 + `version` varchar(20) NOT NULL default 'none', 2.1151 + PRIMARY KEY (`lid`), 2.1152 + KEY `source` (`source`(30)), 2.1153 + KEY `textgroup_location` (`textgroup`(30),`location`) 2.1154 +) ENGINE=MyISAM AUTO_INCREMENT=4355 DEFAULT CHARSET=utf8; 2.1155 + 2.1156 +-- 2.1157 +-- Table structure for table `locales_target` 2.1158 +-- 2.1159 + 2.1160 +DROP TABLE IF EXISTS `locales_target`; 2.1161 +CREATE TABLE `locales_target` ( 2.1162 + `lid` int(11) NOT NULL default '0', 2.1163 + `translation` blob NOT NULL, 2.1164 + `language` varchar(12) NOT NULL default '', 2.1165 + `plid` int(11) NOT NULL default '0', 2.1166 + `plural` int(11) NOT NULL default '0', 2.1167 + `status` int(11) NOT NULL default '0', 2.1168 + PRIMARY KEY (`language`,`lid`,`plural`), 2.1169 + KEY `lid` (`lid`), 2.1170 + KEY `plid` (`plid`), 2.1171 + KEY `plural` (`plural`) 2.1172 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1173 + 2.1174 +-- 2.1175 +-- Table structure for table `menu_custom` 2.1176 +-- 2.1177 + 2.1178 +DROP TABLE IF EXISTS `menu_custom`; 2.1179 +CREATE TABLE `menu_custom` ( 2.1180 + `menu_name` varchar(32) NOT NULL default '', 2.1181 + `title` varchar(255) NOT NULL default '', 2.1182 + `description` text, 2.1183 + PRIMARY KEY (`menu_name`) 2.1184 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1185 + 2.1186 +-- 2.1187 +-- Table structure for table `menu_links` 2.1188 +-- 2.1189 + 2.1190 +DROP TABLE IF EXISTS `menu_links`; 2.1191 +CREATE TABLE `menu_links` ( 2.1192 + `menu_name` varchar(32) NOT NULL default '', 2.1193 + `mlid` int(10) unsigned NOT NULL auto_increment, 2.1194 + `plid` int(10) unsigned NOT NULL default '0', 2.1195 + `link_path` varchar(255) NOT NULL default '', 2.1196 + `router_path` varchar(255) NOT NULL default '', 2.1197 + `link_title` varchar(255) NOT NULL default '', 2.1198 + `options` text, 2.1199 + `module` varchar(255) NOT NULL default 'system', 2.1200 + `hidden` smallint(6) NOT NULL default '0', 2.1201 + `external` smallint(6) NOT NULL default '0', 2.1202 + `has_children` smallint(6) NOT NULL default '0', 2.1203 + `expanded` smallint(6) NOT NULL default '0', 2.1204 + `weight` int(11) NOT NULL default '0', 2.1205 + `depth` smallint(6) NOT NULL default '0', 2.1206 + `customized` smallint(6) NOT NULL default '0', 2.1207 + `p1` int(10) unsigned NOT NULL default '0', 2.1208 + `p2` int(10) unsigned NOT NULL default '0', 2.1209 + `p3` int(10) unsigned NOT NULL default '0', 2.1210 + `p4` int(10) unsigned NOT NULL default '0', 2.1211 + `p5` int(10) unsigned NOT NULL default '0', 2.1212 + `p6` int(10) unsigned NOT NULL default '0', 2.1213 + `p7` int(10) unsigned NOT NULL default '0', 2.1214 + `p8` int(10) unsigned NOT NULL default '0', 2.1215 + `p9` int(10) unsigned NOT NULL default '0', 2.1216 + `updated` smallint(6) NOT NULL default '0', 2.1217 + PRIMARY KEY (`mlid`), 2.1218 + KEY `path_menu` (`link_path`(128),`menu_name`), 2.1219 + KEY `menu_plid_expand_child` (`menu_name`,`plid`,`expanded`,`has_children`), 2.1220 + KEY `menu_parents` (`menu_name`,`p1`,`p2`,`p3`,`p4`,`p5`,`p6`,`p7`,`p8`,`p9`), 2.1221 + KEY `router_path` (`router_path`(128)) 2.1222 +) ENGINE=MyISAM AUTO_INCREMENT=259 DEFAULT CHARSET=utf8; 2.1223 + 2.1224 +-- 2.1225 +-- Table structure for table `menu_router` 2.1226 +-- 2.1227 + 2.1228 +DROP TABLE IF EXISTS `menu_router`; 2.1229 +CREATE TABLE `menu_router` ( 2.1230 + `path` varchar(255) NOT NULL default '', 2.1231 + `load_functions` text NOT NULL, 2.1232 + `to_arg_functions` text NOT NULL, 2.1233 + `access_callback` varchar(255) NOT NULL default '', 2.1234 + `access_arguments` text, 2.1235 + `page_callback` varchar(255) NOT NULL default '', 2.1236 + `page_arguments` text, 2.1237 + `fit` int(11) NOT NULL default '0', 2.1238 + `number_parts` smallint(6) NOT NULL default '0', 2.1239 + `tab_parent` varchar(255) NOT NULL default '', 2.1240 + `tab_root` varchar(255) NOT NULL default '', 2.1241 + `title` varchar(255) NOT NULL default '', 2.1242 + `title_callback` varchar(255) NOT NULL default '', 2.1243 + `title_arguments` varchar(255) NOT NULL default '', 2.1244 + `type` int(11) NOT NULL default '0', 2.1245 + `block_callback` varchar(255) NOT NULL default '', 2.1246 + `description` text NOT NULL, 2.1247 + `position` varchar(255) NOT NULL default '', 2.1248 + `weight` int(11) NOT NULL default '0', 2.1249 + `file` mediumtext, 2.1250 + PRIMARY KEY (`path`), 2.1251 + KEY `fit` (`fit`), 2.1252 + KEY `tab_parent` (`tab_parent`), 2.1253 + KEY `tab_root_weight_title` (`tab_root`(64),`weight`,`title`) 2.1254 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1255 + 2.1256 +-- 2.1257 +-- Table structure for table `node` 2.1258 +-- 2.1259 + 2.1260 +DROP TABLE IF EXISTS `node`; 2.1261 +CREATE TABLE `node` ( 2.1262 + `nid` int(10) unsigned NOT NULL auto_increment, 2.1263 + `vid` int(10) unsigned NOT NULL default '0', 2.1264 + `type` varchar(32) NOT NULL default '', 2.1265 + `language` varchar(12) NOT NULL default '', 2.1266 + `title` varchar(255) NOT NULL default '', 2.1267 + `uid` int(11) NOT NULL default '0', 2.1268 + `status` int(11) NOT NULL default '1', 2.1269 + `created` int(11) NOT NULL default '0', 2.1270 + `changed` int(11) NOT NULL default '0', 2.1271 + `comment` int(11) NOT NULL default '0', 2.1272 + `promote` int(11) NOT NULL default '0', 2.1273 + `moderate` int(11) NOT NULL default '0', 2.1274 + `sticky` int(11) NOT NULL default '0', 2.1275 + `tnid` int(10) unsigned NOT NULL default '0', 2.1276 + `translate` int(11) NOT NULL default '0', 2.1277 + PRIMARY KEY (`nid`), 2.1278 + UNIQUE KEY `vid` (`vid`), 2.1279 + KEY `node_changed` (`changed`), 2.1280 + KEY `node_created` (`created`), 2.1281 + KEY `node_moderate` (`moderate`), 2.1282 + KEY `node_promote_status` (`promote`,`status`), 2.1283 + KEY `node_status_type` (`status`,`type`,`nid`), 2.1284 + KEY `node_title_type` (`title`,`type`(4)), 2.1285 + KEY `node_type` (`type`(4)), 2.1286 + KEY `uid` (`uid`), 2.1287 + KEY `tnid` (`tnid`), 2.1288 + KEY `translate` (`translate`) 2.1289 +) ENGINE=MyISAM AUTO_INCREMENT=142 DEFAULT CHARSET=utf8; 2.1290 + 2.1291 +-- 2.1292 +-- Table structure for table `node_access` 2.1293 +-- 2.1294 + 2.1295 +DROP TABLE IF EXISTS `node_access`; 2.1296 +CREATE TABLE `node_access` ( 2.1297 + `nid` int(10) unsigned NOT NULL default '0', 2.1298 + `gid` int(10) unsigned NOT NULL default '0', 2.1299 + `realm` varchar(255) NOT NULL default '', 2.1300 + `grant_view` tinyint(3) unsigned NOT NULL default '0', 2.1301 + `grant_update` tinyint(3) unsigned NOT NULL default '0', 2.1302 + `grant_delete` tinyint(3) unsigned NOT NULL default '0', 2.1303 + PRIMARY KEY (`nid`,`gid`,`realm`) 2.1304 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1305 + 2.1306 +-- 2.1307 +-- Table structure for table `node_comment_statistics` 2.1308 +-- 2.1309 + 2.1310 +DROP TABLE IF EXISTS `node_comment_statistics`; 2.1311 +CREATE TABLE `node_comment_statistics` ( 2.1312 + `nid` int(10) unsigned NOT NULL default '0', 2.1313 + `last_comment_timestamp` int(11) NOT NULL default '0', 2.1314 + `last_comment_name` varchar(60) default NULL, 2.1315 + `last_comment_uid` int(11) NOT NULL default '0', 2.1316 + `comment_count` int(10) unsigned NOT NULL default '0', 2.1317 + PRIMARY KEY (`nid`), 2.1318 + KEY `node_comment_timestamp` (`last_comment_timestamp`) 2.1319 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1320 + 2.1321 +-- 2.1322 +-- Table structure for table `node_counter` 2.1323 +-- 2.1324 + 2.1325 +DROP TABLE IF EXISTS `node_counter`; 2.1326 +CREATE TABLE `node_counter` ( 2.1327 + `nid` int(11) NOT NULL default '0', 2.1328 + `totalcount` bigint(20) unsigned NOT NULL default '0', 2.1329 + `daycount` mediumint(8) unsigned NOT NULL default '0', 2.1330 + `timestamp` int(10) unsigned NOT NULL default '0', 2.1331 + PRIMARY KEY (`nid`) 2.1332 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1333 + 2.1334 +-- 2.1335 +-- Table structure for table `node_revisions` 2.1336 +-- 2.1337 + 2.1338 +DROP TABLE IF EXISTS `node_revisions`; 2.1339 +CREATE TABLE `node_revisions` ( 2.1340 + `nid` int(10) unsigned NOT NULL default '0', 2.1341 + `vid` int(10) unsigned NOT NULL auto_increment, 2.1342 + `uid` int(11) NOT NULL default '0', 2.1343 + `title` varchar(255) NOT NULL default '', 2.1344 + `body` longtext NOT NULL, 2.1345 + `teaser` longtext NOT NULL, 2.1346 + `log` longtext NOT NULL, 2.1347 + `timestamp` int(11) NOT NULL default '0', 2.1348 + `format` int(11) NOT NULL default '0', 2.1349 + PRIMARY KEY (`vid`), 2.1350 + KEY `nid` (`nid`), 2.1351 + KEY `uid` (`uid`) 2.1352 +) ENGINE=MyISAM AUTO_INCREMENT=485 DEFAULT CHARSET=utf8; 2.1353 + 2.1354 +-- 2.1355 +-- Table structure for table `node_type` 2.1356 +-- 2.1357 + 2.1358 +DROP TABLE IF EXISTS `node_type`; 2.1359 +CREATE TABLE `node_type` ( 2.1360 + `type` varchar(32) NOT NULL, 2.1361 + `name` varchar(255) NOT NULL default '', 2.1362 + `module` varchar(255) NOT NULL, 2.1363 + `description` mediumtext NOT NULL, 2.1364 + `help` mediumtext NOT NULL, 2.1365 + `has_title` tinyint(3) unsigned NOT NULL, 2.1366 + `title_label` varchar(255) NOT NULL default '', 2.1367 + `has_body` tinyint(3) unsigned NOT NULL, 2.1368 + `body_label` varchar(255) NOT NULL default '', 2.1369 + `min_word_count` smallint(5) unsigned NOT NULL, 2.1370 + `custom` tinyint(4) NOT NULL default '0', 2.1371 + `modified` tinyint(4) NOT NULL default '0', 2.1372 + `locked` tinyint(4) NOT NULL default '0', 2.1373 + `orig_type` varchar(255) NOT NULL default '', 2.1374 + PRIMARY KEY (`type`) 2.1375 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1376 + 2.1377 +-- 2.1378 +-- Table structure for table `openid_association` 2.1379 +-- 2.1380 + 2.1381 +DROP TABLE IF EXISTS `openid_association`; 2.1382 +CREATE TABLE `openid_association` ( 2.1383 + `idp_endpoint_uri` varchar(255) default NULL, 2.1384 + `assoc_handle` varchar(255) NOT NULL, 2.1385 + `assoc_type` varchar(32) default NULL, 2.1386 + `session_type` varchar(32) default NULL, 2.1387 + `mac_key` varchar(255) default NULL, 2.1388 + `created` int(11) NOT NULL default '0', 2.1389 + `expires_in` int(11) NOT NULL default '0', 2.1390 + PRIMARY KEY (`assoc_handle`) 2.1391 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1392 + 2.1393 +-- 2.1394 +-- Table structure for table `permission` 2.1395 +-- 2.1396 + 2.1397 +DROP TABLE IF EXISTS `permission`; 2.1398 +CREATE TABLE `permission` ( 2.1399 + `pid` int(11) NOT NULL auto_increment, 2.1400 + `rid` int(10) unsigned NOT NULL default '0', 2.1401 + `perm` longtext, 2.1402 + `tid` int(10) unsigned NOT NULL default '0', 2.1403 + PRIMARY KEY (`pid`), 2.1404 + KEY `rid` (`rid`) 2.1405 +) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8; 2.1406 + 2.1407 +-- 2.1408 +-- Table structure for table `poll` 2.1409 +-- 2.1410 + 2.1411 +DROP TABLE IF EXISTS `poll`; 2.1412 +CREATE TABLE `poll` ( 2.1413 + `nid` int(10) unsigned NOT NULL default '0', 2.1414 + `runtime` int(11) NOT NULL default '0', 2.1415 + `active` int(10) unsigned NOT NULL default '0', 2.1416 + PRIMARY KEY (`nid`) 2.1417 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1418 + 2.1419 +-- 2.1420 +-- Table structure for table `poll_choices` 2.1421 +-- 2.1422 + 2.1423 +DROP TABLE IF EXISTS `poll_choices`; 2.1424 +CREATE TABLE `poll_choices` ( 2.1425 + `chid` int(10) unsigned NOT NULL auto_increment, 2.1426 + `nid` int(10) unsigned NOT NULL default '0', 2.1427 + `chtext` varchar(128) NOT NULL default '', 2.1428 + `chvotes` int(11) NOT NULL default '0', 2.1429 + `chorder` int(11) NOT NULL default '0', 2.1430 + PRIMARY KEY (`chid`), 2.1431 + KEY `nid` (`nid`) 2.1432 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1433 + 2.1434 +-- 2.1435 +-- Table structure for table `poll_votes` 2.1436 +-- 2.1437 + 2.1438 +DROP TABLE IF EXISTS `poll_votes`; 2.1439 +CREATE TABLE `poll_votes` ( 2.1440 + `nid` int(10) unsigned NOT NULL, 2.1441 + `uid` int(10) unsigned NOT NULL default '0', 2.1442 + `chorder` int(11) NOT NULL default '-1', 2.1443 + `hostname` varchar(128) NOT NULL default '', 2.1444 + PRIMARY KEY (`nid`,`uid`,`hostname`), 2.1445 + KEY `hostname` (`hostname`), 2.1446 + KEY `uid` (`uid`) 2.1447 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1448 + 2.1449 +-- 2.1450 +-- Table structure for table `profile_fields` 2.1451 +-- 2.1452 + 2.1453 +DROP TABLE IF EXISTS `profile_fields`; 2.1454 +CREATE TABLE `profile_fields` ( 2.1455 + `fid` int(11) NOT NULL auto_increment, 2.1456 + `title` varchar(255) default NULL, 2.1457 + `name` varchar(128) NOT NULL default '', 2.1458 + `explanation` text, 2.1459 + `category` varchar(255) default NULL, 2.1460 + `page` varchar(255) default NULL, 2.1461 + `type` varchar(128) default NULL, 2.1462 + `weight` tinyint(4) NOT NULL default '0', 2.1463 + `required` tinyint(4) NOT NULL default '0', 2.1464 + `register` tinyint(4) NOT NULL default '0', 2.1465 + `visibility` tinyint(4) NOT NULL default '0', 2.1466 + `autocomplete` tinyint(4) NOT NULL default '0', 2.1467 + `options` text, 2.1468 + PRIMARY KEY (`fid`), 2.1469 + UNIQUE KEY `name` (`name`), 2.1470 + KEY `category` (`category`) 2.1471 +) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; 2.1472 + 2.1473 +-- 2.1474 +-- Table structure for table `profile_values` 2.1475 +-- 2.1476 + 2.1477 +DROP TABLE IF EXISTS `profile_values`; 2.1478 +CREATE TABLE `profile_values` ( 2.1479 + `fid` int(10) unsigned NOT NULL default '0', 2.1480 + `uid` int(10) unsigned NOT NULL default '0', 2.1481 + `value` text, 2.1482 + PRIMARY KEY (`uid`,`fid`), 2.1483 + KEY `fid` (`fid`) 2.1484 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1485 + 2.1486 +-- 2.1487 +-- Table structure for table `role` 2.1488 +-- 2.1489 + 2.1490 +DROP TABLE IF EXISTS `role`; 2.1491 +CREATE TABLE `role` ( 2.1492 + `rid` int(10) unsigned NOT NULL auto_increment, 2.1493 + `name` varchar(64) NOT NULL default '', 2.1494 + PRIMARY KEY (`rid`), 2.1495 + UNIQUE KEY `name` (`name`) 2.1496 +) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; 2.1497 + 2.1498 +-- 2.1499 +-- Table structure for table `sessions` 2.1500 +-- 2.1501 + 2.1502 +DROP TABLE IF EXISTS `sessions`; 2.1503 +CREATE TABLE `sessions` ( 2.1504 + `uid` int(10) unsigned NOT NULL, 2.1505 + `sid` varchar(64) NOT NULL default '', 2.1506 + `hostname` varchar(128) NOT NULL default '', 2.1507 + `timestamp` int(11) NOT NULL default '0', 2.1508 + `cache` int(11) NOT NULL default '0', 2.1509 + `session` longtext, 2.1510 + PRIMARY KEY (`sid`), 2.1511 + KEY `timestamp` (`timestamp`), 2.1512 + KEY `uid` (`uid`) 2.1513 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1514 + 2.1515 +-- 2.1516 +-- Table structure for table `system` 2.1517 +-- 2.1518 + 2.1519 +DROP TABLE IF EXISTS `system`; 2.1520 +CREATE TABLE `system` ( 2.1521 + `filename` varchar(255) NOT NULL default '', 2.1522 + `name` varchar(255) NOT NULL default '', 2.1523 + `type` varchar(255) NOT NULL default '', 2.1524 + `owner` varchar(255) NOT NULL default '', 2.1525 + `status` int(11) NOT NULL default '0', 2.1526 + `throttle` tinyint(4) NOT NULL default '0', 2.1527 + `bootstrap` int(11) NOT NULL default '0', 2.1528 + `schema_version` smallint(6) NOT NULL default '-1', 2.1529 + `weight` int(11) NOT NULL default '0', 2.1530 + `info` text, 2.1531 + PRIMARY KEY (`filename`), 2.1532 + KEY `modules` (`type`(12),`status`,`weight`,`filename`), 2.1533 + KEY `bootstrap` (`type`(12),`status`,`bootstrap`,`weight`,`filename`), 2.1534 + KEY `type_name` (`type`(12),`name`) 2.1535 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1536 + 2.1537 +-- 2.1538 +-- Table structure for table `term_data` 2.1539 +-- 2.1540 + 2.1541 +DROP TABLE IF EXISTS `term_data`; 2.1542 +CREATE TABLE `term_data` ( 2.1543 + `tid` int(10) unsigned NOT NULL auto_increment, 2.1544 + `vid` int(10) unsigned NOT NULL default '0', 2.1545 + `name` varchar(255) NOT NULL default '', 2.1546 + `description` longtext, 2.1547 + `weight` tinyint(4) NOT NULL default '0', 2.1548 + PRIMARY KEY (`tid`), 2.1549 + KEY `taxonomy_tree` (`vid`,`weight`,`name`), 2.1550 + KEY `vid_name` (`vid`,`name`) 2.1551 +) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; 2.1552 + 2.1553 +-- 2.1554 +-- Table structure for table `term_hierarchy` 2.1555 +-- 2.1556 + 2.1557 +DROP TABLE IF EXISTS `term_hierarchy`; 2.1558 +CREATE TABLE `term_hierarchy` ( 2.1559 + `tid` int(10) unsigned NOT NULL default '0', 2.1560 + `parent` int(10) unsigned NOT NULL default '0', 2.1561 + PRIMARY KEY (`tid`,`parent`), 2.1562 + KEY `parent` (`parent`) 2.1563 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1564 + 2.1565 +-- 2.1566 +-- Table structure for table `term_node` 2.1567 +-- 2.1568 + 2.1569 +DROP TABLE IF EXISTS `term_node`; 2.1570 +CREATE TABLE `term_node` ( 2.1571 + `nid` int(10) unsigned NOT NULL default '0', 2.1572 + `vid` int(10) unsigned NOT NULL default '0', 2.1573 + `tid` int(10) unsigned NOT NULL default '0', 2.1574 + PRIMARY KEY (`tid`,`vid`), 2.1575 + KEY `vid` (`vid`), 2.1576 + KEY `nid` (`nid`) 2.1577 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1578 + 2.1579 +-- 2.1580 +-- Table structure for table `term_relation` 2.1581 +-- 2.1582 + 2.1583 +DROP TABLE IF EXISTS `term_relation`; 2.1584 +CREATE TABLE `term_relation` ( 2.1585 + `trid` int(11) NOT NULL auto_increment, 2.1586 + `tid1` int(10) unsigned NOT NULL default '0', 2.1587 + `tid2` int(10) unsigned NOT NULL default '0', 2.1588 + PRIMARY KEY (`trid`), 2.1589 + UNIQUE KEY `tid1_tid2` (`tid1`,`tid2`), 2.1590 + KEY `tid2` (`tid2`) 2.1591 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1592 + 2.1593 +-- 2.1594 +-- Table structure for table `term_synonym` 2.1595 +-- 2.1596 + 2.1597 +DROP TABLE IF EXISTS `term_synonym`; 2.1598 +CREATE TABLE `term_synonym` ( 2.1599 + `tsid` int(11) NOT NULL auto_increment, 2.1600 + `tid` int(10) unsigned NOT NULL default '0', 2.1601 + `name` varchar(255) NOT NULL default '', 2.1602 + PRIMARY KEY (`tsid`), 2.1603 + KEY `tid` (`tid`), 2.1604 + KEY `name_tid` (`name`,`tid`) 2.1605 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1606 + 2.1607 +-- 2.1608 +-- Table structure for table `translation_overview_priority` 2.1609 +-- 2.1610 + 2.1611 +DROP TABLE IF EXISTS `translation_overview_priority`; 2.1612 +CREATE TABLE `translation_overview_priority` ( 2.1613 + `tnid` int(10) unsigned NOT NULL, 2.1614 + `lang_en` tinyint(3) unsigned NOT NULL default '1', 2.1615 + `lang_fr` tinyint(3) unsigned NOT NULL default '1', 2.1616 + `lang_de` tinyint(3) unsigned NOT NULL default '1', 2.1617 + `lang_ptbr` tinyint(3) unsigned NOT NULL default '1', 2.1618 + `lang_zhhant` tinyint(3) unsigned NOT NULL default '1', 2.1619 + PRIMARY KEY (`tnid`), 2.1620 + KEY `lang_en` (`lang_en`), 2.1621 + KEY `lang_fr` (`lang_fr`), 2.1622 + KEY `lang_de` (`lang_de`), 2.1623 + KEY `lang_ptbr` (`lang_ptbr`), 2.1624 + KEY `lang_zhhant` (`lang_zhhant`) 2.1625 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1626 + 2.1627 +-- 2.1628 +-- Table structure for table `twitter` 2.1629 +-- 2.1630 + 2.1631 +DROP TABLE IF EXISTS `twitter`; 2.1632 +CREATE TABLE `twitter` ( 2.1633 + `twitter_id` decimal(20,0) unsigned NOT NULL default '0', 2.1634 + `screen_name` varchar(255) NOT NULL default '', 2.1635 + `created_at` varchar(64) NOT NULL default '', 2.1636 + `created_time` int(11) NOT NULL, 2.1637 + `text` varchar(255) default NULL, 2.1638 + `source` varchar(255) default NULL, 2.1639 + `in_reply_to_status_id` decimal(20,0) unsigned default NULL, 2.1640 + `in_reply_to_user_id` decimal(20,0) unsigned default NULL, 2.1641 + `in_reply_to_screen_name` varchar(255) default NULL, 2.1642 + `truncated` int(10) unsigned NOT NULL default '0', 2.1643 + PRIMARY KEY (`twitter_id`), 2.1644 + KEY `screen_name` (`screen_name`) 2.1645 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1646 + 2.1647 +-- 2.1648 +-- Table structure for table `twitter_account` 2.1649 +-- 2.1650 + 2.1651 +DROP TABLE IF EXISTS `twitter_account`; 2.1652 +CREATE TABLE `twitter_account` ( 2.1653 + `twitter_uid` decimal(20,0) unsigned NOT NULL default '0', 2.1654 + `screen_name` varchar(255) default NULL, 2.1655 + `name` varchar(64) NOT NULL default '', 2.1656 + `description` varchar(255) default NULL, 2.1657 + `location` varchar(255) default NULL, 2.1658 + `followers_count` int(11) NOT NULL default '0', 2.1659 + `profile_image_url` varchar(255) default NULL, 2.1660 + `url` varchar(255) default NULL, 2.1661 + `protected` int(10) unsigned NOT NULL default '0', 2.1662 + `last_refresh` int(11) NOT NULL default '0', 2.1663 + PRIMARY KEY (`twitter_uid`), 2.1664 + KEY `screen_name` (`screen_name`) 2.1665 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1666 + 2.1667 +-- 2.1668 +-- Table structure for table `twitter_user` 2.1669 +-- 2.1670 + 2.1671 +DROP TABLE IF EXISTS `twitter_user`; 2.1672 +CREATE TABLE `twitter_user` ( 2.1673 + `uid` int(11) NOT NULL, 2.1674 + `screen_name` varchar(255) NOT NULL default '', 2.1675 + `password` varchar(64) default NULL, 2.1676 + `import` int(10) unsigned NOT NULL default '1', 2.1677 + PRIMARY KEY (`uid`,`screen_name`), 2.1678 + KEY `screen_name` (`screen_name`), 2.1679 + KEY `uid` (`uid`), 2.1680 + KEY `import` (`import`) 2.1681 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1682 + 2.1683 +-- 2.1684 +-- Table structure for table `upload` 2.1685 +-- 2.1686 + 2.1687 +DROP TABLE IF EXISTS `upload`; 2.1688 +CREATE TABLE `upload` ( 2.1689 + `fid` int(10) unsigned NOT NULL default '0', 2.1690 + `nid` int(10) unsigned NOT NULL default '0', 2.1691 + `vid` int(10) unsigned NOT NULL default '0', 2.1692 + `description` varchar(255) NOT NULL default '', 2.1693 + `list` tinyint(3) unsigned NOT NULL default '0', 2.1694 + `weight` tinyint(4) NOT NULL default '0', 2.1695 + PRIMARY KEY (`vid`,`fid`), 2.1696 + KEY `fid` (`fid`), 2.1697 + KEY `nid` (`nid`) 2.1698 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1699 + 2.1700 +-- 2.1701 +-- Table structure for table `url_alias` 2.1702 +-- 2.1703 + 2.1704 +DROP TABLE IF EXISTS `url_alias`; 2.1705 +CREATE TABLE `url_alias` ( 2.1706 + `pid` int(10) unsigned NOT NULL auto_increment, 2.1707 + `src` varchar(128) NOT NULL default '', 2.1708 + `dst` varchar(128) NOT NULL default '', 2.1709 + `language` varchar(12) NOT NULL default '', 2.1710 + PRIMARY KEY (`pid`), 2.1711 + UNIQUE KEY `dst_language` (`dst`,`language`), 2.1712 + KEY `src_language` (`src`,`language`) 2.1713 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1714 + 2.1715 +-- 2.1716 +-- Table structure for table `users` 2.1717 +-- 2.1718 + 2.1719 +DROP TABLE IF EXISTS `users`; 2.1720 +CREATE TABLE `users` ( 2.1721 + `uid` int(10) unsigned NOT NULL auto_increment, 2.1722 + `name` varchar(60) NOT NULL default '', 2.1723 + `pass` varchar(32) NOT NULL default '', 2.1724 + `mail` varchar(64) default '', 2.1725 + `mode` tinyint(4) NOT NULL default '0', 2.1726 + `sort` tinyint(4) default '0', 2.1727 + `threshold` tinyint(4) default '0', 2.1728 + `theme` varchar(255) NOT NULL default '', 2.1729 + `signature` varchar(255) NOT NULL default '', 2.1730 + `signature_format` smallint(6) NOT NULL default '0', 2.1731 + `created` int(11) NOT NULL default '0', 2.1732 + `access` int(11) NOT NULL default '0', 2.1733 + `login` int(11) NOT NULL default '0', 2.1734 + `status` tinyint(4) NOT NULL default '0', 2.1735 + `timezone` varchar(8) default NULL, 2.1736 + `language` varchar(12) NOT NULL default '', 2.1737 + `picture` varchar(255) NOT NULL default '', 2.1738 + `init` varchar(64) default '', 2.1739 + `data` longtext, 2.1740 + PRIMARY KEY (`uid`), 2.1741 + UNIQUE KEY `name` (`name`), 2.1742 + KEY `access` (`access`), 2.1743 + KEY `created` (`created`), 2.1744 + KEY `mail` (`mail`) 2.1745 +) ENGINE=MyISAM AUTO_INCREMENT=611 DEFAULT CHARSET=utf8; 2.1746 + 2.1747 +-- 2.1748 +-- Table structure for table `users_roles` 2.1749 +-- 2.1750 + 2.1751 +DROP TABLE IF EXISTS `users_roles`; 2.1752 +CREATE TABLE `users_roles` ( 2.1753 + `uid` int(10) unsigned NOT NULL default '0', 2.1754 + `rid` int(10) unsigned NOT NULL default '0', 2.1755 + PRIMARY KEY (`uid`,`rid`), 2.1756 + KEY `rid` (`rid`) 2.1757 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1758 + 2.1759 +-- 2.1760 +-- Table structure for table `variable` 2.1761 +-- 2.1762 + 2.1763 +DROP TABLE IF EXISTS `variable`; 2.1764 +CREATE TABLE `variable` ( 2.1765 + `name` varchar(128) NOT NULL default '', 2.1766 + `value` longtext NOT NULL, 2.1767 + PRIMARY KEY (`name`) 2.1768 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1769 + 2.1770 +-- 2.1771 +-- Table structure for table `vocabulary` 2.1772 +-- 2.1773 + 2.1774 +DROP TABLE IF EXISTS `vocabulary`; 2.1775 +CREATE TABLE `vocabulary` ( 2.1776 + `vid` int(10) unsigned NOT NULL auto_increment, 2.1777 + `name` varchar(255) NOT NULL default '', 2.1778 + `description` longtext, 2.1779 + `help` varchar(255) NOT NULL default '', 2.1780 + `relations` tinyint(3) unsigned NOT NULL default '0', 2.1781 + `hierarchy` tinyint(3) unsigned NOT NULL default '0', 2.1782 + `multiple` tinyint(3) unsigned NOT NULL default '0', 2.1783 + `required` tinyint(3) unsigned NOT NULL default '0', 2.1784 + `tags` tinyint(3) unsigned NOT NULL default '0', 2.1785 + `module` varchar(255) NOT NULL default '', 2.1786 + `weight` tinyint(4) NOT NULL default '0', 2.1787 + PRIMARY KEY (`vid`), 2.1788 + KEY `list` (`weight`,`name`) 2.1789 +) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; 2.1790 + 2.1791 +-- 2.1792 +-- Table structure for table `vocabulary_node_types` 2.1793 +-- 2.1794 + 2.1795 +DROP TABLE IF EXISTS `vocabulary_node_types`; 2.1796 +CREATE TABLE `vocabulary_node_types` ( 2.1797 + `vid` int(10) unsigned NOT NULL default '0', 2.1798 + `type` varchar(32) NOT NULL default '', 2.1799 + PRIMARY KEY (`type`,`vid`), 2.1800 + KEY `vid` (`vid`) 2.1801 +) ENGINE=MyISAM DEFAULT CHARSET=utf8; 2.1802 + 2.1803 +-- 2.1804 +-- Table structure for table `watchdog` 2.1805 +-- 2.1806 + 2.1807 +DROP TABLE IF EXISTS `watchdog`; 2.1808 +CREATE TABLE `watchdog` ( 2.1809 + `wid` int(11) NOT NULL auto_increment, 2.1810 + `uid` int(11) NOT NULL default '0', 2.1811 + `type` varchar(16) NOT NULL default '', 2.1812 + `message` longtext NOT NULL, 2.1813 + `variables` longtext NOT NULL, 2.1814 + `severity` tinyint(3) unsigned NOT NULL default '0', 2.1815 + `link` varchar(255) NOT NULL default '', 2.1816 + `location` text NOT NULL, 2.1817 + `referer` text, 2.1818 + `hostname` varchar(128) NOT NULL default '', 2.1819 + `timestamp` int(11) NOT NULL default '0', 2.1820 + PRIMARY KEY (`wid`), 2.1821 + KEY `type` (`type`) 2.1822 +) ENGINE=MyISAM AUTO_INCREMENT=10149 DEFAULT CHARSET=utf8; 2.1823 +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; 2.1824 + 2.1825 +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 2.1826 +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; 2.1827 +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; 2.1828 +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; 2.1829 +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; 2.1830 +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 2.1831 +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; 2.1832 + 2.1833 +-- Dump completed on 2010-12-22 8:55:59
3.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 3.2 +++ b/forum/system-config/apache/forum.slitaz.org.conf Wed Dec 22 10:25:56 2010 +0100 3.3 @@ -0,0 +1,36 @@ 3.4 +<VirtualHost *> 3.5 + ServerAdmin webmaster@forum.slitaz.org 3.6 + DocumentRoot /home/slitaz/www/forum 3.7 + ServerName forum.slitaz.org 3.8 + ErrorLog /home/slitaz/logs/error_log 3.9 + CustomLog /home/slitaz/logs/access_log combined 3.10 + 3.11 + RewriteEngine On 3.12 + 3.13 + ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/ 3.14 + <Directory "/usr/lib/cgi-bin"> 3.15 + AllowOverride None 3.16 + Options ExecCGI -MultiViews +SymLinksIfOwnerMatch 3.17 + Order allow,deny 3.18 + Allow from all 3.19 + </Directory> 3.20 + 3.21 + 3.22 + <Directory /home/slitaz/www/forum> 3.23 + AllowOverride all 3.24 + Options FollowSymLinks SymLinksIfOwnerMatch IncludesNoExec 3.25 + DirectoryIndex index.php index.htm index.html 3.26 + AddDefaultCharset iso8859-1 3.27 + 3.28 + 3.29 + <Limit GET POST OPTIONS> 3.30 + Order allow,deny 3.31 + Allow from all 3.32 + </Limit> 3.33 + <LimitExcept GET POST OPTIONS> 3.34 + Order deny,allow 3.35 + Deny from all 3.36 + </LimitExcept> 3.37 + </Directory> 3.38 +</VirtualHost> 3.39 +
4.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 4.2 +++ b/forum/system-config/awstats/awstats.forum.slitaz.org.conf Wed Dec 22 10:25:56 2010 +0100 4.3 @@ -0,0 +1,240 @@ 4.4 +# AWSTATS CONFIGURE FILE 6.0 4.5 +#----------------------------------------------------------------------------- 4.6 +# Copy this file into awstats.www.mydomain.conf and edit this new config file 4.7 +# to setup AWStats (See documentation in docs/ directory). 4.8 +# The config file must be in /etc/awstats, /usr/local/etc/awstats or /etc (for 4.9 +# Unix/Linux) or same directory than awstats.pl (Windows, Mac, Unix/Linux...) 4.10 +# To include an environment variable in any parameter (AWStats will replace 4.11 +# it with its value when reading it), follow the example: 4.12 +# Parameter="__ENVNAME__" 4.13 +# Note that environment variable AWSTATS_CURRENT_CONFIG is always defined with 4.14 +# the config value in an AWStats running session and can be used like others. 4.15 +#----------------------------------------------------------------------------- 4.16 +# $Revision: 1.271 $ - $Author: eldy $ - $Date: 2004/01/25 15:35:11 $ 4.17 + 4.18 + 4.19 + 4.20 +#----------------------------------------------------------------------------- 4.21 +# MAIN SETUP SECTION (Required to make AWStats work) 4.22 +#----------------------------------------------------------------------------- 4.23 +LogFile="/home/slitaz/logs/access_log" 4.24 +LogType=W 4.25 +LogFormat=1 4.26 +LogSeparator=" " 4.27 +SiteDomain="forum.slitaz.org" 4.28 +HostAliases="localhost 127.0.0.1 REGEX[forum\.slitaz\.org$]" 4.29 +DNSLookup=0 4.30 +DirData="/var/db/awstats/forum.slitaz.org" 4.31 +DirCgi="/cgi-bin" 4.32 +DirIcons="/icon" 4.33 +AllowToUpdateStatsFromBrowser=0 4.34 +AllowFullYearView=1 4.35 + 4.36 + 4.37 +#----------------------------------------------------------------------------- 4.38 +# OPTIONAL SETUP SECTION (Not required but increase AWStats features) 4.39 +#----------------------------------------------------------------------------- 4.40 +EnableLockForUpdate=0 4.41 +DNSStaticCacheFile="dnscache.txt" 4.42 +DNSLastUpdateCacheFile="dnscachelastupdate.txt" 4.43 +SkipDNSLookupFor="" 4.44 +AllowAccessFromWebToAuthenticatedUsersOnly=0 4.45 +AllowAccessFromWebToFollowingAuthenticatedUsers="" 4.46 +AllowAccessFromWebToFollowingIPAddresses="" 4.47 +CreateDirDataIfNotExists=0 4.48 +BuildHistoryFormat=text 4.49 +BuildReportFormat=html 4.50 +SaveDatabaseFilesWithPermissionsForEveryone=0 4.51 +PurgeLogFile=0 4.52 +ArchiveLogRecords=0 4.53 +KeepBackupOfHistoricFiles=0 4.54 +DefaultFile="index.htm" 4.55 +SkipHosts="81.80.143.121" 4.56 +SkipUserAgents="" 4.57 +SkipFiles="" 4.58 +OnlyHosts="" 4.59 +OnlyUserAgents="" 4.60 +OnlyFiles="" 4.61 +NotPageList="css js class gif jpg jpeg png bmp ico" 4.62 +ValidHTTPCodes="200 304" 4.63 +ValidSMTPCodes="1 250" 4.64 +AuthenticatedUsersNotCaseSensitive=0 4.65 +URLNotCaseSensitive=0 4.66 +URLWithAnchor=0 4.67 +URLQuerySeparators="?;" 4.68 +URLWithQuery=0 4.69 +URLWithQueryWithOnlyFollowingParameters="" 4.70 +URLWithQueryWithoutFollowingParameters="" 4.71 +URLReferrerWithQuery=0 4.72 +WarningMessages=1 4.73 +ErrorMessages="" 4.74 +DebugMessages=1 4.75 +NbOfLinesForCorruptedLog=50 4.76 +WrapperScript="" 4.77 +DecodeUA=0 4.78 +MiscTrackerUrl="/js/awstats_misc_tracker.js" 4.79 + 4.80 +#----------------------------------------------------------------------------- 4.81 +# OPTIONAL ACCURACY SETUP SECTION (Not required but increase AWStats features) 4.82 +#----------------------------------------------------------------------------- 4.83 +LevelForBrowsersDetection=2 # 0 disables Browsers detection. 4.84 + # 2 reduces AWStats speed by 2% 4.85 +LevelForOSDetection=2 # 0 disables OS detection. 4.86 + # 2 reduces AWStats speed by 3% 4.87 +LevelForRefererAnalyze=2 # 0 disables Origin detection. 4.88 + # 2 reduces AWStats speed by 14% 4.89 +LevelForRobotsDetection=2 # 0 disables Robots detection. 4.90 + # 2 reduces AWStats speed by 2.5% 4.91 +LevelForSearchEnginesDetection=2 # 0 disables Search engines detection. 4.92 + # 2 reduces AWStats speed by 9% 4.93 +LevelForKeywordsDetection=2 # 0 disables Keyphrases/Keywords detection. 4.94 + # 2 reduces AWStats speed by 1% 4.95 +LevelForFileTypesDetection=2 # 0 disables File types detection. 4.96 + # 2 reduces AWStats speed by 1% 4.97 +LevelForWormsDetection=0 # 0 disables Worms detection. 4.98 + # 2 reduces AWStats speed by 15% 4.99 + 4.100 + 4.101 + 4.102 +#----------------------------------------------------------------------------- 4.103 +# OPTIONAL APPEARANCE SETUP SECTION (Not required but increase AWStats features) 4.104 +#----------------------------------------------------------------------------- 4.105 +UseFramesWhenCGI=1 4.106 +DetailedReportsOnNewWindows=1 4.107 +Expires=0 4.108 +MaxRowsInHTMLOutput=1000 4.109 +Lang="auto" 4.110 +DirLang="./lang" 4.111 +ShowMenu=1 4.112 +ShowMonthStats=UVPHB 4.113 +ShowDaysOfMonthStats=VPHB 4.114 +ShowDaysOfWeekStats=PHB 4.115 +ShowHoursStats=PHB 4.116 +ShowDomainsStats=PHB 4.117 +ShowHostsStats=PHBL 4.118 +ShowAuthenticatedUsers=0 4.119 +ShowRobotsStats=HBL 4.120 +ShowWormsStats=0 4.121 +ShowEMailSenders=0 4.122 +ShowEMailReceivers=0 4.123 +ShowSessionsStats=1 4.124 +ShowPagesStats=PBEX 4.125 +ShowFileTypesStats=HB 4.126 +ShowFileSizesStats=0 4.127 +ShowOSStats=1 4.128 +ShowBrowsersStats=1 4.129 +ShowScreenSizeStats=0 4.130 +ShowOriginStats=PH 4.131 +ShowKeyphrasesStats=1 4.132 +ShowKeywordsStats=1 4.133 +ShowMiscStats=a 4.134 +ShowHTTPErrorsStats=1 4.135 +ShowSMTPErrorsStats=0 4.136 +ShowClusterStats=0 4.137 + 4.138 +AddDataArrayMonthStats=1 4.139 +AddDataArrayShowDaysOfMonthStats=1 4.140 +AddDataArrayShowDaysOfWeekStats=1 4.141 +AddDataArrayShowHoursStats=1 4.142 + 4.143 +MaxNbOfDomain = 10 4.144 +MinHitDomain = 1 4.145 +MaxNbOfHostsShown = 10 4.146 +MinHitHost = 1 4.147 +MaxNbOfLoginShown = 10 4.148 +MinHitLogin = 1 4.149 +MaxNbOfRobotShown = 10 4.150 +MinHitRobot = 1 4.151 +MaxNbOfPageShown = 10 4.152 +MinHitFile = 1 4.153 +MaxNbOfOsShown = 10 4.154 +MinHitOs = 1 4.155 +MaxNbOfBrowsersShown = 10 4.156 +MinHitBrowser = 1 4.157 +MaxNbOfScreenSizesShown = 5 4.158 +MinHitScreenSize = 1 4.159 +MaxNbOfRefererShown = 10 4.160 +MinHitRefer = 1 4.161 +MaxNbOfKeyphrasesShown = 10 4.162 +MinHitKeyphrase = 1 4.163 +MaxNbOfKeywordsShown = 10 4.164 +MinHitKeyword = 1 4.165 +MaxNbOfEMailsShown = 20 4.166 +MinHitEMail = 1 4.167 +FirstDayOfWeek=1 4.168 + 4.169 +ShowFlagLinks="" 4.170 +ShowLinksOnUrl=1 4.171 +UseHTTPSLinkForUrl="" 4.172 +MaxLengthOfShownURL=64 4.173 +HTMLHeadSection="" 4.174 +HTMLEndSection="" 4.175 +Logo="slitaz-logo.png" 4.176 +LogoLink="http://forum.slita.org" 4.177 +BarWidth = 260 4.178 +BarHeight = 90 4.179 +StyleSheet="" 4.180 +color_Background="FFFFFF" # Background color for main page (Default = "FFFFFF") 4.181 +color_TableBGTitle="CCCCDD" # Background color for table title (Default = "CCCCDD") 4.182 +color_TableTitle="000000" # Table title font color (Default = "000000") 4.183 +color_TableBG="CCCCDD" # Background color for table (Default = "CCCCDD") 4.184 +color_TableRowTitle="FFFFFF" # Table row title font color (Default = "FFFFFF") 4.185 +color_TableBGRowTitle="ECECEC" # Background color for row title (Default = "ECECEC") 4.186 +color_TableBorder="ECECEC" # Table border color (Default = "ECECEC") 4.187 +color_text="000000" # Color of text (Default = "000000") 4.188 +color_textpercent="606060" # Color of text for percent values (Default = "606060") 4.189 +color_titletext="000000" # Color of text title within colored Title Rows (Default = "000000") 4.190 +color_weekend="EAEAEA" # Color for week-end days (Default = "EAEAEA") 4.191 +color_link="0011BB" # Color of HTML links (Default = "0011BB") 4.192 +color_hover="605040" # Color of HTML on-mouseover links (Default = "605040") 4.193 +color_u="FFAA66" # Background color for number of unique visitors (Default = "FFAA66") 4.194 +color_v="F4F090" # Background color for number of visites (Default = "F4F090") 4.195 +color_p="4477DD" # Background color for number of pages (Default = "4477DD") 4.196 +color_h="66DDEE" # Background color for number of hits (Default = "66DDEE") 4.197 +color_k="2EA495" # Background color for number of bytes (Default = "2EA495") 4.198 +color_s="8888DD" # Background color for number of search (Default = "8888DD") 4.199 +color_e="CEC2E8" # Background color for number of entry pages (Default = "CEC2E8") 4.200 +color_x="C1B2E2" # Background color for number of exit pages (Default = "C1B2E2") 4.201 + 4.202 + 4.203 + 4.204 +#----------------------------------------------------------------------------- 4.205 +# PLUGINS 4.206 +#----------------------------------------------------------------------------- 4.207 +#LoadPlugin="tooltips" 4.208 +#LoadPlugin="decodeutfkeys" 4.209 +#LoadPlugin="ipv6" 4.210 +#LoadPlugin="hashfiles" 4.211 +LoadPlugin="geoipfree" 4.212 +#LoadPlugin="geoip" 4.213 +#LoadPlugin="userinfo" 4.214 +#LoadPlugin="hostinfo" 4.215 +#LoadPlugin="urlalias" 4.216 +#LoadPlugin="timehires" 4.217 +#LoadPlugin="timezone +2" 4.218 +#LoadPlugin="rawlog" 4.219 +#LoadPlugin="graphapplet /awstatsclasses" # EXPERIMENTAL FEATURE 4.220 + 4.221 + 4.222 + 4.223 +#----------------------------------------------------------------------------- 4.224 +# EXTRA SECTIONS 4.225 +#----------------------------------------------------------------------------- 4.226 +#ExtraSectionName1="Product orders" 4.227 +#ExtraSectionCondition1="URL,\/cgi\-bin\/order\.cgi|URL,\/cgi\-bin\/order2\.cgi" 4.228 +#ExtraSectionFirstColumnTitle1="Product ID" 4.229 +#ExtraSectionFirstColumnValues1="QUERY_STRING,productid=([^&]+)" 4.230 +#ExtraSectionFirstColumnFormat1="%s" 4.231 +#ExtraSectionStatTypes1=PL 4.232 +#ExtraSectionAddAverageRow1=0 4.233 +#ExtraSectionAddSumRow1=1 4.234 +#MaxNbOfExtra1=20 4.235 +#MinHitExtra1=1 4.236 + 4.237 + 4.238 + 4.239 +#----------------------------------------------------------------------------- 4.240 +# INCLUDES 4.241 +#----------------------------------------------------------------------------- 4.242 +#Include "" 4.243 +
5.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 5.2 +++ b/forum/system-config/logrotate.d/slitaz-forum Wed Dec 22 10:25:56 2010 +0100 5.3 @@ -0,0 +1,21 @@ 5.4 +/home/slitaz/logs/access_log { 5.5 + missingok 5.6 + daily 5.7 + rotate 5 5.8 + prerotate 5.9 + /usr/local/bin/awsupdate forum.slitaz.org 5.10 + endscript 5.11 + postrotate 5.12 + /usr/bin/killall -HUP apache2 2> /dev/null || true 5.13 + endscript 5.14 +} 5.15 + 5.16 +/home/slitaz/logs/error_log { 5.17 + missingok 5.18 + daily 5.19 + rotate 5 5.20 + postrotate 5.21 + /usr/bin/killall -HUP apache2 2> /dev/null || true 5.22 + endscript 5.23 +} 5.24 +
6.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 6.2 +++ b/forum/vanilla-config/config.php Wed Dec 22 10:25:56 2010 +0100 6.3 @@ -0,0 +1,72 @@ 6.4 +<?php if (!defined('APPLICATION')) exit(); 6.5 + 6.6 +// Conversations 6.7 +$Configuration['Conversations']['Version'] = '2.0.16'; 6.8 + 6.9 +// Database 6.10 +$Configuration['Database']['Name'] = 'slitaz_forum'; 6.11 +$Configuration['Database']['Host'] = 'localhost'; 6.12 +$Configuration['Database']['User'] = '***'; 6.13 +$Configuration['Database']['Password'] = '***'; 6.14 + 6.15 +// EnabledApplications 6.16 +$Configuration['EnabledApplications']['Conversations'] = 'conversations'; 6.17 +$Configuration['EnabledApplications']['Skeleton'] = 'skeleton'; 6.18 +$Configuration['EnabledApplications']['Vanilla'] = 'vanilla'; 6.19 + 6.20 +// EnabledPlugins 6.21 +$Configuration['EnabledPlugins']['HtmLawed'] = 'HtmLawed'; 6.22 +$Configuration['EnabledPlugins']['Gravatar'] = 'Gravatar'; 6.23 +$Configuration['EnabledPlugins']['FileUpload'] = 'FileUpload'; 6.24 +$Configuration['EnabledPlugins']['WhosOnline'] = 'WhosOnline'; 6.25 +$Configuration['EnabledPlugins']['Minify'] = 'Minify'; 6.26 +$Configuration['EnabledPlugins']['cleditor'] = 'cleditor'; 6.27 +$Configuration['EnabledPlugins']['Tagging'] = 'Tagging'; 6.28 + 6.29 +// Garden 6.30 +$Configuration['Garden']['Title'] = 'SliTaz Forum'; 6.31 +$Configuration['Garden']['Cookie']['Salt'] = 'VS0GNTQ0ML'; 6.32 +$Configuration['Garden']['Cookie']['Domain'] = ''; 6.33 +$Configuration['Garden']['Version'] = '2.0.16'; 6.34 +$Configuration['Garden']['RewriteUrls'] = FALSE; 6.35 +$Configuration['Garden']['CanProcessImages'] = TRUE; 6.36 +$Configuration['Garden']['Installed'] = TRUE; 6.37 +$Configuration['Garden']['Errors']['MasterView'] = 'error.master.php'; 6.38 +$Configuration['Garden']['Theme'] = 'slitaz-2'; 6.39 +$Configuration['Garden']['Messages']['Cache'] = 'a:1:{i:0;s:6:"[Base]";}'; 6.40 +$Configuration['Garden']['EditContentTimeout'] = '-1'; 6.41 +$Configuration['Garden']['RequiredUpdates'] = 'a:0:{}'; 6.42 +$Configuration['Garden']['UpdateCheckDate'] = 1292966704; 6.43 +$Configuration['Garden']['Registration']['Method'] = 'Captcha'; 6.44 +$Configuration['Garden']['Registration']['CaptchaPrivateKey'] = '6Ld7zwgAAAAAAPo5ydoZaBn_8Wapn7nb0dypEf6M'; 6.45 +$Configuration['Garden']['Registration']['CaptchaPublicKey'] = '6Ld7zwgAAAAAALF1IeGgtdlEg1WYupYxd5ZqGIpg'; 6.46 +$Configuration['Garden']['Registration']['InviteExpiration'] = '-1 week'; 6.47 +$Configuration['Garden']['Registration']['InviteRoles'] = 'a:2:{i:8;s:1:"0";i:16;s:1:"0";}'; 6.48 + 6.49 +// Plugins 6.50 +$Configuration['Plugins']['GettingStarted']['Dashboard'] = '1'; 6.51 +$Configuration['Plugins']['GettingStarted']['Categories'] = '1'; 6.52 +$Configuration['Plugins']['GettingStarted']['Plugins'] = '1'; 6.53 +$Configuration['Plugins']['GettingStarted']['Discussion'] = '1'; 6.54 +$Configuration['Plugins']['FileUpload']['Enabled'] = TRUE; 6.55 +$Configuration['Plugins']['OpenID']['Enabled'] = FALSE; 6.56 +$Configuration['Plugins']['Tagging']['Enabled'] = TRUE; 6.57 + 6.58 +// Routes 6.59 +$Configuration['Routes']['DefaultController'] = 'a:2:{i:0;s:10:"categories";i:1;s:8:"Internal";}'; 6.60 + 6.61 +// Vanilla 6.62 +$Configuration['Vanilla']['Version'] = '2.0.16'; 6.63 +$Configuration['Vanilla']['Categories']['Use'] = TRUE; 6.64 +$Configuration['Vanilla']['Discussions']['PerPage'] = '30'; 6.65 +$Configuration['Vanilla']['Comments']['AutoRefresh'] = '0'; 6.66 +$Configuration['Vanilla']['Comments']['PerPage'] = '50'; 6.67 +$Configuration['Vanilla']['Archive']['Date'] = ''; 6.68 +$Configuration['Vanilla']['Archive']['Exclude'] = FALSE; 6.69 + 6.70 +// WhosOnline 6.71 +$Configuration['WhosOnline']['Frequency'] = '20'; 6.72 +$Configuration['WhosOnline']['Location']['Show'] = 'every'; 6.73 +$Configuration['WhosOnline']['Hide'] = TRUE; 6.74 + 6.75 +// Last edited by pankso (213.3.10.214)2010-12-21 16:25:04 6.76 \ No newline at end of file