2 -- ============LICENSE_START=======================================================
3 -- OpenECOMP - org.openecomp.dmaapbc
4 -- ================================================================================
5 -- Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
6 -- ================================================================================
7 -- Licensed under the Apache License, Version 2.0 (the "License");
8 -- you may not use this file except in compliance with the License.
9 -- You may obtain a copy of the License at
11 -- http://www.apache.org/licenses/LICENSE-2.0
13 -- Unless required by applicable law or agreed to in writing, software
14 -- distributed under the License is distributed on an "AS IS" BASIS,
15 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16 -- See the License for the specific language governing permissions and
17 -- limitations under the License.
18 -- ============LICENSE_END=========================================================
21 @drop table dcae_location;
22 create table dcae_location (
23 dcae_location_name VARCHAR(100),
25 dcae_layer VARCHAR(100),
26 open_stack_availability_zone VARCHAR(100),
28 PRIMARY KEY(dcae_location_name)
33 topic_ns_root VARCHAR(100),
34 dmaap_name VARCHAR(100),
35 dr_prov_url VARCHAR(200),
36 node_key VARCHAR(100),
37 access_key_owner VARCHAR(100),
40 bridge_admin_topic VARCHAR(100),
41 logging_url VARCHAR(200)
44 create table dr_node (
46 dcae_location_name VARCHAR(100),
47 host_name VARCHAR(100),
53 dcae_location_name VARCHAR(100),
54 username VARCHAR(100),
67 dcae_location_name VARCHAR(100),
68 username VARCHAR(100),
71 delivery_u_r_l VARCHAR(200),
72 log_u_r_l VARCHAR(200),
76 @drop table mr_client;
77 create table mr_client (
78 dcae_location_name VARCHAR(100),
80 client_role VARCHAR(100),
82 mr_client_id VARCHAR(100),
84 topic_u_r_l VARCHAR(200),
86 PRIMARY KEY(mr_client_id)
88 @drop table mr_cluster;
89 create table mr_cluster (
91 dcae_location_name VARCHAR(100),
94 topic_protocol VARCHAR(100),
95 topic_port VARCHAR(100),
96 PRIMARY KEY(dcae_location_name)
101 subscribe_u_r_l VARCHAR(200),
102 feed_id VARCHAR(100),
103 feed_name VARCHAR(100),
104 feed_version VARCHAR(100),
105 feed_description VARCHAR(1000),
107 aspr_classification VARCHAR(100),
108 publish_u_r_l VARCHAR(200),
109 log_u_r_l VARCHAR(200),
111 -- pubs not stored here
112 -- subs not stored here
119 topic_name VARCHAR(100),
120 topic_description VARCHAR(1000),
121 tnx_enabled VARCHAR(100),
124 -- clients not stored here
127 @drop table mirror_maker;
128 create table mirror_maker (
129 mm_name VARCHAR(100),
130 source_cluster VARCHAR(100),
131 target_cluster VARCHAR(100),
134 PRIMARY KEY(source_cluster)
136 update dmaapbc_sch_ver set version = 1 where version = 0;