-- ABS-7335 Linen Assistant Android: Extend with 2 scan screens ABS-9437

ALTER TABLE CUSTOMER ADD (RECEIVEFROMLAUNDRYSCAN VARCHAR2(1) DEFAULT 'N' NOT NULL);
ALTER TABLE CUSTOMER ADD (SENDTOLAUNDRYSCAN VARCHAR2(1) DEFAULT 'N' NOT NULL);

ALTER TABLE CUSTOMER
  ADD CONSTRAINT YN_VALIDATIONFIELD240
  CHECK (RECEIVEFROMLAUNDRYSCAN IN ('Y', 'N'));
ALTER TABLE CUSTOMER
  ADD CONSTRAINT YN_VALIDATIONFIELD241
  CHECK (SENDTOLAUNDRYSCAN IN ('Y', 'N'));