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 <[email protected]> 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 <[email protected]> Authored: Sat Apr 2 13:08:30 2016 +0530 Committer: Gautam Borad <[email protected]> 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 */; --
