private void fnRecreate()
{
if (DB != null)
{
DB.Close(); DB.Dispose();
}
if (System.IO.File.Exists(tDB.Text + ".db"))
{
System.IO.File.Delete(tDB.Text + ".db");
}
SQLiteConnection.CreateFile(tDB.Text + ".db");
SQLiteConnection.CompressFile(tDB.Text + ".db");
DB = new SQLiteConnection("Data source=" + tDB.Text + ".db");
DB.Open();
using (SQLiteCommand DBc = DB.CreateCommand())
{
DBc.CommandText = "CREATE TABLE 'dickbutt' (" +
"'id' unsigned bigint(20), " +
"'hash' varchar(32), " +
"'tags' text)";
DBc.ExecuteNonQuery();
}
}
