diff options
author | puthuparambil.aditya <aditya.puthuparambil@bell.ca> | 2021-05-24 13:53:07 +0100 |
---|---|---|
committer | puthuparambil.aditya <aditya.puthuparambil@bell.ca> | 2021-05-26 12:31:44 +0100 |
commit | 8a10943c6f00bd0a269c6cc88c3a619c2fd4ec07 (patch) | |
tree | 0e6e2477c432a4ba02ea0d1916888c1c6b51c992 /src/main/resources/db | |
parent | 25050c117a6e69946de4f70503afa74cdef78aa7 (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.xml | 1 | ||||
-rw-r--r-- | src/main/resources/db/changelog/schema/03-rename-network-data-timestamp-fields.xml | 37 |
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> |