Repository: ambari Updated Branches: refs/heads/trunk 69197e630 -> 93ad28062
AMBARI-10301 - Stack Database Table Creation and Population From Resources (part2) (jonathanhurley) Project: http://git-wip-us.apache.org/repos/asf/ambari/repo Commit: http://git-wip-us.apache.org/repos/asf/ambari/commit/93ad2806 Tree: http://git-wip-us.apache.org/repos/asf/ambari/tree/93ad2806 Diff: http://git-wip-us.apache.org/repos/asf/ambari/diff/93ad2806 Branch: refs/heads/trunk Commit: 93ad280624e4484d68ffa22eb0de8e2bfe6bff3f Parents: 69197e6 Author: Jonathan Hurley <[email protected]> Authored: Wed Apr 1 19:04:56 2015 -0400 Committer: Jonathan Hurley <[email protected]> Committed: Wed Apr 1 19:04:56 2015 -0400 ---------------------------------------------------------------------- ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql | 2 +- ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql | 2 +- ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql | 2 +- .../src/main/resources/Ambari-DDL-Postgres-EMBEDDED-CREATE.sql | 2 +- ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql | 2 +- 5 files changed, 5 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ambari/blob/93ad2806/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 af10a0e..7593e07 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql @@ -837,7 +837,7 @@ CREATE TABLE stack( stack_name VARCHAR(255) NOT NULL, stack_version VARCHAR(255) NOT NULL, PRIMARY KEY (stack_id), - CONSTRAINT uni_stack UNIQUE(stack_name,stack_version) + CONSTRAINT unq_stack UNIQUE(stack_name,stack_version) ); -- In order for the first ID to be 1, must initialize the ambari_sequences table with a sequence_value of 0. http://git-wip-us.apache.org/repos/asf/ambari/blob/93ad2806/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 ff73f60..0562bc6 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql @@ -827,7 +827,7 @@ CREATE TABLE stack( stack_name VARCHAR2(255) NOT NULL, stack_version VARCHAR2(255) NOT NULL, PRIMARY KEY (stack_id), - CONSTRAINT uni_stack UNIQUE(stack_name,stack_version) + CONSTRAINT unq_stack UNIQUE(stack_name,stack_version) ); ---------inserting some data----------- http://git-wip-us.apache.org/repos/asf/ambari/blob/93ad2806/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 e48ea7a..44fde5f 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql @@ -829,7 +829,7 @@ CREATE TABLE stack( stack_name VARCHAR(255) NOT NULL, stack_version VARCHAR(255) NOT NULL, PRIMARY KEY (stack_id), - CONSTRAINT uni_stack UNIQUE(stack_name,stack_version) + CONSTRAINT unq_stack UNIQUE(stack_name,stack_version) ); ---------inserting some data----------- http://git-wip-us.apache.org/repos/asf/ambari/blob/93ad2806/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 49c92c0..74ea215 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 @@ -913,7 +913,7 @@ CREATE TABLE ambari.stack( stack_name VARCHAR(255) NOT NULL, stack_version VARCHAR(255) NOT NULL, PRIMARY KEY (stack_id), - CONSTRAINT uni_stack UNIQUE(stack_name,stack_version) + CONSTRAINT unq_stack UNIQUE(stack_name,stack_version) ); GRANT ALL PRIVILEGES ON TABLE ambari.upgrade TO :username; http://git-wip-us.apache.org/repos/asf/ambari/blob/93ad2806/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 5653ff8..2a7d3f9 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql @@ -372,7 +372,7 @@ CREATE TABLE stack( stack_name VARCHAR(255) NOT NULL, stack_version VARCHAR(255) NOT NULL, PRIMARY KEY (stack_id), - CONSTRAINT uni_stack UNIQUE(stack_name,stack_version) + CONSTRAINT unq_stack UNIQUE(stack_name,stack_version) ); ---------inserting some data-----------
