-- Adminer 4.8.0 MySQL 5.5.5-10.3.24-MariaDB-2 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.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.EMailNotification.Send` 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.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`, `Plugins.EMailNotification.Send`) 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,	0,	0,	0,	0,	0,	0,	0,	0,	0,	0,	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,	3,	3,	2,	2,	2,	2,	2,	3,	2,	2,	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,	1,	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,	1,	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,	1,	0,	0,	0,	0,	0,	0,	0,	0,	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,	1,	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,	1,	0,	0,	0,	0,	0,	0,	0,	0,	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,	1,	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,	1,	1,	0,	0,	0,	0,	0,	1,	0,	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,	1,	1,	0,	0,	0,	0,	0,	1,	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,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	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,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	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,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	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,	1,	1,	1,	1,	1,	1,	1,	1,	1,	1,	0);

-- 2021-03-11 22:38:33