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 group
INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES (1 , 'Group 1', NULL);
-- Adding role
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (1, '1', 'Role 1', NULL);
INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (2, '1', 'Role 2', NULL);
-- 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');
-- Adding clients
INSERT INTO `pbs_client` (`clientID`, `macadress`, `hardwarehash`) VALUES
(1, '00:00:00:00:00:10', 'ea9b82d9de911bc2d3cd23f53a6cab48'),
(2, '00:00:00:00:10:00', '1e2b1599710fbbef0dc789e8cfe12455'),
(3, '00:00:00:10:10:00', '8f6209ca3d6b35e223a11c249d1b69fc'),
(4, '00:00:10:00:00:00', 'e17ab09f3586464f19629e2e8b1e9a9d'),
(5, '00:10:00:00:00:00', '9bf70279d283b85440c2031c19bb6812'),
(6, '10:00:00:00:00:00', 'ad3bce4464a6267441ec144744439c7e'),
(7, '00:55:00:55:00:55', 'e8d7e80d79f224771b7a3a0af4e02748'),
(8, '66:00:66:00:66:00', 'ded66ce272f384e9e386c1b57ded3e4d'),
(9, '00:ff:ff:ff:ff:ff', '695610ee509c060b1fca9c8011529af4'),
(10, '00:22:00:22:00:22', 'a3562c8cad2a4fa4fc11656025dc911b');
-- 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 bootiso
INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `path`, `serialnumber`, `created`, `expires`, `public`) VALUES
(1, 'BootIso 1', 1, 1, 'Path 1', 123456789, '1299693879', '2012-03-09', 0),
(2, 'BootIso 2', 1, 1, 'Path 2', 2147483647, '1299693899', '2012-03-09', 0),
(3, 'BootIso 3', 1, 1, 'Path 3', 2147483647, '1299693899', '2012-03-09', 0);
-- Adding Pools
INSERT INTO `pbs_pool` (`poolID`, `title`, `description`, `location`) VALUES
(1, 'Pool 1', 'Description 1', 'Keller'),
(2, 'Pool 2', 'Description 2', 'EG'),
(3, 'Pool 3', 'Description 3', '1 OG'),
(4, 'Pool 4', 'Description', '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`, `configID`, `order`) VALUES
(1, 1, 1, 'Select BootOs 1', 'kcl 1', 1, 0),
(2, 1, 1, 'Select BootOs 1', 'kcl 2', 2, 1),
(3, 2, 1, 'Select BootOs 2', 'kcl 3', 2, 2),
(4, 5, 2, 'Select BootOs 5', 'kcl 5', 2, 0),
(5, 4, 2, 'Select BootOs 4', 'kcl 4', 2, 1),
(6, 10, 3, 'Select BootOs 10', 'kcl 10', 3, 0),
(7, 8, 3, 'Select BootOs 8', 'kcl 8', 4, 1),
(8, 1, 2, 'Select BootOs 7', 'kcl 7', 5, 2),
(9, 1, 5, 'Select BootOs 3', 'kcl 3', 4, 0),
(10, 9, 4, 'Select BootOs 9', 'kcl 9', 3, 0),
(11, 7, 4, 'Select BootOs 7', 'kcl 7', 5, 1);
-- 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', '1299697337', 10),
(2, 1, 1, 5, 'Filter 2', 'Ausserhalb der Uni', '1299697073', 20),
(3, 1, 1, 4, 'Filter 3', 'Desc3', '1299697277', 5);
-- 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', '');
