· 8 years ago · Jan 08, 2018, 11:02 AM
1CREATE TABLE IF NOT EXISTS `domacnost` (
2 `id_zaznam` int(10) unsigned NOT NULL AUTO_INCREMENT,
3 `cas` int(10) unsigned NOT NULL DEFAULT '0',
4 `teplota_dom` float DEFAULT '0',
5 `teplota_exterier` float DEFAULT '0',
6 `teplota_garaz` float DEFAULT '0',
7 `vlhkost_dom` int(10) unsigned DEFAULT '0',
8 `vlhkost_exterier` int(10) unsigned DEFAULT '0',
9 `vlhkost_garaz` int(10) unsigned DEFAULT '0',
10 `okno1` tinyint(3) unsigned DEFAULT '0',
11 `okno2` tinyint(3) unsigned DEFAULT '0',
12 `okno3` tinyint(3) unsigned DEFAULT '0',
13 `dvere` tinyint(3) unsigned DEFAULT '0',
14 PRIMARY KEY (`id_zaznam`)
15) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
16
17-- Exportovánà dat pro tabulku test.domacnost: ~0 rows (přibližně)
18/*!40000 ALTER TABLE `domacnost` DISABLE KEYS */;
19INSERT INTO `domacnost` (`id_zaznam`, `cas`, `teplota_dom`, `teplota_exterier`, `teplota_garaz`, `vlhkost_dom`, `vlhkost_exterier`, `vlhkost_garaz`, `okno1`, `okno2`, `okno3`, `dvere`) VALUES
20 (1, 1515312000, 20.7, 5.2, 12.6, 50, 70, 60, 0, 0, 0, 0),
21 (2, 1515312300, 21.5, 5.2, 13.4, 50, 70, 60, 0, 1, 0, 0),
22 (3, 1515312600, 20.8, 5.3, 12.6, 50, 69, 60, 0, 0, 0, 0),
23 (4, 1515312900, 21, 5.3, 12.9, 51, 69, 59, 0, 0, 0, 0),
24 (5, 1515313200, 21.4, 5.3, 13.2, 50, 69, 59, 0, 0, 0, 0),
25 (6, 1515313500, 20.9, 5.3, 12.8, 51, 69, 60, 0, 1, 0, 0),
26 (7, 1515313800, 21.4, 5.4, 13.3, 53, 68, 60, 1, 1, 0, 1),
27 (8, 1515314100, 20.6, 5.4, 12.5, 57, 68, 59, 1, 0, 0, 0),
28 (9, 1515314400, 21.1, 5.4, 13.1, 56, 68, 60, 0, 0, 0, 0),
29 (10, 1515314700, 20.6, 5.4, 12.4, 56, 68, 59, 0, 0, 0, 0),
30 (11, 1515315000, 20.7, 5.3, 12.6, 55, 68, 58, 0, 0, 0, 0),
31 (12, 1515315300, 20.9, 5.3, 12.7, 55, 68, 59, 0, 0, 0, 0),
32 (13, 1515315600, 21.2, 5.4, 13.1, 55, 67, 59, 0, 0, 0, 0),
33 (14, 1515315900, 21, 5.4, 13, 54, 67, 60, 0, 1, 0, 0),
34 (15, 1515316200, 21.1, 5.4, 13, 54, 67, 61, 0, 0, 1, 0),
35 (16, 1515316500, 20.9, 5.4, 12.8, 56, 67, 62, 1, 0, 1, 0),
36 (17, 1515316800, 21.1, 5.4, 12.9, 55, 65, 62, 0, 0, 1, 0),
37 (18, 1515317100, 20.6, 5.5, 12.5, 54, 65, 63, 0, 0, 1, 1),
38 (19, 1515317400, 20.7, 5.5, 12.7, 54, 65, 63, 0, 0, 1, 0),
39 (20, 1515317700, 21.5, 5.5, 13.5, 56, 65, 64, 1, 0, 1, 0),
40 (21, 1515318000, 20.9, 5.5, 12.8, 58, 64, 64, 1, 0, 1, 0),
41 (22, 1515318300, 20.6, 5.5, 12.5, 60, 64, 64, 1, 1, 1, 0),
42 (23, 1515318600, 20.8, 5.6, 12.8, 60, 64, 64, 0, 1, 1, 0),
43 (24, 1515318900, 21, 5.6, 12.9, 59, 64, 64, 0, 0, 1, 0),
44 (25, 1515319200, 21.4, 5.6, 13.3, 58, 64, 64, 0, 0, 1, 0),
45 (26, 1515319500, 20.7, 5.6, 12.5, 58, 64, 64, 0, 0, 1, 0),
46 (27, 1515319800, 21.4, 5.5, 13.2, 57, 64, 64, 0, 1, 1, 1),
47 (28, 1515320100, 20.9, 5.6, 12.8, 56, 63, 63, 0, 0, 1, 0),
48 (29, 1515320400, 20.6, 5.7, 12.6, 55, 63, 63, 0, 0, 1, 0);