namespace Weee.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class add_WasteMaterialFields_to_LCA : DbMigration
    {
        public override void Up()
        {
            AddColumn("dbo.LCAs", "WasteMaterialTotalQuantity", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.LCAs", "WasteMaterialShippingDistance", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.LCAs", "WasteMaterialTKM1", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.LCAs", "WasteMaterialNumOfBarrels", c => c.Int(nullable: false));
            AddColumn("dbo.LCAs", "WasteMaterialWeight", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.LCAs", "WasteMaterialWorkingDays", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.LCAs", "WasteMaterialTotalOutputKg", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.LCAs", "WasteMaterialTotalOutputT", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.LCAs", "WasteMaterialTreatmentPlantShippingDistance", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.LCAs", "WasteMaterialTKM2", c => c.Decimal(nullable: false, precision: 24, scale: 12));
            AddColumn("dbo.LCARiskAssmtSurveyForm_WasteMaterial", "TotalQuantity", c => c.Decimal(nullable: false, precision: 24, scale: 12));
        }
        
        public override void Down()
        {
            DropColumn("dbo.LCARiskAssmtSurveyForm_WasteMaterial", "TotalQuantity");
            DropColumn("dbo.LCAs", "WasteMaterialTKM2");
            DropColumn("dbo.LCAs", "WasteMaterialTreatmentPlantShippingDistance");
            DropColumn("dbo.LCAs", "WasteMaterialTotalOutputT");
            DropColumn("dbo.LCAs", "WasteMaterialTotalOutputKg");
            DropColumn("dbo.LCAs", "WasteMaterialWorkingDays");
            DropColumn("dbo.LCAs", "WasteMaterialWeight");
            DropColumn("dbo.LCAs", "WasteMaterialNumOfBarrels");
            DropColumn("dbo.LCAs", "WasteMaterialTKM1");
            DropColumn("dbo.LCAs", "WasteMaterialShippingDistance");
            DropColumn("dbo.LCAs", "WasteMaterialTotalQuantity");
        }
    }
}