Blame view

Vrh.iScheduler.Report/Migrations/201911221620053_ChangeSchemaName.cs 1.23 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 ChangeSchemaName : DbMigration
      {
          public override void Up()
          {
              MoveTable(name: "dbo.SchedulerReportPackageItems", newSchema: "iSchedulerReports");
              MoveTable(name: "dbo.SchedulerReportPackages", newSchema: "iSchedulerReports");
              DropForeignKey("dbo.SchedulerReportPackageItems", "SchedulerReportPackageId", "dbo.SchedulerReportPackages");
              AddForeignKey("iSchedulerReports.SchedulerReportPackageItems", "SchedulerReportPackageId", "iSchedulerReports.SchedulerReportPackages", "Id");
          }
          
          public override void Down()
          {
              DropForeignKey("iSchedulerReports.SchedulerReportPackageItems", "SchedulerReportPackageId", "iSchedulerReports.SchedulerReportPackages");
              AddForeignKey("dbo.SchedulerReportPackageItems", "SchedulerReportPackageId", "dbo.SchedulerReportPackages", "Id", cascadeDelete: true);
              MoveTable(name: "iSchedulerReports.SchedulerReportPackages", newSchema: "dbo");
              MoveTable(name: "iSchedulerReports.SchedulerReportPackageItems", newSchema: "dbo");
          }
      }
  }