summaryrefslogtreecommitdiffstats
path: root/pbs-newdata.sql
diff options
context:
space:
mode:
authorSimon2011-03-30 16:14:22 +0200
committerSimon2011-03-30 16:14:22 +0200
commit6c6094d82c3d8a682c8c9a0c6cb157fadcd2eba7 (patch)
treef30e090eb73097ab76d0d755910b5211dd7b9a3e /pbs-newdata.sql
parentMerge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff)
downloadpbs2-6c6094d82c3d8a682c8c9a0c6cb157fadcd2eba7.tar.gz
pbs2-6c6094d82c3d8a682c8c9a0c6cb157fadcd2eba7.tar.xz
pbs2-6c6094d82c3d8a682c8c9a0c6cb157fadcd2eba7.zip
Filter können auf höher gelegene BootMenus verweisen
Diffstat (limited to 'pbs-newdata.sql')
-rw-r--r--pbs-newdata.sql17
1 files changed, 9 insertions, 8 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql
index 13061c9..c32ee1f 100644
--- a/pbs-newdata.sql
+++ b/pbs-newdata.sql
@@ -68,6 +68,7 @@ INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`) VAL
(11, 2, 'af:54:07:87:63:44', '98413218152196816519841365419816'),
(12, 2, '87:21:74:52:96:20', '98741298132516132169813516981616'),
(13, 2, '14:47:58:47:36:48', '32168132068132068513216053516513');
+(14, 1, '64:46:85:A1:89:23', '9684216842068420616841asd6516984');
-- Adding config
INSERT INTO `pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `shellscript`, `created`) VALUES
@@ -111,11 +112,11 @@ INSERT INTO `pbs_pool` (`poolID`, `groupID`, `title`, `description`, `location`)
-- Adding Bootmenus
INSERT INTO `pbs_bootmenu` (`bootmenuID`, `membershipID`, `groupID`, `title`, `created`) VALUES
-(1, 1, 1, 'Bootmenu 1', '1299694422'),
-(2, 1, 1, 'Bootmenu 2', '1299694433'),
-(3, 1, 1, 'Bootmenu 3', '1299694441'),
-(4, 1, 1, 'Bootmenu 4', '1299694454'),
-(5, 1, 1, 'Bootmenu 5', '1299694461');
+(1, NULL, 1, 'Bootmenu 1', '1299694422'),
+(2, NULL, 1, 'Bootmenu 2', '1299694433'),
+(3, NULL, 1, 'Bootmenu 3', '1299694441'),
+(4, NULL, 1, 'Bootmenu 4', '1299694454'),
+(5, NULL, 1, 'Bootmenu 5', '1299694461');
-- Adding BootOs to BootMenus
INSERT INTO `pbs_bootmenuentries` (`bootmenuentriesID`, `bootosID`, `bootmenuID`, `title`, `kcl`, `kclappend`, `configID`, `order`) VALUES
@@ -151,9 +152,9 @@ INSERT INTO `pbs_session` (`sessionID`, `alphasessionID`,`clientID`, `bootmenuen
-- Adding Filter
INSERT INTO `pbs_filter` (`filterID`, `membershipID`, `groupID`, `bootmenuID`, `title`, `description`, `created`, `priority`) VALUES
-(1, 1, 1, 1, 'Filter 1', 'Innerhalb der Uni', '', 1),
-(2, 1, 1, 2, 'Filter 2', 'Ausserhalb der Uni', '', 1),
-(3, 1, 1, 3, 'Filter 3', 'Montags-Freitag \r\nvon 8 bis 16 Uhr \r\nInnerhalb der Uni', '', 10);
+(1, NULL, 1, 1, 'Filter 1', 'Innerhalb der Uni', '', 1),
+(2, NULL, 1, 2, 'Filter 2', 'Ausserhalb der Uni', '', 1),
+(3, NULL, 1, 3, 'Filter 3', 'Montags-Freitag \r\nvon 8 bis 16 Uhr \r\nInnerhalb der Uni', '', 10);
-- Adding Filterentries
INSERT INTO `pbs_filterentries` (`filterentriesID`, `filterID`, `filtertypeID`, `filtervalue`, `filtervalue2`) VALUES