You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ranger.apache.org by ga...@apache.org on 2016/04/04 07:41:23 UTC
incubator-ranger git commit: RANGER-896: Add Maria DB support for
Ranger and Ranger KMS
Repository: incubator-ranger
Updated Branches:
refs/heads/master 3e59571c6 -> 285ed0dda
RANGER-896: Add Maria DB support for Ranger and Ranger KMS
Signed-off-by: Gautam Borad <ga...@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/285ed0dd
Tree: http://git-wip-us.apache.org/repos/asf/incubator-ranger/tree/285ed0dd
Diff: http://git-wip-us.apache.org/repos/asf/incubator-ranger/diff/285ed0dd
Branch: refs/heads/master
Commit: 285ed0dda47b26503280de067ca4f5871a031923
Parents: 3e59571
Author: Pradeep Agrawal <pr...@freestoneinfotech.com>
Authored: Sat Apr 2 13:08:30 2016 +0530
Committer: Gautam Borad <ga...@apache.org>
Committed: Mon Apr 4 11:11:05 2016 +0530
----------------------------------------------------------------------
kms/scripts/db/mysql/kms_core_db.sql | 4 ++--
security-admin/db/mysql/xa_audit_db.sql | 2 +-
security-admin/db/mysql/xa_core_db.sql | 32 ++++++++++++++--------------
3 files changed, 19 insertions(+), 19 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/285ed0dd/kms/scripts/db/mysql/kms_core_db.sql
----------------------------------------------------------------------
diff --git a/kms/scripts/db/mysql/kms_core_db.sql b/kms/scripts/db/mysql/kms_core_db.sql
index 4e7cf29..1177595 100644
--- a/kms/scripts/db/mysql/kms_core_db.sql
+++ b/kms/scripts/db/mysql/kms_core_db.sql
@@ -24,7 +24,7 @@ CREATE TABLE `ranger_masterkey` (
`bitlength` int DEFAULT NULL ,
`masterkey` varchar(2048),
PRIMARY KEY ( `id` )
-)ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
DROP TABLE IF EXISTS `ranger_keystore`;
CREATE TABLE `ranger_keystore` (
@@ -42,4 +42,4 @@ CREATE TABLE `ranger_keystore` (
`kms_attributes` varchar(1024) DEFAULT NULL,
`kms_encoded`varchar(2048),
PRIMARY KEY (`id`)
-)ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/285ed0dd/security-admin/db/mysql/xa_audit_db.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/mysql/xa_audit_db.sql b/security-admin/db/mysql/xa_audit_db.sql
index 163d7b6..25b940f 100644
--- a/security-admin/db/mysql/xa_audit_db.sql
+++ b/security-admin/db/mysql/xa_audit_db.sql
@@ -67,7 +67,7 @@ CREATE TABLE `xa_access_audit` (
KEY `xa_access_audit_cr_time` (`create_time`),
KEY `xa_access_audit_up_time` (`update_time`),
KEY `xa_access_audit_event_time` (`event_time`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/285ed0dd/security-admin/db/mysql/xa_core_db.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/mysql/xa_core_db.sql b/security-admin/db/mysql/xa_core_db.sql
index 9d889a0..dcfce4d 100644
--- a/security-admin/db/mysql/xa_core_db.sql
+++ b/security-admin/db/mysql/xa_core_db.sql
@@ -87,7 +87,7 @@ CREATE TABLE `x_asset` (
KEY `x_asset_up_time` (`update_time`),
CONSTRAINT `x_asset_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_asset_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -129,7 +129,7 @@ CREATE TABLE `x_audit_map` (
CONSTRAINT `x_audit_map_FK_res_id` FOREIGN KEY (`res_id`) REFERENCES `x_resource` (`id`),
CONSTRAINT `x_audit_map_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_audit_map_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -173,7 +173,7 @@ CREATE TABLE `x_auth_sess` (
CONSTRAINT `x_auth_sess_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_auth_sess_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_auth_sess_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -207,7 +207,7 @@ CREATE TABLE `x_cred_store` (
KEY `x_cred_store_up_time` (`update_time`),
CONSTRAINT `x_cred_store_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_cred_store_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -239,7 +239,7 @@ CREATE TABLE `x_db_base` (
KEY `x_db_base_up_time` (`update_time`),
CONSTRAINT `x_db_base_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_db_base_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -278,7 +278,7 @@ CREATE TABLE `x_group` (
CONSTRAINT `x_group_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_group_FK_cred_store_id` FOREIGN KEY (`cred_store_id`) REFERENCES `x_cred_store` (`id`),
CONSTRAINT `x_group_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -317,7 +317,7 @@ CREATE TABLE `x_group_groups` (
CONSTRAINT `x_group_groups_FK_group_id` FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`),
CONSTRAINT `x_group_groups_FK_p_group_id` FOREIGN KEY (`p_group_id`) REFERENCES `x_group` (`id`),
CONSTRAINT `x_group_groups_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -356,7 +356,7 @@ CREATE TABLE `x_group_users` (
CONSTRAINT `x_group_users_FK_p_group_id` FOREIGN KEY (`p_group_id`) REFERENCES `x_group` (`id`),
CONSTRAINT `x_group_users_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_group_users_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -403,7 +403,7 @@ CREATE TABLE `x_perm_map` (
CONSTRAINT `x_perm_map_FK_res_id` FOREIGN KEY (`res_id`) REFERENCES `x_resource` (`id`),
CONSTRAINT `x_perm_map_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_perm_map_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -442,7 +442,7 @@ CREATE TABLE `x_policy_export_audit` (
KEY `x_policy_export_audit_up_time` (`update_time`),
CONSTRAINT `x_policy_export_audit_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_policy_export_audit_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -487,7 +487,7 @@ CREATE TABLE `x_portal_user` (
KEY `x_portal_user_email` (`email`),
CONSTRAINT `x_portal_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_portal_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+)AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -525,7 +525,7 @@ CREATE TABLE `x_portal_user_role` (
CONSTRAINT `x_portal_user_role_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_portal_user_role_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_portal_user_role_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
+)AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -579,7 +579,7 @@ CREATE TABLE `x_resource` (
CONSTRAINT `x_resource_FK_asset_id` FOREIGN KEY (`asset_id`) REFERENCES `x_asset` (`id`),
CONSTRAINT `x_resource_FK_parent_id` FOREIGN KEY (`parent_id`) REFERENCES `x_resource` (`id`),
CONSTRAINT `x_resource_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -625,7 +625,7 @@ CREATE TABLE `x_trx_log` (
KEY `x_trx_log_up_time` (`update_time`),
CONSTRAINT `x_trx_log_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_trx_log_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -663,7 +663,7 @@ CREATE TABLE `x_user` (
CONSTRAINT `x_user_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`),
CONSTRAINT `x_user_FK_cred_store_id` FOREIGN KEY (`cred_store_id`) REFERENCES `x_cred_store` (`id`),
CONSTRAINT `x_user_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -712,7 +712,7 @@ CREATE TABLE `xa_access_audit` (
KEY `xa_access_audit_cr_time` (`create_time`),
KEY `xa_access_audit_up_time` (`update_time`),
KEY `xa_access_audit_event_time` (`event_time`)
-) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+)DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--