update offsets

[zc] / create.sql

diff --git a/create.sql b/create.sql
index 84e9d6e..593cfcc 100644 (file)
--- 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 ;