aboutsummaryrefslogtreecommitdiffstats
path: root/dmaap-bc/src/main/resources/misc/schema_all.sql
blob: c294b09d24f4c57f4f2caa9df94e200b93cc89b0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
---
-- ============LICENSE_START=======================================================
-- OpenECOMP - org.openecomp.dmaapbc
-- ================================================================================
-- 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=========================================================
---

CREATE TABLE IF NOT EXISTS dcae_location	(
	dcae_location_name	VARCHAR(100),
	clli	VARCHAR(100),
	dcae_layer	VARCHAR(100),
	open_stack_availability_zone	VARCHAR(100),
	last_mod	TIMESTAMP,
	subnet		VARCHAR(100),
  status		VARCHAR(100),
	PRIMARY KEY(dcae_location_name)
);
CREATE TABLE IF NOT EXISTS dmaap	(
	version	VARCHAR(100),
	topic_ns_root	VARCHAR(100),
	dmaap_name	VARCHAR(100),
	dr_prov_url	VARCHAR(200),
	node_key	VARCHAR(100),
	access_key_owner	VARCHAR(100),
	last_mod	TIMESTAMP,
	status		VARCHAR(100),
	bridge_admin_topic	VARCHAR(100),
	logging_url	VARCHAR(200)
);
CREATE TABLE IF NOT EXISTS dr_node	(
	fqdn	VARCHAR(100),
	dcae_location_name	VARCHAR(100),
	host_name	VARCHAR(100),
	version	VARCHAR(100),
	last_mod	TIMESTAMP,
	status		VARCHAR(100),
	PRIMARY KEY(fqdn)
);
CREATE TABLE IF NOT EXISTS dr_pub	(
	dcae_location_name	VARCHAR(100),
	username	VARCHAR(100),
	userpwd	VARCHAR(100),
	feed_id	VARCHAR(100),
	pub_id	VARCHAR(100),
	status	VARCHAR(100),
	last_mod	TIMESTAMP,
	PRIMARY KEY(pub_id)
);
CREATE TABLE IF NOT EXISTS dr_sub	(
	owner	VARCHAR(100),
	suspended	BOOLEAN,
	status	VARCHAR(100),
	use100	BOOLEAN,
	dcae_location_name	VARCHAR(100),
	username	VARCHAR(100),
	userpwd	VARCHAR(100),
	feed_id	VARCHAR(100),
	delivery_u_r_l	VARCHAR(200),
	log_u_r_l	VARCHAR(200),
	sub_id	VARCHAR(100),
	last_mod	TIMESTAMP,
	guaranteed_delivery  BOOLEAN,
	guaranteed_sequence  BOOLEAN,
	privileged_subscriber  BOOLEAN,
	decompress  BOOLEAN,
	PRIMARY KEY(sub_id)
);
CREATE TABLE IF NOT EXISTS mr_client	(
	dcae_location_name	VARCHAR(100),
	fqtn	VARCHAR(100),
	client_role	VARCHAR(100),
	action	VARCHAR(300),
	mr_client_id	VARCHAR(100),
	status	VARCHAR(100),
	topic_u_r_l	VARCHAR(200),
	last_mod	TIMESTAMP,
	client_identity	varchar(100),
	PRIMARY KEY(mr_client_id)
);
CREATE TABLE IF NOT EXISTS mr_cluster	(
	last_mod	TIMESTAMP,
	dcae_location_name	VARCHAR(100),
	fqdn	VARCHAR(100),
	topic_protocol	VARCHAR(100),
	topic_port	VARCHAR(100),
	status		VARCHAR(100),
	replication_group	VARCHAR(100),
	PRIMARY KEY(dcae_location_name)
);
CREATE TABLE IF NOT EXISTS feed	(
	suspended	BOOLEAN,
	subscribe_u_r_l	VARCHAR(200),
	feed_id	VARCHAR(100),
	feed_name	VARCHAR(100),
	feed_version	VARCHAR(100),
	feed_description	VARCHAR(1000),
	owner	VARCHAR(100),
	aspr_classification	VARCHAR(100),
	publish_u_r_l	VARCHAR(200),
	log_u_r_l	VARCHAR(200),
	status	VARCHAR(100),
	last_mod	TIMESTAMP,
	format_uuid	VARCHAR(100),
	PRIMARY KEY(feed_id)
);
CREATE TABLE IF NOT EXISTS topic	(
	last_mod	TIMESTAMP,
	fqtn	VARCHAR(100),
	topic_name	VARCHAR(100),
	topic_description	VARCHAR(1000),
	tnx_enabled	VARCHAR(100),
	owner	VARCHAR(100),
	status	VARCHAR(100),
	format_uuid	VARCHAR(100),
	replication_case INT,
	global_mr_u_r_l	 VARCHAR(200),
	partition_count	VARCHAR(10) DEFAULT 2,
  replication_count VARCHAR(10) DEFAULT 1,
	publisher_role	VARCHAR(100),
  subscriber_role VARCHAR(100),
	PRIMARY KEY(fqtn)
);
CREATE TABLE IF NOT EXISTS mirror_maker	(
	mm_name	VARCHAR(100),
	source_cluster	VARCHAR(100),
	target_cluster	VARCHAR(100),
	last_mod	TIMESTAMP,
	status		VARCHAR(100),
	topics		TEXT,
  PRIMARY KEY(mm_name)
);