3 files changed, 59 insertions, 1 deletions
diff --git a/cmso-database/src/main/resources/cmso-liquibase-changeLog.xml b/cmso-database/src/main/resources/cmso-liquibase-changeLog.xml
index 0bc23c1..bf45ff9 100644
--- a/cmso-database/src/main/resources/cmso-liquibase-changeLog.xml
+++ b/cmso-database/src/main/resources/cmso-liquibase-changeLog.xml
@@ -1,6 +1,6 @@
 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
 <!--
-  Copyright © 2017-2018 AT&T Intellectual Property.
+  Copyright © 2017-2019 AT&T Intellectual Property.
   Modifications Copyright © 2018 IBM.
   
   Licensed under the Apache License, Version 2.0 (the "License");
@@ -45,4 +45,11 @@
 		<sqlFile path="cmso-dbchangelog/onap-cmso-v1-schema.sql" />
 	</changeSet>
 
+	<changeSet author="ONAP" id="cmso-v1.1-schema1">
+		<sqlFile path="cmso-dbchangelog/onap-cmso-v1.1-drop-indices.sql" />
+		<sqlFile path="cmso-dbchangelog/onap-cmso-v1.1-add-uuid.sql" />
+		<sqlFile path="cmso-dbchangelog/onap-cmso-v1.1-restore-indices.sql" />
+		<sqlFile path="cmso-dbchangelog/onap-cmso-v1.1-drop-ids.sql" />
+	</changeSet>
+
 </databaseChangeLog>
diff --git a/cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql b/cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql
index d6e225b..171cb2d 100644
--- a/cmso-database/src/main/resources/optimizer-dbchanges/onap-cmso-v1-schema.sql
+++ b/cmso-database/src/main/resources/optimizer-dbchanges/onap-optimizer-v1-schema.sql
@@ -26,6 +26,7 @@ CREATE TABLE IF NOT EXISTS `optimizer`.`topology` (
   topology_start BIGINT(20) NULL DEFAULT NULL,
   topology_end BIGINT(20) NULL DEFAULT NULL,
   topology_retries INT NULL DEFAULT NULL,
+  topology_polling_interval INT NULL DEFAULT NULL,
   PRIMARY KEY (`uuid`))
 ENGINE = InnoDB
 DEFAULT CHARACTER SET = utf8;
@@ -36,6 +37,7 @@ CREATE TABLE IF NOT EXISTS `optimizer`.`tickets` (
   tickets_start BIGINT(20) NULL DEFAULT NULL,
   tickets_end BIGINT(20) NULL DEFAULT NULL,
   tickets_retries INT NULL DEFAULT NULL,
+  topology_polling_interval INT NULL DEFAULT NULL,
   PRIMARY KEY (`uuid`))
 ENGINE = InnoDB
 DEFAULT CHARACTER SET = utf8;
@@ -46,6 +48,7 @@ CREATE TABLE IF NOT EXISTS `optimizer`.`optimizer` (
   optimize_start BIGINT(20) NULL DEFAULT NULL,
   optimize_end BIGINT(20) NULL DEFAULT NULL,
   optimize_retries INT NULL DEFAULT NULL,
+  optimize_polling_interval INT NULL DEFAULT NULL,
   PRIMARY KEY (`uuid`))
 ENGINE = InnoDB
 DEFAULT CHARACTER SET = utf8;
diff --git a/cmso-database/src/main/resources/optimizer-liquibase-changeLog.xml b/cmso-database/src/main/resources/optimizer-liquibase-changeLog.xml
new file mode 100644
index 0000000..e735975
--- /dev/null
+++ b/cmso-database/src/main/resources/optimizer-liquibase-changeLog.xml
@@ -0,0 +1,48 @@
+<?xml version="1.0" encoding="UTF-8" standalone="no"?>
+<!--
+  Copyright © 2017-2019 AT&T Intellectual Property.
+  Modifications Copyright © 2018 IBM.
+  
+  Licensed under the Apache License, Version 2.0 (the "License");
+  you may not use this file except in compliance with the License.
+  You may obtain a copy of the License at
+  
+          http://www.apache.org/licenses/LICENSE-2.0
+  
+  Unless required by applicable law or agreed to in writing, software
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+  
+  
+  Unless otherwise specified, all documentation contained herein is licensed
+  under the Creative Commons License, Attribution 4.0 Intl. (the "License");
+  you may not use this documentation except in compliance with the License.
+  You may obtain a copy of the License at
+  
+          https://creativecommons.org/licenses/by/4.0/
+  
+  Unless required by applicable law or agreed to in writing, documentation
+  distributed under the License is distributed on an "AS IS" BASIS,
+  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+  See the License for the specific language governing permissions and
+  limitations under the License.
+-->
+
+<databaseChangeLog
+	xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
+	xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"
+	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+	xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.4.xsd">
+
+	<changeSet author="ONAP" id="optimizer-v1-schema1">
+		<preConditions onFail="MARK_RAN">
+			<not>
+				<tableExists schemaName="optimizer" tableName="request" />
+			</not>
+		</preConditions>
+		<sqlFile path="optimizer-dbchanges/onap-optimizer-v1-schema.sql" />
+	</changeSet>
+
+</databaseChangeLog>