USE ##poolctrl##; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- Adding person test2 INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`, `loginpassword`) VALUES (2, 'Herr', 'Test 2', 'Test 2', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test2', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$Do9tGnw0$9ndoxsmcpNV.9mFTBRB7u2RbWekbSfjnUfPKXrCUEpXrZXoqnOesXITGl.RDy0cuaYB1Ouob6WtNWQqU/M/4U.'); -- Adding person test3 INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`, `loginpassword`) VALUES (3, 'Herr', 'Test 3', 'Test 3', 'Teststr,', '5', 'Testburg', '1337', NULL, '1299612370', 'test3', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a', '$6$Do9tGnw0$9ndoxsmcpNV.9mFTBRB7u2RbWekbSfjnUfPKXrCUEpXrZXoqnOesXITGl.RDy0cuaYB1Ouob6WtNWQqU/M/4U.'); -- Adding bootiso INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `prebootID`, `serialnumber`, `created`, `expires`, `public`, `description`) VALUES (1, 'BootMedium 1', 1, 1, '1', '10-20-30-40-50', '123', '2012-03-09', 0, 'Description 1'), (2, 'BootMedium 2', 1, 1, '2', '11-20-30-40-50', '456', '2012-03-09', 0, 'Description 2'), (3, 'BootMedium 3', 1, 1, '3', '12-20-30-40-50', '789', '2012-03-09', 0, 'Description 3'); -- 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 4', '2 OG'); -- 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 events INSERT INTO `poolctrl_event` (`title`, `start`, `end`, `category`, `pbs_poolID`, `pbs_personID`, `pbs_bootisoID`, `note`) VALUES ('Systeme I', '2011-06-24 12:10:00', '2011-06-24 14:00:00', 'Vorlesung', 1, 2, 1, 'Systeme I Vorlesung'), ('Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', 'Vorlesung', 1, 2, 1, 'Systeme II Vorlesung'), ('Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', 'Vorlesung', 1, 2, 1, 'Systeme III Vorlesung'); -- Adding eventreport INSERT INTO `poolctrl_eventreport` (`report`, `eventID`) VALUES (DEFAULT, 1), (DEFAULT, 2), ('wake-on-lan failed', 3);