{"id":1892,"date":"2013-04-04T14:16:02","date_gmt":"2013-04-04T05:16:02","guid":{"rendered":"http:\/\/www.pinewell.jp\/wordpress\/?p=1892"},"modified":"2013-04-04T14:16:02","modified_gmt":"2013-04-04T05:16:02","slug":"%e3%83%87%e3%83%bc%e3%82%bf%e3%83%99%e3%83%bc%e3%82%b9%e3%81%ae%e4%bd%9c%e6%88%90","status":"publish","type":"post","link":"http:\/\/www.pinewell.jp\/wordpress\/?p=1892","title":{"rendered":"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210"},"content":{"rendered":"

ls-gl\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3001\u4e0b\u8a18\u3092\u5b9f\u884c\u3002
\n[crayon]
\nCREATE DATABASE gettemp;
\nUSE gettemp;
\nCREATE TABLE `MSI` (
\n `ID` int(11) NOT NULL AUTO_INCREMENT,
\n `UPTIM` int(11) NOT NULL DEFAULT ‘0’,
\n `gettemp0` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp1` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp2` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp3` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `Weather` int(11) NOT NULL DEFAULT ‘0’,
\n PRIMARY KEY (`ID`)
\n) ENGINE=MyISAM AUTO_INCREMENT=35411 DEFAULT CHARSET=utf8;<\/p>\n

CREATE TABLE `HIGHLOW_Y` (
\n `ID` int(11) NOT NULL AUTO_INCREMENT,
\n `TIM` int(11) NOT NULL DEFAULT ‘0’,
\n `UPTIM` int(11) NOT NULL DEFAULT ‘0’,
\n `SensorNo` tinyint(4) NOT NULL DEFAULT ‘0’,
\n `gettemp` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `kbn` tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘0:High 1:Low’,
\n PRIMARY KEY (`ID`)
\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;<\/p>\n

CREATE TABLE `HIGHLOW_M` (
\n `ID` int(11) NOT NULL AUTO_INCREMENT,
\n `TIM` int(11) NOT NULL DEFAULT ‘0’,
\n `UPTIM` int(11) NOT NULL DEFAULT ‘0’,
\n `SensorNo` tinyint(4) NOT NULL DEFAULT ‘0’,
\n `gettemp` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `kbn` tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘0:High 1:Low’,
\n PRIMARY KEY (`ID`)
\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;<\/p>\n

CREATE TABLE `HIGHLOW` (
\n `ID` int(11) NOT NULL AUTO_INCREMENT,
\n `TIM` int(11) NOT NULL DEFAULT ‘0’,
\n `UPTIM` int(11) NOT NULL DEFAULT ‘0’,
\n `SensorNo` tinyint(4) NOT NULL DEFAULT ‘0’,
\n `gettemp` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `kbn` tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘0:High 1:Low’,
\n PRIMARY KEY (`ID`)
\n) ENGINE=MyISAM AUTO_INCREMENT=3580 DEFAULT CHARSET=utf8;<\/p>\n

CREATE TABLE `AVGTEMP` (
\n `ID` int(11) NOT NULL AUTO_INCREMENT,
\n `UPTIM` int(11) NOT NULL DEFAULT ‘0’,
\n `gettemp0` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp1` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp2` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp3` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n PRIMARY KEY (`ID`)
\n) ENGINE=MyISAM AUTO_INCREMENT=2145 DEFAULT CHARSET=utf8;<\/p>\n

CREATE TABLE `MSI_Y` (
\n `ID` int(11) NOT NULL AUTO_INCREMENT,
\n `UPTIM` int(11) NOT NULL DEFAULT ‘0’,
\n `gettemp0` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp1` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp2` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp3` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `Weather` int(11) NOT NULL DEFAULT ‘0’,
\n PRIMARY KEY (`ID`)
\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;<\/p>\n

CREATE TABLE `MSI_M` (
\n `ID` int(11) NOT NULL AUTO_INCREMENT,
\n `UPTIM` int(11) NOT NULL DEFAULT ‘0’,
\n `gettemp0` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp1` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp2` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `gettemp3` decimal(5,2) NOT NULL DEFAULT ‘0.00’,
\n `Weather` int(11) NOT NULL DEFAULT ‘0’,
\n PRIMARY KEY (`ID`)
\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;<\/p>\n

CREATE TABLE `forecast` (
\n `ID` int(11) NOT NULL AUTO_INCREMENT,
\n `UPTIM` int(11) NOT NULL DEFAULT ‘0’,
\n `w_title` varchar(500) CHARACTER SET utf8 NOT NULL DEFAULT ”,
\n `w_publictime` varchar(500) CHARACTER SET utf8 NOT NULL DEFAULT ”,
\n `w_telop` varchar(500) CHARACTER SET utf8 NOT NULL DEFAULT ”,
\n `w_description` varchar(5000) CHARACTER SET utf8 NOT NULL DEFAULT ”,
\n `w_temp_max` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT ”,
\n `w_temp_min` varchar(100) CHARACTER SET utf8 NOT NULL DEFAULT ”,
\n `w_img` char(255) CHARACTER SET utf8 NOT NULL DEFAULT ”,
\n PRIMARY KEY (`ID`)
\n) ENGINE=MyISAM AUTO_INCREMENT=448 DEFAULT CHARSET=utf8;<\/p>\n

GRANT ALL PRIVILEGES ON *.* TO ‘gettemp’@’localhost’ IDENTIFIED
\nBY ‘%\u30d1\u30b9\u30ef\u30fc\u30c9%’ WITH GRANT OPTION;
\n[\/crayon]
\n\u5b9f\u969b\u306fdatabase.sql\u306a\u3069\u3068\u30d5\u30a1\u30a4\u30eb\u306b\u3057\u3066\u304a\u3044\u3066\u3001
\n#mysql -p -u root < database.sql\u3000\u3068\u3057\u3066\u5b9f\u884c\u3002\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"

ls-gl\u306b\u30ed\u30b0\u30a4\u30f3\u3057\u3001\u4e0b\u8a18\u3092\u5b9f\u884c\u3002 [crayon] CREATE DATABASE gettemp; USE gettemp; CREATE TABLE `MSI` ( `ID` int(11) NOT NULL A […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-1892","post","type-post","status-publish","format-standard","hentry","category-11"],"views":886,"_links":{"self":[{"href":"http:\/\/www.pinewell.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.pinewell.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.pinewell.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.pinewell.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.pinewell.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1892"}],"version-history":[{"count":0,"href":"http:\/\/www.pinewell.jp\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1892\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.pinewell.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.pinewell.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1892"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.pinewell.jp\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}