CREATE DATABASE `pbs` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
USE pbs;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE IF NOT EXISTS `pbs_group` (
`groupID` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(140) COLLATE utf8_unicode_ci,
PRIMARY KEY (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `pbs_rightcategory` (
`rightcategoryID` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`rightcategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `pbs_right` (
`rightID` int(11) NOT NULL AUTO_INCREMENT,
`rightcategoryID` int(11) NOT NULL,
`shortcut` varchar(10) COLLATE utf8_unicode_ci NOT NULL UNIQUE,
`title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`rightID`),
KEY `rightcategoryID` (`rightcategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_right`
ADD CONSTRAINT `pbs_right_ibfk_1` FOREIGN KEY (`rightcategoryID`) REFERENCES `pbs_rightcategory` (`rightcategoryID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_role` (
`roleID` int(11) NOT NULL AUTO_INCREMENT,
`groupID` int(11) NOT NULL,
`title` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(140) COLLATE utf8_unicode_ci DEFAULT NULL,
`inheritance` tinyint(1) NOT NULL,
PRIMARY KEY (`roleID`),
KEY `groupID` (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
ALTER TABLE `pbs_role`
ADD CONSTRAINT `pbs_role_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_rightroles` (
`roleID` int(11) NOT NULL,
`rightID` int(11) NOT NULL,
PRIMARY KEY (`roleID`,`rightID`),
KEY `roleID` (`roleID`),
KEY `rightID` (`rightID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_rightroles`
ADD CONSTRAINT `pbs_rightroles_ibfk_1` FOREIGN KEY (`roleID`) REFERENCES `pbs_role` (`roleID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_rightroles_ibfk_2` FOREIGN KEY (`rightID`) REFERENCES `pbs_right` (`rightID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_groupgroups` (
`parentID` int(11) NOT NULL,
`groupID` int(11) NOT NULL,
PRIMARY KEY (`parentID`,`groupID`),
KEY `parentID` (`parentID`),
KEY `groupID` (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_groupgroups`
ADD CONSTRAINT `pbs_groupgroups_ibfk_1` FOREIGN KEY (`parentID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_groupgroups_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_person` (
`personID` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) COLLATE utf8_unicode_ci,
`name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`firstname` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
`street` varchar(30) COLLATE utf8_unicode_ci,
`housenumber` varchar(30) COLLATE utf8_unicode_ci,
`city` varchar(30) COLLATE utf8_unicode_ci,
`postalcode` varchar(30) COLLATE utf8_unicode_ci,
`logindate` varchar(14) COLLATE utf8_unicode_ci,
`registerdate` varchar(14) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(30) COLLATE utf8_unicode_ci NOT NULL UNIQUE,
`login` varchar(30) COLLATE utf8_unicode_ci,
`password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`password_salt` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`personID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `pbs_grouprequest` (
`grouprequestID` int(11) NOT NULL AUTO_INCREMENT,
`groupID` int(11) NOT NULL,
`personID` int(11) NOT NULL,
`time` varchar(14) NOT NULL,
PRIMARY KEY (`grouprequestID`),
KEY `groupID` (`groupID`),
KEY `personID` (`personID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_grouprequest`
ADD CONSTRAINT `pbs_grouprequest_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_grouprequest_ibfk_2` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_membership` (
`membershipID` int(11) NOT NULL AUTO_INCREMENT,
`groupID` int(11) NOT NULL,
`roleID` int(11) NOT NULL,
`personID` int(11) NOT NULL,
PRIMARY KEY (`membershipID`),
KEY `groupID` (`groupID`),
KEY `roleID` (`roleID`),
KEY `personID` (`personID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_membership`
ADD CONSTRAINT `pbs_membership_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_membership_ibfk_2` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_membership_ibfk_3` FOREIGN KEY (`roleID`) REFERENCES `pbs_role` (`roleID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_config` (
`configID` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`groupID` int(11) NOT NULL,
`membershipID` int(11),
`shellscript` text NOT NULL,
`created` VARCHAR(14) NOT NULL,
PRIMARY KEY (`configID`),
KEY `groupID` (`groupID`),
KEY `membershipID` (`membershipID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_config`
ADD CONSTRAINT `pbs_config_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_config_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_bootos` (
`bootosID` int(11) NOT NULL AUTO_INCREMENT,
`configID` int(11),
`groupID` int(11) NOT NULL,
`membershipID` int(11),
`title` varchar(30) NOT NULL,
`description` varchar(140),
`path_init` varchar(140) NOT NULL,
`path_kernel` varchar(140) NOT NULL,
`defaultkcl` varchar(255),
`created` VARCHAR(14) NOT NULL,
`expires` VARCHAR(14),
`public` int(11) NOT NULL,
PRIMARY KEY (`bootosID`),
KEY `configID` (`configID`),
KEY `groupID` (`groupID`),
KEY `membershipID` (`membershipID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_bootos`
ADD CONSTRAINT `pbs_bootos_ibfk_1` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE SET NULL,
ADD CONSTRAINT `pbs_bootos_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_bootos_ibfk_3` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL;
CREATE TABLE IF NOT EXISTS `pbs_bootmenu` (
`bootmenuID` int(11) NOT NULL AUTO_INCREMENT,
`membershipID` int(11),
`groupID` int(11) NOT NULL,
`title` varchar(30) NOT NULL,
`created` varchar(14) NOT NULL,
PRIMARY KEY (`bootmenuID`),
KEY `groupID` (`groupID`),
KEY `membershipID` (`membershipID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_bootmenu`
ADD CONSTRAINT `pbs_bootmenu_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
ADD CONSTRAINT `pbs_bootmenu_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_bootmenuentries` (
`bootmenuentriesID` int(11) NOT NULL AUTO_INCREMENT,
`bootosID` int(11) NOT NULL,
`bootmenuID` int(11) NOT NULL,
`title` varchar(30) NOT NULL,
`kcl` varchar(255),
`kclappend` varchar(255),
`configID` int(11),
`order` int(11) NOT NULL,
PRIMARY KEY (`bootmenuentriesID`),
KEY `bootosID` (`bootosID`),
KEY `bootmenuID` (`bootmenuID`),
KEY `configID` (`configID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_bootmenuentries`
ADD CONSTRAINT `pbs_bootmenuentries_ibfk_1` FOREIGN KEY (`bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_bootmenuentries_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_bootmenuentries_ibfk_3` FOREIGN KEY (`configID`) REFERENCES `pbs_config` (`configID`) ON DELETE SET NULL;
CREATE TABLE IF NOT EXISTS `pbs_preboot` (
`prebootID` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`membershipID` int(11),
`groupID` int(11) NOT NULL,
`path_preboot` varchar(140) NOT NULL,
PRIMARY KEY (`prebootID`),
KEY `membershipID` (`membershipID`),
KEY `groupID` (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_preboot`
ADD CONSTRAINT `pbs_preboot_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
ADD CONSTRAINT `pbs_preboot_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_bootiso` (
`bootisoID` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`membershipID` int(11),
`groupID` int(11) NOT NULL,
`prebootID` int(11) NOT NULL,
`serialnumber` varchar(30) NOT NULL UNIQUE,
`created` VARCHAR(14) NOT NULL,
`expires` VARCHAR(14),
`public` int(11) NOT NULL,
PRIMARY KEY (`bootisoID`),
KEY `membershipID` (`membershipID`),
KEY `groupID` (`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_bootiso`
ADD CONSTRAINT `pbs_bootiso_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE SET NULL,
ADD CONSTRAINT `pbs_bootiso_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_bootiso_ibfk_3` FOREIGN KEY (`prebootID`) REFERENCES `pbs_preboot` (`prebootID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_client` (
`clientID` int(11) NOT NULL AUTO_INCREMENT,
`macadress` varchar(17) NOT NULL,
`hardwarehash` varchar(32),
PRIMARY KEY (`clientID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;
ALTER TABLE `pbs_client` ADD `groupID` INT NOT NULL AFTER `clientID` ;
ALTER TABLE `pbs_client` ADD UNIQUE (`macadress`);
ALTER TABLE `pbs_client`
ADD CONSTRAINT `pbs_client_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_session` (
`sessionID` int(11) NOT NULL AUTO_INCREMENT,
`clientID` int(11),
`bootosID` int(11),
`time` varchar(14) NOT NULL,
`ip` varchar(15) NOT NULL,
`ip6` varchar(45),
PRIMARY KEY (`sessionID`),
KEY `clientID` (`clientID`),
KEY `bootosID` (`bootosID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_session` ADD `bootisoID` INT AFTER `bootosID`;
ALTER TABLE `pbs_session` ADD `alphasessionID` VARCHAR( 16 ) NOT NULL AFTER `sessionID`, ADD UNIQUE (`alphasessionID`) ;
ALTER TABLE `pbs_session` ADD `bootmenuentryID` INT AFTER `clientID` ;
ALTER TABLE `pbs_session` ADD `membershipID` INT NULL AFTER `bootisoID` ;
ALTER TABLE `pbs_session`
ADD CONSTRAINT `pbs_session_ibfk_1` FOREIGN KEY (`clientID`) REFERENCES `pbs_client` (`clientID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_session_ibfk_2` FOREIGN KEY (`bootosID`) REFERENCES `pbs_bootos` (`bootosID`) ON DELETE SET NULL,
ADD CONSTRAINT `pbs_session_ibfk_3` FOREIGN KEY (`bootisoID`) REFERENCES `pbs_bootiso` (`bootisoID`) ON DELETE SET NULL,
ADD CONSTRAINT `pbs_session_ibfk_4` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_pool` (
`poolID` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`description` varchar(140),
`location` varchar(30),
PRIMARY KEY (`poolID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_pool` ADD `groupID` INT NOT NULL AFTER `poolID`;
ALTER TABLE `pbs_pool`
ADD CONSTRAINT `pbs_pool_ibfk_1` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_poolentries` (
`poolID` int(11) NOT NULL,
`clientID` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_poolentries` ADD `poolentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `pbs_poolentries`
ADD CONSTRAINT `pbs_poolentries_ibfk_1` FOREIGN KEY (`poolID`) REFERENCES `pbs_pool` (`poolID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_poolentries_ibfk_2` FOREIGN KEY (`clientID`) REFERENCES `pbs_client` (`clientID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_filter` (
`filterID` int(11) NOT NULL AUTO_INCREMENT,
`membershipID` int(11),
`groupID` int(11) NOT NULL,
`bootmenuID` int(11) NOT NULL,
`title` varchar(30) NOT NULL,
`description` varchar(140),
`created` varchar(14) NOT NULL,
`priority` int(11) NOT NULL,
PRIMARY KEY (`filterID`),
KEY `membershipID` (`membershipID`),
KEY `groupID` (`groupID`),
KEY `bootmenuID` (`bootmenuID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_filter`
ADD CONSTRAINT `pbs_filter_ibfk_1` FOREIGN KEY (`membershipID`) REFERENCES `pbs_membership` (`membershipID`),
ADD CONSTRAINT `pbs_filter_ibfk_2` FOREIGN KEY (`groupID`) REFERENCES `pbs_group` (`groupID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_filter_ibfk_3` FOREIGN KEY (`bootmenuID`) REFERENCES `pbs_bootmenu` (`bootmenuID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_filtertype` (
`filtertypeID` int(11) NOT NULL AUTO_INCREMENT,
`filtertypename` varchar(30) NOT NULL,
PRIMARY KEY (`filtertypeID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `pbs_filterentries` (
`filterID` int(11) NOT NULL,
`filtertypeID` int(11) NOT NULL,
`filtervalue` varchar(140) NOT NULL,
`filtervalue2` varchar(140) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;
ALTER TABLE `pbs_filterentries` CHANGE `filtervalue2` `filtervalue2` VARCHAR( 140 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL;
ALTER TABLE `pbs_filterentries` ADD `filterentriesID` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE `pbs_filterentries`
ADD CONSTRAINT `pbs_filterentries_ibfk_1` FOREIGN KEY (`filterID`) REFERENCES `pbs_filter` (`filterID`) ON DELETE CASCADE,
ADD CONSTRAINT `pbs_filterentries_ibfk_2` FOREIGN KEY (`filtertypeID`) REFERENCES `pbs_filtertype` (`filtertypeID`) ON DELETE CASCADE;
CREATE TABLE IF NOT EXISTS `pbs_passwordrecovery` (
`personID` int(11) NOT NULL,
`recoveryID` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`personID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
ALTER TABLE `pbs_passwordrecovery`
ADD CONSTRAINT `pbs_passwordrecovery_ibfk_1` FOREIGN KEY (`personID`) REFERENCES `pbs_person` (`personID`) ON DELETE CASCADE;
-- Insert Filtertypes
INSERT INTO `pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES
(1, 'IP'),
(2, 'MAC'),
(3, 'PoolID'),
(4, 'BootIso'),
(5, 'Membership'),
(6, 'Group'),
(7, 'Time'),
(8, 'Client'),
(9, 'Hardwarehash'),
(10, 'Weekday'),
(11, 'Date');
-- Insert rightcategorys
INSERT INTO `pbs_rightcategory` (`rightcategoryID`, `title`) VALUES
(1, 'Person'),
(2, 'Group'),
(3, 'Role'),
(4, 'BootMedia'),
(5, 'Preboot'),
(6, 'Config'),
(7, 'BootOs'),
(8, 'BootMenu'),
(9, 'Client'),
(10, 'Pool'),
(11, 'Filter');
-- Insert rights
INSERT INTO `pbs`.`pbs_right` (`rightID`, `rightcategoryID`, `shortcut`, `title`, `description`) VALUES
-- Person
-- Eigene Personendetails ändern
(NULL, '1', 'peod', 'Edit own profiledetails', NULL),
-- Eigene Personendetails anzeigen
(NULL, '1', 'psod', 'Show own profiledetails', NULL),
-- Eigene Identität vom System löschen
(NULL, '1', 'pdo', 'Delete own account', NULL),
-- Person löschen
(NULL, '1', 'pd', 'Delete account of other', NULL),
-- Personendetails anderer anzeigen
(NULL, '1', 'psood', 'Show other profiledetails', NULL),
-- Personendetails anderer ändern
(NULL, '1', 'peoa', 'Edit account from other', NULL),
-- Person sperren
(NULL, '1', 'psa', 'Suspend account', NULL),
-- Gruppen
-- Gruppenübersicht anzeigen
(NULL, '2', 'gso', 'Show overview of group', NULL),
-- Gruppendetails der eigenen Gruppe anzeigen
(NULL, '2', 'gsdo', 'Show details of own group', NULL),
-- Gruppendetails anderer Gruppen anzeigen
(NULL, '2', 'gsdog', 'Show details of other group', NULL),
-- Mitglieder einer Gruppe Anzeigen
(NULL, '2', 'gsmg', 'Show members of group', NULL),
-- Gruppe erstellen
(NULL, '2', 'gc', 'Create group', NULL),
-- Gruppe löschen
(NULL, '2', 'gd', 'Delete group', NULL),
-- Gruppe mit allen Untergruppen löschen
(NULL, '2', 'gdlwc', 'Delete group with all child groups', NULL),
-- Gruppenanfragen stellen
(NULL, '2', 'grm', 'Request membership', NULL),
-- Gruppenanfragen akzeptieren
(NULL, '2', 'gam', 'Accect membership request', NULL),
-- Gruppenanfragen ablehnen
(NULL, '2', 'gdm', 'Decline membership request', NULL),
-- Mitgliedschaften aus eigenen Gruppen entfernen
(NULL, '2', 'gdmo', 'Delete membership in own group', NULL),
-- Mitgliedschaften aus anderen Gruppen entfernen
(NULL, '2', 'gdmog', 'Delete membership in other group', NULL),
-- Gruppenmitgliedschaft sperren
(NULL, '2', 'gsm', 'Suspend membership', NULL),
-- Rollen
-- Neue Rollen anlegen
(NULL, '3', 'ra', 'Add role', NULL),
-- Rollen anzeigen
(NULL, '3', 'rdd', 'Display details of role', NULL),
-- Rollen löschen
(NULL, '3', 'rd', 'Delete role', NULL),
-- Rollen von Personen ändern
(NULL, '3', 'rcr', 'Change role of membership', NULL),
-- Recht zu Rolle hinzufügen
(NULL, '3', 'rar', 'Add right to role', NULL),
-- Recht von Rolle löschen
(NULL, '3', 'rrr', 'Remove right of role', NULL),
-- Rolle vererbbar machen
(NULL, '3', 'rir', 'Inherit role', NULL),
-- BootMedien
-- BootMedien Admin-Übersicht anzeigen
(NULL, '4', 'bai', 'Show admin interface of BootMedia', NULL),
-- BootMedien User-Übersicht anzeigen
(NULL, '4', 'bui', 'Show user interface of BootMedia', NULL),
-- BootMedien anlegen
(NULL, '4', 'bc', 'Create new BootMedia', NULL),
-- BootMedien editieren
(NULL, '4', 'be', 'Edit BootMedia', NULL),
-- BootMedien löschen
(NULL, '4', 'bd', 'Delete BootMedia', NULL),
-- BootMedien herunterladen
(NULL, '4', 'bdld', 'Download BootMedia', NULL),
-- BootMedien-Metadata (Description, Title) ändern
(NULL, '4', 'bem', 'Edit metadata (Description, Title) of a BootMedia', NULL),
-- Preboot
-- Preboot übersicht anzeigen
(NULL, '5', 'pro', 'Show overview of preboots', NULL),
-- Preboot anlegen
(NULL, '5', 'prc', 'Create preboot', NULL),
-- Preboot editieren
(NULL, '5', 'pre', 'Edit preboot', NULL),
-- Preboot löschen
(NULL, '5', 'prd', 'Delete preboot', NULL),
-- Preboot updaten
(NULL, '5', 'pru', 'Update preboot', NULL),
-- Preboot-Metadata (Description, Title) ändern
(NULL, '5', 'prem', 'Edit metadata (Description, Title) of a preboot', NULL),
-- Config
-- Config Admin-Übersicht anzeigen
(NULL, '6', 'csai', 'Show admin overview of config', NULL),
-- Config User-Übersicht anzeigen
(NULL, '6', 'csui', 'Show user overview of config', NULL),
-- Config anlegen
(NULL, '6', 'cc', 'Create config', NULL),
-- Config editieren
(NULL, '6', 'ce', 'Edit config', NULL),
-- Config löschen
(NULL, '6', 'cd', 'Delete config', NULL),
-- Config updaten
(NULL, '6', 'cu', 'Update config', NULL),
-- Config-Metadata (Description, Title) ändern
(NULL, '6', 'cem', 'Edit metadata (Description, Title) of config', NULL),
-- BootOs
-- BootOs anlegen
(NULL, '7', 'boc', 'Create BootOs', NULL),
-- BootOS Admin-Übersicht anzeigen
(NULL, '7', 'boai', 'Show admin interface of BootOs', NULL),
-- BootOs User-Übersicht anzeigen
(NULL, '7', 'boui', 'Show user interface of BootOs', NULL),
-- BootOs editieren
(NULL, '7', 'boe', 'Edit BootOs', NULL),
-- BootOs löschen
(NULL, '7', 'bod', 'Delete BootOs', NULL),
-- BootOs updaten
(NULL, '7', 'bou', 'Update BootOs', NULL),
-- BootOs-Metadata (Description, Title) ändern
(NULL, '7', 'boem', 'Edit metadata (Description, Title) of config', NULL),
-- BootMenu
-- BootMenu Admin-Übersicht anzeigen
(NULL, '8', 'booai', 'Show admin interface of BootMenu', NULL),
-- User-BootMenu anzeigen
(NULL, '8', 'booui', 'Show user interface of BootMenu', NULL),
-- BootMenu anlegen
(NULL, '8', 'booc', 'Create BootMenu', NULL),
-- BootMenu löschen
(NULL, '8', 'bood', 'Delete BootMenu', NULL),
-- Bootmenu editieren
(NULL, '8', 'booe', 'Edit BootMenu', NULL),
-- BootmenuEintrag löschen
(NULL, '8', 'boode', 'Delete entry of BootMenu', NULL),
-- BootmenuEintrag hinzufügen
(NULL, '8', 'booae', 'Add entry to a BootMenu', NULL),
-- BootmenuEintrag editieren
(NULL, '8', 'booee', 'Edit an entry of a BootMenu', NULL),
-- BootmenuEintrag-Metadata (Description, Title) ändern
(NULL, '8', 'booeem', 'Edit metadata (Description, Title) of an entry of a BootMenu', NULL),
-- Client
-- Client Übersicht ansehen
(NULL, '9', 'clo', 'Show overview of Clients', NULL),
-- Clients manuell anlegen
(NULL, '9', 'cla', 'Add new Clients', NULL),
-- Clients bearbeiten
(NULL, '9', 'cle', 'Edit Clients', NULL),
-- Clients löschen
(NULL, '9', 'cld', 'Delete Clients', NULL),
-- Pool
-- Pool Übersicht anzeigen
(NULL, '10', 'poo', 'Show overview of Pool', NULL),
-- Pools anlegen
(NULL, '10', 'poc', 'Create new Pool', NULL),
-- Pools bearbeiten
(NULL, '10', 'poe', 'Edit Pool', NULL),
-- Pools löschen
(NULL, '10', 'pod', 'Delete Pool', NULL),
-- Clients aus Pool entfernen
(NULL, '10', 'pouc', 'Unlink client to pool', NULL),
-- Clients zu Pool hinzufügen
(NULL, '10', 'polc', 'Link client to pool', NULL),
-- Übersicht an nicht zugewiesene Clients anzeigen
(NULL, '10', 'posuc', 'Show unlinked Clients', NULL),
-- Filter
-- Filter Übersicht ansehen
(NULL, '11', 'fo', 'Show overview of Pool', NULL),
-- Filter anlegen
(NULL, '11', 'fa', 'Create new Filter', NULL),
-- Filter bearbeiten
(NULL, '11', 'fe', 'Edit Filter', NULL),
-- Filterpriorität ändern
(NULL, '11', 'fefp', 'Edit Filterpriority', NULL),
-- Filter löschen
(NULL, '11', 'fd', 'Delete Filter', NULL),
-- FilterEinträge hinzufügen
(NULL, '11', 'ffa', 'Add additional Filterentry to a Filter', NULL),
-- FilterEinträge editieren
(NULL, '11', 'ffe', 'Edit Filterentry of a Filter', NULL),
-- FilterEinträge löschen
(NULL, '11', 'ffd', 'Delete Filterentry of a Filter', NULL);