[SQLITE3]
0={912F82F2-19BC-4A7D-8E17-54555739F118}
1={9A0F82F2-19BC-4A7D-8E17-54555739F119}
2={A85034FD-758E-4546-8636-2C155D8F875C}
3={E8EB9FF2-0DE5-4A25-BD22-19F004753AE5}
4={24DD2455-CA2C-4EF4-98EC-36A146FA55F7}
5={FF43A16A-9EF8-4140-99CB-8F79E9881355}
6={0128AEAE-B745-4101-9911-0553DF51B874}

7={B2E8E121-B349-435B-AF4A-698E0029AEA8}
8={50BB6B7C-41DB-4308-A75B-0B73E3A80FF9}
9={11978370-ED8B-4494-8FA8-6E9F6944B5B9}
10={AA69800B-E588-45AF-AE05-4D5F54974857}
11={942BCFC3-0786-43D2-8CA3-A4E4D4E9F338}

[{912F82F2-19BC-4A7D-8E17-54555739F118}]
1=DROP TABLE IF EXISTS "EP_QYGSXXOld"
2=DROP TABLE IF EXISTS "ep_qykzxxOld"

[{9A0F82F2-19BC-4A7D-8E17-54555739F119}]
;修改开户银行(KHYH)长度
1=ALTER TABLE EP_QYGSXX RENAME TO EP_QYGSXXOld
2=CREATE TABLE "EP_QYGSXX" ("QYID"  INTEGER NOT NULL,"NSRSBH"  varchar(30) NOT NULL,"NSRBM"  varchar(30),"NSRMC"  varchar(80),"FDDBRMC"  varchar(60),"DHHM"  varchar(60),"YZBM"  varchar(6),"ZCDZ"  varchar(200),"YYDZ"  varchar(200),"SSHY"  varchar(20),"SSHYMC"  varchar(60),"DJZCLX_DM"  INTEGER,"NSRZT"  varchar(20),"KKYH"  varchar(80),"YHZH"  varchar(100),"NSRLX"  varchar(20),"XYDJ"  varchar(20),"SSSWJG_DM"  varchar(20),"SSSWJG_MC"  varchar(80),"SSDLJG"  varchar(20),"JKBZ"  varchar(1),"ZDH"  varchar(10),"SQR"  varchar(20),"SMR"  varchar(20),"KSSCJYRQ"  varchar(20),"KSHLND"  varchar(20),"KJZG"  varchar(20),"ZJFMC"  varchar(50),"ZJGSWDJH"  varchar(20),"FZR"  varchar(20),"JBZH"  varchar(50),"FLZSH"  varchar(50),"ICCARD"  TEXT,"QYLXDM"  varchar(20),"QYLXMC"  varchar(50),"GXSJ"  DATETIME,"GXBZ" INTEGER, SWDJRQ DATETIME, PRIMARY KEY ("QYID" ASC))
3=INSERT INTO EP_QYGSXX ("QYID","NSRSBH","NSRBM", "NSRMC", "FDDBRMC","DHHM" ,"YZBM"  ,"ZCDZ" ,"YYDZ" ,"SSHY" ,"SSHYMC","DJZCLX_DM","NSRZT","KKYH" ,"YHZH","NSRLX" ,"XYDJ" ,"SSSWJG_DM" ,"SSSWJG_MC","SSDLJG" ,"JKBZ","ZDH","SQR" ,"SMR","KSSCJYRQ" ,"KSHLND","KJZG","ZJFMC","ZJGSWDJH","FZR","JBZH" ,"FLZSH" ,"ICCARD","QYLXDM" ,"QYLXMC","GXSJ","GXBZ", "SWDJRQ")  SELECT QYID,NSRSBH,NSRBM, NSRMC, FDDBRMC,DHHM ,YZBM  ,ZCDZ ,YYDZ ,SSHY ,SSHYMC,DJZCLX_DM,NSRZT,KKYH ,YHZH,NSRLX ,XYDJ ,SSSWJG_DM ,SSSWJG_MC,SSDLJG ,JKBZ,ZDH,SQR ,SMR,KSSCJYRQ ,KSHLND,KJZG,ZJFMC,ZJGSWDJH,FZR,JBZH ,FLZSH ,ICCARD,QYLXDM ,QYLXMC,GXSJ,GXBZ,SWDJRQ FROM EP_QYGSXXOld
3or=INSERT INTO EP_QYGSXX ("QYID","NSRSBH","NSRBM", "NSRMC", "FDDBRMC","DHHM" ,"YZBM"  ,"ZCDZ" ,"YYDZ" ,"SSHY" ,"SSHYMC","DJZCLX_DM","NSRZT","KKYH" ,"YHZH","NSRLX" ,"XYDJ" ,"SSSWJG_DM" ,"SSSWJG_MC","SSDLJG" ,"JKBZ","ZDH","SQR" ,"SMR","KSSCJYRQ" ,"KSHLND","KJZG","ZJFMC","ZJGSWDJH","FZR","JBZH" ,"FLZSH" ,"ICCARD","QYLXDM" ,"QYLXMC","GXSJ","GXBZ")  SELECT QYID,NSRSBH,NSRBM, NSRMC, FDDBRMC,DHHM ,YZBM  ,ZCDZ ,YYDZ ,SSHY ,SSHYMC,DJZCLX_DM,NSRZT,KKYH ,YHZH,NSRLX ,XYDJ ,SSSWJG_DM ,SSSWJG_MC,SSDLJG ,JKBZ,ZDH,SQR ,SMR,KSSCJYRQ ,KSHLND,KJZG,ZJFMC,ZJGSWDJH,FZR,JBZH ,FLZSH ,ICCARD,QYLXDM ,QYLXMC,GXSJ,GXBZ FROM EP_QYGSXXOld
4=DROP TABLE EP_QYGSXXOld

[{A85034FD-758E-4546-8636-2C155D8F875C}]
;修改备注(BZ)字段改成BLOB类型，同时添加社会信用代码(SHXYDM)字段
1=ALTER TABLE EP_QYKZXX RENAME TO ep_qykzxxOld
2=CREATE TABLE "EP_QYKZXX" ("QYID" INTEGER NOT NULL,"QYSBH" VARCHAR(30),"ZCM" VARCHAR(50),"ZCXLH" VARCHAR(50) NOT NULL,"QYMC" VARCHAR(80),"NSRSBH" VARCHAR(20),"FDDBRMC" VARCHAR(60),"CWFZR" VARCHAR(60),"CWFZRLXHM" VARCHAR(50),"CWFZRBGDH" VARCHAR(50),"BSY" VARCHAR(60),"BSYLXHM" VARCHAR(50),"BSYBGDH" VARCHAR(50),"XZQHDM" VARCHAR(10),"ZCDZ" VARCHAR(200),"YYDZ" VARCHAR(200),"YZBM" VARCHAR(6),"EMAIL" VARCHAR(60),"QYDHHM" VARCHAR(60),"QYCZHM" VARCHAR(60),"HYMC" VARCHAR(50),"HYDM" VARCHAR(6),"ZSID" VARCHAR(40),"DQHDSJ" DATETIME,"CZY_DM" VARCHAR(20),"LBDM" INTEGER,"SSDLJGID" INTEGER,"SSSWJG" VARCHAR(80),"BZ" BLOB,"SHXYDM" VARCHAR(30),PRIMARY KEY ("QYID" ASC))
3=INSERT INTO EP_QYKZXX(QYID,QYSBH,ZCM,ZCXLH,QYMC,NSRSBH,FDDBRMC,CWFZR,CWFZRLXHM,CWFZRBGDH,BSY,BSYLXHM,BSYBGDH,XZQHDM,ZCDZ,YYDZ,YZBM,EMAIL,QYDHHM,QYCZHM,HYMC,HYDM,ZSID,DQHDSJ,CZY_DM,LBDM,SSDLJGID,SSSWJG,BZ,SHXYDM)  SELECT QYID,QYSBH,ZCM,ZCXLH,QYMC,NSRSBH,FDDBRMC,CWFZR,CWFZRLXHM,CWFZRBGDH,BSY,BSYLXHM,BSYBGDH,XZQHDM,ZCDZ,YYDZ,YZBM,EMAIL,QYDHHM,QYCZHM,HYMC,HYDM,ZSID,DQHDSJ,CZY_DM,LBDM,SSDLJGID,SSSWJG,BZ,SHXYDM FROM ep_qykzxxOld
3or=INSERT INTO EP_QYKZXX(QYID,QYSBH,ZCM,ZCXLH,QYMC,NSRSBH,FDDBRMC,CWFZR,CWFZRLXHM,CWFZRBGDH,BSY,BSYLXHM,BSYBGDH,XZQHDM,ZCDZ,YYDZ,YZBM,EMAIL,QYDHHM,QYCZHM,HYMC,HYDM,ZSID,DQHDSJ,CZY_DM,LBDM,SSDLJGID,SSSWJG,BZ)  SELECT QYID,QYSBH,ZCM,ZCXLH,QYMC,NSRSBH,FDDBRMC,CWFZR,CWFZRLXHM,CWFZRBGDH,BSY,BSYLXHM,BSYBGDH,XZQHDM,ZCDZ,YYDZ,YZBM,EMAIL,QYDHHM,QYCZHM,HYMC,HYDM,ZSID,DQHDSJ,CZY_DM,LBDM,SSDLJGID,SSSWJG,BZ FROM ep_qykzxxOld
4=DROP TABLE ep_qykzxxOld

[{E8EB9FF2-0DE5-4A25-BD22-19F004753AE5}]
;添加税务登记日期(SWDJRQ)字段
1=ALTER TABLE EP_QYGSXX ADD SWDJRQ DATETIME
1or=true

[{24DD2455-CA2C-4EF4-98EC-36A146FA55F7}]
;修改EP_QYGSXX 企业名称长度.
1=ALTER TABLE EP_QYGSXX RENAME TO EP_QYGSXXOld
2=CREATE TABLE "EP_QYGSXX" ("QYID"  INTEGER NOT NULL,"NSRSBH"  varchar(30) NOT NULL,"NSRBM"  varchar(30),"NSRMC"  varchar(200),"FDDBRMC"  varchar(60),"DHHM"  varchar(60),"YZBM"  varchar(6),"ZCDZ"  varchar(200),"YYDZ"  varchar(200),"SSHY"  varchar(20),"SSHYMC"  varchar(60),"DJZCLX_DM"  INTEGER,"NSRZT"  varchar(20),"KKYH"  varchar(80),"YHZH"  varchar(100),"NSRLX"  varchar(20),"XYDJ"  varchar(20),"SSSWJG_DM"  varchar(20),"SSSWJG_MC"  varchar(80),"SSDLJG"  varchar(20),"JKBZ"  varchar(1),"ZDH"  varchar(10),"SQR"  varchar(20),"SMR"  varchar(20),"KSSCJYRQ"  varchar(20),"KSHLND"  varchar(20),"KJZG"  varchar(20),"ZJFMC"  varchar(50),"ZJGSWDJH"  varchar(20),"FZR"  varchar(20),"JBZH"  varchar(50),"FLZSH"  varchar(50),"ICCARD"  TEXT,"QYLXDM"  varchar(20),"QYLXMC"  varchar(50),"GXSJ"  DATETIME,"GXBZ" INTEGER, SWDJRQ DATETIME, PRIMARY KEY ("QYID" ASC))
3=INSERT INTO EP_QYGSXX ("QYID","NSRSBH","NSRBM", "NSRMC", "FDDBRMC","DHHM" ,"YZBM"  ,"ZCDZ" ,"YYDZ" ,"SSHY" ,"SSHYMC","DJZCLX_DM","NSRZT","KKYH" ,"YHZH","NSRLX" ,"XYDJ" ,"SSSWJG_DM" ,"SSSWJG_MC","SSDLJG" ,"JKBZ","ZDH","SQR" ,"SMR","KSSCJYRQ" ,"KSHLND","KJZG","ZJFMC","ZJGSWDJH","FZR","JBZH" ,"FLZSH" ,"ICCARD","QYLXDM" ,"QYLXMC","GXSJ","GXBZ", "SWDJRQ")  SELECT QYID,NSRSBH,NSRBM, NSRMC, FDDBRMC,DHHM ,YZBM  ,ZCDZ ,YYDZ ,SSHY ,SSHYMC,DJZCLX_DM,NSRZT,KKYH ,YHZH,NSRLX ,XYDJ ,SSSWJG_DM ,SSSWJG_MC,SSDLJG ,JKBZ,ZDH,SQR ,SMR,KSSCJYRQ ,KSHLND,KJZG,ZJFMC,ZJGSWDJH,FZR,JBZH ,FLZSH ,ICCARD,QYLXDM ,QYLXMC,GXSJ,GXBZ,SWDJRQ FROM EP_QYGSXXOld
3or=INSERT INTO EP_QYGSXX ("QYID","NSRSBH","NSRBM", "NSRMC", "FDDBRMC","DHHM" ,"YZBM"  ,"ZCDZ" ,"YYDZ" ,"SSHY" ,"SSHYMC","DJZCLX_DM","NSRZT","KKYH" ,"YHZH","NSRLX" ,"XYDJ" ,"SSSWJG_DM" ,"SSSWJG_MC","SSDLJG" ,"JKBZ","ZDH","SQR" ,"SMR","KSSCJYRQ" ,"KSHLND","KJZG","ZJFMC","ZJGSWDJH","FZR","JBZH" ,"FLZSH" ,"ICCARD","QYLXDM" ,"QYLXMC","GXSJ","GXBZ")  SELECT QYID,NSRSBH,NSRBM, NSRMC, FDDBRMC,DHHM ,YZBM  ,ZCDZ ,YYDZ ,SSHY ,SSHYMC,DJZCLX_DM,NSRZT,KKYH ,YHZH,NSRLX ,XYDJ ,SSSWJG_DM ,SSSWJG_MC,SSDLJG ,JKBZ,ZDH,SQR ,SMR,KSSCJYRQ ,KSHLND,KJZG,ZJFMC,ZJGSWDJH,FZR,JBZH ,FLZSH ,ICCARD,QYLXDM ,QYLXMC,GXSJ,GXBZ FROM EP_QYGSXXOld
4=DROP TABLE EP_QYGSXXOld



[{FF43A16A-9EF8-4140-99CB-8F79E9881355}]
;修改UC_COMPANY 企业名称长度.
ConName=EpAccountMainCon
1=ALTER TABLE UC_COMPANY RENAME TO UC_COMPANYOld
2=CREATE TABLE "UC_COMPANY" ("G_ID"  INTEGER NOT NULL,"QYSBH"  VARCHAR(30),"DJXH"  VARCHAR(32),"ZCBM"  VARCHAR2(50),"ZCXLH"  VARCHAR(50),"QYMC"  VARCHAR(200),"SWDJZH"  VARCHAR(20),"FDDBRMC"  VARCHAR(60),"CWFZR"  VARCHAR(60),"CWFZRLXHM"  VARCHAR(50),"CWFZRBGDH"  VARCHAR(50),"BSY"  VARCHAR(60),"BSYLXHM"  VARCHAR(50),"BSYBGDH"  VARCHAR(50),"EMAIL"  VARCHAR(50),"POSTCODE"  VARCHAR(20),"SSDXZQH_DM"  VARCHAR(20),"JYDXZQH_DM"  VARCHAR(20),"ZCDZ"  VARCHAR(200),"YYDZ"  VARCHAR(200),"QYTYPE_DM"  VARCHAR(1) DEFAULT '0',"GSSWJG_DM"  VARCHAR(20),"GSSWJG_MC"  VARCHAR(255),"DSSWJG_DM"  VARCHAR(20),"DSSWJG_MC"  VARCHAR(255),"JTLX_DM"  VARCHAR(1) NOT NULL DEFAULT '0',"HYMC"  VARCHAR(200),"HYDL_DM"  VARCHAR(10),"ZGY_ID"  VARCHAR2(32),"ZGY_DM_DS"  VARCHAR2(32),"KHBZ"  VARCHAR(1) DEFAULT '0',"CREATE_TIME"  varchar2(30),"MODIFY_TIME"  varchar2(30),"MS"  varchar(255),"LXDH"  VARCHAR(255),"CZHM"  VARCHAR(255),PRIMARY KEY ("G_ID" ASC),CONSTRAINT "CKC_JTLX_DM_UC_COMPA" CHECK (JTLX_DM in ('0','1','2')))
3=INSERT INTO UC_COMPANY ("G_ID","QYSBH","DJXH","ZCBM","ZCXLH","QYMC" ,"SWDJZH"  ,"FDDBRMC" ,"CWFZR" ,"CWFZRLXHM" ,"CWFZRBGDH","BSY","BSYLXHM","BSYBGDH" ,"EMAIL","POSTCODE" ,"SSDXZQH_DM" ,"JYDXZQH_DM","ZCDZ" ,"YYDZ","QYTYPE_DM","GSSWJG_DM","GSSWJG_MC","DSSWJG_DM","DSSWJG_MC","JTLX_DM","HYMC","HYDL_DM","ZGY_ID","ZGY_DM_DS","KHBZ","CREATE_TIME","MODIFY_TIME","MS" ,"LXDH","CZHM")  SELECT G_ID,QYSBH,DJXH,ZCBM,ZCXLH,QYMC ,SWDJZH  ,FDDBRMC ,CWFZR ,CWFZRLXHM ,CWFZRBGDH,BSY,BSYLXHM,BSYBGDH ,EMAIL,POSTCODE ,SSDXZQH_DM ,JYDXZQH_DM,ZCDZ ,YYDZ,QYTYPE_DM,GSSWJG_DM,GSSWJG_MC,DSSWJG_DM,DSSWJG_MC,JTLX_DM,HYMC,HYDL_DM,ZGY_ID,ZGY_DM_DS,KHBZ,CREATE_TIME,MODIFY_TIME,MS ,LXDH,CZHM FROM UC_COMPANYOld
4=DROP TABLE UC_COMPANYOld

[{0128AEAE-B745-4101-9911-0553DF51B874}]
;新增地税登记序号
1=ALTER TABLE EP_QYKZXX ADD DSZSID VARCHAR(40)
1or=true

[{B2E8E121-B349-435B-AF4A-698E0029AEA8}]
;V3.1.109 脱敏需求 修改UC_COMPANY FDDBRMC: 法定代表人; ZCDZ:注册地址; YYDZ:营业地址；EMAIL：电子邮件;LXDH:联系电话的长度
ConName=EpAccountMainCon
1=ALTER TABLE UC_COMPANY RENAME TO UC_COMPANYOld
2=CREATE TABLE "UC_COMPANY" ("G_ID"  INTEGER NOT NULL,"QYSBH"  VARCHAR(30),"DJXH"  VARCHAR(32),"ZCBM"  VARCHAR2(50),"ZCXLH"  VARCHAR(50),"QYMC"  VARCHAR(200),"SWDJZH"  VARCHAR(20),"FDDBRMC"  VARCHAR(120),"CWFZR"  VARCHAR(60),"CWFZRLXHM"  VARCHAR(50),"CWFZRBGDH"  VARCHAR(50),"BSY"  VARCHAR(60),"BSYLXHM"  VARCHAR(50),"BSYBGDH"  VARCHAR(50),"EMAIL"  VARCHAR(100),"POSTCODE"  VARCHAR(20),"SSDXZQH_DM"  VARCHAR(20),"JYDXZQH_DM"  VARCHAR(20),"ZCDZ"  VARCHAR(400),"YYDZ"  VARCHAR(400),"QYTYPE_DM"  VARCHAR(1) DEFAULT '0',"GSSWJG_DM"  VARCHAR(20),"GSSWJG_MC"  VARCHAR(255),"DSSWJG_DM"  VARCHAR(20),"DSSWJG_MC"  VARCHAR(255),"JTLX_DM"  VARCHAR(1) NOT NULL DEFAULT '0',"HYMC"  VARCHAR(200),"HYDL_DM"  VARCHAR(10),"ZGY_ID"  VARCHAR2(32),"ZGY_DM_DS"  VARCHAR2(32),"KHBZ"  VARCHAR(1) DEFAULT '0',"CREATE_TIME"  varchar2(30),"MODIFY_TIME"  varchar2(30),"MS"  varchar(255),"LXDH"  VARCHAR(512),"CZHM"  VARCHAR(255),PRIMARY KEY ("G_ID" ASC),CONSTRAINT "CKC_JTLX_DM_UC_COMPA" CHECK (JTLX_DM in ('0','1','2')))
3=INSERT INTO UC_COMPANY ("G_ID","QYSBH","DJXH","ZCBM","ZCXLH","QYMC" ,"SWDJZH"  ,"FDDBRMC" ,"CWFZR" ,"CWFZRLXHM" ,"CWFZRBGDH","BSY","BSYLXHM","BSYBGDH" ,"EMAIL","POSTCODE" ,"SSDXZQH_DM" ,"JYDXZQH_DM","ZCDZ" ,"YYDZ","QYTYPE_DM","GSSWJG_DM","GSSWJG_MC","DSSWJG_DM","DSSWJG_MC","JTLX_DM","HYMC","HYDL_DM","ZGY_ID","ZGY_DM_DS","KHBZ","CREATE_TIME","MODIFY_TIME","MS" ,"LXDH","CZHM")  SELECT G_ID,QYSBH,DJXH,ZCBM,ZCXLH,QYMC ,SWDJZH  ,FDDBRMC ,CWFZR ,CWFZRLXHM ,CWFZRBGDH,BSY,BSYLXHM,BSYBGDH ,EMAIL,POSTCODE ,SSDXZQH_DM ,JYDXZQH_DM,ZCDZ ,YYDZ,QYTYPE_DM,GSSWJG_DM,GSSWJG_MC,DSSWJG_DM,DSSWJG_MC,JTLX_DM,HYMC,HYDL_DM,ZGY_ID,ZGY_DM_DS,KHBZ,CREATE_TIME,MODIFY_TIME,MS ,LXDH,CZHM FROM UC_COMPANYOld
4=DROP TABLE UC_COMPANYOld

[{50BB6B7C-41DB-4308-A75B-0B73E3A80FF9}]
;V3.1.109 脱敏需求 修改UC_PERSON EMAIL：电子邮件地址  MOBILE：手机.长度修改 Address: 地址，IDCard:身份证号
ConName=EpAccountMainCon
1=ALTER TABLE UC_PERSON RENAME TO UC_PERSONOld
2=CREATE TABLE "UC_PERSON" ( "P_ID"  VARCHAR(32) NOT NULL, "personType"  CHAR(1) NOT NULL DEFAULT '1', "SY_P_ID"  VARCHAR(32), "SJ_P_ID"  VARCHAR(32), "USER_NAME"  VARCHAR2(32), "NICKNAME"  VARCHAR2(100), "TITLE"  VARCHAR2(20), "MOBILE"  VARCHAR2(70), "PHONE"  VARCHAR2(32), "IDCARD"  VARCHAR(80), "EMAIL"  VARCHAR2(120), "POSTCODE"  VARCHAR2(6), "SEX"  VARCHAR2(1), "BIRTHDAY"  VARCHAR(30), "QQ"  VARCHAR2(20), "REGION_CODE"  CHAR(6), "ADDRESS"  VARCHAR2(400), "TAX_SYNC"  CHAR(1) NOT NULL DEFAULT "1", "SY_SYNC"  CHAR(1) NOT NULL DEFAULT "1", "CREATE_TIME"  varchar(30), "MODIFY_TIME"  varchar(30), "MS"  VARCHAR(255), "sfyz"  CHAR(1) NOT NULL DEFAULT "2", "STATUS"  CHAR(1) NOT NULL DEFAULT '1', "ZT_INITPWD"  VARCHAR2(40), PRIMARY KEY ("P_ID" ASC), CONSTRAINT "CKC_PERSONTYPE_UC_PERSO" CHECK ("personType" in ('0','1','2','3')), CONSTRAINT "CKC_TAX_SYNC_UC_PERSO" CHECK (TAX_SYNC in ('1','2','3')), CONSTRAINT "CKC_SY_SYNC_UC_PERSO" CHECK (SY_SYNC in ('1','2','3')), CONSTRAINT "CKC_SFYZ_UC_PERSO" CHECK ("sfyz" in ('0','1','2')), CONSTRAINT "CKC_STATUS_UC_PERSO" CHECK (STATUS in ('1','2','3')) );
3=INSERT INTO UC_PERSON ("P_ID", "personType", "SY_P_ID" , "SJ_P_ID", "USER_NAME", "NICKNAME", "TITLE" , "MOBILE", "PHONE" , "IDCARD" , "EMAIL", "POSTCODE" , "SEX" , "BIRTHDAY", "QQ" , "REGION_CODE", "ADDRESS" , "TAX_SYNC" , "SY_SYNC" , "CREATE_TIME" , "MODIFY_TIME" , "MS" , "sfyz" , "STATUS"  , "ZT_INITPWD") SELECT  P_ID, personType, SY_P_ID , SJ_P_ID, USER_NAME, NICKNAME, TITLE , MOBILE, PHONE , IDCARD , EMAIL, POSTCODE , SEX , BIRTHDAY, QQ , REGION_CODE, ADDRESS , TAX_SYNC , SY_SYNC , CREATE_TIME , MODIFY_TIME , MS , sfyz , STATUS, ZT_INITPWD  FROM UC_PERSONOld
4=DROP TABLE UC_PERSONOld

[{11978370-ED8B-4494-8FA8-6E9F6944B5B9}]
;V3.1.109 脱敏需求 修改EP_QYGSXX FDDBRMC: 法定代表人; ZCDZ:注册地址; YYDZ:营业地址；DHHM：电话号码; YHZH:银行账号的长度 
1=ALTER TABLE EP_QYGSXX RENAME TO EP_QYGSXXOld
2=CREATE TABLE "EP_QYGSXX" ("QYID"  INTEGER NOT NULL,"NSRSBH"  varchar(30) NOT NULL,"NSRBM"  varchar(30),"NSRMC"  varchar(200),"FDDBRMC"  varchar(120),"DHHM"  varchar(120),"YZBM"  varchar(6),"ZCDZ"  varchar(400),"YYDZ"  varchar(400),"SSHY"  varchar(20),"SSHYMC"  varchar(60),"DJZCLX_DM"  INTEGER,"NSRZT"  varchar(20),"KKYH"  varchar(80),"YHZH"  varchar(200),"NSRLX"  varchar(20),"XYDJ"  varchar(20),"SSSWJG_DM"  varchar(20),"SSSWJG_MC"  varchar(80),"SSDLJG"  varchar(20),"JKBZ"  varchar(1),"ZDH"  varchar(10),"SQR"  varchar(20),"SMR"  varchar(20),"KSSCJYRQ"  varchar(20),"KSHLND"  varchar(20),"KJZG"  varchar(20),"ZJFMC"  varchar(50),"ZJGSWDJH"  varchar(20),"FZR"  varchar(20),"JBZH"  varchar(50),"FLZSH"  varchar(50),"ICCARD"  TEXT,"QYLXDM"  varchar(20),"QYLXMC"  varchar(50),"GXSJ"  DATETIME,"GXBZ" INTEGER, SWDJRQ DATETIME, PRIMARY KEY ("QYID" ASC))
3=INSERT INTO EP_QYGSXX ("QYID","NSRSBH","NSRBM", "NSRMC", "FDDBRMC","DHHM" ,"YZBM"  ,"ZCDZ" ,"YYDZ" ,"SSHY" ,"SSHYMC","DJZCLX_DM","NSRZT","KKYH" ,"YHZH","NSRLX" ,"XYDJ" ,"SSSWJG_DM" ,"SSSWJG_MC","SSDLJG" ,"JKBZ","ZDH","SQR" ,"SMR","KSSCJYRQ" ,"KSHLND","KJZG","ZJFMC","ZJGSWDJH","FZR","JBZH" ,"FLZSH" ,"ICCARD","QYLXDM" ,"QYLXMC","GXSJ","GXBZ", "SWDJRQ")  SELECT QYID,NSRSBH,NSRBM, NSRMC, FDDBRMC,DHHM ,YZBM  ,ZCDZ ,YYDZ ,SSHY ,SSHYMC,DJZCLX_DM,NSRZT,KKYH ,YHZH,NSRLX ,XYDJ ,SSSWJG_DM ,SSSWJG_MC,SSDLJG ,JKBZ,ZDH,SQR ,SMR,KSSCJYRQ ,KSHLND,KJZG,ZJFMC,ZJGSWDJH,FZR,JBZH ,FLZSH ,ICCARD,QYLXDM ,QYLXMC,GXSJ,GXBZ,SWDJRQ FROM EP_QYGSXXOld
4=DROP TABLE EP_QYGSXXOld

[{AA69800B-E588-45AF-AE05-4D5F54974857}]
;V3.1.109 脱敏需求 修改EP_QYKZXX  FDDBRMC: 法定代表人; ZCDZ:注册地址; YYDZ:营业地址；QYDHHM：企业电话号码; EMAIL:电子邮件 ；BSYBGDH: 法人代码（注册时使用）长度修改
1=ALTER TABLE EP_QYKZXX RENAME TO EP_QYKZXXOld
2=CREATE TABLE "EP_QYKZXX" ( "QYID"  INTEGER NOT NULL, "QYSBH"  VARCHAR(30), "ZCM"  VARCHAR(50), "ZCXLH"  VARCHAR(50) NOT NULL, "QYMC"  VARCHAR(200), "NSRSBH"  VARCHAR(20), "FDDBRMC"  VARCHAR(120), "CWFZR"  VARCHAR(60), "CWFZRLXHM"  VARCHAR(50), "CWFZRBGDH"  VARCHAR(50), "BSY"  VARCHAR(60), "BSYLXHM"  VARCHAR(50), "BSYBGDH"  VARCHAR(100), "XZQHDM"  VARCHAR(10), "ZCDZ"  VARCHAR(400), "YYDZ"  VARCHAR(400), "YZBM"  VARCHAR(6), "EMAIL"  VARCHAR(120), "QYDHHM"  VARCHAR(120), "QYCZHM"  VARCHAR(60), "HYMC"  VARCHAR(50), "HYDM"  VARCHAR(6), "ZSID"  VARCHAR(40), "DQHDSJ"  DATETIME, "CZY_DM"  VARCHAR(20), "LBDM"  INTEGER, "SSDLJGID"  INTEGER, "SSSWJG"  VARCHAR(80), "BZ"  BLOB, "SHXYDM"  VARCHAR(30),  "DSZSID" VARCHAR(40), PRIMARY KEY ("QYID" ASC) )
3=INSERT INTO EP_QYKZXX ("QYID", "QYSBH", "ZCM" , "ZCXLH", "QYMC", "NSRSBH", "FDDBRMC", "CWFZR", "CWFZRLXHM", "CWFZRBGDH", "BSY", "BSYLXHM" , "BSYBGDH", "XZQHDM", "ZCDZ" , "YYDZ", "YZBM", "EMAIL" , "QYDHHM", "QYCZHM", "HYMC" , "HYDM" , "ZSID", "DQHDSJ" , "CZY_DM" , "LBDM", "SSDLJGID", "SSSWJG", "BZ", "SHXYDM",  "DSZSID")  SELECT QYID,QYSBH,ZCM,ZCXLH,QYMC,NSRSBH,FDDBRMC,CWFZR,CWFZRLXHM,CWFZRBGDH,BSY,BSYLXHM,BSYBGDH,XZQHDM,ZCDZ,YYDZ,YZBM,EMAIL,QYDHHM,QYCZHM,HYMC,HYDM,ZSID,DQHDSJ,CZY_DM,LBDM,SSDLJGID,SSSWJG,BZ,SHXYDM,DSZSID FROM EP_QYKZXXOld
4=DROP TABLE EP_QYKZXXOld

[{942BCFC3-0786-43D2-8CA3-A4E4D4E9F338}]
;V3.1.109 脱敏需求 修改EP_QYDSXX  FRDB: 法定代表人; DZXX:电子信箱; DH：电话 ；DZ:地址 长度修改
1=ALTER TABLE EP_QYDSXX RENAME TO EP_QYDSXXOld
2=CREATE TABLE "EP_QYDSXX" ("QYID"  INTEGER NOT NULL,"KJYWRMC"  varchar(200),"KJYWRBM"  varchar(20) NOT NULL,"NSRSBH"  varchar(20),"ZGSWJG"  varchar(11),"ZGSWJGMC"  varchar(80),"YZBM"  varchar(6),"DZ"  varchar(800),"DH"  varchar(70),"DZXX"  varchar(100),"CWFZR"  varchar(40),"FRDB"  varchar(80),"DJZCLX"  varchar(3),"DJZCLXMC"  varchar(50),"HY"  varchar(6),"HYMC"  varchar(50),"SBYF"  varchar(6),"GSGBZE"  FLOAT,"SFSS"  CHAR(1),"GXSJ"  DATETIME,"GXBZ"  INTEGER,PRIMARY KEY ("QYID" ASC));
3=INSERT INTO EP_QYDSXX ("QYID","KJYWRMC","KJYWRBM","NSRSBH" ,"ZGSWJG","ZGSWJGMC" ,"YZBM" ,"DZ" ,"DH","DZXX","CWFZR" ,"FRDB","DJZCLX" ,"DJZCLXMC","HY","HYMC" ,"SBYF" ,"GSGBZE" ,"SFSS" ,"GXSJ" ,"GXBZ") SELECT QYID,KJYWRMC,KJYWRBM,NSRSBH ,ZGSWJG,ZGSWJGMC ,YZBM ,DZ ,DH,DZXX,CWFZR ,FRDB,DJZCLX ,DJZCLXMC,HY,HYMC ,SBYF ,GSGBZE ,SFSS ,GXSJ ,GXBZ FROM EP_QYDSXXOld
4=DROP TABLE EP_QYDSXXOld