summaryrefslogtreecommitdiffstats
path: root/setup/poolctrl_testpool-113.sql
blob: fb1c453cddc34c9a79923c9eee277248b8c5ef4d (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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);