ctnd/cfg/ctn_std.sql

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

  [en] INTEGER,

  [intv] INTEGER,

  [keep_day] INTEGER);
INSERT INTO snap VALUES(1,5,30);
CREATE TABLE [ies1000](

  [idx] INTEGER NOT NULL UNIQUE,

  [chan_idx] INTEGER,

  [info] TEXT(64),

  [adr] INTEGER);
INSERT INTO ies1000 VALUES(1,2,'pcs',0);
CREATE TABLE [dtsd1352](

  [idx] INTEGER NOT NULL UNIQUE,

  [chan_idx] INTEGER,

  [info] TEXT(32),

  [adr] INTEGER);
INSERT INTO dtsd1352 VALUES(1,1,'1#transf',2);
CREATE TABLE [meter]([model] TEXT(32));
INSERT INTO meter VALUES('adl200');
CREATE TABLE [ac]([model] TEXT(32));
INSERT INTO ac VALUES('evc');
CREATE TABLE [env]([model] TEXT(32));
INSERT INTO env VALUES('cd1f3300');
CREATE TABLE [rs_ws_n](

  [idx] INTEGER NOT NULL UNIQUE,

  [chan_idx] INTEGER,

  [info] TEXT(32),

  [adr] INTEGER);
INSERT INTO rs_ws_n VALUES(1,4,'1#Temp&Humi',1);
INSERT INTO rs_ws_n VALUES(2,4,'2#Temp&Humi',2);
INSERT INTO rs_ws_n VALUES(3,4,'3#Temp&Humi',3);
CREATE TABLE [plc]([model] TEXT(32));
INSERT INTO plc VALUES('simatic_s7');
CREATE TABLE [ups]([model] TEXT(32));
INSERT INTO ups VALUES('e3ks');
CREATE TABLE [e3ks](

  [idx] INTEGER,

  [chan_idx] INTEGER,

  [info] TEXT(32),

  [adr] INTEGER);
INSERT INTO e3ks VALUES(1,4,'ups',6);
CREATE TABLE [simatic_s7](

  [idx] INTEGER,

  [info] TEXT(32),

  [adr] INTEGER,

  [chan_idx] INTEGER);
INSERT INTO simatic_s7 VALUES(4,'plc',9,3);
CREATE TABLE IF NOT EXISTS "pack"(

  [model] TEXT(32),

  [info] TEXT(32));
INSERT INTO pack VALUES('gt','none');
CREATE TABLE [pcs](

  [model] TEXT(64),

  [info] TEXT(64));
INSERT INTO pcs VALUES('n9','none');
CREATE TABLE [mc90hdnc1a](

  [idx] INTEGER NOT NULL UNIQUE,

  [chan_idx] INTEGER,

  [info] TEXT(32),

  [adr] INTEGER);
INSERT INTO mc90hdnc1a VALUES(1,3,'1#ac',4);
INSERT INTO mc90hdnc1a VALUES(2,3,'2#ac',5);
CREATE TABLE [chan](

  [idx] INTEGER NOT NULL UNIQUE,

  [mode] TEXT(128),

  [info] TEXT(128),

  [dev] TEXT(64),

  [parity] TEXT(8),

  [baud] INTEGER,

  [port] INTEGER,

  [servip] TEXT(128),

  [servport] INTEGER,

  [retry_times] INTEGER,

  [restart_times] INTEGER);
INSERT INTO chan VALUES(1,'modbus_rtu','PCS','ttymxc1','N',9600,0,'192.168.2.10',602,2,2);
INSERT INTO chan VALUES(2,'modbus_rtu','bms','ttymxc2','N',9600,0,'192.168.2.11',602,2,2);
INSERT INTO chan VALUES(3,'modbus_rtu','other','ttymxc3','N',9600,0,'NULL',0,2,2);
INSERT INTO chan VALUES(4,'modbus_rtu','other','ttymxc5','N',9600,0,'NULL',0,2,2);
INSERT INTO chan VALUES(5,'di','gpio','488','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(6,'di','gpio','489','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(7,'di','gpio','490','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(8,'di','gpio','491','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(9,'di','gpio','134','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(10,'di','gpio','135','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(11,'di','gpio','136','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(12,'di','gpio','137','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(13,'do','gpio','480','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(14,'do','gpio','481','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(15,'do','gpio','482','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(16,'do','gpio','483','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(17,'do','gpio','484','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(18,'do','gpio','485','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(19,'do','gpio','486','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(20,'do','gpio','487','0',0,0,'0',0,0,0);
INSERT INTO chan VALUES(21,'socket_can','fa','can0','0',0,0,'0',0,3,3);
INSERT INTO chan VALUES(22,'socket_can','ac','can1','0',0,0,'0',0,3,3);
CREATE TABLE [catl280a](

  [idx] INTEGER NOT NULL UNIQUE,

  [chan_idx] INTEGER,

  [info] TEXT(64),

  [adr] INTEGER,

  [sub_nbr] INTEGER,

  [ovp] INTEGER,

  [uvp] INTEGER);
INSERT INTO catl280a VALUES(1,2,'280A bms',0,1,857,666);
CREATE TABLE [ctn](
  [model] TEXT(32));
INSERT INTO ctn VALUES('zh200');
CREATE TABLE [dlt645](

  [chan_idx] INTEGER,

  [address] TEXT(16),

  [info] TEXT(32),

  [pratio] DOUBLE,

  [vratio] DOUBLE,

  [cratio] DOUBLE);
INSERT INTO dlt645 VALUES(8,'123456789012','load-m',3000.0,346.41000000000002501,15.0);
CREATE TABLE [sga500e](

  [chan_idx] INTEGER,

  [info] TEXT(32),

  [adr] INTEGER);
INSERT INTO sga500e VALUES(4,'1#sga500e',1);
INSERT INTO sga500e VALUES(4,'2#sga500e',2);
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 [abb_b23_4](

  [idx] INTEGER NOT NULL UNIQUE,

  [chan_idx] INTEGER,

  [info] TEXT(32),

  [adr] INTEGER);
INSERT INTO abb_b23_4 VALUES(1,3,'#ctn',1);
INSERT INTO abb_b23_4 VALUES(2,3,'trasnf',1);
CREATE TABLE [ems](

  [reg_lo] DOUBLE,

  [reg_hi] DOUBLE,

  [reg_intv] INTEGER,

  [pcurv_idx] INTEGER,

  [transf_conm_model] TEXT(32),

  [transf_conm_idx] INTEGER,

  [transf_loadm_model] TEXT(32),

  [transf_loadm_idx] INTEGER,

  [factory_conm_model] TEXT(32),

  [factory_conm_idx] INTEGER,

  [factory_loadm_model] TEXT(32),

  [factory_loadm_idx] INTEGER);
INSERT INTO ems VALUES(50.0,1500.0,500,0,'na',0,'abb_b23_4',3,'abb_b23_4',0,'na',0);
CREATE TABLE [cal](

  [m_model] CHAR(20),

  [m_idx] INTEGER,

  [a1_chg] DOUBLE,

  [b1_chg] DOUBLE,

  [a2_chg] DOUBLE,

  [b2_chg] DOUBLE,

  [a1_dhg] DOUBLE,

  [b1_dhg] DOUBLE,

  [a2_dhg] DOUBLE,

  [b2_dhg] DOUBLE,

  [extre_P] DOUBLE);
INSERT INTO cal VALUES('abb_b23_4',1,-0.091399999999999995137,1998.5599999999999454,-0.33000000000000001554,2094.0,0.045699999999999997568,1749.7200000000000272,-0.28499999999999997557,1882.0,500.0);
CREATE TABLE [pws1](

  [idx] INTEGER NOT NULL UNIQUE,

  [chan_idx] INTEGER,

  [info] TEXT(64),

  [adr] INTEGER);
INSERT INTO pws1 VALUES(1,1,'#pcs',1);
CREATE TABLE [cess2000](

  [idx] INTEGER NOT NULL UNIQUE,

  [info] TEXT(32),

  [modbus_tcp_slave_port] INTEGER,

  [norm_cap] INTEGER,

  [norm_pow] INTEGER,

  [min_pow] INTEGER,

  [socd] DOUBLE,

  [socc] DOUBLE,

  [cell_otp] INTEGER,

  [cell_utp] INTEGER,

  [modbus_tcp_slave_port_EMA] INTEGER NOT NULL UNIQUE);
INSERT INTO cess2000 VALUES(1,'na',9527,200,100,5,-1.0,101.0,35,10,9528);
CREATE TABLE [fe]([model] TEXT(32));
INSERT INTO fe VALUES('rs311');
CREATE TABLE [dehumi]([model] TEXT(32));
INSERT INTO dehumi VALUES('sdcs');
CREATE TABLE [dido]([model] TEXT(32));
INSERT INTO dido VALUES('zlgmcu');
CREATE TABLE [fa]([model] TEXT(32));
INSERT INTO fa VALUES('cw1310');
CREATE TABLE [zlgmcu](
	"idx"	INTEGER,
  "chan_idx" INTEGER NOT NULL,
  "type" TEXT(32)
);
INSERT INTO zlgmcu VALUES(0,0,'dido');
INSERT INTO zlgmcu VALUES(1,5,'di');
INSERT INTO zlgmcu VALUES(2,6,'di');
INSERT INTO zlgmcu VALUES(3,7,'di');
INSERT INTO zlgmcu VALUES(4,8,'di');
INSERT INTO zlgmcu VALUES(5,9,'di');
INSERT INTO zlgmcu VALUES(6,10,'di');
INSERT INTO zlgmcu VALUES(7,11,'di');
INSERT INTO zlgmcu VALUES(8,12,'di');
INSERT INTO zlgmcu VALUES(1,13,'do');
INSERT INTO zlgmcu VALUES(2,14,'do');
INSERT INTO zlgmcu VALUES(3,15,'do');
INSERT INTO zlgmcu VALUES(4,16,'do');
CREATE TABLE IF NOT EXISTS "gt" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(64),
	"adr"	INTEGER,
	"sub_nbr"	INTEGER,
	"ovp"	INTEGER,
	"uvp"	INTEGER,
  "pack_nbr" INTEGER
);
INSERT INTO gt VALUES(1,2,'gt bms',1,1,923,728, 5);
CREATE TABLE IF NOT EXISTS "gtai" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(64),
	"adr"	INTEGER,
	"sub_nbr"	INTEGER,
	"ovp"	INTEGER,
	"uvp"	INTEGER
);
INSERT INTO gtai VALUES(1,22,'gtai bms',1,1,923,728);
CREATE TABLE IF NOT EXISTS "n9" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(64),
	"adr"	INTEGER
);
INSERT INTO n9 VALUES(1,1,'pcs',1);
CREATE TABLE IF NOT EXISTS "adl200" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER
);
INSERT INTO adl200 VALUES(1,1,'aux meter',7);
CREATE TABLE IF NOT EXISTS "yf2825" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER
);
INSERT INTO yf2825 VALUES(1,4,'fe yf2825',6);
CREATE TABLE IF NOT EXISTS "rs311" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER
);
INSERT INTO rs311 VALUES(1,0,'fe rs311',0);
CREATE TABLE IF NOT EXISTS "rh811ad053f" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER
);
INSERT INTO rh811ad053f VALUES(1,4,'th',2);
CREATE TABLE IF NOT EXISTS "cd1f3300" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER
);
INSERT INTO cd1f3300 VALUES(1,4,'co',5);
CREATE TABLE IF NOT EXISTS "sdcs" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER
);
INSERT INTO sdcs VALUES(1,4,'dehumi',1);
CREATE TABLE IF NOT EXISTS "mc0051gs" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER
);
INSERT INTO mc0051gs VALUES(1,3,'ac',4);
CREATE TABLE IF NOT EXISTS "tongfei" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER
);
INSERT INTO tongfei VALUES(1,3,'ac',1);
CREATE TABLE IF NOT EXISTS "evc" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER
);
INSERT INTO evc VALUES(1,22,'ac',0);
CREATE TABLE IF NOT EXISTS "zh200" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"info"	TEXT(32),
	"modbus_tcp_slave_port"	INTEGER,
	"norm_cap"	INTEGER,
	"norm_pow"	INTEGER,
	"min_pow"	INTEGER,
	"socd"	DOUBLE,
	"socc"	DOUBLE,
	"cell_otp"	INTEGER,
	"cell_utp"	INTEGER,
	"modbus_tcp_slave_port_EMA"	INTEGER NOT NULL UNIQUE,
	"min_v"	REAL,
	"max_v"	REAL
);
INSERT INTO zh200 VALUES(1,'ctn',9527,200,100,5,-1.0,101.0,42,10,9528,3.0,3.46);
CREATE TABLE IF NOT EXISTS "cw1310" (
	"idx"	INTEGER NOT NULL UNIQUE,
	"chan_idx"	INTEGER,
	"info"	TEXT(32),
	"adr"	INTEGER,
  "level1_co" INTEGER,
  "level1_voc" INTEGER,
  "level1_tmp" INTEGER,
  "level2_co" INTEGER,
  "level2_voc" INTEGER,
  "level2_tmp" INTEGER,
  "level3_co" INTEGER,
  "level3_voc" INTEGER,
  "level3_tmp" INTEGER,
  "level4_co" INTEGER,
  "level4_voc" INTEGER,
  "level4_tmp" INTEGER
);
INSERT INTO cw1310 VALUES(1,21,'fa pack 1',1,100,1000,60,190,1500,70,500,2000,80,500,2000,90);
INSERT INTO cw1310 VALUES(2,21,'fa pack 2',2,100,1000,60,190,1500,70,500,2000,80,500,2000,90);
INSERT INTO cw1310 VALUES(3,21,'fa pack 3',3,100,1000,60,190,1500,70,500,2000,80,500,2000,90);
INSERT INTO cw1310 VALUES(4,21,'fa pack 4',4,100,1000,60,190,1500,70,500,2000,80,500,2000,90);
INSERT INTO cw1310 VALUES(5,21,'fa pack 5',5,100,1000,60,190,1500,70,500,2000,80,500,2000,90);
COMMIT;