aboutsummaryrefslogtreecommitdiffstats
path: root/src/main/resources
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources')
-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>