/// <summary> /// Create SQL Tables if they dont already exist /// </summary> public Task Init() { string sql = @"CREATE TABLE IF NOT EXISTS [DiscordApiKey]( [ServerName] VARCHAR PRIMARY KEY ON CONFLICT REPLACE NOT NULL UNIQUE, [ApiKey] VARCHAR NOT NULL);"; return(_db.CreateTable(sql)); }
/// <summary> /// Creates the table used by this class if it does not exist /// </summary> public Task Init() { string sql = @"CREATE TABLE IF NOT EXISTS [CommandHistory]( [OccuredAt] DATETIME, [CommandName] VARCHAR, [Author] VARCHAR, [Channel] VARCHAR, [Succeeded] BOOLEAN, [Result] VARCHAR )"; return(_db.CreateTable(sql)); }