gistfile1.sql

MariaDB [house]> select * from statistics where statisticName != 'Voltage' order by statisticDate desc limit 20;
+-------------+---------------+----------------+---------------+
| statisticId | statisticName | statisticValue | statisticDate |
+-------------+---------------+----------------+---------------+
|      547354 | Kitchen       |          79.00 |    1345365307 |
|      547353 | Computer Room |          77.00 |    1345365305 |
|      547352 | Workshop      |          80.00 |    1345365303 |
|      547287 | Kitchen       |          79.00 |    1345364987 |
|      547286 | Computer Room |          77.00 |    1345364985 |
|      547285 | Workshop      |          81.00 |    1345364983 |
|      547220 | Kitchen       |          79.00 |    1345364667 |
|      547219 | Computer Room |          78.00 |    1345364665 |
|      547218 | Workshop      |          81.00 |    1345364663 |
|      547153 | Kitchen       |          79.00 |    1345364347 |
|      547152 | Computer Room |          78.00 |    1345364345 |
|      547151 | Workshop      |          81.00 |    1345364343 |
|      547086 | Kitchen       |          79.00 |    1345364027 |
|      547085 | Computer Room |          78.00 |    1345364025 |
|      547084 | Workshop      |          81.00 |    1345364023 |
|      547019 | Kitchen       |          79.00 |    1345363709 |
|      547018 | Computer Room |          78.00 |    1345363707 |
|      547017 | Workshop      |          81.00 |    1345363706 |
|      546952 | Kitchen       |          79.00 |    1345363387 |
|      546951 | Computer Room |          78.00 |    1345363385 |
+-------------+---------------+----------------+---------------+
20 rows in set (0.00 sec)
MariaDB [house]> describe statistics;
+----------------+------------------+------+-----+---------+----------------+
| Field          | Type             | Null | Key | Default | Extra          |
+----------------+------------------+------+-----+---------+----------------+
| statisticId    | int(11)          | NO   | PRI | NULL    | auto_increment |
| statisticName  | varchar(15)      | NO   | MUL | NULL    |                |
| statisticValue | decimal(7,2)     | NO   |     | NULL    |                |
| statisticDate  | int(10) unsigned | NO   | MUL | NULL    |                |
+----------------+------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)