From ad2ce2903cebc0e8d1e440aa8c878aab886c6972 Mon Sep 17 00:00:00 2001 From: Simon Date: Tue, 29 Mar 2011 11:13:58 +0200 Subject: rechte hinzugefügt --- mysqlGraph.png | Bin 282021 -> 279960 bytes pbs-newdata.sql | 10 --- pbs.sql | 207 +++++++++++++++++++++++++++++++++++++++++++++++++++++++- 3 files changed, 205 insertions(+), 12 deletions(-) diff --git a/mysqlGraph.png b/mysqlGraph.png index 81468b8..f24c35b 100644 Binary files a/mysqlGraph.png and b/mysqlGraph.png differ diff --git a/pbs-newdata.sql b/pbs-newdata.sql index a85fdf2..01b1fcc 100644 --- a/pbs-newdata.sql +++ b/pbs-newdata.sql @@ -41,16 +41,6 @@ INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inhe INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (3, '2', 'Role 1-Group2', NULL, 0); INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (4, '2', 'Role 2-Group2', NULL, 0); --- Adding right -INSERT INTO `pbs_rightcategory` (`rightcategoryID`, `title`) VALUES -(1, 'rightcategory 1'), -(2, 'rightcategory 2'), -(3, 'rightcategory 3'); - -INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `title`, `description`) VALUES (1, 1, 'Recht 1', NULL); -INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `title`, `description`) VALUES (2, 1, 'Recht 2', NULL); -INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `title`, `description`) VALUES (3, 2, 'Recht 3', NULL); -INSERT INTO `pbs_right` (`rightID`, `rightcategoryID`, `title`, `description`) VALUES (4, 3, 'Recht 4', NULL); INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES (1, 1), diff --git a/pbs.sql b/pbs.sql index b505444..251e84a 100644 --- a/pbs.sql +++ b/pbs.sql @@ -18,8 +18,8 @@ CREATE TABLE IF NOT EXISTS `pbs_rightcategory` ( CREATE TABLE IF NOT EXISTS `pbs_right` ( `rightID` int(11) NOT NULL AUTO_INCREMENT, `rightcategoryID` int(11) NOT NULL, - `title` varchar(30) COLLATE utf8_unicode_ci NOT NULL, - `description` varchar(140) COLLATE utf8_unicode_ci DEFAULT NULL, + `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 ; @@ -347,5 +347,208 @@ INSERT INTO `pbs_filtertype` (`filtertypeID`, `filtertypename`) VALUES (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`, `title`, `description`) VALUES + -- Person + -- Eigene Personendetails ändern +(NULL, '1', 'Edit own profiledetails', NULL), + -- Eigene Personendetails anzeigen +(NULL, '1', 'Show own profiledetails', NULL), + -- Eigene Identität vom System löschen +(NULL, '1', 'Delete own account', NULL), + -- Person löschen +(NULL, '1', 'Delete account of other', NULL), + -- Personendetails anderer anzeigen +(NULL, '1', 'Show other profiledetails', NULL), + -- Personendetails anderer ändern +(NULL, '1', 'Edit account from other', NULL), + -- Person sperren +(NULL, '1', 'Suspend account', NULL), + + + -- Gruppen + -- Gruppenübersicht anzeigen +(NULL, '2', 'Show overview of group', NULL), + -- Gruppendetails der eigenen Gruppe anzeigen +(NULL, '2', 'Show details of own group', NULL), + -- Gruppendetails anderer Gruppen anzeigen +(NULL, '2', 'Show details of other group', NULL), + -- Mitglieder einer Gruppe Anzeigen +(NULL, '2', 'Show members of group', NULL), + -- Gruppe erstellen +(NULL, '2', 'Create group', NULL), + -- Gruppe löschen +(NULL, '2', 'Delete group', NULL), + -- Gruppe mit allen Untergruppen löschen +(NULL, '2', 'Delete group with all child groups', NULL), + -- Gruppenanfragen stellen +(NULL, '2', 'Request membership', NULL), + -- Gruppenanfragen akzeptieren +(NULL, '2', 'Accect membership request', NULL), + -- Gruppenanfragen ablehnen +(NULL, '2', 'Decline membership request', NULL), + -- Mitgliedschaften aus eigenen Gruppen entfernen +(NULL, '2', 'Delete membership in own group', NULL), + -- Mitgliedschaften aus anderen Gruppen entfernen +(NULL, '2', 'Delete membership in other group', NULL), + -- Gruppenmitgliedschaft sperren +(NULL, '2', 'Suspend membership', NULL), + + -- Rollen + -- Neue Rollen anlegen +(NULL, '3', 'Add role', NULL), + -- Rollen anzeigen +(NULL, '3', 'Display details of role', NULL), + -- Rollen löschen +(NULL, '3', 'Delete role', NULL), + -- Rollen von Personen ändern +(NULL, '3', 'Change role of membership', NULL), + -- Recht zu Rolle hinzufügen +(NULL, '3', 'Add right to role', NULL), + -- Recht von Rolle löschen +(NULL, '3', 'Remove right of role', NULL), + -- Rolle vererbbar machen +(NULL, '3', 'Inherit role', NULL), + + -- BootMedien + -- BootMedien Admin-Übersicht anzeigen +(NULL, '4', 'Show admin interface of BootMedia', NULL), + -- BootMedien User-Übersicht anzeigen +(NULL, '4', 'Show user interface of BootMedia', NULL), + -- BootMedien anlegen +(NULL, '4', 'Create new BootMedia', NULL), + -- BootMedien editieren +(NULL, '4', 'Edit BootMedia', NULL), + -- BootMedien löschen +(NULL, '4', 'Delete BootMedia', NULL), + -- BootMedien herunterladen +(NULL, '4', 'Download BootMedia', NULL), + -- BootMedien-Metadata (Description, Title) ändern +(NULL, '4', 'Edit metadata (Description, Title) of a BootMedia', NULL), + + -- Preboot + -- Preboot übersicht anzeigen +(NULL, '5', 'Show overview of preboots', NULL), + -- Preboot anlegen +(NULL, '5', 'Create preboot', NULL), + -- Preboot editieren +(NULL, '5', 'Edit preboot', NULL), + -- Preboot löschen +(NULL, '5', 'Delete preboot', NULL), + -- Preboot updaten +(NULL, '5', 'Update preboot', NULL), + -- Preboot-Metadata (Description, Title) ändern +(NULL, '5', 'Edit metadata (Description, Title) of a preboot', NULL), + + -- Config + -- Config Admin-Übersicht anzeigen +(NULL, '6', 'Show admin overview of config', NULL), + -- Config User-Übersicht anzeigen +(NULL, '6', 'Show user overview of config', NULL), + -- Config anlegen +(NULL, '6', 'Create config', NULL), + -- Config editieren +(NULL, '6', 'Edit config', NULL), + -- Config löschen +(NULL, '6', 'Delete config', NULL), + -- Config updaten +(NULL, '6', 'Update config', NULL), + -- Config-Metadata (Description, Title) ändern +(NULL, '6', 'Edit metadata (Description, Title) of config', NULL), + + -- BootOs + -- BootOs anlegen +(NULL, '7', 'Create BootOs', NULL), + -- BootOS Admin-Übersicht anzeigen +(NULL, '7', 'Show admin interface of BootOs', NULL), + -- BootOs User-Übersicht anzeigen +(NULL, '7', 'Show user interface of BootOs', NULL), + -- BootOs editieren +(NULL, '7', 'Edit BootOs', NULL), + -- BootOs löschen +(NULL, '7', 'Delete BootOs', NULL), + -- BootOs updaten +(NULL, '7', 'Update BootOs', NULL), + -- BootOs-Metadata (Description, Title) ändern +(NULL, '7', 'Edit metadata (Description, Title) of config', NULL), + + -- BootMenu + -- BootMenu Admin-Übersicht anzeigen +(NULL, '8', 'Show admin interface of BootMenu', NULL), + -- User-BootMenu anzeigen +(NULL, '8', 'Show user interface of BootMenu', NULL), + -- BootMenu anlegen +(NULL, '8', 'Create BootMenu', NULL), + -- BootMenu löschen +(NULL, '8', 'Delete BootMenu', NULL), + -- Bootmenu editieren +(NULL, '8', 'Edit BootMenu', NULL), + -- BootmenuEintrag löschen +(NULL, '8', 'Delete entry of BootMenu', NULL), + -- BootmenuEintrag hinzufügen +(NULL, '8', 'Add entry to a BootMenu', NULL), + -- BootmenuEintrag editieren +(NULL, '8', 'Edit an entry of a BootMenu', NULL), + -- BootmenuEintrag-Metadata (Description, Title) ändern +(NULL, '8', 'Edit metadata (Description, Title) of an entry of a BootMenu', NULL), + + -- Client + -- Client Übersicht ansehen +(NULL, '9', 'Show overview of Clients', NULL), + -- Clients manuell anlegen +(NULL, '9', 'Add new Clients', NULL), + -- Clients bearbeiten +(NULL, '9', 'Edit Clients', NULL), + -- Clients löschen +(NULL, '9', 'Delete Clients', NULL), + + -- Pool + -- Pool Übersicht anzeigen +(NULL, '10', 'Show overview of Pool', NULL), + -- Pools anlegen +(NULL, '10', 'Create new Pool', NULL), + -- Pools bearbeiten +(NULL, '10', 'Edit Pool', NULL), + -- Pools löschen +(NULL, '10', 'Delete Pool', NULL), + -- Clients aus Pool entfernen +(NULL, '10', 'Unlink client to pool', NULL), + -- Clients zu Pool hinzufügen +(NULL, '10', 'Link client to pool', NULL), + -- Übersicht an nicht zugewiesene Clients anzeigen +(NULL, '10', 'Show unlinked Clients', NULL), + + -- Filter + -- Filter Übersicht ansehen +(NULL, '11', 'Show overview of Pool', NULL), + -- Filter anlegen +(NULL, '11', 'Create new Filter', NULL), + -- Filter bearbeiten +(NULL, '11', 'Edit Filter', NULL), + -- Filterpriorität ändern +(NULL, '11', 'Edit Filterpriority', NULL), + -- Filter löschen +(NULL, '11', 'Delete Filter', NULL), + -- FilterEinträge hinzufügen +(NULL, '11', 'Add additional Filterentry to a Filter', NULL), + -- FilterEinträge editieren +(NULL, '11', 'Edit Filterentry of a Filter', NULL), + -- FilterEinträge löschen +(NULL, '11', 'Delete Filterentry of a Filter', NULL); + -- cgit v1.2.3-55-g7522