/*order 502373*/      
      /*
      CHANGE REPORT for Table WEARER
          - change datatype from VARCHAR2(80) to VARCHAR2(300), change unknown attribute from 7 to (empty), change unknown attribute from 3 to (empty), change unknown attribute from 12 to 7, change unknown attribute from 12 to 7 of column REMARK
          - Adding index XIE3WEARER
          - Adding index XIE4WEARER
      ACTION is ALTER or modify Table WEARER
      */

ALTER TABLE WEARER MODIFY (REMARK VARCHAR2(300));

CREATE INDEX XIE3WEARER ON WEARER
(
       CUSTOMER_ID                    ,
       SEARCHNAME                     
);

CREATE INDEX XIE4WEARER ON WEARER
(
       CUSTOMEREMPLOYEENUMBER         
);

