201706161758169_Update02.cs
2.52 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
namespace Vrh.iScheduler.Report.Lib.Migrations
{
using System;
using System.Data.Entity.Migrations;
public partial class Update02 : DbMigration
{
public override void Up()
{
DropIndex("dbo.SchedulerReportPackageItems", new[] { "SchedulerReportPackageId" });
AddColumn("dbo.SchedulerReportPackageItems", "LCID", c => c.String(nullable: false, maxLength: 10));
AddColumn("dbo.SchedulerReportPackages", "GroupId", c => c.String(nullable: false, maxLength: 100));
Sql("update dbo.SchedulerReportPackages set GroupId = SchedulerReportPackageGroup");
AlterColumn("dbo.SchedulerReportPackageItems", "ReportId", c => c.String(nullable: false, maxLength: 50));
AlterColumn("dbo.SchedulerReportPackageItems", "ExportType", c => c.String(nullable: false, maxLength: 30));
AlterColumn("dbo.SchedulerReportPackages", "Name", c => c.String(nullable: false, maxLength: 100));
AlterColumn("dbo.SchedulerReportPackages", "Description", c => c.String(nullable: false, maxLength: 200));
CreateIndex("dbo.SchedulerReportPackageItems", new[] { "SchedulerReportPackageId", "ReportId", "LCID" }, unique: true, name: "IX_SchedulerReportPackageItems_SchedulerReportPackageId_ReportId_LCID");
CreateIndex("dbo.SchedulerReportPackages", new[] { "Name", "GroupId" }, unique: true, name: "IX_SchedulerReportPackages_NameGroup");
DropColumn("dbo.SchedulerReportPackages", "SchedulerReportPackageGroup");
}
public override void Down()
{
AddColumn("dbo.SchedulerReportPackages", "SchedulerReportPackageGroup", c => c.String());
DropIndex("dbo.SchedulerReportPackages", "IX_SchedulerReportPackages_NameGroup");
DropIndex("dbo.SchedulerReportPackageItems", "IX_SchedulerReportPackageItems_SchedulerReportPackageId_ReportId_LCID");
AlterColumn("dbo.SchedulerReportPackages", "Description", c => c.String(maxLength: 200));
AlterColumn("dbo.SchedulerReportPackages", "Name", c => c.String(maxLength: 200));
AlterColumn("dbo.SchedulerReportPackageItems", "ExportType", c => c.String(maxLength: 30));
AlterColumn("dbo.SchedulerReportPackageItems", "ReportId", c => c.String(maxLength: 50));
DropColumn("dbo.SchedulerReportPackages", "GroupId");
DropColumn("dbo.SchedulerReportPackageItems", "LCID");
CreateIndex("dbo.SchedulerReportPackageItems", "SchedulerReportPackageId");
}
}
}