ShWasher/src_0nline/ShwasherSys/ShwasherSys.EntityFramework/Migrations/202411110553553_20241111-init.cs

namespace ShwasherSys.Migrations
{
    using System;
    using System.Collections.Generic;
    using System.Data.Entity.Infrastructure.Annotations;
    using System.Data.Entity.Migrations;
    
    public partial class _20241111init : DbMigration
    {


        public override void Up()
        {
            CreateTable(
                "dbo.Sys_AppGuids",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    Step = c.Short(nullable: false),
                    LastId = c.Int(nullable: false),
                    IdType = c.Short(nullable: false),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Sys_AuditLogs",
                c => new
                {
                    Id = c.Long(nullable: false, identity: true),
                    UserId = c.Long(),
                    UserName = c.String(),
                    ServiceName = c.String(maxLength: 256),
                    MethodName = c.String(maxLength: 256),
                    Parameters = c.String(maxLength: 1024),
                    ExecutionTime = c.DateTime(nullable: false),
                    ExecutionDuration = c.Int(nullable: false),
                    ClientIpAddress = c.String(maxLength: 64),
                    ClientName = c.String(maxLength: 128),
                    BrowserInfo = c.String(maxLength: 512),
                    Exception = c.String(maxLength: 2000),
                    ImpersonatorUserId = c.Long(),
                    ImpersonatorTenantId = c.Int(),
                    CustomData = c.String(maxLength: 2000),
                    LogType = c.Int(nullable: false),
                    Discriminator = c.String(nullable: false, maxLength: 128),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.BackUpCurrentSemiStoreHouse",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    CurrentSemiStoreHouseNo = c.String(nullable: false, maxLength: 32),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    StoreHouseId = c.Int(nullable: false),
                    SemiProductNo = c.String(maxLength: 32),
                    FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ApplyEnterDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.BulletinInfo",
                c => new
                {
                    BulletinInfoId = c.Int(nullable: false, identity: true),
                    BulletinType = c.String(nullable: false, maxLength: 1),
                    Title = c.String(nullable: false, maxLength: 100),
                    Content = c.String(nullable: false, storeType: "ntext"),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    Promulgator = c.String(maxLength: 50),
                    PromulgatTime = c.DateTime(storeType: "smalldatetime"),
                    ExpirationDate = c.DateTime(storeType: "smalldatetime"),
                })
                .PrimaryKey(t => t.BulletinInfoId);

            CreateTable(
                "dbo.BusinessLogs",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    LogType = c.Int(nullable: false),
                    LogCommand = c.String(),
                    LogMessage = c.String(),
                    LogErrorMessage = c.String(),
                    LogDate = c.DateTime(),
                    UserHostAddress = c.String(),
                    Extend1Log = c.String(),
                    Extend2Log = c.String(),
                    Extend3Log = c.String(),
                    Extend4Log = c.String(),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_BusinessLog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Currency",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    CurrencyName = c.String(maxLength: 20),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    UserIDLastMod = c.String(maxLength: 20),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.CurrencyExchangeRate",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    FromCurrencyId = c.String(maxLength: 20),
                    ToCurrencyId = c.String(maxLength: 20),
                    ExchangeRate = c.Decimal(precision: 18, scale: 4),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    UserIDLastMod = c.String(maxLength: 20),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.CurrentProductStoreHouse",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    CurrentProductStoreHouseNo = c.String(nullable: false, maxLength: 32),
                    ProductionOrderNo = c.String(maxLength: 11),
                    StoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(maxLength: 32),
                    ProductNo = c.String(maxLength: 32),
                    FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
                    InventoryCheckState = c.Int(),
                    ReturnState = c.Int(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.CurrentRmStoreHouse",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductionOrderNo = c.String(maxLength: 11),
                    StoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(maxLength: 32),
                    RmProductNo = c.String(maxLength: 32),
                    FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    Remark = c.String(maxLength: 150),
                    ProductBatchNum = c.String(maxLength: 32),
                    PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_CurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.CurrentSemiStoreHouse",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    StoreLocationNo = c.String(maxLength: 32),
                    CurrentSemiStoreHouseNo = c.String(nullable: false, maxLength: 32),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    StoreHouseId = c.Int(nullable: false),
                    SemiProductNo = c.String(maxLength: 32),
                    FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ApplyEnterDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
                    InventoryCheckState = c.Int(),
                    ReturnState = c.Int(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.CustomerDefaultProduct",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    CustomerId = c.String(maxLength: 30),
                    ProductNo = c.String(maxLength: 30),
                    CustomerProductName = c.String(maxLength: 30),
                    Sequence = c.Int(nullable: false),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    PartNo = c.String(maxLength: 30),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.CustomerDisProductInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductOrderNo = c.String(),
                    CustomerNo = c.String(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.Sys_Users",
                c => new
                {
                    Id = c.Long(nullable: false, identity: true),
                    FactoryID = c.String(maxLength: 20),
                    DepartmentID = c.String(maxLength: 20),
                    DutyID = c.Int(),
                    AccountNo = c.String(maxLength: 20),
                    Birthday = c.DateTime(),
                    Address = c.String(maxLength: 200),
                    ZIP = c.String(maxLength: 50),
                    Remark = c.String(maxLength: 500),
                    UserName = c.String(nullable: false, maxLength: 32),
                    UserType = c.Int(nullable: false),
                    AuthenticationSource = c.String(maxLength: 64),
                    EmailAddress = c.String(nullable: false, maxLength: 256),
                    RealName = c.String(nullable: false, maxLength: 32),
                    Password = c.String(nullable: false, maxLength: 128),
                    EmailConfirmationCode = c.String(maxLength: 328),
                    PasswordResetCode = c.String(maxLength: 328),
                    LockoutEndDateUtc = c.DateTime(),
                    AccessFailedCount = c.Int(nullable: false),
                    IsLockoutEnabled = c.Boolean(nullable: false),
                    PhoneNumber = c.String(maxLength: 32),
                    IsPhoneNumberConfirmed = c.Boolean(nullable: false),
                    SecurityStamp = c.String(maxLength: 128),
                    IsTwoFactorEnabled = c.Boolean(nullable: false),
                    IsEmailConfirmed = c.Boolean(nullable: false),
                    IsActive = c.Boolean(nullable: false),
                    LastLoginTime = c.DateTime(),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysUser_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.Sys_UserRoles",
                c => new
                {
                    Id = c.Long(nullable: false, identity: true),
                    UserId = c.Long(nullable: false),
                    RoleId = c.Int(nullable: false),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.UserId, cascadeDelete: true)
                .Index(t => t.UserId);

            CreateTable(
                "dbo.CustomerInvoiceAddress",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    CustomerId = c.String(nullable: false, maxLength: 30),
                    InvoiceAddressName = c.String(nullable: false, maxLength: 150),
                    InvoiceAddress = c.String(nullable: false, maxLength: 250),
                    LinkMan = c.String(maxLength: 30),
                    Telephone = c.String(maxLength: 50),
                    Zip = c.String(maxLength: 8),
                    Email = c.String(maxLength: 50),
                    Mobile = c.String(maxLength: 50),
                    Fax = c.String(maxLength: 50),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_CustomerInvoiceAddress_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Customers",
                c => new
                {
                    CustomerId = c.String(nullable: false, maxLength: 128),
                    CustomerName = c.String(nullable: false, maxLength: 50),
                    LinkMan = c.String(maxLength: 20),
                    Address = c.String(maxLength: 150),
                    WebSite = c.String(maxLength: 50),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    IsLock = c.String(nullable: false, maxLength: 1),
                    Telephone = c.String(maxLength: 50),
                    Fax = c.String(maxLength: 50),
                    zip = c.String(maxLength: 6),
                    Email = c.String(maxLength: 200),
                    SaleType = c.Int(),
                })
                .PrimaryKey(t => t.CustomerId);

            CreateTable(
                "dbo.CustomerSend",
                c => new
                {
                    CustomerSendId = c.Int(nullable: false, identity: true),
                    CustomerId = c.String(nullable: false, maxLength: 30),
                    CustomerSendName = c.String(nullable: false, maxLength: 150),
                    SendAdress = c.String(nullable: false, maxLength: 250),
                    LinkMan = c.String(maxLength: 30),
                    Telephone = c.String(maxLength: 50),
                    Zip = c.String(maxLength: 8),
                    Email = c.String(maxLength: 50),
                    Mobile = c.String(maxLength: 50),
                    Fax = c.String(maxLength: 50),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    IsLock = c.String(nullable: false, maxLength: 1),
                })
                .PrimaryKey(t => t.CustomerSendId);

            CreateTable(
                "dbo.Departments",
                c => new
                {
                    DepartmentID = c.String(nullable: false, maxLength: 128),
                    DepartmentName = c.String(nullable: false, maxLength: 50),
                    Remark = c.String(maxLength: 200),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    IsLock = c.String(nullable: false, maxLength: 1),
                    OrderStatusList = c.String(maxLength: 300),
                })
                .PrimaryKey(t => t.DepartmentID);

            CreateTable(
                "dbo.DeviceMgPlanInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    No = c.String(maxLength: 50),
                    PlanType = c.Int(nullable: false),
                    DeviceNo = c.String(maxLength: 50),
                    Name = c.String(maxLength: 50),
                    Description = c.String(),
                    ExpireDate = c.DateTime(nullable: false),
                    MaintenanceCycle = c.Int(nullable: false),
                    MaintenanceDate = c.DateTime(nullable: false),
                    NextMaintenanceDate = c.DateTime(),
                    Remark = c.String(maxLength: 500),
                    NumberOfUsers = c.Int(nullable: false),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_DeviceMgPlan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.DisqualifiedProductInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    DisqualifiedNo = c.String(maxLength: 20),
                    ProductOrderNo = c.String(maxLength: 11),
                    ReturnOrderNo = c.String(maxLength: 32),
                    ProductNo = c.String(maxLength: 50),
                    ProductName = c.String(maxLength: 100),
                    ProductType = c.Int(nullable: false),
                    QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
                    HandleType = c.Int(nullable: false),
                    CheckUser = c.String(maxLength: 20),
                    CheckDate = c.DateTime(),
                    HandleUser = c.String(maxLength: 20),
                    HandleDate = c.DateTime(),
                    DisqualifiedType = c.Int(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.Dutys",
                c => new
                {
                    DutyID = c.Int(nullable: false, identity: true),
                    DutyName = c.String(nullable: false, maxLength: 50),
                    Remark = c.String(maxLength: 200),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    IsLock = c.String(nullable: false, maxLength: 1),
                })
                .PrimaryKey(t => t.DutyID);

            CreateTable(
                "dbo.EmployeeInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    No = c.String(maxLength: 20),
                    Name = c.String(maxLength: 50),
                    CardId = c.String(maxLength: 18),
                    Gender = c.Int(nullable: false),
                    PhoneNumber = c.String(maxLength: 18),
                    DepartmentNo = c.String(maxLength: 20),
                    DutyNo = c.String(maxLength: 20),
                    Description = c.String(maxLength: 500),
                    UserName = c.String(maxLength: 32),
                    Remark = c.String(maxLength: 500),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_Employee_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.EmployeeWorkPerformanceInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    PerformanceNo = c.String(maxLength: 20),
                    EmployeeId = c.Int(nullable: false),
                    RelatedNo = c.String(maxLength: 20),
                    ProductOrderNo = c.String(maxLength: 11),
                    WorkType = c.Int(nullable: false),
                    Performance = c.Decimal(precision: 18, scale: 3),
                    PerformanceUnit = c.String(maxLength: 10),
                    PerformanceDesc = c.String(maxLength: 500),
                    Remark = c.String(maxLength: 500),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
                .Index(t => t.EmployeeId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.ExpressLogistics",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ExpressName = c.String(maxLength: 50),
                    Code = c.String(maxLength: 50),
                    Sort = c.Int(nullable: false),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 50),
                    IsLock = c.String(nullable: false, maxLength: 1),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.ExpressProviderMappers",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ExpressId = c.Int(nullable: false),
                    ProviderId = c.Int(nullable: false),
                    MapperCode = c.String(maxLength: 50),
                    QueryUrl = c.String(maxLength: 500),
                    ExtendInfo = c.String(maxLength: 500),
                    ActiveStatus = c.Int(),
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.ExpressLogistics", t => t.ExpressId, cascadeDelete: true)
                .ForeignKey("dbo.ExpressServiceProviders", t => t.ProviderId, cascadeDelete: true)
                .Index(t => t.ExpressId)
                .Index(t => t.ProviderId);

            CreateTable(
                "dbo.ExpressServiceProviders",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProviderName = c.String(maxLength: 50),
                    QueryApiUrl = c.String(maxLength: 150),
                    CallBackUrl = c.String(maxLength: 150),
                    ExcuteNamespaceAndMethod = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 50),
                    IsLock = c.String(nullable: false, maxLength: 1),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Factories",
                c => new
                {
                    FactoryID = c.String(nullable: false, maxLength: 128),
                    FactoryName = c.String(nullable: false, maxLength: 100),
                    ShortNames = c.String(nullable: false, maxLength: 20),
                    RegionID = c.String(nullable: false, maxLength: 50),
                    FactoryURL = c.String(maxLength: 80),
                    Address = c.String(maxLength: 100),
                    ZIP = c.String(maxLength: 50),
                    LinkMan = c.String(maxLength: 50),
                    Telephone = c.String(maxLength: 50),
                    Remark = c.String(maxLength: 200),
                    IsLock = c.String(nullable: false, maxLength: 1),
                })
                .PrimaryKey(t => t.FactoryID);

            CreateTable(
                "dbo.FinshedEnterStore",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    PackageApplyNo = c.String(nullable: false, maxLength: 32),
                    PackageProductNo = c.String(maxLength: 50),
                    ProductNo = c.String(maxLength: 50),
                    StoreHouseId = c.Int(nullable: false),
                    SourceStoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(maxLength: 32),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    ApplySourceType = c.Int(nullable: false),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    PackageSpecification = c.Decimal(nullable: false, precision: 18, scale: 3),
                    PackageCount = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualPackageCount = c.Decimal(nullable: false, precision: 18, scale: 3),
                    AuditUser = c.String(maxLength: 20),
                    AuditDate = c.DateTime(),
                    ApplyEnterDate = c.DateTime(),
                    EnterStoreUser = c.String(maxLength: 20),
                    EnterStoreDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    CreateSourceType = c.Int(),
                    PackageEnterNum = c.String(),
                    PackageUser = c.String(maxLength: 20),
                    VerifyUser = c.String(maxLength: 20),
                    ApplyQuantity2 = c.Decimal(nullable: false, precision: 18, scale: 3),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.FixedAssetInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    No = c.String(maxLength: 50),
                    Name = c.String(maxLength: 50),
                    Model = c.String(maxLength: 50),
                    Description = c.String(maxLength: 500),
                    Remark = c.String(maxLength: 500),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_FixedAsset_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.FixedAssetTypeInfo",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    Name = c.String(nullable: false, maxLength: 50),
                    Description = c.String(maxLength: 500),
                    Remark = c.String(maxLength: 500),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_FixedAssetType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.Sys_Functions",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    FunctionNo = c.String(maxLength: 100),
                    ParentNo = c.String(maxLength: 100),
                    FunctionName = c.String(maxLength: 100),
                    PermissionName = c.String(maxLength: 500),
                    FunctionType = c.Int(nullable: false),
                    FunctionPath = c.String(maxLength: 500),
                    Action = c.String(maxLength: 50),
                    Controller = c.String(maxLength: 50),
                    Url = c.String(),
                    Icon = c.String(maxLength: 20),
                    Class = c.String(maxLength: 100),
                    Script = c.String(),
                    Sort = c.Int(nullable: false),
                    Depth = c.Int(nullable: false),
                    IsLeaf = c.Boolean(),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysFunction_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.InventoryCheck",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    CheckNo = c.String(maxLength: 32),
                    StoreHouseId = c.Int(nullable: false),
                    StoreAreaCode = c.String(maxLength: 32),
                    ShelfNumber = c.String(maxLength: 32),
                    ShelfLevel = c.String(maxLength: 32),
                    SequenceNo = c.String(maxLength: 32),
                    CheckType = c.String(maxLength: 10),
                    PlanStartDate = c.DateTime(),
                    PlanEndDate = c.DateTime(),
                    Remark = c.String(maxLength: 200),
                    CheckUser = c.String(maxLength: 32),
                    PublishUser = c.String(maxLength: 32),
                    FinishDate = c.DateTime(),
                    CheckState = c.Int(nullable: false),
                    ProductNo = c.String(maxLength: 32),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_InventoryCheckInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.InventoryCheckRecord",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    CheckNo = c.String(maxLength: 32),
                    CurrentStoreHouseNo = c.String(maxLength: 32),
                    CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.LicenseDocumentInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    No = c.String(maxLength: 50),
                    Name = c.String(maxLength: 50),
                    Description = c.String(maxLength: 500),
                    LicenseGroup = c.String(maxLength: 50),
                    LicenseType = c.String(maxLength: 50),
                    FilePath = c.String(maxLength: 300),
                    ExpireDate = c.DateTime(nullable: false),
                    Remark = c.String(maxLength: 500),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_LicenseDocument_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.LicenseTypeInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    Name = c.String(maxLength: 50),
                    GroupName = c.String(maxLength: 50),
                    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);

            CreateTable(
                "dbo.MaintenanceMemberInfo",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    MaintenanceNo = c.String(),
                    EmployeeId = c.Int(nullable: false),
                    Name = c.String(),
                    StartDateTime = c.DateTime(),
                    EndDateTime = c.DateTime(),
                    WorkHour = c.Decimal(nullable: false, precision: 18, scale: 2),
                    IsConfirm = c.Boolean(nullable: false),
                    WorkDesc = c.String(),
                    Remark = c.String(maxLength: 500),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
                .Index(t => t.EmployeeId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.MaintenanceRecordInfo",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    DeviceMgPlanNo = c.String(maxLength: 50),
                    DeviceNo = c.String(maxLength: 50),
                    DeviceName = c.String(maxLength: 50),
                    MgType = c.Int(nullable: false),
                    Description = c.String(maxLength: 500),
                    Address = c.String(maxLength: 200),
                    PlanDate = c.DateTime(nullable: false),
                    CompleteState = c.Int(nullable: false),
                    CompleteDate = c.DateTime(),
                    Remark = c.String(maxLength: 500),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.MoldInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    No = c.String(maxLength: 50),
                    Name = c.String(maxLength: 50),
                    Model = c.String(maxLength: 50),
                    Material = c.String(maxLength: 50),
                    Description = c.String(maxLength: 500),
                    Remark = c.String(maxLength: 500),
                    CustomerName = c.String(maxLength: 50),
                    ShelfNum = c.String(maxLength: 50),
                    OuterDiameter = c.String(maxLength: 50),
                    InsideDiameter = c.String(maxLength: 50),
                    Thickness = c.String(maxLength: 50),
                    Height = c.String(maxLength: 50),
                    Rigidity = c.String(maxLength: 50),
                    MaintenanceCycle = c.Int(nullable: false),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_Mold_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.MoldProductionRecord",
                c => new
                {
                    Id = c.Long(nullable: false, identity: true),
                    MoldNo = c.String(nullable: false, maxLength: 50),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    Quantity = c.Int(nullable: false),
                    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);

            CreateTable(
                "dbo.OrderHeader",
                c => new
                {
                    OrderNo = c.String(nullable: false, maxLength: 128),
                    CustomerId = c.String(nullable: false, maxLength: 30),
                    LinkName = c.String(nullable: false, maxLength: 50),
                    OrderDate = c.DateTime(nullable: false, storeType: "smalldatetime"),
                    Fax = c.String(maxLength: 50),
                    Telephone = c.String(maxLength: 50),
                    CustomerSendId = c.Int(nullable: false),
                    StockNo = c.String(maxLength: 50),
                    OrderStatusId = c.Int(nullable: false),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 30),
                    SaleType = c.Int(),
                    SaleMan = c.String(maxLength: 50),
                    IsLock = c.String(maxLength: 1),
                })
                .PrimaryKey(t => t.OrderNo);

            CreateTable(
                "dbo.OrderItems",
                c => new
                {
                    OrderItemId = c.Int(nullable: false, identity: true),
                    OrderNo = c.String(nullable: false, maxLength: 30),
                    ProductNo = c.String(nullable: false, maxLength: 30),
                    Price = c.Decimal(nullable: false, storeType: "money"),
                    AfterTaxPrice = c.Decimal(nullable: false, storeType: "money"),
                    CurrencyId = c.String(nullable: false, maxLength: 10),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3, storeType: "numeric"),
                    OrderUnitId = c.Int(nullable: false),
                    SendDate = c.DateTime(nullable: false, storeType: "smalldatetime"),
                    IsReport = c.String(nullable: false, maxLength: 1),
                    IsPartSend = c.String(nullable: false, maxLength: 1),
                    OrderItemStatusId = c.Int(),
                    WareHouse = c.String(maxLength: 50),
                    OrderItemDesc = c.String(maxLength: 500),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    PartNo = c.String(maxLength: 30),
                    ToCnyRate = c.Decimal(precision: 18, scale: 3),
                    EmergencyLevel = c.Int(nullable: false),
                    IsLock = c.String(maxLength: 1),
                    StandardName = c.String(maxLength: 50),
                    StoreCompleteState = c.Int(nullable: false),
                    LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                })
                .PrimaryKey(t => t.OrderItemId);

            CreateTable(
                "dbo.OrderProduction",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    OrderItemId = c.Int(nullable: false),
                    ProductionOrderNo = c.String(maxLength: 11),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.OrderSendBills",
                c => new
                {
                    OrderSendBillNo = c.String(nullable: false, maxLength: 128),
                    CustomerId = c.String(nullable: false, maxLength: 30),
                    SendDate = c.DateTime(storeType: "smalldatetime"),
                    SendAddress = c.String(maxLength: 250),
                    ContactTels = c.String(maxLength: 50),
                    ContactMan = c.String(maxLength: 50),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    IsDoBill = c.String(maxLength: 1),
                    ExpressId = c.Int(),
                    ExpressBillNo = c.String(maxLength: 50),
                })
                .PrimaryKey(t => t.OrderSendBillNo);

            CreateTable(
                "dbo.OrderSendExceed",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    OrderItemId = c.Int(nullable: false),
                    ExceedQuantity = c.Decimal(nullable: false, precision: 18, scale: 3, storeType: "numeric"),
                    OperatorMan = c.String(maxLength: 30),
                    OrderNo = c.String(),
                    ProductNo = c.String(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.OrderSend",
                c => new
                {
                    OrderSendId = c.Int(nullable: false, identity: true),
                    OrderItemId = c.Int(nullable: false),
                    SendDate = c.DateTime(storeType: "smalldatetime"),
                    SendQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    OrderUnitId = c.Int(),
                    Remark = c.String(maxLength: 250),
                    OrderSendBillNo = c.String(maxLength: 20),
                    OrderStickBillNo = c.String(maxLength: 40),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    CreatorUserId = c.String(maxLength: 20),
                    QuantityPerPack = c.Decimal(precision: 18, scale: 3),
                    PackageCount = c.Decimal(precision: 18, scale: 3),
                    ProductBatchNum = c.String(),
                    StoreLocationNo = c.String(maxLength: 32),
                    CurrentProductStoreHouseNo = c.String(),
                    StatementBillNo = c.String(maxLength: 32),
                    LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                    SendBillSort = c.Int(nullable: false),
                    StatementBillSort = c.Int(nullable: false),
                })
                .PrimaryKey(t => t.OrderSendId);

            CreateTable(
                "dbo.OrderStickBills",
                c => new
                {
                    OrderStickBillNo = c.String(nullable: false, maxLength: 128),
                    CustomerId = c.String(nullable: false, maxLength: 30),
                    CreatDate = c.DateTime(storeType: "smalldatetime"),
                    StickNum = c.String(maxLength: 30),
                    StickMan = c.String(maxLength: 20),
                    Description = c.String(maxLength: 4000),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    InvoiceState = c.Int(),
                    Amount = c.Decimal(precision: 18, scale: 2),
                    OriginalStickNum = c.String(maxLength: 30),
                    ReturnOrderNo = c.String(maxLength: 30),
                    OrderNo = c.String(maxLength: 500),
                    InvoiceType = c.Int(nullable: false),
                })
                .PrimaryKey(t => t.OrderStickBillNo);

            CreateTable(
                "dbo.OrderUnit",
                c => new
                {
                    OrderUnitId = c.Int(nullable: false, identity: true),
                    OrderUnitName = c.String(maxLength: 50),
                    ProductNum = c.Int(),
                    OrderUnitDesc = c.String(maxLength: 250),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(),
                })
                .PrimaryKey(t => t.OrderUnitId);

            CreateTable(
                "dbo.OutFactory",
                c => new
                {
                    OutFactoryId = c.String(nullable: false, maxLength: 128),
                    OutFactoryName = c.String(nullable: false, maxLength: 50),
                    LinkMan = c.String(maxLength: 20),
                    Address = c.String(maxLength: 150),
                    WebSite = c.String(maxLength: 50),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    IsLock = c.String(nullable: false, maxLength: 1),
                    Telephone = c.String(maxLength: 50),
                    Fax = c.String(maxLength: 50),
                    zip = c.String(maxLength: 6),
                    Email = c.String(maxLength: 200),
                })
                .PrimaryKey(t => t.OutFactoryId);

            CreateTable(
                "dbo.PackageApply",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    PackageApplyNo = c.String(nullable: false, maxLength: 32),
                    CurrentStoreHouseNo = c.String(maxLength: 32),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    SemiProductNo = c.String(maxLength: 32),
                    ProductNo = c.String(maxLength: 32),
                    ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    SourceStore = c.Int(nullable: false),
                    ApplyStatus = c.String(nullable: false, maxLength: 1),
                    IsClose = c.Boolean(nullable: false),
                    ApplyDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Sys_Permissions",
                c => new
                {
                    Id = c.Long(nullable: false, identity: true),
                    PermissionNo = c.String(maxLength: 32),
                    PermissionName = c.String(maxLength: 500),
                    Master = c.Int(),
                    MasterValue = c.String(),
                    Access = c.Int(),
                    AccessValue = c.String(),
                    IsGranted = c.Boolean(nullable: false),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.ProductInspectInfos",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductInspectReportNo = c.String(nullable: false, maxLength: 32),
                    ProductInspectNo = c.String(nullable: false, maxLength: 32),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    SemiProductNo = c.String(maxLength: 32),
                    InspectStatus = c.Int(nullable: false),
                    InspectSubject = c.String(maxLength: 50),
                    InspectResult = c.Int(nullable: false),
                    InspectDate = c.DateTime(),
                    InspectMember = c.String(maxLength: 100),
                    IsLock = c.String(maxLength: 1),
                    InspectContent = c.String(maxLength: 1000),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.ProductInspectReportInfos",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductInspectReportNo = c.String(nullable: false, maxLength: 32),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    SemiProductNo = c.String(maxLength: 32),
                    ConfirmStatus = c.Int(nullable: false),
                    InspectCount = c.Int(nullable: false),
                    ConfirmDate = c.DateTime(),
                    ConfirmUser = c.String(maxLength: 100),
                    InspectContent = c.String(maxLength: 1000),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.ProductionOrderLogInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionNo = c.String(maxLength: 20),
                    ProductOrderNo = c.String(maxLength: 11),
                    EmployeeId = c.Int(nullable: false),
                    CarNo = c.String(maxLength: 20),
                    QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
                .Index(t => t.EmployeeId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.ProductionOrders",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    ProductionOrderStatus = c.Int(nullable: false),
                    StoveNo = c.String(maxLength: 20),
                    CarNo = c.String(maxLength: 20),
                    SemiProductNo = c.String(maxLength: 32),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    RawMaterials = c.String(maxLength: 100),
                    Material = c.String(maxLength: 50),
                    PartNo = c.String(maxLength: 50),
                    Model = c.String(maxLength: 50),
                    SurfaceColor = c.String(maxLength: 50),
                    Rigidity = c.String(maxLength: 50),
                    Size = c.String(maxLength: 50),
                    ProcessingType = c.String(maxLength: 1),
                    ProcessingLevel = c.String(maxLength: 1),
                    Remark = c.String(maxLength: 150),
                    IsChecked = c.Int(),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    IsLock = c.String(maxLength: 1),
                    SourceProductionOrderNo = c.String(maxLength: 11),
                    PlanProduceDate = c.DateTime(),
                    EnterQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ProductionType = c.String(maxLength: 1),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    OutsourcingFactory = c.String(),
                    EnterDate = c.DateTime(),
                    InspectDate = c.DateTime(),
                    HasExported = c.Boolean(nullable: false),
                    MaxQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.ProductMapper",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductNo = c.String(maxLength: 50),
                    PreProductNo = c.String(maxLength: 50),
                    PreProductType = c.Int(nullable: false),
                    NewProductType = c.Int(nullable: false),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ProductMapper_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.ProductOutStore",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(maxLength: 11),
                    CurrentProductStoreHouseNo = c.String(maxLength: 32),
                    ProductNo = c.String(maxLength: 50),
                    StoreHouseId = c.Int(nullable: false),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    IsConfirm = c.Boolean(),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    AuditUser = c.String(maxLength: 20),
                    AuditDate = c.DateTime(),
                    OutStoreUser = c.String(maxLength: 20),
                    OutStoreDate = c.DateTime(),
                    ApplyOutDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    OrderSendId = c.Int(nullable: false),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ApplyOutStoreSourceType = c.Int(nullable: false),
                    CreateSourceType = c.Int(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.ProductProperties",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    PropertyType = c.String(maxLength: 50),
                    PropertyNo = c.String(maxLength: 50),
                    PropertyValue = c.String(maxLength: 50),
                    DisplayValue = c.String(maxLength: 150),
                    ContentInfo = c.String(maxLength: 250),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ProductProperty_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Products",
                c => new
                {
                    ProductNo = c.String(nullable: false, maxLength: 128),
                    ProductName = c.String(nullable: false, maxLength: 50),
                    Model = c.String(maxLength: 50),
                    StandardId = c.Int(),
                    Material = c.String(maxLength: 50),
                    ProductDesc = c.String(maxLength: 200),
                    SurfaceColor = c.String(maxLength: 50),
                    Rigidity = c.String(maxLength: 50),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    Sequence = c.Int(nullable: false),
                    IsStandard = c.String(nullable: false, maxLength: 1),
                    IsLock = c.String(nullable: false, maxLength: 1),
                    Defprice = c.Decimal(storeType: "money"),
                    TranUnitValue = c.Decimal(precision: 18, scale: 3),
                    PartNo = c.String(maxLength: 50),
                    SpecialDesc = c.String(maxLength: 50),
                    ModelNo = c.String(maxLength: 20),
                    MaterialNo = c.String(maxLength: 20),
                    SurfaceColorNo = c.String(maxLength: 20),
                    RigidityNo = c.String(maxLength: 20),
                    SpecialNo = c.String(maxLength: 20),
                    PrevProductNo = c.String(maxLength: 50),
                })
                .PrimaryKey(t => t.ProductNo);

            CreateTable(
                "dbo.ProductInspectReportContents",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(maxLength: 32),
                    PtoductInspectNo = c.String(maxLength: 32),
                    ReportContent = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.QualityIssueLabelInfo",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    Name = c.String(nullable: false, maxLength: 50),
                    Description = c.String(maxLength: 500),
                    Remark = c.String(maxLength: 500),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_QualityIssueLabel_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.Regions",
                c => new
                {
                    RegionID = c.String(nullable: false, maxLength: 128),
                    RegionName = c.String(nullable: false, maxLength: 50),
                    FatherRegionID = c.String(nullable: false, maxLength: 50),
                    URL = c.String(maxLength: 80),
                    Depth = c.Int(nullable: false),
                    IsLeaf = c.String(nullable: false, maxLength: 1),
                    Sort = c.Int(nullable: false),
                    Path = c.String(nullable: false, maxLength: 220),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    IsLock = c.String(nullable: false, maxLength: 1),
                })
                .PrimaryKey(t => t.RegionID);

            CreateTable(
                "dbo.ReturnGoodOrder",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ReturnOrderNo = c.String(maxLength: 32),
                    SendOrderNo = c.String(maxLength: 32),
                    OrderNo = c.String(maxLength: 32),
                    OrderItemNo = c.String(maxLength: 32),
                    ProductNo = c.String(maxLength: 32),
                    ProductionOrderNo = c.String(maxLength: 32),
                    CustomerId = c.String(maxLength: 32),
                    Reason = c.String(maxLength: 500),
                    Amount = c.Decimal(precision: 18, scale: 2),
                    AuditAmount = c.Decimal(precision: 18, scale: 2),
                    Quantity = c.Decimal(precision: 18, scale: 3),
                    HandleUser = c.String(maxLength: 32),
                    ApplyUser = c.String(maxLength: 32),
                    ConfirmUser = c.String(maxLength: 32),
                    ReturnDate = c.DateTime(),
                    ApplyDate = c.DateTime(),
                    ConfirmDate = c.DateTime(),
                    ReturnState = c.Int(nullable: false),
                    ReturnType = c.Int(nullable: false),
                    LinkName = c.String(maxLength: 50),
                    SurveyReason = c.String(maxLength: 500),
                    SurveyDetail = c.String(maxLength: 500),
                    Solution = c.String(maxLength: 500),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ReturnGoodOrder_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.ReturnOrderNo, unique: true);

            CreateTable(
                "dbo.RmEnterStore",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductionOrderNo = c.String(maxLength: 11),
                    RmProductNo = c.String(maxLength: 50),
                    StoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(maxLength: 32),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    AuditUser = c.String(maxLength: 32),
                    AuditDate = c.DateTime(),
                    ApplyEnterDate = c.DateTime(),
                    EnterStoreUser = c.String(maxLength: 32),
                    EnterStoreDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    ProductBatchNum = c.String(maxLength: 32),
                    CreateSourceType = c.Int(nullable: false),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_RmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.RmOutStore",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductionOrderNo = c.String(maxLength: 11),
                    CurrentRmStoreHouseNo = c.String(maxLength: 32),
                    RmProductNo = c.String(maxLength: 50),
                    StoreHouseId = c.Int(nullable: false),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    IsConfirm = c.Boolean(),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    AuditUser = c.String(maxLength: 150),
                    AuditDate = c.DateTime(),
                    OutStoreUser = c.String(maxLength: 150),
                    OutStoreDate = c.DateTime(),
                    ApplyOutDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    ProductBatchNum = c.String(maxLength: 32),
                    CreateSourceType = c.Int(nullable: false),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_RmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.RmProduct",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductName = c.String(maxLength: 50),
                    Material = c.String(maxLength: 50),
                    Model = c.String(maxLength: 50),
                    ProductDesc = c.String(maxLength: 200),
                    ModelNo = c.String(maxLength: 20),
                    MaterialNo = c.String(maxLength: 20),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Sys_Roles",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    Name = c.String(nullable: false, maxLength: 32),
                    RoleDisplayName = c.String(nullable: false, maxLength: 64),
                    Description = c.String(maxLength: 1000),
                    RoleType = c.Int(nullable: false),
                    IsStatic = c.Boolean(nullable: false),
                    IsDefault = c.Boolean(nullable: false),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysRole_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.ScheduleOrderSend",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    OrderItemId = c.Int(nullable: false),
                    Remark = c.String(maxLength: 500),
                    PlanQuantity = c.Decimal(precision: 18, scale: 2),
                    SendUser = c.String(maxLength: 32),
                    PlanDate = c.DateTime(),
                    SendState = c.Int(nullable: false),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewScheduleOrderSend",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    OrderItemId = c.Int(nullable: false),
                    PlanQuantity = c.Decimal(precision: 18, scale: 2),
                    SendUser = c.String(),
                    Remark = c.String(),
                    PlanDate = c.DateTime(),
                    SendState = c.Int(nullable: false),
                    OrderNo = c.String(),
                    ProductNo = c.String(),
                    ProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    CustomerName = c.String(),
                    CustomerId = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.ScrapEnterStore",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductionOrderNo = c.String(maxLength: 11),
                    ProductNo = c.String(maxLength: 50),
                    StoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(maxLength: 32),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    AuditUser = c.String(maxLength: 32),
                    AuditDate = c.DateTime(),
                    ApplyEnterDate = c.DateTime(),
                    EnterStoreUser = c.String(maxLength: 32),
                    EnterStoreDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    ProductType = c.Int(nullable: false),
                    ScrapSource = c.Int(nullable: false),
                    ScrapSourceNo = c.String(maxLength: 50),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.ScrapTypeInfo",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    Name = c.String(nullable: false, maxLength: 50),
                    Description = c.String(maxLength: 500),
                    Remark = c.String(maxLength: 500),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ScrapType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.SemiEnterStore",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    StoreHouseId = c.Int(nullable: false),
                    ApplyStatus = c.String(nullable: false, maxLength: 5),
                    IsClose = c.Boolean(nullable: false),
                    ApplySource = c.String(nullable: false, maxLength: 5),
                    SemiProductNo = c.String(maxLength: 32),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    AuditUser = c.String(maxLength: 20),
                    AuditDate = c.DateTime(),
                    EnterStoreUser = c.String(maxLength: 20),
                    EnterStoreDate = c.DateTime(),
                    ApplyEnterDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    CreateSourceType = c.Int(),
                    StoreLocationNo = c.String(maxLength: 32),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.SemiOutStores",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    CurrentSemiStoreHouseNo = c.String(maxLength: 32),
                    StoreHouseId = c.Int(nullable: false),
                    ApplyStatus = c.String(nullable: false, maxLength: 5),
                    ApplyTypes = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    ApplyOutStoreSource = c.String(nullable: false, maxLength: 5),
                    IsConfirm = c.Boolean(),
                    SemiProductNo = c.String(maxLength: 32),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ApplyOutDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    AuditUser = c.String(maxLength: 20),
                    AuditDate = c.DateTime(),
                    OutStoreUser = c.String(maxLength: 20),
                    OutStoreDate = c.DateTime(),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    CreateSourceType = c.Int(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.SemiProducts",
                c => new
                {
                    SemiProductNo = c.String(nullable: false, maxLength: 128),
                    SemiProductName = c.String(maxLength: 50),
                    Model = c.String(maxLength: 50),
                    Material = c.String(maxLength: 50),
                    ProductDesc = c.String(maxLength: 200),
                    SurfaceColor = c.String(maxLength: 50),
                    Rigidity = c.String(maxLength: 50),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    IsStandard = c.String(nullable: false, maxLength: 1),
                    Sequence = c.Int(nullable: false),
                    IsLock = c.String(nullable: false, maxLength: 1),
                    PartNo = c.String(maxLength: 50),
                    TranUnitValue = c.Decimal(precision: 18, scale: 3),
                    SpecialDesc = c.String(maxLength: 50),
                    ModelNo = c.String(maxLength: 20),
                    MaterialNo = c.String(maxLength: 20),
                    SurfaceColorNo = c.String(maxLength: 20),
                    RigidityNo = c.String(maxLength: 20),
                    SpecialNo = c.String(maxLength: 20),
                    PrevProductNo = c.String(maxLength: 50),
                })
                .PrimaryKey(t => t.SemiProductNo);

            CreateTable(
                "dbo.SemiProductStore",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    StoreHouseId = c.Int(nullable: false),
                    SemiProductNo = c.String(maxLength: 32),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    StoreYear = c.String(maxLength: 5),
                    StoreMonth = c.String(maxLength: 4),
                    Active = c.String(nullable: false, maxLength: 1),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Sys_Settings",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    SettingNo = c.String(maxLength: 32),
                    SettingName = c.String(maxLength: 50),
                    SettingType = c.Int(nullable: false),
                    Code = c.String(maxLength: 100),
                    Value = c.String(maxLength: 500),
                    Description = c.String(maxLength: 1000),
                    Remark = c.String(maxLength: 1000),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysSetting_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.ShortMessage",
                c => new
                {
                    MsgID = c.Int(nullable: false, identity: true),
                    SendUserID = c.String(nullable: false, maxLength: 20),
                    Title = c.String(maxLength: 100),
                    Content = c.String(maxLength: 3000),
                    SendTime = c.DateTime(storeType: "smalldatetime"),
                    IsDelete = c.String(nullable: false, maxLength: 1),
                    RecieveUserIds = c.String(maxLength: 400),
                })
                .PrimaryKey(t => t.MsgID);

            CreateTable(
                "dbo.ShortMsgDetail",
                c => new
                {
                    DetailID = c.Int(nullable: false, identity: true),
                    MsgID = c.Int(nullable: false),
                    RecvUserID = c.String(nullable: false, maxLength: 20),
                    IsRead = c.String(nullable: false, maxLength: 1),
                })
                .PrimaryKey(t => t.DetailID);

            CreateTable(
                "dbo.StandardCatalog",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    StandardNo = c.String(maxLength: 50),
                    StandardAbbr = c.String(nullable: false, maxLength: 50),
                    StandardAbbrName = c.String(nullable: false, maxLength: 50),
                    StandardName = c.String(nullable: false, maxLength: 150),
                    Rigidity = c.String(maxLength: 250),
                    Param = c.String(maxLength: 250),
                    Drawing = c.String(),
                    Remark = c.String(maxLength: 250),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_StandardCatalog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.StandardDetail",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    StandardId = c.Int(nullable: false),
                    Specs = c.String(nullable: false, maxLength: 50),
                    StandardName = c.String(nullable: false, maxLength: 150),
                    InnerDiameter1 = c.Decimal(precision: 18, scale: 2),
                    InnerDiameter2 = c.Decimal(precision: 18, scale: 2),
                    OutDiameter1 = c.Decimal(precision: 18, scale: 2),
                    OutDiameter2 = c.Decimal(precision: 18, scale: 2),
                    Thickness1 = c.Decimal(precision: 18, scale: 2),
                    Thickness2 = c.Decimal(precision: 18, scale: 2),
                    Height1 = c.Decimal(precision: 18, scale: 2),
                    Height2 = c.Decimal(precision: 18, scale: 2),
                    InnerChamfer1 = c.Decimal(precision: 18, scale: 2),
                    InnerChamfer2 = c.Decimal(precision: 18, scale: 2),
                    OutChamfer1 = c.Decimal(precision: 18, scale: 2),
                    OutChamfer2 = c.Decimal(precision: 18, scale: 2),
                    ThousandWeigh = c.Decimal(precision: 18, scale: 2),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Standard",
                c => new
                {
                    StandardId = c.Int(nullable: false, identity: true),
                    StandardName = c.String(nullable: false, maxLength: 50),
                    StandardDesc = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                })
                .PrimaryKey(t => t.StandardId);

            CreateTable(
                "dbo.StatementBill",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    StatementBillNo = c.String(nullable: false, maxLength: 30),
                    CustomerId = c.String(nullable: false, maxLength: 30),
                    BillMan = c.String(maxLength: 20),
                    Description = c.String(maxLength: 4000),
                    StatementState = c.Int(),
                    OrderStickBillNo = c.String(maxLength: 30),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.StatementBillNo, unique: true);

            CreateTable(
                "dbo.StoreHouseLocation",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    StoreLocationNo = c.String(maxLength: 32),
                    StoreAreaCode = c.String(maxLength: 32),
                    ShelfNumber = c.String(maxLength: 50),
                    ShelfLevel = c.String(maxLength: 10),
                    SequenceNo = c.String(maxLength: 10),
                    Remark = c.String(maxLength: 250),
                    StoreHouseId = c.Int(),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_StoreHouseLocation_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.StoreHouse",
                c => new
                {
                    StoreHouseID = c.Int(nullable: false, identity: true),
                    StoreHouseName = c.String(nullable: false, maxLength: 50),
                    StoreHouseTypeId = c.Int(),
                    Address = c.String(maxLength: 250),
                    Tel = c.String(maxLength: 50),
                    Fax = c.String(maxLength: 50),
                    ContactMan = c.String(maxLength: 50),
                    Remark = c.String(maxLength: 500),
                    IsLock = c.String(maxLength: 1),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                    StoreHouseNo = c.String(maxLength: 20),
                })
                .PrimaryKey(t => t.StoreHouseID);

            CreateTable(
                "dbo.Sys_AttachFiles",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    AttachNo = c.String(maxLength: 32),
                    TableName = c.String(maxLength: 50),
                    ColumnName = c.String(maxLength: 50),
                    SourceKey = c.String(maxLength: 50),
                    FileTitle = c.String(maxLength: 50),
                    FileName = c.String(maxLength: 50),
                    FilePath = c.String(maxLength: 500),
                    FileType = c.String(maxLength: 20),
                    FileExt = c.String(maxLength: 10),
                    Description = c.String(maxLength: 500),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Sys_Helps",
                c => new
                {
                    HelpId = c.Int(nullable: false, identity: true),
                    Classification = c.String(maxLength: 40),
                    HelpTitle = c.String(nullable: false, maxLength: 20),
                    HelpKeyWords = c.String(maxLength: 20),
                    HelpContent = c.String(storeType: "ntext"),
                    Sequence = c.Int(nullable: false),
                    TimeCreated = c.DateTime(storeType: "smalldatetime"),
                    TimeLastMod = c.DateTime(storeType: "smalldatetime"),
                    UserIDLastMod = c.String(maxLength: 20),
                })
                .PrimaryKey(t => t.HelpId);

            CreateTable(
                "dbo.Sys_States",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    StateNo = c.String(maxLength: 32),
                    StateName = c.String(maxLength: 50),
                    TableName = c.String(nullable: false, maxLength: 50),
                    ColumnName = c.String(nullable: false, maxLength: 50),
                    CodeValue = c.String(nullable: false, maxLength: 100),
                    DisplayValue = c.String(nullable: false, maxLength: 100),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysState_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id)
                .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
                .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
                .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
                .Index(t => t.DeleterUserId)
                .Index(t => t.LastModifierUserId)
                .Index(t => t.CreatorUserId);

            CreateTable(
                "dbo.TemplateInfos",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    TemplateNo = c.String(maxLength: 50),
                    Name = c.String(maxLength: 50),
                    Description = c.String(maxLength: 500),
                    Content = c.String(),
                    Type = c.Int(nullable: false),
                    TempKey = c.String(maxLength: 50),
                    FilePath = c.String(maxLength: 300),
                    FileExt = c.String(maxLength: 50),
                    ClassPath = c.String(maxLength: 100),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Sys_UserLoginLogs",
                c => new
                {
                    Id = c.Long(nullable: false, identity: true),
                    UserId = c.Long(),
                    UserNameOrEmailAddress = c.String(maxLength: 255),
                    ClientIpAddress = c.String(maxLength: 64),
                    ClientName = c.String(maxLength: 128),
                    BrowserInfo = c.String(maxLength: 512),
                    Result = c.Byte(nullable: false),
                    CreationTime = c.DateTime(nullable: false),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.Sys_UserLogins",
                c => new
                {
                    Id = c.Long(nullable: false, identity: true),
                    UserId = c.Long(nullable: false),
                    LoginProvider = c.String(nullable: false, maxLength: 128),
                    ProviderKey = c.String(nullable: false, maxLength: 256),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.v_BookedProductNum",
                c => new
                {
                    ProductNo = c.String(nullable: false, maxLength: 128),
                    BookedQuantity = c.Decimal(precision: 18, scale: 2),
                })
                .PrimaryKey(t => t.ProductNo);

            CreateTable(
                "dbo.v_CanProductStore",
                c => new
                {
                    ProductNo = c.String(nullable: false, maxLength: 128),
                    CanUserQuantity = c.Decimal(precision: 18, scale: 2),
                })
                .PrimaryKey(t => t.ProductNo);

            CreateTable(
                "dbo.N_ViewCurrentProductStoreHouse",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    CurrentProductStoreHouseNo = c.String(nullable: false),
                    ProductionOrderNo = c.String(nullable: false),
                    StoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(),
                    ProductNo = c.String(),
                    FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    ProductName = c.String(maxLength: 50),
                    Model = c.String(maxLength: 20),
                    Material = c.String(maxLength: 50),
                    SurfaceColor = c.String(maxLength: 50),
                    Rigidity = c.String(maxLength: 50),
                    IsStandard = c.String(maxLength: 1),
                    ProductDesc = c.String(),
                    PartNo = c.String(),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
                    PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
                    InventoryCheckState = c.Int(),
                    ReturnState = c.Int(),
                    StoreAreaCode = c.String(),
                    ShelfNumber = c.String(),
                    ShelfLevel = c.String(),
                    SequenceNo = c.String(),
                    LocationRemark = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewCurrentRmStoreHouse",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductionOrderNo = c.String(maxLength: 11),
                    StoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(maxLength: 32),
                    RmProductNo = c.String(maxLength: 32),
                    FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    Remark = c.String(maxLength: 150),
                    PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
                    ProductName = c.String(),
                    Material = c.String(),
                    Model = c.String(),
                    ProductDesc = c.String(),
                    StoreHouseName = c.String(),
                    ProductBatchNum = c.String(),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ViewCurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewCurrentSemiStoreHouse",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    CurrentSemiStoreHouseNo = c.String(nullable: false, maxLength: 32),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    StoreHouseId = c.Int(nullable: false),
                    SemiProductNo = c.String(maxLength: 32),
                    FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ApplyEnterDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    SemiProductName = c.String(maxLength: 50),
                    Model = c.String(maxLength: 20),
                    PartNo = c.String(),
                    Material = c.String(maxLength: 50),
                    SurfaceColor = c.String(maxLength: 50),
                    Rigidity = c.String(maxLength: 50),
                    IsStandard = c.String(maxLength: 1),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
                    StoreLocationNo = c.String(),
                    PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
                    InventoryCheckState = c.Int(),
                    ReturnState = c.Int(),
                    StoreAreaCode = c.String(),
                    ShelfNumber = c.String(),
                    ShelfLevel = c.String(),
                    SequenceNo = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.v_SemiProductStoreInfo",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    AllQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    AllFreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    AllPreMonthQuantity = c.Decimal(precision: 18, scale: 2),
                    SemiProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    PartNo = c.String(),
                    ProductDesc = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.v_ProductStoreInfo",
                c => new
                {
                    ProductNo = c.String(nullable: false, maxLength: 128),
                    AllQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    AllFreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    AllPreMonthQuantity = c.Decimal(precision: 18, scale: 2),
                    ProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    PartNo = c.String(),
                    Defprice = c.Decimal(precision: 18, scale: 3),
                })
                .PrimaryKey(t => t.ProductNo);

            CreateTable(
                "dbo.v_customerstick",
                c => new
                {
                    OrderSendId = c.Int(nullable: false, identity: true),
                    OrderNo = c.String(),
                    StockNo = c.String(),
                    OrderSendBillNo = c.String(),
                    SendDate = c.DateTime(),
                    PartNo = c.String(),
                    Model = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    SendQuantity = c.Decimal(precision: 18, scale: 2),
                    OrderUnitId = c.Int(),
                    Price = c.Decimal(precision: 18, scale: 2),
                    total = c.Decimal(precision: 18, scale: 2),
                    CustomerId = c.String(),
                    OrderUnitName = c.String(),
                    IsDoBill = c.String(),
                    Remark = c.String(),
                    OrderStickBillNo = c.String(),
                    StatementBillNo = c.String(),
                })
                .PrimaryKey(t => t.OrderSendId);

            CreateTable(
                "dbo.N_ViewDisqualifiedProduction",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    DisqualifiedNo = c.String(maxLength: 20),
                    ProductOrderNo = c.String(maxLength: 11),
                    ReturnOrderNo = c.String(maxLength: 32),
                    ProductNo = c.String(maxLength: 50),
                    ProductName = c.String(maxLength: 100),
                    ProductType = c.Int(nullable: false),
                    QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
                    HandleType = c.Int(nullable: false),
                    CheckUser = c.String(maxLength: 20),
                    CheckDate = c.DateTime(),
                    HandleUser = c.String(maxLength: 20),
                    HandleDate = c.DateTime(),
                    DisqualifiedType = c.Int(),
                    CreationTime = c.DateTime(nullable: false),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewDisqualifiedReturn",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    DisqualifiedNo = c.String(maxLength: 20),
                    ProductOrderNo = c.String(maxLength: 11),
                    ReturnOrderNo = c.String(maxLength: 32),
                    ProductNo = c.String(maxLength: 50),
                    ProductName = c.String(maxLength: 100),
                    ProductType = c.Int(nullable: false),
                    QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
                    QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
                    HandleType = c.Int(nullable: false),
                    CheckUser = c.String(maxLength: 20),
                    CheckDate = c.DateTime(),
                    HandleUser = c.String(maxLength: 20),
                    HandleDate = c.DateTime(),
                    DisqualifiedType = c.Int(),
                    CreationTime = c.DateTime(nullable: false),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    CustomerId = c.String(),
                    CustomerName = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.NV_ViewEmployeeInfo",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    No = c.String(),
                    Name = c.String(),
                    CardId = c.String(),
                    Gender = c.Int(nullable: false),
                    PhoneNumber = c.String(),
                    DepartmentNo = c.String(),
                    DepartmentName = c.String(),
                    DutyNo = c.String(),
                    DutyName = c.String(),
                    Description = c.String(),
                    UserName = c.String(),
                    Remark = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.vEnterOutLogDetail_c",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ActualId = c.Int(nullable: false),
                    EnterOutFlag = c.Int(nullable: false),
                    ProductNo = c.String(),
                    StoreHouseId = c.Int(nullable: false),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    DateTiem = c.DateTime(),
                    UserIDLastMod = c.String(),
                    Remark = c.String(),
                    ProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    PartNo = c.String(),
                    CustomerId = c.String(),
                    CustomerName = c.String(),
                    ProductionOrderNo = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.v_Store_Query",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ActualId = c.Int(nullable: false),
                    EnterOutFlag = c.Int(nullable: false),
                    ProductNo = c.String(),
                    StoreHouseId = c.Int(nullable: false),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    DateTiem = c.DateTime(),
                    UserIDLastMod = c.String(),
                    Remark = c.String(),
                    ProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    PartNo = c.String(),
                    AllQuantity = c.Decimal(precision: 18, scale: 2),
                    AllFreezeQuantity = c.Decimal(precision: 18, scale: 2),
                    AllPreMonthQuantity = c.Decimal(precision: 18, scale: 2),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.v_EnterOutSemiProductStore",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ActualId = c.Int(nullable: false),
                    EnterOutFlag = c.Int(nullable: false),
                    SemiProductNo = c.String(),
                    StoreHouseId = c.Int(nullable: false),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    DateTiem = c.DateTime(),
                    UserIDLastMod = c.String(),
                    Remark = c.String(),
                    SemiProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    PartNo = c.String(),
                    ProductDesc = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewInventoryCheckRecord_Product",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductNo = c.String(),
                    ProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    ProductDesc = c.String(),
                    CheckNo = c.String(),
                    CurrentStoreHouseNo = c.String(),
                    CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    StoreLocationNo = c.String(),
                    StoreHouseId = c.Int(nullable: false),
                    ProductionOrderNo = c.String(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewInventoryCheckRecord_Semi",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductNo = c.String(),
                    ProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    ProductDesc = c.String(),
                    CheckNo = c.String(),
                    CurrentStoreHouseNo = c.String(),
                    CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    StoreLocationNo = c.String(),
                    StoreHouseId = c.Int(nullable: false),
                    ProductionOrderNo = c.String(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewOrderItems",
                c => new
                {
                    OrderItemId = c.Int(nullable: false, identity: true),
                    OrderNo = c.String(),
                    ProductNo = c.String(),
                    Price = c.Decimal(nullable: false, storeType: "money"),
                    AfterTaxPrice = c.Decimal(nullable: false, storeType: "money"),
                    CurrencyId = c.String(),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2, storeType: "numeric"),
                    OrderUnitId = c.Int(nullable: false),
                    SendDate = c.DateTime(nullable: false, storeType: "smalldatetime"),
                    IsReport = c.String(),
                    IsPartSend = c.String(),
                    OrderItemStatusId = c.Int(),
                    WareHouse = c.String(),
                    OrderItemDesc = c.String(),
                    PartNo = c.String(),
                    TotalPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
                    CustomerId = c.String(),
                    LinkName = c.String(),
                    OrderDate = c.DateTime(storeType: "smalldatetime"),
                    Fax = c.String(),
                    Telephone = c.String(),
                    ProductName = c.String(),
                    Model = c.String(),
                    StandardId = c.Int(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    IsStandard = c.String(),
                    IsSendQuantity = c.Decimal(precision: 18, scale: 2),
                    OrderUnitName = c.String(),
                    StockNo = c.String(),
                    CustomerName = c.String(),
                    AfterTaxTotalPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
                    SaleType = c.Int(),
                    SaleMan = c.String(),
                    EmergencyLevel = c.Int(nullable: false),
                    IsLock = c.String(),
                    StandardName = c.String(),
                    StoreCompleteState = c.Int(nullable: false),
                    LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                })
                .PrimaryKey(t => t.OrderItemId);

            CreateTable(
                "dbo.v_OrderSendBill",
                c => new
                {
                    OrderSendBillNo = c.String(nullable: false, maxLength: 128),
                    CustomerId = c.String(),
                    SendDate = c.DateTime(),
                    SendAddress = c.String(),
                    ContactTels = c.String(),
                    ContactMan = c.String(),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    UserIDLastMod = c.String(),
                    IsDoBill = c.String(),
                    OrderSendCount = c.Int(nullable: false),
                    StatementCount = c.Int(nullable: false),
                    ExpressId = c.Int(),
                    ExpressBillNo = c.String(),
                    ExpressName = c.String(),
                    CreatorUserId = c.String(),
                    TotalPrice = c.Decimal(precision: 18, scale: 3),
                    AfterTaxTotalPrice = c.Decimal(precision: 18, scale: 3),
                    CurrencyId = c.String(),
                })
                .PrimaryKey(t => t.OrderSendBillNo);

            CreateTable(
                "dbo.N_ViewOrderSends",
                c => new
                {
                    OrderSendId = c.Int(nullable: false, identity: true),
                    OrderItemId = c.Int(nullable: false),
                    SendDate = c.DateTime(),
                    SendQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    Remark = c.String(),
                    OrderSendBillNo = c.String(),
                    OrderStickBillNo = c.String(),
                    QuantityPerPack = c.Decimal(precision: 18, scale: 2),
                    PackageCount = c.Decimal(precision: 18, scale: 2),
                    ProductBatchNum = c.String(),
                    UserIDLastMod = c.String(),
                    OrderNo = c.String(),
                    ProductNo = c.String(),
                    Price = c.Decimal(nullable: false, precision: 18, scale: 2),
                    TotalPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
                    IsReport = c.String(),
                    PartNo = c.String(),
                    ProductName = c.String(),
                    Model = c.String(),
                    StandardId = c.Int(),
                    Material = c.String(),
                    ProductDesc = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    CustomerId = c.String(),
                    CustomerName = c.String(),
                    LinkName = c.String(),
                    OrderDate = c.DateTime(),
                    CustomerSendId = c.Int(),
                    StockNo = c.String(),
                    OrderUnitName = c.String(),
                    SaleType = c.Int(),
                    AfterTaxPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
                    StatementBillNo = c.String(),
                    SendActionDate = c.DateTime(),
                    StandardName = c.String(),
                    LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                    SendBillSort = c.Int(nullable: false),
                    StatementBillSort = c.Int(nullable: false),
                })
                .PrimaryKey(t => t.OrderSendId);

            CreateTable(
                "dbo.vwOrderSendBill",
                c => new
                {
                    OrderSendId = c.Int(nullable: false, identity: true),
                    OrderItemId = c.Int(nullable: false),
                    SendDate = c.DateTime(),
                    SendQuantity = c.Decimal(precision: 18, scale: 2),
                    Remark = c.String(),
                    OrderSendBillNo = c.String(),
                    OrderStickBillNo = c.String(),
                    StatementBillNo = c.String(),
                    UserIDLastMod = c.String(),
                    OrderNo = c.String(),
                    ProductNo = c.String(),
                    Price = c.Decimal(nullable: false, precision: 18, scale: 2),
                    totalprice = c.Decimal(nullable: false, precision: 18, scale: 2),
                    IsReport = c.String(),
                    PartNo = c.String(),
                    ProductName = c.String(),
                    Model = c.String(),
                    StandardId = c.Int(),
                    Material = c.String(),
                    ProductDesc = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    CustomerId = c.String(),
                    LinkName = c.String(),
                    OrderDate = c.DateTime(),
                    CustomerSendId = c.Int(nullable: false),
                    StockNo = c.String(),
                    OrderUnitName = c.String(),
                    CurrencyId = c.String(),
                    AfterTaxPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
                    LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
                    LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                    MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
                    AfterTaxTotalprice = c.Decimal(nullable: false, precision: 18, scale: 2),
                    SendBillSort = c.Int(nullable: false),
                    StatementBillSort = c.Int(nullable: false),
                })
                .PrimaryKey(t => t.OrderSendId);

            CreateTable(
                "dbo.N_ViewPackageApply",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    PackageApplyNo = c.String(),
                    CurrentStoreHouseNo = c.String(),
                    ProductionOrderNo = c.String(),
                    SemiProductNo = c.String(),
                    ProductNo = c.String(),
                    ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    SourceStore = c.Int(nullable: false),
                    ApplyStatus = c.String(),
                    IsClose = c.Boolean(nullable: false),
                    ApplyDate = c.DateTime(),
                    Remark = c.String(),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(),
                    UserIDLastMod = c.String(),
                    ProcessingNum = c.Int(nullable: false),
                    IsApplyEnterQuantity = c.Decimal(precision: 18, scale: 2),
                    IsApplyEnterQuantity2 = c.Decimal(precision: 18, scale: 2),
                    KgWeight = c.Decimal(precision: 18, scale: 2),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewProductEnterStore",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(maxLength: 11),
                    PackageApplyNo = c.String(nullable: false),
                    PackageProductNo = c.String(maxLength: 32),
                    ProductNo = c.String(),
                    StoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    ApplySourceType = c.Int(nullable: false),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    PackageSpecification = c.Decimal(nullable: false, precision: 18, scale: 2),
                    PackageCount = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ActualPackageCount = c.Decimal(nullable: false, precision: 18, scale: 2),
                    AuditUser = c.String(),
                    AuditDate = c.DateTime(),
                    ApplyEnterDate = c.DateTime(),
                    Remark = c.String(),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(),
                    UserIDLastMod = c.String(),
                    ProductName = c.String(),
                    Model = c.String(maxLength: 20),
                    Material = c.String(maxLength: 50),
                    SurfaceColor = c.String(maxLength: 50),
                    Rigidity = c.String(maxLength: 50),
                    IsStandard = c.String(maxLength: 1),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
                    SourceStoreHouseId = c.Int(nullable: false),
                    CreateSourceType = c.Int(),
                    PackageEnterNum = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewProductOutStore",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(),
                    CurrentProductStoreHouseNo = c.String(),
                    StoreHouseId = c.Int(nullable: false),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(),
                    IsConfirm = c.Boolean(),
                    ProductNo = c.String(),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ApplyOutDate = c.DateTime(),
                    Remark = c.String(),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(),
                    UserIDLastMod = c.String(),
                    AuditUser = c.String(),
                    AuditDate = c.DateTime(),
                    ProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    IsStandard = c.String(),
                    CustomerId = c.String(),
                    CustomerName = c.String(),
                    OrderSendBillNo = c.String(),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ApplyOutStoreSourceType = c.Int(nullable: false),
                    CreateSourceType = c.Int(),
                    OrderDate = c.DateTime(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.v_QueryCurrentProductNum",
                c => new
                {
                    ProductNo = c.String(nullable: false, maxLength: 128),
                    BookedQuantity = c.Decimal(precision: 18, scale: 2),
                    CanUserQuantity = c.Decimal(precision: 18, scale: 2),
                })
                .PrimaryKey(t => t.ProductNo);

            CreateTable(
                "dbo.N_ViewRmEnterStore",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    RmProductNo = c.String(maxLength: 50),
                    StoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(maxLength: 32),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    AuditUser = c.String(maxLength: 32),
                    AuditDate = c.DateTime(),
                    ApplyEnterDate = c.DateTime(),
                    EnterStoreUser = c.String(maxLength: 32),
                    EnterStoreDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    ProductName = c.String(),
                    Material = c.String(),
                    Model = c.String(),
                    ProductDesc = c.String(),
                    StoreHouseName = c.String(),
                    ProductBatchNum = c.String(),
                    CreateSourceType = c.Int(),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ViewRmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewRmOutStore",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductionOrderNo = c.String(maxLength: 11),
                    CurrentRmStoreHouseNo = c.String(maxLength: 32),
                    RmProductNo = c.String(maxLength: 50),
                    StoreHouseId = c.Int(nullable: false),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    IsConfirm = c.Boolean(),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    AuditUser = c.String(maxLength: 150),
                    AuditDate = c.DateTime(),
                    OutStoreUser = c.String(maxLength: 150),
                    OutStoreDate = c.DateTime(),
                    ApplyOutDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    ProductName = c.String(),
                    Material = c.String(),
                    Model = c.String(),
                    ProductDesc = c.String(),
                    StoreHouseName = c.String(),
                    ProductBatchNum = c.String(),
                    CreateSourceType = c.Int(),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ViewRmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewScrapEnterStore",
                c => new
                {
                    Id = c.String(nullable: false, maxLength: 128),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    ProductNo = c.String(maxLength: 50),
                    StoreHouseId = c.Int(nullable: false),
                    StoreLocationNo = c.String(maxLength: 32),
                    ApplyStatus = c.Int(nullable: false),
                    IsClose = c.Boolean(nullable: false),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
                    AuditUser = c.String(maxLength: 32),
                    AuditDate = c.DateTime(),
                    ApplyEnterDate = c.DateTime(),
                    EnterStoreUser = c.String(maxLength: 32),
                    EnterStoreDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    ProductName = c.String(),
                    Material = c.String(),
                    Model = c.String(),
                    ProductDesc = c.String(),
                    StoreHouseName = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    ProductType = c.Int(),
                    ScrapSource = c.Int(nullable: false),
                    ScrapSourceNo = c.String(),
                    IsDeleted = c.Boolean(nullable: false),
                    DeleterUserId = c.Long(),
                    DeletionTime = c.DateTime(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                },
                annotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewSemiEnterStore",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(nullable: false, maxLength: 11),
                    StoreHouseId = c.Int(nullable: false),
                    ApplyStatus = c.String(nullable: false, maxLength: 1),
                    IsClose = c.Boolean(),
                    ApplySource = c.String(nullable: false, maxLength: 1),
                    SemiProductNo = c.String(maxLength: 32),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    AuditUser = c.String(maxLength: 20),
                    AuditDate = c.DateTime(),
                    ApplyEnterDate = c.DateTime(),
                    Remark = c.String(maxLength: 150),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(maxLength: 20),
                    UserIDLastMod = c.String(maxLength: 20),
                    SemiProductName = c.String(maxLength: 50),
                    Model = c.String(maxLength: 20),
                    Material = c.String(maxLength: 50),
                    SurfaceColor = c.String(maxLength: 50),
                    Rigidity = c.String(maxLength: 50),
                    IsStandard = c.String(maxLength: 1),
                    PartNo = c.String(maxLength: 50),
                    TranUnitValue = c.Decimal(precision: 18, scale: 2),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
                    CreateSourceType = c.Int(),
                    StoreLocationNo = c.String(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewSemiOutStore",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    ProductionOrderNo = c.String(),
                    CurrentSemiStoreHouseNo = c.String(),
                    StoreHouseId = c.Int(nullable: false),
                    ApplyStatus = c.String(),
                    ApplyTypes = c.Int(nullable: false),
                    IsClose = c.Boolean(),
                    IsConfirm = c.Boolean(),
                    ApplyOutStoreSource = c.String(),
                    SemiProductNo = c.String(),
                    Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
                    ApplyOutDate = c.DateTime(),
                    Remark = c.String(),
                    TimeCreated = c.DateTime(),
                    TimeLastMod = c.DateTime(),
                    CreatorUserId = c.String(),
                    UserIDLastMod = c.String(),
                    AuditUser = c.String(),
                    AuditDate = c.DateTime(),
                    SemiProductName = c.String(),
                    Model = c.String(),
                    Material = c.String(),
                    SurfaceColor = c.String(),
                    Rigidity = c.String(),
                    IsStandard = c.String(),
                    PartNo = c.String(),
                    TranUnitValue = c.Decimal(precision: 18, scale: 2),
                    KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
                    CreateSourceType = c.Int(),
                })
                .PrimaryKey(t => t.Id);

            CreateTable(
                "dbo.N_ViewStatementBill",
                c => new
                {
                    Id = c.Int(nullable: false, identity: true),
                    StatementBillNo = c.String(nullable: false, maxLength: 30),
                    CustomerId = c.String(nullable: false, maxLength: 30),
                    BillMan = c.String(maxLength: 20),
                    Description = c.String(maxLength: 4000),
                    StatementState = c.Int(),
                    CustomerName = c.String(),
                    OrderStickBillNo = c.String(),
                    TotalPrice = c.Decimal(precision: 18, scale: 3),
                    AfterTaxTotalPrice = c.Decimal(precision: 18, scale: 3),
                    CurrencyId = c.String(),
                    LastModificationTime = c.DateTime(),
                    LastModifierUserId = c.Long(),
                    CreationTime = c.DateTime(nullable: false),
                    CreatorUserId = c.Long(),
                })
                .PrimaryKey(t => t.Id)
                .Index(t => t.StatementBillNo, unique: true);

            CreateTable(
                "dbo.v_OrderStickBill",
                c => new
                {
                    OrderStickBillNo = c.String(nullable: false, maxLength: 128),
                    CustomerId = c.String(),
                    CreatDate = c.DateTime(),
                    StickNum = c.String(),
                    StickMan = c.String(),
                    Description = c.String(),
                    TimeCreated = c.DateTime(),
                    CustomerName = c.String(),
                    Address = c.String(),
                    LinkMan = c.String(),
                    TotalPrice = c.Decimal(precision: 18, scale: 3),
                    AfterTaxTotalPrice = c.Decimal(precision: 18, scale: 3),
                    CurrencyId = c.String(),
                    InvoiceState = c.Int(),
                    Amount = c.Decimal(precision: 18, scale: 2),
                    OriginalStickNum = c.String(),
                    ReturnOrderNo = c.String(),
                    OrderNo = c.String(),
                    InvoiceType = c.Int(nullable: false),
                })
                .PrimaryKey(t => t.OrderStickBillNo);

        }

        public override void Down()
        {
            DropForeignKey("dbo.Sys_States", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_States", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_States", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Settings", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Settings", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Settings", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.ScrapTypeInfo", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.ScrapTypeInfo", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.ScrapTypeInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Roles", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Roles", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Roles", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.QualityIssueLabelInfo", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.QualityIssueLabelInfo", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.QualityIssueLabelInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.ProductionOrderLogInfo", "EmployeeId", "dbo.EmployeeInfo");
            DropForeignKey("dbo.ProductionOrderLogInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.MoldProductionRecord", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.MoldProductionRecord", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.MoldInfo", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.MoldInfo", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.MoldInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.MaintenanceRecordInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.MaintenanceMemberInfo", "EmployeeId", "dbo.EmployeeInfo");
            DropForeignKey("dbo.MaintenanceMemberInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.LicenseTypeInfo", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.LicenseTypeInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.LicenseDocumentInfo", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.LicenseDocumentInfo", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.LicenseDocumentInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Functions", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Functions", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Functions", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.FixedAssetTypeInfo", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.FixedAssetTypeInfo", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.FixedAssetTypeInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.FixedAssetInfo", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.FixedAssetInfo", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.FixedAssetInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.ExpressProviderMappers", "ProviderId", "dbo.ExpressServiceProviders");
            DropForeignKey("dbo.ExpressProviderMappers", "ExpressId", "dbo.ExpressLogistics");
            DropForeignKey("dbo.EmployeeWorkPerformanceInfo", "EmployeeId", "dbo.EmployeeInfo");
            DropForeignKey("dbo.EmployeeWorkPerformanceInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.EmployeeInfo", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.EmployeeInfo", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.EmployeeInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.DisqualifiedProductInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.DeviceMgPlanInfo", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.DeviceMgPlanInfo", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.DeviceMgPlanInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.CustomerDisProductInfo", "CreatorUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_UserRoles", "UserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Users", "LastModifierUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Users", "DeleterUserId", "dbo.Sys_Users");
            DropForeignKey("dbo.Sys_Users", "CreatorUserId", "dbo.Sys_Users");
            DropIndex("dbo.N_ViewStatementBill", new[] { "StatementBillNo" });
            DropIndex("dbo.Sys_States", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_States", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_States", new[] { "DeleterUserId" });
            DropIndex("dbo.StatementBill", new[] { "StatementBillNo" });
            DropIndex("dbo.Sys_Settings", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_Settings", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_Settings", new[] { "DeleterUserId" });
            DropIndex("dbo.ScrapTypeInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.ScrapTypeInfo", new[] { "LastModifierUserId" });
            DropIndex("dbo.ScrapTypeInfo", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_Roles", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_Roles", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_Roles", new[] { "DeleterUserId" });
            DropIndex("dbo.ReturnGoodOrder", new[] { "ReturnOrderNo" });
            DropIndex("dbo.QualityIssueLabelInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.QualityIssueLabelInfo", new[] { "LastModifierUserId" });
            DropIndex("dbo.QualityIssueLabelInfo", new[] { "DeleterUserId" });
            DropIndex("dbo.ProductionOrderLogInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.ProductionOrderLogInfo", new[] { "EmployeeId" });
            DropIndex("dbo.MoldProductionRecord", new[] { "CreatorUserId" });
            DropIndex("dbo.MoldProductionRecord", new[] { "LastModifierUserId" });
            DropIndex("dbo.MoldInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.MoldInfo", new[] { "LastModifierUserId" });
            DropIndex("dbo.MoldInfo", new[] { "DeleterUserId" });
            DropIndex("dbo.MaintenanceRecordInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.MaintenanceMemberInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.MaintenanceMemberInfo", new[] { "EmployeeId" });
            DropIndex("dbo.LicenseTypeInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.LicenseTypeInfo", new[] { "LastModifierUserId" });
            DropIndex("dbo.LicenseDocumentInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.LicenseDocumentInfo", new[] { "LastModifierUserId" });
            DropIndex("dbo.LicenseDocumentInfo", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_Functions", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_Functions", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_Functions", new[] { "DeleterUserId" });
            DropIndex("dbo.FixedAssetTypeInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.FixedAssetTypeInfo", new[] { "LastModifierUserId" });
            DropIndex("dbo.FixedAssetTypeInfo", new[] { "DeleterUserId" });
            DropIndex("dbo.FixedAssetInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.FixedAssetInfo", new[] { "LastModifierUserId" });
            DropIndex("dbo.FixedAssetInfo", new[] { "DeleterUserId" });
            DropIndex("dbo.ExpressProviderMappers", new[] { "ProviderId" });
            DropIndex("dbo.ExpressProviderMappers", new[] { "ExpressId" });
            DropIndex("dbo.EmployeeWorkPerformanceInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.EmployeeWorkPerformanceInfo", new[] { "EmployeeId" });
            DropIndex("dbo.EmployeeInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.EmployeeInfo", new[] { "LastModifierUserId" });
            DropIndex("dbo.EmployeeInfo", new[] { "DeleterUserId" });
            DropIndex("dbo.DisqualifiedProductInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.DeviceMgPlanInfo", new[] { "CreatorUserId" });
            DropIndex("dbo.DeviceMgPlanInfo", new[] { "LastModifierUserId" });
            DropIndex("dbo.DeviceMgPlanInfo", new[] { "DeleterUserId" });
            DropIndex("dbo.Sys_UserRoles", new[] { "UserId" });
            DropIndex("dbo.Sys_Users", new[] { "CreatorUserId" });
            DropIndex("dbo.Sys_Users", new[] { "LastModifierUserId" });
            DropIndex("dbo.Sys_Users", new[] { "DeleterUserId" });
            DropIndex("dbo.CustomerDisProductInfo", new[] { "CreatorUserId" });
            DropTable("dbo.v_OrderStickBill");
            DropTable("dbo.N_ViewStatementBill");
            DropTable("dbo.N_ViewSemiOutStore");
            DropTable("dbo.N_ViewSemiEnterStore");
            DropTable("dbo.N_ViewScrapEnterStore",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.N_ViewRmOutStore",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ViewRmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.N_ViewRmEnterStore",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ViewRmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.v_QueryCurrentProductNum");
            DropTable("dbo.N_ViewProductOutStore");
            DropTable("dbo.N_ViewProductEnterStore");
            DropTable("dbo.N_ViewPackageApply");
            DropTable("dbo.vwOrderSendBill");
            DropTable("dbo.N_ViewOrderSends");
            DropTable("dbo.v_OrderSendBill");
            DropTable("dbo.N_ViewOrderItems");
            DropTable("dbo.N_ViewInventoryCheckRecord_Semi");
            DropTable("dbo.N_ViewInventoryCheckRecord_Product");
            DropTable("dbo.v_EnterOutSemiProductStore");
            DropTable("dbo.v_Store_Query");
            DropTable("dbo.vEnterOutLogDetail_c");
            DropTable("dbo.NV_ViewEmployeeInfo");
            DropTable("dbo.N_ViewDisqualifiedReturn");
            DropTable("dbo.N_ViewDisqualifiedProduction");
            DropTable("dbo.v_customerstick");
            DropTable("dbo.v_ProductStoreInfo");
            DropTable("dbo.v_SemiProductStoreInfo");
            DropTable("dbo.N_ViewCurrentSemiStoreHouse");
            DropTable("dbo.N_ViewCurrentRmStoreHouse",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ViewCurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.N_ViewCurrentProductStoreHouse");
            DropTable("dbo.v_CanProductStore");
            DropTable("dbo.v_BookedProductNum");
            DropTable("dbo.Sys_UserLogins");
            DropTable("dbo.Sys_UserLoginLogs");
            DropTable("dbo.TemplateInfos");
            DropTable("dbo.Sys_States",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysState_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_Helps");
            DropTable("dbo.Sys_AttachFiles");
            DropTable("dbo.StoreHouse");
            DropTable("dbo.StoreHouseLocation",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_StoreHouseLocation_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.StatementBill");
            DropTable("dbo.Standard");
            DropTable("dbo.StandardDetail",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.StandardCatalog",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_StandardCatalog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.ShortMsgDetail");
            DropTable("dbo.ShortMessage");
            DropTable("dbo.Sys_Settings",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysSetting_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.SemiProductStore");
            DropTable("dbo.SemiProducts");
            DropTable("dbo.SemiOutStores");
            DropTable("dbo.SemiEnterStore");
            DropTable("dbo.ScrapTypeInfo",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ScrapType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.ScrapEnterStore",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.N_ViewScheduleOrderSend");
            DropTable("dbo.ScheduleOrderSend");
            DropTable("dbo.Sys_Roles",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysRole_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.RmProduct",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.RmOutStore",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_RmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.RmEnterStore",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_RmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.ReturnGoodOrder",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ReturnGoodOrder_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Regions");
            DropTable("dbo.QualityIssueLabelInfo",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_QualityIssueLabel_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.ProductInspectReportContents");
            DropTable("dbo.Products");
            DropTable("dbo.ProductProperties",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ProductProperty_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.ProductOutStore");
            DropTable("dbo.ProductMapper",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_ProductMapper_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.ProductionOrders");
            DropTable("dbo.ProductionOrderLogInfo");
            DropTable("dbo.ProductInspectReportInfos");
            DropTable("dbo.ProductInspectInfos");
            DropTable("dbo.Sys_Permissions");
            DropTable("dbo.PackageApply");
            DropTable("dbo.OutFactory");
            DropTable("dbo.OrderUnit");
            DropTable("dbo.OrderStickBills");
            DropTable("dbo.OrderSend");
            DropTable("dbo.OrderSendExceed");
            DropTable("dbo.OrderSendBills");
            DropTable("dbo.OrderProduction");
            DropTable("dbo.OrderItems");
            DropTable("dbo.OrderHeader");
            DropTable("dbo.MoldProductionRecord");
            DropTable("dbo.MoldInfo",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_Mold_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.MaintenanceRecordInfo");
            DropTable("dbo.MaintenanceMemberInfo");
            DropTable("dbo.LicenseTypeInfo");
            DropTable("dbo.LicenseDocumentInfo",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_LicenseDocument_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.InventoryCheckRecord");
            DropTable("dbo.InventoryCheck",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_InventoryCheckInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_Functions",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysFunction_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.FixedAssetTypeInfo",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_FixedAssetType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.FixedAssetInfo",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_FixedAsset_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.FinshedEnterStore");
            DropTable("dbo.Factories");
            DropTable("dbo.ExpressServiceProviders");
            DropTable("dbo.ExpressProviderMappers");
            DropTable("dbo.ExpressLogistics");
            DropTable("dbo.EmployeeWorkPerformanceInfo");
            DropTable("dbo.EmployeeInfo",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_Employee_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Dutys");
            DropTable("dbo.DisqualifiedProductInfo");
            DropTable("dbo.DeviceMgPlanInfo",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_DeviceMgPlan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Departments");
            DropTable("dbo.CustomerSend");
            DropTable("dbo.Customers");
            DropTable("dbo.CustomerInvoiceAddress",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_CustomerInvoiceAddress_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.Sys_UserRoles");
            DropTable("dbo.Sys_Users",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_SysUser_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.CustomerDisProductInfo");
            DropTable("dbo.CustomerDefaultProduct");
            DropTable("dbo.CurrentSemiStoreHouse");
            DropTable("dbo.CurrentRmStoreHouse",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_CurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.CurrentProductStoreHouse");
            DropTable("dbo.CurrencyExchangeRate");
            DropTable("dbo.Currency");
            DropTable("dbo.BusinessLogs",
                removedAnnotations: new Dictionary<string, object>
                {
                    { "DynamicFilter_BusinessLog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
                });
            DropTable("dbo.BulletinInfo");
            DropTable("dbo.BackUpCurrentSemiStoreHouse");
            DropTable("dbo.Sys_AuditLogs");
            DropTable("dbo.Sys_AppGuids");
        }
    }
}