-- ABS-18687 / ABS-27029

---UHFREADERCONFIGURATION table---
ALTER TABLE UHFREADERCONFIGURATION ADD (ANTENNAHUB VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT YN_VALIDATIONFIELD279
                                        CHECK (ANTENNAHUB IN ('Y', 'N')));

---UHFANTENNACONFIGURATION table---
ALTER TABLE UHFANTENNACONFIGURATION MODIFY (ANTENNANUMBER NUMBER(2));
 
ALTER TABLE UHFANTENNACONFIGURATION
  DROP CONSTRAINT ANTENNANUMBER_VALID1;
ALTER TABLE UHFANTENNACONFIGURATION
  ADD CONSTRAINT ANTENNANUMBER_VALID1
  CHECK (ANTENNANUMBER BETWEEN 1 AND 32);