Repository: ambari Updated Branches: refs/heads/trunk 553e6dfc7 -> fb509d480
AMBARI-16924. Invalid syntax of Oracle DDL for cluster_handle (Gaurav Nagar via pallavkul) Project: http://git-wip-us.apache.org/repos/asf/ambari/repo Commit: http://git-wip-us.apache.org/repos/asf/ambari/commit/fb509d48 Tree: http://git-wip-us.apache.org/repos/asf/ambari/tree/fb509d48 Diff: http://git-wip-us.apache.org/repos/asf/ambari/diff/fb509d48 Branch: refs/heads/trunk Commit: fb509d480260c1372ba5cc7ac6426d5d3049ca84 Parents: 553e6df Author: Pallav Kulshreshtha <[email protected]> Authored: Fri May 27 17:19:20 2016 +0530 Committer: Pallav Kulshreshtha <[email protected]> Committed: Fri May 27 17:19:20 2016 +0530 ---------------------------------------------------------------------- .../src/main/resources/Ambari-DDL-Oracle-CREATE.sql | 8 ++++---- .../src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql | 8 ++++---- 2 files changed, 8 insertions(+), 8 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ambari/blob/fb509d48/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 a65df9c..edc46f7 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql @@ -565,7 +565,7 @@ CREATE TABLE viewinstance ( icon64 VARCHAR(255), xml_driven CHAR(1), alter_names NUMBER(1) DEFAULT 1 NOT NULL, - cluster_handle BIGINT, + cluster_handle NUMBER(19), cluster_type VARCHAR(100) DEFAULT 'LOCAL_AMBARI' NOT NULL, short_url NUMBER, CONSTRAINT PK_viewinstance PRIMARY KEY (view_instance_id), @@ -779,7 +779,7 @@ CREATE TABLE setting ( -- Remote Cluster table CREATE TABLE remoteambaricluster( - cluster_id BIGINT NOT NULL, + cluster_id NUMBER(19) NOT NULL, name VARCHAR(255) NOT NULL, username VARCHAR(255) NOT NULL, url VARCHAR(255) NOT NULL, @@ -788,8 +788,8 @@ CREATE TABLE remoteambaricluster( CONSTRAINT unq_remote_ambari_cluster UNIQUE (name)); CREATE TABLE remoteambariclusterservice( - id BIGINT NOT NULL, - cluster_id BIGINT NOT NULL, + id NUMBER(19) NOT NULL, + cluster_id NUMBER(19) NOT NULL, service_name VARCHAR(255) NOT NULL, CONSTRAINT PK_remote_ambari_service PRIMARY KEY (id), CONSTRAINT FK_remote_ambari_cluster_id FOREIGN KEY (cluster_id) REFERENCES remoteambaricluster(cluster_id) http://git-wip-us.apache.org/repos/asf/ambari/blob/fb509d48/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 bd2e6d6..61aadf0 100644 --- a/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql +++ b/ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql @@ -563,7 +563,7 @@ CREATE TABLE viewinstance ( icon64 VARCHAR(255), xml_driven CHAR(1), alter_names BIT NOT NULL DEFAULT 1, - cluster_handle BIGINT, + cluster_handle NUMERIC(19), cluster_type VARCHAR(100) NOT NULL DEFAULT 'LOCAL_AMBARI', short_url NUMERIC, CONSTRAINT PK_viewinstance PRIMARY KEY (view_instance_id), @@ -778,7 +778,7 @@ CREATE TABLE setting ( -- Remote Cluster table CREATE TABLE remoteambaricluster( - cluster_id BIGINT NOT NULL, + cluster_id NUMERIC(19) NOT NULL, name VARCHAR(255) NOT NULL, username VARCHAR(255) NOT NULL, url VARCHAR(255) NOT NULL, @@ -787,8 +787,8 @@ CREATE TABLE remoteambaricluster( CONSTRAINT unq_remote_ambari_cluster UNIQUE (name)); CREATE TABLE remoteambariclusterservice( - id BIGINT NOT NULL, - cluster_id BIGINT NOT NULL, + id NUMERIC(19) NOT NULL, + cluster_id NUMERIC(19) NOT NULL, service_name VARCHAR(255) NOT NULL, CONSTRAINT PK_remote_ambari_service PRIMARY KEY (id), CONSTRAINT FK_remote_ambari_cluster_id FOREIGN KEY (cluster_id) REFERENCES remoteambaricluster(cluster_id)
