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");
        }
Example #2
0
 protected override void MainDbUpgrade()
 {
     SqLiteAlter.DropColumns("NamingConfig",
                             new[]
     {
         "Separator",
         "NumberStyle",
         "IncludeSeriesTitle",
         "IncludeEpisodeTitle",
         "IncludeQuality",
         "ReplaceSpaces"
     });
 }
        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");
        }
Example #4
0
 protected override void MainDbUpgrade()
 {
     SqLiteAlter.DropColumns("Episodes", new [] { "AirDate" });
 }
Example #5
0
 protected override void MainDbUpgrade()
 {
     SqLiteAlter.DropColumns("Episodes", new[] { "Ignored" });
     SqLiteAlter.DropColumns("Seasons", new[] { "Ignored" });
 }
Example #6
0
 protected override void MainDbUpgrade()
 {
     SqLiteAlter.DropColumns("Series", new[] { "CustomStartDate" });
 }
Example #7
0
 protected override void MainDbUpgrade()
 {
     SqLiteAlter.DropColumns("Series", new[] { "BacklogSetting" });
     SqLiteAlter.DropColumns("NamingConfig", new[] { "UseSceneName" });
 }