29 lines
1.0 KiB
SQL
29 lines
1.0 KiB
SQL
alter table PICK_TICKET_DETAIL add (REAL_WEIGHT float);
|
|
alter table PLAN_PICK_TICKET_DETAIL add (REAL_WEIGHT float);
|
|
|
|
alter table MASTER_BOL add (COMPANY_ID NUMBER(19));//添加货主字段
|
|
alter table MASTER_BOL
|
|
add constraint FK39D7EE13EE360C29 foreign key (COMPANY_ID)
|
|
references STRUCTURE (ID);
|
|
|
|
/**10.27*/
|
|
alter table MOVE_DOC add (RELATED_BILL1 varchar(255)) ;
|
|
alter table MOVE_DOC add (DESCRIPTION varchar(500)) ;
|
|
|
|
/**2020-04-27*/
|
|
alter table STRUCTURE add (IS_EXAMINE NUMBER(1));
|
|
alter table STRUCTURE add (IS_BATCH NUMBER(1));
|
|
alter table ITEM add (BOX_VOLUME FLOAT);
|
|
|
|
/**2020-05-06*/
|
|
alter table INVENTORY add (BE_LOCK number(1));
|
|
alter table INVENTORY add (BE_REJECT number(1));
|
|
UPDATE INVENTORY SET BE_LOCK=0,BE_REJECT=0 WHERE BE_LOCK is null
|
|
|
|
/**2020-05-07*/
|
|
alter table STRUCTURE add (IS_PRODUCT NUMBER(1));
|
|
update STRUCTURE set IS_PRODUCT=0 where IS_PRODUCT is null
|
|
|
|
/**常备库存，预备标识*/
|
|
ALTER TABLE pinfan add (cb_qty BIGINT,be_yb BIGINT);
|
|
update pinfan set cb_qty=0, be_yb=0; |