X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=create.sql;h=593cfccf746584cf14c9d86cd748d5b6ba400018;hb=49a2ecb401809105e5b1ccc23d1726b881195482;hp=84e9d6ee52c9839e6d8ff64547c1cb06aac1df82;hpb=8b75a44723dd56d826371d0a00bae64fe4f9e75e;p=zc

diff --git a/create.sql b/create.sql
index 84e9d6e..593cfcc 100644
--- a/create.sql
+++ b/create.sql
@@ -1,6 +1,6 @@
-drop table zc;
+--drop table zc;
 create table zc (
-	time timestamp without time zone default now(),
+	time timestamp with time zone default now(),
 	PN integer not null,
 	Alarm_axis smallint not null,
 	X_axis_angle float 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 ;