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