namespace ShwasherSys.Migrations { using System; using System.Collections.Generic; using System.Data.Entity.Infrastructure.Annotations; using System.Data.Entity.Migrations; public partial class init : DbMigration { public override void Up() { //RenameTable(name: "dbo.ProductInspectReports", newName: "ProductInspectReportContents"); //RenameColumn(table: "dbo.PackageApply", name: "CurrentSemiStoreHouseNo", newName: "CurrentStoreHouseNo"); //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.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 // { // { "DynamicFilter_CurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }) // .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.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 // { // { "DynamicFilter_CustomerInvoiceAddress_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }) // .PrimaryKey(t => t.Id); //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 // { // { "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.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 // { // { "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.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 // { // { "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 // { // { "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.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 // { // { "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 // { // { "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 // { // { "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.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.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.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.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.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 // { // { "DynamicFilter_ProductMapper_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }) // .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 // { // { "DynamicFilter_ProductProperty_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }) // .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 // { // { "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.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 // { // { "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 // { // { "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 // { // { "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 // { // { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }) // .PrimaryKey(t => t.Id); //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 // { // { "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 // { // { "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.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 // { // { "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 // { // { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }) // .PrimaryKey(t => t.Id); //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.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 // { // { "DynamicFilter_ViewCurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }) // .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.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_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_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 // { // { "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 // { // { "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 // { // { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }) // .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); //AddColumn("dbo.BackUpCurrentSemiStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.CurrentProductStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.CurrentProductStoreHouse", "PreMonthQuantity", c => c.Decimal(precision: 18, scale: 3)); //AddColumn("dbo.CurrentProductStoreHouse", "InventoryCheckState", c => c.Int()); //AddColumn("dbo.CurrentProductStoreHouse", "ReturnState", c => c.Int()); //AddColumn("dbo.CurrentSemiStoreHouse", "StoreLocationNo", c => c.String(maxLength: 32)); //AddColumn("dbo.CurrentSemiStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.CurrentSemiStoreHouse", "PreMonthQuantity", c => c.Decimal(precision: 18, scale: 3)); //AddColumn("dbo.CurrentSemiStoreHouse", "InventoryCheckState", c => c.Int()); //AddColumn("dbo.CurrentSemiStoreHouse", "ReturnState", c => c.Int()); //AddColumn("dbo.CustomerDefaultProduct", "PartNo", c => c.String(maxLength: 30)); //AddColumn("dbo.Customers", "SaleType", c => c.Int()); //AddColumn("dbo.FinshedEnterStore", "PackageProductNo", c => c.String(maxLength: 50)); //AddColumn("dbo.FinshedEnterStore", "SourceStoreHouseId", c => c.Int(nullable: false)); //AddColumn("dbo.FinshedEnterStore", "ApplySourceType", c => c.Int(nullable: false)); //AddColumn("dbo.FinshedEnterStore", "ApplyQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.FinshedEnterStore", "EnterStoreUser", c => c.String(maxLength: 20)); //AddColumn("dbo.FinshedEnterStore", "EnterStoreDate", c => c.DateTime()); //AddColumn("dbo.FinshedEnterStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.FinshedEnterStore", "CreateSourceType", c => c.Int()); //AddColumn("dbo.FinshedEnterStore", "PackageEnterNum", c => c.String()); //AddColumn("dbo.FinshedEnterStore", "PackageUser", c => c.String(maxLength: 20)); //AddColumn("dbo.FinshedEnterStore", "VerifyUser", c => c.String(maxLength: 20)); //AddColumn("dbo.FinshedEnterStore", "ApplyQuantity2", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.Sys_Users", "AccountNo", c => c.String(maxLength: 20)); //AddColumn("dbo.OrderHeader", "SaleType", c => c.Int()); //AddColumn("dbo.OrderHeader", "SaleMan", c => c.String(maxLength: 50)); //AddColumn("dbo.OrderHeader", "IsLock", c => c.String(maxLength: 1)); //AddColumn("dbo.OrderItems", "ToCnyRate", c => c.Decimal(precision: 18, scale: 3)); //AddColumn("dbo.OrderItems", "EmergencyLevel", c => c.Int(nullable: false)); //AddColumn("dbo.OrderItems", "IsLock", c => c.String(maxLength: 1)); //AddColumn("dbo.OrderItems", "StandardName", c => c.String(maxLength: 50)); //AddColumn("dbo.OrderItems", "StoreCompleteState", c => c.Int(nullable: false)); //AddColumn("dbo.OrderItems", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.OrderItems", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.OrderItems", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.OrderItems", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.OrderSendBills", "ExpressId", c => c.Int()); //AddColumn("dbo.OrderSendBills", "ExpressBillNo", c => c.String(maxLength: 50)); //AddColumn("dbo.OrderSend", "CreatorUserId", c => c.String(maxLength: 20)); //AddColumn("dbo.OrderSend", "StatementBillNo", c => c.String(maxLength: 32)); //AddColumn("dbo.OrderSend", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.OrderSend", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.OrderSend", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.OrderSend", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.OrderSend", "SendBillSort", c => c.Int(nullable: false)); //AddColumn("dbo.OrderSend", "StatementBillSort", c => c.Int(nullable: false)); //AddColumn("dbo.OrderStickBills", "InvoiceState", c => c.Int()); //AddColumn("dbo.OrderStickBills", "Amount", c => c.Decimal(precision: 18, scale: 2)); //AddColumn("dbo.OrderStickBills", "OriginalStickNum", c => c.String(maxLength: 30)); //AddColumn("dbo.OrderStickBills", "ReturnOrderNo", c => c.String(maxLength: 30)); //AddColumn("dbo.OrderStickBills", "OrderNo", c => c.String(maxLength: 500)); //AddColumn("dbo.OrderStickBills", "InvoiceType", c => c.Int(nullable: false)); //AddColumn("dbo.PackageApply", "ProductNo", c => c.String(maxLength: 32)); //AddColumn("dbo.PackageApply", "SourceStore", c => c.Int(nullable: false)); //AddColumn("dbo.PackageApply", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.ProductInspectInfos", "ProductInspectReportNo", c => c.String(nullable: false, maxLength: 32)); //AddColumn("dbo.ProductInspectInfos", "InspectSubject", c => c.String(maxLength: 50)); //AddColumn("dbo.ProductionOrders", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.ProductionOrders", "OutsourcingFactory", c => c.String()); //AddColumn("dbo.ProductionOrders", "EnterDate", c => c.DateTime()); //AddColumn("dbo.ProductionOrders", "InspectDate", c => c.DateTime()); //AddColumn("dbo.ProductionOrders", "HasExported", c => c.Boolean(nullable: false)); //AddColumn("dbo.ProductionOrders", "MaxQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.ProductOutStore", "OutStoreUser", c => c.String(maxLength: 20)); //AddColumn("dbo.ProductOutStore", "OutStoreDate", c => c.DateTime()); //AddColumn("dbo.ProductOutStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.ProductOutStore", "ApplyOutStoreSourceType", c => c.Int(nullable: false)); //AddColumn("dbo.ProductOutStore", "CreateSourceType", c => c.Int()); //AddColumn("dbo.Products", "SpecialDesc", c => c.String(maxLength: 50)); //AddColumn("dbo.Products", "ModelNo", c => c.String(maxLength: 20)); //AddColumn("dbo.Products", "MaterialNo", c => c.String(maxLength: 20)); //AddColumn("dbo.Products", "SurfaceColorNo", c => c.String(maxLength: 20)); //AddColumn("dbo.Products", "RigidityNo", c => c.String(maxLength: 20)); //AddColumn("dbo.Products", "SpecialNo", c => c.String(maxLength: 20)); //AddColumn("dbo.Products", "PrevProductNo", c => c.String(maxLength: 50)); //AddColumn("dbo.ProductInspectReportContents", "ProductionOrderNo", c => c.String(maxLength: 32)); //AddColumn("dbo.SemiEnterStore", "EnterStoreUser", c => c.String(maxLength: 20)); //AddColumn("dbo.SemiEnterStore", "EnterStoreDate", c => c.DateTime()); //AddColumn("dbo.SemiEnterStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.SemiEnterStore", "CreateSourceType", c => c.Int()); //AddColumn("dbo.SemiEnterStore", "StoreLocationNo", c => c.String(maxLength: 32)); //AddColumn("dbo.SemiOutStores", "OutStoreUser", c => c.String(maxLength: 20)); //AddColumn("dbo.SemiOutStores", "OutStoreDate", c => c.DateTime()); //AddColumn("dbo.SemiOutStores", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AddColumn("dbo.SemiOutStores", "CreateSourceType", c => c.Int()); //AddColumn("dbo.SemiProducts", "SpecialDesc", c => c.String(maxLength: 50)); //AddColumn("dbo.SemiProducts", "ModelNo", c => c.String(maxLength: 20)); //AddColumn("dbo.SemiProducts", "MaterialNo", c => c.String(maxLength: 20)); //AddColumn("dbo.SemiProducts", "SurfaceColorNo", c => c.String(maxLength: 20)); //AddColumn("dbo.SemiProducts", "RigidityNo", c => c.String(maxLength: 20)); //AddColumn("dbo.SemiProducts", "SpecialNo", c => c.String(maxLength: 20)); //AddColumn("dbo.SemiProducts", "PrevProductNo", c => c.String(maxLength: 50)); //AddColumn("dbo.TemplateInfos", "TempKey", c => c.String(maxLength: 50)); //AddColumn("dbo.TemplateInfos", "FilePath", c => c.String(maxLength: 300)); //AddColumn("dbo.TemplateInfos", "FileExt", c => c.String(maxLength: 50)); //AddColumn("dbo.TemplateInfos", "ClassPath", c => c.String(maxLength: 100)); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "ProductDesc", c => c.String()); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "PartNo", c => c.String()); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "PreMonthQuantity", c => c.Decimal(precision: 18, scale: 3)); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "InventoryCheckState", c => c.Int()); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "ReturnState", c => c.Int()); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "StoreAreaCode", c => c.String()); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "ShelfNumber", c => c.String()); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "ShelfLevel", c => c.String()); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "SequenceNo", c => c.String()); //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "LocationRemark", c => c.String()); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "PartNo", c => c.String()); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "StoreLocationNo", c => c.String()); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "PreMonthQuantity", c => c.Decimal(precision: 18, scale: 3)); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "InventoryCheckState", c => c.Int()); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "ReturnState", c => c.Int()); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "StoreAreaCode", c => c.String()); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "ShelfNumber", c => c.String()); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "ShelfLevel", c => c.String()); //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "SequenceNo", c => c.String()); //AddColumn("dbo.v_customerstick", "StatementBillNo", c => c.String()); //AddColumn("dbo.N_ViewOrderItems", "AfterTaxTotalPrice", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewOrderItems", "SaleType", c => c.Int()); //AddColumn("dbo.N_ViewOrderItems", "SaleMan", c => c.String()); //AddColumn("dbo.N_ViewOrderItems", "EmergencyLevel", c => c.Int(nullable: false)); //AddColumn("dbo.N_ViewOrderItems", "IsLock", c => c.String()); //AddColumn("dbo.N_ViewOrderItems", "StandardName", c => c.String()); //AddColumn("dbo.N_ViewOrderItems", "StoreCompleteState", c => c.Int(nullable: false)); //AddColumn("dbo.N_ViewOrderItems", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewOrderItems", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewOrderItems", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewOrderItems", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.v_OrderSendBill", "OrderSendCount", c => c.Int(nullable: false)); //AddColumn("dbo.v_OrderSendBill", "StatementCount", c => c.Int(nullable: false)); //AddColumn("dbo.v_OrderSendBill", "ExpressId", c => c.Int()); //AddColumn("dbo.v_OrderSendBill", "ExpressBillNo", c => c.String()); //AddColumn("dbo.v_OrderSendBill", "ExpressName", c => c.String()); //AddColumn("dbo.v_OrderSendBill", "CreatorUserId", c => c.String()); //AddColumn("dbo.v_OrderSendBill", "TotalPrice", c => c.Decimal(precision: 18, scale: 3)); //AddColumn("dbo.v_OrderSendBill", "AfterTaxTotalPrice", c => c.Decimal(precision: 18, scale: 3)); //AddColumn("dbo.v_OrderSendBill", "CurrencyId", c => c.String()); //AddColumn("dbo.N_ViewOrderSends", "CustomerName", c => c.String()); //AddColumn("dbo.N_ViewOrderSends", "SaleType", c => c.Int()); //AddColumn("dbo.N_ViewOrderSends", "AfterTaxPrice", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewOrderSends", "StatementBillNo", c => c.String()); //AddColumn("dbo.N_ViewOrderSends", "SendActionDate", c => c.DateTime()); //AddColumn("dbo.N_ViewOrderSends", "StandardName", c => c.String()); //AddColumn("dbo.N_ViewOrderSends", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewOrderSends", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewOrderSends", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewOrderSends", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewOrderSends", "SendBillSort", c => c.Int(nullable: false)); //AddColumn("dbo.N_ViewOrderSends", "StatementBillSort", c => c.Int(nullable: false)); //AddColumn("dbo.vwOrderSendBill", "StatementBillNo", c => c.String()); //AddColumn("dbo.vwOrderSendBill", "CurrencyId", c => c.String()); //AddColumn("dbo.vwOrderSendBill", "AfterTaxPrice", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.vwOrderSendBill", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.vwOrderSendBill", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.vwOrderSendBill", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.vwOrderSendBill", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.vwOrderSendBill", "AfterTaxTotalprice", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.vwOrderSendBill", "SendBillSort", c => c.Int(nullable: false)); //AddColumn("dbo.vwOrderSendBill", "StatementBillSort", c => c.Int(nullable: false)); //AddColumn("dbo.N_ViewProductEnterStore", "PackageProductNo", c => c.String(maxLength: 32)); //AddColumn("dbo.N_ViewProductEnterStore", "ApplySourceType", c => c.Int(nullable: false)); //AddColumn("dbo.N_ViewProductEnterStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewProductEnterStore", "SourceStoreHouseId", c => c.Int(nullable: false)); //AddColumn("dbo.N_ViewProductEnterStore", "CreateSourceType", c => c.Int()); //AddColumn("dbo.N_ViewProductEnterStore", "PackageEnterNum", c => c.String()); //AddColumn("dbo.N_ViewProductOutStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewProductOutStore", "ApplyOutStoreSourceType", c => c.Int(nullable: false)); //AddColumn("dbo.N_ViewProductOutStore", "CreateSourceType", c => c.Int()); //AddColumn("dbo.N_ViewProductOutStore", "OrderDate", c => c.DateTime()); //AddColumn("dbo.N_ViewSemiEnterStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewSemiEnterStore", "CreateSourceType", c => c.Int()); //AddColumn("dbo.N_ViewSemiEnterStore", "StoreLocationNo", c => c.String()); //AddColumn("dbo.N_ViewSemiOutStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AddColumn("dbo.N_ViewSemiOutStore", "CreateSourceType", c => c.Int()); //AlterColumn("dbo.BackUpCurrentSemiStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.BackUpCurrentSemiStoreHouse", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.CurrentProductStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.CurrentProductStoreHouse", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.CurrentSemiStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.CurrentSemiStoreHouse", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.FinshedEnterStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.FinshedEnterStore", "PackageSpecification", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.FinshedEnterStore", "PackageCount", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.FinshedEnterStore", "ActualPackageCount", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.OrderItems", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3, storeType: "numeric")); //AlterColumn("dbo.OrderSend", "SendQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.OrderSend", "QuantityPerPack", c => c.Decimal(precision: 18, scale: 3)); //AlterColumn("dbo.OrderSend", "PackageCount", c => c.Decimal(precision: 18, scale: 3)); //AlterColumn("dbo.PackageApply", "ApplyQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.PackageApply", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.ProductionOrders", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.ProductionOrders", "EnterQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.ProductOutStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.ProductOutStore", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.Products", "TranUnitValue", c => c.Decimal(precision: 18, scale: 3)); //AlterColumn("dbo.SemiEnterStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.SemiEnterStore", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.SemiOutStores", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.SemiOutStores", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.SemiProducts", "TranUnitValue", c => c.Decimal(precision: 18, scale: 3)); //AlterColumn("dbo.SemiProductStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3)); //AlterColumn("dbo.N_ViewOrderSends", "OrderDate", c => c.DateTime()); //AlterColumn("dbo.N_ViewOrderSends", "CustomerSendId", c => c.Int()); //DropColumn("dbo.FinshedEnterStore", "SemiProductNo"); //DropColumn("dbo.FinshedEnterStore", "ApplySource"); //DropColumn("dbo.v_OrderSendBill", "StickNum"); //DropColumn("dbo.v_OrderSendBill", "StickMan"); //DropColumn("dbo.v_OrderSendBill", "CreatDate"); //DropColumn("dbo.v_OrderSendBill", "isbill"); //DropColumn("dbo.N_ViewProductEnterStore", "SemiProductNo"); //DropColumn("dbo.N_ViewProductEnterStore", "ApplySource"); //DropTable("dbo.ProductionOrderLogs"); } public override void Down() { //CreateTable( // "dbo.ProductionOrderLogs", // c => new // { // Id = c.Int(nullable: false, identity: true), // ProductionOrderNo = c.String(nullable: false, maxLength: 11), // OperatorTitle = c.String(maxLength: 150), // OperatorConent = c.String(), // TimeCreated = c.DateTime(), // CreatorUserId = c.String(maxLength: 20), // }) // .PrimaryKey(t => t.Id); //AddColumn("dbo.N_ViewProductEnterStore", "ApplySource", c => c.Int(nullable: false)); //AddColumn("dbo.N_ViewProductEnterStore", "SemiProductNo", c => c.String(maxLength: 32)); //AddColumn("dbo.v_OrderSendBill", "isbill", c => c.String()); //AddColumn("dbo.v_OrderSendBill", "CreatDate", c => c.DateTime()); //AddColumn("dbo.v_OrderSendBill", "StickMan", c => c.String()); //AddColumn("dbo.v_OrderSendBill", "StickNum", c => c.String()); //AddColumn("dbo.FinshedEnterStore", "ApplySource", c => c.Int(nullable: false)); //AddColumn("dbo.FinshedEnterStore", "SemiProductNo", c => c.String(maxLength: 50)); //DropForeignKey("dbo.ScrapTypeInfo", "LastModifierUserId", "dbo.Sys_Users"); //DropForeignKey("dbo.ScrapTypeInfo", "DeleterUserId", "dbo.Sys_Users"); //DropForeignKey("dbo.ScrapTypeInfo", "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.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.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"); //DropIndex("dbo.N_ViewStatementBill", new[] { "StatementBillNo" }); //DropIndex("dbo.StatementBill", new[] { "StatementBillNo" }); //DropIndex("dbo.ScrapTypeInfo", new[] { "CreatorUserId" }); //DropIndex("dbo.ScrapTypeInfo", new[] { "LastModifierUserId" }); //DropIndex("dbo.ScrapTypeInfo", 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.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.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.CustomerDisProductInfo", new[] { "CreatorUserId" }); //AlterColumn("dbo.N_ViewOrderSends", "CustomerSendId", c => c.Int(nullable: false)); //AlterColumn("dbo.N_ViewOrderSends", "OrderDate", c => c.DateTime(nullable: false)); //AlterColumn("dbo.SemiProductStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.SemiProducts", "TranUnitValue", c => c.Decimal(precision: 18, scale: 2)); //AlterColumn("dbo.SemiOutStores", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.SemiOutStores", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.SemiEnterStore", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.SemiEnterStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.Products", "TranUnitValue", c => c.Decimal(precision: 18, scale: 2)); //AlterColumn("dbo.ProductOutStore", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.ProductOutStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.ProductionOrders", "EnterQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.ProductionOrders", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.PackageApply", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.PackageApply", "ApplyQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.OrderSend", "PackageCount", c => c.Decimal(precision: 18, scale: 2)); //AlterColumn("dbo.OrderSend", "QuantityPerPack", c => c.Decimal(precision: 18, scale: 2)); //AlterColumn("dbo.OrderSend", "SendQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.OrderItems", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2, storeType: "numeric")); //AlterColumn("dbo.FinshedEnterStore", "ActualPackageCount", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.FinshedEnterStore", "PackageCount", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.FinshedEnterStore", "PackageSpecification", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.FinshedEnterStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.CurrentSemiStoreHouse", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.CurrentSemiStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.CurrentProductStoreHouse", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.CurrentProductStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.BackUpCurrentSemiStoreHouse", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //AlterColumn("dbo.BackUpCurrentSemiStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2)); //DropColumn("dbo.N_ViewSemiOutStore", "CreateSourceType"); //DropColumn("dbo.N_ViewSemiOutStore", "KgWeight"); //DropColumn("dbo.N_ViewSemiEnterStore", "StoreLocationNo"); //DropColumn("dbo.N_ViewSemiEnterStore", "CreateSourceType"); //DropColumn("dbo.N_ViewSemiEnterStore", "KgWeight"); //DropColumn("dbo.N_ViewProductOutStore", "OrderDate"); //DropColumn("dbo.N_ViewProductOutStore", "CreateSourceType"); //DropColumn("dbo.N_ViewProductOutStore", "ApplyOutStoreSourceType"); //DropColumn("dbo.N_ViewProductOutStore", "KgWeight"); //DropColumn("dbo.N_ViewProductEnterStore", "PackageEnterNum"); //DropColumn("dbo.N_ViewProductEnterStore", "CreateSourceType"); //DropColumn("dbo.N_ViewProductEnterStore", "SourceStoreHouseId"); //DropColumn("dbo.N_ViewProductEnterStore", "KgWeight"); //DropColumn("dbo.N_ViewProductEnterStore", "ApplySourceType"); //DropColumn("dbo.N_ViewProductEnterStore", "PackageProductNo"); //DropColumn("dbo.vwOrderSendBill", "StatementBillSort"); //DropColumn("dbo.vwOrderSendBill", "SendBillSort"); //DropColumn("dbo.vwOrderSendBill", "AfterTaxTotalprice"); //DropColumn("dbo.vwOrderSendBill", "MoldFeeAfterTax"); //DropColumn("dbo.vwOrderSendBill", "LogisticsFeeAfterTax"); //DropColumn("dbo.vwOrderSendBill", "MoldFee"); //DropColumn("dbo.vwOrderSendBill", "LogisticsFee"); //DropColumn("dbo.vwOrderSendBill", "AfterTaxPrice"); //DropColumn("dbo.vwOrderSendBill", "CurrencyId"); //DropColumn("dbo.vwOrderSendBill", "StatementBillNo"); //DropColumn("dbo.N_ViewOrderSends", "StatementBillSort"); //DropColumn("dbo.N_ViewOrderSends", "SendBillSort"); //DropColumn("dbo.N_ViewOrderSends", "MoldFeeAfterTax"); //DropColumn("dbo.N_ViewOrderSends", "LogisticsFeeAfterTax"); //DropColumn("dbo.N_ViewOrderSends", "MoldFee"); //DropColumn("dbo.N_ViewOrderSends", "LogisticsFee"); //DropColumn("dbo.N_ViewOrderSends", "StandardName"); //DropColumn("dbo.N_ViewOrderSends", "SendActionDate"); //DropColumn("dbo.N_ViewOrderSends", "StatementBillNo"); //DropColumn("dbo.N_ViewOrderSends", "AfterTaxPrice"); //DropColumn("dbo.N_ViewOrderSends", "SaleType"); //DropColumn("dbo.N_ViewOrderSends", "CustomerName"); //DropColumn("dbo.v_OrderSendBill", "CurrencyId"); //DropColumn("dbo.v_OrderSendBill", "AfterTaxTotalPrice"); //DropColumn("dbo.v_OrderSendBill", "TotalPrice"); //DropColumn("dbo.v_OrderSendBill", "CreatorUserId"); //DropColumn("dbo.v_OrderSendBill", "ExpressName"); //DropColumn("dbo.v_OrderSendBill", "ExpressBillNo"); //DropColumn("dbo.v_OrderSendBill", "ExpressId"); //DropColumn("dbo.v_OrderSendBill", "StatementCount"); //DropColumn("dbo.v_OrderSendBill", "OrderSendCount"); //DropColumn("dbo.N_ViewOrderItems", "MoldFeeAfterTax"); //DropColumn("dbo.N_ViewOrderItems", "LogisticsFeeAfterTax"); //DropColumn("dbo.N_ViewOrderItems", "MoldFee"); //DropColumn("dbo.N_ViewOrderItems", "LogisticsFee"); //DropColumn("dbo.N_ViewOrderItems", "StoreCompleteState"); //DropColumn("dbo.N_ViewOrderItems", "StandardName"); //DropColumn("dbo.N_ViewOrderItems", "IsLock"); //DropColumn("dbo.N_ViewOrderItems", "EmergencyLevel"); //DropColumn("dbo.N_ViewOrderItems", "SaleMan"); //DropColumn("dbo.N_ViewOrderItems", "SaleType"); //DropColumn("dbo.N_ViewOrderItems", "AfterTaxTotalPrice"); //DropColumn("dbo.v_customerstick", "StatementBillNo"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "SequenceNo"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "ShelfLevel"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "ShelfNumber"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "StoreAreaCode"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "ReturnState"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "InventoryCheckState"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "PreMonthQuantity"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "StoreLocationNo"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "KgWeight"); //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "PartNo"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "LocationRemark"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "SequenceNo"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "ShelfLevel"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "ShelfNumber"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "StoreAreaCode"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "ReturnState"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "InventoryCheckState"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "PreMonthQuantity"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "KgWeight"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "PartNo"); //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "ProductDesc"); //DropColumn("dbo.TemplateInfos", "ClassPath"); //DropColumn("dbo.TemplateInfos", "FileExt"); //DropColumn("dbo.TemplateInfos", "FilePath"); //DropColumn("dbo.TemplateInfos", "TempKey"); //DropColumn("dbo.SemiProducts", "PrevProductNo"); //DropColumn("dbo.SemiProducts", "SpecialNo"); //DropColumn("dbo.SemiProducts", "RigidityNo"); //DropColumn("dbo.SemiProducts", "SurfaceColorNo"); //DropColumn("dbo.SemiProducts", "MaterialNo"); //DropColumn("dbo.SemiProducts", "ModelNo"); //DropColumn("dbo.SemiProducts", "SpecialDesc"); //DropColumn("dbo.SemiOutStores", "CreateSourceType"); //DropColumn("dbo.SemiOutStores", "KgWeight"); //DropColumn("dbo.SemiOutStores", "OutStoreDate"); //DropColumn("dbo.SemiOutStores", "OutStoreUser"); //DropColumn("dbo.SemiEnterStore", "StoreLocationNo"); //DropColumn("dbo.SemiEnterStore", "CreateSourceType"); //DropColumn("dbo.SemiEnterStore", "KgWeight"); //DropColumn("dbo.SemiEnterStore", "EnterStoreDate"); //DropColumn("dbo.SemiEnterStore", "EnterStoreUser"); //DropColumn("dbo.ProductInspectReportContents", "ProductionOrderNo"); //DropColumn("dbo.Products", "PrevProductNo"); //DropColumn("dbo.Products", "SpecialNo"); //DropColumn("dbo.Products", "RigidityNo"); //DropColumn("dbo.Products", "SurfaceColorNo"); //DropColumn("dbo.Products", "MaterialNo"); //DropColumn("dbo.Products", "ModelNo"); //DropColumn("dbo.Products", "SpecialDesc"); //DropColumn("dbo.ProductOutStore", "CreateSourceType"); //DropColumn("dbo.ProductOutStore", "ApplyOutStoreSourceType"); //DropColumn("dbo.ProductOutStore", "KgWeight"); //DropColumn("dbo.ProductOutStore", "OutStoreDate"); //DropColumn("dbo.ProductOutStore", "OutStoreUser"); //DropColumn("dbo.ProductionOrders", "MaxQuantity"); //DropColumn("dbo.ProductionOrders", "HasExported"); //DropColumn("dbo.ProductionOrders", "InspectDate"); //DropColumn("dbo.ProductionOrders", "EnterDate"); //DropColumn("dbo.ProductionOrders", "OutsourcingFactory"); //DropColumn("dbo.ProductionOrders", "KgWeight"); //DropColumn("dbo.ProductInspectInfos", "InspectSubject"); //DropColumn("dbo.ProductInspectInfos", "ProductInspectReportNo"); //DropColumn("dbo.PackageApply", "KgWeight"); //DropColumn("dbo.PackageApply", "SourceStore"); //DropColumn("dbo.PackageApply", "ProductNo"); //DropColumn("dbo.OrderStickBills", "InvoiceType"); //DropColumn("dbo.OrderStickBills", "OrderNo"); //DropColumn("dbo.OrderStickBills", "ReturnOrderNo"); //DropColumn("dbo.OrderStickBills", "OriginalStickNum"); //DropColumn("dbo.OrderStickBills", "Amount"); //DropColumn("dbo.OrderStickBills", "InvoiceState"); //DropColumn("dbo.OrderSend", "StatementBillSort"); //DropColumn("dbo.OrderSend", "SendBillSort"); //DropColumn("dbo.OrderSend", "MoldFeeAfterTax"); //DropColumn("dbo.OrderSend", "LogisticsFeeAfterTax"); //DropColumn("dbo.OrderSend", "MoldFee"); //DropColumn("dbo.OrderSend", "LogisticsFee"); //DropColumn("dbo.OrderSend", "StatementBillNo"); //DropColumn("dbo.OrderSend", "CreatorUserId"); //DropColumn("dbo.OrderSendBills", "ExpressBillNo"); //DropColumn("dbo.OrderSendBills", "ExpressId"); //DropColumn("dbo.OrderItems", "MoldFeeAfterTax"); //DropColumn("dbo.OrderItems", "LogisticsFeeAfterTax"); //DropColumn("dbo.OrderItems", "MoldFee"); //DropColumn("dbo.OrderItems", "LogisticsFee"); //DropColumn("dbo.OrderItems", "StoreCompleteState"); //DropColumn("dbo.OrderItems", "StandardName"); //DropColumn("dbo.OrderItems", "IsLock"); //DropColumn("dbo.OrderItems", "EmergencyLevel"); //DropColumn("dbo.OrderItems", "ToCnyRate"); //DropColumn("dbo.OrderHeader", "IsLock"); //DropColumn("dbo.OrderHeader", "SaleMan"); //DropColumn("dbo.OrderHeader", "SaleType"); //DropColumn("dbo.Sys_Users", "AccountNo"); //DropColumn("dbo.FinshedEnterStore", "ApplyQuantity2"); //DropColumn("dbo.FinshedEnterStore", "VerifyUser"); //DropColumn("dbo.FinshedEnterStore", "PackageUser"); //DropColumn("dbo.FinshedEnterStore", "PackageEnterNum"); //DropColumn("dbo.FinshedEnterStore", "CreateSourceType"); //DropColumn("dbo.FinshedEnterStore", "KgWeight"); //DropColumn("dbo.FinshedEnterStore", "EnterStoreDate"); //DropColumn("dbo.FinshedEnterStore", "EnterStoreUser"); //DropColumn("dbo.FinshedEnterStore", "ApplyQuantity"); //DropColumn("dbo.FinshedEnterStore", "ApplySourceType"); //DropColumn("dbo.FinshedEnterStore", "SourceStoreHouseId"); //DropColumn("dbo.FinshedEnterStore", "PackageProductNo"); //DropColumn("dbo.Customers", "SaleType"); //DropColumn("dbo.CustomerDefaultProduct", "PartNo"); //DropColumn("dbo.CurrentSemiStoreHouse", "ReturnState"); //DropColumn("dbo.CurrentSemiStoreHouse", "InventoryCheckState"); //DropColumn("dbo.CurrentSemiStoreHouse", "PreMonthQuantity"); //DropColumn("dbo.CurrentSemiStoreHouse", "KgWeight"); //DropColumn("dbo.CurrentSemiStoreHouse", "StoreLocationNo"); //DropColumn("dbo.CurrentProductStoreHouse", "ReturnState"); //DropColumn("dbo.CurrentProductStoreHouse", "InventoryCheckState"); //DropColumn("dbo.CurrentProductStoreHouse", "PreMonthQuantity"); //DropColumn("dbo.CurrentProductStoreHouse", "KgWeight"); //DropColumn("dbo.BackUpCurrentSemiStoreHouse", "KgWeight"); //DropTable("dbo.v_OrderStickBill"); //DropTable("dbo.N_ViewStatementBill"); //DropTable("dbo.N_ViewScrapEnterStore", // removedAnnotations: new Dictionary // { // { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.N_ViewRmOutStore", // removedAnnotations: new Dictionary // { // { "DynamicFilter_ViewRmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.N_ViewRmEnterStore", // removedAnnotations: new Dictionary // { // { "DynamicFilter_ViewRmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.N_ViewPackageApply"); //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_ProductStoreInfo"); //DropTable("dbo.v_SemiProductStoreInfo"); //DropTable("dbo.N_ViewCurrentRmStoreHouse", // removedAnnotations: new Dictionary // { // { "DynamicFilter_ViewCurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.StatementBill"); //DropTable("dbo.StandardDetail", // removedAnnotations: new Dictionary // { // { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.StandardCatalog", // removedAnnotations: new Dictionary // { // { "DynamicFilter_StandardCatalog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.ScrapTypeInfo", // removedAnnotations: new Dictionary // { // { "DynamicFilter_ScrapType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.ScrapEnterStore", // removedAnnotations: new Dictionary // { // { "DynamicFilter_ScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.N_ViewScheduleOrderSend"); //DropTable("dbo.ScheduleOrderSend"); //DropTable("dbo.RmProduct", // removedAnnotations: new Dictionary // { // { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.RmOutStore", // removedAnnotations: new Dictionary // { // { "DynamicFilter_RmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.RmEnterStore", // removedAnnotations: new Dictionary // { // { "DynamicFilter_RmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.ReturnGoodOrder", // removedAnnotations: new Dictionary // { // { "DynamicFilter_ReturnGoodOrder_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.QualityIssueLabelInfo", // removedAnnotations: new Dictionary // { // { "DynamicFilter_QualityIssueLabel_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.ProductProperties", // removedAnnotations: new Dictionary // { // { "DynamicFilter_ProductProperty_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.ProductMapper", // removedAnnotations: new Dictionary // { // { "DynamicFilter_ProductMapper_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.ProductionOrderLogInfo"); //DropTable("dbo.ProductInspectReportInfos"); //DropTable("dbo.OutFactory"); //DropTable("dbo.OrderSendExceed"); //DropTable("dbo.OrderProduction"); //DropTable("dbo.MoldInfo", // removedAnnotations: new Dictionary // { // { "DynamicFilter_Mold_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.MaintenanceRecordInfo"); //DropTable("dbo.MaintenanceMemberInfo"); //DropTable("dbo.LicenseTypeInfo"); //DropTable("dbo.LicenseDocumentInfo", // removedAnnotations: new Dictionary // { // { "DynamicFilter_LicenseDocument_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.InventoryCheckRecord"); //DropTable("dbo.InventoryCheck", // removedAnnotations: new Dictionary // { // { "DynamicFilter_InventoryCheckInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.FixedAssetTypeInfo", // removedAnnotations: new Dictionary // { // { "DynamicFilter_FixedAssetType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.FixedAssetInfo", // removedAnnotations: new Dictionary // { // { "DynamicFilter_FixedAsset_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.ExpressServiceProviders"); //DropTable("dbo.ExpressProviderMappers"); //DropTable("dbo.ExpressLogistics"); //DropTable("dbo.EmployeeWorkPerformanceInfo"); //DropTable("dbo.EmployeeInfo", // removedAnnotations: new Dictionary // { // { "DynamicFilter_Employee_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.DisqualifiedProductInfo"); //DropTable("dbo.DeviceMgPlanInfo", // removedAnnotations: new Dictionary // { // { "DynamicFilter_DeviceMgPlan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.CustomerInvoiceAddress", // removedAnnotations: new Dictionary // { // { "DynamicFilter_CustomerInvoiceAddress_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.CustomerDisProductInfo"); //DropTable("dbo.CurrentRmStoreHouse", // removedAnnotations: new Dictionary // { // { "DynamicFilter_CurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" }, // }); //DropTable("dbo.CurrencyExchangeRate"); //DropTable("dbo.Currency"); //RenameColumn(table: "dbo.PackageApply", name: "CurrentStoreHouseNo", newName: "CurrentSemiStoreHouseNo"); //RenameTable(name: "dbo.ProductInspectReportContents", newName: "ProductInspectReports"); } } }