123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732 |
- 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;
|