201911221620053_ChangeSchemaName.cs
1.23 KB
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");
}
}
}