· 10 years ago · Aug 23, 2016, 08:52 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=30 DEFAULT CHARSET=latin1;
27
28-- Dumping data for table weather.cust_weatherTemp: ~0 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/*!40000 ALTER TABLE `cust_weatherTemp` ENABLE KEYS */;
62/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
63/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
64/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;