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