jsgkj/gkaq/yjpt-java/trunk/resources/sql/init/update-20141120.sql.ftl.bk

<#if versionDate?date("yyyyMMdd") lte "20140901"?date("yyyyMMdd")   >
-- 9月1日版本脚本语句 已整合
COMMENT ON COLUMN T_YJPT_LOG."LOG_RESULT" IS '返回结果，1：成功；0：失败';
CREATE SEQUENCE SEQ_T_YJPT_LOG;
TRUNCATE TABLE T_YJPT_LOG;
</#if>
<#if versionDate?date("yyyyMMdd") lte "20140919"?date("yyyyMMdd")   >
-- 9月16日版本脚本语句 已整合
INSERT INTO "T_YJPT_MENU" (ID, NAME, CODE, TYPE, PID, PATH, ORDER_NO, RECORD_STATUS, BRANCH, RECORD_CODE, BYZD5) VALUES ('51', 'm001013', '001013', '1', '1', 'com.jtgh.yjpt.view.access.LogLayout', '6', '1', '1', '0', 'N');
INSERT INTO T_YJPT_ROLE_MENU(role,menu) VALUES(1,51);
ALTER TABLE T_YJPT_GKWXHWZYFZBL_FZ MODIFY ("WXHWM" VARCHAR2(800 BYTE));
ALTER TABLE T_YJPT_WXHWGKZYSBD MODIFY ("BGR" VARCHAR2(40 BYTE));
UPDATE "T_YJPT_MENU" SET CODE = '005003_1_c' WHERE id=100036;
UPDATE "T_YJPT_MENU" SET PID = '101001' WHERE id=100006;
update T_YJPT_WXHWPMB set MCHSM='易燃液体，未另列明的。（硅酮）' WHERE ID=11148;
ALTER TABLE T_YJPT_JYRXX_BW MODIFY ("JTJGISDYIDH" VARCHAR2(40 BYTE));
</#if>
<#if versionDate?date("yyyyMMdd") lte "20140919"?date("yyyyMMdd")   >
-- 9月25日版本脚本语句 已整合
update t_yjpt_yjya set byzd1='1' where qymc is not null;
update t_yjpt_yjya set byzd1='2' where qymc is null;
INSERT INTO "T_YJPT_GGDM" (ID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE) VALUES ('11200014', 'HELP', 'REGIST', '1', 'REGIST', '1', '您的注册信息已经提交，请在一个工作日之后登录，如果无法登录，请联系镇江口岸和港口管理局陈俊。如有问题，请加入QQ群：港口安全系统镇江港（群号：138690803）进行询问解答。谢谢！', '0');
alter table T_YJPT_ZCYH add bz VARCHAR2(500);
comment on column T_YJPT_ZCYH.bz  is '备注';
alter table T_YJPT_ZCYH add wzgyy VARCHAR2(500);
comment on column T_YJPT_ZCYH.wzgyy  is '未整改原因';
alter table T_YJPT_ZCYH add yjffcs VARCHAR2(500);
comment on column T_YJPT_ZCYH.yjffcs  is '应急防范措施';
</#if>
<#if versionDate?date("yyyyMMdd") lte "20141009"?date("yyyyMMdd")   >
-- 已整合
update t_yjpt_jyrxx_bw set byzd5='Y';
update t_yjpt_cg set byzd5='Y';
update t_yjpt_jyrxx_dc set byzd5='Y';
update t_yjpt_jyrxx_ck set byzd5='Y';
ALTER TABLE T_YJPT_GKWXHWZYFZBLHHZ MODIFY ("BYZD5" VARCHAR2(2000 BYTE));
ALTER TABLE T_YJPT_GKWXHWZYFZBL_FZ MODIFY ("BYZD5" VARCHAR2(800 BYTE));
update T_YJPT_GKWXHWZYFZBLHHZ set BYZD5= zywxhwpm;
update T_YJPT_GKWXHWZYFZBL_FZ set BYZD5= wxhwm;
INSERT INTO "T_YJPT_MENU" (ID, NAME, CODE, TYPE, PID, PATH, ORDER_NO, RECORD_STATUS, BRANCH, RECORD_CODE, BYZD5) VALUES ('52', 'm001014', '001014', '1', '1', 'com.jtgh.yjpt.view.workflow.WFPropLayout', '8', '1', '1', '0', 'N');
INSERT INTO T_YJPT_ROLE_MENU(role,menu) VALUES(1,52);
</#if>
<#if versionDate?date("yyyyMMdd") lte "20141017"?date("yyyyMMdd")   >
-- 已整合
create table T_YJPT_GQNWXYDJBAB_FLOW
(
  id             NUMBER not null,
  gqnwxydjbab_id NUMBER not null,
  add_user       VARCHAR2(50),
  add_date       TIMESTAMP(6),
  update_user    VARCHAR2(50),
  update_date    TIMESTAMP(6),
  record_status  VARCHAR2(10),
  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)
);

create sequence SEQ_T_YJPT_GQNWXYDJBAB_FLOW
minvalue 1
maxvalue 1000000000
start with 1
increment by 1
cache 20;

alter table T_YJPT_GQNWXYDJBAB add sqhxly VARCHAR2(500);
comment on column T_YJPT_GQNWXYDJBAB.sqhxly
  is '申请核销理由';

insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,BZ,RECORD_STATUS) values (10001301,null,'JDHXPZDWXY','JDHXPZDWXY',1,'JDHXPZDWXY.FJ1','安全评估报告或安全评价报告',0); 
insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,BZ,RECORD_STATUS) values (10001302,null,'JDHXPZDWXY','JDHXPZDWXY',2,'JDHXPZDWXY.FJ2','港区内储存剧毒化学品和港口重大危险源登记备案表',0); 
insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,BZ,RECORD_STATUS) values (10001303,null,'JDHXPZDWXY','JDHXPZDWXY',3,'JDHXPZDWXY.FJ3','其他资料、文件',0); 
</#if>
<#if versionDate?date("yyyyMMdd") lte "20141101"?date("yyyyMMdd")   >
-- 已整合
ALTER TABLE T_YJPT_AQSSSBXXXX ADD (SZD NUMBER);
ALTER TABLE T_YJPT_BLOB ADD (SZD NUMBER);
ALTER TABLE T_YJPT_BUTTON ADD (SZD NUMBER);
ALTER TABLE T_YJPT_CCSJDWXHXPJBLHXNZB ADD (SZD NUMBER);
ALTER TABLE T_YJPT_DBRW ADD (SZD NUMBER);
ALTER TABLE T_YJPT_FJB ADD (SZD NUMBER);
ALTER TABLE T_YJPT_GG_VIEW ADD (SZD NUMBER);
ALTER TABLE T_YJPT_GKWXHWZYFZBL_FZ ADD (SZD NUMBER);
ALTER TABLE T_YJPT_GKXX_GKJTQK ADD (SZD NUMBER);
ALTER TABLE T_YJPT_GQNWXYDJBAB_FLOW ADD (SZD NUMBER);
ALTER TABLE T_YJPT_GZTX ADD (SZD NUMBER);
ALTER TABLE T_YJPT_JYRXX_NSB ADD (SZD NUMBER);
ALTER TABLE T_YJPT_JZYJJYDWRYHZ ADD (SZD NUMBER);
ALTER TABLE T_YJPT_LOG ADD (SZD NUMBER);
ALTER TABLE T_YJPT_MENU ADD (SZD NUMBER);
ALTER TABLE T_YJPT_MT ADD (SZD NUMBER);
ALTER TABLE T_YJPT_ROLE ADD (SZD NUMBER);
ALTER TABLE T_YJPT_RYQKHZ_ZS ADD (SZD NUMBER);
ALTER TABLE T_YJPT_SGALGL_WZDD ADD (SZD NUMBER);
ALTER TABLE T_YJPT_TASK ADD (SZD NUMBER);
ALTER TABLE T_YJPT_USER ADD (SZD NUMBER);
--CREATE TABLE T_YJPT_WF_PROP(ID NUMBER NOT NULL ENABLE,WF_KEY VARCHAR2(50 BYTE), WF_NAME VARCHAR2(50 BYTE), ACITIVTY VARCHAR2(50 BYTE),ACITIVTY_NAME VARCHAR2(100 BYTE), 
--NAME VARCHAR2(100 BYTE), VALUE VARCHAR2(100 BYTE), DISP VARCHAR2(200 BYTE), ADD_USER VARCHAR2(50 BYTE), ADD_DATE TIMESTAMP (6), UPDATE_USER VARCHAR2(50 BYTE), 
--UPDATE_DATE TIMESTAMP (6), RECORD_STATUS NUMBER DEFAULT 1, SFTB CHAR(1 BYTE), TBZT CHAR(1 BYTE), TBDYID NUMBER, QYLB CHAR(1 BYTE), SSQY NUMBER, 
--RECORD_CODE VARCHAR2(30 BYTE), BYZD1 VARCHAR2(100 BYTE), BYZD2 VARCHAR2(100 BYTE), BYZD3 VARCHAR2(100 BYTE), BYZD4 VARCHAR2(100 BYTE), 
--BYZD5 VARCHAR2(100 BYTE), SZD NUMBER, PRIMARY KEY (ID));
--COMMENT ON COLUMN T_YJPT_WF_PROP.ID IS 'ID';
--COMMENT ON COLUMN T_YJPT_WF_PROP.WF_KEY IS '流程主键';
--COMMENT ON COLUMN T_YJPT_WF_PROP.WF_NAME IS '流程名称';
--COMMENT ON COLUMN T_YJPT_WF_PROP.ACITIVTY IS '活动';
--COMMENT ON COLUMN T_YJPT_WF_PROP.ACITIVTY_NAME IS '活动名称';
--COMMENT ON COLUMN T_YJPT_WF_PROP.NAME IS '属性名称';
--COMMENT ON COLUMN T_YJPT_WF_PROP.VALUE IS '属性值';
--COMMENT ON COLUMN T_YJPT_WF_PROP.DISP IS '描述';
ALTER TABLE T_YJPT_WF_PROP ADD (SZD NUMBER);
ALTER TABLE T_YJPT_WXHWGKZYSBD_BG ADD (SZD NUMBER);
ALTER TABLE T_YJPT_YJJYZBXX ADD (SZD NUMBER);
ALTER TABLE T_YJPT_YJWZ_FLXX ADD (SZD NUMBER);
ALTER TABLE T_YJPT_ZCYH ADD (SZD NUMBER);
ALTER TABLE T_YJPT_ZYWXYS ADD (SZD NUMBER);
ALTER TABLE T_YJPT_ZYYJJYDWRYHZ ADD (SZD NUMBER);
ALTER TABLE T_QLYG_INF_APPLY ADD (SZD NUMBER);               
ALTER TABLE T_QLYG_INF_APPLY_PROCESS ADD (SZD NUMBER);       
ALTER TABLE T_QLYG_INF_APPLY_RESULT ADD (SZD NUMBER);        
ALTER TABLE T_QLYG_INF_SUPBACK ADD (SZD NUMBER);             
ALTER TABLE T_QLYG_MONITOR_ALERT ADD (SZD NUMBER);           
ALTER TABLE T_QLYG_MONITOR_SUPERVISE ADD (SZD NUMBER);       
ALTER TABLE T_QLYG_MONITOR_SUPERVISE_REPLY ADD (SZD NUMBER); 
ALTER TABLE T_QLYG_MONITOR_SUPERVISE_RES ADD (SZD NUMBER);   


UPDATE T_YJPT_AQSSSBXXXX SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_BLOB SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_BUTTON SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_CCSJDWXHXPJBLHXNZB SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_DBRW SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_FJB SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_GG_VIEW SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_GKWXHWZYFZBL_FZ SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_GKXX_GKJTQK SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_GQNWXYDJBAB_FLOW SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_GZTX SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_JYRXX_NSB SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_JZYJJYDWRYHZ SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_LOG SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_MENU SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_MT SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_ROLE SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_RYQKHZ_ZS SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_SGALGL_WZDD SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_TASK SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_USER SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_WF_PROP SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_WXHWGKZYSBD_BG SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_YJJYZBXX SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_YJWZ_FLXX SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_ZCYH SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_ZYWXYS SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_YJPT_ZYYJJYDWRYHZ SET SZD=${szdId} WHERE SZD IS NULL;
UPDATE T_QLYG_INF_APPLY SET SZD=${szdId} WHERE SZD IS NULL;               
UPDATE T_QLYG_INF_APPLY_PROCESS SET SZD=${szdId} WHERE SZD IS NULL;       
UPDATE T_QLYG_INF_APPLY_RESULT SET SZD=${szdId} WHERE SZD IS NULL;        
UPDATE T_QLYG_INF_SUPBACK SET SZD=${szdId} WHERE SZD IS NULL;             
UPDATE T_QLYG_MONITOR_ALERT SET SZD=${szdId} WHERE SZD IS NULL;           
UPDATE T_QLYG_MONITOR_SUPERVISE SET SZD=${szdId} WHERE SZD IS NULL;       
UPDATE T_QLYG_MONITOR_SUPERVISE_REPLY SET SZD=${szdId} WHERE SZD IS NULL; 
UPDATE T_QLYG_MONITOR_SUPERVISE_RES SET SZD=${szdId} WHERE SZD IS NULL;   


INSERT INTO "T_YJPT_GGDM" (ID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('900', 'SZD', '320000', '320000', 'SZD.JIANGSU', '1', '江苏省', '0', 'JS');
UPDATE T_YJPT_GGDM SET FID = 900 WHERE ID>90010 AND ID<90028;
</#if>
<#if versionDate?date("yyyyMMdd") lte "20141104"?date("yyyyMMdd")   >
--2014.11.3
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90012WHZYFZ','SZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90013WHZYFZ','LYGKG_FZSQ','yyyy','_',4,null);                                 
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90014WHZYFZ','NJKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90015WHZYFZ','NTKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90016WHZYFZ','WZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90017WHZYFZ','YZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90018WHZYFZ','TZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90019WHZYFZ','YCKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90020WHZYFZ','XZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90021WHZYFZ','CZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90022WHZYFZ','SQKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90023WHZYFZ','HAKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90024WHZYFZ','ZJNHKG_FZSQ','yyyy','_',4,null);                                
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90025WHZYFZ','NTNHKG_FZSQ','yyyy','_',4,null);                                
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90026WHZYFZ','LYGNHKG_FZSQ','yyyy','_',4,null);                               
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90027WHZYFZ','YCNHKG_FZSQ','yyyy','_',4,null);                                
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90012ZDWXYBA','SZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90013ZDWXYBA','LYGKG_ZDWXYBA','yyyy','_',4,null);                                 
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90014ZDWXYBA','NJKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90015ZDWXYBA','NTKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90016ZDWXYBA','WZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90017ZDWXYBA','YZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90018ZDWXYBA','TZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90019ZDWXYBA','YCKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90020ZDWXYBA','XZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90021ZDWXYBA','CZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90022ZDWXYBA','SQKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90023ZDWXYBA','HAKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90024ZDWXYBA','ZJNHKG_ZDWXYBA','yyyy','_',4,null);                                
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90025ZDWXYBA','NTNHKG_ZDWXYBA','yyyy','_',4,null);                                
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90026ZDWXYBA','LYGNHKG_ZDWXYBA','yyyy','_',4,null);                               
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90027ZDWXYBA','YCNHKG_ZDWXYBA','yyyy','_',4,null);                                

INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9001201', '90012', 'SZD', '321009', '320510', 'SZD.ZHANGJIAGANG', '1', '张家港', '0', 'ZJG');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9001202', '90012', 'SZD', '321009', '320520', 'SZD.TAICANG', '1', '太仓', '0', 'TC');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9001203', '90012', 'SZD', '321009', '320530', 'SZD.CHANGSHU', '1', '常熟', '0', 'CS');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9001204', '90012', 'SZD', '321009', '320505', 'SZD.SUZHOULOCAL', '1', '苏州本部', '0', 'SZ_0');

INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002301', '90023', 'SZD', '321105', '320810', 'SZD.LIANSHUI', '1', '涟水县', '0', 'LS');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002302', '90023', 'SZD', '321105', '320820', 'SZD.HUAIYIN', '1', '淮阴县', '0', 'HY');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002303', '90023', 'SZD', '321105', '320830', 'SZD.HUAIANQU', '1', '淮安区', '0', 'HAQ');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002304', '90023', 'SZD', '321105', '320840', 'SZD.HONGZE', '1', '洪泽县', '0', 'HZ');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002305', '90023', 'SZD', '321105', '320850', 'SZD.XUYU', '1', '盱眙县', '0', 'XY');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002306', '90023', 'SZD', '321105', '320860', 'SZD.JINHU', '1', '金湖县', '0', 'JH');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002307', '90023', 'SZD', '321105', '320805', 'SZD.HUAIANLOCAL', '1', '淮安本部', '0', 'HA_0');

<#if szdName == "苏州" || szdName == "省级">
--苏州港区
UPDATE T_YJPT_GQ SET SZD = 9001201 WHERE ID = 1000000001;
UPDATE T_YJPT_GQ SET SZD = 9001202 WHERE ID = 1000000002;
UPDATE T_YJPT_GQ SET SZD = 9001203 WHERE ID = 1000000003;
</#if>

<#if szdName == "淮安" || szdName == "省级">
-- 淮安港区
UPDATE T_YJPT_GQ SET SZD = 9002301 WHERE ID = 12000000001;
UPDATE T_YJPT_GQ SET SZD = 9002302 WHERE ID = 12000000002;
UPDATE T_YJPT_GQ SET SZD = 9002307 WHERE ID = 12000000003;
UPDATE T_YJPT_GQ SET SZD = 9002303 WHERE ID = 12000000004;
UPDATE T_YJPT_GQ SET SZD = 9002304 WHERE ID = 12000000005;
UPDATE T_YJPT_GQ SET SZD = 9002305 WHERE ID = 12000000006;
UPDATE T_YJPT_GQ SET SZD = 9002306 WHERE ID = 12000000007;
</#if>

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 (1010005,1010000,'yjwlType','lz',5,'yjwl.type.lz',null,null,null,null,1,null,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 (1010006,1010000,'yjwlType','hb',6,'yjwl.type.hb',null,null,null,null,1,null,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 (1010007,1010000,'yjwlType','sj',7,'yjwl.type.sj',null,null,null,null,1,null,null,null,null,null,null,null,null,'0',null,null,null,null,null);
</#if>


<#if versionDate?date("yyyyMMdd") lte "20141105"?date("yyyyMMdd")   >
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002001', '90020', 'SZD', '321101', '320310', 'SZD.TONGSHANXIAN', '1', '铜山县', '0', 'TSX');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002002', '90020', 'SZD', '321101', '320320', 'SZD.FENGXIAN', '1', '丰县', '0', 'FX');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002003', '90020', 'SZD', '321101', '320330', 'SZD.PEIXIAN', '1', '沛县', '0', 'PX');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002004', '90020', 'SZD', '321101', '320340', 'SZD.PIZHOU', '1', '邳州', '0', 'PZ');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002005', '90020', 'SZD', '321101', '320350', 'SZD.XINYI', '1', '新沂', '0', 'XY');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002006', '90020', 'SZD', '321101', '320360', 'SZD.SUINING', '1', '睢宁', '0', 'SN');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002007', '90020', 'SZD', '321101', '320370', 'SZD.JIAWANGQU', '1', '贾汪区', '0', 'JWQ');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002008', '90020', 'SZD', '321101', '320380', 'SZD.XUZHOULOCAL', '1', '徐州本部', '0', 'XZ_0');

<#if szdName == "徐州" || szdName == "省级">
-- 徐州港区
UPDATE T_YJPT_GQ SET SZD = 9002001,GQMC='徐州港区-铜山县' WHERE ID = 9000000001;
UPDATE T_YJPT_GQ SET SZD = 9002002 WHERE ID = 9000000002;
UPDATE T_YJPT_GQ SET SZD = 9002003 WHERE ID = 9000000003;
UPDATE T_YJPT_GQ SET SZD = 9002004 WHERE ID = 9000000004;
UPDATE T_YJPT_GQ SET SZD = 9002005 WHERE ID = 9000000005;
UPDATE T_YJPT_GQ SET SZD = 9002006 WHERE ID = 9000000006;
INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('9000000007', '9002007', '徐州港区-贾汪区', '2201');
INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('9000000008', '9002008', '徐州港区', '2201');
</#if>

--2015.11.6

INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002101', '90021', 'SZD', '321005', '320410', 'SZD.CHANGZHOULOCAL', '1', '常州本部', '0', 'CZ_0');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002102', '90021', 'SZD', '321005', '320420', 'SZD.WUJIN', '1', '武进', '0', 'WJ');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002103', '90021', 'SZD', '321005', '320430', 'SZD.JINTAN', '1', '金坛', '0', 'JT');
INSERT INTO "T_YJPT_GGDM" (ID, FID, GROUPCODE, CODE, PX, MC, RECORD_STATUS, BZ, RECORD_CODE, BYZD1) VALUES ('9002104', '90021', 'SZD', '321005', '320440', 'SZD.LIYANG', '1', '溧阳', '0', 'LY');

<#if szdName == "常州" || szdName == "省级">
-- 常州港区
--DELETE FROM T_YJPT_GQ;
INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('10000000001', '9002101', '夹江港区', '2203');
INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('10000000002', '9002101', '录安洲港区', '2203');
INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('10000000003', '9002101', '圩塘港区', '2203');
INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('10000000004', '9002101', '市区港区', '2201');
INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('10000000005', '9002102', '武进港区', '2201');
INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('10000000006', '9002103', '金坛港区', '2201');
INSERT INTO "T_YJPT_GQ" (ID, SZD, GQMC, GQSZSYLX) VALUES ('10000000007', '9002104', '溧阳港区', '2201');
</#if>

INSERT INTO "T_YJPT_BUTTON" (ID, SZD,MENU_ID, NAME, CODE, ORDER_NO, RECORD_STATUS, RECORD_CODE) VALUES ('50001749',${szdId}, '100018', 'btn.count', 'statistics', '5', '1', '0');

INSERT INTO "T_YJPT_ROLE_BUTTON" (ROLE, BUTTON) VALUES ('2', '50001749');
INSERT INTO "T_YJPT_ROLE_BUTTON" (ROLE, BUTTON) VALUES ('5', '50001749');
-- add by lz
insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,BZ,RECORD_STATUS) values (80106,'','WXYDJ','',1,'WXYDJ1','一级',0); 
insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,BZ,RECORD_STATUS) values (80107,'','WXYDJ','',2,'WXYDJ2','二级',0); 
insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,BZ,RECORD_STATUS) values (80108,'','WXYDJ','',3,'WXYDJ3','三级',0); 
insert into T_YJPT_GGDM (ID,FID,GROUPCODE,CODE,PX,MC,BZ,RECORD_STATUS) values (80109,'','WXYDJ','',4,'WXYDJ4','四级',0); 

alter table T_YJPT_CG add wxydj number;
comment on column T_YJPT_CG.wxydj  is '危险源等级';
</#if>
<#if versionDate?date("yyyyMMdd") lte "20141114"?date("yyyyMMdd")   >
--2014.11.12
ALTER TABLE T_YJPT_USER MODIFY ("NAME" VARCHAR2(60 BYTE));

UPDATE T_YJPT_GGDM SET BYZD2=ID WHERE GROUPCODE ='SZD' AND BYZD1 NOT LIKE '%_0';
UPDATE T_YJPT_GGDM SET BYZD2=FID WHERE GROUPCODE ='SZD' AND BYZD1 LIKE '%_0';

UPDATE T_YJPT_USER SET SZD=9001204 WHERE SZD=90012 AND UPPER(CODE) NOT LIKE '%ADMIN%';
UPDATE T_YJPT_USER SET SZD=9002307 WHERE SZD=90023 AND UPPER(CODE) NOT LIKE '%ADMIN%';
UPDATE T_YJPT_USER SET SZD=9002101 WHERE SZD=90021 AND UPPER(CODE) NOT LIKE '%ADMIN%';
UPDATE T_YJPT_USER SET SZD=9002008 WHERE SZD=90020 AND UPPER(CODE) NOT LIKE '%ADMIN%';

--2014.11.13
ALTER TABLE T_YJPT_GKSSSB MODIFY ("SSMC" VARCHAR2(80 BYTE));

</#if>
<#if versionDate?date("yyyyMMdd") lte "20141120"?date("yyyyMMdd")   >
--2014.11.17
ALTER TABLE T_YJPT_RYQKHZ_ZS MODIFY ("ZSMC" VARCHAR2(100 BYTE));
ALTER TABLE T_YJPT_GKSSSB MODIFY ("GGXH" VARCHAR2(100 BYTE));
ALTER TABLE T_YJPT_GKWXHWZYFZBL_FZ MODIFY ("WXHWM" VARCHAR2(1000 BYTE));
--2014.11.17  by  liangzan
insert into T_YJPT_BUTTON (ID, MENU_ID, NAME, CODE, ORDER_NO, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, TBZT, TBDYID, QYLB, SSQY, SFTB, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5, SZD)
values (100233, 100042, 'btn.check', 'check', 5, null, null, null, null, 1, null, null, null, null, null, '0', null, null, null, null, null, null);
insert into T_YJPT_BUTTON (ID, MENU_ID, NAME, CODE, ORDER_NO, ADD_USER, ADD_DATE, UPDATE_USER, UPDATE_DATE, RECORD_STATUS, TBZT, TBDYID, QYLB, SSQY, SFTB, RECORD_CODE, BYZD1, BYZD2, BYZD3, BYZD4, BYZD5, SZD)
values (234, 42, 'btn.check', 'check', 6, null, null, null, null, 1, null, null, null, null, null, '0', null, null, null, null, null, null);
alter table T_YJPT_DC add jcyj number;
comment on column T_YJPT_DC.jcyj is '检查依据  关联公告id';
--2014.11.18 by liangzan
create table T_YJPT_DCZXJC
(
  id            NUMBER not null,
  ggmc          VARCHAR2(100),
  ggnr          VARCHAR2(2000),
  ggid          NUMBER,
  yhs           NUMBER,
  zgs           NUMBER,
  zgl           VARCHAR2(30),
  zgzj          NUMBER,
  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 table T_YJPT_DCZXJC
  is '专项检查';
-- Add comments to the columns 
comment on column T_YJPT_DCZXJC.id
  is 'ID';
comment on column T_YJPT_DCZXJC.ggmc
  is '公告名称';
comment on column T_YJPT_DCZXJC.ggnr
  is '公告内容';
comment on column T_YJPT_DCZXJC.ggid
  is '公告id';
comment on column T_YJPT_DCZXJC.yhs
  is '隐患数';
comment on column T_YJPT_DCZXJC.zgs
  is '整改数';
comment on column T_YJPT_DCZXJC.zgl
  is '整改率';
comment on column T_YJPT_DCZXJC.zgzj
  is '整改资金';
comment on column T_YJPT_DCZXJC.add_user
  is 'ADD_USER';
comment on column T_YJPT_DCZXJC.add_date
  is 'ADD_DATE';
comment on column T_YJPT_DCZXJC.update_user
  is 'UPDATE_USER';
comment on column T_YJPT_DCZXJC.update_date
  is 'UPDATE_DATE';
comment on column T_YJPT_DCZXJC.record_status
  is 'RECORD_STATUS';
comment on column T_YJPT_DCZXJC.sftb
  is 'SFTB';
comment on column T_YJPT_DCZXJC.tbzt
  is 'TBZT';
comment on column T_YJPT_DCZXJC.tbdyid
  is 'TBDYID';
comment on column T_YJPT_DCZXJC.qylb
  is 'QYLB';
comment on column T_YJPT_DCZXJC.ssqy
  is 'SSQY';
comment on column T_YJPT_DCZXJC.record_code
  is 'RECORD_CODE';
comment on column T_YJPT_DCZXJC.byzd1
  is 'BYZD1';
comment on column T_YJPT_DCZXJC.byzd2
  is 'BYZD2';
comment on column T_YJPT_DCZXJC.byzd3
  is 'BYZD3';
comment on column T_YJPT_DCZXJC.byzd4
  is 'BYZD4';
comment on column T_YJPT_DCZXJC.byzd5
  is 'BYZD5';
alter table T_YJPT_DCZXJC
  add constraint T_YJPT_DCZXJC primary key (ID);
alter table T_YJPT_DC add zxjcid number;
comment on column T_YJPT_DC.zxjcid  is '专项检查id';

--2014.11.19
ALTER TABLE T_YJPT_CG MODIFY ("LXDH" VARCHAR2(40 BYTE));
UPDATE T_YJPT_GQ SET GQMC='徐州港区-铜山区' WHERE ID=9000000001;
</#if>

--2014.11.25
CREATE SEQUENCE SEQ_T_YJPT_DCZXJC MINVALUE ${seqMinvalue} MAXVALUE ${seqMaxvalue} INCREMENT BY 1 START WITH ${seqStartCacheWith} CACHE ${seqCache} NOORDER NOCYCLE;
--2014.11.27
alter table T_YJPT_DCZXJC drop column yhs;
alter table T_YJPT_DCZXJC drop column zgs;
alter table T_YJPT_DCZXJC drop column zgl;
alter table T_YJPT_DCZXJC drop column zgzj;

--2014.12.02  by liangzan 
-- Add/modify columns 
alter table T_YJPT_WXHWGKZYSBD add hzwxx number;
alter table T_YJPT_WXHWGKZYSBD add dxdj number;
alter table T_YJPT_WXHWGKZYSBD add wrlb number;
alter table T_YJPT_WXHWGKZYSBD add mao varchar2(10);
-- Add comments to the columns 
comment on column T_YJPT_WXHWGKZYSBD.hzwxx
  is '火灾危险性';
comment on column T_YJPT_WXHWGKZYSBD.dxdj
  is '毒性等级';
comment on column T_YJPT_WXHWGKZYSBD.wrlb
  is '污染类别';
comment on column T_YJPT_WXHWGKZYSBD.mao
  is '内贸外贸';
  -- Add/modify columns 
alter table T_YJPT_WXHWPMB add hzwxx NUMBER;
alter table T_YJPT_WXHWPMB add dxdj NUMBER;
alter table T_YJPT_WXHWPMB add wrlb NUMBER;
-- Add comments to the columns 
comment on column T_YJPT_WXHWPMB.hzwxx
  is '火灾危险性';
comment on column T_YJPT_WXHWPMB.dxdj
  is '毒性等级';
comment on column T_YJPT_WXHWPMB.wrlb
  is '污染类别';
  
  --2014.12.03 by liangzan 
  
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 (20000, null, 'DXDJ', 'DXDJ', 1, 'DXDJ1', 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 (20001, null, 'DXDJ', 'DXDJ', 2, 'DXDJ2', 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 (20002, null, 'WRLB', 'WRLB', 1, 'WRLB1', null, null, null, null, 1, null, null, null, null, null, 'Z', 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 (20003, null, 'WRLB', 'WRLB', 2, 'WRLB2', null, null, null, null, 1, null, null, null, null, null, 'Y', 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 (20004, null, 'WRLB', 'WRLB', 3, 'WRLB3', null, null, null, null, 1, null, null, null, null, null, 'Y/17', 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 (20005, null, 'WRLB', 'WRLB', 4, 'WRLB4', null, null, null, null, 1, null, null, null, null, null, 'Z/17', 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 (20006, null, 'WRLB', 'WRLB', 5, 'WRLB5', null, null, null, null, 1, null, null, null, null, null, 'Z/18', 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 (20007, null, 'WRLB', 'WRLB', 6, 'WRLB6', null, null, null, null, 1, null, null, null, null, null, 'X', 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 (20008, null, 'WRLB', 'WRLB', 7, 'WRLB7', null, null, null, null, 1, null, null, null, null, null, 'OS', 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 (20009, null, 'HZWXX', 'HZWXX', 1, 'HZWXX1', 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 (20010, null, 'HZWXX', 'HZWXX', 2, 'HZWXX2', 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 (20011, null, 'HZWXX', 'HZWXX', 3, 'HZWXX3', 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 (20012, null, 'HZWXX', 'HZWXX', 4, 'HZWXX4', 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 (20013, null, 'HZWXX', 'HZWXX', 5, 'HZWXX5', null, null, null, null, 1, null, null, null, null, null, '', null, null, '0', null, null, null, null, null);