-- ABS-42798 / ABS-46375

----------- PRODUCTLISTPERCUSTOMER -----------
ALTER TABLE PRODUCTLISTPERCUSTOMER ADD (MAXIMUMNUMBEROFREPAIRS NUMBER DEFAULT 0 NOT NULL);

----------- PRODUCT -----------
ALTER TABLE PRODUCT ADD (MAXIMUMNUMBEROFREPAIRS NUMBER DEFAULT 0 NOT NULL);

----------- AUTOMATICFLAG -----------
INSERT INTO AUTOMATICFLAG
          (AUTOMATICFLAG_ID,
           EVENT,
           SYSTEMUSER_ID,
           TIMESTAMP,
           SELECTABLE,
           DELETABLE,
           TRANSFERABLE,
           FLAGTYPE)
      SELECT SEQ_AUTOMATICFLAG.Nextval,
           'Maximum Number of Repairs',
           GETMINSYSTEMUSER(),
           GETCURRENTDATETIME(),
           'N',
           'N',
           'Y',
            1 FROM DUAL;
COMMIT;
