diff options
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> |