--##2018.05.15 add by dsm for BQ-20180507-001 --冲销类别 0 按医技单冲销的,1按收费项目冲销的
create index INDEX_YJ_YWJJ00_MXID on SD_YJ.YJ_YWJJ00(MXID00);
alter table SD_YJ.YJ_YWJJ00 add(CXLB00 varchar2(1));                              
commit; 
------------------------------------末次更新20180519-----------------------------------
--##2018.04.25 Wusd for LIS-20180424-001
Prompt 家庭档案项目表(JY_JTDAXM)
create table SD_JY.JY_JTDAXM( 
  JTDAH0 varchar2(12), 
  ZFGHID number(10),
  ZFGHH0 char(12), 
  QZGHID number(10),
  QZGHH0 char(12),
  XMLX00 varchar2(2),
  XMMC00 varchar2(12),
  KDRQ00 char(8),
  KDSJ00 char(8)
);
create synonym JY_JTDAXM for SD_JY.JY_JTDAXM;
commit;

--##2018.04.28 Wusd for LIS-20180424-001
alter table SD_JY.JY_CJTDAH add (JTDAZT number(2) default 1);
alter table SD_JY.JY_CJTDAH drop column XMLX00;
alter table SD_JY.JY_CJTDAH drop column XMMC00;
alter table SD_JY.JY_YW0000 add (XMLX00 varchar2(2));
------------------------------------末次更新20180519-----------------------------------
--##zhengzk 2018.05.19 for YQBG-20180508-002
alter table SD_MZ.YS_SYJBDJ add
(
  CZFZBZ  varchar2(1) default '0'
);
commit;

--## huangjy 2018.05.20 add by YFPY-20180508-001
alter table SD_YF.YF_CFDL00 add(FYR000 varchar2(20));
commit; 
------------------------------------末次更新20180521-----------------------------------
--##2018.05.22  by zhangyc  MZSF-20180522-001
alter table SD_HOSPITAL.BM_ZFRZ00 add
(
FKTM00 varchar2(50)  ,--付款条码
JXCXCS varchar2(200) ,--交易查询信息
DDCXCS varchar2(200)  --订单撤销信息
); 

alter table SD_SF.SF_POSLSZ add
(
DDLSH0 varchar2(32)  --订单流水号=BM_ZFRZ00.DDLSH0
); 

alter table SD_ZY.ZY_POSLSZ add
(
DDLSH0 varchar2(32)  --订单流水号=BM_ZFRZ00.DDLSH0
); 
commit;
------------------------------------末次更新20180524-----------------------------------
--##2018.05.21 add by dsm for BQ-20180509-001
--医嘱预撤销标志
alter table SD_BQ.BQ_YPYZ00 add(YCXBZ0 varchar2(1)) ; 
--医嘱预撤销标志
alter table SD_BQ.BQ_YJYZ00 add(YCXBZ0 varchar2(1)) ; 
commit;  
------------------------------------末次更新20180524-----------------------------------
--##2018.05.22 wusd JKTJ-20180522-001
alter table SD_TJ.TJ_DWSFTJ add (FJF000 number(12,4) default 0);
commit;  
------------------------------------末次更新20180525-----------------------------------
--##2018.05.24  by zhangyc  MZSF-20180514-002
alter table SD_HOSPITAL.BM_ZFRZ00 modify
(
JXCXCS varchar2(2000) ,--交易查询信息
DDCXCS varchar2(2000)  --订单撤销信息
); 
alter table SD_HOSPITAL.BM_ZFRZ00 add
(
JYCXBM varchar2(20)  ,--交易查询状态编码
JYCXMC varchar2(50)  ,--交易查询状态名称
ZFZTBM varchar2(20)  ,--平台支付状态编码 1  支付成功  0  未支付、支付失败  2  订单关闭或退款或撤销  -1  等待用户支付,用户支付中
ZFZTMC varchar2(50)  ,--平台支付状态名称
QDZTBM varchar2(20)  ,--渠道状态编码 微信：SUCCESS(支付成功) 支付宝:TRADE_SUCCESS（交易支付成功）
QDZTMC varchar2(50)  ,--渠道状态名称
DDCXBM varchar2(20)  ,--订单撤销状态编码
DDCXMC varchar2(50)   --订单撤销状态名称
); 
commit;
------------------------------------末次更新20180525-----------------------------------

--##2018.05.17 add by dsm for ZYSF-20171020-001
create table SD_ZY.ZY_FYYHMX(ZYID00  number(12),  --住院ID
                             DJH000  number(12),  --单据号 ZY_FYMX00.DJH000
                             MXID00  number(12),  --明细ID ZY_FYMX00.MXID00
                             YHMXID  number(12),  --优惠金额的MXID ZY_FYMX00.MXID00
                             YHDJH0  number(12),  --优惠单据号
                             CXBZ00  char(1),     --冲销标志
                             BZ0000  varchar2(20), --备注
                             CZRQ00  varchar2(8) default to_char(sysdate,'YYYYMMDD'),  --日期
                             CZSJ00  varchar2(8) default to_char(sysdate,'HH24:MI:SS'),  --时间
                             YXBZ00  varchar2(1) default '1'  --有效标志0:无效,1有效
                             );
create synonym ZY_FYYHMX for SD_ZY.ZY_FYYHMX;
create index INDEX_ZY_FYYHMX_ZYID00 on SD_HOSPITAL.ZY_FYYHMX(ZYID00);
create index INDEX_ZY_FYYHMX_MXID00 on SD_HOSPITAL.ZY_FYYHMX(MXID00);
create index INDEX_ZY_FYYHMX_YHMXID on SD_HOSPITAL.ZY_FYYHMX(YHMXID);
commit;

------------------------------------末次更新20180528-----------------------------------
--##2018.05.29  by zhangyc ZYSF-20180529-002
alter table SD_ZY.ZY_BASYFS add(KZMRZ0 varchar2(200));
commit;
------------------------------------末次更新20180529-----------------------------------
--##2018.05.30  by zhangyc ZYSF-20180530-001
update BM_YBBCLX set YBBL00='jzfpje',YBBLZW='精准扶贫补助总金额' where YBYLZD='YBYL43' and YBBL00='jcfpje';
commit;
------------------------------------末次更新20180530-----------------------------------
--##2018.05.30 add by dsm for MZYS-20180526-001
alter table SD_HOSPITAL.BM_TYZD00 modify(PYSM00 varchar2(200));
alter table SD_HOSPITAL.BM_TYZD00 modify(WBSM00 varchar2(200));
commit;

--##2018.05.18 chenhn  by   LIS-20180412-001
alter table SD_HOSPITAL.JY_WJYBCX add(BTZRXM varchar2(20));    
alter table SD_HOSPITAL.JY_WJYBCX add(TZNR00 varchar2(100));   
commit;

--##2018.05.18 chenhn  by   LIS-20180412-001
alter table SD_JY.JY_WJZJLD add
(
TZNR00 varchar2(100),   --通知内容
BTZXM0 varchar2(20),    --被通知医生姓名
BTZBH0 number(5,0),     --被通知医生编号
WJSFTB char(1)          --危急值是否通报
);
commit;

------------------------------------末次更新20180531-----------------------------------
--##2018.05.30 zhengzk added for  XMGL-20180525-001 增加门诊住院标志
alter table SD_HOSPITAL.BM_TSBZB0 add (
  MZZYBZ char(1) default '2' not null  --门诊住院标志：0限门诊 1限住院 2不限制,默认2
);
commit;

--## 2018.05.31 chenhn  by LIS-20180412-002
alter table SD_JY.JY_YW0000 add(SFYC00 char(1));
commit;


--##2018.06.01 Nixj by LIS-20170510-003
alter table SD_JY.JY_BGXMZD add(BGSX00 char(1));
commit;

create table SD_JY.JY_SDSJTJ
(	ZYZBMC varchar2(50),
	YQJC00 varchar2(50),
	XMZS00 number(10),
	SNXMS0 number(10),
	SJXMS0 number(10),
	QTXMS0 number(10)
);
create synonym JY_SDSJTJ for SD_JY.JY_SDSJTJ;
------------------------------------末次更新20180601-----------------------------------
--##2018.06.04 chenhn  用于判断危急值是否及时提醒医生，如果24小时内没提醒，弹框显示，并把该字段改为已弹窗。原始数据需要过滤，所以字段默认要先改回'1' by LIS-20180531-003 
alter table SD_JY.JY_YW0000 add(TXTBWJ char(1));
commit;

--更新历史不需要统计、弹框数据，请工程人员自行添加时间条件,因update时间过长,请在系统更新完成后单独运行。
/*
alter table SD_JY.JY_YW0000 disable all triggers;
update SD_JY.JY_YW0000 set TXTBWJ='1';
commit;
alter table SD_JY.JY_YW0000 enable all triggers;                                 
commit;
*/

------------------------------------末次更新20180605-----------------------------------
--##2018.06.05 chenhn  by   LIS-20180605-001  --耗时
alter table SD_JY.JY_WJZJLD add (HS0000 varchar2(20));
commit;
------------------------------------末次更新20180606-----------------------------------
--##2018.06.04 Wusd for LIS-20180604-003
create index INDEX_JY_YW0000_MZZYBZ on JY_YW0000 (MZZYBZ);
create index INDEX_JY_YW0000_XMLX00 on JY_YW0000 (XMLX00);
create index INDEX_JY_JYJG00_PYRQ00 on JY_JYJG00 (PYRQ00);
------------------------------------末次更新20180607-----------------------------------
--##2018.06.12 Wusd for LIS-20180612-001
alter table SD_JY.JY_BGXMZD add (BTJC00 varchar2(40));
prompt 婚检报告临时表1(JY_JYJGLS)
create global temporary table SD_JY.JY_JYJGLS(
    ID0000 number(9),
    ZLXMJC varchar2(200),
    BGXMMC varchar2(100),
    JYJG00 varchar2(200),
    JGZCBZ varchar2(10),
    JGDW00 varchar2(12),
    CKFW00 varchar2(200),
    JYFF00 varchar2(40)) on commit delete rows;
create synonym JY_JYJGLS for SD_JY.JY_JYJGLS;
commit;

prompt 婚检报告临时表2(JY_HJJYLS)
create table SD_JY.JY_HJJYLS(
    PX0000 number(9),
    ZLXM01 varchar2(200),
    BGXM01 varchar2(100),
    JYJG01 varchar2(200),
    JGBZ01 varchar2(10),
    JGDW01 varchar2(12),
    CKFW01 varchar2(200),
    JYFF01 varchar2(40),    
    ZLXM02 varchar2(200),
    BGXM02 varchar2(100),
    JYJG02 varchar2(200),
    JGBZ02 varchar2(10),
    JGDW02 varchar2(12),
    CKFW02 varchar2(200),
    JYFF02 varchar2(40));
create synonym JY_HJJYLS for SD_JY.JY_HJJYLS;
commit;

--##2018.06.12 add by dsm for ZYYS-20180409-001 实际启用时间,如果为空BQ_YPYZ00.SJQYSJ则按算法计算(QYSJ00和频次时序对比得出),如果有值则按此时间和频次时序对比得出
alter table SD_HOSPITAL.BM_YPYF00 add (SJQYSJ varchar2(8));
commit;
------------------------------------末次更新20180613-----------------------------------
--##2018.06.13  wuzy  新增字段合并症  ZYDZBL-20180605-002
alter table SD_ZS.LJ_TJZBZ0 add ( HBZ000 char(1));
------------------------------------末次更新20180613-----------------------------------
--##2018.06.12 Nixj for LIS-20180604-005
alter table SD_HOSPITAL.JY_BBZLTJ add(SQKS00 number(5));
commit; 

--##2018.06.04 Nixj  for LIS-20180522-001
create table SD_JY.JY_YWECPY
(	YQDH00 char(2),
	TXM000 varchar2(12),
	YBH000 char(6),
	PYRQ00 char(8)
);
create synonym JY_YWECPY for SD_JY.JY_YWECPY;
commit;
------------------------------------末次更新20180614-----------------------------------
--##2018.06.16 数据库版本更新
update XT_DBMS00 set DBBB00='05.00.180616' where DBBB00 <'05.00.180616' ;
commit;
------------------------------------末次更新20180616-----------------------------------