USE pbs;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- Adding person test//test
INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES
(1, 'Herr', 'Test 1', 'Test 1', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a');
-- Adding person test2//test
INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES
(2, 'Herr', 'Test 2', 'Test 2', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test2', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a');
-- Adding person test3//test
INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES
(3, 'Herr', 'Test 3', 'Test 3', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test3', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a');

-- Adding group
INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES 
(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);
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (2, '1', 'Role 2-Group1', NULL);
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (3, '2', 'Role 1-Group2', NULL);
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (4, '2', 'Role 2-Group2', NULL);

-- Adding right
INSERT INTO `pbs_right` (`rightID`, `title`, `description`) VALUES (1, 'Recht 1', NULL);
INSERT INTO `pbs_right` (`rightID`, `title`, `description`) VALUES (2, 'Recht 2', NULL);
INSERT INTO `pbs_right` (`rightID`, `title`, `description`) VALUES (3, 'Recht 3', NULL);
INSERT INTO `pbs_right` (`rightID`, `title`, `description`) VALUES (4, 'Recht 4', NULL);

INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES
(1, 1),
(1, 2),
(1, 3),
(2, 4),
(2, 3),
(3, 1),
(4, 2);

-- Adding memberships
INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (1, '1', '1', '1');
INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (2, '1', '2', '2');
INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (3, '2', '3', '1');
INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (4, '2', '4', '3');

-- Adding clients
INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`) VALUES
(1, 1, '00:00:00:00:00:10', 'ea9b82d9de911bc2d3cd23f53a6cab48'),
(2, 1, '00:00:00:00:10:00', '1e2b1599710fbbef0dc789e8cfe12455'),
(3, 1, '00:00:00:10:10:00', '8f6209ca3d6b35e223a11c249d1b69fc'),
(4, 1, '00:00:10:00:00:00', 'e17ab09f3586464f19629e2e8b1e9a9d'),
(5, 1, '00:10:00:00:00:00', '9bf70279d283b85440c2031c19bb6812'),
(6, 1, '10:00:00:00:00:00', 'ad3bce4464a6267441ec144744439c7e'),
(7, 1, '00:55:00:55:00:55', 'e8d7e80d79f224771b7a3a0af4e02748'),
(8, 1, '66:00:66:00:66:00', 'ded66ce272f384e9e386c1b57ded3e4d'),
(9, 1, '00:ff:ff:ff:ff:ff', '695610ee509c060b1fca9c8011529af4'),
(10, 1, '00:22:00:22:00:22', 'a3562c8cad2a4fa4fc11656025dc911b'),
(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');

-- Adding config
INSERT INTO `pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `shellscript`, `created`) VALUES
(1, 'Config 1', 1, 1, 'shellscript 1', '1299693677'),
(2, 'Config 2', 1, 1, 'shellskript 2', '1299693690'),
(3, 'Config 3', 1, 1, 'shellskript 3', '1299693690'),
(4, 'Config 4', 1, 1, 'shellskript 4', '1299693690'),
(5, 'Config 5', 1, 1, 'shellskript 5', '1299693690');

-- Adding bootos
INSERT INTO `pbs_bootos` (`bootosID`, `configID`, `groupID`, `membershipID`, `title`, `description`, `path_init`, `path_kernel`, `defaultkcl`, `created`, `expires`, `public`) VALUES
(1, 1, 1, 1, 'BootOs 1', 'Description 1', 'initpath 1', 'kernelpath 1', 'default kcl 1', '1299693782', '2012-03-09', 0),
(2, 1, 1, 1, 'BootOs 2', 'Description 2', 'initpath 2', 'kernelpath 2', 'default kcl 2', '1299693782', '2012-03-09', 0),
(3, 1, 1, 1, 'BootOs 3', 'Description 3', 'initpath 3', 'kernelpath 3', 'default kcl 3', '1299693782', '2012-03-09', 0),
(4, 1, 1, 1, 'BootOs 4', 'Description 4', 'initpath 4', 'kernelpath 4', 'default kcl 4', '1299693782', '2012-03-09', 0),
(5, 1, 1, 1, 'BootOs 5', 'Description 5', 'initpath 5', 'kernelpath 5', 'default kcl 5', '1299693782', '2012-03-09', 0),
(6, 1, 1, 1, 'BootOs 6', 'Description 6', 'initpath 6', 'kernelpath 6', 'default kcl 6', '1299693782', '2012-03-09', 0),
(7, 1, 1, 1, 'BootOs 7', 'Description 7', 'initpath 7', 'kernelpath 7', 'default kcl 7', '1299693782', '2012-03-09', 0),
(8, 1, 1, 1, 'BootOs 8', 'Description 8', 'initpath 8', 'kernelpath 8', 'default kcl 8', '1299693782', '2012-03-09', 0),
(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 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 2'),
(3, 'Preboot 3', 1, 1, 'path 3');

-- 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', '2147483647a', '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'),
(2, 1, 'Pool 2', 'Description 2', 'EG'),
(3, 1, 'Pool 3', 'Description 3', '1 OG'),
(4, 1, 'Pool 4', 'Description 4', '2 OG');

-- 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');

-- Adding BootOs to BootMenus
INSERT INTO `pbs_bootmenuentries` (`bootmenuentriesID`, `bootosID`, `bootmenuID`, `title`, `kcl`, `kclappend`, `configID`, `order`) VALUES
(1, 5, 1, '123', 'default kcl 5', 'abc', 1, 0),
(2, 2, 1, 'menu2', 'default kcl 2', '123456', 1, 1),
(3, 6, 1, 'Mein OS 6', 'default kcl 6', 'appending', 1, 2),
(4, 10, 2, 'Das OS 10', 'default kcl 10', 'append', 1, 0),
(5, 9, 5, 'Bootos 9', 'default kcl 9', 'a', 1, 0),
(6, 1, 4, 'booting 1', 'default kcl 1', 'aphabeta', 1, 0),
(7, 6, 3, 'blablabla', 'default kcl 6', '11', 1, 0);

-- Adding client to pools (poolentries)
INSERT INTO `pbs_poolentries` (`poolentriesID`, `poolID`, `clientID`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3),
(4, 1, 4),
(5, 2, 5),
(6, 2, 6),
(7, 3, 7),
(8, 3, 8),
(9, 4, 9),
(10, 4, 10);

-- Adding Sessions
INSERT INTO `pbs_session` (`sessionID`, `alphasessionID`,`clientID`, `bootmenuentryID`,`bootosID`, `bootisoID`, `time`, `ip`, `ip6`) VALUES
(1, 'a', 1, NULL, NULL, 1, '1299684000', '132.230.5.6', ''),
(2, 'b', 9, NULL, NULL, 2, '1299684000', '132.230.10.2', ''),
(3, 'c', 10, NULL, NULL, 1, '1299648000', '132.20.20.2', ''),
(4, 'd', 7, NULL, NULL, 3, '1299676800', '84.23.56.86', ''),
(5, 'e', 4, NULL, NULL, 3, '1299674340', '70.81.94.222', ''),
(6, 'f', 5, NULL, NULL, 3, '1299683100', '210.84.65.2', '');

-- 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);

-- Adding Filterentries
INSERT INTO `pbs_filterentries` (`filterentriesID`, `filterID`, `filtertypeID`, `filtervalue`, `filtervalue2`) VALUES
(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');