--order 502598      
      /*
      CHANGE REPORT for Table SURVEYSCORE
          - Adding column RANDOMSURVEYCONTACTPERSON
          - Changing definition of index XAK1SURVEYSCORE
      ACTION is ALTER or modify Table SURVEYSCORE
      */

DROP INDEX XAK1SURVEYSCORE;


ALTER TABLE SURVEYSCORE ADD (RANDOMSURVEYCONTACTPERSON VARCHAR2(30) NULL);

CREATE UNIQUE INDEX XAK1SURVEYSCORE ON SURVEYSCORE
(
       SURVEYDATE                     ASC,
       CUSTOMER_LINK_ID               ASC,
       SURVEYTYPEQUESTION_ID          ASC,
       CONTACTPERSON_ID               ,
       RANDOMSURVEYCONTACTPERSON      
);

