From 7ecdac335b89831e5d9043434f05beb21dff640a Mon Sep 17 00:00:00 2001 From: dglFromAtt Date: Mon, 18 Feb 2019 20:00:09 -0500 Subject: Added new fields to dr_sub API for ONAP: privilegedSubscriber for AT&T: guaranteed_delivery, guaranteed_sequence also used this opportunity to move info about properties into README file patchset 2: increment version patchset 3: more try{}catch around reading fields from JSON . Boolean fields are fragile. Change-Id: Idc7353aaa660c180c1079f9ff61c7d55c41d4170 Signed-off-by: dglFromAtt Issue-ID: DMAAP-1033 Signed-off-by: dglFromAtt --- src/main/resources/schema_12.sql | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 src/main/resources/schema_12.sql (limited to 'src/main/resources') diff --git a/src/main/resources/schema_12.sql b/src/main/resources/schema_12.sql new file mode 100644 index 0000000..7aaab11 --- /dev/null +++ b/src/main/resources/schema_12.sql @@ -0,0 +1,30 @@ +--- +-- ============LICENSE_START======================================================= +-- OpenECOMP - org.onap.dbcapi +-- ================================================================================ +-- Copyright (C) 2017 AT&T Intellectual Property. All rights reserved. +-- ================================================================================ +-- 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========================================================= +--- + + +@alter table dr_sub + + add column guaranteed_delivery boolean, + add column guaranteed_sequence boolean, + add column privileged_subscriber boolean +; + + +update dmaapbc_sch_ver set version = 12 where version = 11; -- cgit 1.2.3-korg