-
Notifications
You must be signed in to change notification settings - Fork 0
/
ESPtable2.sql
30 lines (22 loc) · 869 Bytes
/
ESPtable2.sql
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
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
CREATE TABLE `ESPtable2` (
`id` int(5) NOT NULL,
`temp` int(5) NOT NULL,
`humidity` int(5) NOT NULL,
`temp_min` int(5) NOT NULL,
`temp_max` int(5) NOT NULL,
`weather` int(5) NOT NULL,
`value_1` int(5) NOT NULL,
`value_2` int(5) NOT NULL,
`value_3` int(5) NOT NULL,
`Value_4` int(5) NOT NULL,
`Value_5` int(5) NOT NULL,
`TEXT_1` text CHARACTER SET latin1 COLLATE latin1_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `ESPtable2` (`id`,`temp`, `humidity`, `temp_min`, `temp_max`, `weather`, `Value_1`, `Value_2`, `Value_3`, `Value_4`, `Value_5`, `TEXT_1`) VALUES
(0, 0, 0, 0, 0, 0, 0, 0, 0,0,0, 'Nebune!');
ALTER TABLE `ESPtable2`
ADD PRIMARY KEY (`id`);
ALTER TABLE `ESPtable2`
MODIFY `id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=100000;