public void Create()
{
string query = "CREATE TABLE Info " +
"(" +
"Id INTEGER PRIMARY KEY AUTOINCREMENT," +
"Description VARCHAR(80), " +
"Timestamp DATETIME" +
")";
_connection.ExecuteNonQuery(query);
}
/// <summary>
/// Messsage tábla létrehozása
/// </summary>
public void Create()
{
string query = "CREATE TABLE Messages " +
"(" +
"Id INTEGER PRIMARY KEY AUTOINCREMENT," +
"Name VARCHAR(80), " +
"Timestamp BIGINT," +
"Direction VARCHAR(20)," +
"Type VARCHAR(10)," +
"ArbitrationId INT," +
"IsRemote BOOL NOT NULL," +
"Data VARCHAR(80)," +
"Documentation VARCHAR(80)," +
"Description VARCHAR(80) " +
")";
_connection.ExecuteNonQuery(query);
}