
11,Raspberry Pi LoRa Gateway – Add Database at MySQL
68 Comments
CREATE TABLE `IoTTable` (
`Id` int(11) NOT NULL,
`Datetime` datetime NOT NULL,
`KeyName` varchar(50) COLLATE latin1_general_ci NOT NULL,
`Data` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`OwnerId` int(11) NOT NULL,
`Datatype` varchar(20) COLLATE latin1_general_ci NOT NULL,
`IoTProjectsId` int(11) NOT NULL DEFAULT ‘0’
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;