[2/3] ambari git commit: AMBARI-18226. Remove Redundant Embedded Postgres SQL (aonishuk)
http://git-wip-us.apache.org/repos/asf/ambari/blob/9dbcac6d/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql -- diff --git a/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql index 8f03989..9943cae 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql @@ -26,1707 +26,4 @@ GRANT ALL PRIVILEGES ON DATABASE :dbname TO :username; CREATE SCHEMA ambari AUTHORIZATION :username; ALTER SCHEMA ambari OWNER TO :username; ALTER ROLE :username SET search_path TO 'ambari'; - ---create tables and grant privileges to db user- -CREATE TABLE ambari.stack( - stack_id BIGINT NOT NULL, - stack_name VARCHAR(255) NOT NULL, - stack_version VARCHAR(255) NOT NULL, - CONSTRAINT PK_stack PRIMARY KEY (stack_id), - CONSTRAINT UQ_stack UNIQUE (stack_name, stack_version) -); -GRANT ALL PRIVILEGES ON TABLE ambari.stack TO :username; - -CREATE TABLE ambari.extension( - extension_id BIGINT NOT NULL, - extension_name VARCHAR(255) NOT NULL, - extension_version VARCHAR(255) NOT NULL, - CONSTRAINT PK_extension PRIMARY KEY (extension_id), - CONSTRAINT UQ_extension UNIQUE(extension_name, extension_version)); -GRANT ALL PRIVILEGES ON TABLE ambari.extension TO :username; - -CREATE TABLE ambari.extensionlink( - link_id BIGINT NOT NULL, - stack_id BIGINT NOT NULL, - extension_id BIGINT NOT NULL, - CONSTRAINT PK_extensionlink PRIMARY KEY (link_id), - CONSTRAINT FK_extensionlink_stack_id FOREIGN KEY (stack_id) REFERENCES ambari.stack(stack_id), - CONSTRAINT FK_extensionlink_extension_id FOREIGN KEY (extension_id) REFERENCES ambari.extension(extension_id), - CONSTRAINT UQ_extension_link UNIQUE(stack_id, extension_id)); -GRANT ALL PRIVILEGES ON TABLE ambari.extensionlink TO :username; - -CREATE TABLE ambari.adminresourcetype ( - resource_type_id INTEGER NOT NULL, - resource_type_name VARCHAR(255) NOT NULL, - CONSTRAINT PK_adminresourcetype PRIMARY KEY (resource_type_id) -); -GRANT ALL PRIVILEGES ON TABLE ambari.adminresourcetype TO :username; - -CREATE TABLE ambari.adminresource ( - resource_id BIGINT NOT NULL, - resource_type_id INTEGER NOT NULL, - CONSTRAINT PK_adminresource PRIMARY KEY (resource_id), - CONSTRAINT FK_resource_resource_type_id FOREIGN KEY (resource_type_id) REFERENCES ambari.adminresourcetype(resource_type_id) -); -GRANT ALL PRIVILEGES ON TABLE ambari.adminresource TO :username; - -CREATE TABLE ambari.clusters ( - cluster_id BIGINT NOT NULL, - resource_id BIGINT NOT NULL, - upgrade_id BIGINT, - cluster_info VARCHAR(255) NOT NULL, - cluster_name VARCHAR(100) NOT NULL UNIQUE, - provisioning_state VARCHAR(255) NOT NULL DEFAULT 'INIT', - security_type VARCHAR(32) NOT NULL DEFAULT 'NONE', - desired_cluster_state VARCHAR(255) NOT NULL, - desired_stack_id BIGINT NOT NULL, - CONSTRAINT PK_clusters PRIMARY KEY (cluster_id), - CONSTRAINT FK_clusters_desired_stack_id FOREIGN KEY (desired_stack_id) REFERENCES ambari.stack(stack_id), - CONSTRAINT FK_clusters_resource_id FOREIGN KEY (resource_id) REFERENCES ambari.adminresource(resource_id) -); -GRANT ALL PRIVILEGES ON TABLE ambari.clusters TO :username; - -CREATE TABLE ambari.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, - config_data TEXT NOT NULL, - config_attributes TEXT, - create_timestamp BIGINT NOT NULL, - CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id), - CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES ambari.clusters (cluster_id), - CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES ambari.stack(stack_id), - CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag), - CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version) -); -GRANT ALL PRIVILEGES ON TABLE ambari.clusterconfig TO :username; - -CREATE TABLE ambari.clusterconfigmapping ( - cluster_id BIGINT NOT NULL, - type_name VARCHAR(255) NOT NULL, - version_tag VARCHAR(255) NOT NULL, - create_timestamp BIGINT NOT NULL, - selected INTEGER NOT NULL DEFAULT 0, - user_name VARCHAR(255) NOT NULL DEFAULT '_db', - CONSTRAINT PK_clusterconfigmapping PRIMARY KEY (cluster_id, type_name, create_timestamp), - CONSTRAINT clusterconfigmappingcluster_id FOREIGN KEY (cluster_id) REFERENCES ambari.clusters (cluster_id) -); -GRANT ALL PRIVILEGES ON TABLE ambari.clusterconfigmapping TO :username; - -CREATE TABLE ambari.serviceconfig ( - service_config_id BIGINT NOT NULL, - cluster_id BIGINT NOT NULL, - service_name VARCHAR(255) NOT NULL, - version BIGINT NOT NULL, - create_timestamp BIGINT NOT NULL, - stack_id BIGINT NOT NULL, -
[2/3] ambari git commit: AMBARI-18226. Remove Redundant Embedded Postgres SQL (aonishuk)
http://git-wip-us.apache.org/repos/asf/ambari/blob/20eacc67/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql -- diff --git a/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql b/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql index 8f03989..9943cae 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql @@ -26,1707 +26,4 @@ GRANT ALL PRIVILEGES ON DATABASE :dbname TO :username; CREATE SCHEMA ambari AUTHORIZATION :username; ALTER SCHEMA ambari OWNER TO :username; ALTER ROLE :username SET search_path TO 'ambari'; - ---create tables and grant privileges to db user- -CREATE TABLE ambari.stack( - stack_id BIGINT NOT NULL, - stack_name VARCHAR(255) NOT NULL, - stack_version VARCHAR(255) NOT NULL, - CONSTRAINT PK_stack PRIMARY KEY (stack_id), - CONSTRAINT UQ_stack UNIQUE (stack_name, stack_version) -); -GRANT ALL PRIVILEGES ON TABLE ambari.stack TO :username; - -CREATE TABLE ambari.extension( - extension_id BIGINT NOT NULL, - extension_name VARCHAR(255) NOT NULL, - extension_version VARCHAR(255) NOT NULL, - CONSTRAINT PK_extension PRIMARY KEY (extension_id), - CONSTRAINT UQ_extension UNIQUE(extension_name, extension_version)); -GRANT ALL PRIVILEGES ON TABLE ambari.extension TO :username; - -CREATE TABLE ambari.extensionlink( - link_id BIGINT NOT NULL, - stack_id BIGINT NOT NULL, - extension_id BIGINT NOT NULL, - CONSTRAINT PK_extensionlink PRIMARY KEY (link_id), - CONSTRAINT FK_extensionlink_stack_id FOREIGN KEY (stack_id) REFERENCES ambari.stack(stack_id), - CONSTRAINT FK_extensionlink_extension_id FOREIGN KEY (extension_id) REFERENCES ambari.extension(extension_id), - CONSTRAINT UQ_extension_link UNIQUE(stack_id, extension_id)); -GRANT ALL PRIVILEGES ON TABLE ambari.extensionlink TO :username; - -CREATE TABLE ambari.adminresourcetype ( - resource_type_id INTEGER NOT NULL, - resource_type_name VARCHAR(255) NOT NULL, - CONSTRAINT PK_adminresourcetype PRIMARY KEY (resource_type_id) -); -GRANT ALL PRIVILEGES ON TABLE ambari.adminresourcetype TO :username; - -CREATE TABLE ambari.adminresource ( - resource_id BIGINT NOT NULL, - resource_type_id INTEGER NOT NULL, - CONSTRAINT PK_adminresource PRIMARY KEY (resource_id), - CONSTRAINT FK_resource_resource_type_id FOREIGN KEY (resource_type_id) REFERENCES ambari.adminresourcetype(resource_type_id) -); -GRANT ALL PRIVILEGES ON TABLE ambari.adminresource TO :username; - -CREATE TABLE ambari.clusters ( - cluster_id BIGINT NOT NULL, - resource_id BIGINT NOT NULL, - upgrade_id BIGINT, - cluster_info VARCHAR(255) NOT NULL, - cluster_name VARCHAR(100) NOT NULL UNIQUE, - provisioning_state VARCHAR(255) NOT NULL DEFAULT 'INIT', - security_type VARCHAR(32) NOT NULL DEFAULT 'NONE', - desired_cluster_state VARCHAR(255) NOT NULL, - desired_stack_id BIGINT NOT NULL, - CONSTRAINT PK_clusters PRIMARY KEY (cluster_id), - CONSTRAINT FK_clusters_desired_stack_id FOREIGN KEY (desired_stack_id) REFERENCES ambari.stack(stack_id), - CONSTRAINT FK_clusters_resource_id FOREIGN KEY (resource_id) REFERENCES ambari.adminresource(resource_id) -); -GRANT ALL PRIVILEGES ON TABLE ambari.clusters TO :username; - -CREATE TABLE ambari.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, - config_data TEXT NOT NULL, - config_attributes TEXT, - create_timestamp BIGINT NOT NULL, - CONSTRAINT PK_clusterconfig PRIMARY KEY (config_id), - CONSTRAINT FK_clusterconfig_cluster_id FOREIGN KEY (cluster_id) REFERENCES ambari.clusters (cluster_id), - CONSTRAINT FK_clusterconfig_stack_id FOREIGN KEY (stack_id) REFERENCES ambari.stack(stack_id), - CONSTRAINT UQ_config_type_tag UNIQUE (cluster_id, type_name, version_tag), - CONSTRAINT UQ_config_type_version UNIQUE (cluster_id, type_name, version) -); -GRANT ALL PRIVILEGES ON TABLE ambari.clusterconfig TO :username; - -CREATE TABLE ambari.clusterconfigmapping ( - cluster_id BIGINT NOT NULL, - type_name VARCHAR(255) NOT NULL, - version_tag VARCHAR(255) NOT NULL, - create_timestamp BIGINT NOT NULL, - selected INTEGER NOT NULL DEFAULT 0, - user_name VARCHAR(255) NOT NULL DEFAULT '_db', - CONSTRAINT PK_clusterconfigmapping PRIMARY KEY (cluster_id, type_name, create_timestamp), - CONSTRAINT clusterconfigmappingcluster_id FOREIGN KEY (cluster_id) REFERENCES ambari.clusters (cluster_id) -); -GRANT ALL PRIVILEGES ON TABLE ambari.clusterconfigmapping TO :username; - -CREATE TABLE ambari.serviceconfig ( - service_config_id BIGINT NOT NULL, - cluster_id BIGINT NOT NULL, - service_name VARCHAR(255) NOT NULL, - version BIGINT NOT NULL, - create_timestamp BIGINT NOT NULL, - stack_id BIGINT NOT NULL, -
