-- order 502646 (analysis changed)

      /*
      CHANGE REPORT for Table DATABASESCRIPTEXECUTION
          - Adding column DATABASESCRIPTEXECUTION_ID
          - Adding index XAK1DATABASESCRIPTEXECUTION
          - Changing definition of index XPKDATABASESCRIPTEXECUTION
          - Changing primary key
          WARNING : Drop PK of table DATABASESCRIPTEXECUTION will fail if there are any FKs that reference the table and are not on the DB Sync - Resolve Differences list.
      ACTION is ALTER or modify Table DATABASESCRIPTEXECUTION
      */

ALTER TABLE DATABASESCRIPTEXECUTION DROP PRIMARY KEY CASCADE;


ALTER TABLE DATABASESCRIPTEXECUTION ADD (DATABASESCRIPTEXECUTION_ID NUMBER NOT 
    NULL);

CREATE UNIQUE INDEX XAK1DATABASESCRIPTEXECUTION ON DATABASESCRIPTEXECUTION
(
       DATABASESCRIPT_ID              ,
       SYSTEMUSER_ID                  ,
       TIMESTAMP                      
);


ALTER TABLE DATABASESCRIPTEXECUTION
       ADD  ( CONSTRAINT XPKDATABASESCRIPTEXECUTION PRIMARY KEY (
              DATABASESCRIPTEXECUTION_ID) ) ;

