added index on pn

diff --git a/create.sql b/create.sql
index dcc48a6..593cfcc 100644 (file)
--- a/create.sql
+++ b/create.sql
@@ -1,4 +1,4 @@
-drop table zc;
+--drop table zc;
 create table zc (
        time timestamp with time zone default now(),
        PN integer not null,
@@ -13,5 +13,7 @@ create table zc (
        _id serial
 );
 
+create index zc_pn on zc(pn) ;
+
 create user grafana password 'readonly' ;
 grant select on zc to  grafana ;