| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167 |
- 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<string, object>
- // {
- // { "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<string, object>
- // {
- // { "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<string, object>
- // {
- // { "DynamicFilter_DeviceMgPlan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.DisqualifiedProductInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // DisqualifiedNo = c.String(maxLength: 20),
- // ProductOrderNo = c.String(maxLength: 11),
- // ReturnOrderNo = c.String(maxLength: 32),
- // ProductNo = c.String(maxLength: 50),
- // ProductName = c.String(maxLength: 100),
- // ProductType = c.Int(nullable: false),
- // QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
- // HandleType = c.Int(nullable: false),
- // CheckUser = c.String(maxLength: 20),
- // CheckDate = c.DateTime(),
- // HandleUser = c.String(maxLength: 20),
- // HandleDate = c.DateTime(),
- // DisqualifiedType = c.Int(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.EmployeeInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(maxLength: 20),
- // Name = c.String(maxLength: 50),
- // CardId = c.String(maxLength: 18),
- // Gender = c.Int(nullable: false),
- // PhoneNumber = c.String(maxLength: 18),
- // DepartmentNo = c.String(maxLength: 20),
- // DutyNo = c.String(maxLength: 20),
- // Description = c.String(maxLength: 500),
- // UserName = c.String(maxLength: 32),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_Employee_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.EmployeeWorkPerformanceInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // PerformanceNo = c.String(maxLength: 20),
- // EmployeeId = c.Int(nullable: false),
- // RelatedNo = c.String(maxLength: 20),
- // ProductOrderNo = c.String(maxLength: 11),
- // WorkType = c.Int(nullable: false),
- // Performance = c.Decimal(precision: 18, scale: 3),
- // PerformanceUnit = c.String(maxLength: 10),
- // PerformanceDesc = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
- // .Index(t => t.EmployeeId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.ExpressLogistics",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ExpressName = c.String(maxLength: 50),
- // Code = c.String(maxLength: 50),
- // Sort = c.Int(nullable: false),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 50),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.ExpressProviderMappers",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ExpressId = c.Int(nullable: false),
- // ProviderId = c.Int(nullable: false),
- // MapperCode = c.String(maxLength: 50),
- // QueryUrl = c.String(maxLength: 500),
- // ExtendInfo = c.String(maxLength: 500),
- // ActiveStatus = c.Int(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.ExpressLogistics", t => t.ExpressId, cascadeDelete: true)
- // .ForeignKey("dbo.ExpressServiceProviders", t => t.ProviderId, cascadeDelete: true)
- // .Index(t => t.ExpressId)
- // .Index(t => t.ProviderId);
-
- //CreateTable(
- // "dbo.ExpressServiceProviders",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProviderName = c.String(maxLength: 50),
- // QueryApiUrl = c.String(maxLength: 150),
- // CallBackUrl = c.String(maxLength: 150),
- // ExcuteNamespaceAndMethod = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 50),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.FixedAssetInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(maxLength: 50),
- // Name = c.String(maxLength: 50),
- // Model = c.String(maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_FixedAsset_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.FixedAssetTypeInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // Name = c.String(nullable: false, maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_FixedAssetType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.InventoryCheck",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // CheckNo = c.String(maxLength: 32),
- // StoreHouseId = c.Int(nullable: false),
- // StoreAreaCode = c.String(maxLength: 32),
- // ShelfNumber = c.String(maxLength: 32),
- // ShelfLevel = c.String(maxLength: 32),
- // SequenceNo = c.String(maxLength: 32),
- // CheckType = c.String(maxLength: 10),
- // PlanStartDate = c.DateTime(),
- // PlanEndDate = c.DateTime(),
- // Remark = c.String(maxLength: 200),
- // CheckUser = c.String(maxLength: 32),
- // PublishUser = c.String(maxLength: 32),
- // FinishDate = c.DateTime(),
- // CheckState = c.Int(nullable: false),
- // ProductNo = c.String(maxLength: 32),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_InventoryCheckInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.InventoryCheckRecord",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // CheckNo = c.String(maxLength: 32),
- // CurrentStoreHouseNo = c.String(maxLength: 32),
- // CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.LicenseDocumentInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(maxLength: 50),
- // Name = c.String(maxLength: 50),
- // Description = c.String(maxLength: 500),
- // LicenseGroup = c.String(maxLength: 50),
- // LicenseType = c.String(maxLength: 50),
- // FilePath = c.String(maxLength: 300),
- // ExpireDate = c.DateTime(nullable: false),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_LicenseDocument_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.LicenseTypeInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // Name = c.String(maxLength: 50),
- // GroupName = c.String(maxLength: 50),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.MaintenanceMemberInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // MaintenanceNo = c.String(),
- // EmployeeId = c.Int(nullable: false),
- // Name = c.String(),
- // StartDateTime = c.DateTime(),
- // EndDateTime = c.DateTime(),
- // WorkHour = c.Decimal(nullable: false, precision: 18, scale: 2),
- // IsConfirm = c.Boolean(nullable: false),
- // WorkDesc = c.String(),
- // Remark = c.String(maxLength: 500),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
- // .Index(t => t.EmployeeId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.MaintenanceRecordInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // DeviceMgPlanNo = c.String(maxLength: 50),
- // DeviceNo = c.String(maxLength: 50),
- // DeviceName = c.String(maxLength: 50),
- // MgType = c.Int(nullable: false),
- // Description = c.String(maxLength: 500),
- // Address = c.String(maxLength: 200),
- // PlanDate = c.DateTime(nullable: false),
- // CompleteState = c.Int(nullable: false),
- // CompleteDate = c.DateTime(),
- // Remark = c.String(maxLength: 500),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.MoldInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(maxLength: 50),
- // Name = c.String(maxLength: 50),
- // Model = c.String(maxLength: 50),
- // Material = c.String(maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // CustomerName = c.String(maxLength: 50),
- // ShelfNum = c.String(maxLength: 50),
- // OuterDiameter = c.String(maxLength: 50),
- // InsideDiameter = c.String(maxLength: 50),
- // Thickness = c.String(maxLength: 50),
- // Height = c.String(maxLength: 50),
- // Rigidity = c.String(maxLength: 50),
- // MaintenanceCycle = c.Int(nullable: false),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_Mold_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.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<string, object>
- // {
- // { "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<string, object>
- // {
- // { "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<string, object>
- // {
- // { "DynamicFilter_QualityIssueLabel_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.ReturnGoodOrder",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ReturnOrderNo = c.String(maxLength: 32),
- // SendOrderNo = c.String(maxLength: 32),
- // OrderNo = c.String(maxLength: 32),
- // OrderItemNo = c.String(maxLength: 32),
- // ProductNo = c.String(maxLength: 32),
- // ProductionOrderNo = c.String(maxLength: 32),
- // CustomerId = c.String(maxLength: 32),
- // Reason = c.String(maxLength: 500),
- // Amount = c.Decimal(precision: 18, scale: 2),
- // AuditAmount = c.Decimal(precision: 18, scale: 2),
- // Quantity = c.Decimal(precision: 18, scale: 3),
- // HandleUser = c.String(maxLength: 32),
- // ApplyUser = c.String(maxLength: 32),
- // ConfirmUser = c.String(maxLength: 32),
- // ReturnDate = c.DateTime(),
- // ApplyDate = c.DateTime(),
- // ConfirmDate = c.DateTime(),
- // ReturnState = c.Int(nullable: false),
- // ReturnType = c.Int(nullable: false),
- // LinkName = c.String(maxLength: 50),
- // SurveyReason = c.String(maxLength: 500),
- // SurveyDetail = c.String(maxLength: 500),
- // Solution = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ReturnGoodOrder_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .Index(t => t.ReturnOrderNo, unique: true);
-
- //CreateTable(
- // "dbo.RmEnterStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // RmProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 32),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // EnterStoreUser = c.String(maxLength: 32),
- // EnterStoreDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductBatchNum = c.String(maxLength: 32),
- // CreateSourceType = c.Int(nullable: false),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.RmOutStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // CurrentRmStoreHouseNo = c.String(maxLength: 32),
- // RmProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // IsConfirm = c.Boolean(),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 150),
- // AuditDate = c.DateTime(),
- // OutStoreUser = c.String(maxLength: 150),
- // OutStoreDate = c.DateTime(),
- // ApplyOutDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductBatchNum = c.String(maxLength: 32),
- // CreateSourceType = c.Int(nullable: false),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.RmProduct",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductName = c.String(maxLength: 50),
- // Material = c.String(maxLength: 50),
- // Model = c.String(maxLength: 50),
- // ProductDesc = c.String(maxLength: 200),
- // ModelNo = c.String(maxLength: 20),
- // MaterialNo = c.String(maxLength: 20),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.ScheduleOrderSend",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // OrderItemId = c.Int(nullable: false),
- // Remark = c.String(maxLength: 500),
- // PlanQuantity = c.Decimal(precision: 18, scale: 2),
- // SendUser = c.String(maxLength: 32),
- // PlanDate = c.DateTime(),
- // SendState = c.Int(nullable: false),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.N_ViewScheduleOrderSend",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // OrderItemId = c.Int(nullable: false),
- // PlanQuantity = c.Decimal(precision: 18, scale: 2),
- // SendUser = c.String(),
- // Remark = c.String(),
- // PlanDate = c.DateTime(),
- // SendState = c.Int(nullable: false),
- // OrderNo = c.String(),
- // ProductNo = c.String(),
- // ProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // CustomerName = c.String(),
- // CustomerId = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.ScrapEnterStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // ProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 32),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // EnterStoreUser = c.String(maxLength: 32),
- // EnterStoreDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductType = c.Int(nullable: false),
- // ScrapSource = c.Int(nullable: false),
- // ScrapSourceNo = c.String(maxLength: 50),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.ScrapTypeInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // Name = c.String(nullable: false, maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ScrapType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
-
- //CreateTable(
- // "dbo.StandardCatalog",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StandardNo = c.String(maxLength: 50),
- // StandardAbbr = c.String(nullable: false, maxLength: 50),
- // StandardAbbrName = c.String(nullable: false, maxLength: 50),
- // StandardName = c.String(nullable: false, maxLength: 150),
- // Rigidity = c.String(maxLength: 250),
- // Param = c.String(maxLength: 250),
- // Drawing = c.String(),
- // Remark = c.String(maxLength: 250),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StandardCatalog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.StandardDetail",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StandardId = c.Int(nullable: false),
- // Specs = c.String(nullable: false, maxLength: 50),
- // StandardName = c.String(nullable: false, maxLength: 150),
- // InnerDiameter1 = c.Decimal(precision: 18, scale: 2),
- // InnerDiameter2 = c.Decimal(precision: 18, scale: 2),
- // OutDiameter1 = c.Decimal(precision: 18, scale: 2),
- // OutDiameter2 = c.Decimal(precision: 18, scale: 2),
- // Thickness1 = c.Decimal(precision: 18, scale: 2),
- // Thickness2 = c.Decimal(precision: 18, scale: 2),
- // Height1 = c.Decimal(precision: 18, scale: 2),
- // Height2 = c.Decimal(precision: 18, scale: 2),
- // InnerChamfer1 = c.Decimal(precision: 18, scale: 2),
- // InnerChamfer2 = c.Decimal(precision: 18, scale: 2),
- // OutChamfer1 = c.Decimal(precision: 18, scale: 2),
- // OutChamfer2 = c.Decimal(precision: 18, scale: 2),
- // ThousandWeigh = c.Decimal(precision: 18, scale: 2),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.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<string, object>
- // {
- // { "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<string, object>
- // {
- // { "DynamicFilter_ViewRmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.N_ViewRmOutStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // CurrentRmStoreHouseNo = c.String(maxLength: 32),
- // RmProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // IsConfirm = c.Boolean(),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 150),
- // AuditDate = c.DateTime(),
- // OutStoreUser = c.String(maxLength: 150),
- // OutStoreDate = c.DateTime(),
- // ApplyOutDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductName = c.String(),
- // Material = c.String(),
- // Model = c.String(),
- // ProductDesc = c.String(),
- // StoreHouseName = c.String(),
- // ProductBatchNum = c.String(),
- // CreateSourceType = c.Int(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewRmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.N_ViewScrapEnterStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // ProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 32),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // EnterStoreUser = c.String(maxLength: 32),
- // EnterStoreDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductName = c.String(),
- // Material = c.String(),
- // Model = c.String(),
- // ProductDesc = c.String(),
- // StoreHouseName = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // ProductType = c.Int(),
- // ScrapSource = c.Int(nullable: false),
- // ScrapSourceNo = c.String(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
-
- //CreateTable(
- // "dbo.N_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<string, object>
- // {
- // { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.N_ViewRmOutStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewRmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.N_ViewRmEnterStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewRmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.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<string, object>
- // {
- // { "DynamicFilter_ViewCurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.StatementBill");
- //DropTable("dbo.StandardDetail",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.StandardCatalog",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StandardCatalog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ScrapTypeInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ScrapType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ScrapEnterStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.N_ViewScheduleOrderSend");
- //DropTable("dbo.ScheduleOrderSend");
- //DropTable("dbo.RmProduct",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.RmOutStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.RmEnterStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ReturnGoodOrder",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ReturnGoodOrder_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.QualityIssueLabelInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_QualityIssueLabel_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ProductProperties",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ProductProperty_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ProductMapper",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "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<string, object>
- // {
- // { "DynamicFilter_Mold_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.MaintenanceRecordInfo");
- //DropTable("dbo.MaintenanceMemberInfo");
- //DropTable("dbo.LicenseTypeInfo");
- //DropTable("dbo.LicenseDocumentInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_LicenseDocument_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.InventoryCheckRecord");
- //DropTable("dbo.InventoryCheck",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_InventoryCheckInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.FixedAssetTypeInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_FixedAssetType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.FixedAssetInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_FixedAsset_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ExpressServiceProviders");
- //DropTable("dbo.ExpressProviderMappers");
- //DropTable("dbo.ExpressLogistics");
- //DropTable("dbo.EmployeeWorkPerformanceInfo");
- //DropTable("dbo.EmployeeInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_Employee_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.DisqualifiedProductInfo");
- //DropTable("dbo.DeviceMgPlanInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_DeviceMgPlan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.CustomerInvoiceAddress",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_CustomerInvoiceAddress_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.CustomerDisProductInfo");
- //DropTable("dbo.CurrentRmStoreHouse",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "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");
- }
- }
- }
|