diff options
Diffstat (limited to 'src')
3 files changed, 41 insertions, 3 deletions
diff --git a/src/main/java/org/onap/cps/temporal/domain/NetworkData.java b/src/main/java/org/onap/cps/temporal/domain/NetworkData.java index c4f3176..aa2ce95 100644 --- a/src/main/java/org/onap/cps/temporal/domain/NetworkData.java +++ b/src/main/java/org/onap/cps/temporal/domain/NetworkData.java @@ -48,10 +48,10 @@ import org.hibernate.annotations.TypeDef; @TypeDef(name = "jsonb", typeClass = JsonBinaryType.class) public class NetworkData implements Serializable { - private static final long serialVersionUID = 1L; + private static final long serialVersionUID = -8032810412816532433L; @Id - @Column(name = "timestamp") + @Column private OffsetDateTime observedTimestamp; @Id @@ -72,7 +72,7 @@ public class NetworkData implements Serializable { private String payload; @CreationTimestamp - @Column(name = "version", updatable = false) + @Column(updatable = false) private OffsetDateTime createdTimestamp; } 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> |