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