--ABS-157570

--PRODUCTIONCUSTOMER TABLE
ALTER TABLE PRODUCTIONCUSTOMER ADD (DIRECTLOAD     VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT CHK_PRODUCTIONCUSTOMER_DIRECTLOAD CHECK (DIRECTLOAD IN ('Y', 'N')),
                                    PRINTUBSTICKER VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT CHK_PRODUCTIONCUSTOMER_PRINTUBSTICKER CHECK (PRINTUBSTICKER IN ('Y', 'N')));
COMMENT ON COLUMN PRODUCTIONCUSTOMER.PRINTUBSTICKER IS 'UB = Unique Bundle';

--PRODUCTIONQUEUE
ALTER TABLE PRODUCTIONQUEUE ADD (IMMEDIATELOAD VARCHAR2(1) DEFAULT 'N' NOT NULL CONSTRAINT CHK_PRODUCTIONQUEUE_IMMEDIATELOAD CHECK (IMMEDIATELOAD IN ('Y', 'N')));
