-- order 502858 (new Lotus order: 20010600.30)


ALTER  TABLE STOP  ADD ROUTELISTINSTRUCTIONSCOPY CLOB ;
   
UPDATE STOP  SET ROUTELISTINSTRUCTIONSCOPY =ROUTELISTINSTRUCTIONS  WHERE ROUTELISTINSTRUCTIONS is not null;    
COMMIT;  

ALTER  TABLE STOP DROP COLUMN ROUTELISTINSTRUCTIONS;

ALTER  TABLE STOP RENAME COLUMN ROUTELISTINSTRUCTIONSCOPY to ROUTELISTINSTRUCTIONS;



ALTER  TABLE ROUTESTOP  ADD ROUTELISTINSTRUCTIONSCOPY CLOB ;
  
UPDATE ROUTESTOP  SET ROUTELISTINSTRUCTIONSCOPY =ROUTELISTINSTRUCTIONS WHERE ROUTELISTINSTRUCTIONS is not null;
COMMIT;

ALTER  TABLE ROUTESTOP DROP COLUMN ROUTELISTINSTRUCTIONS;
                                                    
ALTER  TABLE ROUTESTOP RENAME COLUMN ROUTELISTINSTRUCTIONSCOPY to ROUTELISTINSTRUCTIONS;



ALTER  TABLE ISAPEXPORT  ADD ERRORMSGCOPY CLOB ;  
 
UPDATE ISAPEXPORT  SET ERRORMSGCOPY =ERRORMSG WHERE ERRORMSG is not null;
COMMIT;
                                                    
ALTER  TABLE ISAPEXPORT DROP COLUMN ERRORMSG;

ALTER  TABLE ISAPEXPORT RENAME COLUMN ERRORMSGCOPY to ERRORMSG;



ALTER  TABLE CUSTOMERUSERINSTRUCTION_DESC  ADD INSTRUCTIONCOPY  CLOB ;
 
UPDATE CUSTOMERUSERINSTRUCTION_DESC  SET INSTRUCTIONCOPY =INSTRUCTION WHERE INSTRUCTION is not null;
COMMIT;
                                               
ALTER  TABLE CUSTOMERUSERINSTRUCTION_DESC DROP COLUMN INSTRUCTION ;

ALTER  TABLE CUSTOMERUSERINSTRUCTION_DESC RENAME COLUMN INSTRUCTIONCOPY to INSTRUCTION;



ALTER  TABLE GENERALUSERINSTRUCTION_DESC  ADD INSTRUCTIONCOPY  CLOB ;
 
UPDATE GENERALUSERINSTRUCTION_DESC  SET INSTRUCTIONCOPY =INSTRUCTION WHERE INSTRUCTION is not null;
COMMIT;
                                                   
ALTER  TABLE GENERALUSERINSTRUCTION_DESC DROP COLUMN INSTRUCTION ;

ALTER TABLE GENERALUSERINSTRUCTION_DESC  RENAME COLUMN INSTRUCTIONCOPY to INSTRUCTION; 




ALTER  TABLE DBCONSISTENCYCHECK  ADD  SQLSTATEMENTCOPY  CLOB ;
 
UPDATE DBCONSISTENCYCHECK  SET SQLSTATEMENTCOPY =SQLSTATEMENT WHERE SQLSTATEMENT is not null;
COMMIT;
                                                    
ALTER  TABLE DBCONSISTENCYCHECK DROP COLUMN SQLSTATEMENT ;

ALTER TABLE DBCONSISTENCYCHECK  RENAME COLUMN SQLSTATEMENTCOPY to SQLSTATEMENT; 

