aboutsummaryrefslogtreecommitdiffstats
path: root/src/main/resources/db
diff options
context:
space:
mode:
authorputhuparambil.aditya <aditya.puthuparambil@bell.ca>2021-05-24 13:53:07 +0100
committerputhuparambil.aditya <aditya.puthuparambil@bell.ca>2021-05-26 12:31:44 +0100
commit8a10943c6f00bd0a269c6cc88c3a619c2fd4ec07 (patch)
tree0e6e2477c432a4ba02ea0d1916888c1c6b51c992 /src/main/resources/db
parent25050c117a6e69946de4f70503afa74cdef78aa7 (diff)
Update db schema to keep field name consistent with domain property
Rollback need not be specified for renameColumn as per documentation: https://docs.liquibase.com/workflows/liquibase-community/using-rollback.html Issue-ID: CPS-425 Signed-off-by: puthuparambil.aditya <aditya.puthuparambil@bell.ca> Change-Id: Ida1cf80e7cd180c7b713bc595105fa83f4f6b278
Diffstat (limited to 'src/main/resources/db')
-rw-r--r--src/main/resources/db/changelog/changelog-master.xml1
-rw-r--r--src/main/resources/db/changelog/schema/03-rename-network-data-timestamp-fields.xml37
2 files changed, 38 insertions, 0 deletions
diff --git a/src/main/resources/db/changelog/changelog-master.xml b/src/main/resources/db/changelog/changelog-master.xml
index 630d399..6ec36fb 100644
--- a/src/main/resources/db/changelog/changelog-master.xml
+++ b/src/main/resources/db/changelog/changelog-master.xml
@@ -25,5 +25,6 @@
<include file="db/changelog/schema/01-init-schema.xml"/>
<include file="db/changelog/data/02-init-data.xml"/>
+ <include file="db/changelog/schema/03-rename-network-data-timestamp-fields.xml"/>
</databaseChangeLog>
diff --git a/src/main/resources/db/changelog/schema/03-rename-network-data-timestamp-fields.xml b/src/main/resources/db/changelog/schema/03-rename-network-data-timestamp-fields.xml
new file mode 100644
index 0000000..21baa8c
--- /dev/null
+++ b/src/main/resources/db/changelog/schema/03-rename-network-data-timestamp-fields.xml
@@ -0,0 +1,37 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!--
+ ============LICENSE_START=======================================================
+ Copyright (c) 2021 Bell Canada.
+ ================================================================================
+ 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.
+ ============LICENSE_END=========================================================
+-->
+
+<databaseChangeLog
+ xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
+ xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
+ xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
+ http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.3.xsd">
+
+ <changeSet id="3" author="cps">
+ <comment>Rename timestamp and version columns in network data timescale table</comment>
+ <renameColumn
+ newColumnName="observed_timestamp"
+ oldColumnName="timestamp"
+ tableName="network_data"/>
+ <renameColumn
+ newColumnName="created_timestamp"
+ oldColumnName="version"
+ tableName="network_data"/>
+ </changeSet>
+</databaseChangeLog>