Blame view

Vrh.iScheduler.Report/Migrations/201708281428381_Update03.cs 1.4 KB
ab9f2fbe   Schwirg László   Add project files.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
  namespace Vrh.iScheduler.Report.Lib.Migrations
  {
      using System;
      using System.Data.Entity.Migrations;
      
      public partial class Update03 : DbMigration
      {
          public override void Up()
          {
              DropIndex("dbo.SchedulerReportPackageItems", "IX_SchedulerReportPackageItems_SchedulerReportPackageId_ReportId_LCID");
              AddColumn("dbo.SchedulerReportPackageItems", "PresetId", c => c.String(nullable: false, maxLength: 50));
              AlterColumn("dbo.SchedulerReportPackageItems", "ExportType", c => c.String(nullable: false, maxLength: 10));
              CreateIndex("dbo.SchedulerReportPackageItems", new[] { "SchedulerReportPackageId", "ReportId", "LCID", "PresetId" }, unique: true, name: "IX_SchedulerReportPackageItems_SchedulerReportPackageId_ReportId_LCID_PresetId");
          }
          
          public override void Down()
          {
              DropIndex("dbo.SchedulerReportPackageItems", "IX_SchedulerReportPackageItems_SchedulerReportPackageId_ReportId_LCID_PresetId");
              AlterColumn("dbo.SchedulerReportPackageItems", "ExportType", c => c.String(nullable: false, maxLength: 30));
              DropColumn("dbo.SchedulerReportPackageItems", "PresetId");
              CreateIndex("dbo.SchedulerReportPackageItems", new[] { "SchedulerReportPackageId", "ReportId", "LCID" }, unique: true, name: "IX_SchedulerReportPackageItems_SchedulerReportPackageId_ReportId_LCID");
          }
      }
  }