From 6569600da6b4681db1c7e218f9a9747d933e8468 Mon Sep 17 00:00:00 2001 From: Björn Geiger Date: Wed, 17 Aug 2011 21:19:04 +0200 Subject: Client nun mit ip bzw. ip6 --- setup/pbs-newdata.sql | 31 +++++++++++++++---------------- setup/pbs.sql | 2 ++ 2 files changed, 17 insertions(+), 16 deletions(-) (limited to 'setup') diff --git a/setup/pbs-newdata.sql b/setup/pbs-newdata.sql index ecc6117..17de9bd 100644 --- a/setup/pbs-newdata.sql +++ b/setup/pbs-newdata.sql @@ -37,22 +37,21 @@ INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, ` INSERT INTO `pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`, `apikey`) VALUES (NULL, '8', '1', '1', 'apikey8'); -- Adding clients -INSERT INTO `pbs_client` (`clientID`, `groupID`,`macadress`, `hardwarehash`) VALUES -(1, 1, 'a5:9a:0f:94:2a:b0', 'ea9b82d9de911bc2d3cd23f53a6cab48'), -(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'), -(5, 1, '63:51:7e:22:aa:72', '9bf70279d283b85440c2031c19bb6812'), -(6, 1, '68:9e:fe:47:95:c5', 'ad3bce4464a6267441ec144744439c7e'), -(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'), -(10, 1, '56:8e:7b:03:5f:98', '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'); - +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 diff --git a/setup/pbs.sql b/setup/pbs.sql index 0ddf900..33682bc 100644 --- a/setup/pbs.sql +++ b/setup/pbs.sql @@ -264,6 +264,8 @@ ALTER TABLE `pbs_bootiso` CREATE TABLE IF NOT EXISTS `pbs_client` ( `clientID` int(11) NOT NULL AUTO_INCREMENT, `macadress` varchar(17) NOT NULL, + `ip` varchar(15) NOT NULL, + `ip6` varchar(45), `hardwarehash` varchar(32), `created` int(15), PRIMARY KEY (`clientID`) -- cgit v1.2.3-55-g7522