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");

        }
    }
}