You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ambari.apache.org by be...@apache.org on 2017/11/14 11:14:38 UTC
[05/17] ambari git commit: AMBARI-22355 : Addendum patch for adding
service_id to clusterconfig (mradhakrishnan)
AMBARI-22355 : Addendum patch for adding service_id to clusterconfig (mradhakrishnan)
Project: http://git-wip-us.apache.org/repos/asf/ambari/repo
Commit: http://git-wip-us.apache.org/repos/asf/ambari/commit/55e450ee
Tree: http://git-wip-us.apache.org/repos/asf/ambari/tree/55e450ee
Diff: http://git-wip-us.apache.org/repos/asf/ambari/diff/55e450ee
Branch: refs/heads/branch-feature-AMBARI-14714-blueprintv2
Commit: 55e450eea40030d21addbb3aa06bf5d87668ae6e
Parents: 4959206
Author: Madhuvanthi Radhakrishnan <mr...@hortonworks.com>
Authored: Fri Nov 10 15:57:00 2017 -0800
Committer: Madhuvanthi Radhakrishnan <mr...@hortonworks.com>
Committed: Fri Nov 10 15:57:00 2017 -0800
----------------------------------------------------------------------
.../main/resources/Ambari-DDL-Derby-CREATE.sql | 44 ++++++++++----------
.../main/resources/Ambari-DDL-MySQL-CREATE.sql | 44 ++++++++++----------
.../main/resources/Ambari-DDL-Oracle-CREATE.sql | 43 +++++++++----------
.../resources/Ambari-DDL-Postgres-CREATE.sql | 43 +++++++++----------
.../resources/Ambari-DDL-SQLAnywhere-CREATE.sql | 43 +++++++++----------
.../resources/Ambari-DDL-SQLServer-CREATE.sql | 43 +++++++++----------
6 files changed, 134 insertions(+), 126 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/ambari/blob/55e450ee/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql
----------------------------------------------------------------------
diff --git a/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql
index 039d8af..a591bbf 100644
--- a/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql
+++ b/ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql
@@ -86,27 +86,6 @@ CREATE TABLE clusters (
CONSTRAINT FK_clusters_desired_stack_id FOREIGN KEY (desired_stack_id) REFERENCES stack(stack_id),
CONSTRAINT FK_clusters_resource_id FOREIGN KEY (resource_id) REFERENCES adminresource(resource_id));
-CREATE TABLE clusterconfig (
- config_id BIGINT NOT NULL,
- version_tag VARCHAR(255) NOT NULL,
- version BIGINT NOT NULL,
- type_name VARCHAR(255) NOT NULL,
- cluster_id BIGINT NOT NULL,
- stack_id BIGINT NOT NULL,
- selected SMALLINT NOT NULL DEFAULT 0,
- config_data VARCHAR(3000) NOT NULL,
- config_attributes VARCHAR(3000),
- create_timestamp BIGINT NOT NULL,
- unmapped SMALLINT NOT NULL DEFAULT 0,
- selected_timestamp BIGINT NOT NULL DEFAULT 0,
- service_id BIGINT,
- CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
- CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
- CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
- CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
- CONSTRAINT UQ_config_type_tag UNIQUE (version_tag, type_name, cluster_id),
- CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
-
CREATE TABLE configuration_base (
id BIGINT NOT NULL,
version_tag VARCHAR(255) NOT NULL,
@@ -176,8 +155,31 @@ CREATE TABLE clusterservices (
service_group_id BIGINT NOT NULL,
service_enabled INTEGER NOT NULL,
CONSTRAINT PK_clusterservices PRIMARY KEY (id, service_group_id, cluster_id),
+ CONSTRAINT UQ_service_id UNIQUE (id),
CONSTRAINT FK_clusterservices_cluster_id FOREIGN KEY (service_group_id, cluster_id) REFERENCES servicegroups (id, cluster_id));
+CREATE TABLE clusterconfig (
+ config_id BIGINT NOT NULL,
+ version_tag VARCHAR(255) NOT NULL,
+ version BIGINT NOT NULL,
+ type_name VARCHAR(255) NOT NULL,
+ cluster_id BIGINT NOT NULL,
+ stack_id BIGINT NOT NULL,
+ selected SMALLINT NOT NULL DEFAULT 0,
+ config_data VARCHAR(3000) NOT NULL,
+ config_attributes VARCHAR(3000),
+ create_timestamp BIGINT NOT NULL,
+ unmapped SMALLINT NOT NULL DEFAULT 0,
+ selected_timestamp BIGINT NOT NULL DEFAULT 0,
+ service_id BIGINT,
+ CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
+ CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
+ CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
+ CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
+ CONSTRAINT UQ_config_type_tag UNIQUE (version_tag, type_name, cluster_id),
+ CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
+
+
CREATE TABLE servicedependencies (
service_id BIGINT NOT NULL,
service_group_id BIGINT NOT NULL,
http://git-wip-us.apache.org/repos/asf/ambari/blob/55e450ee/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
----------------------------------------------------------------------
diff --git a/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
index e14f0f1..6c2c0f4 100644
--- a/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
+++ b/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql
@@ -105,27 +105,6 @@ CREATE TABLE clusters (
CONSTRAINT FK_clusters_desired_stack_id FOREIGN KEY (desired_stack_id) REFERENCES stack(stack_id),
CONSTRAINT FK_clusters_resource_id FOREIGN KEY (resource_id) REFERENCES adminresource(resource_id));
-CREATE TABLE clusterconfig (
- config_id BIGINT NOT NULL,
- version_tag VARCHAR(100) NOT NULL,
- version BIGINT NOT NULL,
- type_name VARCHAR(100) NOT NULL,
- cluster_id BIGINT NOT NULL,
- stack_id BIGINT NOT NULL,
- selected SMALLINT NOT NULL DEFAULT 0,
- config_data LONGTEXT NOT NULL,
- config_attributes LONGTEXT,
- create_timestamp BIGINT NOT NULL,
- unmapped SMALLINT NOT NULL DEFAULT 0,
- selected_timestamp BIGINT NOT NULL DEFAULT 0,
- service_id BIGINT,
- CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
- CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
- CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
- CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
- CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
- CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
-
CREATE TABLE configuration_base (
id BIGINT NOT NULL,
version_tag VARCHAR(100) NOT NULL,
@@ -195,8 +174,31 @@ CREATE TABLE clusterservices (
service_group_id BIGINT NOT NULL,
service_enabled INTEGER NOT NULL,
CONSTRAINT PK_clusterservices PRIMARY KEY (id, service_group_id, cluster_id),
+ CONSTRAINT UQ_service_id UNIQUE (id),
CONSTRAINT FK_clusterservices_cluster_id FOREIGN KEY (service_group_id, cluster_id) REFERENCES servicegroups (id, cluster_id));
+
+CREATE TABLE clusterconfig (
+ config_id BIGINT NOT NULL,
+ version_tag VARCHAR(100) NOT NULL,
+ version BIGINT NOT NULL,
+ type_name VARCHAR(100) NOT NULL,
+ cluster_id BIGINT NOT NULL,
+ stack_id BIGINT NOT NULL,
+ selected SMALLINT NOT NULL DEFAULT 0,
+ config_data LONGTEXT NOT NULL,
+ config_attributes LONGTEXT,
+ create_timestamp BIGINT NOT NULL,
+ unmapped SMALLINT NOT NULL DEFAULT 0,
+ selected_timestamp BIGINT NOT NULL DEFAULT 0,
+ service_id BIGINT,
+ CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
+ CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
+ CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
+ CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
+ CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
+ CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
+
CREATE TABLE servicedependencies (
service_id BIGINT NOT NULL,
service_group_id BIGINT NOT NULL,
http://git-wip-us.apache.org/repos/asf/ambari/blob/55e450ee/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
----------------------------------------------------------------------
diff --git a/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
index a5911eb..d697e05 100644
--- a/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
+++ b/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
@@ -86,27 +86,6 @@ CREATE TABLE clusters (
CONSTRAINT FK_clusters_desired_stack_id FOREIGN KEY (desired_stack_id) REFERENCES stack(stack_id),
CONSTRAINT FK_clusters_resource_id FOREIGN KEY (resource_id) REFERENCES adminresource(resource_id));
-CREATE TABLE clusterconfig (
- config_id NUMBER(19) NOT NULL,
- version_tag VARCHAR2(255) NOT NULL,
- version NUMBER(19) NOT NULL,
- type_name VARCHAR2(255) NOT NULL,
- cluster_id NUMBER(19) NOT NULL,
- stack_id NUMBER(19) NOT NULL,
- selected NUMBER(1) DEFAULT 0 NOT NULL,
- config_data CLOB NOT NULL,
- config_attributes CLOB,
- create_timestamp NUMBER(19) NOT NULL,
- unmapped SMALLINT DEFAULT 0 NOT NULL,
- selected_timestamp NUMBER(19) DEFAULT 0 NOT NULL,
- service_id BIGINT,
- CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
- CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
- CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
- CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
- CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
- CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
-
CREATE TABLE configuration_base (
id NUMBER(19) NOT NULL,
version_tag VARCHAR(255) NOT NULL,
@@ -176,8 +155,30 @@ CREATE TABLE clusterservices (
service_group_id NUMBER(19) NOT NULL,
service_enabled NUMBER(10) NOT NULL,
CONSTRAINT PK_clusterservices PRIMARY KEY (id, service_group_id, cluster_id),
+ CONSTRAINT UQ_service_id UNIQUE (id),
CONSTRAINT FK_clusterservices_cluster_id FOREIGN KEY (service_group_id, cluster_id) REFERENCES servicegroups (id, cluster_id));
+CREATE TABLE clusterconfig (
+ config_id NUMBER(19) NOT NULL,
+ version_tag VARCHAR2(255) NOT NULL,
+ version NUMBER(19) NOT NULL,
+ type_name VARCHAR2(255) NOT NULL,
+ cluster_id NUMBER(19) NOT NULL,
+ stack_id NUMBER(19) NOT NULL,
+ selected NUMBER(1) DEFAULT 0 NOT NULL,
+ config_data CLOB NOT NULL,
+ config_attributes CLOB,
+ create_timestamp NUMBER(19) NOT NULL,
+ unmapped SMALLINT DEFAULT 0 NOT NULL,
+ selected_timestamp NUMBER(19) DEFAULT 0 NOT NULL,
+ service_id BIGINT,
+ CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
+ CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
+ CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
+ CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
+ CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
+ CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
+
CREATE TABLE servicedependencies (
service_id NUMBER(19) NOT NULL,
service_group_id NUMBER(19) NOT NULL,
http://git-wip-us.apache.org/repos/asf/ambari/blob/55e450ee/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
----------------------------------------------------------------------
diff --git a/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
index c5203e4..f9544a5 100644
--- a/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
+++ b/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql
@@ -104,27 +104,6 @@ CREATE TABLE ambari_configuration (
CONSTRAINT FK_ambari_conf_conf_base FOREIGN KEY (id) REFERENCES configuration_base (id)
);
-CREATE TABLE clusterconfig (
- config_id BIGINT NOT NULL,
- version_tag VARCHAR(255) NOT NULL,
- version BIGINT NOT NULL,
- type_name VARCHAR(255) NOT NULL,
- cluster_id BIGINT NOT NULL,
- stack_id BIGINT NOT NULL,
- selected SMALLINT NOT NULL DEFAULT 0,
- config_data TEXT NOT NULL,
- config_attributes TEXT,
- create_timestamp BIGINT NOT NULL,
- unmapped SMALLINT NOT NULL DEFAULT 0,
- selected_timestamp BIGINT NOT NULL DEFAULT 0,
- service_id BIGINT,
- CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
- CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
- CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
- CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
- CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
- CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
-
CREATE TABLE hosts (
host_id BIGINT NOT NULL,
host_name VARCHAR(255) NOT NULL,
@@ -177,8 +156,30 @@ CREATE TABLE clusterservices (
service_group_id BIGINT NOT NULL,
service_enabled INTEGER NOT NULL,
CONSTRAINT PK_clusterservices PRIMARY KEY (id, service_group_id, cluster_id),
+ CONSTRAINT UQ_service_id UNIQUE (id),
CONSTRAINT FK_clusterservices_cluster_id FOREIGN KEY (service_group_id, cluster_id) REFERENCES servicegroups (id, cluster_id));
+CREATE TABLE clusterconfig (
+ config_id BIGINT NOT NULL,
+ version_tag VARCHAR(255) NOT NULL,
+ version BIGINT NOT NULL,
+ type_name VARCHAR(255) NOT NULL,
+ cluster_id BIGINT NOT NULL,
+ stack_id BIGINT NOT NULL,
+ selected SMALLINT NOT NULL DEFAULT 0,
+ config_data TEXT NOT NULL,
+ config_attributes TEXT,
+ create_timestamp BIGINT NOT NULL,
+ unmapped SMALLINT NOT NULL DEFAULT 0,
+ selected_timestamp BIGINT NOT NULL DEFAULT 0,
+ service_id BIGINT,
+ CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
+ CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
+ CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
+ CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
+ CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
+ CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
+
CREATE TABLE servicedependencies (
service_id BIGINT NOT NULL,
service_group_id BIGINT NOT NULL,
http://git-wip-us.apache.org/repos/asf/ambari/blob/55e450ee/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql
----------------------------------------------------------------------
diff --git a/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql
index a9032f3..fb98cbd 100644
--- a/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql
+++ b/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql
@@ -85,27 +85,6 @@ CREATE TABLE clusters (
CONSTRAINT FK_clusters_desired_stack_id FOREIGN KEY (desired_stack_id) REFERENCES stack(stack_id),
CONSTRAINT FK_clusters_resource_id FOREIGN KEY (resource_id) REFERENCES adminresource(resource_id));
-CREATE TABLE clusterconfig (
- config_id NUMERIC(19) NOT NULL,
- version_tag VARCHAR(255) NOT NULL,
- version NUMERIC(19) NOT NULL,
- type_name VARCHAR(255) NOT NULL,
- cluster_id NUMERIC(19) NOT NULL,
- stack_id NUMERIC(19) NOT NULL,
- selected SMALLINT NOT NULL DEFAULT 0,
- config_data TEXT NOT NULL,
- config_attributes TEXT,
- create_timestamp NUMERIC(19) NOT NULL,
- unmapped SMALLINT NOT NULL DEFAULT 0,
- selected_timestamp NUMERIC(19) NOT NULL DEFAULT 0,
- service_id BIGINT,
- CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
- CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
- CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
- CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
- CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
- CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
-
CREATE TABLE configuration_base (
id NUMERIC(19) NOT NULL,
version_tag VARCHAR(255) NOT NULL,
@@ -175,8 +154,30 @@ CREATE TABLE clusterservices (
service_group_id NUMERIC(19) NOT NULL,
service_enabled INTEGER NOT NULL,
CONSTRAINT PK_clusterservices PRIMARY KEY (id, service_group_id, cluster_id),
+ CONSTRAINT UQ_service_id UNIQUE (id),
CONSTRAINT FK_clusterservices_cluster_id FOREIGN KEY (service_group_id, cluster_id) REFERENCES servicegroups (id, cluster_id));
+CREATE TABLE clusterconfig (
+ config_id NUMERIC(19) NOT NULL,
+ version_tag VARCHAR(255) NOT NULL,
+ version NUMERIC(19) NOT NULL,
+ type_name VARCHAR(255) NOT NULL,
+ cluster_id NUMERIC(19) NOT NULL,
+ stack_id NUMERIC(19) NOT NULL,
+ selected SMALLINT NOT NULL DEFAULT 0,
+ config_data TEXT NOT NULL,
+ config_attributes TEXT,
+ create_timestamp NUMERIC(19) NOT NULL,
+ unmapped SMALLINT NOT NULL DEFAULT 0,
+ selected_timestamp NUMERIC(19) NOT NULL DEFAULT 0,
+ service_id BIGINT,
+ CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id),
+ CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
+ CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
+ CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
+ CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
+ CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
+
CREATE TABLE servicedependencies (
service_id NUMERIC(19) NOT NULL,
service_group_id NUMERIC(19) NOT NULL,
http://git-wip-us.apache.org/repos/asf/ambari/blob/55e450ee/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
----------------------------------------------------------------------
diff --git a/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
index d782155..9f93fbb 100644
--- a/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
+++ b/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql
@@ -99,27 +99,6 @@ CREATE TABLE clusters (
CONSTRAINT FK_clusters_desired_stack_id FOREIGN KEY (desired_stack_id) REFERENCES stack(stack_id),
CONSTRAINT FK_clusters_resource_id FOREIGN KEY (resource_id) REFERENCES adminresource(resource_id));
-CREATE TABLE clusterconfig (
- config_id BIGINT NOT NULL,
- version_tag VARCHAR(255) NOT NULL,
- version BIGINT NOT NULL,
- type_name VARCHAR(255) NOT NULL,
- cluster_id BIGINT NOT NULL,
- stack_id BIGINT NOT NULL,
- selected SMALLINT NOT NULL DEFAULT 0,
- config_data VARCHAR(MAX) NOT NULL,
- config_attributes VARCHAR(MAX),
- create_timestamp BIGINT NOT NULL,
- unmapped SMALLINT NOT NULL DEFAULT 0,
- selected_timestamp BIGINT NOT NULL DEFAULT 0,
- service_id BIGINT,
- CONSTRAINT PK_clusterconfig PRIMARY KEY CLUSTERED (config_id),
- CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
- CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
- CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
- CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
- CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
-
CREATE TABLE configuration_base (
id BIGINT NOT NULL,
version_tag VARCHAR(255) NOT NULL,
@@ -189,8 +168,30 @@ CREATE TABLE clusterservices (
service_group_id BIGINT NOT NULL,
service_enabled INT NOT NULL,
CONSTRAINT PK_clusterservices PRIMARY KEY (id, service_group_id, cluster_id),
+ CONSTRAINT UQ_service_id UNIQUE (id),
CONSTRAINT FK_clusterservices_cluster_id FOREIGN KEY (service_group_id, cluster_id) REFERENCES servicegroups (id, cluster_id));
+CREATE TABLE clusterconfig (
+ config_id BIGINT NOT NULL,
+ version_tag VARCHAR(255) NOT NULL,
+ version BIGINT NOT NULL,
+ type_name VARCHAR(255) NOT NULL,
+ cluster_id BIGINT NOT NULL,
+ stack_id BIGINT NOT NULL,
+ selected SMALLINT NOT NULL DEFAULT 0,
+ config_data VARCHAR(MAX) NOT NULL,
+ config_attributes VARCHAR(MAX),
+ create_timestamp BIGINT NOT NULL,
+ unmapped SMALLINT NOT NULL DEFAULT 0,
+ selected_timestamp BIGINT NOT NULL DEFAULT 0,
+ service_id BIGINT,
+ CONSTRAINT PK_clusterconfig PRIMARY KEY CLUSTERED (config_id),
+ CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES clusters (cluster_id),
+ CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES stack(stack_id),
+ CONSTRAINT FK_clusterconfig_service_id FOREIGN KEY (service_id) REFERENCES clusterservices(id),
+ CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag),
+ CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version));
+
CREATE TABLE servicedependencies (
service_id BIGINT NOT NULL,
service_group_id BIGINT NOT NULL,