You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ambari.apache.org by ad...@apache.org on 2018/03/14 20:12:14 UTC
[ambari] branch trunk updated: AMBARI-23235. SQL errors in schema
create script for Oracle (#657)
This is an automated email from the ASF dual-hosted git repository.
adoroszlai pushed a commit to branch trunk
in repository https://gitbox.apache.org/repos/asf/ambari.git
The following commit(s) were added to refs/heads/trunk by this push:
new 522607f AMBARI-23235. SQL errors in schema create script for Oracle (#657)
522607f is described below
commit 522607f6d11ca0ae303fd29344d09ea356fe71df
Author: Doroszlai, Attila <64...@users.noreply.github.com>
AuthorDate: Wed Mar 14 21:12:12 2018 +0100
AMBARI-23235. SQL errors in schema create script for Oracle (#657)
---
ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
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 05f3deb..ee7230b 100644
--- a/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
+++ b/ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql
@@ -233,7 +233,7 @@ CREATE TABLE hostcomponentstate (
component_name VARCHAR2(255) NOT NULL,
version VARCHAR2(32) DEFAULT 'UNKNOWN' NOT NULL,
current_state VARCHAR2(255) NOT NULL,
- last_live_state VARCHAR2(255) NOT NULL DEFAULT 'UNKNOWN',
+ last_live_state VARCHAR2(255) DEFAULT 'UNKNOWN' NOT NULL,
host_id NUMBER(19) NOT NULL,
service_name VARCHAR2(255) NOT NULL,
upgrade_state VARCHAR2(32) DEFAULT 'NONE' NOT NULL,
@@ -960,11 +960,11 @@ CREATE TABLE kerberos_keytab (
);
CREATE TABLE kerberos_keytab_principal (
- kkp_id BIGINT NOT NULL DEFAULT 0,
+ kkp_id NUMBER(19) DEFAULT 0 NOT NULL,
keytab_path VARCHAR2(255) NOT NULL,
principal_name VARCHAR2(255) NOT NULL,
host_id NUMBER(19),
- is_distributed NUMBER(1) NOT NULL DEFAULT 0,
+ is_distributed NUMBER(1) DEFAULT 0 NOT NULL,
CONSTRAINT PK_kkp PRIMARY KEY (kkp_id),
CONSTRAINT FK_kkp_keytab_path FOREIGN KEY (keytab_path) REFERENCES kerberos_keytab (keytab_path),
CONSTRAINT FK_kkp_host_id FOREIGN KEY (host_id) REFERENCES hosts (host_id),
@@ -973,7 +973,7 @@ CREATE TABLE kerberos_keytab_principal (
);
CREATE TABLE kkp_mapping_service (
- kkp_id BIGINT NOT NULL DEFAULT 0,
+ kkp_id NUMBER(19) DEFAULT 0 NOT NULL,
service_name VARCHAR(255) NOT NULL,
component_name VARCHAR(255) NOT NULL,
CONSTRAINT PK_kkp_mapping_service PRIMARY KEY (kkp_id, service_name, component_name),
--
To stop receiving notification emails like this one, please contact
adoroszlai@apache.org.