hbghj/gkaq/yjpt-java/trunk/resources/sql/init/9.update.sql.ftl

<#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;
  </#if>

--创建行政部门表 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';