-- Adminer 4.8.0 MySQL 5.5.5-10.5.9-MariaDB-1 dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `GDN_Permission`;
CREATE TABLE `GDN_Permission` (
  `PermissionID` int(11) NOT NULL AUTO_INCREMENT,
  `RoleID` int(11) NOT NULL DEFAULT 0,
  `JunctionTable` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `JunctionColumn` varchar(100) COLLATE utf8mb4_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.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,
  `Garden.Community.Manage` tinyint(4) NOT NULL DEFAULT 0,
  `Garden.Tokens.Add` tinyint(4) NOT NULL DEFAULT 0,
  `Garden.Uploads.Add` tinyint(4) NOT NULL DEFAULT 0,
  `Vanilla.Tagging.Add` 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.CloseOwn` 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,
  `Reactions.Positive.Add` tinyint(4) NOT NULL DEFAULT 0,
  `Reactions.Negative.Add` tinyint(4) NOT NULL DEFAULT 0,
  `Reactions.Flag.Add` tinyint(4) NOT NULL DEFAULT 0,
  `Garden.NoAds.Allow` tinyint(4) NOT NULL DEFAULT 0,
  `Plugins.Pockets.Manage` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`PermissionID`),
  KEY `FK_Permission_RoleID` (`RoleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `GDN_Permission` (`PermissionID`, `RoleID`, `JunctionTable`, `JunctionColumn`, `JunctionID`, `Garden.Email.View`, `Garden.Settings.Manage`, `Garden.Settings.View`, `Garden.SignIn.Allow`, `Garden.Users.Add`, `Garden.Users.Edit`, `Garden.Users.Delete`, `Garden.Users.Approve`, `Garden.Activity.Delete`, `Garden.Activity.View`, `Garden.Profiles.View`, `Garden.Profiles.Edit`, `Garden.Curation.Manage`, `Garden.Moderation.Manage`, `Garden.PersonalInfo.View`, `Garden.AdvancedNotifications.Allow`, `Garden.Community.Manage`, `Garden.Tokens.Add`, `Garden.Uploads.Add`, `Vanilla.Tagging.Add`, `Conversations.Moderation.Manage`, `Conversations.Conversations.Add`, `Vanilla.Approval.Require`, `Vanilla.Comments.Me`, `Vanilla.Discussions.CloseOwn`, `Vanilla.Discussions.View`, `Vanilla.Discussions.Add`, `Vanilla.Discussions.Edit`, `Vanilla.Discussions.Announce`, `Vanilla.Discussions.Sink`, `Vanilla.Discussions.Close`, `Vanilla.Discussions.Delete`, `Vanilla.Comments.Add`, `Vanilla.Comments.Edit`, `Vanilla.Comments.Delete`, `Reactions.Positive.Add`, `Reactions.Negative.Add`, `Reactions.Flag.Add`, `Garden.NoAds.Allow`, `Plugins.Pockets.Manage`) VALUES
(1,	0,	NULL,	NULL,	NULL,	3,	2,	2,	3,	2,	2,	2,	2,	2,	3,	3,	3,	2,	2,	2,	2,	2,	2,	3,	3,	2,	3,	2,	3,	2,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	3,	3,	3,	2,	2),
(2,	0,	'Category',	'PermissionCategoryID',	NULL,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	3,	3,	2,	2,	2,	2,	2,	3,	2,	2,	0,	0,	0,	0,	0),
(3,	2,	NULL,	NULL,	NULL,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0),
(4,	2,	'Category',	'PermissionCategoryID',	-1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0),
(5,	3,	NULL,	NULL,	NULL,	1,	0,	0,	1,	0,	0,	0,	0,	0,	1,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	1,	1,	0,	0),
(6,	3,	'Category',	'PermissionCategoryID',	-1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0),
(7,	4,	NULL,	NULL,	NULL,	1,	0,	0,	1,	0,	0,	0,	0,	0,	1,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	1,	1,	0,	0),
(8,	4,	'Category',	'PermissionCategoryID',	-1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0),
(9,	8,	NULL,	NULL,	NULL,	1,	0,	0,	1,	0,	0,	0,	0,	0,	1,	1,	1,	0,	0,	0,	0,	0,	0,	1,	0,	0,	1,	0,	0,	0,	1,	1,	0,	0,	0,	0,	0,	1,	0,	0,	1,	1,	1,	0,	0),
(10,	8,	'Category',	'PermissionCategoryID',	-1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	1,	0,	0,	0,	0,	0,	1,	0,	0,	0,	0,	0,	0,	0),
(11,	32,	NULL,	NULL,	NULL,	1,	0,	0,	1,	0,	0,	0,	0,	0,	1,	1,	1,	1,	1,	1,	0,	0,	0,	1,	0,	0,	1,	0,	0,	0,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	0,	0),
(12,	32,	'Category',	'PermissionCategoryID',	-1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	0,	0,	0,	0,	0),
(13,	16,	NULL,	NULL,	NULL,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	0,	1,	0,	0,	1,	0,	0,	0,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	0,	1),
(14,	16,	'Category',	'PermissionCategoryID',	-1,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	0,	0,	0,	0,	0);

DROP TABLE IF EXISTS `GDN_Role`;
CREATE TABLE `GDN_Role` (
  `RoleID` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Type` enum('guest','unconfirmed','applicant','member','moderator','administrator') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Sync` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `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=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `GDN_Role` (`RoleID`, `Name`, `Description`, `Type`, `Sync`, `Sort`, `Deletable`, `CanSession`, `PersonalInfo`) VALUES
(2,	'Guest',	'Guests can only view content. Anyone browsing the site who is not signed in is considered to be a \"Guest\".',	'guest',	'',	1,	0,	0,	0),
(3,	'Unconfirmed',	'Users must confirm their emails before becoming full members. They get assigned to this role.',	'unconfirmed',	'',	2,	0,	1,	0),
(4,	'Applicant',	'Users who have applied for membership, but have not yet been accepted. They have the same permissions as guests.',	'applicant',	'',	3,	0,	1,	0),
(8,	'Member',	'Members can participate in discussions.',	'member',	'',	4,	1,	1,	0),
(16,	'Administrator',	'Administrators have permission to do anything.',	'administrator',	'',	6,	1,	1,	0),
(32,	'Moderator',	'Moderators have permission to edit most content.',	'moderator',	'',	5,	1,	1,	0);

DROP TABLE IF EXISTS `GDN_UserRole`;
CREATE TABLE `GDN_UserRole` (
  `UserID` int(11) NOT NULL,
  `RoleID` int(11) NOT NULL,
  PRIMARY KEY (`UserID`,`RoleID`),
  KEY `IX_UserRole_RoleID` (`RoleID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `GDN_UserRole` (`UserID`, `RoleID`) VALUES
(1,	16),
(2,	16),
(3,	16),
(4,	16),
(5,	32),
(6,	8),
(7,	16),
(8,	32),
(9,	8);

-- 2021-05-11 20:07:27