-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathdummy.sql
More file actions
11 lines (8 loc) · 1.08 KB
/
Copy pathdummy.sql
File metadata and controls
11 lines (8 loc) · 1.08 KB
1
2
3
4
5
6
7
8
9
10
11
insert into checkout values(1, 'UHF ISO CARD', '41443030303120202020202020202020', '{"Mon":"0-24","Tue":"0-24","Wed":"0-24","Thu":"0-24","Fri":"0-24","Sat":"0-24","Sun":"0-24"}');
insert into checkout values(2, 'UHF ISO CARD', '41443030303220202020202020202020', '{"Mon":"0-24","Tue":"0-24","Wed":"0-24","Thu":"0-24","Fri":"0-24","Sat":"0-24","Sun":"0-24"}');
insert into checkout values(3, 'UHF ISO CARD', '41443030303320202020202020202020', '{"Mon":"0-24","Tue":"0-24","Wed":"0-24","Thu":"0-24","Fri":"0-24","Sat":"0-24","Sun":"0-24"}');
insert into checkout values(20, 'Camera', 'AD000001');
insert into events values('Detected', 'UHF ISO CARD', '41443030303120202020202020202020', 'Door', '2016-06-10 08:00:00');
insert into events values('Detected', 'UHF ISO CARD', '41443030303220202020202020202020', 'Door', '2016-06-11 08:30:00');
insert into events values('Detected', 'UHF ISO CARD', '41443030303320202020202020202020', 'Door', '2016-06-12 18:00:00');
'{"Mon":"00:00-24:00","Tue":"00:00-24:00","Wed":"00:00-24:00","Thu":"00:00-24:00","Fri":"00:00-24:00","Sat":"00:00-24:00","Sun":"00:00-24:00"}'