private static void CreateMasteryTable(SqliteConnection con, bool force = false)
{
MasteryTable masteryTable = new MasteryTable();
CreateTable(con, masteryTable, force);
if (IsEmpty(con, masteryTable))
{
MasteryItem defaultUnset = new MasteryItem("Unset", true, "#F0FDFA")
{
Id = DefaultMasteryId
};
MasteryItem defaultBeginner = new MasteryItem("Beginner", true, "#D8F4EF");
MasteryItem defaultIntermediate = new MasteryItem("Intermediate", true, "#B7ECEA");
MasteryItem defaultAdvanced = new MasteryItem("Advanced", true, "#97DEE7");
MasteryItem defaultMastered = new MasteryItem("Mastered", true, "#78C5DC");
InsertRows(con, masteryTable, new BaseModelItem[] { defaultUnset, defaultBeginner, defaultIntermediate, defaultAdvanced, defaultMastered });
}
}
public SongTable() : base("Song")
{
MasteryTable masteryTable = new MasteryTable();
MasteryId = new SqlColumn("MasteryID", EType.Int, masteryTable.TableName, masteryTable.Id.Name, false);
}
