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);