private void CreateTables()
{
var queryable = new SQLiteQueryableConnection(this.connectionstring);
queryable.Connect();
var tables = queryable.ListTableNames();
if (!tables.Contains("connection"))
{
var ddl =
"CREATE TABLE `connection` (" +
" `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT," +
" `type` INTEGER NOT NULL DEFAULT 1," +
" `name` TEXT NOT NULL," +
" `host` TEXT NOT NULL," +
" `port` INTEGER NOT NULL," +
" `username` TEXT NOT NULL," +
" `password` TEXT NOT NULL," +
" `databasename` TEXT NOT NULL," +
" `extraparams` TEXT NOT NULL" +
"); ";
ExecuteDDL(ddl);
}
if (!tables.Contains("query"))
{
var ddl =
"CREATE TABLE `query` (" +
" `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT," +
" `connection_id` INTEGER NOT NULL," +
" `name` TEXT NOT NULL," +
" `sqltext` TEXT NOT NULL" +
" ); ";
ExecuteDDL(ddl);
}
}
private void CreateTables()
{
var queryable = new SQLiteQueryableConnection(this.connectionstring);
queryable.Connect();
var tables = queryable.ListTableNames();
if (!tables.Contains("connection"))
{
var ddl =
"CREATE TABLE `connection` (" +
" `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT," +
" `type` INTEGER NOT NULL DEFAULT 1," +
" `name` TEXT NOT NULL," +
" `host` TEXT NOT NULL," +
" `port` INTEGER NOT NULL," +
" `username` TEXT NOT NULL," +
" `password` TEXT NOT NULL," +
" `databasename` TEXT NOT NULL," +
" `extraparams` TEXT NOT NULL" +
"); ";
ExecuteDDL(ddl);
}
if (!tables.Contains("query"))
{
var ddl =
"CREATE TABLE `query` (" +
" `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT," +
" `connection_id` INTEGER NOT NULL," +
" `name` TEXT NOT NULL," +
" `sqltext` TEXT NOT NULL" +
" ); ";
ExecuteDDL(ddl);
}
}
