· 10 years ago · Aug 23, 2016, 10:22 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 5.7.13-0ubuntu0.16.04.2 - (Ubuntu)
4-- Server OS: Linux
5-- HeidiSQL Version: 9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for weather
14CREATE DATABASE IF NOT EXISTS `weather` /*!40100 DEFAULT CHARACTER SET latin1 */;
15USE `weather`;
16
17
18-- Dumping structure for table weather.cust_weatherTemp
19CREATE TABLE IF NOT EXISTS `cust_weatherTemp` (
20 `id` int(11) NOT NULL AUTO_INCREMENT,
21 `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
22 `temp` varchar(50) DEFAULT '0',
23 `humid` varchar(50) DEFAULT '0',
24 PRIMARY KEY (`id`),
25 UNIQUE KEY `Unique` (`id`)
26) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=latin1;
27
28-- Dumping data for table weather.cust_weatherTemp: ~29 rows (approximately)
29DELETE FROM `cust_weatherTemp`;
30/*!40000 ALTER TABLE `cust_weatherTemp` DISABLE KEYS */;
31INSERT INTO `cust_weatherTemp` (`id`, `date`, `temp`, `humid`) VALUES
32 (1, '2016-08-23 19:33:55', '18.8', '71'),
33 (2, '2016-08-23 19:36:34', '18.7', '71'),
34 (3, '2016-08-23 19:39:13', '18.7', '71'),
35 (4, '2016-08-23 19:41:52', '18.4', '72'),
36 (5, '2016-08-23 19:44:31', '18.2', '72'),
37 (6, '2016-08-23 19:47:10', '18.3', '72'),
38 (7, '2016-08-23 19:49:49', '18.2', '72'),
39 (8, '2016-08-23 19:52:28', '18.0', '73'),
40 (9, '2016-08-23 19:55:07', '18.1', '72'),
41 (10, '2016-08-23 19:57:46', '17.9', '73'),
42 (11, '2016-08-23 20:00:25', '17.9', '73'),
43 (12, '2016-08-23 20:03:04', '18.0', '73'),
44 (13, '2016-08-23 20:05:43', '17.9', '73'),
45 (14, '2016-08-23 20:08:22', '18.0', '72'),
46 (15, '2016-08-23 20:11:01', '17.9', '73'),
47 (16, '2016-08-23 20:13:40', '17.9', '73'),
48 (17, '2016-08-23 20:16:19', '17.9', '73'),
49 (18, '2016-08-23 20:18:58', '17.8', '73'),
50 (19, '2016-08-23 20:21:37', '17.7', '74'),
51 (20, '2016-08-23 20:24:16', '17.6', '74'),
52 (21, '2016-08-23 20:27:48', '17.5', '74'),
53 (22, '2016-08-23 20:30:27', '17.5', '74'),
54 (23, '2016-08-23 20:33:06', '17.5', '74'),
55 (24, '2016-08-23 20:35:45', '17.4', '74'),
56 (25, '2016-08-23 20:38:24', '17.4', '74'),
57 (26, '2016-08-23 20:41:03', '17.3', '74'),
58 (27, '2016-08-23 20:43:42', '17.3', '75'),
59 (28, '2016-08-23 20:46:21', '17.3', '75'),
60 (29, '2016-08-23 20:49:00', '17.2', '76'),
61 (30, '2016-08-23 20:51:39', '17.2', '76'),
62 (31, '2016-08-23 20:54:18', '17.2', '76'),
63 (32, '2016-08-23 20:56:57', '17.1', '77'),
64 (33, '2016-08-23 20:59:36', '17.1', '77'),
65 (34, '2016-08-23 21:02:15', '17.1', '77'),
66 (35, '2016-08-23 21:04:54', '17.0', '77'),
67 (36, '2016-08-23 21:07:33', '17.0', '77'),
68 (37, '2016-08-23 21:10:12', '17.0', '76'),
69 (38, '2016-08-23 21:12:51', '17.0', '77'),
70 (39, '2016-08-23 21:15:30', '16.9', '77'),
71 (40, '2016-08-23 21:18:09', '16.8', '78'),
72 (41, '2016-08-23 21:20:48', '16.8', '78'),
73 (42, '2016-08-23 21:23:27', '16.7', '78'),
74 (43, '2016-08-23 21:26:59', '16.6', '78'),
75 (44, '2016-08-23 21:29:38', '16.6', '78'),
76 (45, '2016-08-23 21:32:17', '16.5', '79'),
77 (46, '2016-08-23 21:34:56', '16.5', '79'),
78 (47, '2016-08-23 21:37:35', '16.5', '79'),
79 (48, '2016-08-23 21:40:14', '16.5', '79'),
80 (49, '2016-08-23 21:42:53', '16.5', '79'),
81 (50, '2016-08-23 21:45:32', '16.5', '80'),
82 (51, '2016-08-23 21:48:11', '16.5', '80'),
83 (52, '2016-08-23 21:50:50', '16.5', '80'),
84 (53, '2016-08-23 21:53:29', '16.6', '80'),
85 (54, '2016-08-23 21:56:08', '16.5', '80'),
86 (55, '2016-08-23 21:58:47', '16.5', '80'),
87 (56, '2016-08-23 22:01:26', '16.5', '80'),
88 (57, '2016-08-23 22:04:05', '16.5', '80'),
89 (58, '2016-08-23 22:06:44', '16.6', '80'),
90 (59, '2016-08-23 22:09:23', '16.5', '81'),
91 (60, '2016-08-23 22:12:02', '16.6', '80'),
92 (61, '2016-08-23 22:14:41', '16.6', '80'),
93 (62, '2016-08-23 22:17:20', '16.6', '80'),
94 (63, '2016-08-23 22:19:59', '16.6', '80');
95/*!40000 ALTER TABLE `cust_weatherTemp` ENABLE KEYS */;
96/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
97/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
98/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;