sta/cfg/sta_2ctn_std.sql

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE [snap](

  [en] INTEGER, 

  [intv] INTEGER, 

  [keep_day] INTEGER);
INSERT INTO snap VALUES(1,4,100);
CREATE TABLE [chan](

  [idx] INTEGER NOT NULL UNIQUE, 

  [mode] TEXT(128), 

  [info] TEXT(128), 

  [dev] TEXT(64), 

  [baud] INTEGER, 

  [parity] TEXT(8), 

  [port] INTEGER, 

  [servip] TEXT(128), 

  [servport] INTEGER);
INSERT INTO chan VALUES(1,'modbus_tcp','ctn1','na',0,'na',0,'192.168.0.137',9527);
INSERT INTO chan VALUES(2,'modbus_tcp','ctn2','na',0,'na',0,'192.168.0.138',9527);
INSERT INTO chan VALUES(3,'modbus_rtu','ctn-meter','ttymxc1',9600,'N',0,'0',0);
-- INSERT INTO chan VALUES(3,'modbus_rtu_tcp','conn-m1','na',0,'na',0,'10.8.0.53',54321);
-- INSERT INTO chan VALUES(4,'modbus_rtu_tcp','conn-m2','na',0,'na',0,'10.8.0.53',54322);
CREATE TABLE [timeseg](
  [idx] INTEGER, 
  [hour] INTEGER, 
  [minute] INTEGER, 
  [segtype] INTEGER);
INSERT INTO timeseg VALUES(1,0,0,4);
INSERT INTO timeseg VALUES(1,0,5,4);
INSERT INTO timeseg VALUES(1,0,10,4);
INSERT INTO timeseg VALUES(1,0,15,4);
INSERT INTO timeseg VALUES(1,0,20,4);
INSERT INTO timeseg VALUES(1,0,25,4);
INSERT INTO timeseg VALUES(1,0,30,4);
INSERT INTO timeseg VALUES(1,0,35,4);
INSERT INTO timeseg VALUES(1,0,40,4);
INSERT INTO timeseg VALUES(1,0,45,4);
INSERT INTO timeseg VALUES(1,0,50,4);
INSERT INTO timeseg VALUES(1,0,55,4);
INSERT INTO timeseg VALUES(1,1,0,4);
INSERT INTO timeseg VALUES(1,1,5,4);
INSERT INTO timeseg VALUES(1,1,10,4);
INSERT INTO timeseg VALUES(1,1,15,4);
INSERT INTO timeseg VALUES(1,1,20,4);
INSERT INTO timeseg VALUES(1,1,25,4);
INSERT INTO timeseg VALUES(1,1,30,4);
INSERT INTO timeseg VALUES(1,1,35,4);
INSERT INTO timeseg VALUES(1,1,40,4);
INSERT INTO timeseg VALUES(1,1,45,4);
INSERT INTO timeseg VALUES(1,1,50,4);
INSERT INTO timeseg VALUES(1,1,55,4);
INSERT INTO timeseg VALUES(1,2,0,4);
INSERT INTO timeseg VALUES(1,2,5,4);
INSERT INTO timeseg VALUES(1,2,10,4);
INSERT INTO timeseg VALUES(1,2,15,4);
INSERT INTO timeseg VALUES(1,2,20,4);
INSERT INTO timeseg VALUES(1,2,25,4);
INSERT INTO timeseg VALUES(1,2,30,4);
INSERT INTO timeseg VALUES(1,2,35,4);
INSERT INTO timeseg VALUES(1,2,40,4);
INSERT INTO timeseg VALUES(1,2,45,4);
INSERT INTO timeseg VALUES(1,2,50,4);
INSERT INTO timeseg VALUES(1,2,55,4);
INSERT INTO timeseg VALUES(1,3,0,4);
INSERT INTO timeseg VALUES(1,3,5,4);
INSERT INTO timeseg VALUES(1,3,10,4);
INSERT INTO timeseg VALUES(1,3,15,4);
INSERT INTO timeseg VALUES(1,3,20,4);
INSERT INTO timeseg VALUES(1,3,25,4);
INSERT INTO timeseg VALUES(1,3,30,4);
INSERT INTO timeseg VALUES(1,3,35,4);
INSERT INTO timeseg VALUES(1,3,40,4);
INSERT INTO timeseg VALUES(1,3,45,4);
INSERT INTO timeseg VALUES(1,3,50,4);
INSERT INTO timeseg VALUES(1,3,55,4);
INSERT INTO timeseg VALUES(1,4,0,4);
INSERT INTO timeseg VALUES(1,4,5,4);
INSERT INTO timeseg VALUES(1,4,10,4);
INSERT INTO timeseg VALUES(1,4,15,4);
INSERT INTO timeseg VALUES(1,4,20,4);
INSERT INTO timeseg VALUES(1,4,25,4);
INSERT INTO timeseg VALUES(1,4,30,4);
INSERT INTO timeseg VALUES(1,4,35,4);
INSERT INTO timeseg VALUES(1,4,40,4);
INSERT INTO timeseg VALUES(1,4,45,4);
INSERT INTO timeseg VALUES(1,4,50,4);
INSERT INTO timeseg VALUES(1,4,55,4);
INSERT INTO timeseg VALUES(1,5,0,4);
INSERT INTO timeseg VALUES(1,5,5,4);
INSERT INTO timeseg VALUES(1,5,10,4);
INSERT INTO timeseg VALUES(1,5,15,4);
INSERT INTO timeseg VALUES(1,5,20,4);
INSERT INTO timeseg VALUES(1,5,25,4);
INSERT INTO timeseg VALUES(1,5,30,4);
INSERT INTO timeseg VALUES(1,5,35,4);
INSERT INTO timeseg VALUES(1,5,40,4);
INSERT INTO timeseg VALUES(1,5,45,4);
INSERT INTO timeseg VALUES(1,5,50,4);
INSERT INTO timeseg VALUES(1,5,55,4);
INSERT INTO timeseg VALUES(1,6,0,4);
INSERT INTO timeseg VALUES(1,6,5,4);
INSERT INTO timeseg VALUES(1,6,10,4);
INSERT INTO timeseg VALUES(1,6,15,4);
INSERT INTO timeseg VALUES(1,6,20,4);
INSERT INTO timeseg VALUES(1,6,25,4);
INSERT INTO timeseg VALUES(1,6,30,4);
INSERT INTO timeseg VALUES(1,6,35,4);
INSERT INTO timeseg VALUES(1,6,40,4);
INSERT INTO timeseg VALUES(1,6,45,4);
INSERT INTO timeseg VALUES(1,6,50,4);
INSERT INTO timeseg VALUES(1,6,55,4);
INSERT INTO timeseg VALUES(1,7,0,4);
INSERT INTO timeseg VALUES(1,7,5,4);
INSERT INTO timeseg VALUES(1,7,10,4);
INSERT INTO timeseg VALUES(1,7,15,4);
INSERT INTO timeseg VALUES(1,7,20,4);
INSERT INTO timeseg VALUES(1,7,25,4);
INSERT INTO timeseg VALUES(1,7,30,4);
INSERT INTO timeseg VALUES(1,7,35,4);
INSERT INTO timeseg VALUES(1,7,40,4);
INSERT INTO timeseg VALUES(1,7,45,4);
INSERT INTO timeseg VALUES(1,7,50,4);
INSERT INTO timeseg VALUES(1,7,55,4);
INSERT INTO timeseg VALUES(1,8,0,3);
INSERT INTO timeseg VALUES(1,8,5,3);
INSERT INTO timeseg VALUES(1,8,10,3);
INSERT INTO timeseg VALUES(1,8,15,3);
INSERT INTO timeseg VALUES(1,8,20,3);
INSERT INTO timeseg VALUES(1,8,25,3);
INSERT INTO timeseg VALUES(1,8,30,3);
INSERT INTO timeseg VALUES(1,8,35,3);
INSERT INTO timeseg VALUES(1,8,40,3);
INSERT INTO timeseg VALUES(1,8,45,3);
INSERT INTO timeseg VALUES(1,8,50,3);
INSERT INTO timeseg VALUES(1,8,55,3);
INSERT INTO timeseg VALUES(1,9,0,3);
INSERT INTO timeseg VALUES(1,9,5,3);
INSERT INTO timeseg VALUES(1,9,10,3);
INSERT INTO timeseg VALUES(1,9,15,3);
INSERT INTO timeseg VALUES(1,9,20,3);
INSERT INTO timeseg VALUES(1,9,25,3);
INSERT INTO timeseg VALUES(1,9,30,3);
INSERT INTO timeseg VALUES(1,9,35,3);
INSERT INTO timeseg VALUES(1,9,40,3);
INSERT INTO timeseg VALUES(1,9,45,3);
INSERT INTO timeseg VALUES(1,9,50,3);
INSERT INTO timeseg VALUES(1,9,55,3);
INSERT INTO timeseg VALUES(1,10,0,2);
INSERT INTO timeseg VALUES(1,10,5,2);
INSERT INTO timeseg VALUES(1,10,10,2);
INSERT INTO timeseg VALUES(1,10,15,2);
INSERT INTO timeseg VALUES(1,10,20,2);
INSERT INTO timeseg VALUES(1,10,25,2);
INSERT INTO timeseg VALUES(1,10,30,2);
INSERT INTO timeseg VALUES(1,10,35,2);
INSERT INTO timeseg VALUES(1,10,40,2);
INSERT INTO timeseg VALUES(1,10,45,2);
INSERT INTO timeseg VALUES(1,10,50,2);
INSERT INTO timeseg VALUES(1,10,55,2);
INSERT INTO timeseg VALUES(1,11,0,2);
INSERT INTO timeseg VALUES(1,11,5,2);
INSERT INTO timeseg VALUES(1,11,10,2);
INSERT INTO timeseg VALUES(1,11,15,2);
INSERT INTO timeseg VALUES(1,11,20,2);
INSERT INTO timeseg VALUES(1,11,25,2);
INSERT INTO timeseg VALUES(1,11,30,2);
INSERT INTO timeseg VALUES(1,11,35,2);
INSERT INTO timeseg VALUES(1,11,40,2);
INSERT INTO timeseg VALUES(1,11,45,2);
INSERT INTO timeseg VALUES(1,11,50,2);
INSERT INTO timeseg VALUES(1,11,55,2);
INSERT INTO timeseg VALUES(1,12,0,3);
INSERT INTO timeseg VALUES(1,12,5,3);
INSERT INTO timeseg VALUES(1,12,10,3);
INSERT INTO timeseg VALUES(1,12,15,3);
INSERT INTO timeseg VALUES(1,12,20,3);
INSERT INTO timeseg VALUES(1,12,25,3);
INSERT INTO timeseg VALUES(1,12,30,3);
INSERT INTO timeseg VALUES(1,12,35,3);
INSERT INTO timeseg VALUES(1,12,40,3);
INSERT INTO timeseg VALUES(1,12,45,3);
INSERT INTO timeseg VALUES(1,12,50,3);
INSERT INTO timeseg VALUES(1,12,55,3);
INSERT INTO timeseg VALUES(1,13,0,3);
INSERT INTO timeseg VALUES(1,13,5,3);
INSERT INTO timeseg VALUES(1,13,10,3);
INSERT INTO timeseg VALUES(1,13,15,3);
INSERT INTO timeseg VALUES(1,13,20,3);
INSERT INTO timeseg VALUES(1,13,25,3);
INSERT INTO timeseg VALUES(1,13,30,3);
INSERT INTO timeseg VALUES(1,13,35,3);
INSERT INTO timeseg VALUES(1,13,40,3);
INSERT INTO timeseg VALUES(1,13,45,3);
INSERT INTO timeseg VALUES(1,13,50,3);
INSERT INTO timeseg VALUES(1,13,55,3);
INSERT INTO timeseg VALUES(1,14,0,2);
INSERT INTO timeseg VALUES(1,14,5,2);
INSERT INTO timeseg VALUES(1,14,10,2);
INSERT INTO timeseg VALUES(1,14,15,2);
INSERT INTO timeseg VALUES(1,14,20,2);
INSERT INTO timeseg VALUES(1,14,25,2);
INSERT INTO timeseg VALUES(1,14,30,2);
INSERT INTO timeseg VALUES(1,14,35,2);
INSERT INTO timeseg VALUES(1,14,40,2);
INSERT INTO timeseg VALUES(1,14,45,2);
INSERT INTO timeseg VALUES(1,14,50,2);
INSERT INTO timeseg VALUES(1,14,55,2);
INSERT INTO timeseg VALUES(1,15,0,2);
INSERT INTO timeseg VALUES(1,15,5,2);
INSERT INTO timeseg VALUES(1,15,10,2);
INSERT INTO timeseg VALUES(1,15,15,2);
INSERT INTO timeseg VALUES(1,15,20,2);
INSERT INTO timeseg VALUES(1,15,25,2);
INSERT INTO timeseg VALUES(1,15,30,2);
INSERT INTO timeseg VALUES(1,15,35,2);
INSERT INTO timeseg VALUES(1,15,40,2);
INSERT INTO timeseg VALUES(1,15,45,2);
INSERT INTO timeseg VALUES(1,15,50,2);
INSERT INTO timeseg VALUES(1,15,55,2);
INSERT INTO timeseg VALUES(1,16,0,2);
INSERT INTO timeseg VALUES(1,16,5,2);
INSERT INTO timeseg VALUES(1,16,10,2);
INSERT INTO timeseg VALUES(1,16,15,2);
INSERT INTO timeseg VALUES(1,16,20,2);
INSERT INTO timeseg VALUES(1,16,25,2);
INSERT INTO timeseg VALUES(1,16,30,2);
INSERT INTO timeseg VALUES(1,16,35,2);
INSERT INTO timeseg VALUES(1,16,40,2);
INSERT INTO timeseg VALUES(1,16,45,2);
INSERT INTO timeseg VALUES(1,16,50,2);
INSERT INTO timeseg VALUES(1,16,55,2);
INSERT INTO timeseg VALUES(1,17,0,2);
INSERT INTO timeseg VALUES(1,17,5,2);
INSERT INTO timeseg VALUES(1,17,10,2);
INSERT INTO timeseg VALUES(1,17,15,2);
INSERT INTO timeseg VALUES(1,17,20,2);
INSERT INTO timeseg VALUES(1,17,25,2);
INSERT INTO timeseg VALUES(1,17,30,2);
INSERT INTO timeseg VALUES(1,17,35,2);
INSERT INTO timeseg VALUES(1,17,40,2);
INSERT INTO timeseg VALUES(1,17,45,2);
INSERT INTO timeseg VALUES(1,17,50,2);
INSERT INTO timeseg VALUES(1,17,55,2);
INSERT INTO timeseg VALUES(1,18,0,2);
INSERT INTO timeseg VALUES(1,18,5,2);
INSERT INTO timeseg VALUES(1,18,10,2);
INSERT INTO timeseg VALUES(1,18,15,2);
INSERT INTO timeseg VALUES(1,18,20,2);
INSERT INTO timeseg VALUES(1,18,25,2);
INSERT INTO timeseg VALUES(1,18,30,2);
INSERT INTO timeseg VALUES(1,18,35,2);
INSERT INTO timeseg VALUES(1,18,40,2);
INSERT INTO timeseg VALUES(1,18,45,2);
INSERT INTO timeseg VALUES(1,18,50,2);
INSERT INTO timeseg VALUES(1,18,55,2);
INSERT INTO timeseg VALUES(1,19,0,3);
INSERT INTO timeseg VALUES(1,19,5,3);
INSERT INTO timeseg VALUES(1,19,10,3);
INSERT INTO timeseg VALUES(1,19,15,3);
INSERT INTO timeseg VALUES(1,19,20,3);
INSERT INTO timeseg VALUES(1,19,25,3);
INSERT INTO timeseg VALUES(1,19,30,3);
INSERT INTO timeseg VALUES(1,19,35,3);
INSERT INTO timeseg VALUES(1,19,40,3);
INSERT INTO timeseg VALUES(1,19,45,3);
INSERT INTO timeseg VALUES(1,19,50,3);
INSERT INTO timeseg VALUES(1,19,55,3);
INSERT INTO timeseg VALUES(1,20,0,3);
INSERT INTO timeseg VALUES(1,20,5,3);
INSERT INTO timeseg VALUES(1,20,10,3);
INSERT INTO timeseg VALUES(1,20,15,3);
INSERT INTO timeseg VALUES(1,20,20,3);
INSERT INTO timeseg VALUES(1,20,25,3);
INSERT INTO timeseg VALUES(1,20,30,3);
INSERT INTO timeseg VALUES(1,20,35,3);
INSERT INTO timeseg VALUES(1,20,40,3);
INSERT INTO timeseg VALUES(1,20,45,3);
INSERT INTO timeseg VALUES(1,20,50,3);
INSERT INTO timeseg VALUES(1,20,55,3);
INSERT INTO timeseg VALUES(1,21,0,3);
INSERT INTO timeseg VALUES(1,21,5,3);
INSERT INTO timeseg VALUES(1,21,10,3);
INSERT INTO timeseg VALUES(1,21,15,3);
INSERT INTO timeseg VALUES(1,21,20,3);
INSERT INTO timeseg VALUES(1,21,25,3);
INSERT INTO timeseg VALUES(1,21,30,3);
INSERT INTO timeseg VALUES(1,21,35,3);
INSERT INTO timeseg VALUES(1,21,40,3);
INSERT INTO timeseg VALUES(1,21,45,3);
INSERT INTO timeseg VALUES(1,21,50,3);
INSERT INTO timeseg VALUES(1,21,55,3);
INSERT INTO timeseg VALUES(1,22,0,3);
INSERT INTO timeseg VALUES(1,22,5,3);
INSERT INTO timeseg VALUES(1,22,10,3);
INSERT INTO timeseg VALUES(1,22,15,3);
INSERT INTO timeseg VALUES(1,22,20,3);
INSERT INTO timeseg VALUES(1,22,25,3);
INSERT INTO timeseg VALUES(1,22,30,3);
INSERT INTO timeseg VALUES(1,22,35,3);
INSERT INTO timeseg VALUES(1,22,40,3);
INSERT INTO timeseg VALUES(1,22,45,3);
INSERT INTO timeseg VALUES(1,22,50,3);
INSERT INTO timeseg VALUES(1,22,55,3);
INSERT INTO timeseg VALUES(1,23,0,3);
INSERT INTO timeseg VALUES(1,23,5,3);
INSERT INTO timeseg VALUES(1,23,10,3);
INSERT INTO timeseg VALUES(1,23,15,3);
INSERT INTO timeseg VALUES(1,23,20,3);
INSERT INTO timeseg VALUES(1,23,25,3);
INSERT INTO timeseg VALUES(1,23,30,3);
INSERT INTO timeseg VALUES(1,23,35,3);
INSERT INTO timeseg VALUES(1,23,40,3);
INSERT INTO timeseg VALUES(1,23,45,3);
INSERT INTO timeseg VALUES(1,23,50,3);
INSERT INTO timeseg VALUES(1,23,55,3);
CREATE TABLE [ems](

  [reg_lo] DOUBLE, 

  [reg_hi] DOUBLE, 

  [reg_intv] INTEGER, 

  [conm_model] TEXT(32), 

  [conm_idx] INTEGER, 

  [loadm_model] TEXT(32), 

  [loadm_idx] INTEGER, 

  [pcurv_idx] INTEGER);
INSERT INTO ems VALUES(50.0,1000.0,10,'na',0,'dtsd1352',1,0);
CREATE TABLE [dtsd1352](
  [idx] INTEGER NOT NULL UNIQUE, 
  [chan_idx] INTEGER, 
  [info] TEXT(32), 
  [adr] INTEGER,  
  [limit_low] INTEGER,
  [limit_high] INTEGER,
  [type] INTEGER
);
-- INSERT INTO dtsd1352 VALUES(1,5,'pv meter',3,-9999999,9999999, 15);
INSERT INTO dtsd1352 VALUES(2,3,'conn meter 1',6,-460,460, 13);
INSERT INTO dtsd1352 VALUES(3,3,'conn meter 2',3,-360,360, 13);
-- INSERT INTO dtsd1352 VALUES(4,3,'ctn meter 1',4,-9999999,9999999, 12);
-- INSERT INTO dtsd1352 VALUES(5,4,'ctn meter 2',5,-9999999,9999999, 12);
CREATE TABLE IF NOT EXISTS "zh200" (
	"info"	TEXT(32),
	"chan_idx"	INTEGER,
	"adr"	INTEGER
);
INSERT INTO zh200 VALUES('1#',1,0);
INSERT INTO zh200 VALUES('2#',2,0);
CREATE TABLE IF NOT EXISTS "ctn" (
	"model"	TEXT(32)
);
INSERT INTO ctn VALUES('zh200');
CREATE TABLE IF NOT EXISTS "meter" (
	"model"	TEXT(32)
);
INSERT INTO meter VALUES('dtsd1352');
COMMIT;