| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419 |
- namespace ShwasherSys.Migrations
- {
- using System;
- using System.Collections.Generic;
- using System.Data.Entity.Infrastructure.Annotations;
- using System.Data.Entity.Migrations;
-
- public partial class _20241111init : DbMigration
- {
- public override void Up()
- {
- //CreateTable(
- // "dbo.Sys_AppGuids",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // Step = c.Short(nullable: false),
- // LastId = c.Int(nullable: false),
- // IdType = c.Short(nullable: false),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Sys_AuditLogs",
- // c => new
- // {
- // Id = c.Long(nullable: false, identity: true),
- // UserId = c.Long(),
- // UserName = c.String(),
- // ServiceName = c.String(maxLength: 256),
- // MethodName = c.String(maxLength: 256),
- // Parameters = c.String(maxLength: 1024),
- // ExecutionTime = c.DateTime(nullable: false),
- // ExecutionDuration = c.Int(nullable: false),
- // ClientIpAddress = c.String(maxLength: 64),
- // ClientName = c.String(maxLength: 128),
- // BrowserInfo = c.String(maxLength: 512),
- // Exception = c.String(maxLength: 2000),
- // ImpersonatorUserId = c.Long(),
- // ImpersonatorTenantId = c.Int(),
- // CustomData = c.String(maxLength: 2000),
- // LogType = c.Int(nullable: false),
- // Discriminator = c.String(nullable: false, maxLength: 128),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.BackUpCurrentSemiStoreHouse",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // CurrentSemiStoreHouseNo = c.String(nullable: false, maxLength: 32),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // StoreHouseId = c.Int(nullable: false),
- // SemiProductNo = c.String(maxLength: 32),
- // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyEnterDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.BulletinInfo",
- // c => new
- // {
- // BulletinInfoId = c.Int(nullable: false, identity: true),
- // BulletinType = c.String(nullable: false, maxLength: 1),
- // Title = c.String(nullable: false, maxLength: 100),
- // Content = c.String(nullable: false, storeType: "ntext"),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // Promulgator = c.String(maxLength: 50),
- // PromulgatTime = c.DateTime(storeType: "smalldatetime"),
- // ExpirationDate = c.DateTime(storeType: "smalldatetime"),
- // })
- // .PrimaryKey(t => t.BulletinInfoId);
- //CreateTable(
- // "dbo.BusinessLogs",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // LogType = c.Int(nullable: false),
- // LogCommand = c.String(),
- // LogMessage = c.String(),
- // LogErrorMessage = c.String(),
- // LogDate = c.DateTime(),
- // UserHostAddress = c.String(),
- // Extend1Log = c.String(),
- // Extend2Log = c.String(),
- // Extend3Log = c.String(),
- // Extend4Log = c.String(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_BusinessLog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Currency",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // CurrencyName = c.String(maxLength: 20),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // UserIDLastMod = c.String(maxLength: 20),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.CurrencyExchangeRate",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // FromCurrencyId = c.String(maxLength: 20),
- // ToCurrencyId = c.String(maxLength: 20),
- // ExchangeRate = c.Decimal(precision: 18, scale: 4),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // UserIDLastMod = c.String(maxLength: 20),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.CurrentProductStoreHouse",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // CurrentProductStoreHouseNo = c.String(nullable: false, maxLength: 32),
- // ProductionOrderNo = c.String(maxLength: 11),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // ProductNo = c.String(maxLength: 32),
- // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
- // InventoryCheckState = c.Int(),
- // ReturnState = c.Int(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.CurrentRmStoreHouse",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // RmProductNo = c.String(maxLength: 32),
- // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // Remark = c.String(maxLength: 150),
- // ProductBatchNum = c.String(maxLength: 32),
- // PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_CurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.CurrentSemiStoreHouse",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StoreLocationNo = c.String(maxLength: 32),
- // CurrentSemiStoreHouseNo = c.String(nullable: false, maxLength: 32),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // StoreHouseId = c.Int(nullable: false),
- // SemiProductNo = c.String(maxLength: 32),
- // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyEnterDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
- // InventoryCheckState = c.Int(),
- // ReturnState = c.Int(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.CustomerDefaultProduct",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // CustomerId = c.String(maxLength: 30),
- // ProductNo = c.String(maxLength: 30),
- // CustomerProductName = c.String(maxLength: 30),
- // Sequence = c.Int(nullable: false),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // PartNo = c.String(maxLength: 30),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.CustomerDisProductInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductOrderNo = c.String(),
- // CustomerNo = c.String(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.Sys_Users",
- // c => new
- // {
- // Id = c.Long(nullable: false, identity: true),
- // FactoryID = c.String(maxLength: 20),
- // DepartmentID = c.String(maxLength: 20),
- // DutyID = c.Int(),
- // AccountNo = c.String(maxLength: 20),
- // Birthday = c.DateTime(),
- // Address = c.String(maxLength: 200),
- // ZIP = c.String(maxLength: 50),
- // Remark = c.String(maxLength: 500),
- // UserName = c.String(nullable: false, maxLength: 32),
- // UserType = c.Int(nullable: false),
- // AuthenticationSource = c.String(maxLength: 64),
- // EmailAddress = c.String(nullable: false, maxLength: 256),
- // RealName = c.String(nullable: false, maxLength: 32),
- // Password = c.String(nullable: false, maxLength: 128),
- // EmailConfirmationCode = c.String(maxLength: 328),
- // PasswordResetCode = c.String(maxLength: 328),
- // LockoutEndDateUtc = c.DateTime(),
- // AccessFailedCount = c.Int(nullable: false),
- // IsLockoutEnabled = c.Boolean(nullable: false),
- // PhoneNumber = c.String(maxLength: 32),
- // IsPhoneNumberConfirmed = c.Boolean(nullable: false),
- // SecurityStamp = c.String(maxLength: 128),
- // IsTwoFactorEnabled = c.Boolean(nullable: false),
- // IsEmailConfirmed = c.Boolean(nullable: false),
- // IsActive = c.Boolean(nullable: false),
- // LastLoginTime = c.DateTime(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysUser_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.Sys_UserRoles",
- // c => new
- // {
- // Id = c.Long(nullable: false, identity: true),
- // UserId = c.Long(nullable: false),
- // RoleId = c.Int(nullable: false),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.UserId, cascadeDelete: true)
- // .Index(t => t.UserId);
- //CreateTable(
- // "dbo.CustomerInvoiceAddress",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // CustomerId = c.String(nullable: false, maxLength: 30),
- // InvoiceAddressName = c.String(nullable: false, maxLength: 150),
- // InvoiceAddress = c.String(nullable: false, maxLength: 250),
- // LinkMan = c.String(maxLength: 30),
- // Telephone = c.String(maxLength: 50),
- // Zip = c.String(maxLength: 8),
- // Email = c.String(maxLength: 50),
- // Mobile = c.String(maxLength: 50),
- // Fax = c.String(maxLength: 50),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_CustomerInvoiceAddress_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Customers",
- // c => new
- // {
- // CustomerId = c.String(nullable: false, maxLength: 128),
- // CustomerName = c.String(nullable: false, maxLength: 50),
- // LinkMan = c.String(maxLength: 20),
- // Address = c.String(maxLength: 150),
- // WebSite = c.String(maxLength: 50),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // Telephone = c.String(maxLength: 50),
- // Fax = c.String(maxLength: 50),
- // zip = c.String(maxLength: 6),
- // Email = c.String(maxLength: 200),
- // SaleType = c.Int(),
- // })
- // .PrimaryKey(t => t.CustomerId);
- //CreateTable(
- // "dbo.CustomerSend",
- // c => new
- // {
- // CustomerSendId = c.Int(nullable: false, identity: true),
- // CustomerId = c.String(nullable: false, maxLength: 30),
- // CustomerSendName = c.String(nullable: false, maxLength: 150),
- // SendAdress = c.String(nullable: false, maxLength: 250),
- // LinkMan = c.String(maxLength: 30),
- // Telephone = c.String(maxLength: 50),
- // Zip = c.String(maxLength: 8),
- // Email = c.String(maxLength: 50),
- // Mobile = c.String(maxLength: 50),
- // Fax = c.String(maxLength: 50),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // })
- // .PrimaryKey(t => t.CustomerSendId);
- //CreateTable(
- // "dbo.Departments",
- // c => new
- // {
- // DepartmentID = c.String(nullable: false, maxLength: 128),
- // DepartmentName = c.String(nullable: false, maxLength: 50),
- // Remark = c.String(maxLength: 200),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // OrderStatusList = c.String(maxLength: 300),
- // })
- // .PrimaryKey(t => t.DepartmentID);
- //CreateTable(
- // "dbo.DeviceMgPlanInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(maxLength: 50),
- // PlanType = c.Int(nullable: false),
- // DeviceNo = c.String(maxLength: 50),
- // Name = c.String(maxLength: 50),
- // Description = c.String(),
- // ExpireDate = c.DateTime(nullable: false),
- // MaintenanceCycle = c.Int(nullable: false),
- // MaintenanceDate = c.DateTime(nullable: false),
- // NextMaintenanceDate = c.DateTime(),
- // Remark = c.String(maxLength: 500),
- // NumberOfUsers = c.Int(nullable: false),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_DeviceMgPlan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.DisqualifiedProductInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // DisqualifiedNo = c.String(maxLength: 20),
- // ProductOrderNo = c.String(maxLength: 11),
- // ReturnOrderNo = c.String(maxLength: 32),
- // ProductNo = c.String(maxLength: 50),
- // ProductName = c.String(maxLength: 100),
- // ProductType = c.Int(nullable: false),
- // QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
- // HandleType = c.Int(nullable: false),
- // CheckUser = c.String(maxLength: 20),
- // CheckDate = c.DateTime(),
- // HandleUser = c.String(maxLength: 20),
- // HandleDate = c.DateTime(),
- // DisqualifiedType = c.Int(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.Dutys",
- // c => new
- // {
- // DutyID = c.Int(nullable: false, identity: true),
- // DutyName = c.String(nullable: false, maxLength: 50),
- // Remark = c.String(maxLength: 200),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // })
- // .PrimaryKey(t => t.DutyID);
- //CreateTable(
- // "dbo.EmployeeInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(maxLength: 20),
- // Name = c.String(maxLength: 50),
- // CardId = c.String(maxLength: 18),
- // Gender = c.Int(nullable: false),
- // PhoneNumber = c.String(maxLength: 18),
- // DepartmentNo = c.String(maxLength: 20),
- // DutyNo = c.String(maxLength: 20),
- // Description = c.String(maxLength: 500),
- // UserName = c.String(maxLength: 32),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_Employee_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.EmployeeWorkPerformanceInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // PerformanceNo = c.String(maxLength: 20),
- // EmployeeId = c.Int(nullable: false),
- // RelatedNo = c.String(maxLength: 20),
- // ProductOrderNo = c.String(maxLength: 11),
- // WorkType = c.Int(nullable: false),
- // Performance = c.Decimal(precision: 18, scale: 3),
- // PerformanceUnit = c.String(maxLength: 10),
- // PerformanceDesc = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
- // .Index(t => t.EmployeeId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.ExpressLogistics",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ExpressName = c.String(maxLength: 50),
- // Code = c.String(maxLength: 50),
- // Sort = c.Int(nullable: false),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 50),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.ExpressProviderMappers",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ExpressId = c.Int(nullable: false),
- // ProviderId = c.Int(nullable: false),
- // MapperCode = c.String(maxLength: 50),
- // QueryUrl = c.String(maxLength: 500),
- // ExtendInfo = c.String(maxLength: 500),
- // ActiveStatus = c.Int(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.ExpressLogistics", t => t.ExpressId, cascadeDelete: true)
- // .ForeignKey("dbo.ExpressServiceProviders", t => t.ProviderId, cascadeDelete: true)
- // .Index(t => t.ExpressId)
- // .Index(t => t.ProviderId);
- //CreateTable(
- // "dbo.ExpressServiceProviders",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProviderName = c.String(maxLength: 50),
- // QueryApiUrl = c.String(maxLength: 150),
- // CallBackUrl = c.String(maxLength: 150),
- // ExcuteNamespaceAndMethod = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 50),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Factories",
- // c => new
- // {
- // FactoryID = c.String(nullable: false, maxLength: 128),
- // FactoryName = c.String(nullable: false, maxLength: 100),
- // ShortNames = c.String(nullable: false, maxLength: 20),
- // RegionID = c.String(nullable: false, maxLength: 50),
- // FactoryURL = c.String(maxLength: 80),
- // Address = c.String(maxLength: 100),
- // ZIP = c.String(maxLength: 50),
- // LinkMan = c.String(maxLength: 50),
- // Telephone = c.String(maxLength: 50),
- // Remark = c.String(maxLength: 200),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // })
- // .PrimaryKey(t => t.FactoryID);
- //CreateTable(
- // "dbo.FinshedEnterStore",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // PackageApplyNo = c.String(nullable: false, maxLength: 32),
- // PackageProductNo = c.String(maxLength: 50),
- // ProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // SourceStoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // ApplySourceType = c.Int(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // PackageSpecification = c.Decimal(nullable: false, precision: 18, scale: 3),
- // PackageCount = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualPackageCount = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 20),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // EnterStoreUser = c.String(maxLength: 20),
- // EnterStoreDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // CreateSourceType = c.Int(),
- // PackageEnterNum = c.String(),
- // PackageUser = c.String(maxLength: 20),
- // VerifyUser = c.String(maxLength: 20),
- // ApplyQuantity2 = c.Decimal(nullable: false, precision: 18, scale: 3),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.FixedAssetInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(maxLength: 50),
- // Name = c.String(maxLength: 50),
- // Model = c.String(maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_FixedAsset_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.FixedAssetTypeInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // Name = c.String(nullable: false, maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_FixedAssetType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.Sys_Functions",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // FunctionNo = c.String(maxLength: 100),
- // ParentNo = c.String(maxLength: 100),
- // FunctionName = c.String(maxLength: 100),
- // PermissionName = c.String(maxLength: 500),
- // FunctionType = c.Int(nullable: false),
- // FunctionPath = c.String(maxLength: 500),
- // Action = c.String(maxLength: 50),
- // Controller = c.String(maxLength: 50),
- // Url = c.String(),
- // Icon = c.String(maxLength: 20),
- // Class = c.String(maxLength: 100),
- // Script = c.String(),
- // Sort = c.Int(nullable: false),
- // Depth = c.Int(nullable: false),
- // IsLeaf = c.Boolean(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysFunction_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.InventoryCheck",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // CheckNo = c.String(maxLength: 32),
- // StoreHouseId = c.Int(nullable: false),
- // StoreAreaCode = c.String(maxLength: 32),
- // ShelfNumber = c.String(maxLength: 32),
- // ShelfLevel = c.String(maxLength: 32),
- // SequenceNo = c.String(maxLength: 32),
- // CheckType = c.String(maxLength: 10),
- // PlanStartDate = c.DateTime(),
- // PlanEndDate = c.DateTime(),
- // Remark = c.String(maxLength: 200),
- // CheckUser = c.String(maxLength: 32),
- // PublishUser = c.String(maxLength: 32),
- // FinishDate = c.DateTime(),
- // CheckState = c.Int(nullable: false),
- // ProductNo = c.String(maxLength: 32),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_InventoryCheckInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.InventoryCheckRecord",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // CheckNo = c.String(maxLength: 32),
- // CurrentStoreHouseNo = c.String(maxLength: 32),
- // CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.LicenseDocumentInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(maxLength: 50),
- // Name = c.String(maxLength: 50),
- // Description = c.String(maxLength: 500),
- // LicenseGroup = c.String(maxLength: 50),
- // LicenseType = c.String(maxLength: 50),
- // FilePath = c.String(maxLength: 300),
- // ExpireDate = c.DateTime(nullable: false),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_LicenseDocument_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.LicenseTypeInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // Name = c.String(maxLength: 50),
- // GroupName = c.String(maxLength: 50),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.MaintenanceMemberInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // MaintenanceNo = c.String(),
- // EmployeeId = c.Int(nullable: false),
- // Name = c.String(),
- // StartDateTime = c.DateTime(),
- // EndDateTime = c.DateTime(),
- // WorkHour = c.Decimal(nullable: false, precision: 18, scale: 2),
- // IsConfirm = c.Boolean(nullable: false),
- // WorkDesc = c.String(),
- // Remark = c.String(maxLength: 500),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
- // .Index(t => t.EmployeeId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.MaintenanceRecordInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // DeviceMgPlanNo = c.String(maxLength: 50),
- // DeviceNo = c.String(maxLength: 50),
- // DeviceName = c.String(maxLength: 50),
- // MgType = c.Int(nullable: false),
- // Description = c.String(maxLength: 500),
- // Address = c.String(maxLength: 200),
- // PlanDate = c.DateTime(nullable: false),
- // CompleteState = c.Int(nullable: false),
- // CompleteDate = c.DateTime(),
- // Remark = c.String(maxLength: 500),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.MoldInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(maxLength: 50),
- // Name = c.String(maxLength: 50),
- // Model = c.String(maxLength: 50),
- // Material = c.String(maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // CustomerName = c.String(maxLength: 50),
- // ShelfNum = c.String(maxLength: 50),
- // OuterDiameter = c.String(maxLength: 50),
- // InsideDiameter = c.String(maxLength: 50),
- // Thickness = c.String(maxLength: 50),
- // Height = c.String(maxLength: 50),
- // Rigidity = c.String(maxLength: 50),
- // MaintenanceCycle = c.Int(nullable: false),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_Mold_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.MoldProductionRecord",
- // c => new
- // {
- // Id = c.Long(nullable: false, identity: true),
- // MoldNo = c.String(nullable: false, maxLength: 50),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // Quantity = c.Int(nullable: false),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.OrderHeader",
- // c => new
- // {
- // OrderNo = c.String(nullable: false, maxLength: 128),
- // CustomerId = c.String(nullable: false, maxLength: 30),
- // LinkName = c.String(nullable: false, maxLength: 50),
- // OrderDate = c.DateTime(nullable: false, storeType: "smalldatetime"),
- // Fax = c.String(maxLength: 50),
- // Telephone = c.String(maxLength: 50),
- // CustomerSendId = c.Int(nullable: false),
- // StockNo = c.String(maxLength: 50),
- // OrderStatusId = c.Int(nullable: false),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 30),
- // SaleType = c.Int(),
- // SaleMan = c.String(maxLength: 50),
- // IsLock = c.String(maxLength: 1),
- // })
- // .PrimaryKey(t => t.OrderNo);
- //CreateTable(
- // "dbo.OrderItems",
- // c => new
- // {
- // OrderItemId = c.Int(nullable: false, identity: true),
- // OrderNo = c.String(nullable: false, maxLength: 30),
- // ProductNo = c.String(nullable: false, maxLength: 30),
- // Price = c.Decimal(nullable: false, storeType: "money"),
- // AfterTaxPrice = c.Decimal(nullable: false, storeType: "money"),
- // CurrencyId = c.String(nullable: false, maxLength: 10),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3, storeType: "numeric"),
- // OrderUnitId = c.Int(nullable: false),
- // SendDate = c.DateTime(nullable: false, storeType: "smalldatetime"),
- // IsReport = c.String(nullable: false, maxLength: 1),
- // IsPartSend = c.String(nullable: false, maxLength: 1),
- // OrderItemStatusId = c.Int(),
- // WareHouse = c.String(maxLength: 50),
- // OrderItemDesc = c.String(maxLength: 500),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // PartNo = c.String(maxLength: 30),
- // ToCnyRate = c.Decimal(precision: 18, scale: 3),
- // EmergencyLevel = c.Int(nullable: false),
- // IsLock = c.String(maxLength: 1),
- // StandardName = c.String(maxLength: 50),
- // StoreCompleteState = c.Int(nullable: false),
- // LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // })
- // .PrimaryKey(t => t.OrderItemId);
- //CreateTable(
- // "dbo.OrderProduction",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // OrderItemId = c.Int(nullable: false),
- // ProductionOrderNo = c.String(maxLength: 11),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.OrderSendBills",
- // c => new
- // {
- // OrderSendBillNo = c.String(nullable: false, maxLength: 128),
- // CustomerId = c.String(nullable: false, maxLength: 30),
- // SendDate = c.DateTime(storeType: "smalldatetime"),
- // SendAddress = c.String(maxLength: 250),
- // ContactTels = c.String(maxLength: 50),
- // ContactMan = c.String(maxLength: 50),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // IsDoBill = c.String(maxLength: 1),
- // ExpressId = c.Int(),
- // ExpressBillNo = c.String(maxLength: 50),
- // })
- // .PrimaryKey(t => t.OrderSendBillNo);
- //CreateTable(
- // "dbo.OrderSendExceed",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // OrderItemId = c.Int(nullable: false),
- // ExceedQuantity = c.Decimal(nullable: false, precision: 18, scale: 3, storeType: "numeric"),
- // OperatorMan = c.String(maxLength: 30),
- // OrderNo = c.String(),
- // ProductNo = c.String(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.OrderSend",
- // c => new
- // {
- // OrderSendId = c.Int(nullable: false, identity: true),
- // OrderItemId = c.Int(nullable: false),
- // SendDate = c.DateTime(storeType: "smalldatetime"),
- // SendQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // OrderUnitId = c.Int(),
- // Remark = c.String(maxLength: 250),
- // OrderSendBillNo = c.String(maxLength: 20),
- // OrderStickBillNo = c.String(maxLength: 40),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // CreatorUserId = c.String(maxLength: 20),
- // QuantityPerPack = c.Decimal(precision: 18, scale: 3),
- // PackageCount = c.Decimal(precision: 18, scale: 3),
- // ProductBatchNum = c.String(),
- // StoreLocationNo = c.String(maxLength: 32),
- // CurrentProductStoreHouseNo = c.String(),
- // StatementBillNo = c.String(maxLength: 32),
- // LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // SendBillSort = c.Int(nullable: false),
- // StatementBillSort = c.Int(nullable: false),
- // })
- // .PrimaryKey(t => t.OrderSendId);
- //CreateTable(
- // "dbo.OrderStickBills",
- // c => new
- // {
- // OrderStickBillNo = c.String(nullable: false, maxLength: 128),
- // CustomerId = c.String(nullable: false, maxLength: 30),
- // CreatDate = c.DateTime(storeType: "smalldatetime"),
- // StickNum = c.String(maxLength: 30),
- // StickMan = c.String(maxLength: 20),
- // Description = c.String(maxLength: 4000),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // InvoiceState = c.Int(),
- // Amount = c.Decimal(precision: 18, scale: 2),
- // OriginalStickNum = c.String(maxLength: 30),
- // ReturnOrderNo = c.String(maxLength: 30),
- // OrderNo = c.String(maxLength: 500),
- // InvoiceType = c.Int(nullable: false),
- // })
- // .PrimaryKey(t => t.OrderStickBillNo);
- //CreateTable(
- // "dbo.OrderUnit",
- // c => new
- // {
- // OrderUnitId = c.Int(nullable: false, identity: true),
- // OrderUnitName = c.String(maxLength: 50),
- // ProductNum = c.Int(),
- // OrderUnitDesc = c.String(maxLength: 250),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(),
- // })
- // .PrimaryKey(t => t.OrderUnitId);
- //CreateTable(
- // "dbo.OutFactory",
- // c => new
- // {
- // OutFactoryId = c.String(nullable: false, maxLength: 128),
- // OutFactoryName = c.String(nullable: false, maxLength: 50),
- // LinkMan = c.String(maxLength: 20),
- // Address = c.String(maxLength: 150),
- // WebSite = c.String(maxLength: 50),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // Telephone = c.String(maxLength: 50),
- // Fax = c.String(maxLength: 50),
- // zip = c.String(maxLength: 6),
- // Email = c.String(maxLength: 200),
- // })
- // .PrimaryKey(t => t.OutFactoryId);
- //CreateTable(
- // "dbo.PackageApply",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // PackageApplyNo = c.String(nullable: false, maxLength: 32),
- // CurrentStoreHouseNo = c.String(maxLength: 32),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // SemiProductNo = c.String(maxLength: 32),
- // ProductNo = c.String(maxLength: 32),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // SourceStore = c.Int(nullable: false),
- // ApplyStatus = c.String(nullable: false, maxLength: 1),
- // IsClose = c.Boolean(nullable: false),
- // ApplyDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Sys_Permissions",
- // c => new
- // {
- // Id = c.Long(nullable: false, identity: true),
- // PermissionNo = c.String(maxLength: 32),
- // PermissionName = c.String(maxLength: 500),
- // Master = c.Int(),
- // MasterValue = c.String(),
- // Access = c.Int(),
- // AccessValue = c.String(),
- // IsGranted = c.Boolean(nullable: false),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.ProductInspectInfos",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductInspectReportNo = c.String(nullable: false, maxLength: 32),
- // ProductInspectNo = c.String(nullable: false, maxLength: 32),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // SemiProductNo = c.String(maxLength: 32),
- // InspectStatus = c.Int(nullable: false),
- // InspectSubject = c.String(maxLength: 50),
- // InspectResult = c.Int(nullable: false),
- // InspectDate = c.DateTime(),
- // InspectMember = c.String(maxLength: 100),
- // IsLock = c.String(maxLength: 1),
- // InspectContent = c.String(maxLength: 1000),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.ProductInspectReportInfos",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductInspectReportNo = c.String(nullable: false, maxLength: 32),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // SemiProductNo = c.String(maxLength: 32),
- // ConfirmStatus = c.Int(nullable: false),
- // InspectCount = c.Int(nullable: false),
- // ConfirmDate = c.DateTime(),
- // ConfirmUser = c.String(maxLength: 100),
- // InspectContent = c.String(maxLength: 1000),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.ProductionOrderLogInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionNo = c.String(maxLength: 20),
- // ProductOrderNo = c.String(maxLength: 11),
- // EmployeeId = c.Int(nullable: false),
- // CarNo = c.String(maxLength: 20),
- // QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
- // .Index(t => t.EmployeeId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.ProductionOrders",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // ProductionOrderStatus = c.Int(nullable: false),
- // StoveNo = c.String(maxLength: 20),
- // CarNo = c.String(maxLength: 20),
- // SemiProductNo = c.String(maxLength: 32),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // RawMaterials = c.String(maxLength: 100),
- // Material = c.String(maxLength: 50),
- // PartNo = c.String(maxLength: 50),
- // Model = c.String(maxLength: 50),
- // SurfaceColor = c.String(maxLength: 50),
- // Rigidity = c.String(maxLength: 50),
- // Size = c.String(maxLength: 50),
- // ProcessingType = c.String(maxLength: 1),
- // ProcessingLevel = c.String(maxLength: 1),
- // Remark = c.String(maxLength: 150),
- // IsChecked = c.Int(),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // IsLock = c.String(maxLength: 1),
- // SourceProductionOrderNo = c.String(maxLength: 11),
- // PlanProduceDate = c.DateTime(),
- // EnterQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ProductionType = c.String(maxLength: 1),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // OutsourcingFactory = c.String(),
- // EnterDate = c.DateTime(),
- // InspectDate = c.DateTime(),
- // HasExported = c.Boolean(nullable: false),
- // MaxQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.ProductMapper",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductNo = c.String(maxLength: 50),
- // PreProductNo = c.String(maxLength: 50),
- // PreProductType = c.Int(nullable: false),
- // NewProductType = c.Int(nullable: false),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ProductMapper_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.ProductOutStore",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(maxLength: 11),
- // CurrentProductStoreHouseNo = c.String(maxLength: 32),
- // ProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // IsConfirm = c.Boolean(),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 20),
- // AuditDate = c.DateTime(),
- // OutStoreUser = c.String(maxLength: 20),
- // OutStoreDate = c.DateTime(),
- // ApplyOutDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // OrderSendId = c.Int(nullable: false),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyOutStoreSourceType = c.Int(nullable: false),
- // CreateSourceType = c.Int(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.ProductProperties",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // PropertyType = c.String(maxLength: 50),
- // PropertyNo = c.String(maxLength: 50),
- // PropertyValue = c.String(maxLength: 50),
- // DisplayValue = c.String(maxLength: 150),
- // ContentInfo = c.String(maxLength: 250),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ProductProperty_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Products",
- // c => new
- // {
- // ProductNo = c.String(nullable: false, maxLength: 128),
- // ProductName = c.String(nullable: false, maxLength: 50),
- // Model = c.String(maxLength: 50),
- // StandardId = c.Int(),
- // Material = c.String(maxLength: 50),
- // ProductDesc = c.String(maxLength: 200),
- // SurfaceColor = c.String(maxLength: 50),
- // Rigidity = c.String(maxLength: 50),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // Sequence = c.Int(nullable: false),
- // IsStandard = c.String(nullable: false, maxLength: 1),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // Defprice = c.Decimal(storeType: "money"),
- // TranUnitValue = c.Decimal(precision: 18, scale: 3),
- // PartNo = c.String(maxLength: 50),
- // SpecialDesc = c.String(maxLength: 50),
- // ModelNo = c.String(maxLength: 20),
- // MaterialNo = c.String(maxLength: 20),
- // SurfaceColorNo = c.String(maxLength: 20),
- // RigidityNo = c.String(maxLength: 20),
- // SpecialNo = c.String(maxLength: 20),
- // PrevProductNo = c.String(maxLength: 50),
- // })
- // .PrimaryKey(t => t.ProductNo);
- //CreateTable(
- // "dbo.ProductInspectReportContents",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(maxLength: 32),
- // PtoductInspectNo = c.String(maxLength: 32),
- // ReportContent = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.QualityIssueLabelInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // Name = c.String(nullable: false, maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_QualityIssueLabel_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.Regions",
- // c => new
- // {
- // RegionID = c.String(nullable: false, maxLength: 128),
- // RegionName = c.String(nullable: false, maxLength: 50),
- // FatherRegionID = c.String(nullable: false, maxLength: 50),
- // URL = c.String(maxLength: 80),
- // Depth = c.Int(nullable: false),
- // IsLeaf = c.String(nullable: false, maxLength: 1),
- // Sort = c.Int(nullable: false),
- // Path = c.String(nullable: false, maxLength: 220),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // })
- // .PrimaryKey(t => t.RegionID);
- //CreateTable(
- // "dbo.ReturnGoodOrder",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ReturnOrderNo = c.String(maxLength: 32),
- // SendOrderNo = c.String(maxLength: 32),
- // OrderNo = c.String(maxLength: 32),
- // OrderItemNo = c.String(maxLength: 32),
- // ProductNo = c.String(maxLength: 32),
- // ProductionOrderNo = c.String(maxLength: 32),
- // CustomerId = c.String(maxLength: 32),
- // Reason = c.String(maxLength: 500),
- // Amount = c.Decimal(precision: 18, scale: 2),
- // AuditAmount = c.Decimal(precision: 18, scale: 2),
- // Quantity = c.Decimal(precision: 18, scale: 3),
- // HandleUser = c.String(maxLength: 32),
- // ApplyUser = c.String(maxLength: 32),
- // ConfirmUser = c.String(maxLength: 32),
- // ReturnDate = c.DateTime(),
- // ApplyDate = c.DateTime(),
- // ConfirmDate = c.DateTime(),
- // ReturnState = c.Int(nullable: false),
- // ReturnType = c.Int(nullable: false),
- // LinkName = c.String(maxLength: 50),
- // SurveyReason = c.String(maxLength: 500),
- // SurveyDetail = c.String(maxLength: 500),
- // Solution = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ReturnGoodOrder_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .Index(t => t.ReturnOrderNo, unique: true);
- //CreateTable(
- // "dbo.RmEnterStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // RmProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 32),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // EnterStoreUser = c.String(maxLength: 32),
- // EnterStoreDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductBatchNum = c.String(maxLength: 32),
- // CreateSourceType = c.Int(nullable: false),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.RmOutStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // CurrentRmStoreHouseNo = c.String(maxLength: 32),
- // RmProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // IsConfirm = c.Boolean(),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 150),
- // AuditDate = c.DateTime(),
- // OutStoreUser = c.String(maxLength: 150),
- // OutStoreDate = c.DateTime(),
- // ApplyOutDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductBatchNum = c.String(maxLength: 32),
- // CreateSourceType = c.Int(nullable: false),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.RmProduct",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductName = c.String(maxLength: 50),
- // Material = c.String(maxLength: 50),
- // Model = c.String(maxLength: 50),
- // ProductDesc = c.String(maxLength: 200),
- // ModelNo = c.String(maxLength: 20),
- // MaterialNo = c.String(maxLength: 20),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Sys_Roles",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // Name = c.String(nullable: false, maxLength: 32),
- // RoleDisplayName = c.String(nullable: false, maxLength: 64),
- // Description = c.String(maxLength: 1000),
- // RoleType = c.Int(nullable: false),
- // IsStatic = c.Boolean(nullable: false),
- // IsDefault = c.Boolean(nullable: false),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysRole_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.ScheduleOrderSend",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // OrderItemId = c.Int(nullable: false),
- // Remark = c.String(maxLength: 500),
- // PlanQuantity = c.Decimal(precision: 18, scale: 2),
- // SendUser = c.String(maxLength: 32),
- // PlanDate = c.DateTime(),
- // SendState = c.Int(nullable: false),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewScheduleOrderSend",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // OrderItemId = c.Int(nullable: false),
- // PlanQuantity = c.Decimal(precision: 18, scale: 2),
- // SendUser = c.String(),
- // Remark = c.String(),
- // PlanDate = c.DateTime(),
- // SendState = c.Int(nullable: false),
- // OrderNo = c.String(),
- // ProductNo = c.String(),
- // ProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // CustomerName = c.String(),
- // CustomerId = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.ScrapEnterStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // ProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 32),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // EnterStoreUser = c.String(maxLength: 32),
- // EnterStoreDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductType = c.Int(nullable: false),
- // ScrapSource = c.Int(nullable: false),
- // ScrapSourceNo = c.String(maxLength: 50),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.ScrapTypeInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // Name = c.String(nullable: false, maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Remark = c.String(maxLength: 500),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ScrapType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.SemiEnterStore",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.String(nullable: false, maxLength: 5),
- // IsClose = c.Boolean(nullable: false),
- // ApplySource = c.String(nullable: false, maxLength: 5),
- // SemiProductNo = c.String(maxLength: 32),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 20),
- // AuditDate = c.DateTime(),
- // EnterStoreUser = c.String(maxLength: 20),
- // EnterStoreDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // CreateSourceType = c.Int(),
- // StoreLocationNo = c.String(maxLength: 32),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.SemiOutStores",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // CurrentSemiStoreHouseNo = c.String(maxLength: 32),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.String(nullable: false, maxLength: 5),
- // ApplyTypes = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // ApplyOutStoreSource = c.String(nullable: false, maxLength: 5),
- // IsConfirm = c.Boolean(),
- // SemiProductNo = c.String(maxLength: 32),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyOutDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // AuditUser = c.String(maxLength: 20),
- // AuditDate = c.DateTime(),
- // OutStoreUser = c.String(maxLength: 20),
- // OutStoreDate = c.DateTime(),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // CreateSourceType = c.Int(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.SemiProducts",
- // c => new
- // {
- // SemiProductNo = c.String(nullable: false, maxLength: 128),
- // SemiProductName = c.String(maxLength: 50),
- // Model = c.String(maxLength: 50),
- // Material = c.String(maxLength: 50),
- // ProductDesc = c.String(maxLength: 200),
- // SurfaceColor = c.String(maxLength: 50),
- // Rigidity = c.String(maxLength: 50),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // IsStandard = c.String(nullable: false, maxLength: 1),
- // Sequence = c.Int(nullable: false),
- // IsLock = c.String(nullable: false, maxLength: 1),
- // PartNo = c.String(maxLength: 50),
- // TranUnitValue = c.Decimal(precision: 18, scale: 3),
- // SpecialDesc = c.String(maxLength: 50),
- // ModelNo = c.String(maxLength: 20),
- // MaterialNo = c.String(maxLength: 20),
- // SurfaceColorNo = c.String(maxLength: 20),
- // RigidityNo = c.String(maxLength: 20),
- // SpecialNo = c.String(maxLength: 20),
- // PrevProductNo = c.String(maxLength: 50),
- // })
- // .PrimaryKey(t => t.SemiProductNo);
- //CreateTable(
- // "dbo.SemiProductStore",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StoreHouseId = c.Int(nullable: false),
- // SemiProductNo = c.String(maxLength: 32),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // StoreYear = c.String(maxLength: 5),
- // StoreMonth = c.String(maxLength: 4),
- // Active = c.String(nullable: false, maxLength: 1),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Sys_Settings",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // SettingNo = c.String(maxLength: 32),
- // SettingName = c.String(maxLength: 50),
- // SettingType = c.Int(nullable: false),
- // Code = c.String(maxLength: 100),
- // Value = c.String(maxLength: 500),
- // Description = c.String(maxLength: 1000),
- // Remark = c.String(maxLength: 1000),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysSetting_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.ShortMessage",
- // c => new
- // {
- // MsgID = c.Int(nullable: false, identity: true),
- // SendUserID = c.String(nullable: false, maxLength: 20),
- // Title = c.String(maxLength: 100),
- // Content = c.String(maxLength: 3000),
- // SendTime = c.DateTime(storeType: "smalldatetime"),
- // IsDelete = c.String(nullable: false, maxLength: 1),
- // RecieveUserIds = c.String(maxLength: 400),
- // })
- // .PrimaryKey(t => t.MsgID);
- //CreateTable(
- // "dbo.ShortMsgDetail",
- // c => new
- // {
- // DetailID = c.Int(nullable: false, identity: true),
- // MsgID = c.Int(nullable: false),
- // RecvUserID = c.String(nullable: false, maxLength: 20),
- // IsRead = c.String(nullable: false, maxLength: 1),
- // })
- // .PrimaryKey(t => t.DetailID);
- //CreateTable(
- // "dbo.StandardCatalog",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StandardNo = c.String(maxLength: 50),
- // StandardAbbr = c.String(nullable: false, maxLength: 50),
- // StandardAbbrName = c.String(nullable: false, maxLength: 50),
- // StandardName = c.String(nullable: false, maxLength: 150),
- // Rigidity = c.String(maxLength: 250),
- // Param = c.String(maxLength: 250),
- // Drawing = c.String(),
- // Remark = c.String(maxLength: 250),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StandardCatalog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.StandardDetail",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StandardId = c.Int(nullable: false),
- // Specs = c.String(nullable: false, maxLength: 50),
- // StandardName = c.String(nullable: false, maxLength: 150),
- // InnerDiameter1 = c.Decimal(precision: 18, scale: 2),
- // InnerDiameter2 = c.Decimal(precision: 18, scale: 2),
- // OutDiameter1 = c.Decimal(precision: 18, scale: 2),
- // OutDiameter2 = c.Decimal(precision: 18, scale: 2),
- // Thickness1 = c.Decimal(precision: 18, scale: 2),
- // Thickness2 = c.Decimal(precision: 18, scale: 2),
- // Height1 = c.Decimal(precision: 18, scale: 2),
- // Height2 = c.Decimal(precision: 18, scale: 2),
- // InnerChamfer1 = c.Decimal(precision: 18, scale: 2),
- // InnerChamfer2 = c.Decimal(precision: 18, scale: 2),
- // OutChamfer1 = c.Decimal(precision: 18, scale: 2),
- // OutChamfer2 = c.Decimal(precision: 18, scale: 2),
- // ThousandWeigh = c.Decimal(precision: 18, scale: 2),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Standard",
- // c => new
- // {
- // StandardId = c.Int(nullable: false, identity: true),
- // StandardName = c.String(nullable: false, maxLength: 50),
- // StandardDesc = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // })
- // .PrimaryKey(t => t.StandardId);
- //CreateTable(
- // "dbo.StatementBill",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StatementBillNo = c.String(nullable: false, maxLength: 30),
- // CustomerId = c.String(nullable: false, maxLength: 30),
- // BillMan = c.String(maxLength: 20),
- // Description = c.String(maxLength: 4000),
- // StatementState = c.Int(),
- // OrderStickBillNo = c.String(maxLength: 30),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .Index(t => t.StatementBillNo, unique: true);
- //CreateTable(
- // "dbo.StoreHouseLocation",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StoreLocationNo = c.String(maxLength: 32),
- // StoreAreaCode = c.String(maxLength: 32),
- // ShelfNumber = c.String(maxLength: 50),
- // ShelfLevel = c.String(maxLength: 10),
- // SequenceNo = c.String(maxLength: 10),
- // Remark = c.String(maxLength: 250),
- // StoreHouseId = c.Int(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StoreHouseLocation_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.StoreHouse",
- // c => new
- // {
- // StoreHouseID = c.Int(nullable: false, identity: true),
- // StoreHouseName = c.String(nullable: false, maxLength: 50),
- // StoreHouseTypeId = c.Int(),
- // Address = c.String(maxLength: 250),
- // Tel = c.String(maxLength: 50),
- // Fax = c.String(maxLength: 50),
- // ContactMan = c.String(maxLength: 50),
- // Remark = c.String(maxLength: 500),
- // IsLock = c.String(maxLength: 1),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // StoreHouseNo = c.String(maxLength: 20),
- // })
- // .PrimaryKey(t => t.StoreHouseID);
- //CreateTable(
- // "dbo.Sys_AttachFiles",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // AttachNo = c.String(maxLength: 32),
- // TableName = c.String(maxLength: 50),
- // ColumnName = c.String(maxLength: 50),
- // SourceKey = c.String(maxLength: 50),
- // FileTitle = c.String(maxLength: 50),
- // FileName = c.String(maxLength: 50),
- // FilePath = c.String(maxLength: 500),
- // FileType = c.String(maxLength: 20),
- // FileExt = c.String(maxLength: 10),
- // Description = c.String(maxLength: 500),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Sys_Helps",
- // c => new
- // {
- // HelpId = c.Int(nullable: false, identity: true),
- // Classification = c.String(maxLength: 40),
- // HelpTitle = c.String(nullable: false, maxLength: 20),
- // HelpKeyWords = c.String(maxLength: 20),
- // HelpContent = c.String(storeType: "ntext"),
- // Sequence = c.Int(nullable: false),
- // TimeCreated = c.DateTime(storeType: "smalldatetime"),
- // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
- // UserIDLastMod = c.String(maxLength: 20),
- // })
- // .PrimaryKey(t => t.HelpId);
- //CreateTable(
- // "dbo.Sys_States",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StateNo = c.String(maxLength: 32),
- // StateName = c.String(maxLength: 50),
- // TableName = c.String(nullable: false, maxLength: 50),
- // ColumnName = c.String(nullable: false, maxLength: 50),
- // CodeValue = c.String(nullable: false, maxLength: 100),
- // DisplayValue = c.String(nullable: false, maxLength: 100),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysState_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id)
- // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
- // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
- // .Index(t => t.DeleterUserId)
- // .Index(t => t.LastModifierUserId)
- // .Index(t => t.CreatorUserId);
- //CreateTable(
- // "dbo.TemplateInfos",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // TemplateNo = c.String(maxLength: 50),
- // Name = c.String(maxLength: 50),
- // Description = c.String(maxLength: 500),
- // Content = c.String(),
- // Type = c.Int(nullable: false),
- // TempKey = c.String(maxLength: 50),
- // FilePath = c.String(maxLength: 300),
- // FileExt = c.String(maxLength: 50),
- // ClassPath = c.String(maxLength: 100),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Sys_UserLoginLogs",
- // c => new
- // {
- // Id = c.Long(nullable: false, identity: true),
- // UserId = c.Long(),
- // UserNameOrEmailAddress = c.String(maxLength: 255),
- // ClientIpAddress = c.String(maxLength: 64),
- // ClientName = c.String(maxLength: 128),
- // BrowserInfo = c.String(maxLength: 512),
- // Result = c.Byte(nullable: false),
- // CreationTime = c.DateTime(nullable: false),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.Sys_UserLogins",
- // c => new
- // {
- // Id = c.Long(nullable: false, identity: true),
- // UserId = c.Long(nullable: false),
- // LoginProvider = c.String(nullable: false, maxLength: 128),
- // ProviderKey = c.String(nullable: false, maxLength: 256),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.v_BookedProductNum",
- // c => new
- // {
- // ProductNo = c.String(nullable: false, maxLength: 128),
- // BookedQuantity = c.Decimal(precision: 18, scale: 2),
- // })
- // .PrimaryKey(t => t.ProductNo);
- //CreateTable(
- // "dbo.v_CanProductStore",
- // c => new
- // {
- // ProductNo = c.String(nullable: false, maxLength: 128),
- // CanUserQuantity = c.Decimal(precision: 18, scale: 2),
- // })
- // .PrimaryKey(t => t.ProductNo);
- //CreateTable(
- // "dbo.N_ViewCurrentProductStoreHouse",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // CurrentProductStoreHouseNo = c.String(nullable: false),
- // ProductionOrderNo = c.String(nullable: false),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(),
- // ProductNo = c.String(),
- // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // ProductName = c.String(maxLength: 50),
- // Model = c.String(maxLength: 20),
- // Material = c.String(maxLength: 50),
- // SurfaceColor = c.String(maxLength: 50),
- // Rigidity = c.String(maxLength: 50),
- // IsStandard = c.String(maxLength: 1),
- // ProductDesc = c.String(),
- // PartNo = c.String(),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
- // PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
- // InventoryCheckState = c.Int(),
- // ReturnState = c.Int(),
- // StoreAreaCode = c.String(),
- // ShelfNumber = c.String(),
- // ShelfLevel = c.String(),
- // SequenceNo = c.String(),
- // LocationRemark = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewCurrentRmStoreHouse",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // RmProductNo = c.String(maxLength: 32),
- // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // Remark = c.String(maxLength: 150),
- // PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
- // ProductName = c.String(),
- // Material = c.String(),
- // Model = c.String(),
- // ProductDesc = c.String(),
- // StoreHouseName = c.String(),
- // ProductBatchNum = c.String(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewCurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewCurrentSemiStoreHouse",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // CurrentSemiStoreHouseNo = c.String(nullable: false, maxLength: 32),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // StoreHouseId = c.Int(nullable: false),
- // SemiProductNo = c.String(maxLength: 32),
- // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ApplyEnterDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // SemiProductName = c.String(maxLength: 50),
- // Model = c.String(maxLength: 20),
- // PartNo = c.String(),
- // Material = c.String(maxLength: 50),
- // SurfaceColor = c.String(maxLength: 50),
- // Rigidity = c.String(maxLength: 50),
- // IsStandard = c.String(maxLength: 1),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
- // StoreLocationNo = c.String(),
- // PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
- // InventoryCheckState = c.Int(),
- // ReturnState = c.Int(),
- // StoreAreaCode = c.String(),
- // ShelfNumber = c.String(),
- // ShelfLevel = c.String(),
- // SequenceNo = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.v_SemiProductStoreInfo",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // AllQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // AllFreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // AllPreMonthQuantity = c.Decimal(precision: 18, scale: 2),
- // SemiProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // PartNo = c.String(),
- // ProductDesc = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.v_ProductStoreInfo",
- // c => new
- // {
- // ProductNo = c.String(nullable: false, maxLength: 128),
- // AllQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // AllFreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // AllPreMonthQuantity = c.Decimal(precision: 18, scale: 2),
- // ProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // PartNo = c.String(),
- // Defprice = c.Decimal(precision: 18, scale: 3),
- // })
- // .PrimaryKey(t => t.ProductNo);
- //CreateTable(
- // "dbo.v_customerstick",
- // c => new
- // {
- // OrderSendId = c.Int(nullable: false, identity: true),
- // OrderNo = c.String(),
- // StockNo = c.String(),
- // OrderSendBillNo = c.String(),
- // SendDate = c.DateTime(),
- // PartNo = c.String(),
- // Model = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // SendQuantity = c.Decimal(precision: 18, scale: 2),
- // OrderUnitId = c.Int(),
- // Price = c.Decimal(precision: 18, scale: 2),
- // total = c.Decimal(precision: 18, scale: 2),
- // CustomerId = c.String(),
- // OrderUnitName = c.String(),
- // IsDoBill = c.String(),
- // Remark = c.String(),
- // OrderStickBillNo = c.String(),
- // StatementBillNo = c.String(),
- // })
- // .PrimaryKey(t => t.OrderSendId);
- //CreateTable(
- // "dbo.N_ViewDisqualifiedProduction",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // DisqualifiedNo = c.String(maxLength: 20),
- // ProductOrderNo = c.String(maxLength: 11),
- // ReturnOrderNo = c.String(maxLength: 32),
- // ProductNo = c.String(maxLength: 50),
- // ProductName = c.String(maxLength: 100),
- // ProductType = c.Int(nullable: false),
- // QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
- // HandleType = c.Int(nullable: false),
- // CheckUser = c.String(maxLength: 20),
- // CheckDate = c.DateTime(),
- // HandleUser = c.String(maxLength: 20),
- // HandleDate = c.DateTime(),
- // DisqualifiedType = c.Int(),
- // CreationTime = c.DateTime(nullable: false),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewDisqualifiedReturn",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // DisqualifiedNo = c.String(maxLength: 20),
- // ProductOrderNo = c.String(maxLength: 11),
- // ReturnOrderNo = c.String(maxLength: 32),
- // ProductNo = c.String(maxLength: 50),
- // ProductName = c.String(maxLength: 100),
- // ProductType = c.Int(nullable: false),
- // QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
- // QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
- // HandleType = c.Int(nullable: false),
- // CheckUser = c.String(maxLength: 20),
- // CheckDate = c.DateTime(),
- // HandleUser = c.String(maxLength: 20),
- // HandleDate = c.DateTime(),
- // DisqualifiedType = c.Int(),
- // CreationTime = c.DateTime(nullable: false),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // CustomerId = c.String(),
- // CustomerName = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.NV_ViewEmployeeInfo",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // No = c.String(),
- // Name = c.String(),
- // CardId = c.String(),
- // Gender = c.Int(nullable: false),
- // PhoneNumber = c.String(),
- // DepartmentNo = c.String(),
- // DepartmentName = c.String(),
- // DutyNo = c.String(),
- // DutyName = c.String(),
- // Description = c.String(),
- // UserName = c.String(),
- // Remark = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.vEnterOutLogDetail_c",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ActualId = c.Int(nullable: false),
- // EnterOutFlag = c.Int(nullable: false),
- // ProductNo = c.String(),
- // StoreHouseId = c.Int(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // DateTiem = c.DateTime(),
- // UserIDLastMod = c.String(),
- // Remark = c.String(),
- // ProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // PartNo = c.String(),
- // CustomerId = c.String(),
- // CustomerName = c.String(),
- // ProductionOrderNo = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.v_Store_Query",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ActualId = c.Int(nullable: false),
- // EnterOutFlag = c.Int(nullable: false),
- // ProductNo = c.String(),
- // StoreHouseId = c.Int(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // DateTiem = c.DateTime(),
- // UserIDLastMod = c.String(),
- // Remark = c.String(),
- // ProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // PartNo = c.String(),
- // AllQuantity = c.Decimal(precision: 18, scale: 2),
- // AllFreezeQuantity = c.Decimal(precision: 18, scale: 2),
- // AllPreMonthQuantity = c.Decimal(precision: 18, scale: 2),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.v_EnterOutSemiProductStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ActualId = c.Int(nullable: false),
- // EnterOutFlag = c.Int(nullable: false),
- // SemiProductNo = c.String(),
- // StoreHouseId = c.Int(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // DateTiem = c.DateTime(),
- // UserIDLastMod = c.String(),
- // Remark = c.String(),
- // SemiProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // PartNo = c.String(),
- // ProductDesc = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewInventoryCheckRecord_Product",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductNo = c.String(),
- // ProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // ProductDesc = c.String(),
- // CheckNo = c.String(),
- // CurrentStoreHouseNo = c.String(),
- // CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // StoreLocationNo = c.String(),
- // StoreHouseId = c.Int(nullable: false),
- // ProductionOrderNo = c.String(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewInventoryCheckRecord_Semi",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductNo = c.String(),
- // ProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // ProductDesc = c.String(),
- // CheckNo = c.String(),
- // CurrentStoreHouseNo = c.String(),
- // CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // StoreLocationNo = c.String(),
- // StoreHouseId = c.Int(nullable: false),
- // ProductionOrderNo = c.String(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewOrderItems",
- // c => new
- // {
- // OrderItemId = c.Int(nullable: false, identity: true),
- // OrderNo = c.String(),
- // ProductNo = c.String(),
- // Price = c.Decimal(nullable: false, storeType: "money"),
- // AfterTaxPrice = c.Decimal(nullable: false, storeType: "money"),
- // CurrencyId = c.String(),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2, storeType: "numeric"),
- // OrderUnitId = c.Int(nullable: false),
- // SendDate = c.DateTime(nullable: false, storeType: "smalldatetime"),
- // IsReport = c.String(),
- // IsPartSend = c.String(),
- // OrderItemStatusId = c.Int(),
- // WareHouse = c.String(),
- // OrderItemDesc = c.String(),
- // PartNo = c.String(),
- // TotalPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
- // CustomerId = c.String(),
- // LinkName = c.String(),
- // OrderDate = c.DateTime(storeType: "smalldatetime"),
- // Fax = c.String(),
- // Telephone = c.String(),
- // ProductName = c.String(),
- // Model = c.String(),
- // StandardId = c.Int(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // IsStandard = c.String(),
- // IsSendQuantity = c.Decimal(precision: 18, scale: 2),
- // OrderUnitName = c.String(),
- // StockNo = c.String(),
- // CustomerName = c.String(),
- // AfterTaxTotalPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
- // SaleType = c.Int(),
- // SaleMan = c.String(),
- // EmergencyLevel = c.Int(nullable: false),
- // IsLock = c.String(),
- // StandardName = c.String(),
- // StoreCompleteState = c.Int(nullable: false),
- // LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // })
- // .PrimaryKey(t => t.OrderItemId);
- //CreateTable(
- // "dbo.v_OrderSendBill",
- // c => new
- // {
- // OrderSendBillNo = c.String(nullable: false, maxLength: 128),
- // CustomerId = c.String(),
- // SendDate = c.DateTime(),
- // SendAddress = c.String(),
- // ContactTels = c.String(),
- // ContactMan = c.String(),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // UserIDLastMod = c.String(),
- // IsDoBill = c.String(),
- // OrderSendCount = c.Int(nullable: false),
- // StatementCount = c.Int(nullable: false),
- // ExpressId = c.Int(),
- // ExpressBillNo = c.String(),
- // ExpressName = c.String(),
- // CreatorUserId = c.String(),
- // TotalPrice = c.Decimal(precision: 18, scale: 3),
- // AfterTaxTotalPrice = c.Decimal(precision: 18, scale: 3),
- // CurrencyId = c.String(),
- // })
- // .PrimaryKey(t => t.OrderSendBillNo);
- //CreateTable(
- // "dbo.N_ViewOrderSends",
- // c => new
- // {
- // OrderSendId = c.Int(nullable: false, identity: true),
- // OrderItemId = c.Int(nullable: false),
- // SendDate = c.DateTime(),
- // SendQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // Remark = c.String(),
- // OrderSendBillNo = c.String(),
- // OrderStickBillNo = c.String(),
- // QuantityPerPack = c.Decimal(precision: 18, scale: 2),
- // PackageCount = c.Decimal(precision: 18, scale: 2),
- // ProductBatchNum = c.String(),
- // UserIDLastMod = c.String(),
- // OrderNo = c.String(),
- // ProductNo = c.String(),
- // Price = c.Decimal(nullable: false, precision: 18, scale: 2),
- // TotalPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
- // IsReport = c.String(),
- // PartNo = c.String(),
- // ProductName = c.String(),
- // Model = c.String(),
- // StandardId = c.Int(),
- // Material = c.String(),
- // ProductDesc = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // CustomerId = c.String(),
- // CustomerName = c.String(),
- // LinkName = c.String(),
- // OrderDate = c.DateTime(),
- // CustomerSendId = c.Int(),
- // StockNo = c.String(),
- // OrderUnitName = c.String(),
- // SaleType = c.Int(),
- // AfterTaxPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
- // StatementBillNo = c.String(),
- // SendActionDate = c.DateTime(),
- // StandardName = c.String(),
- // LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // SendBillSort = c.Int(nullable: false),
- // StatementBillSort = c.Int(nullable: false),
- // })
- // .PrimaryKey(t => t.OrderSendId);
- //CreateTable(
- // "dbo.vwOrderSendBill",
- // c => new
- // {
- // OrderSendId = c.Int(nullable: false, identity: true),
- // OrderItemId = c.Int(nullable: false),
- // SendDate = c.DateTime(),
- // SendQuantity = c.Decimal(precision: 18, scale: 2),
- // Remark = c.String(),
- // OrderSendBillNo = c.String(),
- // OrderStickBillNo = c.String(),
- // StatementBillNo = c.String(),
- // UserIDLastMod = c.String(),
- // OrderNo = c.String(),
- // ProductNo = c.String(),
- // Price = c.Decimal(nullable: false, precision: 18, scale: 2),
- // totalprice = c.Decimal(nullable: false, precision: 18, scale: 2),
- // IsReport = c.String(),
- // PartNo = c.String(),
- // ProductName = c.String(),
- // Model = c.String(),
- // StandardId = c.Int(),
- // Material = c.String(),
- // ProductDesc = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // CustomerId = c.String(),
- // LinkName = c.String(),
- // OrderDate = c.DateTime(),
- // CustomerSendId = c.Int(nullable: false),
- // StockNo = c.String(),
- // OrderUnitName = c.String(),
- // CurrencyId = c.String(),
- // AfterTaxPrice = c.Decimal(nullable: false, precision: 18, scale: 2),
- // LogisticsFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFee = c.Decimal(nullable: false, precision: 18, scale: 2),
- // LogisticsFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // MoldFeeAfterTax = c.Decimal(nullable: false, precision: 18, scale: 2),
- // AfterTaxTotalprice = c.Decimal(nullable: false, precision: 18, scale: 2),
- // SendBillSort = c.Int(nullable: false),
- // StatementBillSort = c.Int(nullable: false),
- // })
- // .PrimaryKey(t => t.OrderSendId);
- //CreateTable(
- // "dbo.N_ViewPackageApply",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // PackageApplyNo = c.String(),
- // CurrentStoreHouseNo = c.String(),
- // ProductionOrderNo = c.String(),
- // SemiProductNo = c.String(),
- // ProductNo = c.String(),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // SourceStore = c.Int(nullable: false),
- // ApplyStatus = c.String(),
- // IsClose = c.Boolean(nullable: false),
- // ApplyDate = c.DateTime(),
- // Remark = c.String(),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(),
- // UserIDLastMod = c.String(),
- // ProcessingNum = c.Int(nullable: false),
- // IsApplyEnterQuantity = c.Decimal(precision: 18, scale: 2),
- // IsApplyEnterQuantity2 = c.Decimal(precision: 18, scale: 2),
- // KgWeight = c.Decimal(precision: 18, scale: 2),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewProductEnterStore",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(maxLength: 11),
- // PackageApplyNo = c.String(nullable: false),
- // PackageProductNo = c.String(maxLength: 32),
- // ProductNo = c.String(),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // ApplySourceType = c.Int(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // PackageSpecification = c.Decimal(nullable: false, precision: 18, scale: 2),
- // PackageCount = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ActualPackageCount = c.Decimal(nullable: false, precision: 18, scale: 2),
- // AuditUser = c.String(),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // Remark = c.String(),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(),
- // UserIDLastMod = c.String(),
- // ProductName = c.String(),
- // Model = c.String(maxLength: 20),
- // Material = c.String(maxLength: 50),
- // SurfaceColor = c.String(maxLength: 50),
- // Rigidity = c.String(maxLength: 50),
- // IsStandard = c.String(maxLength: 1),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
- // SourceStoreHouseId = c.Int(nullable: false),
- // CreateSourceType = c.Int(),
- // PackageEnterNum = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewProductOutStore",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(),
- // CurrentProductStoreHouseNo = c.String(),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(),
- // IsConfirm = c.Boolean(),
- // ProductNo = c.String(),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ApplyOutDate = c.DateTime(),
- // Remark = c.String(),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(),
- // UserIDLastMod = c.String(),
- // AuditUser = c.String(),
- // AuditDate = c.DateTime(),
- // ProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // IsStandard = c.String(),
- // CustomerId = c.String(),
- // CustomerName = c.String(),
- // OrderSendBillNo = c.String(),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ApplyOutStoreSourceType = c.Int(nullable: false),
- // CreateSourceType = c.Int(),
- // OrderDate = c.DateTime(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.v_QueryCurrentProductNum",
- // c => new
- // {
- // ProductNo = c.String(nullable: false, maxLength: 128),
- // BookedQuantity = c.Decimal(precision: 18, scale: 2),
- // CanUserQuantity = c.Decimal(precision: 18, scale: 2),
- // })
- // .PrimaryKey(t => t.ProductNo);
- //CreateTable(
- // "dbo.N_ViewRmEnterStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // RmProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 32),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // EnterStoreUser = c.String(maxLength: 32),
- // EnterStoreDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductName = c.String(),
- // Material = c.String(),
- // Model = c.String(),
- // ProductDesc = c.String(),
- // StoreHouseName = c.String(),
- // ProductBatchNum = c.String(),
- // CreateSourceType = c.Int(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewRmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewRmOutStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(maxLength: 11),
- // CurrentRmStoreHouseNo = c.String(maxLength: 32),
- // RmProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // IsConfirm = c.Boolean(),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 150),
- // AuditDate = c.DateTime(),
- // OutStoreUser = c.String(maxLength: 150),
- // OutStoreDate = c.DateTime(),
- // ApplyOutDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductName = c.String(),
- // Material = c.String(),
- // Model = c.String(),
- // ProductDesc = c.String(),
- // StoreHouseName = c.String(),
- // ProductBatchNum = c.String(),
- // CreateSourceType = c.Int(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewRmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewScrapEnterStore",
- // c => new
- // {
- // Id = c.String(nullable: false, maxLength: 128),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // ProductNo = c.String(maxLength: 50),
- // StoreHouseId = c.Int(nullable: false),
- // StoreLocationNo = c.String(maxLength: 32),
- // ApplyStatus = c.Int(nullable: false),
- // IsClose = c.Boolean(nullable: false),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
- // AuditUser = c.String(maxLength: 32),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // EnterStoreUser = c.String(maxLength: 32),
- // EnterStoreDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // ProductName = c.String(),
- // Material = c.String(),
- // Model = c.String(),
- // ProductDesc = c.String(),
- // StoreHouseName = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // ProductType = c.Int(),
- // ScrapSource = c.Int(nullable: false),
- // ScrapSourceNo = c.String(),
- // IsDeleted = c.Boolean(nullable: false),
- // DeleterUserId = c.Long(),
- // DeletionTime = c.DateTime(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // },
- // annotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewSemiEnterStore",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.String(nullable: false, maxLength: 1),
- // IsClose = c.Boolean(),
- // ApplySource = c.String(nullable: false, maxLength: 1),
- // SemiProductNo = c.String(maxLength: 32),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // AuditUser = c.String(maxLength: 20),
- // AuditDate = c.DateTime(),
- // ApplyEnterDate = c.DateTime(),
- // Remark = c.String(maxLength: 150),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(maxLength: 20),
- // UserIDLastMod = c.String(maxLength: 20),
- // SemiProductName = c.String(maxLength: 50),
- // Model = c.String(maxLength: 20),
- // Material = c.String(maxLength: 50),
- // SurfaceColor = c.String(maxLength: 50),
- // Rigidity = c.String(maxLength: 50),
- // IsStandard = c.String(maxLength: 1),
- // PartNo = c.String(maxLength: 50),
- // TranUnitValue = c.Decimal(precision: 18, scale: 2),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
- // CreateSourceType = c.Int(),
- // StoreLocationNo = c.String(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewSemiOutStore",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // ProductionOrderNo = c.String(),
- // CurrentSemiStoreHouseNo = c.String(),
- // StoreHouseId = c.Int(nullable: false),
- // ApplyStatus = c.String(),
- // ApplyTypes = c.Int(nullable: false),
- // IsClose = c.Boolean(),
- // IsConfirm = c.Boolean(),
- // ApplyOutStoreSource = c.String(),
- // SemiProductNo = c.String(),
- // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
- // ApplyOutDate = c.DateTime(),
- // Remark = c.String(),
- // TimeCreated = c.DateTime(),
- // TimeLastMod = c.DateTime(),
- // CreatorUserId = c.String(),
- // UserIDLastMod = c.String(),
- // AuditUser = c.String(),
- // AuditDate = c.DateTime(),
- // SemiProductName = c.String(),
- // Model = c.String(),
- // Material = c.String(),
- // SurfaceColor = c.String(),
- // Rigidity = c.String(),
- // IsStandard = c.String(),
- // PartNo = c.String(),
- // TranUnitValue = c.Decimal(precision: 18, scale: 2),
- // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 2),
- // CreateSourceType = c.Int(),
- // })
- // .PrimaryKey(t => t.Id);
- //CreateTable(
- // "dbo.N_ViewStatementBill",
- // c => new
- // {
- // Id = c.Int(nullable: false, identity: true),
- // StatementBillNo = c.String(nullable: false, maxLength: 30),
- // CustomerId = c.String(nullable: false, maxLength: 30),
- // BillMan = c.String(maxLength: 20),
- // Description = c.String(maxLength: 4000),
- // StatementState = c.Int(),
- // CustomerName = c.String(),
- // OrderStickBillNo = c.String(),
- // TotalPrice = c.Decimal(precision: 18, scale: 3),
- // AfterTaxTotalPrice = c.Decimal(precision: 18, scale: 3),
- // CurrencyId = c.String(),
- // LastModificationTime = c.DateTime(),
- // LastModifierUserId = c.Long(),
- // CreationTime = c.DateTime(nullable: false),
- // CreatorUserId = c.Long(),
- // })
- // .PrimaryKey(t => t.Id)
- // .Index(t => t.StatementBillNo, unique: true);
- //CreateTable(
- // "dbo.v_OrderStickBill",
- // c => new
- // {
- // OrderStickBillNo = c.String(nullable: false, maxLength: 128),
- // CustomerId = c.String(),
- // CreatDate = c.DateTime(),
- // StickNum = c.String(),
- // StickMan = c.String(),
- // Description = c.String(),
- // TimeCreated = c.DateTime(),
- // CustomerName = c.String(),
- // Address = c.String(),
- // LinkMan = c.String(),
- // TotalPrice = c.Decimal(precision: 18, scale: 3),
- // AfterTaxTotalPrice = c.Decimal(precision: 18, scale: 3),
- // CurrencyId = c.String(),
- // InvoiceState = c.Int(),
- // Amount = c.Decimal(precision: 18, scale: 2),
- // OriginalStickNum = c.String(),
- // ReturnOrderNo = c.String(),
- // OrderNo = c.String(),
- // InvoiceType = c.Int(nullable: false),
- // })
- // .PrimaryKey(t => t.OrderStickBillNo);
- }
- public override void Down()
- {
- //DropForeignKey("dbo.Sys_States", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_States", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_States", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Settings", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Settings", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Settings", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.ScrapTypeInfo", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.ScrapTypeInfo", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.ScrapTypeInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Roles", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Roles", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Roles", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.QualityIssueLabelInfo", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.QualityIssueLabelInfo", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.QualityIssueLabelInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.ProductionOrderLogInfo", "EmployeeId", "dbo.EmployeeInfo");
- //DropForeignKey("dbo.ProductionOrderLogInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.MoldProductionRecord", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.MoldProductionRecord", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.MoldInfo", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.MoldInfo", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.MoldInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.MaintenanceRecordInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.MaintenanceMemberInfo", "EmployeeId", "dbo.EmployeeInfo");
- //DropForeignKey("dbo.MaintenanceMemberInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.LicenseTypeInfo", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.LicenseTypeInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.LicenseDocumentInfo", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.LicenseDocumentInfo", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.LicenseDocumentInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Functions", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Functions", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Functions", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.FixedAssetTypeInfo", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.FixedAssetTypeInfo", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.FixedAssetTypeInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.FixedAssetInfo", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.FixedAssetInfo", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.FixedAssetInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.ExpressProviderMappers", "ProviderId", "dbo.ExpressServiceProviders");
- //DropForeignKey("dbo.ExpressProviderMappers", "ExpressId", "dbo.ExpressLogistics");
- //DropForeignKey("dbo.EmployeeWorkPerformanceInfo", "EmployeeId", "dbo.EmployeeInfo");
- //DropForeignKey("dbo.EmployeeWorkPerformanceInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.EmployeeInfo", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.EmployeeInfo", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.EmployeeInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.DisqualifiedProductInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.DeviceMgPlanInfo", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.DeviceMgPlanInfo", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.DeviceMgPlanInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.CustomerDisProductInfo", "CreatorUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_UserRoles", "UserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Users", "LastModifierUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Users", "DeleterUserId", "dbo.Sys_Users");
- //DropForeignKey("dbo.Sys_Users", "CreatorUserId", "dbo.Sys_Users");
- //DropIndex("dbo.N_ViewStatementBill", new[] { "StatementBillNo" });
- //DropIndex("dbo.Sys_States", new[] { "CreatorUserId" });
- //DropIndex("dbo.Sys_States", new[] { "LastModifierUserId" });
- //DropIndex("dbo.Sys_States", new[] { "DeleterUserId" });
- //DropIndex("dbo.StatementBill", new[] { "StatementBillNo" });
- //DropIndex("dbo.Sys_Settings", new[] { "CreatorUserId" });
- //DropIndex("dbo.Sys_Settings", new[] { "LastModifierUserId" });
- //DropIndex("dbo.Sys_Settings", new[] { "DeleterUserId" });
- //DropIndex("dbo.ScrapTypeInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.ScrapTypeInfo", new[] { "LastModifierUserId" });
- //DropIndex("dbo.ScrapTypeInfo", new[] { "DeleterUserId" });
- //DropIndex("dbo.Sys_Roles", new[] { "CreatorUserId" });
- //DropIndex("dbo.Sys_Roles", new[] { "LastModifierUserId" });
- //DropIndex("dbo.Sys_Roles", new[] { "DeleterUserId" });
- //DropIndex("dbo.ReturnGoodOrder", new[] { "ReturnOrderNo" });
- //DropIndex("dbo.QualityIssueLabelInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.QualityIssueLabelInfo", new[] { "LastModifierUserId" });
- //DropIndex("dbo.QualityIssueLabelInfo", new[] { "DeleterUserId" });
- //DropIndex("dbo.ProductionOrderLogInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.ProductionOrderLogInfo", new[] { "EmployeeId" });
- //DropIndex("dbo.MoldProductionRecord", new[] { "CreatorUserId" });
- //DropIndex("dbo.MoldProductionRecord", new[] { "LastModifierUserId" });
- //DropIndex("dbo.MoldInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.MoldInfo", new[] { "LastModifierUserId" });
- //DropIndex("dbo.MoldInfo", new[] { "DeleterUserId" });
- //DropIndex("dbo.MaintenanceRecordInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.MaintenanceMemberInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.MaintenanceMemberInfo", new[] { "EmployeeId" });
- //DropIndex("dbo.LicenseTypeInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.LicenseTypeInfo", new[] { "LastModifierUserId" });
- //DropIndex("dbo.LicenseDocumentInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.LicenseDocumentInfo", new[] { "LastModifierUserId" });
- //DropIndex("dbo.LicenseDocumentInfo", new[] { "DeleterUserId" });
- //DropIndex("dbo.Sys_Functions", new[] { "CreatorUserId" });
- //DropIndex("dbo.Sys_Functions", new[] { "LastModifierUserId" });
- //DropIndex("dbo.Sys_Functions", new[] { "DeleterUserId" });
- //DropIndex("dbo.FixedAssetTypeInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.FixedAssetTypeInfo", new[] { "LastModifierUserId" });
- //DropIndex("dbo.FixedAssetTypeInfo", new[] { "DeleterUserId" });
- //DropIndex("dbo.FixedAssetInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.FixedAssetInfo", new[] { "LastModifierUserId" });
- //DropIndex("dbo.FixedAssetInfo", new[] { "DeleterUserId" });
- //DropIndex("dbo.ExpressProviderMappers", new[] { "ProviderId" });
- //DropIndex("dbo.ExpressProviderMappers", new[] { "ExpressId" });
- //DropIndex("dbo.EmployeeWorkPerformanceInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.EmployeeWorkPerformanceInfo", new[] { "EmployeeId" });
- //DropIndex("dbo.EmployeeInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.EmployeeInfo", new[] { "LastModifierUserId" });
- //DropIndex("dbo.EmployeeInfo", new[] { "DeleterUserId" });
- //DropIndex("dbo.DisqualifiedProductInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.DeviceMgPlanInfo", new[] { "CreatorUserId" });
- //DropIndex("dbo.DeviceMgPlanInfo", new[] { "LastModifierUserId" });
- //DropIndex("dbo.DeviceMgPlanInfo", new[] { "DeleterUserId" });
- //DropIndex("dbo.Sys_UserRoles", new[] { "UserId" });
- //DropIndex("dbo.Sys_Users", new[] { "CreatorUserId" });
- //DropIndex("dbo.Sys_Users", new[] { "LastModifierUserId" });
- //DropIndex("dbo.Sys_Users", new[] { "DeleterUserId" });
- //DropIndex("dbo.CustomerDisProductInfo", new[] { "CreatorUserId" });
- //DropTable("dbo.v_OrderStickBill");
- //DropTable("dbo.N_ViewStatementBill");
- //DropTable("dbo.N_ViewSemiOutStore");
- //DropTable("dbo.N_ViewSemiEnterStore");
- //DropTable("dbo.N_ViewScrapEnterStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.N_ViewRmOutStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewRmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.N_ViewRmEnterStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewRmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.v_QueryCurrentProductNum");
- //DropTable("dbo.N_ViewProductOutStore");
- //DropTable("dbo.N_ViewProductEnterStore");
- //DropTable("dbo.N_ViewPackageApply");
- //DropTable("dbo.vwOrderSendBill");
- //DropTable("dbo.N_ViewOrderSends");
- //DropTable("dbo.v_OrderSendBill");
- //DropTable("dbo.N_ViewOrderItems");
- //DropTable("dbo.N_ViewInventoryCheckRecord_Semi");
- //DropTable("dbo.N_ViewInventoryCheckRecord_Product");
- //DropTable("dbo.v_EnterOutSemiProductStore");
- //DropTable("dbo.v_Store_Query");
- //DropTable("dbo.vEnterOutLogDetail_c");
- //DropTable("dbo.NV_ViewEmployeeInfo");
- //DropTable("dbo.N_ViewDisqualifiedReturn");
- //DropTable("dbo.N_ViewDisqualifiedProduction");
- //DropTable("dbo.v_customerstick");
- //DropTable("dbo.v_ProductStoreInfo");
- //DropTable("dbo.v_SemiProductStoreInfo");
- //DropTable("dbo.N_ViewCurrentSemiStoreHouse");
- //DropTable("dbo.N_ViewCurrentRmStoreHouse",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ViewCurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.N_ViewCurrentProductStoreHouse");
- //DropTable("dbo.v_CanProductStore");
- //DropTable("dbo.v_BookedProductNum");
- //DropTable("dbo.Sys_UserLogins");
- //DropTable("dbo.Sys_UserLoginLogs");
- //DropTable("dbo.TemplateInfos");
- //DropTable("dbo.Sys_States",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysState_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.Sys_Helps");
- //DropTable("dbo.Sys_AttachFiles");
- //DropTable("dbo.StoreHouse");
- //DropTable("dbo.StoreHouseLocation",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StoreHouseLocation_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.StatementBill");
- //DropTable("dbo.Standard");
- //DropTable("dbo.StandardDetail",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.StandardCatalog",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_StandardCatalog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ShortMsgDetail");
- //DropTable("dbo.ShortMessage");
- //DropTable("dbo.Sys_Settings",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysSetting_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.SemiProductStore");
- //DropTable("dbo.SemiProducts");
- //DropTable("dbo.SemiOutStores");
- //DropTable("dbo.SemiEnterStore");
- //DropTable("dbo.ScrapTypeInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ScrapType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ScrapEnterStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.N_ViewScheduleOrderSend");
- //DropTable("dbo.ScheduleOrderSend");
- //DropTable("dbo.Sys_Roles",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysRole_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.RmProduct",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.RmOutStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.RmEnterStore",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_RmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ReturnGoodOrder",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ReturnGoodOrder_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.Regions");
- //DropTable("dbo.QualityIssueLabelInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_QualityIssueLabel_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ProductInspectReportContents");
- //DropTable("dbo.Products");
- //DropTable("dbo.ProductProperties",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ProductProperty_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ProductOutStore");
- //DropTable("dbo.ProductMapper",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_ProductMapper_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.ProductionOrders");
- //DropTable("dbo.ProductionOrderLogInfo");
- //DropTable("dbo.ProductInspectReportInfos");
- //DropTable("dbo.ProductInspectInfos");
- //DropTable("dbo.Sys_Permissions");
- //DropTable("dbo.PackageApply");
- //DropTable("dbo.OutFactory");
- //DropTable("dbo.OrderUnit");
- //DropTable("dbo.OrderStickBills");
- //DropTable("dbo.OrderSend");
- //DropTable("dbo.OrderSendExceed");
- //DropTable("dbo.OrderSendBills");
- //DropTable("dbo.OrderProduction");
- //DropTable("dbo.OrderItems");
- //DropTable("dbo.OrderHeader");
- //DropTable("dbo.MoldProductionRecord");
- //DropTable("dbo.MoldInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_Mold_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.MaintenanceRecordInfo");
- //DropTable("dbo.MaintenanceMemberInfo");
- //DropTable("dbo.LicenseTypeInfo");
- //DropTable("dbo.LicenseDocumentInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_LicenseDocument_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.InventoryCheckRecord");
- //DropTable("dbo.InventoryCheck",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_InventoryCheckInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.Sys_Functions",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysFunction_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.FixedAssetTypeInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_FixedAssetType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.FixedAssetInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_FixedAsset_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.FinshedEnterStore");
- //DropTable("dbo.Factories");
- //DropTable("dbo.ExpressServiceProviders");
- //DropTable("dbo.ExpressProviderMappers");
- //DropTable("dbo.ExpressLogistics");
- //DropTable("dbo.EmployeeWorkPerformanceInfo");
- //DropTable("dbo.EmployeeInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_Employee_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.Dutys");
- //DropTable("dbo.DisqualifiedProductInfo");
- //DropTable("dbo.DeviceMgPlanInfo",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_DeviceMgPlan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.Departments");
- //DropTable("dbo.CustomerSend");
- //DropTable("dbo.Customers");
- //DropTable("dbo.CustomerInvoiceAddress",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_CustomerInvoiceAddress_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.Sys_UserRoles");
- //DropTable("dbo.Sys_Users",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_SysUser_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.CustomerDisProductInfo");
- //DropTable("dbo.CustomerDefaultProduct");
- //DropTable("dbo.CurrentSemiStoreHouse");
- //DropTable("dbo.CurrentRmStoreHouse",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_CurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.CurrentProductStoreHouse");
- //DropTable("dbo.CurrencyExchangeRate");
- //DropTable("dbo.Currency");
- //DropTable("dbo.BusinessLogs",
- // removedAnnotations: new Dictionary<string, object>
- // {
- // { "DynamicFilter_BusinessLog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
- // });
- //DropTable("dbo.BulletinInfo");
- //DropTable("dbo.BackUpCurrentSemiStoreHouse");
- //DropTable("dbo.Sys_AuditLogs");
- //DropTable("dbo.Sys_AppGuids");
- }
- }
- }
|