USE ##poolctrl##; SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- Adding clients INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`, `ip`, `ip6`) VALUES (1, 1, 'a5:9a:0f:94:2a:b0', 'ea9b82d9de911bc2d3cd23f53a6cab48', '132.230.5.6', ''), (2, 1, '91:91:f1:e2:99:aa', '1e2b1599710fbbef0dc789e8cfe12455', '', ''), (3, 1, '6e:5c:82:78:f2:39', '8f6209ca3d6b35e223a11c249d1b69fc', '', ''), (4, 1, '67:75:e9:f2:5f:8e', 'e17ab09f3586464f19629e2e8b1e9a9d', '84.23.56.86', ''), (5, 1, '63:51:7e:22:aa:72', '9bf70279d283b85440c2031c19bb6812', '70.81.94.222', ''), (6, 1, '68:9e:fe:47:95:c5', 'ad3bce4464a6267441ec144744439c7e', '210.84.65.2', ''), (7, 1, '6e:1c:2e:01:77:33', 'e8d7e80d79f224771b7a3a0af4e02748', '', ''), (8, 1, 'd1:91:20:43:2f:dd', 'ded66ce272f384e9e386c1b57ded3e4d', '', ''), (9, 1, '1b:0f:a5:82:47:16', '695610ee509c060b1fca9c8011529af4', '132.230.10.2', ''), (10, 1, '56:8e:7b:03:5f:98', 'a3562c8cad2a4fa4fc11656025dc911b', '132.20.20.2', ''), (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 bootos INSERT INTO `pbs_bootos` (`bootosID`, `groupID`, `membershipID`, `title`, `description`, `defaultkcl`, `created`, `expires`, `public`, `source`, `distro`, `distroversion`, `shortname`, `share`) VALUES (1, 1, 1, 'BootOs 1', 'Description 1', 'default kcl 1', '1299693782', '2012-03-09', 0, null, null, null, null, null), (2, 1, 1, 'BootOs 2', 'Description 2', 'default kcl 2', '1299693782', '2012-03-09', 0, null, null, null, null, null), (3, 1, 1, 'BootOs 3', 'Description 3', 'default kcl 3', '1299693782', '2012-03-09', 0, null, null, null, null, null), (4, 1, 1, 'BootOs 4', 'Description 4', 'default kcl 4', '1299693782', '2012-03-09', 0, null, null, null, null, null), (5, 1, 1, 'BootOs 5', 'Description 5', 'default kcl 5', '1299693782', '2012-03-09', 0, null, null, null, null, null), (6, 1, 1, 'BootOs 6', 'Description 6', 'default kcl 6', '1299693782', '2012-03-09', 0, null, null, null, null, null), (7, 1, 1, 'BootOs 7', 'Description 7', 'default kcl 7', '1299693782', '2012-03-09', 0, null, null, null, null, null), (8, 1, 1, 'BootOs 8', 'Description 8', 'default kcl 8', '1299693782', '2012-03-09', 0, null, null, null, null, null), (9, 1, 1, 'BootOs 9', 'Description 9', 'default kcl 9', '1299693782', '2012-03-09', 0, null, null, null, null, null), (10, 1, 1, 'BootOs 10', 'Description 10', 'default kcl 10', '1299693782', '2012-03-09', 0, null, null, null, null, null); -- Adding config INSERT INTO `pbs_config` (`configID`, `title`, `description`, `groupID`, `membershipID`, `visible`, `created`, `bootosID`) VALUES (1, 'Default Config', 'Desc1', 1, null, '1', '1299693677', '1'), (2, 'Config 2', 'Desc2' ,null, 1, '1', '1299693690', '1'); -- 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 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 eventcategories INSERT INTO `poolctrl_eventcategory` (`eventcategoryID`, `title`) VALUES (1, 'Lecture'), (2, 'Maintenance'), (3, 'Boot'), (4, 'Shutdown'); -- Adding eventtypes INSERT INTO `poolctrl_eventtype` (`eventtypeID`, `title`) VALUES (1, 'Boot'), (2, 'Shutdown'); -- Adding events INSERT INTO `poolctrl_event` (`eventID`, `title`, `start`, `end`, `category`, `pbs_poolID`, `pbs_membershipID`, `pbs_bootosID`, `note`, `pbs_bootmenuID`, `pbs_filterID`, `created`) VALUES (1, 'Systeme I', '2011-06-24 12:10:00', '2011-06-24 14:00:00', '1', 1, 1, 1, 'Systeme I Vorlesung', 1, 1, 1308583320), (2, 'Systeme II', '2011-06-24 14:10:00', '2011-06-24 16:00:00', '1', 1, 1, 1, 'Systeme II Vorlesung', 1, 1, 1308583320), (3, 'Systeme III', '2011-06-24 16:10:00', '2011-06-24 18:00:00', '1', 1, 1, 1, 'Systeme III Vorlesung', 1, 1, 1308583320); -- Adding eventreports INSERT INTO `poolctrl_eventreport` (`reportID`, `result`, `errors`, `type`, `eventID`, `created`) VALUES (1, DEFAULT, null, 1, 1, 1308917400), (2, DEFAULT, null, 1, 2, 1308917400), (3, 'failed', 'wake-on-lan failed', 1, 3, 1308931800);