-- order 502899 (new Lotus order: 20010619.40)  


ALTER TABLE PACKCONTENTS ADD (
       ALLOWPACKCONTENTS    NUMBER(1) DEFAULT 0 NOT NULL
                                   CONSTRAINT AllowPackContents_Valid
                                          CHECK (ALLOWPACKCONTENTS IN (0, 1, 2, 3))
);


COMMENT ON COLUMN PACKCONTENTS.ALLOWPACKCONTENTS IS '0 = Allow general pool only
1 = Allow customer related pool
2 = Allow wearer related items
3 = Allow customer related pool and wearer related items';
