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 CREATE TABLE IF NOT EXISTS dcae_location (
22 dcae_location_name VARCHAR(100),
24 dcae_layer VARCHAR(100),
25 open_stack_availability_zone VARCHAR(100),
29 PRIMARY KEY(dcae_location_name)
31 CREATE TABLE IF NOT EXISTS dmaap (
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)
43 CREATE TABLE IF NOT EXISTS dr_node (
45 dcae_location_name VARCHAR(100),
46 host_name VARCHAR(100),
52 CREATE TABLE IF NOT EXISTS dr_pub (
53 dcae_location_name VARCHAR(100),
54 username VARCHAR(100),
62 CREATE TABLE IF NOT EXISTS dr_sub (
67 dcae_location_name VARCHAR(100),
68 username VARCHAR(100),
71 delivery_u_r_l VARCHAR(200),
72 log_u_r_l VARCHAR(200),
75 guaranteed_delivery BOOLEAN,
76 guaranteed_sequence BOOLEAN,
77 privileged_subscriber BOOLEAN,
81 CREATE TABLE IF NOT EXISTS mr_client (
82 dcae_location_name VARCHAR(100),
84 client_role VARCHAR(100),
86 mr_client_id VARCHAR(100),
88 topic_u_r_l VARCHAR(200),
90 client_identity varchar(100),
91 PRIMARY KEY(mr_client_id)
93 CREATE TABLE IF NOT EXISTS mr_cluster (
95 dcae_location_name VARCHAR(100),
97 topic_protocol VARCHAR(100),
98 topic_port VARCHAR(100),
100 replication_group VARCHAR(100),
101 PRIMARY KEY(dcae_location_name)
103 CREATE TABLE IF NOT EXISTS feed (
105 subscribe_u_r_l VARCHAR(200),
106 feed_id VARCHAR(100),
107 feed_name VARCHAR(100),
108 feed_version VARCHAR(100),
109 feed_description VARCHAR(1000),
111 aspr_classification VARCHAR(100),
112 publish_u_r_l VARCHAR(200),
113 log_u_r_l VARCHAR(200),
116 format_uuid VARCHAR(100),
119 CREATE TABLE IF NOT EXISTS topic (
122 topic_name VARCHAR(100),
123 topic_description VARCHAR(1000),
124 tnx_enabled VARCHAR(100),
127 format_uuid VARCHAR(100),
128 replication_case INT,
129 global_mr_u_r_l VARCHAR(200),
130 partition_count VARCHAR(10) DEFAULT 2,
131 replication_count VARCHAR(10) DEFAULT 1,
132 publisher_role VARCHAR(100),
133 subscriber_role VARCHAR(100),
136 CREATE TABLE IF NOT EXISTS mirror_maker (
137 mm_name VARCHAR(100),
138 source_cluster VARCHAR(100),
139 target_cluster VARCHAR(100),