<#if versionDate?date("yyyyMMdd") lt "20160308"?date("yyyyMMdd") > --安全检查表 create table T_YJPT_AQJC ( id NUMBER not null, szd NUMBER, szgq NUMBER, qymc NUMBER, jcdw VARCHAR2(100), jcsj TIMESTAMP(6), zzqk VARCHAR2(20), sbjy VARCHAR2(20), abss VARCHAR2(20), aqss VARCHAR2(20), zdjczgc VARCHAR2(20), qt VARCHAR2(400), czwt VARCHAR2(400), zgyj VARCHAR2(400), jcry VARCHAR2(100), bjcry VARCHAR2(100), add_user VARCHAR2(50), add_date TIMESTAMP(6), update_user VARCHAR2(50), update_date TIMESTAMP(6), record_status NUMBER default 0, sftb CHAR(1), tbzt CHAR(1), tbdyid NUMBER, qylb CHAR(1), ssqy NUMBER, record_code VARCHAR2(30), byzd1 VARCHAR2(100), byzd2 VARCHAR2(100), byzd3 VARCHAR2(100), byzd4 VARCHAR2(100), byzd5 VARCHAR2(100), ) ; comment on table T_YJPT_AQJC is '应急演练表'; comment on column T_YJPT_AQJC.id is '主键'; comment on column T_YJPT_AQJC.szd is '所在地'; comment on column T_YJPT_AQJC.szgq is '所在港区'; comment on column T_YJPT_AQJC.qymc is '企业名称'; comment on column T_YJPT_AQJC.jcdw is '检查单位'; comment on column T_YJPT_AQJC.jcsj is '检查时间'; comment on column T_YJPT_AQJC.zzqk is '资质情况'; comment on column T_YJPT_AQJC.sbjy is '设备检验'; comment on column T_YJPT_AQJC.abss is '安保设施'; comment on column T_YJPT_AQJC.aqss is '安全设施'; comment on column T_YJPT_AQJC.zdjczgc is '制度及操作规程执行情况'; comment on column T_YJPT_AQJC.qt is '其他'; comment on column T_YJPT_AQJC.czwt is '存在问题'; comment on column T_YJPT_AQJC.zgyj is '整改意见'; comment on column T_YJPT_AQJC.jcry is '检查人员'; comment on column T_YJPT_AQJC.bjcry is '被检查人员'; comment on column T_YJPT_AQJC.add_user is '创建人'; comment on column T_YJPT_AQJC.add_date is '创建时间'; comment on column T_YJPT_AQJC.update_user is '修改人'; comment on column T_YJPT_AQJC.update_date is '修改时间'; comment on column T_YJPT_AQJC.record_status is '删除状态'; comment on column T_YJPT_AQJC.sftb is '是否同步 Y或者N'; comment on column T_YJPT_AQJC.tbzt is '同步状态 已同步Y， 未同步N'; comment on column T_YJPT_AQJC.tbdyid is '同步对应ID'; comment on column T_YJPT_AQJC.qylb is '区域类别，省级还是市级'; comment on column T_YJPT_AQJC.ssqy is '所属区域，关联组织架构表的主键'; comment on column T_YJPT_AQJC.record_code is '记录代码'; comment on column T_YJPT_AQJC.byzd1 is '备用字段1'; comment on column T_YJPT_AQJC.byzd2 is '备用字段2'; comment on column T_YJPT_AQJC.byzd3 is '备用字段3'; comment on column T_YJPT_AQJC.byzd4 is '备用字段4'; comment on column T_YJPT_AQJC.byzd5 is '备用字段5'; alter table T_YJPT_AQJC add constraint T_YJPT_AQJC_PK primary key (ID); CREATE SEQUENCE SEQ_T_YJPT_AQJC MINVALUE 1 MAXVALUE 17000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE; ALTER TABLE T_YJPT_DC ADD SFXDTZS CHAR(1); COMMENT ON COLUMN T_YJPT_DC.SFXDTZS IS '是否下达通知'; ALTER TABLE T_YJPT_DC ADD TZSID NUMBER; COMMENT ON COLUMN T_YJPT_DC.TZSID IS '通知书ID'; Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (235,42,42,'btn.check2','check2',7,1,null,null,null,null,null,'0',null,null,null,null,null); Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (100235,42,100042,'btn.check2','check2',6,1,null,null,null,null,null,'0',null,null,null,null,null); insert into t_yjpt_role_button(role, button) select role,235 from t_yjpt_role_button where button=234; insert into t_yjpt_role_button(role, button) select role,100235 from t_yjpt_role_button where button=100233; --创建行政部门表 20160523 create table T_YJPT_GOV ( id NUMBER not null, code VARCHAR2(30), name VARCHAR2(50), remark VARCHAR2(200), add_user VARCHAR2(50), add_date TIMESTAMP(6), update_user VARCHAR2(50), update_date TIMESTAMP(6), record_status NUMBER default 0, sftb CHAR(1), tbzt CHAR(1), tbdyid NUMBER, qylb CHAR(1), ssqy NUMBER, record_code VARCHAR2(30), byzd1 VARCHAR2(100), byzd2 VARCHAR2(100), byzd3 VARCHAR2(100), byzd4 VARCHAR2(100), byzd5 VARCHAR2(100), SZD NUMBER ) ; comment on column T_YJPT_GOV.code is '角色编号'; comment on column T_YJPT_GOV.name is '角色名称'; comment on column T_YJPT_GOV.remark is '备注'; comment on column T_YJPT_GOV.add_user is '创建人'; comment on column T_YJPT_GOV.add_date is '创建时间'; comment on column T_YJPT_GOV.update_user is '修改人'; comment on column T_YJPT_GOV.update_date is '修改时间'; comment on column T_YJPT_GOV.record_status is '删除状态'; comment on column T_YJPT_GOV.sftb is '是否同步 Y或者N'; comment on column T_YJPT_GOV.tbzt is '同步状态 已同步Y， 未同步N'; comment on column T_YJPT_GOV.tbdyid is '同步对应ID'; comment on column T_YJPT_GOV.qylb is '区域类别，省级还是市级'; comment on column T_YJPT_GOV.ssqy is '所属区域，关联组织架构表的主键'; comment on column T_YJPT_GOV.record_code is '记录代码'; comment on column T_YJPT_GOV.byzd1 is '备用字段1'; comment on column T_YJPT_GOV.byzd2 is '备用字段2'; comment on column T_YJPT_GOV.byzd3 is '备用字段3'; comment on column T_YJPT_GOV.byzd4 is '备用字段4'; comment on column T_YJPT_GOV.byzd5 is '备用字段5'; alter table T_YJPT_GOV add constraint T_YJPT_GOV_PK primary key (ID); CREATE SEQUENCE SEQ_T_YJPT_GOV MINVALUE 1 MAXVALUE 17000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE; Insert into T_YJPT_MENU (SZD,ID,T_Y_ID,NAME,CODE,TYPE,PATH,PID,ORDER_NO,RECORD_STATUS,BRANCH,SFTB,TBZT,TBDYID,QYLB,SSQY,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (42,54,null,'m001017','001017','1','com.jtgh.yjpt.view.access.GovLayout',1001,5,1,'1',null,null,null,null,null,'0',null,null,null,null,'N'); Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (236,42,54,'btn.add','add',1,1,null,null,null,null,null,'0',null,null,null,null,null); Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (237,42,54,'btn.edit','edit',2,1,null,null,null,null,null,'0',null,null,null,null,null); Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (238,42,54,'btn.del','del',3,1,null,null,null,null,null,'0',null,null,null,null,null); Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (239,42,54,'btn.view','view',4,1,null,null,null,null,null,'0',null,null,null,null,null); --行政人员表 create table T_YJPT_XZRY ( id NUMBER not null, name VARCHAR2(100), add_user VARCHAR2(50), add_date TIMESTAMP(6), update_user VARCHAR2(50), update_date TIMESTAMP(6), record_status NUMBER default 0, sftb CHAR(1), tbzt CHAR(1), tbdyid NUMBER, qylb CHAR(1), ssqy NUMBER, lxdh VARCHAR2(400), cz VARCHAR2(400), yx VARCHAR2(400), bgdz VARCHAR2(400), record_code VARCHAR2(30), byzd1 VARCHAR2(100), byzd2 VARCHAR2(100), byzd3 VARCHAR2(100), byzd4 VARCHAR2(400), byzd5 VARCHAR2(400), birth DATE, sex VARCHAR2(2), political_landscape VARCHAR2(20), education VARCHAR2(20), SZD NUMBER ) ; comment on column T_YJPT_XZRY.name is '姓名'; comment on column T_YJPT_XZRY.add_user is '创建人'; comment on column T_YJPT_XZRY.add_date is '创建时间'; comment on column T_YJPT_XZRY.update_user is '修改人'; comment on column T_YJPT_XZRY.update_date is '修改时间'; comment on column T_YJPT_XZRY.record_status is '删除状态'; comment on column T_YJPT_XZRY.sftb is '是否同步 Y或者N'; comment on column T_YJPT_XZRY.tbzt is '同步状态 已同步Y， 未同步N'; comment on column T_YJPT_XZRY.tbdyid is '同步对应ID'; comment on column T_YJPT_XZRY.qylb is '区域类别，省级还是市级'; comment on column T_YJPT_XZRY.ssqy is '所属区域，关联组织架构表的主键'; comment on column T_YJPT_XZRY.lxdh is '联系电话'; comment on column T_YJPT_XZRY.cz is '传真'; comment on column T_YJPT_XZRY.yx is '邮箱'; comment on column T_YJPT_XZRY.bgdz is '办公地址'; alter table T_YJPT_XZRY add constraint T_YJPT_XZRY_PK primary key (ID); CREATE SEQUENCE SEQ_T_YJPT_XZRY MINVALUE 1 MAXVALUE 17000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE; Insert into T_YJPT_MENU (SZD,ID,T_Y_ID,NAME,CODE,TYPE,PATH,PID,ORDER_NO,RECORD_STATUS,BRANCH,SFTB,TBZT,TBDYID,QYLB,SSQY,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (42,55,null,'m001016','001016','1','com.jtgh.yjpt.view.access.XzryLayout',1001,4,1,'1',null,null,null,null,null,'0',null,null,null,null,'N'); Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (240,42,55,'btn.add','add',1,1,null,null,null,null,null,'0',null,null,null,null,null); Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (241,42,55,'btn.edit','edit',2,1,null,null,null,null,null,'0',null,null,null,null,null); Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (242,42,55,'btn.del','del',3,1,null,null,null,null,null,'0',null,null,null,null,null); Insert into T_YJPT_BUTTON (ID,SZD,MENU_ID,NAME,CODE,ORDER_NO,RECORD_STATUS,TBZT,TBDYID,QYLB,SSQY,SFTB,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (243,42,55,'btn.view','view',4,1,null,null,null,null,null,'0',null,null,null,null,null); --行政人员行政部门对于关系 create table T_YJPT_GOV_XZRY ( GOV NUMBER not null, XZRY NUMBER not null ) ; alter table T_YJPT_GOV_XZRY add constraint T_YJPT_GOV_XZRY_PK primary key (GOV, XZRY); --20160610 UPDATE T_YJPT_GKWXHWZYFZBLHHZ SET ZYFS=NULL; alter table T_YJPT_GKWXHWZYFZBLHHZ modify zyfs NUMBER; --20160610 ALTER TABLE T_YJPT_JSXMAQSC add lxjb char(1); ALTER TABLE T_YJPT_JSXMAQSC ADD LXDW VARCHAR2(100); --20160611建设项目附件 Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000345,null,'JSXMAQSC','FJLX',6,'T_YJPT_JSXMAQSC_FJ6',null,null,null,null,1,null,null,null,null,null,'6、预评价报告编制单位资质证书。 ',null,null,'0',null,null,null,null,null); --20160611 安全设施专篇审查 create table T_YJPT_AQSSZPSC ( id NUMBER not null, add_user VARCHAR2(50), add_date TIMESTAMP(6), update_user VARCHAR2(50), update_date TIMESTAMP(6), record_status NUMBER default 0, tbzt CHAR(1), tbdyid NUMBER, qylb CHAR(1), ssqy NUMBER, sftb CHAR(1), record_code VARCHAR2(30), byzd1 VARCHAR2(100), byzd2 VARCHAR2(100), byzd3 VARCHAR2(100), byzd4 VARCHAR2(100), byzd5 VARCHAR2(100), szd NUMBER, xmmc VARCHAR2(200), sqdw VARCHAR2(200), sqrq TIMESTAMP(6), fzr VARCHAR2(20), lb VARCHAR2(20), lxr VARCHAR2(20), dhhcz VARCHAR2(200), sqsx VARCHAR2(200), dwdz VARCHAR2(200), yb VARCHAR2(20), gcdz VARCHAR2(200), gcqsj TIMESTAMP(6), gczsj TIMESTAMP(6), gkjsaqssgk VARCHAR2(2000), zywxhwpm VARCHAR2(2000), szgq NUMBER, status VARCHAR2(20), bh VARCHAR2(20), gkjsdwmc VARCHAR2(200), jsdw NUMBER, pkj CHAR(1) ) ; comment on table T_YJPT_AQSSZPSC is '安全设施专项验收'; comment on column T_YJPT_AQSSZPSC.id is '主键'; comment on column T_YJPT_AQSSZPSC.add_user is '创建人'; comment on column T_YJPT_AQSSZPSC.add_date is '创建时间'; comment on column T_YJPT_AQSSZPSC.update_user is '修改人'; comment on column T_YJPT_AQSSZPSC.update_date is '修改时间'; comment on column T_YJPT_AQSSZPSC.record_status is '删除状态'; comment on column T_YJPT_AQSSZPSC.tbzt is '同步状态 已同步Y， 未同步N'; comment on column T_YJPT_AQSSZPSC.tbdyid is '同步对应ID'; comment on column T_YJPT_AQSSZPSC.qylb is '区域类别，省级还是市级'; comment on column T_YJPT_AQSSZPSC.ssqy is '所属区域，关联组织架构表的主键'; comment on column T_YJPT_AQSSZPSC.sftb is '是否同步'; comment on column T_YJPT_AQSSZPSC.szd is '所在地'; comment on column T_YJPT_AQSSZPSC.xmmc is '项目名称'; comment on column T_YJPT_AQSSZPSC.sqdw is '申请单位'; comment on column T_YJPT_AQSSZPSC.sqrq is '申请日期'; comment on column T_YJPT_AQSSZPSC.fzr is '负责人'; comment on column T_YJPT_AQSSZPSC.lb is '类别'; comment on column T_YJPT_AQSSZPSC.lxr is '联系人'; comment on column T_YJPT_AQSSZPSC.dhhcz is '电话和传真'; comment on column T_YJPT_AQSSZPSC.sqsx is '申请事项'; comment on column T_YJPT_AQSSZPSC.dwdz is '单位地址'; comment on column T_YJPT_AQSSZPSC.yb is '邮编'; comment on column T_YJPT_AQSSZPSC.gcdz is '工程地址'; comment on column T_YJPT_AQSSZPSC.gcqsj is '工程起时间'; comment on column T_YJPT_AQSSZPSC.gczsj is '工程止时间'; comment on column T_YJPT_AQSSZPSC.gkjsaqssgk is '港口建设安全设施概况'; comment on column T_YJPT_AQSSZPSC.zywxhwpm is '装卸、储存主要危险货物品名'; comment on column T_YJPT_AQSSZPSC.szgq is '所在港区'; comment on column T_YJPT_AQSSZPSC.bh is '编号'; comment on column T_YJPT_AQSSZPSC.gkjsdwmc is '港口建设单位名称'; comment on column T_YJPT_AQSSZPSC.jsdw is '建设单位'; comment on column T_YJPT_AQSSZPSC.pkj is '省级可见'; alter table T_YJPT_AQSSZPSC add constraint T_YJPT_AQSSZPSC_PK primary key (ID); CREATE SEQUENCE SEQ_T_YJPT_AQSSZPSC MINVALUE 1 MAXVALUE 17000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE; Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000330,null,'AQSSZPSC','FJLX',1,'T_YJPT_AQSSZPSC_FJ1',null,null,null,null,1,null,null,null,null,null,'1、港口建设项目安全条件审查申请书；',null,null,'0',null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000331,null,'AQSSZPSC','FJLX',2,'T_YJPT_AQSSZPSC_FJ2',null,null,null,null,1,null,null,null,null,null,'2、港口建设项目概况；',null,null,'0',null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000332,null,'AQSSZPSC','FJLX',3,'T_YJPT_AQSSZPSC_FJ3',null,null,null,null,1,null,null,null,null,null,'3、港口建设项目安全条件论证报告；',null,null,'0',null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000333,null,'AQSSZPSC','FJLX',4,'T_YJPT_AQSSZPSC_FJ4',null,null,null,null,1,null,null,null,null,null,'4、港口建设项目安全预评价报告；',null,null,'0',null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000334,null,'AQSSZPSC','FJLX',5,'T_YJPT_AQSSZPSC_FJ5',null,null,null,null,1,null,null,null,null,null,'5、工商行政管理部门颁发的企业营业执照或者企业名称预先核准通知书； ',null,null,'0',null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000335,null,'AQSSZPSC','FJLX',6,'T_YJPT_AQSSZPSC_FJ6',null,null,null,null,1,null,null,null,null,null,'6、预评价报告编制单位资质证书； ',null,null,'0',null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000336,null,'AQSSZPSC','FJLX',7,'T_YJPT_AQSSZPSC_FJ7',null,null,null,null,1,null,null,null,null,null,'7、专篇报告编制单位资质证书。 ',null,null,'0',null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000965,null,'WF_FJ_AQSSZPSC_ZJYJ',null,15,'AQSSZPSC_ZJYJ_CITY',null,null,null,null,1,null,null,null,null,null,'安全设施专篇验收-专家意见市级可见',null,null,null,null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000966,null,'WF_FJ_AQSSZPSC_ZJYJ',null,16,'AQSSZPSC_ZJYJ_JYR',null,null,null,null,1,null,null,null,null,null,'安全设施专篇验收-专家意见经营人可见',null,null,null,null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000967,null,'WF_FJ_AQSSZPSC_ZLSC',null,17,'AQSSZPSC_ZLSC',null,null,null,null,1,null,null,null,null,null,'安全设施专篇验收-资料审查',null,null,null,null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000968,null,'WF_FJ_AQSSZPSC_ZLSC',null,18,'AQSSZPSC_ZLSC_CITY',null,null,null,null,1,null,null,null,null,null,'安全设施专篇验收-资料审查',null,null,null,null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000969,null,'WF_FJ_AQSSZPSC_ZLSC',null,19,'AQSSZPSC_ZLSC_JYR',null,null,null,null,1,null,null,null,null,null,'安全设施专篇验收-资料审查',null,null,null,null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000970,null,'WF_FJ_AQSSZPSC_CITYSC',null,20,'AQSSZPSC_CITYSC',null,null,null,null,1,null,null,null,null,null,'安全设施专篇验收-市级审查',null,null,null,null,null,null,null,null); --作业方式 insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40001, null, 'FZ.ZYFS', 'ZYFS', 1, 'FZ.ZYFS1', null, null, null, null, 1, null, null, null, null, null, '船-管道', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40002, null, 'FZ.ZYFS', 'ZYFS', 2, 'FZ.ZYFS2', null, null, null, null, 1, null, null, null, null, null, '管道-船', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40003, null, 'FZ.ZYFS', 'ZYFS', 3, 'FZ.ZYFS3', null, null, null, null, 1, null, null, null, null, null, '船-管道-储罐', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40004, null, 'FZ.ZYFS', 'ZYFS', 4, 'FZ.ZYFS4', null, null, null, null, 1, null, null, null, null, null, '储罐-管道-船', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40005, null, 'FZ.ZYFS', 'ZYFS', 5, 'FZ.ZYFS5', null, null, null, null, 1, null, null, null, null, null, '船-堆场', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40006, null, 'FZ.ZYFS', 'ZYFS', 6, 'FZ.ZYFS6', null, null, null, null, 1, null, null, null, null, null, '堆场-船', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40007, null, 'FZ.ZYFS', 'ZYFS', 7, 'FZ.ZYFS7', null, null, null, null, 1, null, null, null, null, null, '船-船', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40008, null, 'FZ.ZYFS', 'ZYFS', 8, 'FZ.ZYFS8', null, null, null, null, 1, null, null, null, null, null, '火车-汽车', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40009, null, 'FZ.ZYFS', 'ZYFS', 9, 'FZ.ZYFS9', null, null, null, null, 1, null, null, null, null, null, '汽车-火车', null, null, '0', null, null, null, null, null); --公共代码 20160612 update T_YJPT_GGDM set bz='8.港口经营许可证书或临时经营许可证复印件;' where id=10000327; update T_YJPT_GGDM set bz='9.危险货物作业场所平面示意图;' where id=10000328; update T_YJPT_GGDM set bz='应急预案审查意见' where id=10000250; update T_YJPT_GGDM set bz='应急预案审查意见' where id=10000260; --督查隐患跟踪 20160612 create table T_YJPT_DCYHGZ ( id NUMBER NOT NULL , dcid NUMBER NOT NULL , rq DATE NULL , gzr VARCHAR2(100 ) , gzqk VARCHAR2(2000)， add_user VARCHAR2(50), add_date TIMESTAMP(6), update_user VARCHAR2(50), update_date TIMESTAMP(6), record_status NUMBER default 0, tbzt CHAR(1), tbdyid NUMBER, qylb CHAR(1), ssqy NUMBER, sftb CHAR(1), record_code VARCHAR2(30), byzd1 VARCHAR2(100), byzd2 VARCHAR2(100), byzd3 VARCHAR2(100), byzd4 VARCHAR2(100), byzd5 VARCHAR2(100), szd NUMBER ); comment on table T_YJPT_DCYHGZ is '隐患跟踪'; comment on column T_YJPT_DCYHGZ.id is '序列'; comment on column T_YJPT_DCYHGZ.dcid is '督查ID'; comment on column T_YJPT_DCYHGZ.rq is '日期'; comment on column T_YJPT_DCYHGZ.gzr is '跟踪人'; comment on column T_YJPT_DCYHGZ.gzqk is '跟踪情况'; comment on column T_YJPT_DCYHGZ.add_user is '创建人'; comment on column T_YJPT_DCYHGZ.add_date is '创建时间'; comment on column T_YJPT_DCYHGZ.update_user is '修改人'; comment on column T_YJPT_DCYHGZ.update_date is '修改时间'; comment on column T_YJPT_DCYHGZ.record_status is '删除状态'; comment on column T_YJPT_DCYHGZ.tbzt is '同步状态 已同步Y， 未同步N'; comment on column T_YJPT_DCYHGZ.tbdyid is '同步对应ID'; comment on column T_YJPT_DCYHGZ.qylb is '区域类别，省级还是市级'; comment on column T_YJPT_DCYHGZ.ssqy is '所属区域，关联组织架构表的主键'; comment on column T_YJPT_DCYHGZ.sftb is '是否同步'; comment on column T_YJPT_DCYHGZ.szd is '所在地'; comment on column T_YJPT_DCYHGZ.xmmc is '项目名称'; alter table T_YJPT_DCYHGZ add constraint T_YJPT_DCYHGZ_PK primary key (ID); CREATE SEQUENCE SEQ_T_YJPT_DCYHGZ MINVALUE 1 MAXVALUE 17000000000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE; --申报单作业方式 20160616 UPDATE T_YJPT_WXHWGKZYSBD SET zylx=''; alter table T_YJPT_WXHWGKZYSBD modify zylx NUMBER; INSERT INTO T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5, GISID) VALUES ('10000337', NULL, 'AQSSZPSC', 'FJLX', '8', 'T_YJPT_AQSSZPSC_FJ8', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '8、专篇报告编制单位资质证书。 ', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5, GISID) VALUES ('10000271', NULL, 'null', 'FJSSLX', '22', 'T_YJPT_AQSSZPSC', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5, GISID) VALUES ('10000272', NULL, 'null', 'FJSSLX', '35', 'T_YJPT_AQSSZPSC_WF_ZLSC', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5, GISID) VALUES ('10000273', NULL, 'null', 'FJSSLX', '35', 'T_YJPT_AQSSZPSCWF_ZJ', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5, GISID) VALUES ('10000274', NULL, 'null', 'FJSSLX', '35', 'T_YJPT_AQSSZPSC_WF_CITYSC', NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL); Insert into T_YJPT_NORULE(NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK)VALUES('AQSSZPSC','ZP','yyyyMM','-',4,'安全设施设计专篇编号，ZP-201603-0001'); UPDATE T_YJPT_WXHWGKZYSBD SET hzwxx=''; alter table T_YJPT_WXHWGKZYSBD modify hzwxx varchar2（100）; UPDATE T_YJPT_WXHWGKZYSBD SET wrlb=''; alter table T_YJPT_WXHWGKZYSBD modify wrlb varchar2（100）; delete from t_yjpt_ggdm where id=2202; --20160714 人员增加附件照片 Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (10000366,null,'null','FJSSLX',6,'T_YJPT_JYRDRYXX',null,null,null,null,1,null,null,null,null,null,'人员基本信息',null,null,'0',null,null,null,null,null); --20160718 隐患大类其他,中类其他 Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (11000037,null,'YHDL','C',3,'YHDL.QT',null,null,null,null,1,null,null,null,null,null,'其他',null,null,'0',null,null,null,null,null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (11300001,11000037,'YHZL','C01',1,'YHZL.QT',null,null,null,null,1,null,null,null,null,null,'其他',null,null,'0',null,null,null,null,null); --20160722 添加所在地帮助信息 Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200015,4201,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200016,4202,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200017,4203,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200018,4205,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200019,4206,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200020,4207,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200021,4208,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200022,4209,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200023,4210,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200024,4211,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200025,4212,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200026,4213,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200027,4228,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200028,429004,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200029,429005,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (11200030,429006,'HELP','HELP',1,'HELP',1,'如遇到问题，请联系：江苏省交通规划设计院 纪蓉 联系电话：025-88018888-7425，并请加入QQ群进行问题解答，群号：港口安全系统**港（ *********），谢谢！','0'); alter table T_YJPT_CG modify tbr varchar2(100); alter table T_YJPT_GKAQPJJGSQBAB modify tbr varchar2(100); alter table T_YJPT_GKSSSB modify tbr varchar2(100); alter table T_YJPT_QSK modify tbr varchar2(100); alter table T_YJPT_YJJYNLJBQK modify tbr varchar2(100); alter table T_YJPT_YJYL modify tbr varchar2(100); alter table T_YJPT_ZDSGYHPCZGBA modify tbr varchar2(100); alter table T_YJPT_GKSSSB modify tbr varchar2(100); alter table T_YJPT_QSK modify tbr varchar2(100); alter table T_YJPT_YJJYNLJBQK modify tbr varchar2(100); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40010, null, 'FZ.ZYFS', 'ZYFS', 10, 'FZ.ZYFS10', null, null, null, null, 1, null, null, null, null, null, '储罐-管道-汽车', null, null, '0', null, null, null, null, null); insert into T_YJPT_GGDM (ID, FID, GROUPCODE, CODE, PX, MC, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, SFTB, TBZT, TBDYID, QYLB, SSQY, BZ, SZD, GQ, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5) values (40011, null, 'FZ.ZYFS', 'ZYFS', 10, 'FZ.ZYFS11', null, null, null, null, 1, null, null, null, null, null, '汽车-管道-储罐', null, null, '0', null, null, null, null, null); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,ADD_USER,ADD_DATE,UPDATE_USER,UPDATE_DATE,RECORD_STATUS,SFTB,TBZT,TBDYID,QYLB,SSQY,BZ,SZD,GQ,RECORD_CODE,BYZD1,BYZD2,BYZD3,BYZD4,BYZD5) values (11023,10903,'SSFL.WZFL',null,5,'SSFL.YWRFZSS.SYWYL',null,null,null,null,1,null,null,null,null,null,'水用围油栏',null,null,'0','个',null,null,null,null); ALTER TABLE T_YJPT_USER ADD zs NUMBER; ALTER TABLE T_YJPT_JYRJCXX ADD zs NUMBER; --站所20160901 Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210021,421002,'ZS',4210021,'玉和坪所',1,'玉和坪所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210022,421002,'ZS',4210022,'柳林洲所',1,'柳林洲所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210023,421002,'ZS',4210023,'窑滂所',1,'窑滂所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210871,421087,'ZS',4210871,'松滋口港航所',1,'松滋口港航所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210872,421087,'ZS',4210872,'涴市所',1,'涴市所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210221,421022,'ZS',4210221,'斗湖堤所',1,'斗湖堤所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210231,421023,'ZS',4210231,'盐船套作业区',1,'盐船套作业区','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210232,421023,'ZS',4210232,'白螺作业区',1,'白螺作业区','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210831,421083,'ZS',4210831,'城区所',1,'城区所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4210832,421083,'ZS',4210832,'螺山所',1,'螺山所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4202011,420201,'ZS',4202011,'黄石港港航管理所',1,'黄石港港航管理所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4202012,420201,'ZS',4202012,'中心港港航管理所',1,'中心港港航管理所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4202013,420201,'ZS',4202013,'西塞港航管理所',1,'西塞港航管理所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4212211,421221,'ZS',4212211,'潘家湾港航管理所',1,'潘家湾港航管理所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4212212,421221,'ZS',4212212,'石矶头港航管理所',1,'石矶头港航管理所','0'); --20160907 Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4201011,420101,'ZS',4201011,'江南航务管理一所',1,'江南航务管理一所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4201012,420101,'ZS',4201012,'江南航务管理二所',1,'江南航务管理二所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4201013,420101,'ZS',4201013,'江南航务管理长江所',1,'江南航务管理长江所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4201014,420101,'ZS',4201014,'江北航务管理一所',1,'江北航务管理一所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4201015,420101,'ZS',4201015,'江北航务管理二所',1,'江北航务管理二所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4201016,420101,'ZS',4201016,'汉江航务管理一所',1,'汉江航务管理一所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4201017,420101,'ZS',4201017,'汉江航务管理二所',1,'汉江航务管理二所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4201018,420101,'ZS',4201018,'汉江航务管理舵落口所',1,'汉江航务管理舵落口所','0'); Insert into T_YJPT_GGDM (ID,FID,GROUPCODE,PX,MC,RECORD_STATUS,BZ,RECORD_CODE) values (4201019,420101,'ZS',4201019,'阳逻督查室',1,'阳逻督查室','0'); --更新用户和经营人资料 update T_YJPT_USER r set r.ZS=4201011 where r.SZD=420199; update T_YJPT_USER r set r.ZS=4201012 where r.SZD=420107; update T_YJPT_USER r set r.ZS=4201013 where r.SZD=420198; update T_YJPT_USER r set r.ZS=4201014 where r.SZD=420105; update T_YJPT_USER r set r.ZS=4201015 where r.SZD=420102; update T_YJPT_USER r set r.ZS=4201016 where r.SZD=420196; update T_YJPT_USER r set r.ZS=4201017 where r.SZD=420197; update T_YJPT_USER r set r.ZS=4201018 where r.SZD=420104; update T_YJPT_JYRJCXX j set j.ZS=4201011 where j.SZD=420199; update T_YJPT_JYRJCXX j set j.ZS=4201012 where j.SZD=420107; update T_YJPT_JYRJCXX j set j.ZS=4201013 where j.SZD=420198; update T_YJPT_JYRJCXX j set j.ZS=4201014 where j.SZD=420105; update T_YJPT_JYRJCXX j set j.ZS=4201015 where j.SZD=420102; update T_YJPT_JYRJCXX j set j.ZS=4201016 where j.SZD=420196; update T_YJPT_JYRJCXX j set j.ZS=4201017 where j.SZD=420197; update T_YJPT_JYRJCXX j set j.ZS=4201018 where j.SZD=420104; --港区数据所在水域修正 Alter table t_yjpt_gq modify gqszsylx varchar(10); --经营人的自动审批字段置为空 update t_yjpt_user u set u.byzd2="" where u.sfjyr='Y';