--ABS-153450
UPDATE A_TABLELIST
SET TABLENAME = TRIM(UPPER(TABLENAME))
WHERE TABLENAME <> TRIM(UPPER(TABLENAME));

UPDATE A_TABLELIST
SET A_TABLENAME = TRIM(UPPER(A_TABLENAME))
WHERE A_TABLENAME <> TRIM(UPPER(A_TABLENAME));

COMMIT;

ALTER TABLE A_TABLELIST ADD CONSTRAINT CHK_INDX_A_TABLELIST_ATABLENAME CHECK (SUBSTR(A_TABLENAME,1,2) = 'A_');
ALTER TABLE A_TABLELIST ADD CONSTRAINT CHK_INDX_A_TABLELIST_DAYS_TO_KEEP CHECK (DAYS_TO_KEEP >= 1);
ALTER TABLE A_TABLELIST ADD CONSTRAINT CHK_INDX_A_TABLELIST_HISTORY_DAYS CHECK (HISTORY_DAYS >= 1);
ALTER TABLE A_TABLELIST ADD CONSTRAINT CHK_INDX_A_TABLELIST_TABLENAME CHECK (SUBSTR(TABLENAME,1,2) <> 'A_');
ALTER TABLE A_TABLELIST ADD CONSTRAINT CHK_INDX_A_TABLELIST_UATABLENAME CHECK (A_TABLENAME = TRIM(UPPER(A_TABLENAME)));
ALTER TABLE A_TABLELIST ADD CONSTRAINT CHK_INDX_A_TABLELIST_UTABLENAME CHECK (TABLENAME = TRIM(UPPER(TABLENAME)));