forked from gitalecu/DIY-Arduino-PID-and-Web-temperature
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmysql.sql
More file actions
205 lines (188 loc) · 14.1 KB
/
mysql.sql
File metadata and controls
205 lines (188 loc) · 14.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
--http://fermentationriot.com/images/SQL%20table.jpg
--Now we need to create an SQL database and create a table with the following column structure:
--Name the table "temp".
--See more at: http://fermentationriot.com/arduinopid.php#sthash.3voJRpbo.dpuf
-- phpMyAdmin SQL Dump
-- version 3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 29, 2015 at 06:52 AM
-- Server version: 5.1.62-log
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `web59db1`
--
-- --------------------------------------------------------
--
-- Table structure for table `temp`
--
CREATE TABLE IF NOT EXISTS `temp` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique ID',
`Time` int(11) NOT NULL,
`Temp` varchar(10) CHARACTER SET utf8 NOT NULL COMMENT 'Unique ID of the sensor',
`Setpoint` varchar(10) CHARACTER SET utf8 NOT NULL COMMENT 'Measured Temperature in Celsius',
`Input` varchar(10) CHARACTER SET utf8 NOT NULL,
`Kp` varchar(10) CHARACTER SET utf8 NOT NULL,
`Ki` varchar(10) CHARACTER SET utf8 NOT NULL,
`Kd` varchar(10) CHARACTER SET utf8 NOT NULL,
`Heater` varchar(10) CHARACTER SET ucs2 NOT NULL,
PRIMARY KEY (`id`),
KEY `event` (`Temp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=404 ;
--
-- Dumping data for table `temp`
--
INSERT INTO `temp` (`id`, `Time`, `Temp`, `Setpoint`, `Input`, `Kp`, `Ki`, `Kd`, `Heater`) VALUES
(133, 1435548328, '-1768.00', '127.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(132, 1435548324, '-1768.00', '100.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(131, 1435548320, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(130, 1435548316, '-1768.00', '127.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(403, 1435549477, '-1768.00', '139.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(402, 1435549474, '-1768.00', '139.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(401, 1435549472, '-1768.00', '102.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(400, 1435549470, '-1768.00', '119.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(399, 1435549467, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(398, 1435549465, '-1768.00', '133.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(397, 1435549462, '-1768.00', '101.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(396, 1435549460, '-1768.00', '138.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(395, 1435549457, '-1768.00', '103.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(394, 1435549455, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(393, 1435549452, '-1768.00', '111.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(392, 1435549450, '-1768.00', '108.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(391, 1435549447, '-1768.00', '137.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(390, 1435549445, '-1768.00', '131.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(389, 1435549442, '-1768.00', '105.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(388, 1435549440, '-1768.00', '135.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(387, 1435549437, '-1768.00', '143.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(386, 1435549435, '-1768.00', '107.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(385, 1435549432, '-1768.00', '104.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(384, 1435549429, '-1768.00', '108.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(383, 1435549427, '-1768.00', '101.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(382, 1435549424, '-1768.00', '143.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(381, 1435549423, '29', '20', '19', '200', '50', '0', '25'),
(380, 1435549422, '-1768.00', '136.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(379, 1435549419, '-1768.00', '104.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(378, 1435549417, '29', '20', '19', '200', '50', '0', '25'),
(377, 1435549417, '-1768.00', '107.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(376, 1435549414, '-1768.00', '146.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(375, 1435549412, '-1768.00', '144.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(374, 1435549409, '-1768.00', '133.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(373, 1435549407, '-1768.00', '104.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(372, 1435549405, '-1768.00', '124.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(371, 1435549402, '-1768.00', '125.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(370, 1435549400, '-1768.00', '103.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(369, 1435549399, '29', '20', '19', '200', '50', '0', '25'),
(368, 1435549397, '-1768.00', '133.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(367, 1435549395, '-1768.00', '104.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(366, 1435549392, '-1768.00', '102.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(365, 1435549390, '-1768.00', '114.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(364, 1435549387, '-1768.00', '125.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(363, 1435549385, '-1768.00', '103.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(362, 1435549383, '-1768.00', '144.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(361, 1435549381, '-1768.00', '104.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(360, 1435549378, '-1768.00', '106.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(359, 1435549376, '-1768.00', '106.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(358, 1435549373, '-1768.00', '140.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(357, 1435549371, '-1768.00', '117.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(356, 1435549369, '-1768.00', '104.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(355, 1435549366, '-1768.00', '136.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(354, 1435549364, '-1768.00', '130.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(353, 1435549361, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(352, 1435549359, '-1768.00', '121.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(351, 1435549356, '-1768.00', '133.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(350, 1435549354, '-1768.00', '103.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(349, 1435549352, '29', '20', '19', '200', '50', '0', '25'),
(348, 1435549352, '-1768.00', '114.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(347, 1435549349, '-1768.00', '135.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(346, 1435549347, '-1768.00', '103.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(345, 1435549344, '-1768.00', '120.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(344, 1435549343, '29', '20', '19', '200', '50', '0', '25'),
(343, 1435549342, '-1768.00', '139.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(342, 1435549339, '-1768.00', '140.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(341, 1435549337, '-1768.00', '143.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(340, 1435549334, '-1768.00', '134.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(339, 1435549332, '-1768.00', '103.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(338, 1435549329, '-1768.00', '112.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(337, 1435549328, '29', '20', '19', '200', '50', '0', '25'),
(336, 1435549326, '29', '20', '19', '200', '50', '0', '25'),
(335, 1435549326, '-1768.00', '132.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(334, 1435549324, '-1768.00', '120.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(333, 1435549321, '-1768.00', '107.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(332, 1435549318, '-1768.00', '121.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(331, 1435549316, '-1768.00', '155.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(330, 1435549314, '-1768.00', '207.00', '-1709.07', '200.00', '50.00', '0.00', '100.00'),
(329, 1435549247, '29', '20', '19', '200', '50', '0', '25'),
(328, 1435549244, '29', '20', '19', '200', '50', '0', '25'),
(327, 1435549230, '29', '20', '19', '200', '50', '0', '25'),
(326, 1435549218, '29', '20', '19', '200', '50', '0', '25'),
(325, 1435548958, '-1768.00', '126.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(324, 1435548956, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(323, 1435548954, '-1768.00', '116.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(322, 1435548951, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(321, 1435548948, '-1768.00', '121.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(320, 1435548946, '-1768.00', '132.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(319, 1435548943, '-1768.00', '100.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(318, 1435548941, '-1768.00', '103.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(317, 1435548938, '-1768.00', '102.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(316, 1435548936, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(315, 1435548933, '-1768.00', '121.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(314, 1435548931, '-1768.00', '119.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(313, 1435548928, '-1768.00', '132.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(312, 1435548926, '-1768.00', '108.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(311, 1435548923, '-1768.00', '99.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(310, 1435548921, '-1768.00', '142.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(309, 1435548918, '-1768.00', '137.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(308, 1435548916, '-1768.00', '128.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(307, 1435548913, '-1768.00', '100.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(306, 1435548911, '-1768.00', '101.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(305, 1435548908, '-1768.00', '106.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(304, 1435548906, '-1768.00', '134.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(303, 1435548903, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(302, 1435548901, '-1768.00', '109.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(301, 1435548898, '-1768.00', '122.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(300, 1435548896, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(299, 1435548894, '-1768.00', '123.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(298, 1435548892, '-1768.00', '113.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(297, 1435548889, '-1768.00', '125.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(296, 1435548887, '-1768.00', '140.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(295, 1435548884, '-1768.00', '100.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(294, 1435548882, '-1768.00', '106.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(293, 1435548879, '-1768.00', '123.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(292, 1435548877, '-1768.00', '128.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(291, 1435548875, '-1768.00', '141.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(290, 1435548872, '-1768.00', '140.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(289, 1435548870, '-1768.00', '121.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(288, 1435548867, '-1768.00', '99.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(287, 1435548865, '-1768.00', '100.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(286, 1435548862, '-1768.00', '127.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(285, 1435548860, '-1768.00', '128.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(284, 1435548857, '-1768.00', '107.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(283, 1435548855, '-1768.00', '106.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(282, 1435548852, '-1768.00', '101.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(281, 1435548850, '-1768.00', '105.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(280, 1435548847, '-1768.00', '100.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(279, 1435548845, '-1768.00', '135.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(265, 1435548810, '-1768.00', '197.00', '-1709.07', '200.00', '50.00', '0.00', '100.00'),
(266, 1435548813, '-1768.00', '150.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(267, 1435548815, '-1768.00', '146.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(268, 1435548818, '-1768.00', '118.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(269, 1435548820, '-1768.00', '113.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(270, 1435548822, '-1768.00', '131.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(271, 1435548825, '-1768.00', '134.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(272, 1435548827, '-1768.00', '105.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(273, 1435548830, '-1768.00', '114.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(274, 1435548832, '-1768.00', '129.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(275, 1435548835, '-1768.00', '142.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(276, 1435548837, '-1768.00', '140.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(277, 1435548840, '-1768.00', '136.00', '-1768.00', '200.00', '50.00', '0.00', '100.00'),
(278, 1435548842, '-1768.00', '126.00', '-1768.00', '200.00', '50.00', '0.00', '100.00');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;