-- ABS-28797
-- RESVALSCHEMEDEFINITION
ALTER TABLE RESVALSCHEMEDEFINITION ADD (ENDPERCENTAGE_TEMP NUMBER(16,3));
UPDATE RESVALSCHEMEDEFINITION SET ENDPERCENTAGE_TEMP=ENDPERCENTAGE;
COMMIT;
UPDATE RESVALSCHEMEDEFINITION SET ENDPERCENTAGE=NULL;
COMMIT;
ALTER TABLE RESVALSCHEMEDEFINITION MODIFY (ENDPERCENTAGE NUMBER(16,3));
UPDATE RESVALSCHEMEDEFINITION SET ENDPERCENTAGE=ENDPERCENTAGE_TEMP;
COMMIT;
ALTER TABLE RESVALSCHEMEDEFINITION DROP COLUMN ENDPERCENTAGE_TEMP;
------------------------------------------------------------------------------
ALTER TABLE RESVALSCHEMEDEFINITION ADD (STARTPERCENTAGE_TEMP NUMBER(16,3));
UPDATE RESVALSCHEMEDEFINITION SET STARTPERCENTAGE_TEMP=STARTPERCENTAGE;
COMMIT;
UPDATE RESVALSCHEMEDEFINITION SET STARTPERCENTAGE=NULL;
COMMIT;
ALTER TABLE RESVALSCHEMEDEFINITION MODIFY (STARTPERCENTAGE NUMBER(16,3));
UPDATE RESVALSCHEMEDEFINITION SET STARTPERCENTAGE=STARTPERCENTAGE_TEMP;
COMMIT;
ALTER TABLE RESVALSCHEMEDEFINITION DROP COLUMN STARTPERCENTAGE_TEMP;
------------------------------------------------------------------------------
ALTER TABLE RESVALSCHEMEDEFINITION ADD (FIXEDPERCENTAGE_TEMP NUMBER(16,3));
UPDATE RESVALSCHEMEDEFINITION SET FIXEDPERCENTAGE_TEMP=FIXEDPERCENTAGE;
COMMIT;
UPDATE RESVALSCHEMEDEFINITION SET FIXEDPERCENTAGE=NULL;
COMMIT;
ALTER TABLE RESVALSCHEMEDEFINITION MODIFY (FIXEDPERCENTAGE NUMBER(16,3));
UPDATE RESVALSCHEMEDEFINITION SET FIXEDPERCENTAGE=FIXEDPERCENTAGE_TEMP;
COMMIT;
ALTER TABLE RESVALSCHEMEDEFINITION DROP COLUMN FIXEDPERCENTAGE_TEMP;
-------------------------------------------------------------------------------
-- OUTOFCIRCULATIONHISTORY
ALTER TABLE OUTOFCIRCULATIONHISTORY MODIFY (THEORETICALPERCENTAGE NULL);
ALTER TABLE OUTOFCIRCULATIONHISTORY ADD (THEORETICALPERCENTAGE_TEMP NUMBER(19,6));
UPDATE OUTOFCIRCULATIONHISTORY SET THEORETICALPERCENTAGE_TEMP=THEORETICALPERCENTAGE;
COMMIT;
UPDATE OUTOFCIRCULATIONHISTORY SET THEORETICALPERCENTAGE=NULL;
COMMIT;
ALTER TABLE OUTOFCIRCULATIONHISTORY MODIFY (THEORETICALPERCENTAGE NUMBER(19,6));
UPDATE OUTOFCIRCULATIONHISTORY SET THEORETICALPERCENTAGE=THEORETICALPERCENTAGE_TEMP;
COMMIT;
ALTER TABLE OUTOFCIRCULATIONHISTORY DROP COLUMN THEORETICALPERCENTAGE_TEMP;
ALTER TABLE OUTOFCIRCULATIONHISTORY MODIFY (THEORETICALPERCENTAGE NOT NULL);
------------------------------------------------------------------------------
ALTER TABLE OUTOFCIRCULATIONHISTORY MODIFY (ENTEREDPERCENTAGE NULL);
ALTER TABLE OUTOFCIRCULATIONHISTORY ADD (ENTEREDPERCENTAGE_TEMP NUMBER(19,6));
UPDATE OUTOFCIRCULATIONHISTORY SET ENTEREDPERCENTAGE_TEMP=ENTEREDPERCENTAGE;
COMMIT;
UPDATE OUTOFCIRCULATIONHISTORY SET ENTEREDPERCENTAGE=NULL;
COMMIT;
ALTER TABLE OUTOFCIRCULATIONHISTORY MODIFY (ENTEREDPERCENTAGE NUMBER(19,6));
UPDATE OUTOFCIRCULATIONHISTORY SET ENTEREDPERCENTAGE=ENTEREDPERCENTAGE_TEMP;
COMMIT;
ALTER TABLE OUTOFCIRCULATIONHISTORY DROP COLUMN ENTEREDPERCENTAGE_TEMP;
ALTER TABLE OUTOFCIRCULATIONHISTORY MODIFY (ENTEREDPERCENTAGE NOT NULL);
------------------------------------------------------------------------------
ALTER TABLE OUTOFCIRCULATIONHISTORY MODIFY (TOBECHARGEDPERCENTAGE NULL);
ALTER TABLE OUTOFCIRCULATIONHISTORY ADD (TOBECHARGEDPERCENTAGE_TEMP NUMBER(19,6));
UPDATE OUTOFCIRCULATIONHISTORY SET TOBECHARGEDPERCENTAGE_TEMP=TOBECHARGEDPERCENTAGE;
COMMIT;
UPDATE OUTOFCIRCULATIONHISTORY SET TOBECHARGEDPERCENTAGE=NULL;
COMMIT;
ALTER TABLE OUTOFCIRCULATIONHISTORY MODIFY (TOBECHARGEDPERCENTAGE NUMBER(19,6));
UPDATE OUTOFCIRCULATIONHISTORY SET TOBECHARGEDPERCENTAGE=TOBECHARGEDPERCENTAGE_TEMP;
COMMIT;
ALTER TABLE OUTOFCIRCULATIONHISTORY DROP COLUMN TOBECHARGEDPERCENTAGE_TEMP;
ALTER TABLE OUTOFCIRCULATIONHISTORY MODIFY (TOBECHARGEDPERCENTAGE NOT NULL);
-----------------------------------------------------------------------------------
-- GARMENTSALESHISTORY
ALTER TABLE GARMENTSALESHISTORY MODIFY (RESVALPERCENTAGE NULL);
ALTER TABLE GARMENTSALESHISTORY ADD (RESVALPERCENTAGE_TEMP NUMBER(16,3));
UPDATE GARMENTSALESHISTORY SET RESVALPERCENTAGE_TEMP=RESVALPERCENTAGE;
COMMIT;
UPDATE GARMENTSALESHISTORY SET RESVALPERCENTAGE=NULL;
COMMIT;
ALTER TABLE GARMENTSALESHISTORY MODIFY (RESVALPERCENTAGE NUMBER(16,3));
UPDATE GARMENTSALESHISTORY SET RESVALPERCENTAGE=RESVALPERCENTAGE_TEMP;
COMMIT;
ALTER TABLE GARMENTSALESHISTORY DROP COLUMN RESVALPERCENTAGE_TEMP;
ALTER TABLE GARMENTSALESHISTORY MODIFY (RESVALPERCENTAGE NOT NULL);