X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=create.sql;h=593cfccf746584cf14c9d86cd748d5b6ba400018;hb=93c26262fb1edaa3d67c01d24c3602a583eaad82;hp=dcc48a605cec94c4b33ac11ca2079dcaec303030;hpb=8bc7c158f64a9f91478ff0f981988f6e7e2ab6f1;p=zc

diff --git a/create.sql b/create.sql
index dcc48a6..593cfcc 100644
--- 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 ;