Repository navigation
Expand file tree
/
Copy pathinsert_timedtriggers.sql
More file actions
52 lines (46 loc) · 6.71 KB
/
Copy pathinsert_timedtriggers.sql
File metadata and controls
52 lines (46 loc) · 6.71 KB
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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
# delete from timedtrigger;
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (10,"Rads Prog Mon 0 on", 0, "04:30:00", 3, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (11,"Rads Prog Mon 0 off", 0, "23:00:00", 4, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (12,"Rads Prog Tue 0 on", 1, "04:30:00", 3, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (13,"Rads Prog Tue 0 off", 1, "23:00:00", 4, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (14,"Rads Prog Wed 0 on", 2, "04:30:00", 3, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (15,"Rads Prog Wed 0 off", 2, "23:00:00", 4, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (16,"Rads Prog Thu 0 on", 3, "04:30:00", 3, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (17,"Rads Prog Thu 0 off", 3, "23:00:00", 4, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (18,"Rads Prog Fri 0 on", 4, "04:30:00", 3, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (19,"Rads Prog Fri 0 off", 4, "23:00:00", 4, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (20,"Rads Prog Sat 0 on", 5, "04:30:00", 3, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (21,"Rads Prog Sat 0 off", 5, "23:00:00", 4, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (22,"Rads Prog Sun 0 on", 6, "04:30:00", 3, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (23,"Rads Prog Sun 0 off", 6, "23:00:00", 4, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (30,"Ufloor Ground Prog Mon 0 on", 0, "05:00:00", 5, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (31,"Ufloor Ground Prog Mon 0 off", 0, "23:00:00", 6, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (32,"Ufloor Ground Prog Tue 0 on", 1, "05:00:00", 5, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (33,"Ufloor Ground Prog Tue 0 off", 1, "23:00:00", 6, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (34,"Ufloor Ground Prog Wed 0 on", 2, "05:00:00", 5, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (35,"Ufloor Ground Prog Wed 0 off", 2, "23:00:00", 6, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (36,"Ufloor Ground Prog Thu 0 on", 3, "05:00:00", 5, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (37,"Ufloor Ground Prog Thu 0 off", 3, "23:00:00", 6, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (38,"Ufloor Ground Prog Fri 0 on", 4, "05:00:00", 5, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (39,"Ufloor Ground Prog Fri 0 off", 4, "23:00:00", 6, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (40,"Ufloor Ground Prog Sat 0 on", 5, "05:00:00", 5, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (41,"Ufloor Ground Prog Sat 0 off", 5, "23:00:00", 6, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (42,"Ufloor Ground Prog Sun 0 on", 6, "05:00:00", 5, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (43,"Ufloor Ground Prog Sun 0 off", 6, "23:00:00", 6, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (50,"Ufloor First Prog Mon 0 on", 0, "05:00:00", 7, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (51,"Ufloor First Prog Mon 0 off", 0, "23:00:00", 8, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (52,"Ufloor First Prog Tue 0 on", 1, "05:00:00", 7, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (53,"Ufloor First Prog Tue 0 off", 1, "23:00:00", 8, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (54,"Ufloor First Prog Wed 0 on", 2, "05:00:00", 7, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (55,"Ufloor First Prog Wed 0 off", 2, "23:00:00", 8, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (56,"Ufloor First Prog Thu 0 on", 3, "05:00:00", 7, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (57,"Ufloor First Prog Thu 0 off", 3, "23:00:00", 8, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (58,"Ufloor First Prog Fri 0 on", 4, "05:00:00", 7, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (59,"Ufloor First Prog Fri 0 off", 4, "23:00:00", 8, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (60,"Ufloor First Prog Sat 0 on", 5, "05:00:00", 7, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (61,"Ufloor First Prog Sat 0 off", 5, "23:00:00", 8, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (62,"Ufloor First Prog Sun 0 on", 6, "05:00:00", 7, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (63,"Ufloor First Prog Sun 0 off", 6, "23:00:00", 8, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (64,"Reset daily consumption", -1, "00:00:01", 9, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (65,"Boost DHW off peak", -1, "05:30:00", 10, "Active");
insert into timedtrigger (timedtriggerid, description, day, time, actionid, status) values (66,"Unboost DHW off peak", -1, "06:29:00", 11, "Active");