Skip to content

Instantly share code, notes, and snippets.

@intellecat

intellecat/gist:7729819

Created December 1, 2013 08:20
Show Gist options
  • Save intellecat/7729819 to your computer and use it in GitHub Desktop.
Save intellecat/7729819 to your computer and use it in GitHub Desktop.
Download ZIP
vanilla sql
Raw
gistfile1.sql
# ************************************************************
# Sequel Pro SQL dump
# Version 4096
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: 127.0.0.1 (MySQL 5.6.12)
# Database: garden
# Generation Time: 2013-12-01 08:18:05 +0000
# ************************************************************
/*!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 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table gdn_activity
# ------------------------------------------------------------
CREATE TABLE `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_DateUpdated` (`DateUpdated`),
KEY `FK_Activity_InsertUserID` (`InsertUserID`),
KEY `IX_Activity_Recent` (`NotifyUserID`,`DateUpdated`),
KEY `IX_Activity_Feed` (`NotifyUserID`,`ActivityUserID`,`DateUpdated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_ActivityComment
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_ActivityType
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_AnalyticsLocal
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Ban
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Category
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Comment
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Conversation
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_ConversationMessage
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Discussion
# ------------------------------------------------------------
CREATE TABLE `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,
`State` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`DiscussionID`),
KEY `IX_Discussion_Type` (`Type`),
KEY `IX_Discussion_ForeignID` (`ForeignID`),
KEY `IX_Discussion_DateLastComment` (`DateLastComment`),
KEY `IX_Discussion_RegardingID` (`RegardingID`),
KEY `FK_Discussion_CategoryID` (`CategoryID`),
KEY `FK_Discussion_InsertUserID` (`InsertUserID`),
KEY `IX_Discussion_DateInserted` (`DateInserted`),
KEY `IX_Discussion_CategoryPages` (`CategoryID`,`DateLastComment`),
FULLTEXT KEY `TX_Discussion` (`Name`,`Body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_Draft
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Invitation
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Log
# ------------------------------------------------------------
CREATE TABLE `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,
`Data` mediumtext COLLATE utf8_unicode_ci,
`CountGroup` int(11) DEFAULT NULL,
`CategoryID` 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;
# Dump of table GDN_Media
# ------------------------------------------------------------
CREATE TABLE `GDN_Media` (
`MediaID` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Type` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`Size` int(11) NOT NULL,
`ImageWidth` smallint(5) unsigned DEFAULT NULL,
`ImageHeight` smallint(5) unsigned DEFAULT NULL,
`StorageMethod` varchar(24) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'local',
`Path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`ThumbWidth` smallint(5) unsigned DEFAULT NULL,
`ThumbHeight` smallint(5) unsigned DEFAULT NULL,
`ThumbPath` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`InsertUserID` int(11) NOT NULL,
`DateInserted` datetime NOT NULL,
`ForeignID` int(11) DEFAULT NULL,
`ForeignTable` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`MediaID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_Message
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Permission
# ------------------------------------------------------------
CREATE TABLE `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.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.Applicants.Manage` 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.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.Attachments.Upload.Allow` tinyint(4) NOT NULL DEFAULT '0',
`Plugins.Attachments.Download.Allow` tinyint(4) NOT NULL DEFAULT '0',
`Garden.Email.View` tinyint(4) NOT NULL DEFAULT '0',
`Plugins.Debugger.View` tinyint(4) NOT NULL DEFAULT '0',
`Plugins.Debugger.Manage` tinyint(4) NOT NULL DEFAULT '0',
`Plugins.Pockets.Manage` tinyint(4) NOT NULL DEFAULT '0',
`Vanilla.Approval.Require` tinyint(4) NOT NULL DEFAULT '0',
`Vanilla.Comments.Me` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`PermissionID`),
KEY `FK_Permission_RoleID` (`RoleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_Photo
# ------------------------------------------------------------
CREATE TABLE `GDN_Photo` (
`PhotoID` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`InsertUserID` int(11) DEFAULT NULL,
`DateInserted` datetime NOT NULL,
PRIMARY KEY (`PhotoID`),
KEY `FK_Photo_InsertUserID` (`InsertUserID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_Pocket
# ------------------------------------------------------------
CREATE TABLE `GDN_Pocket` (
`PocketID` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`Page` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`Location` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`Sort` smallint(6) NOT NULL,
`Repeat` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
`Body` text COLLATE utf8_unicode_ci NOT NULL,
`Format` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`Condition` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
`Disabled` smallint(6) NOT NULL DEFAULT '0',
`Attributes` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`PocketID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_Regarding
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Role
# ------------------------------------------------------------
CREATE TABLE `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(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`RoleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_Session
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Spammer
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_Tag
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_TagCategoryCount
# ------------------------------------------------------------
CREATE TABLE `GDN_TagCategoryCount` (
`CategoryID` int(11) NOT NULL,
`TagID` int(11) NOT NULL,
`CountDiscussions` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`CategoryID`,`TagID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_TagDiscussion
# ------------------------------------------------------------
CREATE TABLE `GDN_TagDiscussion` (
`TagID` int(11) NOT NULL,
`DiscussionID` int(11) NOT NULL,
`DateInserted` datetime DEFAULT NULL,
`CategoryID` int(11) NOT NULL,
PRIMARY KEY (`TagID`,`DiscussionID`),
KEY `IX_TagDiscussion_CategoryID` (`CategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_User
# ------------------------------------------------------------
CREATE TABLE `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,
PRIMARY KEY (`UserID`),
KEY `FK_User_Name` (`Name`),
KEY `IX_User_Email` (`Email`),
KEY `IX_User_DateLastActive` (`DateLastActive`),
KEY `IX_User_DateInserted` (`DateInserted`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_UserAuthentication
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserAuthenticationNonce
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserAuthenticationProvider
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserAuthenticationToken
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserCategory
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserComment
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserConversation
# ------------------------------------------------------------
CREATE TABLE `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 `FK_UserConversation_LastMessageID` (`LastMessageID`),
KEY `IX_UserConversation_Inbox` (`UserID`,`Deleted`,`DateConversationUpdated`),
KEY `FK_UserConversation_ConversationID` (`ConversationID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
# Dump of table GDN_UserDiscussion
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserMerge
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserMergeItem
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserMeta
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserPoints
# ------------------------------------------------------------
CREATE TABLE `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;
# Dump of table GDN_UserRole
# ------------------------------------------------------------
CREATE TABLE `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;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!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 */;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment