-- ABS-76810 / ABS-77343
ALTER TABLE CONTRACTATTRIBUTE DROP CONSTRAINT GROUPNUMBER_VALID1_1;

COMMENT ON COLUMN CONTRACTATTRIBUTE.GROUPNUMBER IS '1 = Miscellaneous
2 = Garments - Settings
3 = Garments – Locker Management
4 = Garments - Charges
5 = Garments – Wearer Functions
6 = Garments – Emblem Templates
7 = Invoicing
8 = Payment
9 = Residential
10 = Contract Product – Billing
11 = Contract Product – Pricing
12 = Contract Product – Logistics
13 = Contract Product – Miscellaneous
14 = Contract Product - Budget Protection
15 = Contract Product – ImageCare
16 = Emblem Template
17 = Wearer Functions';

ALTER TABLE CONTRACTATTRIBUTE ADD CONSTRAINT GROUPNUMBER_VALID1_1 CHECK (GROUPNUMBER BETWEEN 1 AND 17);

