<?xml version="1.0" encoding="utf-8" ?>
<SQLs>
  <sql>
    <descript>添加字典的小区编号</descript>
    <CommandText>ALTER TABLE T_DICT ADD AID varchar default ''</CommandText>
  </sql>
  <sql>
    <descript>添加收费大类小区编号</descript>
    <CommandText>ALTER TABLE t_a0_feeclass ADD AID varchar default ''</CommandText>
  </sql>
  <sql>
    <descript>添加收费项目小区编号</descript>
    <CommandText>ALTER TABLE t_a0_feeitems ADD AID varchar default ''</CommandText>
  </sql>
  <sql>
    <descript>添加阶梯方案小区编号</descript>
    <CommandText>ALTER TABLE t_a0_stepplan ADD AID varchar default ''</CommandText>
  </sql>
  <sql>
    <descript>添加收费凭证表小区编号</descript>
    <CommandText>ALTER TABLE t_b2_pay ADD AID varchar default ''</CommandText>
  </sql>
  <sql>
    <descript>添加业主家庭成员表</descript>
    <CommandText>Create  TABLE t_a3_customerFamily(CID varchar(40),ID varchar(40) PRIMARY KEY,NAME varchar(40),TEL varchar(20),GX varchar(20),DESCRIPT varchar(80),SEX varchar(2),BIRTHDAY varchar(10),AID varchar(40))</CommandText>
  </sql>
  <sql>
    <descript>添加业主收费项目表小区编号</descript>
    <CommandText>ALTER TABLE t_a4_customerFees ADD AID  varchar default ''</CommandText>
  </sql>
  <sql>
    <descript>添加物业类型收费标准表小区编号</descript>
    <CommandText>ALTER TABLE t_a0_wytype ADD AID varchar default ''</CommandText>
  </sql>
  <sql>
    <descript>添加收费计算公式表</descript>
    <CommandText>Create  TABLE t_a0_formula(AID varchar,ID varchar PRIMARY KEY,NAME varchar,FORMULA varchar)</CommandText>
  </sql>
  <sql>
    <descript>添加收费调整追加字段</descript>
    <CommandText>ALTER TABLE t_b1_fees ADD ZJ decimal default 0</CommandText>
  </sql>
  <sql>
    <descript>添加成本费用信息表</descript>
    <CommandText>Create  TABLE t_d1_cost(ID varchar(40) PRIMARY KEY,AID varchar(40),COSTTYPE varchar(30),REGDATE varchar(10),MONEY decimal,CAPTION varchar(40),CONTENT varchar(800),REGER varchar(40))</CommandText>
  </sql>
  <sql>
    <descript>添加额外收入信息表</descript>
    <CommandText>Create  TABLE t_e1_income(ID varchar(40) PRIMARY KEY,AID varchar(40),COSTTYPE varchar(30),REGDATE varchar(10),MONEY decimal,CAPTION varchar(40),CONTENT varchar(800),REGER varchar(40))</CommandText>
  </sql> 
  <sql>
    <descript>添加作废单据字段</descript>
    <CommandText>ALTER TABLE T_USERS ADD INVALID varchar(5) default '0'</CommandText>
  </sql> 
  <sql>
    <descript>收费凭证表添加作废字段</descript>
    <CommandText>ALTER TABLE t_b2_pay ADD INVALID varchar(5) default '0'</CommandText>
  </sql>
  <sql>
    <descript>收费明细表添加作废字段</descript>
    <CommandText>ALTER TABLE t_b1_fees ADD INVALID varchar(5) default '0'</CommandText>
  </sql>
  <sql>
    <descript>添加分摊关系表</descript>
    <CommandText>Create  TABLE t_a5_sharenet(ID varchar(40) PRIMARY KEY,SID varchar(40),CID varchar(40),AID varchar(40),QTY decimal DEFAULT 1)</CommandText>
  </sql>   
  <sql>
    <descript>添加分摊表码</descript>
    <CommandText>Create  TABLE t_a5_shareBM([ID] varchar(40) PRIMARY KEY,[SID] varchar(40),[BDATE] varchar(10),[EDATE] varchar(10),[QM] decimal,[ZM] decimal,[ZJ] decimal,[QTY] decimal,CDATE varchar(10))</CommandText>
  </sql>
  <sql>
    <descript>删除唯一萦引</descript>
    <CommandText>drop INDEX unique_t_b1_fees_CIDCDATEFID</CommandText>
  </sql>
  <sql>
    <descript>新增唯一萦引</descript>
    <CommandText>create Unique INDEX unique_t_b1_fees_CIDCDATEFID On t_b1_fees (CID ,FID ,DESCRIPT ,BDATE ,INVALID )</CommandText>
  </sql>
  <sql>
    <descript>新增倍率字段</descript>
    <CommandText>ALTER TABLE t_b1_fees ADD BLL decimal default 1</CommandText>
  </sql>
  <sql>
    <descript>新增业主关联名字段</descript>
    <CommandText>ALTER TABLE t_a3_customer ADD GROUPNAME varchar(40) default ''</CommandText>
  </sql>
  <sql>
    <descript>新增小区保留小数位数</descript>
    <CommandText>ALTER TABLE t_a1_plot ADD dec int default 2</CommandText>
  </sql> 
  <sql>
    <descript>新增小区打单时是否计算违约金</descript>
    <CommandText>ALTER TABLE t_a1_plot ADD ZNJ varchar(1) default '1'</CommandText>
  </sql>
  <sql>
    <descript>新增费用科目表</descript>
    <CommandText>Create TABLE t_a0_subjects(ID varchar(40) PRIMARY KEY,NAME varchar(200),PID varchar(20),DESCRIPT varchar(300),TYPE varchar(1) default '1',ORD int)</CommandText>
  </sql>
  <sql>
    <descript>新增其它收入付款方式15-12-19</descript>
    <CommandText>ALTER TABLE t_e1_income ADD PAYSTYLE varchar default '现金'</CommandText>
  </sql>
  <sql>
    <descript>新增收费单有序单号（按收费员编号）</descript>
    <CommandText>ALTER TABLE t_b2_pay ADD OID varchar(32) default '00000000'</CommandText>
  </sql>
  <sql>
    <descript>新增用户权限范围字段</descript>
    <CommandText>ALTER TABLE t_users ADD RANGE1 varchar</CommandText>
  </sql>
  <sql>
    <descript>新增其它收入收费序号</descript>
    <CommandText>ALTER TABLE t_e1_income ADD OID varchar(32) default '00000000'</CommandText>
  </sql>
  <sql>
    <descript>新增服务维修单序号</descript>
    <CommandText>ALTER TABLE t_c1_protect ADD OID varchar(32) default '00000000'</CommandText>
  </sql> 
  <sql>
    <descript>新增成本单序号</descript>
    <CommandText>ALTER TABLE t_d1_cost ADD OID varchar(32) default '00000000'</CommandText>
  </sql>
  <sql>
    <descript>新增小区打单时计算违约金逾期时长</descript>
    <CommandText>ALTER TABLE t_a1_plot ADD ZNJDAY varchar(3) default '10'</CommandText>
  </sql>
  <sql>
    <descript>新增定义收费项目时确定是否计算违约金</descript>
    <CommandText>ALTER TABLE t_a0_feeItems ADD ZNJ varchar(2) default '0'</CommandText>
  </sql>
  <sql>
    <descript>新增定义收费项目时确定计算违约金逾期时长</descript>
    <CommandText>ALTER TABLE t_a0_feeItems ADD ZNJDAY varchar(3) default '10'</CommandText>
  </sql>
  <sql>
    <descript>新增用户优惠权限</descript>
    <CommandText>ALTER TABLE t_users ADD YH varchar(5) default '0'</CommandText>
  </sql>
</SQLs>