namespace ShwasherSys.Migrations
{
    using System;
    using System.Data.Entity.Migrations;
    
    public partial class addViewoutSourcingMiss : DbMigration
    {
        public override void Up()
        {
            //CreateTable(
            //    "dbo.N_ViewOutSourcingMiss",
            //    c => new
            //        {
            //            Id = c.Int(nullable: false, identity: true),
            //            ProductionOrderNo = c.String(nullable: false),
            //            PlannedQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
            //            ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
            //            MissQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
            //            SemiProductNo = c.String(),
            //            Material = c.String(),
            //            Model = c.String(),
            //            SurfaceColor = c.String(),
            //            Rigidity = c.String(),
            //            PartNo = c.String(),
            //            LastModificationTime = c.DateTime(),
            //            LastModifierUserId = c.Long(),
            //            CreationTime = c.DateTime(nullable: false),
            //            CreatorUserId = c.Long(),
            //        })
            //    .PrimaryKey(t => t.Id)
            //    .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
            //    .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
            //    .Index(t => t.LastModifierUserId)
            //    .Index(t => t.CreatorUserId);
            
        }
        
        public override void Down()
        {
            //DropForeignKey("dbo.N_ViewOutSourcingMiss", "LastModifierUserId", "dbo.Sys_Users");
            //DropForeignKey("dbo.N_ViewOutSourcingMiss", "CreatorUserId", "dbo.Sys_Users");
            //DropIndex("dbo.N_ViewOutSourcingMiss", new[] { "CreatorUserId" });
            //DropIndex("dbo.N_ViewOutSourcingMiss", new[] { "LastModifierUserId" });
            //DropTable("dbo.N_ViewOutSourcingMiss");
        }
    }
}