diff options
Diffstat (limited to 'pbs-newdata.sql')
| -rw-r--r-- | pbs-newdata.sql | 183 |
1 files changed, 0 insertions, 183 deletions
diff --git a/pbs-newdata.sql b/pbs-newdata.sql deleted file mode 100644 index 0c1fffb..0000000 --- a/pbs-newdata.sql +++ /dev/null @@ -1,183 +0,0 @@ -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 -(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`, `inheritance`) VALUES (7, '2', 'Role 1-Group2', NULL, 0); -INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (8, '2', 'Role 2-Group2', NULL, 0); -INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`, `inheritance`) VALUES (9, '2', 'Role 3-Group2', NULL, 0); - -INSERT INTO `pbs_rightroles` (`roleID`, `rightID`) VALUES -(7, 4), -(7, 3), -(8, 1), -(9, 2); - --- Adding memberships -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (1, '1', '1', '1', 'apikey1'); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (2, '1', '2', '2', 'apikey2'); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (3, '2', '3', '1', 'apikey3'); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (4, '2', '4', '3', 'apikey4'); - --- 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'), -(14, 1, '64:46:85:A1:89:23', '9684216842068420616841asd6516984'); - --- Adding config -INSERT INTO `pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `visible`, `created`) VALUES -(1, 'Config 1', 1, null, '1', '1299693677'), -(2, 'Config 2', 1, null, '0', '1299693690'), -(3, 'Config 3', 1, null, '1', '1299693690'), -(4, 'Config 4', null, 1, '1', '1299693690'), -(5, 'Config 5', null, 1, '1', '1299693690'); - --- Adding bootosuser -INSERT INTO `pbs_bootosuser` (`bootosuserID`, `configID`, `login`, `password`, `homepath`, `hometypeID`) VALUES -(1, 1, 'login1', 'password1', null, 0), -(2, 1, 'login2', 'password2', null, 1), -(3, 1, 'login3', 'password3', '/home/bla/blub', 2), -(4, 4, 'login4', 'password4', null, 0), -(5, 4, 'login5', 'password5', null, 1); - --- Adding hometype -INSERT INTO `pbs_hometype` (`hometypeID`, `name`) VALUES -(0, 'standard'), -(1, 'usbstick'), -(2, 'custom path'), -(3, 'extern'), -(4, 'dropbox'); - --- Adding bootos -INSERT INTO `pbs_bootos` (`bootosID`, `path_config`, `groupID`, `membershipID`, `title`, `description`, `path_init`, `path_kernel`, `defaultkcl`, `created`, `expires`, `public`, `source`, `distro`, `distroversion`, `shortname`, `share`) VALUES -(1, 'configpath 1', 1, 1, 'BootOs 1', 'Description 1', 'initpath 1', 'kernelpath 1', 'default kcl 1', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(2, 'configpath 2', 1, 1, 'BootOs 2', 'Description 2', 'initpath 2', 'kernelpath 2', 'default kcl 2', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(3, 'configpath 3', 1, 1, 'BootOs 3', 'Description 3', 'initpath 3', 'kernelpath 3', 'default kcl 3', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(4, 'configpath 4', 1, 1, 'BootOs 4', 'Description 4', 'initpath 4', 'kernelpath 4', 'default kcl 4', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(5, 'configpath 5', 1, 1, 'BootOs 5', 'Description 5', 'initpath 5', 'kernelpath 5', 'default kcl 5', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(6, 'configpath 6', 1, 1, 'BootOs 6', 'Description 6', 'initpath 6', 'kernelpath 6', 'default kcl 6', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(7, 'configpath 7', 1, 1, 'BootOs 7', 'Description 7', 'initpath 7', 'kernelpath 7', 'default kcl 7', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(8, 'configpath 8', 1, 1, 'BootOs 8', 'Description 8', 'initpath 8', 'kernelpath 8', 'default kcl 8', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(9, 'configpath 9', 1, 1, 'BootOs 9', 'Description 9', 'initpath 9', 'kernelpath 9', 'default kcl 9', '1299693782', '2012-03-09', 0, null, null, null, null, null), -(10, 'configpath 10', 1, 1, 'BootOs 10', 'Description 10', 'initpath 10', 'kernelpath 10', 'default kcl 10', '1299693782', '2012-03-09', 0, null, null, null, null, null); - - --- 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', '10-20-30-40-50', '123', '2012-03-09', 0), -(2, 'BootIso 2', 1, 1, '2', '11-20-30-40-50', '456', '2012-03-09', 0), -(3, 'BootIso 3', 1, 1, '3', '12-20-30-40-50', '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`,`defaultbootmenu`) VALUES -(1, NULL, 1, 'Bootmenu 1', '1299694422', '0'), -(2, NULL, 1, 'Bootmenu 2', '1299694433', '0'), -(3, NULL, 1, 'Bootmenu 3', '1299694441', '0'), -(4, NULL, 1, 'Bootmenu 4', '1299694454', '1'), -(5, NULL, 1, 'Bootmenu 5', '1299694461', '0'); - --- Adding BootOs to BootMenus -INSERT INTO `pbs_bootmenuentries` (`bootmenuentriesID`, `bootosID`, `bootmenuID`, `title`, `kcl`, `kclappend`, `configID`, `order`) VALUES -(1, 5, 1, '123', '1', 'abc', 1, 0), -(2, 2, 1, 'menu2', '0', '123456', 1, 1), -(3, 6, 1, 'Mein OS 6', '1', 'appending', 1, 2), -(4, 10, 2, 'Das OS 10', '1', 'append', 1, 0), -(5, 9, 5, 'Bootos 9', '1', 'a', 1, 0), -(6, 1, 4, 'booting 1', '0', 'aphabeta', 1, 0), -(7, 6, 3, 'blablabla', '0', '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, NULL, 1, 1, 'Filter 1', 'Innerhalb der Uni', '1300022113', 1), -(2, NULL, 1, 2, 'Filter 2', 'Ausserhalb der Uni', '1302000113', 1), -(3, NULL, 1, 3, 'Filter 3', 'Montags-Freitag \r\nvon 8 bis 16 Uhr \r\nInnerhalb der Uni', '1302022113', 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'); |