xnyb.txt

医疗卫生用辅助管理系统,用来管理整个后台程序使用状况

//说明:
//本文件为删除系统数据库表数据的文件,用于初始化用,必须将本文件存
//放的路径是在C:\XNYB.TXT;如果有表需要添加的,则在此文件中增加,但
//必须根据表结构主外键关系进行清空数据,先清空外键表,再清空主键表,
//如果要添加文件说明,则以"//"开头,SQL语句中必须以";"(分号)结尾.

//删除自动升级文件表
DELETE FROM AUTOUPDATE;
DELETE FROM AUTOUPDATE_CLINT;

//删除报表相关表
DELETE FROM BB_SJGB;
DELETE FROM BB_BBGS;
DELETE FROM BB_YYMZHZ;
DELETE FROM BB_YYZYHZ;
DELETE FROM BB_BZDY;
DELETE FROM BB_JCXX;
DELETE FROM BB_JJHZ

//删除卡数据相关表
DELETE FROM JC_KHMD_LS;
DELETE FROM JC_KHMD;
DELETE FROM JC_KZXX;

//删除财务相关数据
DELETE FROM CW_FDXX;
DELETE FROM CW_GRZH_MX;
DELETE FROM CW_GRZH;
DELETE FROM CW_GRZH_MX_LS;
DELETE FROM CW_GRZH_LS;
DELETE FROM CW_JJRB;
DELETE FROM CW_JJRB_HZ;
DELETE FROM CW_JJSR;
DELETE FROM CW_JJYB;
DELETE FROM CW_JJYB_JG;
DELETE FROM CW_JJZC;
DELETE FROM CW_JTZH_MX;
DELETE FROM CW_JTZH;
DELETE FROM CW_JTZH_MX_LS;
DELETE FROM CW_JTZH_LS;
DELETE FROM CW_NDJJ;
DELETE FROM CW_YJJG;
DELETE FROM CW_YJJL;

//删除基础数据相关表
DELETE FROM JC_CYJF;
DELETE FROM JC_CYXX_TMP;
DELETE FROM JC_CYZY;
DELETE FROM JC_JTBD;
DELETE FROM JC_SJDR_SCSJ;
DELETE FROM JC_ZYLS;
DELETE FROM JC_JCXX_TMP;
DELETE FROM JC_CBXX;
DELETE FROM JC_RZMX;
DELETE FROM JC_TBJL;
DELETE FROM JC_CYXX;
DELETE FROM JC_JTXX;
DELETE FROM JC_JTXX_TMP;
DELETE FROM JC_JCXX;
DELETE FROM JC_XZXX;

//删除自费结算报销接口表
DELETE FROM JK_ZYXMMX;
DELETE FROM JK_ZYXX;

//删除报销分段信息
DELETE FROM BX_FDXX;

//删除医院门诊业务表
DELETE FROM YY_JSDXX;
DELETE FROM YY_MZZF;
DELETE FROM YY_MZJS;
DELETE FROM YY_MZJSMX;
DELETE FROM YY_MZDJ;

//删除医院住院业务数据
DELETE FROM YY_ZYZF;
DELETE FROM YY_ZYJS;
DELETE FROM YY_ZYJSMX;
DELETE FROM YY_RYDJ;

//删除中心门诊业务数据
DELETE FROM SH_MZXMHZ;
DELETE FROM SH_JSDXX;
DELETE FROM SH_MZZF;
DELETE FROM SH_MZJS;
DELETE FROM SH_MZJSMX;
DELETE FROM SH_MZDJ;

//删除中心住院业务数据
DELETE FROM SH_ZYXMHZ;
DELETE FROM SH_ZYZF;
DELETE FROM SH_ZYJS;
DELETE FROM SH_ZYJSMX;
DELETE FROM SH_RYDJ;

//删除备案相关数据
DELETE FROM SH_TSBZBA_MX;
DELETE FROM SH_TSBZBA;
DELETE FROM SH_ZYBA;
DELETE FROM SH_BAGL;

//删除日结日志表
DELETE FROM RJ_LOG;
DELETE FROM RJ_RJXX;

//删除主键值表数据
DELETE FROM SS_IDENTITY;

//删除共用信息
DELETE FROM GY_CJLS;
DELETE FROM GY_JFCS;
DELETE FROM GY_NDJZ;
DELETE FROM GY_RJHZ;
DELETE FROM GY_RJJL;
DELETE FROM GY_RZCS;
DELETE FROM GY_ZDBM;

//更新系统参数表,将当前参数值更改为默认值
UPDATE GY_XTCS SET CSZ = MRZ ;

//删除基础维护信息相关数据
DELETE FROM WH_BXFD;
DELETE FROM WH_FDCS;
DELETE FROM WH_YLJG;
DELETE FROM WH_ZFCS;
DELETE FROM WH_YPFYML;