SliTaz Repositories

     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