-- ABS-67158

-- CSVEXPORT  TABLE--
ALTER TABLE CSVEXPORT ADD (WEARERNUMBERCOPY NUMBER NULL);

UPDATE CSVEXPORT SET WEARERNUMBERCOPY = WEARERNUMBER WHERE WEARERNUMBER IS NOT NULL;
COMMIT;

UPDATE CSVEXPORT SET WEARERNUMBER = NULL WHERE WEARERNUMBER IS NOT NULL;
COMMIT;

ALTER TABLE CSVEXPORT MODIFY (WEARERNUMBER VARCHAR2(10));

UPDATE CSVEXPORT SET WEARERNUMBER = WEARERNUMBERCOPY WHERE WEARERNUMBERCOPY IS NOT NULL;
COMMIT;

ALTER TABLE CSVEXPORT DROP COLUMN WEARERNUMBERCOPY;