--SO 20015287

ALTER TABLE CONTRACTCUSTOMER ADD (PURCHASEORDERNUMBER VARCHAR2(30) NULL);
  
ALTER TABLE CONTRACTCUSTOMER ADD (PURCHASEORDERVALUE NUMBER DEFAULT 0 NOT NULL);

ALTER TABLE CONTRACTCUSTOMER ADD (EXPIRATIONDATE DATE NULL);

DROP INDEX XAK1CONTRACTCUSTOMER;
CREATE UNIQUE INDEX XAK1CONTRACTCUSTOMER ON CONTRACTCUSTOMER
(CONTRACT_ID, CUSTOMER_LINK_ID, STARTDATE);

CREATE INDEX XIE1CONTRACTCUSTOMER ON CONTRACTCUSTOMER
(CONTRACT_ID, PURCHASEORDERNUMBER);

