11,Raspberry Pi LoRa Gateway – Add Database at MySQL

設定資料庫的資料，
請先安裝Mysql 和myphpadmin
並建立資料庫ifroglab
資料庫的用戶ifroglab 和ifroglab
並新增以下的表格

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;