Posted on 2011-12-17 16:00
哈希 阅读(142)
评论(0) 编辑 收藏 所属分类:
sql 总结
--修改TB_C_ACCOUNT_INFO中金账户信息，增加字段：收款人名称、收款人电话。
--返厂单表 TB_E_BACKFACTORY_BILLS 删除字段：基础金价、产成品ID CHAR(14 BYTE)
--alter table TB_E_BACKFACTORY_BILLS drop column CREATETIME;
--alter table TB_E_BACKFACTORY_BILLS add CREATETIME CHAR(14 BYTE) not null;
--2 alter table TB_E_BACKFACTORY_BILLS drop column FINISH_PRODUCT_ID;
alter table TB_E_BACKFACTORY_BILLS add FACTORY VARCHAR2(64) not null;
--3alter table TB_E_BACKFACTORY_BILLS add PAYEENAME VARCHAR2(64) not null;
--alter table TB_E_BACKFACTORY_BILLS add FACTORY VARCHAR2(64);
--alter table TB_E_BACKFACTORY_BILLS add description VARCHAR2(64);
--comment on column tb_e_backfactory_bills.description is '备注'; "CREATETIME" CHAR(14 BYTE) NOT NULL ENABLE,
--4 alter table TB_E_BACKFACTORY_BILLS add PAYEETEL VARCHAR2(30) not null;
--5 alter table TB_E_BACKFACTORY_BILLS add ACCOUNT VARCHAR2(64) not null;
--6 alter table TB_E_BACKFACTORY_BILLS add RETURNDATE CHAR(14) not null;
--7 comment on column TB_E_BACKFACTORY_BILLS.PAYEENAME is '收款人名称';
--8 comment on column TB_E_BACKFACTORY_BILLS.PAYEETEL is '收款人电话';
--9 comment on column TB_E_BACKFACTORY_BILLS.ACCOUNT is '银行帐号';
--10 comment on column TB_E_BACKFACTORY_BILLS.RETURNDATE is '返厂日期';
--11alter table TB_L_FINPRODU_FINISH_PRODUCT drop column REMARK
--12 alter table TB_L_FINPRODU_FINISH_PRODUCT modify AGENCYBUYPRICE default 0 not null;
--13 alter table TB_L_FINPRODU_FINISH_PRODUCT add AGENCYBUYTOTAL NUMBER(15,4) default 0 not null;
--14 alter table TB_L_FINPRODU_FINISH_PRODUCT add BASEPRICE NUMBER(15,4) default 0 not null;
--15 alter table TB_L_FINPRODU_FINISH_PRODUCT add BASEPRICETOTAL NUMBER(15,4) default 0 not null;
--16 comment on column TB_L_FINPRODU_FINISH_PRODUCT.AGENCYBUYTOTAL is '代回购价格合计';
--17 comment on column TB_L_FINPRODU_FINISH_PRODUCT.BASEPRICE is '基础价格';
--18comment on column TB_L_FINPRODU_FINISH_PRODUCT.BASEPRICETOTAL is '基础价格合计';
--0alter table TB_C_ACCOUNT_INFO add RECEIVERNAME VARCHAR2(64) not null;
--alter table TB_C_ACCOUNT_INFO add RECEIVERTELEPHONE VARCHAR2(64) ;
---comment on column TB_C_ACCOUNT_INFO.RECEIVERNAME is '收款人名称';