diff options
Diffstat (limited to 'pbs-newdata.sql')
| -rw-r--r-- | pbs-newdata.sql | 40 |
1 files changed, 18 insertions, 22 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql index 7f4b958..1abb07c 100644 --- a/pbs-newdata.sql +++ b/pbs-newdata.sql @@ -20,17 +20,17 @@ INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `person 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'); +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'); -- Adding config INSERT INTO `pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `shellscript`, `created`) VALUES @@ -77,17 +77,13 @@ INSERT INTO `pbs_bootmenu` (`bootmenuID`, `membershipID`, `groupID`, `title`, `c -- Adding BootOs to BootMenus INSERT INTO `pbs_bootmenuentries` (`bootmenuentriesID`, `bootosID`, `bootmenuID`, `title`, `kcl`, `kclappend`, `configID`, `order`) VALUES -(1, 1, 1, 'Select BootOs 1', 'kcl 1', 'kcl 1', 1, 0), -(2, 1, 1, 'Select BootOs 1', 'kcl 2', 'kcl 2', 2, 1), -(3, 2, 1, 'Select BootOs 2', 'kcl 3', 'kcl 3', 2, 2), -(4, 5, 2, 'Select BootOs 5', 'kcl 5', 'kcl 5', 2, 0), -(5, 4, 2, 'Select BootOs 4', 'kcl 4', 'kcl 4', 2, 1), -(6, 10, 3, 'Select BootOs 10', 'kcl 10', 'kcl 10', 3, 0), -(7, 8, 3, 'Select BootOs 8', 'kcl 8', 'kcl 8', 4, 1), -(8, 1, 2, 'Select BootOs 7', 'kcl 7', 'kcl 7', 5, 2), -(9, 1, 5, 'Select BootOs 3', 'kcl 3', 'kcl 3', 4, 0), -(10, 9, 4, 'Select BootOs 9', 'kcl 9', 'kcl 9', 3, 0), -(11, 7, 4, 'Select BootOs 7', 'kcl 7', 'kcl 7', 5, 1); +(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 |