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); }