--order 502356(from PVD)
-- Add comments to the columns 
comment on column I_PRODUCT.PUTUPTYPE
  is '1 = Put up per customer (Packingnote)
2 = Bulk put up
3 = Packer
4 = Bulk putup scan per route
5 = Packer (Loose Linen)';
-- Create/Recreate check constraints 
alter table I_PRODUCT
  drop constraint PUTUPTYPE_VALIDATION;
alter table I_PRODUCT
  add constraint PUTUPTYPE_VALIDATION
  check (putuptype IN (1, 2, 3, 4, 5));

-- Add comments to the columns 
comment on column I_PRODUCTLISTPERCUSTOMER.SPECIFICPUTUPTYPE
  is '0 = No Specific, inherit from Product
1 = Put up per customer (Packingnote)
2 = Bulk put up
3 = Packer
4 = Bulk putup scan per route
5 = Packer (Loose Linen)';
-- Create/Recreate check constraints 
alter table I_PRODUCTLISTPERCUSTOMER
  drop constraint SPECIFICPUTUPTYPE_VALIDATION15;
alter table I_PRODUCTLISTPERCUSTOMER
  add constraint SPECIFICPUTUPTYPE_VALIDATION15
  check (specificputuptype IN (0, 1, 2, 3, 4, 5));