From 8155f8deadc605497882ce845522e5ff9ad96801 Mon Sep 17 00:00:00 2001 From: Nicolas Boisselier Date: Thu, 4 Jan 2018 15:39:34 +0000 Subject: [PATCH] www/dbq/dbq.php --- etc/dbq/000-local.php | 10 ---------- share/sql/zipcode.sql | 4 ++-- 2 files changed, 2 insertions(+), 12 deletions(-) diff --git a/etc/dbq/000-local.php b/etc/dbq/000-local.php index 0a39675f..412871ca 100644 --- a/etc/dbq/000-local.php +++ b/etc/dbq/000-local.php @@ -8,16 +8,6 @@ $DBQ = [ 'name' => 'Nb', 'default_table' => 'mime', 'host' => nb::ROOT_DIR.'/share/db/nb.db', - - 'tables' => [ - '_country' => [ - 'row_parse_post' => ( nb::php_cli() or nb::client_content_type('text/plain') != 'text/html' ) ? null : function(&$r,$t) { - $r['zaza'] = 'zaza'; - bye('zaza'); - return; - }, - ], - ], ], ]; diff --git a/share/sql/zipcode.sql b/share/sql/zipcode.sql index 2b76372e..36172f38 100644 --- a/share/sql/zipcode.sql +++ b/share/sql/zipcode.sql @@ -1,4 +1,4 @@ --- DROP TABLE IF EXISTS zipcode; +DROP TABLE IF EXISTS zipcode; CREATE TABLE IF NOT EXISTS zipcode ( id varchar(20), country varchar(2), @@ -9,7 +9,7 @@ CREATE TABLE IF NOT EXISTS zipcode ( province_code varchar(20), community varchar(100), community_code varchar(20), - latitue numeric(7,4), + latitude numeric(7,4), longitude numeric(7,4), accuracy smallint -- PRIMARY KEY(id,country) -- 2.47.3