分好一级 二级 三级等等表 like this #talbe define rules:ColumnName DataType AllowNULLS #as to primarykey,1=PRIMARY KEY;2=PRIMARY KEY AND ANTO_INCREMENT#main table structure define MainTable: ID(2) INTEGER no AgentName TEXT no IPAddress TEXT no Port INTEGER no AgentTableName TEXT no StartTime TEXT no EndTime TEXT no #agent table structure define AgentTable: CounterId(1) TEXT no CounterName TEXT no CounterDesc TEXT yes CompressMode INTEGER no CounterDataTableName TEXT no #counter table structure define CounterTable: time(1) INTEGER no value REAL no
http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/02/4142971.aspx
like this #talbe define rules:ColumnName DataType AllowNULLS
#as to primarykey,1=PRIMARY KEY;2=PRIMARY KEY AND ANTO_INCREMENT#main table structure define
MainTable:
ID(2) INTEGER no
AgentName TEXT no
IPAddress TEXT no
Port INTEGER no
AgentTableName TEXT no
StartTime TEXT no
EndTime TEXT no
#agent table structure define
AgentTable:
CounterId(1) TEXT no
CounterName TEXT no
CounterDesc TEXT yes
CompressMode INTEGER no
CounterDataTableName TEXT no
#counter table structure define
CounterTable:
time(1) INTEGER no
value REAL no