aboutsummaryrefslogtreecommitdiffstats
path: root/packages
diff options
context:
space:
mode:
Diffstat (limited to 'packages')
-rw-r--r--packages/base/src/files/install/mysql/data/170701_downgrade_script.sql8
-rw-r--r--packages/base/src/files/install/mysql/data/170701_upgrade_script.sql16
2 files changed, 12 insertions, 12 deletions
diff --git a/packages/base/src/files/install/mysql/data/170701_downgrade_script.sql b/packages/base/src/files/install/mysql/data/170701_downgrade_script.sql
index 8271f27ce..58f92a6cd 100644
--- a/packages/base/src/files/install/mysql/data/170701_downgrade_script.sql
+++ b/packages/base/src/files/install/mysql/data/170701_downgrade_script.sql
@@ -18,9 +18,9 @@
use onap_sdk;
ALTER TABLE fwtagpicker drop networkRole;
-alter table microservicemodels drop column enumValues, drop column annotation;
-drop table if exists FWTag;
-drop table if exists FWTagPicker;
+alter table microservicemodels drop column enumValues, drop column annotation;
+drop table if exists FwTag;
+drop table if exists FwTagPicker;
drop table if exists brmsdependency;
drop table if exists brmscontroller;
-drop table if exists microserviceattribute;
+drop table if exists microserviceattribute;
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,