jsgkj/gkjsjy/trunk/WebContent/static/sql/oracle/table/update.sql

  
--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');


-- Alter table 
alter table GK_SHARE_JSJY_JYXKZ
  storage
  (
    next 8
  )
;
-- Add/modify columns 
alter table GK_SHARE_JSJY_JYXKZ add stype char(1);


-- Add/modify columns 
alter table GK_OPERATION_JSJY_JSJDBGFJ add fjlx VARCHAR2(40);
alter table GK_OPERATION_JSJY_JSJDBGFJ add wjlb VARCHAR2(40);
alter table GK_OPERATION_JSJY_JSJDBGFJ add wjh VARCHAR2(40);
alter table GK_OPERATION_JSJY_JSJDBGFJ add fjbz VARCHAR2(40);
alter table GK_OPERATION_JSJY_JSJDBGFJ add fbsj TIMESTAMP(6);
alter table GK_OPERATION_JSJY_JSJDBGFJ add fbdw VARCHAR2(100);
-- Add comments to the columns 
comment on column GK_OPERATION_JSJY_JSJDBGFJ.wjlb
  is '文件类别';
comment on column GK_OPERATION_JSJY_JSJDBGFJ.wjh
  is '文件号';
comment on column GK_OPERATION_JSJY_JSJDBGFJ.fjbz
  is '附件标识';
comment on column GK_OPERATION_JSJY_JSJDBGFJ.fbsj
  is '发布时间';
comment on column GK_OPERATION_JSJY_JSJDBGFJ.fbdw
  is '发布单位';
  
  
-- Add/modify columns 
alter table GK_BASIC_JSJY_JYR_BW add bwbh varchar2(10);
alter table GK_BASIC_JSJY_JYR_BW add ab varchar2(40);
alter table GK_BASIC_JSJY_JYR_BW add sfwygkghaxn varchar2(40);
alter table GK_BASIC_JSJY_JYR_BW add gkaxsyzh nvarchar2(400);
-- Add comments to the columns 
comment on column GK_BASIC_JSJY_JYR_BW.bwbh
  is '泊位编号';
comment on column GK_BASIC_JSJY_JYR_BW.ab
  is '岸别';
comment on column GK_BASIC_JSJY_JYR_BW.sfwygkghaxn
  is '是否位于港口规划岸线内';
comment on column GK_BASIC_JSJY_JYR_BW.gkaxsyzh
  is '港口岸线使用证号';