summaryrefslogtreecommitdiffstats
path: root/setup
diff options
context:
space:
mode:
authorBjörn Geiger2011-08-24 13:56:27 +0200
committerBjörn Geiger2011-08-24 13:56:27 +0200
commit88c3105d9bee90653a1327062183a0726377e9ad (patch)
tree70032ee8e0e9ca33ec3e382de20c580e3424dc3e /setup
parentminor (diff)
downloadpoolctrl-88c3105d9bee90653a1327062183a0726377e9ad.tar.gz
poolctrl-88c3105d9bee90653a1327062183a0726377e9ad.tar.xz
poolctrl-88c3105d9bee90653a1327062183a0726377e9ad.zip
verschiedene Korrekturen
Diffstat (limited to 'setup')
-rw-r--r--setup/poolctrl_testpool-113.sql42
1 files changed, 42 insertions, 0 deletions
diff --git a/setup/poolctrl_testpool-113.sql b/setup/poolctrl_testpool-113.sql
new file mode 100644
index 0000000..fb1c453
--- /dev/null
+++ b/setup/poolctrl_testpool-113.sql
@@ -0,0 +1,42 @@
+USE poolctrl;
+SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+
+-- Adding Clients of Pool RZ -113
+INSERT INTO `pbs_client` (`clientID`, `groupID`, `macadress`, `hardwarehash`, `ip`, `ip6`) VALUES
+(16, 1, '00:1e:0b:a6:f8:19', null, '132.230.4.121', null),
+(17, 1, '00:1e:0b:a6:d5:de', null, '132.230.4.122', null),
+(18, 1, '00:1e:0b:a6:d5:8e', null, '132.230.4.123', null),
+(19, 1, '00:1e:0b:a6:f8:2c', null, '132.230.4.124', null),
+(20, 1, '00:1e:0b:a6:d5:e9', null, '132.230.4.125', null),
+(21, 1, '00:1e:0b:a6:d5:07', null, '132.230.4.126', null),
+(22, 1, '00:1e:0b:a6:d5:d4', null, '132.230.4.127', null),
+(23, 1, '00:1e:0b:a6:f8:5d', null, '132.230.4.128', null),
+(24, 1, '00:1e:0b:a6:f8:04', null, '132.230.4.129', null),
+(25, 1, '00:1e:0b:a6:f7:eb', null, '132.230.4.130', null),
+(26, 1, '00:1e:0b:a6:f8:a7', null, '132.230.4.131', null),
+(27, 1, '00:1e:0b:a6:d5:e4', null, '132.230.4.132', null),
+(28, 1, '00:1e:0b:a6:f8:76', null, '132.230.4.133', null),
+(29, 1, '00:1e:0b:a6:f7:52', null, '132.230.4.134', null),
+(30, 1, '00:1e:0b:a6:d5:b5', null, '132.230.4.135', null);
+
+-- Adding Pool RZ -113
+INSERT INTO `pbs_pool` (`poolID`, `groupID`, `title`, `description`, `location`) VALUES
+(6, 1, 'Pool RZ -113', 'Pool im Keller Raum -113', 'Rechenzentrum Keller');
+
+-- Adding clients to Pool RZ -113
+INSERT INTO `pbs_poolentries` (`poolID`, `clientID`) VALUES
+(6, 16),
+(6, 17),
+(6, 18),
+(6, 19),
+(6, 20),
+(6, 21),
+(6, 22),
+(6, 23),
+(6, 24),
+(6, 25),
+(6, 26),
+(6, 27),
+(6, 28),
+(6, 29),
+(6, 30);