/*order 502357*/

ALTER TABLE DELIVERYSIGNATURE DROP CONSTRAINT DELIVERYSIGNATURE_STOP_ID;

      
      /*
      CHANGE REPORT for Table DELIVERYSIGNATURE
          - Changing definition of relation DELIVERYSIGNATURE_STOP_ID
          - change datatype from VARCHAR2(6) to VARCHAR2(30), change null constraint from NOT NULL to NULL of column PERSONIDENTIFICATION
          - change null constraint from NOT NULL to NULL of column SIGNATURE
          - Adding column GPSTIME
          - Adding column GPSWIDTH
          - Adding column GPSLENGTH
          - Changing definition of index XPKDELIVERYSIGNATURE
          - Changing primary key
      ACTION is ALTER or modify Table DELIVERYSIGNATURE
      */

ALTER TABLE DELIVERYSIGNATURE MODIFY (PERSONIDENTIFICATION VARCHAR2(30) NULL);


ALTER TABLE DELIVERYSIGNATURE MODIFY (SIGNATURE NULL);


ALTER TABLE DELIVERYSIGNATURE ADD (GPSTIME              VARCHAR2(12) NULL);


ALTER TABLE DELIVERYSIGNATURE ADD (GPSWIDTH             VARCHAR2(12) NULL);


ALTER TABLE DELIVERYSIGNATURE ADD (GPSLENGTH            VARCHAR2(12) NULL);


ALTER TABLE DELIVERYSIGNATURE
       ADD  ( CONSTRAINT DELIVERYSIGNATURE_STOP_ID
              FOREIGN KEY (STOP_ID)
                             REFERENCES STOP
                             ON DELETE CASCADE ) ;


insert into process(process_id,description,active) values ('81','Import Route Info from PDS','Y');
