summaryrefslogtreecommitdiffstats
path: root/pbs-newdata.sql
diff options
context:
space:
mode:
authorSimon2011-03-21 12:48:44 +0100
committerSimon2011-03-21 12:48:44 +0100
commite83e5f1768562d142e638980dc0c8d7fd4d88104 (patch)
treee2de8972e8e3091753f76d1f2ce0130ebd767df7 /pbs-newdata.sql
parentMerge branch 'master' of openslx.org:lsfks/master-teamprojekt/pbs2 (diff)
downloadpbs2-e83e5f1768562d142e638980dc0c8d7fd4d88104.tar.gz
pbs2-e83e5f1768562d142e638980dc0c8d7fd4d88104.tar.xz
pbs2-e83e5f1768562d142e638980dc0c8d7fd4d88104.zip
FilterEntries-Formular steht
Diffstat (limited to 'pbs-newdata.sql')
-rw-r--r--pbs-newdata.sql56
1 files changed, 39 insertions, 17 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql
index d3dd6ab..8e6fe11 100644
--- a/pbs-newdata.sql
+++ b/pbs-newdata.sql
@@ -13,9 +13,28 @@ INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `h
-- Adding group
INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES
-(1, 'Group 1', 'Our Testgroup'),
-(2, 'Group 2', 'The Second Testgroup'),
-(3, 'Group 3', 'Wohoo');
+(1, 'Group 1', 'First Group'),
+(2, 'Group 2', 'Second Group'),
+(3, 'Group 3', 'Third Group'),
+(4, 'Group 4', 'Fourth Group'),
+(5, 'Group 5', 'Fifth Group'),
+(6, 'Group 6', 'Sixth Group'),
+(7, 'Group 7', 'Seventh Group'),
+(8, 'Group 8', 'Eight Group'),
+(9, 'Group 9', 'Nineth Group'),
+(10, 'Group 10', 'Tenth Group');
+
+INSERT INTO `pbs`.`pbs_groupgroups` (`parentID`, `groupID`) VALUES
+(1, 2),
+(1, 3),
+(2, 4),
+(2, 5),
+(1, 8),
+(3, 6),
+(3, 7),
+(3, 9),
+(3, 10);
+
-- Adding role
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (1, '1', 'Role 1-Group1', NULL);
@@ -66,18 +85,18 @@ INSERT INTO `pbs_bootos` (`bootosID`, `configID`, `groupID`, `membershipID`, `ti
(9, 1, 1, 1, 'BootOs 9', 'Description 9', 'initpath 9', 'kernelpath 9', 'default kcl 9', '1299693782', '2012-03-09', 0),
(10, 1, 1, 1, 'BootOs 10', 'Description 10', 'initpath 10', 'kernelpath 10', 'default kcl 10', '1299693782', '2012-03-09', 0);
--- Adding bootiso
-INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `prebootID`, `serialnumber`, `created`, `expires`, `public`) VALUES
-(1, 'BootIso 1', 1, 1, '1', 123456789, '123', '2012-03-09', 0),
-(2, 'BootIso 2', 1, 1, '2', 2147483647, '456', '2012-03-09', 0),
-(3, 'BootIso 3', 1, 1, '3', 2147483647, '789', '2012-03-09', 0);
-
-- Adding preboot
INSERT INTO `pbs_preboot` (`prebootID`, `title`, `membershipID`, `groupID`, `path_preboot`) VALUES
(1, 'Preboot 1', 1, 1, 'path 1'),
(2, 'Preboot 2', 1, 1, 'path 1'),
(3, 'Preboot 3', 1, 1, 'path 1');
+-- Adding bootiso
+INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `prebootID`, `serialnumber`, `created`, `expires`, `public`) VALUES
+(1, 'BootIso 1', 1, 1, '1', 123456789, '123', '2012-03-09', 0),
+(2, 'BootIso 2', 1, 1, '2', 2147483647, '456', '2012-03-09', 0),
+(3, 'BootIso 3', 1, 1, '3', 2147483647, '789', '2012-03-09', 0);
+
-- Adding Pools
INSERT INTO `pbs_pool` (`poolID`, `groupID`, `title`, `description`, `location`) VALUES
(1, 1, 'Pool 1', 'Description 1', 'Keller'),
@@ -127,14 +146,17 @@ 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', '1299697337', 10),
-(2, 1, 1, 5, 'Filter 2', 'Ausserhalb der Uni', '1299697073', 20),
-(3, 1, 1, 4, 'Filter 3', 'Desc3', '1299697277', 5);
+(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);
-- Adding Filterentries
INSERT INTO `pbs_filterentries` (`filterentriesID`, `filterID`, `filtertypeID`, `filtervalue`, `filtervalue2`) VALUES
-(1, 1, 7, '08:00', '18:00'),
-(2, 2, 1, '001.001.001.001', '132.229.255.255'),
-(3, 2, 1, '132.231.001.001', '255.255.255.255'),
-(4, 1, 1, '132.230.001.001', '132.230.255.255'),
-(5, 3, 3, '1', '');
+(1, 1, 6, '1', NULL),
+(2, 1, 1, '132.230.001.001', '132.230.255.255'),
+(3, 2, 6, '1', NULL),
+(4, 2, 1, '000.000.000.000', '132.229.255.255'),
+(5, 2, 1, '132.231.001.001', '255.255.255.255'),
+(6, 3, 6, '1', NULL),
+(7, 3, 7, '08:00', '16:00'),
+(8, 3, 10, '1', '5');