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);