protected override void MainDbUpgrade() { SqLiteAlter.DropColumns("NamingConfig", new[] { "SeasonFolderFormat" }); Execute.Sql("UPDATE NamingConfig SET RenameEpisodes = 1 WHERE RenameEpisodes = -1"); Execute.Sql("UPDATE NamingConfig SET RenameEpisodes = 0 WHERE RenameEpisodes = -2"); }
protected override void MainDbUpgrade() { SqLiteAlter.DropColumns("NamingConfig", new[] { "Separator", "NumberStyle", "IncludeSeriesTitle", "IncludeEpisodeTitle", "IncludeQuality", "ReplaceSpaces" }); }
protected override void MainDbUpgrade() { SqLiteAlter.AddIndexes("Series", new SQLiteIndex { Column = "TvdbId", Table = "Series", Unique = true }, new SQLiteIndex { Column = "TitleSlug", Table = "Series", Unique = true }); SqLiteAlter.AddIndexes("Episodes", new SQLiteIndex { Column = "TvDbEpisodeId", Table = "Episodes", Unique = true }); }
protected override void MainDbUpgrade() { SqLiteAlter.DropColumns("QualityProfiles", new[] { "Allowed" }); Alter.Column("Items").OnTable("QualityProfiles").AsString().NotNullable(); Create.TableForModel("QualityDefinitions") .WithColumn("Quality").AsInt32().Unique() .WithColumn("Title").AsString().Unique() .WithColumn("Weight").AsInt32().Unique() .WithColumn("MinSize").AsInt32() .WithColumn("MaxSize").AsInt32(); Execute.WithConnection(ConvertQualities); Delete.Table("QualitySizes"); }
protected override void MainDbUpgrade() { SqLiteAlter.DropColumns("Episodes", new [] { "AirDate" }); }
protected override void MainDbUpgrade() { SqLiteAlter.Nullify("Series", new[] { "ImdbId", "TitleSlug" }); }
protected override void MainDbUpgrade() { SqLiteAlter.DropColumns("Episodes", new[] { "Ignored" }); SqLiteAlter.DropColumns("Seasons", new[] { "Ignored" }); }
protected override void MainDbUpgrade() { SqLiteAlter.DropColumns("Series", new[] { "CustomStartDate" }); }
protected override void MainDbUpgrade() { SqLiteAlter.DropColumns("Series", new[] { "BacklogSetting" }); SqLiteAlter.DropColumns("NamingConfig", new[] { "UseSceneName" }); }