-- ABS-119014/ ABS-133238

ALTER TABLE CITYCOUNTY ADD (ACTIVE VARCHAR2(1) DEFAULT 'Y' NOT NULL
                                   CONSTRAINT CHK_CITYCOUNTY_ACTIVE CHECK (ACTIVE IN ('Y', 'N')));

ALTER TABLE STATES ADD (ACTIVE VARCHAR2(1) DEFAULT 'Y' NOT NULL
                               CONSTRAINT CHK_STATES_ACTIVE CHECK (ACTIVE IN ('Y', 'N')));