{"id":10,"date":"2009-09-04T22:42:17","date_gmt":"2009-09-04T20:42:17","guid":{"rendered":"http:\/\/www.bretterhofer.at\/blog\/?page_id=10"},"modified":"2009-09-04T22:52:52","modified_gmt":"2009-09-04T20:52:52","slug":"maxmind-geoipcity","status":"publish","type":"page","link":"https:\/\/bretterhofer.at\/blog\/projects\/maxmind-geoipcity\/","title":{"rendered":"Maxmind GeoIPCity"},"content":{"rendered":"<p>Create Table for mysql with:<\/p>\n<pre>CREATE TABLE geo_ip (\r\nstart int(10) unsigned NOT NULL,\r\nend int(10) unsigned NOT NULL,\r\nci tinyint(3) unsigned NOT NULL\r\n);\r\n\r\nCREATE TABLE geo_ipcity (\r\nLOCID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 unsigned NOT NULL,\r\nCOUNTRY\u00a0\u00a0\u00a0\u00a0\u00a0 varchar(2) NOT NULL,\r\nREGION\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 varchar(2) ,\r\nCITY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 varchar(255) ,\r\nPOSTALCODE\u00a0\u00a0\u00a0\u00a0 varchar(6) ,\r\nLATITUDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DECIMAL(10,6),\r\nLONGITUDE\u00a0\u00a0\u00a0\u00a0\u00a0 DECIMAL(10,6),\r\nDMACODE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 varchar(3) ,\r\nAREACODE\u00a0\u00a0\u00a0\u00a0 varchar(3)\r\n);<\/pre>\n<p>mysql<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create Table for mysql with: CREATE TABLE geo_ip ( start int(10) unsigned NOT NULL, end int(10) unsigned NOT NULL, ci tinyint(3) unsigned NOT NULL );<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":6,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/pages\/10"}],"collection":[{"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/comments?post=10"}],"version-history":[{"count":2,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/pages\/10\/revisions"}],"predecessor-version":[{"id":13,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/pages\/10\/revisions\/13"}],"up":[{"embeddable":true,"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/pages\/6"}],"wp:attachment":[{"href":"https:\/\/bretterhofer.at\/blog\/wp-json\/wp\/v2\/media?parent=10"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}