8 lines
380 B
MySQL
8 lines
380 B
MySQL
|
alter table TMS_ROUTE_FEE add TRANSPORTATIONAGING8 float;
|
||
|
|
update TMS_ROUTE_FEE set TRANSPORTATIONAGING8=0 where TRANSPORTATIONAGING8 is null;
|
||
|
|
alter table TMS_TRANS_LOCATION add Brand VARCHAR2(50);
|
||
|
|
|
||
|
|
alter table BMS_CONTRACT_RATE add (ZONE_ID NUMBER(19));
|
||
|
|
alter table BMS_CONTRACT_RATE
|
||
|
|
add constraint FK351215568D25E36D foreign key (ZONE_ID)
|
||
|
|
references TMS_ZONE (ID);
|