1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756 |
-
- --update GK_BASIC_JSJY_JYR_BW t set t.ssjyr=(select jyr.id from yjptpro.t_yjpt_jyrxx_bw b,yjptpro.t_yjpt_jyrjcxx j,GK_BASIC_JSJY_JYR jyr where b.qymc=j.id and b.id = t.aqid and j.id=jyr.aqid) where t.ssjyr is null and t.aqid is not null;
- --为所有集成BaseEntity的实体类对应的数据表添加SFTB(是否同步)、TBZT(同步状态)二个字段
- ALTER TABLE GK_BASIC_JSJY_GK_AX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GK_AX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_AX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_AX."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_FJB
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_FJB
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_FJB."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_FJB."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_BIZ_LOG
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_BIZ_LOG
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_BIZ_LOG."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_BIZ_LOG."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR_BW
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR_BW
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_BW."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_BW."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR_DC
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR_DC
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_DC."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_DC."TBZT" IS '同步状态';
- ALTER TABLE GK_SHARE_DTYW_CBJBXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_SHARE_DTYW_CBJBXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_SHARE_DTYW_CBJBXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_SHARE_DTYW_CBJBXX."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR_CG
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR_CG
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_CG."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_CG."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR_CK
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR_CK
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_CK."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_CK."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_CODE
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_CODE
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_CODE."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_CODE."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_DCSB
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_DCSB
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSB."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSB."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GK_FBD
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GK_FBD
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_FBD."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_FBD."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_FUNC
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_FUNC
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_FUNC."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_FUNC."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_GGFWXX_TZGG
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_GGFWXX_TZGG
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TZGG."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TZGG."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_GGFWXX_FB
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_GGFWXX_FB
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_FB."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_FB."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GK_GK
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GK_GK
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_GK."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_GK."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GK_GQ
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GK_GQ
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_GQ."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_GQ."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_GKHS_CBZYWXHWSBD
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_GKHS_CBZYWXHWSBD
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_GKHS_CBZYWXHWSBD."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_GKHS_CBZYWXHWSBD."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_HXHBGL
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_HXHBGL
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_HXHBGL."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_HXHBGL."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GK_HDXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GK_HDXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_HDXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_HDXX."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_JOBINFO
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_JOBINFO
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_JOBINFO."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_JOBINFO."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GKJS_JSJDFJ
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GKJS_JSJDFJ
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GKJS_JSJDFJ."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GKJS_JSJDFJ."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GK_MD
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GK_MD
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_MD."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_MD."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_MENU
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_MENU
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_MENU."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_MENU."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR_MT
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR_MT
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_MT."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_MT."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_ORG
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_ORG
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_ORG."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_ORG."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR_QYTZ
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR_QYTZ
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_QYTZ."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_QYTZ."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_ROLE
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_ROLE
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_ROLE."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_ROLE."TBZT" IS '同步状态';
- ALTER TABLE GK_SHARE_JSJY_JYXKZ
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_SHARE_JSJY_JYXKZ
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_SHARE_JSJY_JYXKZ."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_SHARE_JSJY_JYXKZ."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR_RY
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR_RY
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_RY."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_RY."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR_RY_ZS
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR_RY_ZS
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_RY_ZS."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_RY_ZS."TBZT" IS '同步状态';
- ALTER TABLE GK_SHARE_JSJY_HS_SHIP_CARRIAGE
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_SHARE_JSJY_HS_SHIP_CARRIAGE
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_SHARE_JSJY_HS_SHIP_CARRIAGE."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_SHARE_JSJY_HS_SHIP_CARRIAGE."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_JYR_SSSB
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_JYR_SSSB
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_SSSB."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_JYR_SSSB."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_SYS_PARAM
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_SYS_PARAM
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_SYS_PARAM."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_SYS_PARAM."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_TASK
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_TASK
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_TASK."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_TASK."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GKJS_TZJH
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GKJS_TZJH
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GKJS_TZJH."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GKJS_TZJH."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_USER
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_USER
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_USER."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_USER."TBZT" IS '同步状态';
- ALTER TABLE GK_SHARE_JSJY_WHZYFZ
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_SHARE_JSJY_WHZYFZ
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_SHARE_JSJY_WHZYFZ."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_SHARE_JSJY_WHZYFZ."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZJYFWXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZJYFWXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZJYFWXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZJYFWXX."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZSQXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZSQXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZSQXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZSQXX."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZSQFJ
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZSQFJ
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZSQFJ."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZSQFJ."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZSQGLB
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZSQGLB
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZSQGLB."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZSQGLB."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZSQJDS
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZSQJDS
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZSQJDS."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZSQJDS."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZZXXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZZXXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZZXXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZZXXX."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZYXXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZYXXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZYXXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZYXXX."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZYXFJ
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZYXFJ
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZYXFJ."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZYXFJ."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZYXJDS
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZYXJDS
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZYXJDS."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZYXJDS."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZZXXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZZXXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZZXXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZZXXX."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZZXFJ
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZZXFJ
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZZXFJ."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZZXFJ."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZZXJDS
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZZXJDS
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZZXJDS."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZZXJDS."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GKJS_XMXXGL
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GKJS_XMXXGL
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GKJS_XMXXGL."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GKJS_XMXXGL."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GKJS_XMYJHXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GKJS_XMYJHXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GKJS_XMYJHXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GKJS_XMYJHXX."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_DWXX_XZGLBMXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_DWXX_XZGLBMXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_DWXX_XZGLBMXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_DWXX_XZGLBMXX."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_DWXX_XZGLRYXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_DWXX_XZGLRYXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_DWXX_XZGLRYXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_DWXX_XZGLRYXX."TBZT" IS '同步状态';
- ALTER TABLE GK_OPERATION_JSJY_XKZYWZLXX
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_OPERATION_JSJY_XKZYWZLXX
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZYWZLXX."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_XKZYWZLXX."TBZT" IS '同步状态';
- ALTER TABLE GK_BASIC_JSJY_GK_ZYQ
- ADD ("SFTB" CHAR(1) DEFAULT 'Y' NOT NULL);
- ALTER TABLE GK_BASIC_JSJY_GK_ZYQ
- ADD ("TBZT" CHAR(1) DEFAULT 'N' NOT NULL);
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_ZYQ."SFTB" IS '是否同步';
- COMMENT ON COLUMN GK_BASIC_JSJY_GK_ZYQ."TBZT" IS '同步状态';
- --2016-1-7
- --行政管理
- -- Add/modify columns
- alter table GK_BASIC_JSJY_DWXX_XZGLBMXX add address nvarchar2(200);
- alter table GK_BASIC_JSJY_DWXX_XZGLBMXX add email nvarchar2(100);
- alter table GK_BASIC_JSJY_DWXX_XZGLBMXX add lx nvarchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.address
- is '地址';
- comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.email
- is '电子邮箱';
- comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.lx
- is '类型';
-
- -- Add/modify columns
- alter table GK_BASIC_JSJY_DWXX_XZGLRYXX add phone varchar2(30);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.phone
- is '手机';
-
- --项目信息管理
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_XMXXGL rename column xmssdw to JSGM;
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.jsgm
- is '建设规模';
-
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB rename column xmssdw to JSGM;
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.jsgm
- is '建设规模';
-
- --建设进度附件表
- alter table GK_BASIC_JSJY_GKJS_JSJDFJ modify fjid VARCHAR2(40);
-
-
- --堆场
- alter table GK_BASIC_JSJY_JYR_DC add dclx nvarchar2(40);
- alter table GK_BASIC_JSJY_JYR_DC add mcmj number;
- alter table GK_BASIC_JSJY_JYR_DC add mcrl number;
- alter table GK_BASIC_JSJY_JYR_DC add ksdcmj number;
- alter table GK_BASIC_JSJY_JYR_DC add ksdcrl number;
- alter table GK_BASIC_JSJY_JYR_DC add lcxdcmj number;
- alter table GK_BASIC_JSJY_JYR_DC add lcxdcdcnl number;
- alter table GK_BASIC_JSJY_JYR_DC add czxdcmj number;
- alter table GK_BASIC_JSJY_JYR_DC add czxdcdcnl number;
- alter table GK_BASIC_JSJY_JYR_DC add xxdcmj number;
- alter table GK_BASIC_JSJY_JYR_DC add xxdcdcnl number;
- alter table GK_BASIC_JSJY_JYR_DC add qtdcmj number;
- alter table GK_BASIC_JSJY_JYR_DC add qtdcdcnl1 number;
- alter table GK_BASIC_JSJY_JYR_DC add qtdcdcnl2 number;
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_DC.dclx
- is '堆场类型';
- comment on column GK_BASIC_JSJY_JYR_DC.mcmj
- is '煤场面积平方米';
- comment on column GK_BASIC_JSJY_JYR_DC.mcrl
- is '煤场容量吨';
- comment on column GK_BASIC_JSJY_JYR_DC.ksdcmj
- is '矿石堆场面积平方米';
- comment on column GK_BASIC_JSJY_JYR_DC.ksdcrl
- is '矿石堆场容量吨';
- comment on column GK_BASIC_JSJY_JYR_DC.lcxdcmj
- is '冷藏箱堆场面积平方米';
- comment on column GK_BASIC_JSJY_JYR_DC.lcxdcdcnl
- is '冷藏箱堆场堆存能力teu';
- comment on column GK_BASIC_JSJY_JYR_DC.czxdcmj
- is '拆装箱堆场面积平方米';
- comment on column GK_BASIC_JSJY_JYR_DC.czxdcdcnl
- is '拆装箱堆场堆存能力teu';
- comment on column GK_BASIC_JSJY_JYR_DC.xxdcmj
- is '洗箱堆场面积平方米';
- comment on column GK_BASIC_JSJY_JYR_DC.xxdcdcnl
- is '洗箱堆场堆存能力teu';
- comment on column GK_BASIC_JSJY_JYR_DC.qtdcmj
- is '其他堆场面积平方米';
- comment on column GK_BASIC_JSJY_JYR_DC.qtdcdcnl1
- is '其他堆场堆存能力teu';
- comment on column GK_BASIC_JSJY_JYR_DC.qtdcdcnl2
- is '其他堆场堆存能力吨';
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_DC.jzxdcdcnl
- is '集装箱堆场堆存能力(TEU)';
-
- --设施设备
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_SSSB add bh nvarchar2(100);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_SSSB.bh
- is '检验报告(或证书)编号';
- --储罐
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_CG add sfwxpcg VARCHAR2(40);
- alter table GK_BASIC_JSJY_JYR_CG add ygrj NUMBER;
- alter table GK_BASIC_JSJY_JYR_CG add ygrl NUMBER;
- alter table GK_BASIC_JSJY_JYR_CG add ytcrj NUMBER;
- alter table GK_BASIC_JSJY_JYR_CG add ythgcgrj NUMBER;
- alter table GK_BASIC_JSJY_JYR_CG add lstcrj NUMBER;
- alter table GK_BASIC_JSJY_JYR_CG add sntcrj NUMBER;
- alter table GK_BASIC_JSJY_JYR_CG add qtscyckrj NUMBER;
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_CG.sfwxpcg
- is '是否危险品储罐';
- comment on column GK_BASIC_JSJY_JYR_CG.ygrj
- is '油罐容积立方米';
- comment on column GK_BASIC_JSJY_JYR_CG.ygrl
- is '油罐容量';
- comment on column GK_BASIC_JSJY_JYR_CG.ytcrj
- is '圆筒仓容积立方米';
- comment on column GK_BASIC_JSJY_JYR_CG.ythgcgrj
- is '液体化工储罐容积立方米';
- comment on column GK_BASIC_JSJY_JYR_CG.lstcrj
- is '粮食筒仓容积立方米';
- comment on column GK_BASIC_JSJY_JYR_CG.sntcrj
- is '水泥筒仓容积立方米';
- comment on column GK_BASIC_JSJY_JYR_CG.qtscyckrj
- is '其他生产用仓库容积立方米';
-
- --仓库
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_CK add cklx nvarchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_CK.cklx
- is '仓库类型';
- --航线航班
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_HXHBGL add year varchar2(10);
- alter table GK_OPERATION_JSJY_HXHBGL add month varchar2(10);
- -- Add comments to the columns
- comment on column GK_OPERATION_JSJY_HXHBGL.year
- is '年';
- comment on column GK_OPERATION_JSJY_HXHBGL.month
- is '月';
-
- --锚地
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GK_MD add xzhgh varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GK_MD.xzhgh
- is '现状或规划';
- --岸线
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GK_AX add axwzms nvarchar2(200);
- alter table GK_BASIC_JSJY_GK_AX add qdzby VARCHAR2(50);
- alter table GK_BASIC_JSJY_GK_AX add zdzby VARCHAR2(50);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GK_AX.axwzms
- is '岸线位置描述';
- comment on column GK_BASIC_JSJY_GK_AX.qdzby
- is '起点坐标Y';
- comment on column GK_BASIC_JSJY_GK_AX.zdzby
- is '重点坐标Y';
- --许可证
- -- Add/modify columns
- alter table GK_SHARE_JSJY_JYXKZ add szgk varchar2(40);
- alter table GK_SHARE_JSJY_JYXKZ add sfyx varchar2(10);
- -- Add comments to the columns
- comment on column GK_SHARE_JSJY_JYXKZ.szgk
- is '所在港口';
- comment on column GK_SHARE_JSJY_JYXKZ.sfyx
- is '是否有效';
- --2016-1-12
- --建设进度附件
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_JSJDFJ add fjlx varchar2(10);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.fjlx
- is '附件类型(普通附件和其他附件)';
-
- --2016-1-11
- alter table GK_BASIC_JSJY_GK_GQ add (gis_status char);
- comment on column GK_BASIC_JSJY_GK_GQ.gis_status is '1=未审核,2=审核中,3=审核通过(未同步),4=审核通过(已同步),5=审核通过(同步失败),6=审核未通过';
- alter table GK_BASIC_JSJY_JYR_MT add (gis_status char);
- comment on column GK_BASIC_JSJY_JYR_MT.gis_status is '1=未审核,2=审核中,3=审核通过(未同步),4=审核通过(已同步),5=审核通过(同步失败),6=审核未通过';
- alter table GK_BASIC_JSJY_JYR add (gis_status char);
- comment on column GK_BASIC_JSJY_JYR.gis_status is '1=未审核,2=审核中,3=审核通过(未同步),4=审核通过(已同步),5=审核通过(同步失败),6=审核未通过';
- alter table GK_BASIC_JSJY_JYR_BW add (gis_status char);
- comment on column GK_BASIC_JSJY_JYR_BW.gis_status is '1=未审核,2=审核中,3=审核通过(未同步),4=审核通过(已同步),5=审核通过(同步失败),6=审核未通过';
- alter table GK_BASIC_JSJY_GK_ZYQ add (gis_status char);
- comment on column GK_BASIC_JSJY_GK_ZYQ.gis_status is '1=未审核,2=审核中,3=审核通过(未同步),4=审核通过(已同步),5=审核通过(同步失败),6=审核未通过';
- alter table GK_BASIC_JSJY_GK_MD add (gis_status char);
- comment on column GK_BASIC_JSJY_GK_MD.gis_status is '1=未审核,2=审核中,3=审核通过(未同步),4=审核通过(已同步),5=审核通过(同步失败),6=审核未通过';
-
- --2016-1-25
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR add yjyrid VARCHAR2(40);
- alter table GK_BASIC_JSJY_JYR add bgid VARCHAR2(40);
- alter table GK_BASIC_JSJY_JYR add BGJYRID VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR.yjyrid
- is '原经营人id';
- comment on column GK_BASIC_JSJY_JYR.bgid
- is '变更id';
- comment on column GK_BASIC_JSJY_JYR.BGJYRID
- is '变更经营人id';
-
- --2016-1-25
- --建设进度副本表
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add SFTB CHAR(1);
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add TBZT CHAR(1);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.SFTB
- is '是否同步';
- comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.TBZT
- is '同步状态';
-
- ---- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_BW add ybwid VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_BW.ybwid
- is '原泊位id';
-
- ---- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_MT add ymtid VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_MT.ymtid
- is '原码头id';
-
- ---- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_CG add ycgid VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_CG.ycgid
- is '原储罐id';
-
- ---- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_CK add yckid VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_CK.yckid
- is '原仓库id';
-
- ---- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_DC add ydcid VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_DC.ydcid
- is '原堆场id';
-
- ---- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_QYTZ add yqytzid VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_QYTZ.yqytzid
- is '原企业投资id';
-
- ---- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_SSSB add ysssbid VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_SSSB.ysssbid
- is '原设施设备id';
-
- ---- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_RY add yryid VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_RY.yryid
- is '原人员id';
-
- alter table GK_BASIC_JSJY_GK_GQ add orderid number;
- alter table GK_BASIC_JSJY_GK_GK add orderid number;
-
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_JSJDFJ add fjbz VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.fjbz
- is '附件标识';
-
- update GK_OPERATION_JSJY_XKZSQGLB t set t.record_status = 1 ;
- alter table GK_OPERATION_JSJY_XKZSQZSCS add tbzt char(1) default 'Y';
- alter table GK_OPERATION_JSJY_XKZSQZSCS add sftb CHAR(1) default 'N';
- --2016/1/29
- update GK_OPERATION_JSJY_FUNC set code = 'edit' where id ='402881ec50db2e730150db41b30f0048';
-
- --2016/2/16 单船申报
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_DCSB add sfg NVARCHAR2(200);
- alter table GK_OPERATION_JSJY_DCSB add mdg NVARCHAR2(200);
- -- Add comments to the columns
- comment on column GK_OPERATION_JSJY_DCSB.sfg
- is '始发港';
- comment on column GK_OPERATION_JSJY_DCSB.mdg
- is '目的港';
-
- --2016/2/17 投资计划管理
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_TZJH add sfyzjbz VARCHAR2(10);
- alter table GK_BASIC_JSJY_GKJS_TZJH add zybzzj NUMBER;
- alter table GK_BASIC_JSJY_GKJS_TZJH add sbzzj NUMBER;
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_TZJH.sfyzjbz
- is '是否有资金补助';
- comment on column GK_BASIC_JSJY_GKJS_TZJH.zybzzj
- is '中央补助资金';
- comment on column GK_BASIC_JSJY_GKJS_TZJH.sbzzj
- is '省补助资金';
-
- --2016/2/18 项目信息管理
- -- Drop columns
- alter table GK_BASIC_JSJY_GKJS_XMXXGL drop column mtwzzb;
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add sddx VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add sddy VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add xddx VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add xddy VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.sddx
- is '上端点X';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.sddy
- is '上端点Y';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.xddx
- is '下端点X';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.xddy
- is '下端点Y';
-
- --项目信息管理副本
- -- Drop columns
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB drop column mtwzzb;
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add sddx VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add sddy VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add xddx VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add xddy VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.sddx
- is '上端点X';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.sddy
- is '上端点Y';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.xddx
- is '下端点X';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.xddy
- is '下端点Y';
-
- -- Alter table
- alter table GK_OPERATION_JSJY_DCSB
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_DCSB add sfg nvarchar2(200);
- alter table GK_OPERATION_JSJY_DCSB add mdg nvarchar2(200);
- -- Add comments to the columns
- comment on column GK_OPERATION_JSJY_DCSB.sfg
- is '始发港';
- comment on column GK_OPERATION_JSJY_DCSB.mdg
- is '目的港';
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_MT
- storage
- (
- next 8
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_MT add xkzid varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_MT.xkzid
- is '许可证ID';
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_BW
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_BW add xkzid varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_BW.xkzid
- is '许可证id';
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_CG
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_CG add xkzid varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_CG.xkzid
- is '许可证ID';
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_CK
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_CK add xkzid varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_CK.xkzid
- is '许可证ID';
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_DC
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_DC add xkzid varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_DC.xkzid
- is '许可证ID';
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_RY
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_RY add xkzid varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_RY.xkzid
- is '许可证id';
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_SSSB
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_SSSB add xkzid varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_SSSB.xkzid
- is '许可证ID';
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_QYTZ
- storage
- (
- next 8
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_QYTZ add xkzid varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_QYTZ.xkzid
- is '许可证ID';
-
-
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_QYTZ
- storage
- (
- next 8
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_QYTZ add zczbdw varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_QYTZ.zczbdw
- is '注册资本单位';
-
-
-
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_ZXJX
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_ZXJX add yzxjxid varchar2(40);
- alter table GK_BASIC_JSJY_JYR_ZXJX add xkzid varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_ZXJX.yzxjxid
- is '原Id';
- comment on column GK_BASIC_JSJY_JYR_ZXJX.xkzid
- is '许可证ID';
-
-
- -- Alter table
- alter table GK_BASIC_JSJY_JYR_QYTZ
- storage
- (
- next 8
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_QYTZ modify record_status integer;
- --2016-2-25
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GK_GK add xzqh VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GK_GK.xzqh
- is '行政区划';
-
- -- Add/modify columns
- alter table GK_SHARE_JSJY_JYXKZ add sftb char(1) default 'Y';
- alter table GK_SHARE_JSJY_JYXKZ add tbzt char(1) default 'N';
- -- Add comments to the columns
- comment on column GK_SHARE_JSJY_JYXKZ.sftb
- is '是否同步';
- comment on column GK_SHARE_JSJY_JYXKZ.tbzt
- is '同步状态';
-
- --单船申报月报表2016.2.26
- CREATE TABLE GK_OPERATION_JSJY_DCSBYBB
- ( "ID" VARCHAR2(40 BYTE) NOT NULL ENABLE,
- "SZGK" VARCHAR2(40 BYTE),
- "SZGQ" VARCHAR2(40 BYTE),
- "SSJYR" VARCHAR2(40 BYTE),
- "BGSJ" TIMESTAMP (6),
- "HWZL" VARCHAR2(40 BYTE),
- "HUXS" VARCHAR2(40 BYTE),
- "ZYSL" NUMBER(*,0),
- "ZYSLXG" NUMBER(*,0),
- "ZYSLTEU" NUMBER(*,0),
- "ZYSLTEUXG" NUMBER(*,0),
- "JCG" NVARCHAR2(30),
- "NWM" VARCHAR2(40 BYTE),
- "MT" VARCHAR2(40 BYTE),
- "BW" VARCHAR2(40 BYTE),
- "CREATE_DATE_TIME" TIMESTAMP (0) DEFAULT current_timestamp,
- "UPDATE_DATE_TIME" TIMESTAMP (0) DEFAULT current_timestamp,
- "RECORD_STATUS" NUMBER(*,0) DEFAULT 1,
- "CREATE_USER" VARCHAR2(40 BYTE),
- "UPDATE_USER" VARCHAR2(40 BYTE),
- "SZD" VARCHAR2(40 BYTE),
- "SFTB" CHAR(1 BYTE) DEFAULT 'Y' NOT NULL ENABLE,
- "TBZT" CHAR(1 BYTE) DEFAULT 'N' NOT NULL ENABLE,
- PRIMARY KEY ("ID")
- )TABLESPACE "GK_OPERATION";
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.ID IS '主键';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.SZGK IS '所在港口';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.SZGQ IS '所在港区';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.SSJYR IS '所属于经营人';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.ZYSL IS '作业数量';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.ZYSLXG IS '修改后作业数量';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.ZYSLTEU IS '作业数量TEU';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.ZYSLTEUXG IS '修改后作业数量TEU';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.JCG IS '进出港';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.BGSJ IS '报告时间';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.NWM IS '内外贸';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.MT IS '码头';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.BW IS '泊位';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.HWZL IS '货物种类';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.HUXS IS '货物形式';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.CREATE_DATE_TIME IS '创建时间';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.UPDATE_DATE_TIME IS '修改时间';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.RECORD_STATUS IS '数据状态';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.CREATE_USER IS '创建人';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.UPDATE_USER IS '修改人';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.SZD IS '所在地';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.SFTB IS '是否同步';
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB.TBZT IS '同步状态';
- COMMENT ON TABLE GK_OPERATION_JSJY_DCSBYBB IS '单船申报月报表';
- --更新货物种类公共代码2016.2.26
- DELETE FROM GK_OPERATION_JSJY_CODE WHERE GROUP_CODE='HWZL';
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2501','25','集装箱','JZX','2501',1,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2502','25','煤炭及制品','MT','2501',2,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2503','25','石油、天然气及制品','SYTRQJZP','2503',3,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2504','25','原油','YY','2504',4,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2505','25','金属矿石','JSKS','2505',5,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2506','25','铁矿石','TKS','2506',6,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2507','25','钢铁','GT','2507',7,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2508','25','建筑材料','JZCL','2508',8,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2509','25','水泥','SN','2509',9,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2510','25','木材','MC','2510',10,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2511','25','非金属矿石','FJSKS','2511',11,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2512','25','化肥及农药','HFJNY','2512',12,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2513','25','盐','Y','2513',13,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2514','25','粮食','LS','2514',14,1,'1','1','HWZL');
- Insert into GK_OPERATION_JSJY_CODE (ID,PID,TEXT,CODE,VAL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,GROUP_CODE) values ('2515','25','其他','QT','2515',15,1,'1','1','HWZL');
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_XKZSQXX modify sqr NVARCHAR2(100);
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_XKZBGXX modify sqr NVARCHAR2(100);
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_XKZYXXX modify sqr nVARCHAR2(100);
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_XKZZXXX modify sqr nVARCHAR2(100);
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_SSSB add szzyq varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_SSSB.szzyq
- is '所在作业区';
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_RY_ZS add zszl varchar2(100);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_RY_ZS.zszl
- is '证书种类';
-
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_BW add hcnlxztj varchar2(100);
- alter table GK_BASIC_JSJY_JYR_BW add zls varchar2(40);
- alter table GK_BASIC_JSJY_JYR_BW add xp varchar2(40);
- alter table GK_BASIC_JSJY_JYR_BW add hwhc number;
- alter table GK_BASIC_JSJY_JYR_BW add hwgs number;
- alter table GK_BASIC_JSJY_JYR_BW add jzxhc number;
- alter table GK_BASIC_JSJY_JYR_BW add jzxgs number;
- alter table GK_BASIC_JSJY_JYR_BW add gzsj number;
- alter table GK_BASIC_JSJY_JYR_BW add gzhc number;
- alter table GK_BASIC_JSJY_JYR_BW add gzgs number;
- alter table GK_BASIC_JSJY_JYR_BW add lksj number;
- alter table GK_BASIC_JSJY_JYR_BW add lkhc number;
- alter table GK_BASIC_JSJY_JYR_BW add lkgs number;
- alter table GK_BASIC_JSJY_JYR_BW add bwgs number;
- alter table GK_BASIC_JSJY_JYR_BW add kbcblx varchar2(40);
- alter table GK_BASIC_JSJY_JYR_BW add bz varchar2(1000);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_BW.hcnlxztj
- is '核查能力限制条件';
- comment on column GK_BASIC_JSJY_JYR_BW.zls
- is '泊位型式_直立式子类别';
- comment on column GK_BASIC_JSJY_JYR_BW.xp
- is '泊位型式_斜坡子类别';
- comment on column GK_BASIC_JSJY_JYR_BW.hwhc
- is '货物核查年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.hwgs
- is '货物估算年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.jzxhc
- is '集装箱核查年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.jzxgs
- is '集装箱估算年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.gzsj
- is '滚装设计年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.gzhc
- is '滚装核查年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.gzgs
- is '滚装估算年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.lksj
- is '旅客设计年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.lkhc
- is '旅客核查年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.lkgs
- is '旅客估算年综合通过能力';
- comment on column GK_BASIC_JSJY_JYR_BW.bwgs
- is '泊位个数';
- comment on column GK_BASIC_JSJY_JYR_BW.kbcblx
- is '靠泊船舶类型';
- comment on column GK_BASIC_JSJY_JYR_BW.bz
- is '备注';
-
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_CK add szzyq varchar2(40);
- alter table GK_BASIC_JSJY_JYR_CK add ssbw varchar2(40);
- alter table GK_BASIC_JSJY_JYR_CK add kcsclx varchar2(40);
- alter table GK_BASIC_JSJY_JYR_CK add ckzmj Number;
- alter table GK_BASIC_JSJY_JYR_CK add ckrl Number;
- alter table GK_BASIC_JSJY_JYR_CK add ygrj Number;
- alter table GK_BASIC_JSJY_JYR_CK add ygrl Number;
- alter table GK_BASIC_JSJY_JYR_CK add ytcrj Number;
- alter table GK_BASIC_JSJY_JYR_CK add lstcrj Number;
- alter table GK_BASIC_JSJY_JYR_CK add sntcrj Number;
- alter table GK_BASIC_JSJY_JYR_CK add qtscyckrj Number;
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_CK.szzyq
- is '所在作业区';
- comment on column GK_BASIC_JSJY_JYR_CK.ssbw
- is '所属码头';
- comment on column GK_BASIC_JSJY_JYR_CK.kcsclx
- is '库场生产类型';
- comment on column GK_BASIC_JSJY_JYR_CK.ckzmj
- is '仓库总面积';
- comment on column GK_BASIC_JSJY_JYR_CK.ckrl
- is '仓库容量';
- comment on column GK_BASIC_JSJY_JYR_CK.ygrj
- is '油罐容积';
- comment on column GK_BASIC_JSJY_JYR_CK.ygrl
- is '油罐容量';
- comment on column GK_BASIC_JSJY_JYR_CK.ytcrj
- is '圆筒仓容积';
- comment on column GK_BASIC_JSJY_JYR_CK.lstcrj
- is '粮食筒仓容积';
- comment on column GK_BASIC_JSJY_JYR_CK.sntcrj
- is '水泥筒仓容积';
- comment on column GK_BASIC_JSJY_JYR_CK.qtscyckrj
- is '其他生产用仓库容积';
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_CG add cglx varchar2(40);
- alter table GK_BASIC_JSJY_JYR_CG add bz varchar2(1000);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_CG.cglx
- is '储罐类型';
- comment on column GK_BASIC_JSJY_JYR_CG.bz
- is '备注';
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_QYTZ add tzjedw varchar2(40);
- alter table GK_BASIC_JSJY_JYR_QYTZ add tzjjlx varchar2(40);
- alter table GK_BASIC_JSJY_JYR_QYTZ add je number;
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_QYTZ.tzjedw
- is '投资金额单位';
- comment on column GK_BASIC_JSJY_JYR_QYTZ.tzjjlx
- is '经济类型';
- comment on column GK_BASIC_JSJY_JYR_QYTZ.je
- is '投资金额';
- --单船申报月报表菜单
- INSERT INTO GK_OPERATION_JSJY_MENU (ID,PID,NAME,CODE,URL,SORTNO,RECORD_STATUS,CREATE_USER,UPDATE_USER,SZD,ICONCLS,LEAF,SFTB,TBZT) values ('91AD44DEE5424B0B822E09E2B4CC2EE2','402881ec50da5a350150da6747d10001','港口作业申报月报表','dcsbybb','/dcsbybb/main',4,1,'1','1',null,null,'Y','Y','N');
- INSERT INTO GK_OPERATION_JSJY_ROLE_MENU (RID, MID) VALUES ('8a819ef551806e3d0151847bf4fa0004', '91AD44DEE5424B0B822E09E2B4CC2EE2');
- INSERT INTO GK_OPERATION_JSJY_ROLE_MENU (RID, MID) VALUES ('40289e10528621e3015286294c700000', '91AD44DEE5424B0B822E09E2B4CC2EE2');
- INSERT INTO GK_OPERATION_JSJY_ROLE_MENU (RID, MID) VALUES ('402881a450a1b4e00150a1b5c1f60000', '91AD44DEE5424B0B822E09E2B4CC2EE2');
- INSERT INTO GK_OPERATION_JSJY_ROLE_MENU (RID, MID) VALUES ('8a819ef551806e3d0151847b2f990002', '91AD44DEE5424B0B822E09E2B4CC2EE2');
- INSERT INTO GK_OPERATION_JSJY_ROLE_MENU (RID, MID) VALUES ('8a819ef551806e3d0151847b959c0003', '91AD44DEE5424B0B822E09E2B4CC2EE2');
- INSERT INTO GK_OPERATION_JSJY_ROLE_MENU (RID, MID) VALUES ('8a819ef551806e3d0151847c476c0005', '91AD44DEE5424B0B822E09E2B4CC2EE2');
- INSERT INTO GK_OPERATION_JSJY_ROLE_MENU (RID, MID) VALUES ('8a819ef551806e3d0151847c935a0006', '91AD44DEE5424B0B822E09E2B4CC2EE2');
- alter table GK_OPERATION_JSJY_GGFWXX_FB add xzry varchar2(1000);
- comment on column GK_OPERATION_JSJY_GGFWXX_FB.xzry
- is '能看到公告的行政人员';
- --2016/3/7 项目信息管理、项目信息管理副本
- -- Alter table
- alter table GK_BASIC_JSJY_GKJS_XMXXGL
- storage
- (
- next 8
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add bwyt VARCHAR2(30);
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add zyhbwfl VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.bwyt
- is '泊位用途';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.zyhbwfl
- is '专业化泊位分类';
-
- -- Alter table
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB
- storage
- (
- next 8
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add bwyt VARCHAR2(30);
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add zyhbwfl VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.bwyt
- is '泊位用途';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.zyhbwfl
- is '专业化泊位分类';
-
- --监督提醒
- CREATE TABLE GK_OPERATION_JSJY_GGFWXX_JDTX
- ( "ID" VARCHAR2(40 BYTE) NOT NULL ENABLE,
- "CREATE_USER" VARCHAR2(40 BYTE),
- "UPDATE_USER" VARCHAR2(40 BYTE),
- "CREATE_DATE_TIME" TIMESTAMP (6),
- "UPDATE_DATE_TIME" TIMESTAMP (6),
- "RECORD_STATUS" NUMBER,
- "BT" VARCHAR2(100 BYTE),
- "NR" VARCHAR2(1000 BYTE),
- "TXR" VARCHAR2(100 BYTE),
- "TXSJ" TIMESTAMP (6),
- "SZD" VARCHAR2(40 BYTE),
- "SFTB" CHAR(1 BYTE) DEFAULT 'Y',
- "TBZT" CHAR(1 BYTE) DEFAULT 'N',
- PRIMARY KEY ("ID")
-
- )
- TABLESPACE "GK_OPERATION" ;
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.ID IS 'ID';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.CREATE_USER IS '创建人';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.UPDATE_USER IS '修改人';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.CREATE_DATE_TIME IS '创建时间';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.UPDATE_DATE_TIME IS '修改时间';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.RECORD_STATUS IS '数据状态';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.BT IS '标题';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.NR IS '内容';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.TXR IS '填写人';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.TXSJ IS '提醒时间';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.SZD IS '所在地';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.SFTB IS '是否同步';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_JDTX.TBZT IS '同步状态';
-
- --
-
- CREATE TABLE GK_OPERATION_JSJY_GGFWXX_TX
- ( "ID" VARCHAR2(40 BYTE) NOT NULL ENABLE,
- "JYR" VARCHAR2(1000 BYTE),
- "XZRY" VARCHAR2(1000 BYTE),
- "CREATE_USER" VARCHAR2(40 BYTE),
- "UPDATE_USER" VARCHAR2(40 BYTE),
- "CREATE_DATE_TIME" TIMESTAMP (6),
- "UPDATE_DATE_TIME" TIMESTAMP (6),
- "RECORD_STATUS" NUMBER,
- "SFTB" CHAR(1 BYTE) DEFAULT 'Y',
- "TBZT" CHAR(1 BYTE) DEFAULT 'N',
- "SZD" VARCHAR2(40 BYTE),
- "TX" VARCHAR2(40 BYTE),
- PRIMARY KEY ("ID")
-
- ) TABLESPACE "GK_OPERATION" ;
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.JYR IS '提醒经营人';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.XZRY IS '提醒行政人员';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.CREATE_USER IS '创建人';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.UPDATE_USER IS '修改人';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.CREATE_DATE_TIME IS '创建时间';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.UPDATE_DATE_TIME IS '修改时间';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.RECORD_STATUS IS '数据状态';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.SFTB IS '是否同步';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.TBZT IS '同步状态';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.SZD IS '所在地';
-
- COMMENT ON COLUMN GK_OPERATION_JSJY_GGFWXX_TX.TX IS '提醒id';
-
- alter table GK_BASIC_JSJY_JYR_DC add dczrlteu number;
- comment on column GK_BASIC_JSJY_JYR_DC.dczrlteu
- is '堆场总容量teu';
- --单船申报月报表,增加来源字段
- ALTER TABLE GK_OPERATION_JSJY_DCSBYBB
- ADD ("SOURCE" CHAR(1) DEFAULT '1' NOT NULL);
- COMMENT ON COLUMN GK_OPERATION_JSJY_DCSBYBB."SOURCE" IS '来源,1:导入,2:汇总,3,手动输入';
- --航线表
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_GGFWXX_HX rename column jyrmc to JYRID;
- alter table GK_OPERATION_JSJY_GGFWXX_HX add szgk VARCHAR2(40);
- alter table GK_OPERATION_JSJY_GGFWXX_HX add szgq VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_OPERATION_JSJY_GGFWXX_HX.szgk
- is '所在港口';
- comment on column GK_OPERATION_JSJY_GGFWXX_HX.szgq
- is '所在港区';
- -- Alter table
- alter table GK_SHARE_JSJY_JYXKZ
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_SHARE_JSJY_JYXKZ add zmpicid varchar2(40);
- alter table GK_SHARE_JSJY_JYXKZ add fmpicid varchar2(40);
- -- Alter table
- alter table GK_BASIC_JSJY_FJB
- storage
- (
- next 1
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_FJB modify filepath NVARCHAR2(1000);
- --单船申报月报表
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_DCSBYBB add bgr VARCHAR2(40);
- alter table GK_OPERATION_JSJY_DCSBYBB add sqsj VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_OPERATION_JSJY_DCSBYBB.bgr
- is '报告人';
- comment on column GK_OPERATION_JSJY_DCSBYBB.sqsj
- is '报告时间';
-
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_DCSBYBB modify zysl number;
- alter table GK_OPERATION_JSJY_DCSBYBB modify zyslxg number;
- alter table GK_OPERATION_JSJY_DCSBYBB modify zyslteu number;
- alter table GK_OPERATION_JSJY_DCSBYBB modify zyslteuxg number;
- alter table GK_BASIC_JSJY_JYR_SSSB modify tbr NVARCHAR2(100);
- --单船申报增加字段
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_DCSB add hwzldedl VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_OPERATION_JSJY_DCSB.hwzldedl
- is '货物种类第二大类';
- --单船申报月报表增加字段
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_DCSBYBB add hwzldedl VARCHAR2(40);
- -- Add comments to the columns
- comment on column GK_OPERATION_JSJY_DCSBYBB.hwzldedl
- is '货物种类第二大类';
- --2016/5/4 行政管理部门信息增加字段
- -- Add/modify columns
- alter table GK_BASIC_JSJY_DWXX_XZGLBMXX add leaf VARCHAR2(10);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.leaf
- is '是否末级';
-
- --2016/5/5 单船申报作业数量类型修改
- -- Add/modify columns
- alter table GK_OPERATION_JSJY_DCSB modify zysl number;
- --2016/5/9 项目信息管理,建设规模字段加大
- -- Alter table
- alter table GK_BASIC_JSJY_GKJS_XMXXGL
- storage
- (
- next 8
- )
- ;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_XMXXGL modify jsgm nVARCHAR2(200);
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR_BW add bwszhd varchar2(40);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR_BW.bwszhd
- is '泊位所在航道';
-
- -- Add/modify columns
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB modify jsgm nvarchar2(200);
- --经营人基本信息
- alter table GK_BASIC_JSJY_JYR add tzze2 VARCHAR2(100);
- alter table GK_BASIC_JSJY_JYR add zczb2 VARCHAR2(100);
- update GK_BASIC_JSJY_JYR t set t.zczb2=t.zczb , t.tzze2=t.tzze
- -- Drop columns
- alter table GK_BASIC_JSJY_JYR drop column tzze;
- alter table GK_BASIC_JSJY_JYR drop column zczb;
- -- Add/modify columns
- alter table GK_BASIC_JSJY_JYR rename column tzze2 to TZZE;
- alter table GK_BASIC_JSJY_JYR rename column zczb2 to ZCZB;
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_JYR.tzze
- is '投资总额';
- comment on column GK_BASIC_JSJY_JYR.zczb
- is '注册资本';
-
- -- 2016/6/1项目信息管理
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add lcjd VARCHAR2(40);
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.lcjd
- is '流程节点';
-
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add sfqswj VARCHAR2(20);
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.sfqswj
- is '是否缺失文件';
-
-
- alter table GK_SHARE_JSJY_JYXKZ add isflag char(1) default 1;
- comment on column GK_SHARE_JSJY_JYXKZ.isflag
- is '是否输入判断标志1为是';
-
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add xmbm VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add zftze number;
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add sylx VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add jcsj timestamp;
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.xmbm
- is '项目编码';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.zftze
- is '政府投资额';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.sylx
- is '水域类型';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.jcsj
- is '建成时间';
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add flowstatus CHAR(1);
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.flowstatus
- is '状态0,正常1.退回地市2完成';
-
- alter table GK_OPERATION_JSJY_TASK add sfth CHAR(1);
- alter table GK_BASIC_JSJY_GKJS_XMXXGL modify bwyt VARCHAR2(100);
- alter table GK_OPERATION_JSJY_JSJDCBSJ modify bwyt VARCHAR2(100);
- alter table GK_OPERATION_JSJY_JGSQ modify bwyt VARCHAR2(100);
- alter table GK_OPERATION_JSJY_JGBG modify bwyt VARCHAR2(100);
- alter table GK_OPERATION_JSJY_JGZX modify bwyt VARCHAR2(100);
- alter table GK_OPERATION_JSJY_JSJDBG modify bwyt VARCHAR2(100);
- alter table GK_OPERATION_JSJY_JSJDZX modify bwyt VARCHAR2(100);
- alter table GK_OPERATION_JSJY_DCSB modify bgr nVARCHAR2(100);
- alter table GK_OPERATION_JSJY_DCSBYBB modify bgr nVARCHAR2(100);
- alter table GK_BASIC_JSJY_GKJS_XMXXGL add xmgk NVARCHAR2(200);
- comment on column GK_BASIC_JSJY_GKJS_XMXXGL.xmgk
- is '项目概况';
- alter table GK_OPERATION_JSJY_JSJDCBSJ add xmgk NVARCHAR2(200);
- comment on column GK_OPERATION_JSJY_JSJDCBSJ.xmgk
- is '项目概况';
-
- alter table GK_OPERATION_JSJY_JSJDBG add xmgk NVARCHAR2(200);
- comment on column GK_OPERATION_JSJY_JSJDBG.xmgk
- is '项目概况';
- alter table GK_OPERATION_JSJY_JGBG add xmgk NVARCHAR2(200);
- comment on column GK_OPERATION_JSJY_JGBG.xmgk
- is '项目概况';
- alter table GK_OPERATION_JSJY_JGSQ add xmgk NVARCHAR2(200);
- alter table GK_OPERATION_JSJY_JGSQ add xmid VARCHAR2(40);
- alter table GK_OPERATION_JSJY_JSJDCBSJ add xmid VARCHAR2(40);
- alter table GK_OPERATION_JSJY_LHSQ add flowstatus CHAR(1);
- alter table GK_OPERATION_JSJY_LHSQ modify jydy nVARCHAR2(200);
- alter table GK_OPERATION_JSJY_LHBG add tyyy nvarchar2(400);
- alter table GK_SHARE_JSJY_JYXKZ add yxqq DATE;
- alter table GK_SHARE_JSJY_JYXKZ add opid VARCHAR2(40);
- comment on column GK_SHARE_JSJY_JYXKZ.yxqq
- is '有效期起';
- comment on column GK_SHARE_JSJY_JYXKZ.opid
- is '业务ID';
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB
- storage
- (
- next 8
- )
- ;
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add xmbm VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add zftze NUMBER;
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add sylx VARCHAR2(40);
- alter table GK_BASIC_JSJY_GKJS_XMXXGLFB add jcsj TIMESTAMP(6);
- -- Add comments to the columns
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.xmbm
- is '项目编码';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.zftze
- is '政府投资额';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.sylx
- is '水域类型';
- comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.jcsj
- is '建成时间';
- alter table GK_OPERATION_JSJY_JSJDCBSJFJ modify fjlx VARCHAR2(40);
-
- alter table GK_OPERATION_JSJY_JSJDBG add xmid varchar2(40);
-
- alter table GK_OPERATION_JSJY_LHBG add flowstatus char(1);
-
- alter table GK_OPERATION_JSJY_LHSQ modify jyrmc NVARCHAR2(200);
-
- alter table GK_OPERATION_JSJY_LHYX add flowstatus CHAR(1);
-
- comment on column GK_OPERATION_JSJY_LHBG.tyyy
- is '停业原因';
-
- alter table GK_OPERATION_JSJY_JSJDBGFJ
- add constraint GK_OPERATION_JSJY_JSJDBGFJ primary key (ID);
- alter table GK_OPERATION_JSJY_LHBG
- add constraint GK_OPERATION_JSJY_LHBG_PK primary key (ID);
- alter table GK_OPERATION_JSJY_LHBGFJ
- add constraint GK_OPERATION_JSJY_LHBGFJ_PK primary key (ID);
- alter table GK_OPERATION_JSJY_LHYX
- add constraint GK_OPERATION_JSJY_LHYX_PK primary key (ID);
- alter table GK_OPERATION_JSJY_LHYXFJ
- add constraint GK_OPERATION_JSJY_LHYXFJ_PK primary key (ID);
-
- insert into GK_OPERATION_JSJY_CODE (ID, PID, TEXT, CODE, VAL, SORTNO, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, GROUP_CODE, BZ, YJPTID, SFTB, TBZT)
- values ('2205', '22', '其它', 'QTQT', '2205', 5, '20-9月 -16 06.44.02 下午', '20-9月 -16 06.44.02 下午', 1, null, null, null, 'XMLX', null, null, 'Y', 'N');
- insert into GK_OPERATION_JSJY_CODE (ID, PID, TEXT, CODE, VAL, SORTNO, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, CREATE_USER, UPDATE_USER, SZD, GROUP_CODE, BZ, YJPTID, SFTB, TBZT)
- values ('2204', '22', '技术改造', 'JSGZJSGZ', '2204', 4, '20-9月 -16 06.43.33 下午', '20-9月 -16 06.43.33 下午', 1, null, null, null, 'XMLX', null, null, 'Y', 'N');
|