database/data/data_lights.sql at hms2 · NottingHack/database · GitHub

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
INSERT INTO `lights` (`id`, `output_channel_id`, `room_id`, `name`) VALUES
  (1, 1, 2, 'Blue corridor'),
  (2, 2, 2, 'Blue corridor'),
  (3, 3, 2, 'Blue corridor'),
  (4, 4, 2, ''),
  (5, 5, 2, ''),
  (6, 6, 2, ''),
  (7, 7, 2, ''),
  (8, 8, 2, ''),
  (9, 9, 2, ''),
  (10, 10, 1, 'CNC corridor'),
  (11, 11, 1, 'CNC corridor'),
  (12, 12, 1, ''),
  (13, 13, 1, ''),
  (14, 14, 1, ''),
  (15, 15, 1, ''),
  (16, 16, 8, 'CNC corridor'),
  (17, 17, 8, 'CNC corridor'),
  (18, 18, 3, ''),
  (19, 19, 3, ''),
  (20, 58, 5, 'Class Room'),
  (21, 57, 5, 'Class Room'),
  (22, 56, 5, 'Class Room'),
  (23, 55, 5, 'Class Room'),
  (24, 54, 5, 'Class Room'),
  (25, 53, 5, 'Class Room'),
  (26, 52, 5, 'Class Room'),
  (27, 51, 5, 'Class Room'),
  (28, 50, 5, 'Class Room'),
  (29, 49, 5, 'Class Room'),
  (30, 65, 4, 'Member Storage'),
  (31, 64, 4, 'Member Storage'),
  (32, 25, 7, 'Disabled toilet'),
  (33, 63, 9, 'Corridor'),
  (34, 62, 9, 'Corridor'),
  (35, 61, 9, 'Corridor'),
  (36, 60, 9, 'Corridor'),
  (37, 59, 9, 'Corridor');