X-Git-Url: https://gerrit.onap.org/r/gitweb?p=policy%2Fengine.git;a=blobdiff_plain;f=packages%2Fbase%2Fsrc%2Ffiles%2Finstall%2Fmysql%2Fdata%2F170701_upgrade_script.sql;h=c2343b720b6ef202c6dfc8fde8cbebbc4ef628f8;hp=f8ed77182f26abe64f55c5991763683cb7daebb0;hb=0c20d1c294fe146e1018f14b07a8d861c29fe527;hpb=72d4e8692753620f8cbe6c7ebb3f9c0b247d7827 diff --git a/packages/base/src/files/install/mysql/data/170701_upgrade_script.sql b/packages/base/src/files/install/mysql/data/170701_upgrade_script.sql index f8ed77182..c2343b720 100644 --- a/packages/base/src/files/install/mysql/data/170701_upgrade_script.sql +++ b/packages/base/src/files/install/mysql/data/170701_upgrade_script.sql @@ -20,14 +20,14 @@ use onap_sdk; INSERT INTO policyeditorscopes (`id`, `scopename`, `created_date`, `created_by`, `modified_date`, `modified_by`) VALUES ('1', 'com', '2017-06-01 11:45:36', 'demo', '2017-06-01 11:45:36', 'demo'); -alter table IntegrityAuditEntity modify jdbcUrl varchar(200) not null; +alter table IntegrityAuditEntity modify jdbcUrl varchar(200) not null; -alter table `onap_sdk`.`microservicemodels` -add column `enumValues` longtext null default null after `version`, +alter table `onap_sdk`.`microservicemodels` +add column `enumValues` longtext null default null after `version`, add column `annotation` longtext null after `enumValues`; -drop table if exists FWTag; -CREATE TABLE FWTag( +drop table if exists FwTag; +CREATE TABLE FwTag( Id int NOT NULL AUTO_INCREMENT, tagName VARCHAR(45) NOT NULL, description VARCHAR(1024), @@ -39,8 +39,8 @@ MODIFIED_BY VARCHAR(45) NOT NULL, PRIMARY KEY(ID) ); -drop table if exists FWTagPicker; -CREATE TABLE FWTagPicker( +drop table if exists FwTagPicker; +CREATE TABLE FwTagPicker( ID INT NOT NULL AUTO_INCREMENT, tagPickerName VARCHAR(45) NOT NULL, DESCRIPTION VARCHAR(1024), @@ -79,7 +79,7 @@ controller longtext not null, primary key(id) ); -drop table if exists microserviceattribute; +drop table if exists microserviceattribute; CREATE TABLE microserviceattribute( ID INT NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL,