FPMr9YYb

1CREATE TABLE IF NOT EXISTS `services` (
2  `id` int(6) unsigned NOT NULL,
3  `description` varchar(200) NOT NULL,
4  PRIMARY KEY (`id`)
5) DEFAULT CHARSET=utf8;
6
7INSERT INTO `services` (`id`, `description`) VALUES
8  ('1', 'Water flood from kitchen'),
9  ('2', 'Light switch burnt');
10
11
12CREATE TABLE IF NOT EXISTS `visits` (
13  `id` int(6) unsigned NOT NULL,
14  `date` DATETIME NOT NULL,
15  `description` varchar(200) NOT NULL,
16  `worker` varchar(200) NOT NULL,
17  `services_id` int(6) NOT NULL,
18  PRIMARY KEY (`id`)
19) DEFAULT CHARSET=utf8;
20
21INSERT INTO `visits` (`id`, `date`, `description`, `worker`, `services_id`) VALUES
22  ('1', '2018-12-10 16:00:00', 'Find and stop leak', 'Thomas', '1'),
23  ('2', '2018-12-11 09:00:00', 'Change broken pipe', 'Bob', '1'),
24  ('3', '2018-12-10 19:00:00', 'Change light switch', 'Alfred', '2'),
25  ('4', '2018-12-11 10:00:00', 'Paint wall blackened by shortcircuit', 'Ryan', '2');
26	
27'1', '2018-12-10 16:00:00', 'Find and stop leak', 'Thomas', '1'
28'3', '2018-12-10 19:00:00', 'Change light switch', 'Alfred', '2'