diff options
author | Simon | 2011-04-11 12:18:10 +0200 |
---|---|---|
committer | Simon | 2011-04-11 12:18:10 +0200 |
commit | 4e088739f1a9761bd46b04ce1fb3f62313f78140 (patch) | |
tree | beb652a0ef5669a30f4a196bc019a41fac6cc57a /pbs.sql | |
parent | Suche in Bootmenu gefixxt (diff) | |
download | pbs2-4e088739f1a9761bd46b04ce1fb3f62313f78140.tar.gz pbs2-4e088739f1a9761bd46b04ce1fb3f62313f78140.tar.xz pbs2-4e088739f1a9761bd46b04ce1fb3f62313f78140.zip |
kleine anpassungen
Diffstat (limited to 'pbs.sql')
-rw-r--r-- | pbs.sql | 8 |
1 files changed, 4 insertions, 4 deletions
@@ -19,7 +19,7 @@ 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, + `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL, `description` varchar(300) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`rightID`), KEY `rightcategoryID` (`rightcategoryID`) @@ -159,7 +159,7 @@ CREATE TABLE IF NOT EXISTS `pbs_bootmenu` ( `bootmenuID` int(11) NOT NULL AUTO_INCREMENT, `membershipID` int(11), `groupID` int(11), - `title` varchar(30) NOT NULL, + `title` varchar(50) NOT NULL, `created` varchar(14) NOT NULL, `defaultbootmenu` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`bootmenuID`), @@ -286,7 +286,7 @@ ALTER TABLE `pbs_poolentries` CREATE TABLE IF NOT EXISTS `pbs_filter` ( `filterID` int(11) NOT NULL AUTO_INCREMENT, `membershipID` int(11), - `groupID` int(11) NOT NULL, + `groupID` int(11), `bootmenuID` int(11) NOT NULL, `title` varchar(30) NOT NULL, `description` varchar(140), @@ -578,4 +578,4 @@ INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES (1, 'OpenSLX', 'This is the OpenSLX-Group'); INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (1, '1', 'SuperAdmin', 'The SuperAdmin', 0); INSERT INTO `pbs`.`pbs_rightroles` (`roleID`, `rightID`) VALUES -(1, 1),(1, 2),(1, 3),(1, 4),(1, 5),(1, 6),(1, 7),(1, 8),(1, 9),(1, 10),(1, 11),(1, 12),(1, 13),(1, 14),(1, 15),(1, 16),(1, 17),(1, 18),(1, 19),(1, 20),(1, 21),(1, 22),(1, 23),(1, 24),(1, 25),(1, 26),(1, 27),(1, 28),(1, 29),(1, 30),(1, 31),(1, 32),(1, 33),(1, 34),(1, 35),(1, 36),(1, 37),(1, 38),(1, 39),(1, 40),(1, 41),(1, 42),(1, 43),(1, 44),(1, 45),(1, 46),(1, 47),(1, 48),(1, 49),(1, 50),(1, 51),(1, 52),(1, 53),(1, 54),(1, 55),(1, 56),(1, 57),(1, 58),(1, 59),(1, 60),(1, 61),(1, 62),(1, 63),(1, 64),(1, 65),(1, 66),(1, 67),(1, 68),(1, 69),(1, 70),(1, 71),(1, 72),(1, 73),(1, 74),(1, 75),(1, 76),(1, 77),(1, 78),(1, 79),(1, 80),(1, 81),(1, 82),(1, 83),(1, 84),(1, 85),(1, 86); +(1, 1),(1, 2),(1, 3),(1, 4),(1, 5),(1, 6),(1, 7),(1, 8),(1, 9),(1, 10),(1, 11),(1, 12),(1, 13),(1, 14),(1, 15),(1, 16),(1, 17),(1, 18),(1, 19),(1, 20),(1, 21),(1, 22),(1, 23),(1, 24),(1, 25),(1, 26),(1, 27),(1, 28),(1, 29),(1, 30),(1, 31),(1, 32),(1, 33),(1, 34),(1, 35),(1, 36),(1, 37),(1, 38),(1, 39),(1, 40),(1, 41),(1, 42),(1, 43),(1, 44),(1, 45),(1, 46),(1, 47),(1, 48),(1, 49),(1, 50),(1, 51),(1, 52),(1, 53),(1, 54),(1, 55),(1, 56),(1, 57),(1, 58),(1, 59),(1, 60),(1, 61),(1, 62),(1, 63),(1, 64),(1, 65),(1, 66),(1, 67),(1, 68),(1, 69),(1, 70),(1, 71),(1, 72),(1, 73),(1, 74),(1, 75),(1, 76),(1, 77),(1, 78),(1, 79),(1, 80),(1, 81),(1, 82),(1, 83),(1, 84),(1, 85),(1, 86),(1, 87),(1, 88),(1, 89),(1, 90),(1, 91),(1, 92),(1, 93); |