1 | INSERT INTO `gssim_results`.`unit_energy_timeline` (`fk_unit_id`, `timestamp`, `usage`) |
---|
2 | VALUES ('210', FROM_UNIXTIME(1225666800), '1.4'), |
---|
3 | ('210', FROM_UNIXTIME(1225674000), '0.7'), |
---|
4 | ('210', FROM_UNIXTIME(1225681200), '0'), |
---|
5 | ('210', FROM_UNIXTIME(1225688400), '1.4'), |
---|
6 | ('210', FROM_UNIXTIME(1225692000), '2.1'), |
---|
7 | ('210', FROM_UNIXTIME(1225699200), '1.4'), |
---|
8 | ('210', FROM_UNIXTIME(1225706400), '2.1'), |
---|
9 | ('210', FROM_UNIXTIME(1225710000), '1.4'), |
---|
10 | ('210', FROM_UNIXTIME(1225713600), '2.1'), |
---|
11 | ('210', FROM_UNIXTIME(1225717200), '1.4'), |
---|
12 | ('210', FROM_UNIXTIME(1225720800), '0.7'), |
---|
13 | ('210', FROM_UNIXTIME(1225724400), '0'), |
---|
14 | ('211', FROM_UNIXTIME(1225666800), '0.2'), |
---|
15 | ('211', FROM_UNIXTIME(1225674000), '0.1'), |
---|
16 | ('211', FROM_UNIXTIME(1225681200), '0'), |
---|
17 | ('211', FROM_UNIXTIME(1225688400), '0.2'), |
---|
18 | ('211', FROM_UNIXTIME(1225692000), '0.3'), |
---|
19 | ('211', FROM_UNIXTIME(1225699200), '0.2'), |
---|
20 | ('211', FROM_UNIXTIME(1225706400), '0.3'), |
---|
21 | ('211', FROM_UNIXTIME(1225710000), '0.2'), |
---|
22 | ('211', FROM_UNIXTIME(1225713600), '0.3'), |
---|
23 | ('211', FROM_UNIXTIME(1225717200), '0.2'), |
---|
24 | ('211', FROM_UNIXTIME(1225720800), '0.1'), |
---|
25 | ('211', FROM_UNIXTIME(1225724400), '0'), |
---|
26 | ('220', FROM_UNIXTIME(1225666800), '0.7'), |
---|
27 | ('220', FROM_UNIXTIME(1225670400), '2.1'), |
---|
28 | ('220', FROM_UNIXTIME(1225677600), '0.7'), |
---|
29 | ('220', FROM_UNIXTIME(1225681200), '1.4'), |
---|
30 | ('220', FROM_UNIXTIME(1225684800), '2.1'), |
---|
31 | ('220', FROM_UNIXTIME(1225688400), '2.1'), |
---|
32 | ('220', FROM_UNIXTIME(1225692000), '1.4'), |
---|
33 | ('220', FROM_UNIXTIME(1225695600), '0'), |
---|
34 | ('221', FROM_UNIXTIME(1225666800), '0.1'), |
---|
35 | ('221', FROM_UNIXTIME(1225670400), '0.3'), |
---|
36 | ('221', FROM_UNIXTIME(1225677600), '0.1'), |
---|
37 | ('221', FROM_UNIXTIME(1225681200), '0.2'), |
---|
38 | ('221', FROM_UNIXTIME(1225684800), '0.3'), |
---|
39 | ('221', FROM_UNIXTIME(1225688400), '0.3'), |
---|
40 | ('221', FROM_UNIXTIME(1225692000), '0.2'), |
---|
41 | ('221', FROM_UNIXTIME(1225695600), '0'), |
---|
42 | ('212', FROM_UNIXTIME(1225666800), '0.4'), |
---|
43 | ('212', FROM_UNIXTIME(1225674000), '0.2'), |
---|
44 | ('212', FROM_UNIXTIME(1225681200), '0'), |
---|
45 | ('212', FROM_UNIXTIME(1225688400), '0.4'), |
---|
46 | ('212', FROM_UNIXTIME(1225692000), '0.6'), |
---|
47 | ('212', FROM_UNIXTIME(1225699200), '0.4'), |
---|
48 | ('212', FROM_UNIXTIME(1225706400), '0.6'), |
---|
49 | ('212', FROM_UNIXTIME(1225710000), '0.4'), |
---|
50 | ('212', FROM_UNIXTIME(1225713600), '0.6'), |
---|
51 | ('212', FROM_UNIXTIME(1225717200), '0.4'), |
---|
52 | ('212', FROM_UNIXTIME(1225720800), '0.2'), |
---|
53 | ('212', FROM_UNIXTIME(1225724400), '0'), |
---|
54 | ('222', FROM_UNIXTIME(1225666800), '0.2'), |
---|
55 | ('222', FROM_UNIXTIME(1225670400), '0.6'), |
---|
56 | ('222', FROM_UNIXTIME(1225677600), '0.2'), |
---|
57 | ('222', FROM_UNIXTIME(1225681200), '0.4'), |
---|
58 | ('222', FROM_UNIXTIME(1225684800), '0.6'), |
---|
59 | ('222', FROM_UNIXTIME(1225688400), '0.6'), |
---|
60 | ('222', FROM_UNIXTIME(1225692000), '0.4'), |
---|
61 | ('222', FROM_UNIXTIME(1225695600), '0'), |
---|
62 | ('310', FROM_UNIXTIME(1225666800), '2.1'), |
---|
63 | ('310', FROM_UNIXTIME(1225674000), '1.4'), |
---|
64 | ('310', FROM_UNIXTIME(1225681200), '1.4'), |
---|
65 | ('310', FROM_UNIXTIME(1225684800), '2.1'), |
---|
66 | ('310', FROM_UNIXTIME(1225688400), '2.1'), |
---|
67 | ('310', FROM_UNIXTIME(1225692000), '2.1'), |
---|
68 | ('310', FROM_UNIXTIME(1225695600), '1.4'), |
---|
69 | ('310', FROM_UNIXTIME(1225699200), '0.7'), |
---|
70 | ('310', FROM_UNIXTIME(1225713600), '1.4'), |
---|
71 | ('310', FROM_UNIXTIME(1225717200), '0.7'), |
---|
72 | ('310', FROM_UNIXTIME(1225724400), '0'), |
---|
73 | ('311', FROM_UNIXTIME(1225666800), '0.3'), |
---|
74 | ('311', FROM_UNIXTIME(1225674000), '0.2'), |
---|
75 | ('311', FROM_UNIXTIME(1225681200), '0.2'), |
---|
76 | ('311', FROM_UNIXTIME(1225684800), '0.3'), |
---|
77 | ('311', FROM_UNIXTIME(1225688400), '0.3'), |
---|
78 | ('311', FROM_UNIXTIME(1225692000), '0.3'), |
---|
79 | ('311', FROM_UNIXTIME(1225695600), '0.2'), |
---|
80 | ('311', FROM_UNIXTIME(1225699200), '0.1'), |
---|
81 | ('311', FROM_UNIXTIME(1225713600), '0.2'), |
---|
82 | ('311', FROM_UNIXTIME(1225717200), '0.1'), |
---|
83 | ('311', FROM_UNIXTIME(1225724400), '0'), |
---|
84 | ('312', FROM_UNIXTIME(1225666800), '0.6'), |
---|
85 | ('312', FROM_UNIXTIME(1225674000), '0.4'), |
---|
86 | ('312', FROM_UNIXTIME(1225681200), '0.4'), |
---|
87 | ('312', FROM_UNIXTIME(1225684800), '0.6'), |
---|
88 | ('312', FROM_UNIXTIME(1225688400), '0.6'), |
---|
89 | ('312', FROM_UNIXTIME(1225692000), '0.6'), |
---|
90 | ('312', FROM_UNIXTIME(1225695600), '0.4'), |
---|
91 | ('312', FROM_UNIXTIME(1225699200), '0.2'), |
---|
92 | ('312', FROM_UNIXTIME(1225713600), '0.4'), |
---|
93 | ('312', FROM_UNIXTIME(1225717200), '0.2'), |
---|
94 | ('312', FROM_UNIXTIME(1225724400), '0'), |
---|
95 | ('320', FROM_UNIXTIME(1225670400), '1.4'), |
---|
96 | ('320', FROM_UNIXTIME(1225677600), '0'), |
---|
97 | ('320', FROM_UNIXTIME(1225688400), '1.4'), |
---|
98 | ('320', FROM_UNIXTIME(1225695600), '0.7'), |
---|
99 | ('320', FROM_UNIXTIME(1225706400), '1.4'), |
---|
100 | ('320', FROM_UNIXTIME(1225710000), '0.7'), |
---|
101 | ('320', FROM_UNIXTIME(1225720800), '0'), |
---|
102 | ('321', FROM_UNIXTIME(1225670400), '0.2'), |
---|
103 | ('321', FROM_UNIXTIME(1225677600), '0'), |
---|
104 | ('321', FROM_UNIXTIME(1225688400), '0.2'), |
---|
105 | ('321', FROM_UNIXTIME(1225695600), '0.1'), |
---|
106 | ('321', FROM_UNIXTIME(1225706400), '0.2'), |
---|
107 | ('321', FROM_UNIXTIME(1225710000), '0.1'), |
---|
108 | ('321', FROM_UNIXTIME(1225720800), '0'), |
---|
109 | ('322', FROM_UNIXTIME(1225670400), '0.4'), |
---|
110 | ('322', FROM_UNIXTIME(1225677600), '0'), |
---|
111 | ('322', FROM_UNIXTIME(1225688400), '0.4'), |
---|
112 | ('322', FROM_UNIXTIME(1225695600), '0.2'), |
---|
113 | ('322', FROM_UNIXTIME(1225706400), '0.4'), |
---|
114 | ('322', FROM_UNIXTIME(1225710000), '0.2'), |
---|
115 | ('322', FROM_UNIXTIME(1225720800), '0'), |
---|
116 | ('410', FROM_UNIXTIME(1225688400), '1.4'), |
---|
117 | ('410', FROM_UNIXTIME(1225695600), '0.7'), |
---|
118 | ('410', FROM_UNIXTIME(1225699200), '0'), |
---|
119 | ('411', FROM_UNIXTIME(1225688400), '0.2'), |
---|
120 | ('411', FROM_UNIXTIME(1225695600), '0.1'), |
---|
121 | ('411', FROM_UNIXTIME(1225699200), '0'), |
---|
122 | ('412', FROM_UNIXTIME(1225688400), '0.4'), |
---|
123 | ('412', FROM_UNIXTIME(1225695600), '0.2'), |
---|
124 | ('412', FROM_UNIXTIME(1225699200), '0'), |
---|
125 | ('420', FROM_UNIXTIME(1225668594), '0.7'), |
---|
126 | ('420', FROM_UNIXTIME(1225675794), '0'), |
---|
127 | ('420', FROM_UNIXTIME(1225681200), '0'), |
---|
128 | ('420', FROM_UNIXTIME(1225684800), '1.4'), |
---|
129 | ('420', FROM_UNIXTIME(1225688400), '0.7'), |
---|
130 | ('420', FROM_UNIXTIME(1225692000), '0'), |
---|
131 | ('421', FROM_UNIXTIME(1225668594), '0.1'), |
---|
132 | ('421', FROM_UNIXTIME(1225675794), '0'), |
---|
133 | ('421', FROM_UNIXTIME(1225681200), '0'), |
---|
134 | ('421', FROM_UNIXTIME(1225684800), '0.2'), |
---|
135 | ('421', FROM_UNIXTIME(1225688400), '0.1'), |
---|
136 | ('421', FROM_UNIXTIME(1225692000), '0'), |
---|
137 | ('422', FROM_UNIXTIME(1225668594), '0.2'), |
---|
138 | ('422', FROM_UNIXTIME(1225675794), '0'), |
---|
139 | ('422', FROM_UNIXTIME(1225681200), '0'), |
---|
140 | ('422', FROM_UNIXTIME(1225684800), '0.4'), |
---|
141 | ('422', FROM_UNIXTIME(1225688400), '0.2'), |
---|
142 | ('422', FROM_UNIXTIME(1225692000), '0'), |
---|
143 | ('510', FROM_UNIXTIME(1225670322), '0.7'), |
---|
144 | ('510', FROM_UNIXTIME(1225673986), '1.4'), |
---|
145 | ('510', FROM_UNIXTIME(1225681186), '0.7'), |
---|
146 | ('510', FROM_UNIXTIME(1225684722), '0'), |
---|
147 | ('510', FROM_UNIXTIME(1225691986), '0.7'), |
---|
148 | ('510', FROM_UNIXTIME(1225695570), '1.4'), |
---|
149 | ('510', FROM_UNIXTIME(1225709906), '2.1'), |
---|
150 | ('510', FROM_UNIXTIME(1225713586), '1.4'), |
---|
151 | ('510', FROM_UNIXTIME(1225720770), '0.7'), |
---|
152 | ('510', FROM_UNIXTIME(1225724306), '0'), |
---|
153 | ('511', FROM_UNIXTIME(1225670322), '0.1'), |
---|
154 | ('511', FROM_UNIXTIME(1225673986), '0.2'), |
---|
155 | ('511', FROM_UNIXTIME(1225681186), '0.1'), |
---|
156 | ('511', FROM_UNIXTIME(1225684722), '0'), |
---|
157 | ('511', FROM_UNIXTIME(1225691986), '0.1'), |
---|
158 | ('511', FROM_UNIXTIME(1225695570), '0.2'), |
---|
159 | ('511', FROM_UNIXTIME(1225709906), '0.3'), |
---|
160 | ('511', FROM_UNIXTIME(1225713586), '0.2'), |
---|
161 | ('511', FROM_UNIXTIME(1225720770), '0.1'), |
---|
162 | ('511', FROM_UNIXTIME(1225724306), '0'), |
---|
163 | ('512', FROM_UNIXTIME(1225670322), '0.2'), |
---|
164 | ('512', FROM_UNIXTIME(1225673986), '0.4'), |
---|
165 | ('512', FROM_UNIXTIME(1225681186), '0.2'), |
---|
166 | ('512', FROM_UNIXTIME(1225684722), '0'), |
---|
167 | ('512', FROM_UNIXTIME(1225691986), '0.2'), |
---|
168 | ('512', FROM_UNIXTIME(1225695570), '0.4'), |
---|
169 | ('512', FROM_UNIXTIME(1225709906), '0.6'), |
---|
170 | ('512', FROM_UNIXTIME(1225713586), '0.4'), |
---|
171 | ('512', FROM_UNIXTIME(1225720770), '0.2'), |
---|
172 | ('512', FROM_UNIXTIME(1225724306), '0'), |
---|
173 | ('520', FROM_UNIXTIME(1225666802), '0.7'), |
---|
174 | ('520', FROM_UNIXTIME(1225695602), '0'), |
---|
175 | ('520', FROM_UNIXTIME(1225717042), '0.7'), |
---|
176 | ('520', FROM_UNIXTIME(1225727842), '0'), |
---|
177 | ('521', FROM_UNIXTIME(1225666802), '0.1'), |
---|
178 | ('521', FROM_UNIXTIME(1225695602), '0'), |
---|
179 | ('521', FROM_UNIXTIME(1225717042), '0.1'), |
---|
180 | ('521', FROM_UNIXTIME(1225727842), '0'), |
---|
181 | ('522', FROM_UNIXTIME(1225666802), '0.2'), |
---|
182 | ('522', FROM_UNIXTIME(1225695602), '0'), |
---|
183 | ('522', FROM_UNIXTIME(1225717042), '0.2'), |
---|
184 | ('522', FROM_UNIXTIME(1225727842), '0'); |
---|