42 lines
2.5 KiB
C#
42 lines
2.5 KiB
C#
namespace Weee.Migrations
|
|
{
|
|
using System;
|
|
using System.Data.Entity.Migrations;
|
|
|
|
public partial class addAllSheetDescription : DbMigration
|
|
{
|
|
public override void Up()
|
|
{
|
|
RenameColumn("dbo.LCACommonSurveyForm_FireEquipments", "NoteDescription", "Description");
|
|
RenameColumn("dbo.LCACommonSurveyForm_GasolineEquipments", "NoteDescription", "Description");
|
|
RenameColumn("dbo.LCACommonSurveyForm_Kitchens", "NoteDescription", "Description");
|
|
RenameColumn("dbo.LCACommonSurveyForm_Refrigerants", "NoteDescription", "Description");
|
|
RenameColumn("dbo.LCACommonSurveyForm_Vehicles", "NoteDescription", "Description");
|
|
RenameColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "NoteDescription", "Description");
|
|
AddColumn("dbo.LCACommonSurveyForm_PowerUsages", "Description", c => c.String());
|
|
AddColumn("dbo.LCACommonSurveyForm_SteamUsages", "Description", c => c.String());
|
|
AddColumn("dbo.LCACommonSurveyForm_WorkHours", "Description", c => c.String());
|
|
AddColumn("dbo.ProductLCAFabSurveyForm_Transports", "Description", c => c.String());
|
|
AddColumn("dbo.ProductLCAFabSurveyForm_WasteTransports", "Description", c => c.String());
|
|
AddColumn("dbo.ProductLCAFabSurveyForm_WaterUsages", "Description", c => c.String());
|
|
}
|
|
|
|
public override void Down()
|
|
{
|
|
RenameColumn("dbo.LCACommonSurveyForm_FireEquipments", "Description", "NoteDescription");
|
|
RenameColumn("dbo.LCACommonSurveyForm_GasolineEquipments", "Description", "NoteDescription");
|
|
RenameColumn("dbo.LCACommonSurveyForm_Kitchens", "Description", "NoteDescription");
|
|
RenameColumn("dbo.LCACommonSurveyForm_Refrigerants", "Description", "NoteDescription");
|
|
RenameColumn("dbo.LCACommonSurveyForm_Vehicles", "Description", "NoteDescription");
|
|
RenameColumn("dbo.ProductLCAFabSurveyForm_OtherCompounds", "Description", "NoteDescription");
|
|
DropColumn("dbo.ProductLCAFabSurveyForm_WaterUsages", "Description");
|
|
DropColumn("dbo.ProductLCAFabSurveyForm_WasteTransports", "Description");
|
|
DropColumn("dbo.ProductLCAFabSurveyForm_Transports", "Description");
|
|
DropColumn("dbo.LCACommonSurveyForm_WorkHours", "Description");
|
|
DropColumn("dbo.LCACommonSurveyForm_SteamUsages", "Description");
|
|
DropColumn("dbo.LCACommonSurveyForm_PowerUsages", "Description");
|
|
|
|
}
|
|
}
|
|
}
|