-- order 502743

/*
      CHANGE REPORT for Table WEBUSER
          - change datatype from VARCHAR2(40) to VARCHAR2(300) of column EMAIL
      ACTION is ALTER or modify Table WEBUSER
      */   

 begin
    execute immediate ('DROP INDEX XIE3WEBUSER');
 exception
    when others then null;
 end;
/

begin
    execute immediate ('DROP INDEX XIF3WEBUSER');
 exception
    when others then null;
 end;
/

ALTER TABLE WEBUSER MODIFY (EMAILADDRESS VARCHAR2(300));


 begin
    execute immediate ('CREATE INDEX XIE1WEBUSER ON WEBUSER (UPPER(EMAILADDRESS))');
 exception
    when others then null;
 end;
/

      /*
      CHANGE REPORT for Table CLIENT
          - change datatype from VARCHAR2(30) to VARCHAR2(300) of column EMAIL
      ACTION is ALTER or modify Table CLIENT
      */

ALTER TABLE CLIENT MODIFY (EMAIL VARCHAR2(300));

      
      /*
      CHANGE REPORT for Table CLIENTCONTACTPERSON
          - change datatype from VARCHAR2(40) to VARCHAR2(300), change unknown attribute from 3 to (empty), change unknown attribute from 40 to (empty) of column EMAIL
      ACTION is ALTER or modify Table CLIENTCONTACTPERSON
      */

ALTER TABLE CLIENTCONTACTPERSON MODIFY (EMAIL VARCHAR2(300));

      
      /*
      CHANGE REPORT for Table CONTACTPERSON
          - change datatype from VARCHAR2(40) to VARCHAR2(300), change unknown attribute from 14 to (empty), change unknown attribute from 91 to (empty) of column EMAIL
      ACTION is ALTER or modify Table CONTACTPERSON
      */

ALTER TABLE CONTACTPERSON MODIFY (EMAIL VARCHAR2(300));

      
      /*
      CHANGE REPORT for Table CUSTOMER
          - change datatype from VARCHAR2(40) to VARCHAR2(300), change unknown attribute from 13 to (empty), change unknown attribute from 86 to (empty), change unknown attribute from 7 to 8, change unknown attribute from 7 to 8 of column EMAIL
      ACTION is ALTER or modify Table CUSTOMER
      */

ALTER TABLE CUSTOMER MODIFY (EMAIL VARCHAR2(300));

      
      /*
      CHANGE REPORT for Table INVOICEJOB
          - change datatype from VARCHAR2(40) to VARCHAR2(300), change unknown attribute from 11 to (empty), change unknown attribute from 69 to (empty) of column EMAILADDRESSSUMMARY
      ACTION is ALTER or modify Table INVOICEJOB
      */

ALTER TABLE INVOICEJOB MODIFY (EMAILADDRESSSUMMARY VARCHAR2(300));

      
      /*
      CHANGE REPORT for Table INVOICEJOBBUSINESSUNIT
          - change datatype from VARCHAR2(40) to VARCHAR2(300), change unknown attribute from 7 to (empty), change unknown attribute from 29 to (empty) of column EMAILADDRESS
      ACTION is ALTER or modify Table INVOICEJOBBUSINESSUNIT
      */

ALTER TABLE INVOICEJOBBUSINESSUNIT MODIFY (EMAILADDRESS VARCHAR2(300));

      
      /*
      CHANGE REPORT for Table PLANT
          - change datatype from VARCHAR2(40) to VARCHAR2(300), change unknown attribute from 11 to (empty), change unknown attribute from 79 to (empty) of column EMAIL
      ACTION is ALTER or modify Table PLANT
      */

ALTER TABLE PLANT MODIFY (EMAIL VARCHAR2(300));

      
      /*
      CHANGE REPORT for Table PLANTCOMPANY
          - change datatype from VARCHAR2(40) to VARCHAR2(300), change unknown attribute from 100 to (empty) of column EMAIL
      ACTION is ALTER or modify Table PLANTCOMPANY
      */

ALTER TABLE PLANTCOMPANY MODIFY (EMAIL VARCHAR2(300));

      
      /*
      CHANGE REPORT for Table SUPPLIER
          - change datatype from VARCHAR2(40) to VARCHAR2(300), change unknown attribute from 11 to (empty), change unknown attribute from 81 to (empty) of column EMAIL
      ACTION is ALTER or modify Table SUPPLIER
      */

ALTER TABLE SUPPLIER MODIFY (EMAIL VARCHAR2(300));

      
      /*
      CHANGE REPORT for Table WEBCATINVOICEHEADERIMP
          - change datatype from VARCHAR2(60) to VARCHAR2(300) of column CONTACTPERSONEMAIL
      ACTION is ALTER or modify Table WEBCATINVOICEHEADERIMP
      */

ALTER TABLE WEBCATINVOICEHEADERIMP MODIFY (CONTACTPERSONEMAIL VARCHAR2(300));

 /*
      CHANGE REPORT for Table INVOICEHEADER
          - change datatype from VARCHAR2(60) to VARCHAR2(300), change unknown attribute from 19 to (empty), change unknown attribute from 76 to (empty) of column EMAILADDRESS
      ACTION is ALTER or modify Table INVOICEHEADER
      */

ALTER TABLE INVOICEHEADER MODIFY (EMAILADDRESS VARCHAR2(300));






