-- Upgrade script to take the DB from version 1.0.8.3 to 2.0.0.1

USE ActiveBpel;

-- add the urn mapping table
CREATE TABLE AeURNValues (
   URN VARCHAR(255) NOT NULL,
   URL LONGTEXT NOT NULL,
   PRIMARY KEY (URN)
) TYPE = INNODB;

-- Update the DB version number.
UPDATE AeMetaInfo SET PropertyValue = '2.0.0.1' WHERE PropertyName = 'Version';
