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 <[email protected]> Authored: Fri Nov 10 15:57:00 2017 -0800 Committer: Madhuvanthi Radhakrishnan <[email protected]> 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,
