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.
CREATE TABLE `device_work_sched` (
`id` int(11),
`id_app` int(11),
`start_time` varchar(5),
`end_time` varchar(5),
`work_interval` varchar(5),
`is_active` tinyint(4),
`service_time` varchar(150),
`uid` varchar(50),
`day_of_week` int(1),
PRIMARY KEY (`id`),
UNIQUE KEY `Unique` (`id_app`,`day_of_week`)
);
INSERT INTO `device_work_sched` (`id`, `id_app`, `start_time`, `end_time`, `work_interval`, `is_active`, `service_time`, `uid`, `day_of_week`) VALUES
(16, 9, '08:00', '15:00', '00:15', 0, '10:00-11:10;', 'conquest', 1),
(18, 9, '08:00', '15:00', '00:30', 1, '09:00-09:10;', 'conquest', 2),
(19, 6, '08:00', '20:00', '00:30', 1, '12:00-14:00;', 'conquest', 3),
(22, 9, '08:00', '20:00', '00:30', 1, '', 'conquest', 7),
(23, 9, '08:00', '20:00', '00:30', 1, '14:00-16:00;16:35-17:00;18:30-18:40;18:50-19:00;', 'conquest', 3),
(44, 9, '08:00', '20:00', '00:30', 1, '14:00-16:00;16:35-17:00;', 'conquest', 6),
(75, 7, '10:00', '20:00', '00:10', 0, '13:00-14:00', 'conquest', 1),
(76, 7, '10:00', '20:00', '00:10', 0, '13:00-14:00', 'conquest', 2),
(77, 1, '08:00', '20:00', '00:15', 1, '12:00-13:00;15:00-19:00;', 'conquest', 1),
(78, 1, '08:00', '20:00', '00:15', 1, '12:00-13:00', 'conquest', 2),
(79, 1, '08:00', '20:00', '00:15', 1, '12:00-13:00', 'conquest', 3),
(80, 1, '08:00', '20:00', '00:15', 1, '12:00-13:00', 'conquest', 4),
(81, 1, '08:00', '20:00', '00:15', 1, '12:00-13:00', 'conquest', 5),
(97, 9, '08:00', '20:00', '00:30', 1, '14:00-16:00;17:00-18:00;', 'conquest', 4),
(98, 9, '08:00', '20:00', '00:30', 1, '', 'conquest', 5),
(133, 4, '10:00', '20:00', '00:30', 1, '10:30-11:00;12:30-13:00;15:30-16:00;', 'conquest', 1),
(134, 4, '10:00', '20:00', '00:20', 1, '10:05-13:00;', 'conquest', 2),
(184, 8, '10:00', '14:00', '00:10', 1, '', 'conquest', 1),
(185, 8, '10:00', '14:00', '00:10', 1, '', 'conquest', 4);
