-- ABS-79212 / ABS-82319
----------------------- DATABASESCRIPT ---------------------------

ALTER TABLE DATABASESCRIPT DROP CONSTRAINT DATABASESCRIPTUSAGE_VALID;
ALTER TABLE DATABASESCRIPT ADD CONSTRAINT CHK_DATABASESCRIPT_USAGE CHECK (USAGE IN (0,1,2,3,4,5));
COMMENT ON COLUMN DATABASESCRIPT.USAGE 
IS '0=Incidental
1=Scheduled
2=Pre/post process
3=User defined query
4=Invoice Script
5=Predefined';

----------------------------- ABSDBENCRYPT ---------------------------

CREATE TABLE ABSDBENCRYPT (ABSDBENCRYPTED VARCHAR2(1) DEFAULT 'N' NOT NULL
                           CONSTRAINT CHK_ABSDBENCRYPT_ABSDBENCRYPTE CHECK (ABSDBENCRYPTED IN('Y','N')));
