Posted on 2011-12-17 16:00
哈希 閱讀(146)
評論(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 '收款人名稱';