From b624c3acd773e276b41adf274985c3a0fe9e70e5 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Tue, 12 Dec 2017 20:26:46 +0000
Subject: [PATCH] lib/php/db/table.php

---
 lib/php/db.php          |  1 -
 lib/php/db/table.php    |  5 -----
 share/sql/host_info.sql | 13 +++++++++++++
 3 files changed, 13 insertions(+), 6 deletions(-)
 create mode 100644 share/sql/host_info.sql

diff --git a/lib/php/db.php b/lib/php/db.php
index 03bea9f5..45acaf4e 100644
--- a/lib/php/db.php
+++ b/lib/php/db.php
@@ -217,7 +217,6 @@ class Db extends nb {
         'name' => 'dbname',
         'charset' => 'charset',
       ] as $k => $v) {
-        #self::debug([$k,$this->$k]);
         if ($v=='charset' and $this->type=='pgsql') continue;
         if (empty($this->$k)) continue;
         $this->pdo = preg_replace("/\b$v=[^;]*(;|$)/","",$this->pdo);
diff --git a/lib/php/db/table.php b/lib/php/db/table.php
index c6f453b5..4129e24c 100644
--- a/lib/php/db/table.php
+++ b/lib/php/db/table.php
@@ -1636,11 +1636,6 @@ Class Table extends nb {
 
     $info['rowCount'] = $query->rowCount();
     return $query->rowCount();
-# NB 19.10.17 
-# NB 19.10.17     return $execute;
-# NB 19.10.17 
-# NB 19.10.17     return $this->db()->exec($sql,$values);
-# NB 19.10.17     return $this->db()->exec($sql);
   }
 
   public function update($post,&$info=[]) {
diff --git a/share/sql/host_info.sql b/share/sql/host_info.sql
new file mode 100644
index 00000000..62aeb019
--- /dev/null
+++ b/share/sql/host_info.sql
@@ -0,0 +1,13 @@
+DROP TABLE IF EXISTS host_info;
+CREATE TABLE host_info (
+	host VARCHAR(200),	
+	key VARCHAR(100) NOT NULL,	
+	val VARCHAR(500) NOT NULL,	
+	created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+	PRIMARY KEY (host,key,created)
+);
+CREATE INDEX IF NOT EXISTS host_info_host ON host_info USING btree (host);
+CREATE INDEX IF NOT EXISTS host_info_key ON host_info USING btree (key);
+CREATE INDEX IF NOT EXISTS host_info_val ON host_info USING btree (val);
+CREATE INDEX IF NOT EXISTS host_info_created ON host_info USING btree (created);
+GRANT ALL ON host_info TO www;
-- 
2.47.3