· 8 years ago · May 21, 2018, 04:42 AM
1CREATE TABLE IF NOT EXISTS `IOTBoard` (
2 `Led1` int(11) NOT NULL,
3 `Led2` int(11) NOT NULL,
4 `Gas` int(11) NOT NULL,
5 `Gas_Value` float NOT NULL,
6 `PIR` int(11) NOT NULL,
7 `Temp` float NOT NULL,
8 `Temp_status` int(11) NOT NULL,
9 `Led_Value1` float NOT NULL,
10 `Led1_Color` int(10) NOT NULL,
11 `Led_Value2` float NOT NULL,
12 `Led2_Color` int(10) NOT NULL,
13 `Id` int(11) NOT NULL,
14 `enable` int(11) NOT NULL
15) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
16
17--
18-- Dumping data for table `IOTBoard`
19--
20
21INSERT INTO `IOTBoard` (`Led1`, `Led2`, `Gas`, `Gas_Value`, `PIR`, `Temp`, `Temp_status`, `Led_Value1`, `Led1_Color`, `Led_Value2`, `Led2_Color`, `Id`, `enable`) VALUES
22(1, 1, 1, 1, 1, 24, 1, 107.35, 6, 0, 6, 1, 1);