summaryrefslogtreecommitdiffstats
path: root/packages/base/src/files/install/mysql
diff options
context:
space:
mode:
authorliamfallon <liam.fallon@est.tech>2019-11-08 16:11:50 +0000
committerliamfallon <liam.fallon@est.tech>2019-11-12 09:20:22 +0000
commit0c20d1c294fe146e1018f14b07a8d861c29fe527 (patch)
tree04d82d897c7ecf69771a5810443109e17749eae5 /packages/base/src/files/install/mysql
parent2ee068fed59becbd3327937125264bdcf651f7b8 (diff)
JUnit/SONAR/Checkstyle in ONAP-REST
Third batch of JPA pojos (E-M), with JUnit added and SONAR/Checkstyle issues addressed. In cases where a class name change caused an update in another package, the license header on files for those knock on changes are not updated. Issue-ID: POLICY-2131 Change-Id: I4fee1e9fb9c8a69dd6f2f15d3e3a8844473b857b Signed-off-by: liamfallon <liam.fallon@est.tech>
Diffstat (limited to 'packages/base/src/files/install/mysql')
-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,