hQdTLcE2

1DROP TABLE IF EXISTS `events_dictionary`;
2
3CREATE TABLE `events_dictionary` (
4  `id` int(11) NOT NULL AUTO_INCREMENT,
5  `name` varchar(64) NOT NULL,
6  PRIMARY KEY (`id`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8;
8
9INSERT INTO `events_dictionary` VALUES (1, 'Light'),(2, 'Switch'),(3, 'on'),(4, 'off');
10
11DROP TABLE IF EXISTS `events_log`;
12
13CREATE TABLE `events_log` (
14  `log_id` bigint(20) NOT NULL AUTO_INCREMENT,
15  `event_name_id` int(11) NOT NULL DEFAULT '0',
16  `event_param1` int(11) DEFAULT NULL,
17  `event_value1` int(11) DEFAULT NULL,
18  PRIMARY KEY (`log_id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8;
20
21INSERT INTO `events_log` VALUES (1, 1, 1, 1),(2, 1, 1, 2);
22	
23SELECT name, event_param1, event_value1 FROM events_log JOIN events_dictionary ON events_log.event_name_id = events_dictionary.id;
24	
25name  | event_param1  | event_value1
26Light | 1             |  1
27Light | 1             |  2