public static void CreateTable()
{
var table = new SQLiteTable("DBCONF");
var cols = new SQLiteColumnList();
cols.Add(new SQLiteColumn("id", ColType.Text, true, false, true, ""));
cols.Add(new SQLiteColumn("dbType"));
cols.Add(new SQLiteColumn("dbHost"));
cols.Add(new SQLiteColumn("dbPort"));
cols.Add(new SQLiteColumn("dbName"));
cols.Add(new SQLiteColumn("dbUserName"));
cols.Add(new SQLiteColumn("dbPassword"));
cols.Add(new SQLiteColumn("updateDate", ColType.DateTime));
table.SetCols(cols);
db.CreateTable(table);
table = new SQLiteTable("PATHCONF");
cols = new SQLiteColumnList();
cols.Add(new SQLiteColumn("code"));
cols.Add(new SQLiteColumn("name"));
cols.Add(new SQLiteColumn("value"));
table.SetCols(cols);
db.CreateTable(table);
}
public void AddColumn(SQLiteColumn item)
{
Columns.Add(item);
}