You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ranger.apache.org by ve...@apache.org on 2016/09/13 14:39:28 UTC
[2/2] incubator-ranger git commit: RANGER-1173: Improve Ranger
database schema import logic and make it more robust
RANGER-1173: Improve Ranger database schema import logic and make it more robust
Signed-off-by: Velmurugan Periasamy <ve...@apache.org>
Project: http://git-wip-us.apache.org/repos/asf/incubator-ranger/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-ranger/commit/68541c92
Tree: http://git-wip-us.apache.org/repos/asf/incubator-ranger/tree/68541c92
Diff: http://git-wip-us.apache.org/repos/asf/incubator-ranger/diff/68541c92
Branch: refs/heads/master
Commit: 68541c92afe3b6500ef28b3a6ee01149a337ad20
Parents: 1115ca8
Author: pradeep agrawal <pr...@freestoneinfotech.com>
Authored: Tue Sep 13 14:39:51 2016 +0530
Committer: Velmurugan Periasamy <ve...@apache.org>
Committed: Tue Sep 13 10:38:22 2016 -0400
----------------------------------------------------------------------
.../db/oracle/create_dbversion_catalog.sql | 1 +
security-admin/db/oracle/xa_core_db_oracle.sql | 1 -
security-admin/scripts/db_setup.py | 1023 +++++++++++++++---
3 files changed, 858 insertions(+), 167 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/68541c92/security-admin/db/oracle/create_dbversion_catalog.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/create_dbversion_catalog.sql b/security-admin/db/oracle/create_dbversion_catalog.sql
index 0017748..5820cc8 100644
--- a/security-admin/db/oracle/create_dbversion_catalog.sql
+++ b/security-admin/db/oracle/create_dbversion_catalog.sql
@@ -22,4 +22,5 @@ create table X_DB_VERSION_H (
updated_by VARCHAR(256) NOT NULL,
active VARCHAR(1) DEFAULT 'Y'
);
+CREATE SEQUENCE X_DB_VERSION_H_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
commit;
http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/68541c92/security-admin/db/oracle/xa_core_db_oracle.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/oracle/xa_core_db_oracle.sql b/security-admin/db/oracle/xa_core_db_oracle.sql
index 2ede810..d377482 100644
--- a/security-admin/db/oracle/xa_core_db_oracle.sql
+++ b/security-admin/db/oracle/xa_core_db_oracle.sql
@@ -31,7 +31,6 @@ CREATE SEQUENCE X_PORTAL_USER_ROLE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYC
CREATE SEQUENCE X_RESOURCE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE X_TRX_LOG_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE X_USER_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
-CREATE SEQUENCE X_DB_VERSION_H_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE V_TRX_LOG_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE XA_ACCESS_AUDIT_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
commit;