MYSQL upgrade

Below is the Procedure to update the mappings

  1. Backup current WIP database

  2. Install new WIP2.0 version

  3. Rename the columns

    1. ALTER TABLE AbActor  RENAME COLUMN Usage TO Usage_COL;
      ALTER TABLE VmBoCategory  RENAME COLUMN Path TO Path_COL;
      ALTER TABLE VmObject  RENAME COLUMN Path TO Path_COL;
      ALTER TABLE VmObjectImage  RENAME COLUMN Path TO Path_COL;
      ALTER TABLE VmAttribute  RENAME COLUMN Path TO Path_COL;

  4. IN WIP2.0 Setup Update Mappings (get rid of proposed update instructions)