-- phpMyAdmin SQL Dump -- version 3.4.11.1deb2 -- http://www.phpmyadmin.net -- -- Client: localhost -- Généré le: Mer 25 Septembre 2013 à 00:25 -- Version du serveur: 5.5.30 -- Version de PHP: 5.4.4-14 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Base de données: `vn_fr` -- -- -------------------------------------------------------- -- -- Structure de la table `GDN_Activity` -- CREATE TABLE IF NOT EXISTS `GDN_Activity` ( `ActivityID` int(11) NOT NULL AUTO_INCREMENT, `ActivityTypeID` int(11) NOT NULL, `NotifyUserID` int(11) NOT NULL DEFAULT '0', `ActivityUserID` int(11) DEFAULT NULL, `RegardingUserID` int(11) DEFAULT NULL, `Photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `HeadlineFormat` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Story` text COLLATE utf8_unicode_ci, `Format` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `Route` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `RecordType` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `RecordID` int(11) DEFAULT NULL, `InsertUserID` int(11) DEFAULT NULL, `DateInserted` datetime NOT NULL, `InsertIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `DateUpdated` datetime NOT NULL, `Notified` tinyint(4) NOT NULL DEFAULT '0', `Emailed` tinyint(4) NOT NULL DEFAULT '0', `Data` text COLLATE utf8_unicode_ci, PRIMARY KEY (`ActivityID`), KEY `IX_Activity_Notify` (`NotifyUserID`,`Notified`), KEY `IX_Activity_Recent` (`NotifyUserID`,`DateUpdated`), KEY `IX_Activity_Feed` (`NotifyUserID`,`ActivityUserID`,`DateUpdated`), KEY `IX_Activity_DateUpdated` (`DateUpdated`), KEY `FK_Activity_InsertUserID` (`InsertUserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_ActivityComment` -- CREATE TABLE IF NOT EXISTS `GDN_ActivityComment` ( `ActivityCommentID` int(11) NOT NULL AUTO_INCREMENT, `ActivityID` int(11) NOT NULL, `Body` text COLLATE utf8_unicode_ci NOT NULL, `Format` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `InsertUserID` int(11) NOT NULL, `DateInserted` datetime NOT NULL, `InsertIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`ActivityCommentID`), KEY `FK_ActivityComment_ActivityID` (`ActivityID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_ActivityType` -- CREATE TABLE IF NOT EXISTS `GDN_ActivityType` ( `ActivityTypeID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `AllowComments` tinyint(4) NOT NULL DEFAULT '0', `ShowIcon` tinyint(4) NOT NULL DEFAULT '0', `ProfileHeadline` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `FullHeadline` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `RouteCode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Notify` tinyint(4) NOT NULL DEFAULT '0', `Public` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`ActivityTypeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=32 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_AnalyticsLocal` -- CREATE TABLE IF NOT EXISTS `GDN_AnalyticsLocal` ( `TimeSlot` varchar(8) COLLATE utf8_unicode_ci NOT NULL, `Views` int(11) DEFAULT NULL, `EmbedViews` int(11) DEFAULT NULL, UNIQUE KEY `UX_AnalyticsLocal` (`TimeSlot`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Ban` -- CREATE TABLE IF NOT EXISTS `GDN_Ban` ( `BanID` int(11) NOT NULL AUTO_INCREMENT, `BanType` enum('IPAddress','Name','Email') COLLATE utf8_unicode_ci NOT NULL, `BanValue` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Notes` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CountUsers` int(10) unsigned NOT NULL DEFAULT '0', `CountBlockedRegistrations` int(10) unsigned NOT NULL DEFAULT '0', `InsertUserID` int(11) NOT NULL, `DateInserted` datetime NOT NULL, PRIMARY KEY (`BanID`), UNIQUE KEY `UX_Ban` (`BanType`,`BanValue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Category` -- CREATE TABLE IF NOT EXISTS `GDN_Category` ( `CategoryID` int(11) NOT NULL AUTO_INCREMENT, `ParentCategoryID` int(11) DEFAULT NULL, `TreeLeft` int(11) DEFAULT NULL, `TreeRight` int(11) DEFAULT NULL, `Depth` int(11) DEFAULT NULL, `CountDiscussions` int(11) NOT NULL DEFAULT '0', `CountComments` int(11) NOT NULL DEFAULT '0', `DateMarkedRead` datetime DEFAULT NULL, `AllowDiscussions` tinyint(4) NOT NULL DEFAULT '1', `Archived` tinyint(4) NOT NULL DEFAULT '0', `Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `UrlCode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Description` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `Sort` int(11) DEFAULT NULL, `CssClass` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `Photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PermissionCategoryID` int(11) NOT NULL DEFAULT '-1', `PointsCategoryID` int(11) NOT NULL DEFAULT '0', `HideAllDiscussions` tinyint(4) NOT NULL DEFAULT '0', `DisplayAs` enum('Categories','Discussions','Default') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Default', `InsertUserID` int(11) NOT NULL, `UpdateUserID` int(11) DEFAULT NULL, `DateInserted` datetime NOT NULL, `DateUpdated` datetime NOT NULL, `LastCommentID` int(11) DEFAULT NULL, `LastDiscussionID` int(11) DEFAULT NULL, `LastDateInserted` datetime DEFAULT NULL, `AllowedDiscussionTypes` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `DefaultDiscussionType` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`CategoryID`), KEY `FK_Category_InsertUserID` (`InsertUserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Comment` -- CREATE TABLE IF NOT EXISTS `GDN_Comment` ( `CommentID` int(11) NOT NULL AUTO_INCREMENT, `DiscussionID` int(11) NOT NULL, `InsertUserID` int(11) DEFAULT NULL, `UpdateUserID` int(11) DEFAULT NULL, `DeleteUserID` int(11) DEFAULT NULL, `Body` text COLLATE utf8_unicode_ci NOT NULL, `Format` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `DateInserted` datetime DEFAULT NULL, `DateDeleted` datetime DEFAULT NULL, `DateUpdated` datetime DEFAULT NULL, `InsertIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `UpdateIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `Flag` tinyint(4) NOT NULL DEFAULT '0', `Score` float DEFAULT NULL, `Attributes` text COLLATE utf8_unicode_ci, `QnA` enum('Accepted','Rejected') COLLATE utf8_unicode_ci DEFAULT NULL, `DateAccepted` datetime DEFAULT NULL, `AcceptedUserID` int(11) DEFAULT NULL, PRIMARY KEY (`CommentID`), KEY `IX_Comment_1` (`DiscussionID`,`DateInserted`), KEY `IX_Comment_DateInserted` (`DateInserted`), KEY `FK_Comment_InsertUserID` (`InsertUserID`), FULLTEXT KEY `TX_Comment` (`Body`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Conversation` -- CREATE TABLE IF NOT EXISTS `GDN_Conversation` ( `ConversationID` int(11) NOT NULL AUTO_INCREMENT, `Type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `Subject` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `Contributors` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `FirstMessageID` int(11) DEFAULT NULL, `InsertUserID` int(11) NOT NULL, `DateInserted` datetime DEFAULT NULL, `InsertIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `UpdateUserID` int(11) NOT NULL, `DateUpdated` datetime NOT NULL, `UpdateIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `CountMessages` int(11) NOT NULL DEFAULT '0', `LastMessageID` int(11) DEFAULT NULL, `RegardingID` int(11) DEFAULT NULL, PRIMARY KEY (`ConversationID`), KEY `FK_Conversation_FirstMessageID` (`FirstMessageID`), KEY `FK_Conversation_InsertUserID` (`InsertUserID`), KEY `FK_Conversation_DateInserted` (`DateInserted`), KEY `FK_Conversation_UpdateUserID` (`UpdateUserID`), KEY `IX_Conversation_RegardingID` (`RegardingID`), KEY `IX_Conversation_Type` (`Type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_ConversationMessage` -- CREATE TABLE IF NOT EXISTS `GDN_ConversationMessage` ( `MessageID` int(11) NOT NULL AUTO_INCREMENT, `ConversationID` int(11) NOT NULL, `Body` text COLLATE utf8_unicode_ci NOT NULL, `Format` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `InsertUserID` int(11) DEFAULT NULL, `DateInserted` datetime NOT NULL, `InsertIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`MessageID`), KEY `FK_ConversationMessage_ConversationID` (`ConversationID`), KEY `FK_ConversationMessage_InsertUserID` (`InsertUserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Discussion` -- CREATE TABLE IF NOT EXISTS `GDN_Discussion` ( `DiscussionID` int(11) NOT NULL AUTO_INCREMENT, `Type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `ForeignID` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `CategoryID` int(11) NOT NULL, `InsertUserID` int(11) NOT NULL, `UpdateUserID` int(11) DEFAULT NULL, `FirstCommentID` int(11) DEFAULT NULL, `LastCommentID` int(11) DEFAULT NULL, `Name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `Body` text COLLATE utf8_unicode_ci NOT NULL, `Format` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `Tags` text COLLATE utf8_unicode_ci, `CountComments` int(11) NOT NULL DEFAULT '0', `CountBookmarks` int(11) DEFAULT NULL, `CountViews` int(11) NOT NULL DEFAULT '1', `Closed` tinyint(4) NOT NULL DEFAULT '0', `Announce` tinyint(4) NOT NULL DEFAULT '0', `Sink` tinyint(4) NOT NULL DEFAULT '0', `DateInserted` datetime NOT NULL, `DateUpdated` datetime DEFAULT NULL, `InsertIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `UpdateIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `DateLastComment` datetime DEFAULT NULL, `LastCommentUserID` int(11) DEFAULT NULL, `Score` float DEFAULT NULL, `Attributes` text COLLATE utf8_unicode_ci, `RegardingID` int(11) DEFAULT NULL, `QnA` enum('Unanswered','Answered','Accepted','Rejected') COLLATE utf8_unicode_ci DEFAULT NULL, `DateAccepted` datetime DEFAULT NULL, `DateOfAnswer` datetime DEFAULT NULL, PRIMARY KEY (`DiscussionID`), KEY `IX_Discussion_Type` (`Type`), KEY `IX_Discussion_ForeignID` (`ForeignID`), KEY `IX_Discussion_DateInserted` (`DateInserted`), KEY `IX_Discussion_DateLastComment` (`DateLastComment`), KEY `IX_Discussion_RegardingID` (`RegardingID`), KEY `IX_Discussion_CategoryPages` (`CategoryID`,`DateLastComment`), KEY `FK_Discussion_CategoryID` (`CategoryID`), KEY `FK_Discussion_InsertUserID` (`InsertUserID`), FULLTEXT KEY `TX_Discussion` (`Name`,`Body`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Draft` -- CREATE TABLE IF NOT EXISTS `GDN_Draft` ( `DraftID` int(11) NOT NULL AUTO_INCREMENT, `DiscussionID` int(11) DEFAULT NULL, `CategoryID` int(11) DEFAULT NULL, `InsertUserID` int(11) NOT NULL, `UpdateUserID` int(11) NOT NULL, `Name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `Tags` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Closed` tinyint(4) NOT NULL DEFAULT '0', `Announce` tinyint(4) NOT NULL DEFAULT '0', `Sink` tinyint(4) NOT NULL DEFAULT '0', `Body` text COLLATE utf8_unicode_ci NOT NULL, `Format` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `DateInserted` datetime NOT NULL, `DateUpdated` datetime DEFAULT NULL, PRIMARY KEY (`DraftID`), KEY `FK_Draft_DiscussionID` (`DiscussionID`), KEY `FK_Draft_CategoryID` (`CategoryID`), KEY `FK_Draft_InsertUserID` (`InsertUserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Invitation` -- CREATE TABLE IF NOT EXISTS `GDN_Invitation` ( `InvitationID` int(11) NOT NULL AUTO_INCREMENT, `Email` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `Code` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `InsertUserID` int(11) DEFAULT NULL, `DateInserted` datetime NOT NULL, `AcceptedUserID` int(11) DEFAULT NULL, PRIMARY KEY (`InvitationID`), KEY `FK_Invitation_InsertUserID` (`InsertUserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Log` -- CREATE TABLE IF NOT EXISTS `GDN_Log` ( `LogID` int(11) NOT NULL AUTO_INCREMENT, `Operation` enum('Delete','Edit','Spam','Moderate','Pending','Ban','Error') COLLATE utf8_unicode_ci NOT NULL, `RecordType` enum('Discussion','Comment','User','Registration','Activity','ActivityComment','Configuration','Group') COLLATE utf8_unicode_ci NOT NULL, `TransactionLogID` int(11) DEFAULT NULL, `RecordID` int(11) DEFAULT NULL, `RecordUserID` int(11) DEFAULT NULL, `RecordDate` datetime NOT NULL, `RecordIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `InsertUserID` int(11) NOT NULL, `DateInserted` datetime NOT NULL, `InsertIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `OtherUserIDs` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `DateUpdated` datetime DEFAULT NULL, `ParentRecordID` int(11) DEFAULT NULL, `CategoryID` int(11) DEFAULT NULL, `Data` mediumtext COLLATE utf8_unicode_ci, `CountGroup` int(11) DEFAULT NULL, PRIMARY KEY (`LogID`), KEY `IX_Log_RecordType` (`RecordType`), KEY `IX_Log_RecordID` (`RecordID`), KEY `IX_Log_RecordIPAddress` (`RecordIPAddress`), KEY `IX_Log_ParentRecordID` (`ParentRecordID`), KEY `FK_Log_CategoryID` (`CategoryID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=64 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Media` -- CREATE TABLE IF NOT EXISTS `GDN_Media` ( `MediaID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `Path` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `Type` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `Size` int(11) NOT NULL, `InsertUserID` int(11) NOT NULL, `DateInserted` datetime NOT NULL, `ForeignID` int(11) DEFAULT NULL, `ForeignTable` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL, `ImageWidth` smallint(5) unsigned DEFAULT NULL, `ImageHeight` smallint(5) unsigned DEFAULT NULL, `ThumbWidth` smallint(5) unsigned DEFAULT NULL, `ThumbHeight` smallint(5) unsigned DEFAULT NULL, `ThumbPath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`MediaID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Message` -- CREATE TABLE IF NOT EXISTS `GDN_Message` ( `MessageID` int(11) NOT NULL AUTO_INCREMENT, `Content` text COLLATE utf8_unicode_ci NOT NULL, `Format` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `AllowDismiss` tinyint(4) NOT NULL DEFAULT '1', `Enabled` tinyint(4) NOT NULL DEFAULT '1', `Application` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Controller` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Method` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `CategoryID` int(11) DEFAULT NULL, `IncludeSubcategories` tinyint(4) NOT NULL DEFAULT '0', `AssetTarget` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `CssClass` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `Sort` int(11) DEFAULT NULL, PRIMARY KEY (`MessageID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Permission` -- CREATE TABLE IF NOT EXISTS `GDN_Permission` ( `PermissionID` int(11) NOT NULL AUTO_INCREMENT, `RoleID` int(11) NOT NULL DEFAULT '0', `JunctionTable` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `JunctionColumn` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `JunctionID` int(11) DEFAULT NULL, `Garden.Email.View` tinyint(4) NOT NULL DEFAULT '0', `Garden.Settings.Manage` tinyint(4) NOT NULL DEFAULT '0', `Garden.Settings.View` tinyint(4) NOT NULL DEFAULT '0', `Garden.Messages.Manage` tinyint(4) NOT NULL DEFAULT '0', `Garden.SignIn.Allow` tinyint(4) NOT NULL DEFAULT '0', `Garden.Users.Add` tinyint(4) NOT NULL DEFAULT '0', `Garden.Users.Edit` tinyint(4) NOT NULL DEFAULT '0', `Garden.Users.Delete` tinyint(4) NOT NULL DEFAULT '0', `Garden.Users.Approve` tinyint(4) NOT NULL DEFAULT '0', `Garden.Activity.Delete` tinyint(4) NOT NULL DEFAULT '0', `Garden.Activity.View` tinyint(4) NOT NULL DEFAULT '0', `Garden.Profiles.View` tinyint(4) NOT NULL DEFAULT '0', `Garden.Profiles.Edit` tinyint(4) NOT NULL DEFAULT '0', `Garden.Curation.Manage` tinyint(4) NOT NULL DEFAULT '0', `Garden.Moderation.Manage` tinyint(4) NOT NULL DEFAULT '0', `Garden.PersonalInfo.View` tinyint(4) NOT NULL DEFAULT '0', `Garden.AdvancedNotifications.Allow` tinyint(4) NOT NULL DEFAULT '0', `Conversations.Moderation.Manage` tinyint(4) NOT NULL DEFAULT '0', `Conversations.Conversations.Add` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Approval.Require` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Comments.Me` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Discussions.View` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Discussions.Add` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Discussions.Edit` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Discussions.Announce` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Discussions.Sink` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Discussions.Close` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Discussions.Delete` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Comments.Add` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Comments.Edit` tinyint(4) NOT NULL DEFAULT '0', `Vanilla.Comments.Delete` tinyint(4) NOT NULL DEFAULT '0', `Plugins.Signatures.Edit` tinyint(4) NOT NULL DEFAULT '0', `Plugins.Tagging.Add` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`PermissionID`), KEY `FK_Permission_RoleID` (`RoleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=14 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Regarding` -- CREATE TABLE IF NOT EXISTS `GDN_Regarding` ( `RegardingID` int(11) NOT NULL AUTO_INCREMENT, `Type` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `InsertUserID` int(11) NOT NULL, `DateInserted` datetime NOT NULL, `ForeignType` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `ForeignID` int(11) NOT NULL, `OriginalContent` text COLLATE utf8_unicode_ci, `ParentType` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `ParentID` int(11) DEFAULT NULL, `ForeignURL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Comment` text COLLATE utf8_unicode_ci NOT NULL, `Reports` int(11) DEFAULT NULL, PRIMARY KEY (`RegardingID`), KEY `FK_Regarding_Type` (`Type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Role` -- CREATE TABLE IF NOT EXISTS `GDN_Role` ( `RoleID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `Description` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL, `Sort` int(11) DEFAULT NULL, `Deletable` tinyint(4) NOT NULL DEFAULT '1', `CanSession` tinyint(4) NOT NULL DEFAULT '1', `PersonalInfo` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`RoleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=33 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Session` -- CREATE TABLE IF NOT EXISTS `GDN_Session` ( `SessionID` char(32) COLLATE utf8_unicode_ci NOT NULL, `UserID` int(11) NOT NULL DEFAULT '0', `DateInserted` datetime NOT NULL, `DateUpdated` datetime NOT NULL, `TransientKey` varchar(12) COLLATE utf8_unicode_ci NOT NULL, `Attributes` text COLLATE utf8_unicode_ci, PRIMARY KEY (`SessionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Spammer` -- CREATE TABLE IF NOT EXISTS `GDN_Spammer` ( `UserID` int(11) NOT NULL, `CountSpam` smallint(5) unsigned NOT NULL DEFAULT '0', `CountDeletedSpam` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_Tag` -- CREATE TABLE IF NOT EXISTS `GDN_Tag` ( `TagID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `Type` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `InsertUserID` int(11) DEFAULT NULL, `DateInserted` datetime NOT NULL, `CategoryID` int(11) NOT NULL DEFAULT '-1', `CountDiscussions` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`TagID`), UNIQUE KEY `UX_Tag` (`Name`,`CategoryID`), KEY `IX_Tag_Type` (`Type`), KEY `FK_Tag_InsertUserID` (`InsertUserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_TagDiscussion` -- CREATE TABLE IF NOT EXISTS `GDN_TagDiscussion` ( `TagID` int(11) NOT NULL, `DiscussionID` int(11) NOT NULL, `CategoryID` int(11) NOT NULL, `DateInserted` datetime NOT NULL, PRIMARY KEY (`TagID`,`DiscussionID`), KEY `IX_TagDiscussion_CategoryID` (`CategoryID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_User` -- CREATE TABLE IF NOT EXISTS `GDN_User` ( `UserID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `Password` varbinary(100) NOT NULL, `HashMethod` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `Photo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `Location` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `About` text COLLATE utf8_unicode_ci, `Email` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `ShowEmail` tinyint(4) NOT NULL DEFAULT '0', `Gender` enum('u','m','f') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'u', `CountVisits` int(11) NOT NULL DEFAULT '0', `CountInvitations` int(11) NOT NULL DEFAULT '0', `CountNotifications` int(11) DEFAULT NULL, `InviteUserID` int(11) DEFAULT NULL, `DiscoveryText` text COLLATE utf8_unicode_ci, `Preferences` text COLLATE utf8_unicode_ci, `Permissions` text COLLATE utf8_unicode_ci, `Attributes` text COLLATE utf8_unicode_ci, `DateSetInvitations` datetime DEFAULT NULL, `DateOfBirth` datetime DEFAULT NULL, `DateFirstVisit` datetime DEFAULT NULL, `DateLastActive` datetime DEFAULT NULL, `LastIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `AllIPAddresses` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `DateInserted` datetime NOT NULL, `InsertIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `DateUpdated` datetime DEFAULT NULL, `UpdateIPAddress` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `HourOffset` int(11) NOT NULL DEFAULT '0', `Score` float DEFAULT NULL, `Admin` tinyint(4) NOT NULL DEFAULT '0', `Confirmed` tinyint(4) NOT NULL DEFAULT '1', `Verified` tinyint(4) NOT NULL DEFAULT '0', `Banned` tinyint(4) NOT NULL DEFAULT '0', `Deleted` tinyint(4) NOT NULL DEFAULT '0', `Points` int(11) NOT NULL DEFAULT '0', `CountUnreadConversations` int(11) DEFAULT NULL, `CountDiscussions` int(11) DEFAULT NULL, `CountUnreadDiscussions` int(11) DEFAULT NULL, `CountComments` int(11) DEFAULT NULL, `CountDrafts` int(11) DEFAULT NULL, `CountBookmarks` int(11) DEFAULT NULL, `CountAcceptedAnswers` int(11) NOT NULL DEFAULT '0', `Fingerprint` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`UserID`), KEY `FK_User_Name` (`Name`), KEY `IX_User_Email` (`Email`), KEY `IX_User_DateLastActive` (`DateLastActive`), KEY `IX_User_DateInserted` (`DateInserted`), KEY `IX_User_Fingerprint` (`Fingerprint`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserAuthentication` -- CREATE TABLE IF NOT EXISTS `GDN_UserAuthentication` ( `ForeignUserKey` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `ProviderKey` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `UserID` int(11) NOT NULL, PRIMARY KEY (`ForeignUserKey`,`ProviderKey`), KEY `FK_UserAuthentication_UserID` (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserAuthenticationNonce` -- CREATE TABLE IF NOT EXISTS `GDN_UserAuthenticationNonce` ( `Nonce` varchar(200) COLLATE utf8_unicode_ci NOT NULL, `Token` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`Nonce`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserAuthenticationProvider` -- CREATE TABLE IF NOT EXISTS `GDN_UserAuthenticationProvider` ( `AuthenticationKey` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `AuthenticationSchemeAlias` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `Name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `URL` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `AssociationSecret` text COLLATE utf8_unicode_ci, `AssociationHashMethod` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `AuthenticateUrl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `RegisterUrl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `SignInUrl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `SignOutUrl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `PasswordUrl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ProfileUrl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `Attributes` text COLLATE utf8_unicode_ci, `Active` tinyint(4) NOT NULL DEFAULT '1', `IsDefault` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`AuthenticationKey`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserAuthenticationToken` -- CREATE TABLE IF NOT EXISTS `GDN_UserAuthenticationToken` ( `Token` varchar(128) COLLATE utf8_unicode_ci NOT NULL, `ProviderKey` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `ForeignUserKey` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `TokenSecret` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `TokenType` enum('request','access') COLLATE utf8_unicode_ci NOT NULL, `Authorized` tinyint(4) NOT NULL, `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `Lifetime` int(11) NOT NULL, PRIMARY KEY (`Token`,`ProviderKey`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserCategory` -- CREATE TABLE IF NOT EXISTS `GDN_UserCategory` ( `UserID` int(11) NOT NULL, `CategoryID` int(11) NOT NULL, `DateMarkedRead` datetime DEFAULT NULL, `Unfollow` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`UserID`,`CategoryID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserComment` -- CREATE TABLE IF NOT EXISTS `GDN_UserComment` ( `UserID` int(11) NOT NULL, `CommentID` int(11) NOT NULL, `Score` float DEFAULT NULL, `DateLastViewed` datetime DEFAULT NULL, PRIMARY KEY (`UserID`,`CommentID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserConversation` -- CREATE TABLE IF NOT EXISTS `GDN_UserConversation` ( `UserID` int(11) NOT NULL, `ConversationID` int(11) NOT NULL, `CountReadMessages` int(11) NOT NULL DEFAULT '0', `LastMessageID` int(11) DEFAULT NULL, `DateLastViewed` datetime DEFAULT NULL, `DateCleared` datetime DEFAULT NULL, `Bookmarked` tinyint(4) NOT NULL DEFAULT '0', `Deleted` tinyint(4) NOT NULL DEFAULT '0', `DateConversationUpdated` datetime DEFAULT NULL, PRIMARY KEY (`UserID`,`ConversationID`), KEY `IX_UserConversation_Inbox` (`UserID`,`Deleted`,`DateConversationUpdated`), KEY `FK_UserConversation_ConversationID` (`ConversationID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserDiscussion` -- CREATE TABLE IF NOT EXISTS `GDN_UserDiscussion` ( `UserID` int(11) NOT NULL, `DiscussionID` int(11) NOT NULL, `Score` float DEFAULT NULL, `CountComments` int(11) NOT NULL DEFAULT '0', `DateLastViewed` datetime DEFAULT NULL, `Dismissed` tinyint(4) NOT NULL DEFAULT '0', `Bookmarked` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`UserID`,`DiscussionID`), KEY `FK_UserDiscussion_DiscussionID` (`DiscussionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserMerge` -- CREATE TABLE IF NOT EXISTS `GDN_UserMerge` ( `MergeID` int(11) NOT NULL AUTO_INCREMENT, `OldUserID` int(11) NOT NULL, `NewUserID` int(11) NOT NULL, `DateInserted` datetime NOT NULL, `InsertUserID` int(11) NOT NULL, `DateUpdated` datetime DEFAULT NULL, `UpdateUserID` int(11) DEFAULT NULL, `Attributes` text COLLATE utf8_unicode_ci, PRIMARY KEY (`MergeID`), KEY `FK_UserMerge_OldUserID` (`OldUserID`), KEY `FK_UserMerge_NewUserID` (`NewUserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserMergeItem` -- CREATE TABLE IF NOT EXISTS `GDN_UserMergeItem` ( `MergeID` int(11) NOT NULL, `Table` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `Column` varchar(30) COLLATE utf8_unicode_ci NOT NULL, `RecordID` int(11) NOT NULL, `OldUserID` int(11) NOT NULL, `NewUserID` int(11) NOT NULL, KEY `FK_UserMergeItem_MergeID` (`MergeID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserMeta` -- CREATE TABLE IF NOT EXISTS `GDN_UserMeta` ( `UserID` int(11) NOT NULL, `Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `Value` text COLLATE utf8_unicode_ci, PRIMARY KEY (`UserID`,`Name`), KEY `IX_UserMeta_Name` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserPoints` -- CREATE TABLE IF NOT EXISTS `GDN_UserPoints` ( `SlotType` enum('d','w','m','y','a') COLLATE utf8_unicode_ci NOT NULL, `TimeSlot` datetime NOT NULL, `Source` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Total', `CategoryID` int(11) NOT NULL DEFAULT '0', `UserID` int(11) NOT NULL, `Points` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`SlotType`,`TimeSlot`,`Source`,`CategoryID`,`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UserRole` -- CREATE TABLE IF NOT EXISTS `GDN_UserRole` ( `UserID` int(11) NOT NULL, `RoleID` int(11) NOT NULL, PRIMARY KEY (`UserID`,`RoleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `GDN_UsersOnline` -- CREATE TABLE IF NOT EXISTS `GDN_UsersOnline` ( `SessionID` int(11) NOT NULL AUTO_INCREMENT, `UserIp` int(10) unsigned NOT NULL, `Time` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`SessionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;