--ABSN-1732
ALTER TABLE A_TABLELIST ADD(AUDIT_INSERT VARCHAR2(1) DEFAULT 'Y' NOT NULL,
AUDIT_UPDATE  VARCHAR2(1) DEFAULT 'Y' NOT NULL,
AUDIT_DELETE  VARCHAR2(1) DEFAULT 'Y' NOT NULL);

ALTER TABLE A_TABLELIST
  ADD CONSTRAINT CHK_INDX_A_TABLELIST_AUDIT_IID
  CHECK ((AUDIT_INSERT = 'Y' OR AUDIT_UPDATE ='Y' OR AUDIT_DELETE ='Y'));
ALTER TABLE A_TABLELIST
  ADD CONSTRAINT CHK_INDX_A_TABLELIST_AUDIT_INSERT
  CHECK (AUDIT_INSERT IN ('Y','N'));
ALTER TABLE A_TABLELIST
  ADD CONSTRAINT CHK_INDX_A_TABLELIST_AUDIT_UPDATE
  CHECK (AUDIT_UPDATE IN ('Y','N'));
ALTER TABLE A_TABLELIST
  ADD CONSTRAINT CHK_INDX_A_TABLELIST_AUDIT_DELETE
  CHECK (AUDIT_DELETE IN ('Y','N'));

COMMENT ON COLUMN A_TABLELIST.AUDIT_INSERT
  IS 'Default Y, options Y or N, when set to N inserts will not be audited!';
COMMENT ON COLUMN A_TABLELIST.AUDIT_UPDATE
  IS 'Default Y, options Y or N, when set to N updates will not be audited!';
COMMENT ON COLUMN A_TABLELIST.AUDIT_DELETE
  IS 'Default Y, options Y or N, when set to N deletes will not be audited!';
