http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/mysql/xa_db.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/mysql/xa_db.sql b/security-admin/db/mysql/xa_db.sql new file mode 100644 index 0000000..4b2919f --- /dev/null +++ b/security-admin/db/mysql/xa_db.sql @@ -0,0 +1,778 @@ +-- Licensed to the Apache Software Foundation (ASF) under one or more +-- contributor license agreements. See the NOTICE file distributed with +-- this work for additional information regarding copyright ownership. +-- The ASF licenses this file to You under the Apache License, Version 2.0 +-- (the "License"); you may not use this file except in compliance with +-- the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. + +-- MySQL dump 10.13 Distrib 5.1.50, for apple-darwin10.3.0 (i386) +-- +-- Host: localhost Database: xa_db +-- ------------------------------------------------------ +-- Server version 5.1.50 + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Current Database: `xa_db` +-- + +/*!40000 DROP DATABASE IF EXISTS `xa_db`*/; + +CREATE DATABASE /*!32312 IF NOT EXISTS*/ `xa_db` /*!40100 DEFAULT CHARACTER SET latin1 */; + +USE `xa_db`; + +-- +-- Temporary table structure for view `vx_trx_log` +-- + +DROP TABLE IF EXISTS `vx_trx_log`; +/*!50001 DROP VIEW IF EXISTS `vx_trx_log`*/; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +/*!50001 CREATE TABLE `vx_trx_log` ( + `id` bigint(20), + `create_time` datetime, + `update_time` datetime, + `added_by_id` bigint(20), + `upd_by_id` bigint(20), + `class_type` int(11), + `object_id` bigint(20), + `parent_object_id` bigint(20), + `parent_object_class_type` int(11), + `attr_name` varchar(255), + `parent_object_name` varchar(1024), + `object_name` varchar(1024), + `prev_val` varchar(1024), + `new_val` varchar(1024), + `trx_id` varchar(1024), + `action` varchar(255), + `sess_id` varchar(512), + `req_id` varchar(30), + `sess_type` varchar(30) +) ENGINE=MyISAM */; +SET character_set_client = @saved_cs_client; + +-- +-- Table structure for table `x_asset` +-- + +DROP TABLE IF EXISTS `x_asset`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_asset` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `asset_name` varchar(1024) NOT NULL, + `descr` varchar(4000) NOT NULL, + `act_status` int(11) NOT NULL DEFAULT '0', + `asset_type` int(11) NOT NULL DEFAULT '0', + `config` text, + `sup_native` tinyint(1) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), + KEY `x_asset_FK_added_by_id` (`added_by_id`), + KEY `x_asset_FK_upd_by_id` (`upd_by_id`), + KEY `x_asset_cr_time` (`create_time`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_asset` +-- + +LOCK TABLES `x_asset` WRITE; +/*!40000 ALTER TABLE `x_asset` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_asset` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_audit_map` +-- + +DROP TABLE IF EXISTS `x_audit_map`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_audit_map` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `res_id` bigint(20) DEFAULT NULL, + `group_id` bigint(20) DEFAULT NULL, + `user_id` bigint(20) DEFAULT NULL, + `audit_type` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), + KEY `x_audit_map_FK_added_by_id` (`added_by_id`), + KEY `x_audit_map_FK_upd_by_id` (`upd_by_id`), + KEY `x_audit_map_FK_res_id` (`res_id`), + KEY `x_audit_map_FK_group_id` (`group_id`), + KEY `x_audit_map_FK_user_id` (`user_id`), + KEY `x_audit_map_cr_time` (`create_time`), + KEY `x_audit_map_up_time` (`update_time`), + CONSTRAINT `x_audit_map_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), + CONSTRAINT `x_audit_map_FK_group_id` FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_audit_map` +-- + +LOCK TABLES `x_audit_map` WRITE; +/*!40000 ALTER TABLE `x_audit_map` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_audit_map` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_auth_sess` +-- + +DROP TABLE IF EXISTS `x_auth_sess`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_auth_sess` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `login_id` varchar(767) NOT NULL, + `user_id` bigint(20) DEFAULT NULL, + `ext_sess_id` varchar(512) DEFAULT NULL, + `auth_time` datetime NOT NULL, + `auth_status` int(11) NOT NULL DEFAULT '0', + `auth_type` int(11) NOT NULL DEFAULT '0', + `auth_provider` int(11) NOT NULL DEFAULT '0', + `device_type` int(11) NOT NULL DEFAULT '0', + `req_ip` varchar(48) NOT NULL, + `req_ua` varchar(1024) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `x_auth_sess_FK_added_by_id` (`added_by_id`), + KEY `x_auth_sess_FK_upd_by_id` (`upd_by_id`), + KEY `x_auth_sess_FK_user_id` (`user_id`), + KEY `x_auth_sess_cr_time` (`create_time`), + KEY `x_auth_sess_up_time` (`update_time`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_auth_sess` +-- + +LOCK TABLES `x_auth_sess` WRITE; +/*!40000 ALTER TABLE `x_auth_sess` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_auth_sess` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_cred_store` +-- + +DROP TABLE IF EXISTS `x_cred_store`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_cred_store` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `store_name` varchar(1024) NOT NULL, + `descr` varchar(4000) NOT NULL, + PRIMARY KEY (`id`), + KEY `x_cred_store_FK_added_by_id` (`added_by_id`), + KEY `x_cred_store_FK_upd_by_id` (`upd_by_id`), + KEY `x_cred_store_cr_time` (`create_time`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_cred_store` +-- + +LOCK TABLES `x_cred_store` WRITE; +/*!40000 ALTER TABLE `x_cred_store` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_cred_store` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_db_base` +-- + +DROP TABLE IF EXISTS `x_db_base`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_db_base` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `x_db_base_FK_added_by_id` (`added_by_id`), + KEY `x_db_base_FK_upd_by_id` (`upd_by_id`), + KEY `x_db_base_cr_time` (`create_time`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_db_base` +-- + +LOCK TABLES `x_db_base` WRITE; +/*!40000 ALTER TABLE `x_db_base` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_db_base` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_group` +-- + +DROP TABLE IF EXISTS `x_group`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_group` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `group_name` varchar(1024) NOT NULL, + `descr` varchar(4000) NOT NULL, + `status` int(11) NOT NULL DEFAULT '0', + `group_type` int(11) NOT NULL DEFAULT '0', + `group_src` int(11) NOT NULL DEFAULT '0', + `cred_store_id` bigint(20) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `x_group_FK_added_by_id` (`added_by_id`), + KEY `x_group_FK_upd_by_id` (`upd_by_id`), + KEY `x_group_FK_cred_store_id` (`cred_store_id`), + KEY `x_group_cr_time` (`create_time`), + KEY `x_group_up_time` (`update_time`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_group` +-- + +LOCK TABLES `x_group` WRITE; +/*!40000 ALTER TABLE `x_group` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_group` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_group_groups` +-- + +DROP TABLE IF EXISTS `x_group_groups`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_group_groups` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `group_name` varchar(1024) NOT NULL, + `p_group_id` bigint(20) DEFAULT NULL, + `group_id` bigint(20) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `x_group_groups_FK_added_by_id` (`added_by_id`), + KEY `x_group_groups_FK_upd_by_id` (`upd_by_id`), + KEY `x_group_groups_FK_p_group_id` (`p_group_id`), + KEY `x_group_groups_FK_group_id` (`group_id`), + KEY `x_group_groups_cr_time` (`create_time`), + KEY `x_group_groups_up_time` (`update_time`), + CONSTRAINT `x_group_groups_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_group_groups` +-- + +LOCK TABLES `x_group_groups` WRITE; +/*!40000 ALTER TABLE `x_group_groups` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_group_groups` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_group_users` +-- + +DROP TABLE IF EXISTS `x_group_users`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_group_users` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `group_name` varchar(1024) NOT NULL, + `p_group_id` bigint(20) DEFAULT NULL, + `user_id` bigint(20) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `x_group_users_FK_added_by_id` (`added_by_id`), + KEY `x_group_users_FK_upd_by_id` (`upd_by_id`), + KEY `x_group_users_FK_p_group_id` (`p_group_id`), + KEY `x_group_users_FK_user_id` (`user_id`), + KEY `x_group_users_cr_time` (`create_time`), + KEY `x_group_users_up_time` (`update_time`), + CONSTRAINT `x_group_users_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_group_users` +-- + +LOCK TABLES `x_group_users` WRITE; +/*!40000 ALTER TABLE `x_group_users` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_group_users` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_perm_map` +-- + +DROP TABLE IF EXISTS `x_perm_map`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_perm_map` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `perm_group` varchar(1024) DEFAULT NULL, + `res_id` bigint(20) DEFAULT NULL, + `group_id` bigint(20) DEFAULT NULL, + `user_id` bigint(20) DEFAULT NULL, + `perm_for` int(11) NOT NULL DEFAULT '0', + `perm_type` int(11) NOT NULL DEFAULT '0', + `is_recursive` int(11) NOT NULL DEFAULT '0', + `is_wild_card` tinyint(1) NOT NULL DEFAULT '1', + `grant_revoke` tinyint(1) NOT NULL DEFAULT '1', + `ip_address` text, + PRIMARY KEY (`id`), + KEY `x_perm_map_FK_added_by_id` (`added_by_id`), + KEY `x_perm_map_FK_upd_by_id` (`upd_by_id`), + KEY `x_perm_map_FK_res_id` (`res_id`), + KEY `x_perm_map_FK_group_id` (`group_id`), + KEY `x_perm_map_FK_user_id` (`user_id`), + KEY `x_perm_map_cr_time` (`create_time`), + KEY `x_perm_map_up_time` (`update_time`), + CONSTRAINT `x_perm_map_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), + CONSTRAINT `x_perm_map_FK_group_id` FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_perm_map` +-- + +LOCK TABLES `x_perm_map` WRITE; +/*!40000 ALTER TABLE `x_perm_map` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_perm_map` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_policy_export_audit` +-- + +DROP TABLE IF EXISTS `x_policy_export_audit`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_policy_export_audit` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `client_ip` varchar(255) NOT NULL, + `agent_id` varchar(255) DEFAULT NULL, + `req_epoch` bigint(20) NOT NULL, + `last_updated` datetime DEFAULT NULL, + `repository_name` varchar(1024) DEFAULT NULL, + `exported_json` text, + `http_ret_code` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), + KEY `x_policy_export_audit_FK_added_by_id` (`added_by_id`), + KEY `x_policy_export_audit_FK_upd_by_id` (`upd_by_id`), + KEY `x_policy_export_audit_cr_time` (`create_time`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_policy_export_audit` +-- + +LOCK TABLES `x_policy_export_audit` WRITE; +/*!40000 ALTER TABLE `x_policy_export_audit` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_policy_export_audit` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_portal_user` +-- + +DROP TABLE IF EXISTS `x_portal_user`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_portal_user` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `first_name` varchar(1022) DEFAULT NULL, + `last_name` varchar(1022) DEFAULT NULL, + `pub_scr_name` varchar(2048) DEFAULT NULL, + `login_id` varchar(767) DEFAULT NULL, + `password` varchar(512) NOT NULL, + `email` varchar(512) DEFAULT NULL, + `status` int(11) NOT NULL DEFAULT '0', + `user_src` int(11) NOT NULL DEFAULT '0', + `notes` varchar(4000) DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `x_portal_user_UK_login_id` (`login_id`), + UNIQUE KEY `x_portal_user_UK_email` (`email`), + KEY `x_portal_user_FK_added_by_id` (`added_by_id`), + KEY `x_portal_user_FK_upd_by_id` (`upd_by_id`), + KEY `x_portal_user_cr_time` (`create_time`), + KEY `x_portal_user_up_time` (`update_time`), + KEY `x_portal_user_name` (`first_name`(767)), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_portal_user` +-- + +LOCK TABLES `x_portal_user` WRITE; +/*!40000 ALTER TABLE `x_portal_user` DISABLE KEYS */; +INSERT INTO `x_portal_user` VALUES (1,'2014-05-25 00:07:26','2014-05-25 00:07:26',NULL,NULL,'Admin','','Admin','admin','ceb4f32325eda6142bd65215f4c0f371','',1,0,NULL); +/*!40000 ALTER TABLE `x_portal_user` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_portal_user_role` +-- + +DROP TABLE IF EXISTS `x_portal_user_role`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_portal_user_role` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `user_id` bigint(20) NOT NULL, + `user_role` varchar(128) DEFAULT NULL, + `status` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`id`), + KEY `x_portal_user_role_FK_added_by_id` (`added_by_id`), + KEY `x_portal_user_role_FK_upd_by_id` (`upd_by_id`), + KEY `x_portal_user_role_FK_user_id` (`user_id`), + KEY `x_portal_user_role_cr_time` (`create_time`), + KEY `x_portal_user_role_up_time` (`update_time`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_portal_user_role` +-- + +LOCK TABLES `x_portal_user_role` WRITE; +/*!40000 ALTER TABLE `x_portal_user_role` DISABLE KEYS */; +INSERT INTO `x_portal_user_role` VALUES (1,'2014-05-25 00:07:26','2014-05-25 00:07:26',NULL,NULL,1,'ROLE_SYS_ADMIN',1); +/*!40000 ALTER TABLE `x_portal_user_role` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_resource` +-- + +DROP TABLE IF EXISTS `x_resource`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_resource` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `res_name` varchar(4000) DEFAULT NULL, + `policy_name` varchar(500) DEFAULT NULL, + `descr` varchar(4000) DEFAULT NULL, + `res_type` int(11) NOT NULL DEFAULT '0', + `asset_id` bigint(20) NOT NULL, + `parent_id` bigint(20) DEFAULT NULL, + `parent_path` varchar(4000) DEFAULT NULL, + `is_encrypt` int(11) NOT NULL DEFAULT '0', + `is_recursive` int(11) NOT NULL DEFAULT '0', + `res_group` varchar(1024) DEFAULT NULL, + `res_dbs` text, + `res_tables` text, + `res_col_fams` text, + `res_cols` text, + `res_udfs` text, + `res_status` int(11) NOT NULL DEFAULT '1', + `table_type` int(11) NOT NULL DEFAULT '0', + `col_type` int(11) NOT NULL DEFAULT '0', + `res_topologies` text, + `res_services` text, + PRIMARY KEY (`id`), + UNIQUE KEY `policy_name` (`policy_name`), + KEY `x_resource_FK_added_by_id` (`added_by_id`), + KEY `x_resource_FK_upd_by_id` (`upd_by_id`), + KEY `x_resource_FK_asset_id` (`asset_id`), + KEY `x_resource_FK_parent_id` (`parent_id`), + KEY `x_resource_cr_time` (`create_time`), + KEY `x_resource_up_time` (`update_time`), + CONSTRAINT `x_resource_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_resource` +-- + +LOCK TABLES `x_resource` WRITE; +/*!40000 ALTER TABLE `x_resource` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_resource` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_trx_log` +-- + +DROP TABLE IF EXISTS `x_trx_log`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_trx_log` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `class_type` int(11) NOT NULL DEFAULT '0', + `object_id` bigint(20) DEFAULT NULL, + `parent_object_id` bigint(20) DEFAULT NULL, + `parent_object_class_type` int(11) NOT NULL DEFAULT '0', + `parent_object_name` varchar(1024) DEFAULT NULL, + `object_name` varchar(1024) DEFAULT NULL, + `attr_name` varchar(255) DEFAULT NULL, + `prev_val` varchar(1024) DEFAULT NULL, + `new_val` varchar(1024) DEFAULT NULL, + `trx_id` varchar(1024) DEFAULT NULL, + `action` varchar(255) DEFAULT NULL, + `sess_id` varchar(512) DEFAULT NULL, + `req_id` varchar(30) DEFAULT NULL, + `sess_type` varchar(30) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `x_trx_log_FK_added_by_id` (`added_by_id`), + KEY `x_trx_log_FK_upd_by_id` (`upd_by_id`), + KEY `x_trx_log_cr_time` (`create_time`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_trx_log` +-- + +LOCK TABLES `x_trx_log` WRITE; +/*!40000 ALTER TABLE `x_trx_log` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_trx_log` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `x_user` +-- + +DROP TABLE IF EXISTS `x_user`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `x_user` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `user_name` varchar(1024) NOT NULL, + `descr` varchar(4000) NOT NULL, + `status` int(11) NOT NULL DEFAULT '0', + `cred_store_id` bigint(20) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `x_user_FK_added_by_id` (`added_by_id`), + KEY `x_user_FK_upd_by_id` (`upd_by_id`), + KEY `x_user_FK_cred_store_id` (`cred_store_id`), + KEY `x_user_cr_time` (`create_time`), + KEY `x_user_up_time` (`update_time`), + 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; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `x_user` +-- + +LOCK TABLES `x_user` WRITE; +/*!40000 ALTER TABLE `x_user` DISABLE KEYS */; +/*!40000 ALTER TABLE `x_user` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `xa_access_audit` +-- + +DROP TABLE IF EXISTS `xa_access_audit`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `xa_access_audit` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT, + `create_time` datetime DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `added_by_id` bigint(20) DEFAULT NULL, + `upd_by_id` bigint(20) DEFAULT NULL, + `audit_type` int(11) NOT NULL DEFAULT '0', + `access_result` int(11) DEFAULT '0', + `access_type` varchar(255) DEFAULT NULL, + `acl_enforcer` varchar(255) DEFAULT NULL, + `agent_id` varchar(255) DEFAULT NULL, + `client_ip` varchar(255) DEFAULT NULL, + `client_type` varchar(255) DEFAULT NULL, + `policy_id` bigint(20) DEFAULT '0', + `repo_name` varchar(255) DEFAULT NULL, + `repo_type` int(11) DEFAULT '0', + `result_reason` varchar(255) DEFAULT NULL, + `session_id` varchar(255) DEFAULT NULL, + `event_time` datetime DEFAULT NULL, + `request_user` varchar(255) DEFAULT NULL, + `action` varchar(2000) DEFAULT NULL, + `request_data` varchar(2000) DEFAULT NULL, + `resource_path` varchar(2000) DEFAULT NULL, + `resource_type` varchar(255) DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `xa_access_audit_FK_added_by_id` (`added_by_id`), + KEY `xa_access_audit_FK_upd_by_id` (`upd_by_id`), + KEY `xa_access_audit_cr_time` (`create_time`), + KEY `xa_access_audit_up_time` (`update_time`), + CONSTRAINT `xa_access_audit_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), + CONSTRAINT `xa_access_audit_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `xa_access_audit` +-- + +LOCK TABLES `xa_access_audit` WRITE; +/*!40000 ALTER TABLE `xa_access_audit` DISABLE KEYS */; +/*!40000 ALTER TABLE `xa_access_audit` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Current Database: `xa_db` +-- + +USE `xa_db`; + +-- +-- Final view structure for view `vx_trx_log` +-- + +/*!50001 DROP TABLE IF EXISTS `vx_trx_log`*/; +/*!50001 DROP VIEW IF EXISTS `vx_trx_log`*/; +/*!50001 SET @saved_cs_client = @@character_set_client */; +/*!50001 SET @saved_cs_results = @@character_set_results */; +/*!50001 SET @saved_col_connection = @@collation_connection */; +/*!50001 SET character_set_client = latin1 */; +/*!50001 SET character_set_results = latin1 */; +/*!50001 SET collation_connection = latin1_swedish_ci */; +/*!50001 CREATE ALGORITHM=UNDEFINED */ +/*!50013 DEFINER=`xaadmin`@`localhost` SQL SECURITY DEFINER */ +/*!50001 VIEW `vx_trx_log` AS select `x_trx_log`.`id` AS `id`,`x_trx_log`.`create_time` AS `create_time`,`x_trx_log`.`update_time` AS `update_time`,`x_trx_log`.`added_by_id` AS `added_by_id`,`x_trx_log`.`upd_by_id` AS `upd_by_id`,`x_trx_log`.`class_type` AS `class_type`,`x_trx_log`.`object_id` AS `object_id`,`x_trx_log`.`parent_object_id` AS `parent_object_id`,`x_trx_log`.`parent_object_class_type` AS `parent_object_class_type`,`x_trx_log`.`attr_name` AS `attr_name`,`x_trx_log`.`parent_object_name` AS `parent_object_name`,`x_trx_log`.`object_name` AS `object_name`,`x_trx_log`.`prev_val` AS `prev_val`,`x_trx_log`.`new_val` AS `new_val`,`x_trx_log`.`trx_id` AS `trx_id`,`x_trx_log`.`action` AS `action`,`x_trx_log`.`sess_id` AS `sess_id`,`x_trx_log`.`req_id` AS `req_id`,`x_trx_log`.`sess_type` AS `sess_type` from `x_trx_log` group by `x_trx_log`.`trx_id` */; +/*!50001 SET character_set_client = @saved_cs_client */; +/*!50001 SET character_set_results = @saved_cs_results */; +/*!50001 SET collation_connection = @saved_col_connection */; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2014-05-25 0:07:27
http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/mysql/xa_db_bare.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/mysql/xa_db_bare.sql b/security-admin/db/mysql/xa_db_bare.sql new file mode 100644 index 0000000..8204f1d --- /dev/null +++ b/security-admin/db/mysql/xa_db_bare.sql @@ -0,0 +1,15 @@ +-- Licensed to the Apache Software Foundation (ASF) under one or more +-- contributor license agreements. See the NOTICE file distributed with +-- this work for additional information regarding copyright ownership. +-- The ASF licenses this file to You under the Apache License, Version 2.0 +-- (the "License"); you may not use this file except in compliance with +-- the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. + http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/001-groupsource.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/oracle/patches/001-groupsource.sql b/security-admin/db/oracle/patches/001-groupsource.sql index cda2d15..a6b0a13 100644 --- a/security-admin/db/oracle/patches/001-groupsource.sql +++ b/security-admin/db/oracle/patches/001-groupsource.sql @@ -25,5 +25,4 @@ BEGIN execute immediate 'ALTER TABLE x_group ADD group_src NUMBER(10) DEFAULT 0 NOT NULL'; commit; end if; -end; -/ +end;/ \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/002-policyname.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/oracle/patches/002-policyname.sql b/security-admin/db/oracle/patches/002-policyname.sql index be20751..4eb71ee 100644 --- a/security-admin/db/oracle/patches/002-policyname.sql +++ b/security-admin/db/oracle/patches/002-policyname.sql @@ -25,5 +25,4 @@ BEGIN execute immediate 'ALTER TABLE x_resource ADD CONSTRAINT x_resource_UK_policy_name UNIQUE(policy_name)'; commit; end if; -end; -/ +end;/ \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/003-knoxrepo.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/oracle/patches/003-knoxrepo.sql b/security-admin/db/oracle/patches/003-knoxrepo.sql index 422649c..ee0ce87 100644 --- a/security-admin/db/oracle/patches/003-knoxrepo.sql +++ b/security-admin/db/oracle/patches/003-knoxrepo.sql @@ -45,5 +45,4 @@ Select count(*) into v_column_exists execute immediate 'ALTER TABLE x_perm_map ADD ip_address CLOB DEFAULT NULL NULL'; commit; end if; -end; -/ +end;/ \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql b/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql index 55c0cd5..dbdd55a 100644 --- a/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql +++ b/security-admin/db/oracle/patches/006-createdefaultpublicgroup.sql @@ -25,5 +25,4 @@ BEGIN commit; end if; end if; -end; -/ +end;/ \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/patches/009-updated_schema.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/oracle/patches/009-updated_schema.sql b/security-admin/db/oracle/patches/009-updated_schema.sql new file mode 100644 index 0000000..2101d03 --- /dev/null +++ b/security-admin/db/oracle/patches/009-updated_schema.sql @@ -0,0 +1,407 @@ +-- Licensed to the Apache Software Foundation (ASF) under one or more +-- contributor license agreements. See the NOTICE file distributed with +-- this work for additional information regarding copyright ownership. +-- The ASF licenses this file to You under the Apache License, Version 2.0 +-- (the "License"); you may not use this file except in compliance with +-- the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. +/ +CREATE SEQUENCE X_SERVICE_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_SERVICE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_POLICY_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_SERVICE_CONFIG_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_RESOURCE_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_ACCESS_TYPE_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_ACCESS_TYPE_DEF_GRANTS_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_POLICY_CONDITION_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_ENUM_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_ENUM_ELEMENT_DEF_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_SERVICE_CONFIG_MAP_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_POLICY_RESOURCE_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_POLICY_RESOURCE_MAP_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_POLICY_ITEM_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_POLICY_ITEM_ACCESS_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_POLICY_ITEM_CONDITION_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_POLICY_ITEM_USER_PERM_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_POLICY_ITEM_GROUP_PERM_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +CREATE SEQUENCE X_DATA_HIST_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; +commit; +CREATE TABLE x_service_def ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +version NUMBER(20) DEFAULT NULL NULL, +name VARCHAR(1024) DEFAULT NULL NULL, +impl_class_name VARCHAR(1024) DEFAULT NULL NULL, +label VARCHAR(1024) DEFAULT NULL NULL, +description VARCHAR(1024) DEFAULT NULL NULL, +rb_key_label VARCHAR(1024) DEFAULT NULL NULL, +rb_key_description VARCHAR(1024) DEFAULT NULL NULL, +is_enabled NUMBER(1) DEFAULT '1' NULL, +PRIMARY KEY (id), +CONSTRAINT x_service_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_service_def_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_service( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +version NUMBER(20) DEFAULT NULL NULL, +type NUMBER(20) DEFAULT NULL NULL, +name varchar(512) DEFAULT NULL NULL, +policy_version NUMBER(20) DEFAULT NULL NULL, +policy_update_time DATE DEFAULT NULL NULL, +description VARCHAR(1024) DEFAULT NULL NULL, +is_enabled NUMBER(1) DEFAULT '0' NOT NULL, +primary key (id), +CONSTRAINT x_service_name UNIQUE (name), +CONSTRAINT x_service_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_service_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_service_FK_type FOREIGN KEY (type) REFERENCES x_service_def (id) +); +commit; +CREATE TABLE x_policy ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +version NUMBER(20) DEFAULT NULL NULL, +service NUMBER(20) DEFAULT NULL NULL, +name VARCHAR(512) DEFAULT NULL NULL, +description VARCHAR(1024) DEFAULT NULL NULL, +is_enabled NUMBER(1) DEFAULT '0' NOT NULL, +is_audit_enabled NUMBER(1) DEFAULT '0' NOT NULL, +primary key (id), +CONSTRAINT x_policy_name UNIQUE (name), +CONSTRAINT x_policy_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_policy_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_policy_FK_service FOREIGN KEY (service) REFERENCES x_service (id) +); +commit; +CREATE TABLE x_service_config_def ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +def_id NUMBER(20) NOT NULL, +name VARCHAR(1024) DEFAULT NULL NULL, +type VARCHAR(1024) DEFAULT NULL NULL, +sub_type VARCHAR(1024) DEFAULT NULL NULL, +is_mandatory NUMBER(1) DEFAULT '0' NOT NULL, +default_value VARCHAR(1024) DEFAULT NULL NULL, +label VARCHAR(1024) DEFAULT NULL NULL, +description VARCHAR(1024) DEFAULT NULL NULL, +rb_key_label VARCHAR(1024) DEFAULT NULL NULL, +rb_key_decription VARCHAR(1024) DEFAULT NULL NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_service_conf_def_FK_defid FOREIGN KEY (def_id) REFERENCES x_service_def (id), +CONSTRAINT x_service_conf_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_service_conf_def_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_resource_def ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +def_id NUMBER(20) NOT NULL, +name VARCHAR(1024) DEFAULT NULL NULL, +type VARCHAR(1024) DEFAULT NULL NULL, +res_level NUMBER(20) DEFAULT NULL NULL, +parent NUMBER(20) DEFAULT NULL NULL, +mandatory NUMBER(1) DEFAULT '0' NOT NULL, +look_up_supported NUMBER(1) DEFAULT '0' NOT NULL, +recursive_supported NUMBER(1) DEFAULT '0' NOT NULL, +excludes_supported NUMBER(1) DEFAULT '0' NOT NULL, +matcher VARCHAR(1024) DEFAULT NULL NULL, +matcher_options varchar(1024) DEFAULT NULL NULL, +label VARCHAR(1024) DEFAULT NULL NULL, +description VARCHAR(1024) DEFAULT NULL NULL, +rb_key_label VARCHAR(1024) DEFAULT NULL NULL, +rb_key_description VARCHAR(1024) DEFAULT NULL NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_resource_def_FK_parent FOREIGN KEY (parent) REFERENCES x_resource_def (id), +CONSTRAINT x_resource_def_FK_defid FOREIGN KEY (def_id) REFERENCES x_service_def (id), +CONSTRAINT x_resource_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_resource_def_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_access_type_def ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +def_id NUMBER(20) NOT NULL, +name VARCHAR(1024) DEFAULT NULL NULL, +label VARCHAR(1024) DEFAULT NULL NULL, +rb_key_label VARCHAR(1024) DEFAULT NULL NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_access_type_def_FK_defid FOREIGN KEY (def_id) REFERENCES x_service_def (id), +CONSTRAINT x_access_type_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_access_type_def_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_access_type_def_grants ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +atd_id NUMBER(20) NOT NULL, +implied_grant VARCHAR(1024) DEFAULT NULL NULL, +primary key (id), +CONSTRAINT x_atd_grants_FK_atdid FOREIGN KEY (atd_id) REFERENCES x_access_type_def (id), +CONSTRAINT x_atd_grants_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_atd_grants_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_policy_condition_def ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +def_id NUMBER(20) NOT NULL, +name VARCHAR(1024) DEFAULT NULL NULL, +evaluator VARCHAR(1024) DEFAULT NULL NULL, +evaluator_options VARCHAR(1024) DEFAULT NULL NULL, +label VARCHAR(1024) DEFAULT NULL NULL, +description VARCHAR(1024) DEFAULT NULL NULL, +rb_key_label VARCHAR(1024) DEFAULT NULL NULL, +rb_key_description VARCHAR(1024) DEFAULT NULL NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_policy_cond_def_FK_defid FOREIGN KEY (def_id) REFERENCES x_service_def (id), +CONSTRAINT x_policy_cond_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_policy_cond_def_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_enum_def ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +def_id NUMBER(20) NOT NULL, +name VARCHAR(1024) DEFAULT NULL NULL, +default_index NUMBER(20) DEFAULT NULL NULL, +primary key (id), +CONSTRAINT x_enum_def_FK_def_id FOREIGN KEY (def_id) REFERENCES x_service_def (id), +CONSTRAINT x_enum_def_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_enum_def_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_enum_element_def ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +enum_def_id NUMBER(20) NOT NULL, +name VARCHAR(1024) DEFAULT NULL NULL, +label VARCHAR(1024) DEFAULT NULL NULL, +rb_key_label VARCHAR(1024) DEFAULT NULL NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_enum_element_def_FK_defid FOREIGN KEY (enum_def_id) REFERENCES x_enum_def (id), +CONSTRAINT x_enum_element_def_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_enum_element_def_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_service_config_map ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +service NUMBER(20) NOT NULL, +config_key VARCHAR(1024) DEFAULT NULL NULL, +config_value VARCHAR(1024) DEFAULT NULL NULL, +primary key (id), +CONSTRAINT x_service_conf_map_FK_service FOREIGN KEY (service) REFERENCES x_service (id), +CONSTRAINT x_service_conf_map_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_service_conf_map_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_policy_resource ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +policy_id NUMBER(20) NOT NULL, +res_def_id NUMBER(20) NOT NULL, +is_excludes NUMBER(1) DEFAULT '0' NOT NULL, +is_recursive NUMBER(1) DEFAULT '0' NOT NULL, +primary key (id), +CONSTRAINT x_policy_res_FK_policy_id FOREIGN KEY (policy_id) REFERENCES x_policy (id), +CONSTRAINT x_policy_res_FK_res_def_id FOREIGN KEY (res_def_id) REFERENCES x_resource_def (id), +CONSTRAINT x_policy_res_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_policy_res_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_policy_resource_map ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +resource_id NUMBER(20) NOT NULL, +value VARCHAR(1024) DEFAULT NULL NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_policy_res_map_FK_res_id FOREIGN KEY (resource_id) REFERENCES x_policy_resource (id), +CONSTRAINT x_policy_res_map_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_policy_res_map_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_policy_item ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +policy_id NUMBER(20) NOT NULL, +delegate_admin NUMBER(1) DEFAULT '0' NOT NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_policy_item_FK_policy_id FOREIGN KEY (policy_id) REFERENCES x_policy (id), +CONSTRAINT x_policy_item_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_policy_item_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_policy_item_access ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +policy_item_id NUMBER(20) NOT NULL, +type NUMBER(20) NOT NULL, +is_allowed NUMBER(3) DEFAULT '0' NOT NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_plc_item_access_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES x_policy_item (id), +CONSTRAINT x_plc_item_access_FK_atd_id FOREIGN KEY (type) REFERENCES x_access_type_def (id), +CONSTRAINT x_plc_item_access_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_plc_item_access_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_policy_item_condition ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +policy_item_id NUMBER(20) NOT NULL, +type NUMBER(20) NOT NULL, +value VARCHAR(1024) DEFAULT NULL NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_plc_item_cond_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES x_policy_item (id), +CONSTRAINT x_plc_item_cond_FK_pcd_id FOREIGN KEY (type) REFERENCES x_policy_condition_def (id), +CONSTRAINT x_plc_item_cond_FK_added_by_id FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_plc_item_cond_FK_upd_by_id FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_policy_item_user_perm ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +policy_item_id NUMBER(20) NOT NULL, +user_id NUMBER(20) DEFAULT NULL NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_plc_itm_usr_perm_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES x_policy_item (id), +CONSTRAINT x_plc_itm_usr_perm_FK_user_id FOREIGN KEY (user_id) REFERENCES x_user (id), +CONSTRAINT x_plc_itm_usr_perm_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_plc_itm_usr_perm_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_policy_item_group_perm ( +id NUMBER(20) NOT NULL, +guid VARCHAR(1024) DEFAULT NULL NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +added_by_id NUMBER(20) DEFAULT NULL NULL, +upd_by_id NUMBER(20) DEFAULT NULL NULL, +policy_item_id NUMBER(20) NOT NULL, +group_id NUMBER(20) DEFAULT NULL NULL, +sort_order NUMBER(3) DEFAULT '0' NULL, +primary key (id), +CONSTRAINT x_plc_itm_grp_perm_FK_pi_id FOREIGN KEY (policy_item_id) REFERENCES x_policy_item (id), +CONSTRAINT x_plc_itm_grp_perm_FK_group_id FOREIGN KEY (group_id) REFERENCES x_group (id), +CONSTRAINT x_plc_itm_grp_perm_FK_added_by FOREIGN KEY (added_by_id) REFERENCES x_portal_user (id), +CONSTRAINT x_plc_itm_grp_perm_FK_upd_by FOREIGN KEY (upd_by_id) REFERENCES x_portal_user (id) +); +commit; +CREATE TABLE x_data_hist ( +id NUMBER(20) NOT NULL, +create_time DATE DEFAULT NULL NULL, +update_time DATE DEFAULT NULL NULL, +obj_guid VARCHAR(1024) NOT NULL, +obj_class_type NUMBER(11) NOT NULL, +obj_id NUMBER(20) NOT NULL, +obj_name VARCHAR(1024) NOT NULL, +version NUMBER(20) DEFAULT NULL NULL, +action VARCHAR(512)NOT NULL, +from_time DATE NOT NULL, +to_time DATE DEFAULT NULL NULL, +content CLOB NOT NULL, +primary key (id) +); +commit; +CREATE INDEX x_service_def_added_by_id ON x_service_def(added_by_id); +CREATE INDEX x_service_def_upd_by_id ON x_service_def(upd_by_id); +CREATE INDEX x_service_def_cr_time ON x_service_def(create_time); +CREATE INDEX x_service_def_up_time ON x_service_def(update_time); +CREATE INDEX x_service_added_by_id ON x_service(added_by_id); +CREATE INDEX x_service_upd_by_id ON x_service(upd_by_id); +CREATE INDEX x_service_cr_time ON x_service(create_time); +CREATE INDEX x_service_up_time ON x_service(update_time); +CREATE INDEX x_service_type ON x_service(type); +CREATE INDEX x_policy_added_by_id ON x_policy(added_by_id); +CREATE INDEX x_policy_upd_by_id ON x_policy(upd_by_id); +CREATE INDEX x_policy_cr_time ON x_policy(create_time); +CREATE INDEX x_policy_up_time ON x_policy(update_time); +CREATE INDEX x_policy_service ON x_policy(service); +CREATE INDEX x_resource_def_parent ON x_resource_def(parent); +commit; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/reset_audit_db_oracle.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/oracle/reset_audit_db_oracle.sql b/security-admin/db/oracle/reset_audit_db_oracle.sql new file mode 100644 index 0000000..8ec832b --- /dev/null +++ b/security-admin/db/oracle/reset_audit_db_oracle.sql @@ -0,0 +1,71 @@ +-- Licensed to the Apache Software Foundation (ASF) under one or more +-- contributor license agreements. See the NOTICE file distributed with +-- this work for additional information regarding copyright ownership. +-- The ASF licenses this file to You under the Apache License, Version 2.0 +-- (the "License"); you may not use this file except in compliance with +-- the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. + +CREATE OR REPLACE PROCEDURE sp_dropobject(ObjName IN varchar2,ObjType IN varchar2) +IS +v_counter integer; +BEGIN +if (ObjType = 'TABLE') then + select count(*) into v_counter from user_tables where table_name = upper(ObjName); + if (v_counter > 0) then + execute immediate 'drop table ' || ObjName || ' cascade constraints'; + end if; +end if; + if (ObjType = 'PROCEDURE') then + select count(*) into v_counter from User_Objects where object_type = 'PROCEDURE' and OBJECT_NAME = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP PROCEDURE ' || ObjName; + end if; + end if; + if (ObjType = 'FUNCTION') then + select count(*) into v_counter from User_Objects where object_type = 'FUNCTION' and OBJECT_NAME = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP FUNCTION ' || ObjName; + end if; + end if; + if (ObjType = 'TRIGGER') then + select count(*) into v_counter from User_Triggers where TRIGGER_NAME = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP TRIGGER ' || ObjName; + end if; + end if; + if (ObjType = 'VIEW') then + select count(*) into v_counter from User_Views where VIEW_NAME = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP VIEW ' || ObjName; + end if; + end if; + if (ObjType = 'SEQUENCE') then + select count(*) into v_counter from user_sequences where sequence_name = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP SEQUENCE ' || ObjName; + end if; + end if; + if (ObjType = 'INDEX') then + select count(*) into v_counter from user_indexes where index_name = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP INDEX ' || ObjName; + end if; + end if; +END; +/ +call sp_dropobject('XA_ACCESS_AUDIT','TABLE'); +call sp_dropobject('XA_ACCESS_AUDIT_SEQ','SEQUENCE'); +call sp_dropobject('xa_access_audit_added_by_id','INDEX'); +call sp_dropobject('xa_access_audit_upd_by_id','INDEX'); +call sp_dropobject('xa_access_audit_cr_time','INDEX'); +call sp_dropobject('xa_access_audit_up_time','INDEX'); +call sp_dropobject('xa_access_audit_event_time','INDEX'); +commit; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/reset_core_db_oracle.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/oracle/reset_core_db_oracle.sql b/security-admin/db/oracle/reset_core_db_oracle.sql new file mode 100644 index 0000000..ce94027 --- /dev/null +++ b/security-admin/db/oracle/reset_core_db_oracle.sql @@ -0,0 +1,114 @@ +-- Licensed to the Apache Software Foundation (ASF) under one or more +-- contributor license agreements. See the NOTICE file distributed with +-- this work for additional information regarding copyright ownership. +-- The ASF licenses this file to You under the Apache License, Version 2.0 +-- (the "License"); you may not use this file except in compliance with +-- the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, software +-- distributed under the License is distributed on an "AS IS" BASIS, +-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +-- See the License for the specific language governing permissions and +-- limitations under the License. + +-- create or replace procedure +commit; +CREATE OR REPLACE PROCEDURE sp_dropobject(ObjName IN varchar2,ObjType IN varchar2) +IS +v_counter integer; +BEGIN +if (ObjType = 'TABLE') then + select count(*) into v_counter from user_tables where table_name = upper(ObjName); + if (v_counter > 0) then + execute immediate 'drop table ' || ObjName || ' cascade constraints'; + end if; +end if; + if (ObjType = 'PROCEDURE') then + select count(*) into v_counter from User_Objects where object_type = 'PROCEDURE' and OBJECT_NAME = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP PROCEDURE ' || ObjName; + end if; + end if; + if (ObjType = 'FUNCTION') then + select count(*) into v_counter from User_Objects where object_type = 'FUNCTION' and OBJECT_NAME = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP FUNCTION ' || ObjName; + end if; + end if; + if (ObjType = 'TRIGGER') then + select count(*) into v_counter from User_Triggers where TRIGGER_NAME = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP TRIGGER ' || ObjName; + end if; + end if; + if (ObjType = 'VIEW') then + select count(*) into v_counter from User_Views where VIEW_NAME = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP VIEW ' || ObjName; + end if; + end if; + if (ObjType = 'SEQUENCE') then + select count(*) into v_counter from user_sequences where sequence_name = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP SEQUENCE ' || ObjName; + end if; + end if; + if (ObjType = 'INDEX') then + select count(*) into v_counter from user_indexes where index_name = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP INDEX ' || ObjName; + end if; + end if; + if (ObjType = 'CONSTRAINT') then + select count(*) into v_counter from user_constraints where constraint_name = upper(ObjName); + if (v_counter > 0) then + execute immediate 'DROP CONSTRAINT ' || ObjName; + end if; + end if; +END; +/ +-- sequence +call sp_dropobject('SEQ_GEN_IDENTITY','SEQUENCE'); +call sp_dropobject('X_ACCESS_AUDIT_SEQ','SEQUENCE'); +call sp_dropobject('X_ASSET_SEQ','SEQUENCE'); +call sp_dropobject('X_AUDIT_MAP_SEQ','SEQUENCE'); +call sp_dropobject('X_AUTH_SESS_SEQ','SEQUENCE'); +call sp_dropobject('X_CRED_STORE_SEQ','SEQUENCE'); +call sp_dropobject('X_DB_BASE_SEQ','SEQUENCE'); +call sp_dropobject('X_GROUP_SEQ','SEQUENCE'); +call sp_dropobject('X_GROUP_GROUPS_SEQ','SEQUENCE'); +call sp_dropobject('X_GROUP_USERS_SEQ','SEQUENCE'); +call sp_dropobject('X_PERM_MAP_SEQ','SEQUENCE'); +call sp_dropobject('X_POLICY_EXPORT_SEQ','SEQUENCE'); +call sp_dropobject('X_PORTAL_USER_SEQ','SEQUENCE'); +call sp_dropobject('X_PORTAL_USER_ROLE_SEQ','SEQUENCE'); +call sp_dropobject('X_RESOURCE_SEQ','SEQUENCE'); +call sp_dropobject('X_TRX_LOG_SEQ','SEQUENCE'); +call sp_dropobject('X_USER_SEQ','SEQUENCE'); +call sp_dropobject('X_DB_VERSION_H_SEQ','SEQUENCE'); +call sp_dropobject('V_TRX_LOG_SEQ','SEQUENCE'); +call sp_dropobject('XA_ACCESS_AUDIT_SEQ','SEQUENCE'); +commit; + +-- drop table +call sp_dropobject('vx_trx_log','VIEW'); +call sp_dropobject('x_perm_map','TABLE'); +call sp_dropobject('x_audit_map','TABLE'); +call sp_dropobject('x_trx_log','TABLE'); +call sp_dropobject('x_resource','TABLE'); +call sp_dropobject('x_policy_export_audit','TABLE'); +call sp_dropobject('x_group_users','TABLE'); +call sp_dropobject('x_user','TABLE'); +call sp_dropobject('x_group_groups','TABLE'); +call sp_dropobject('X_GROUP','TABLE'); +call sp_dropobject('x_db_base','TABLE'); +call sp_dropobject('x_cred_store','TABLE'); +call sp_dropobject('x_auth_sess','TABLE'); +call sp_dropobject('x_asset','TABLE'); +call sp_dropobject('xa_access_audit','TABLE'); +call sp_dropobject('x_portal_user_role','TABLE'); +call sp_dropobject('x_portal_user','TABLE'); + +commit; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/oracle/xa_audit_db_oracle.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/oracle/xa_audit_db_oracle.sql b/security-admin/db/oracle/xa_audit_db_oracle.sql index 4e1a184..3092055 100644 --- a/security-admin/db/oracle/xa_audit_db_oracle.sql +++ b/security-admin/db/oracle/xa_audit_db_oracle.sql @@ -13,61 +13,7 @@ -- See the License for the specific language governing permissions and -- limitations under the License. -CREATE OR REPLACE PROCEDURE sp_dropobject(ObjName IN varchar2,ObjType IN varchar2) -IS -v_counter integer; -BEGIN -if (ObjType = 'TABLE') then - select count(*) into v_counter from user_tables where table_name = upper(ObjName); - if (v_counter > 0) then - execute immediate 'drop table ' || ObjName || ' cascade constraints'; - end if; -end if; - if (ObjType = 'PROCEDURE') then - select count(*) into v_counter from User_Objects where object_type = 'PROCEDURE' and OBJECT_NAME = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP PROCEDURE ' || ObjName; - end if; - end if; - if (ObjType = 'FUNCTION') then - select count(*) into v_counter from User_Objects where object_type = 'FUNCTION' and OBJECT_NAME = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP FUNCTION ' || ObjName; - end if; - end if; - if (ObjType = 'TRIGGER') then - select count(*) into v_counter from User_Triggers where TRIGGER_NAME = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP TRIGGER ' || ObjName; - end if; - end if; - if (ObjType = 'VIEW') then - select count(*) into v_counter from User_Views where VIEW_NAME = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP VIEW ' || ObjName; - end if; - end if; - if (ObjType = 'SEQUENCE') then - select count(*) into v_counter from user_sequences where sequence_name = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP SEQUENCE ' || ObjName; - end if; - end if; - if (ObjType = 'INDEX') then - select count(*) into v_counter from user_indexes where index_name = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP INDEX ' || ObjName; - end if; - end if; -END; -/ -call sp_dropobject('XA_ACCESS_AUDIT','TABLE'); -call sp_dropobject('XA_ACCESS_AUDIT_SEQ','SEQUENCE'); -call sp_dropobject('xa_access_audit_added_by_id','INDEX'); -call sp_dropobject('xa_access_audit_upd_by_id','INDEX'); -call sp_dropobject('xa_access_audit_cr_time','INDEX'); -call sp_dropobject('xa_access_audit_up_time','INDEX'); -call sp_dropobject('xa_access_audit_event_time','INDEX'); + CREATE SEQUENCE XA_ACCESS_AUDIT_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; CREATE TABLE xa_access_audit ( id NUMBER(20) NOT NULL, http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/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 449c461..9cc22ff 100644 --- a/security-admin/db/oracle/xa_core_db_oracle.sql +++ b/security-admin/db/oracle/xa_core_db_oracle.sql @@ -13,106 +13,7 @@ -- See the License for the specific language governing permissions and -- limitations under the License. -/* create or replace procedure */ -commit; -CREATE OR REPLACE PROCEDURE sp_dropobject(ObjName IN varchar2,ObjType IN varchar2) -IS -v_counter integer; -BEGIN -if (ObjType = 'TABLE') then - select count(*) into v_counter from user_tables where table_name = upper(ObjName); - if (v_counter > 0) then - execute immediate 'drop table ' || ObjName || ' cascade constraints'; - end if; -end if; - if (ObjType = 'PROCEDURE') then - select count(*) into v_counter from User_Objects where object_type = 'PROCEDURE' and OBJECT_NAME = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP PROCEDURE ' || ObjName; - end if; - end if; - if (ObjType = 'FUNCTION') then - select count(*) into v_counter from User_Objects where object_type = 'FUNCTION' and OBJECT_NAME = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP FUNCTION ' || ObjName; - end if; - end if; - if (ObjType = 'TRIGGER') then - select count(*) into v_counter from User_Triggers where TRIGGER_NAME = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP TRIGGER ' || ObjName; - end if; - end if; - if (ObjType = 'VIEW') then - select count(*) into v_counter from User_Views where VIEW_NAME = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP VIEW ' || ObjName; - end if; - end if; - if (ObjType = 'SEQUENCE') then - select count(*) into v_counter from user_sequences where sequence_name = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP SEQUENCE ' || ObjName; - end if; - end if; - if (ObjType = 'INDEX') then - select count(*) into v_counter from user_indexes where index_name = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP INDEX ' || ObjName; - end if; - end if; - if (ObjType = 'CONSTRAINT') then - select count(*) into v_counter from user_constraints where constraint_name = upper(ObjName); - if (v_counter > 0) then - execute immediate 'DROP CONSTRAINT ' || ObjName; - end if; - end if; -END; -/ -/* sequence */ -call sp_dropobject('SEQ_GEN_IDENTITY','SEQUENCE'); -call sp_dropobject('X_ACCESS_AUDIT_SEQ','SEQUENCE'); -call sp_dropobject('X_ASSET_SEQ','SEQUENCE'); -call sp_dropobject('X_AUDIT_MAP_SEQ','SEQUENCE'); -call sp_dropobject('X_AUTH_SESS_SEQ','SEQUENCE'); -call sp_dropobject('X_CRED_STORE_SEQ','SEQUENCE'); -call sp_dropobject('X_DB_BASE_SEQ','SEQUENCE'); -call sp_dropobject('X_GROUP_SEQ','SEQUENCE'); -call sp_dropobject('X_GROUP_GROUPS_SEQ','SEQUENCE'); -call sp_dropobject('X_GROUP_USERS_SEQ','SEQUENCE'); -call sp_dropobject('X_PERM_MAP_SEQ','SEQUENCE'); -call sp_dropobject('X_POLICY_EXPORT_SEQ','SEQUENCE'); -call sp_dropobject('X_PORTAL_USER_SEQ','SEQUENCE'); -call sp_dropobject('X_PORTAL_USER_ROLE_SEQ','SEQUENCE'); -call sp_dropobject('X_RESOURCE_SEQ','SEQUENCE'); -call sp_dropobject('X_TRX_LOG_SEQ','SEQUENCE'); -call sp_dropobject('X_USER_SEQ','SEQUENCE'); -call sp_dropobject('X_DB_VERSION_H_SEQ','SEQUENCE'); -call sp_dropobject('V_TRX_LOG_SEQ','SEQUENCE'); -call sp_dropobject('XA_ACCESS_AUDIT_SEQ','SEQUENCE'); -commit; - -/* drop table */ -call sp_dropobject('vx_trx_log','VIEW'); -call sp_dropobject('x_perm_map','TABLE'); -call sp_dropobject('x_audit_map','TABLE'); -call sp_dropobject('x_trx_log','TABLE'); -call sp_dropobject('x_resource','TABLE'); -call sp_dropobject('x_policy_export_audit','TABLE'); -call sp_dropobject('x_group_users','TABLE'); -call sp_dropobject('x_user','TABLE'); -call sp_dropobject('x_group_groups','TABLE'); -call sp_dropobject('X_GROUP','TABLE'); -call sp_dropobject('x_db_base','TABLE'); -call sp_dropobject('x_cred_store','TABLE'); -call sp_dropobject('x_auth_sess','TABLE'); -call sp_dropobject('x_asset','TABLE'); -call sp_dropobject('xa_access_audit','TABLE'); -call sp_dropobject('x_portal_user_role','TABLE'); -call sp_dropobject('x_portal_user','TABLE'); - -commit; -/* create sequences */ +-- create sequences CREATE SEQUENCE SEQ_GEN_IDENTITY START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; CREATE SEQUENCE X_ACCESS_AUDIT_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; CREATE SEQUENCE X_ASSET_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; @@ -136,7 +37,7 @@ CREATE SEQUENCE XA_ACCESS_AUDIT_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE; commit; -/* create tables */ +-- create tables CREATE TABLE x_portal_user ( id NUMBER(20) NOT NULL, create_time DATE DEFAULT NULL NULL , @@ -531,7 +432,7 @@ CREATE INDEX x_user_up_time ON x_user(update_time); CREATE OR REPLACE PUBLIC SYNONYM xa_access_audit FOR xa_access_audit; CREATE OR REPLACE PUBLIC SYNONYM XA_ACCESS_AUDIT_SEQ FOR XA_ACCESS_AUDIT_SEQ; - +commit; insert into x_portal_user ( id,CREATE_TIME, UPDATE_TIME, FIRST_NAME, LAST_NAME, PUB_SCR_NAME, @@ -541,7 +442,7 @@ X_PORTAL_USER_SEQ.NEXTVAL, SYSDATE, SYSDATE, 'Admin', '', 'Admin', 'admin', 'ceb4f32325eda6142bd65215f4c0f371', '', 1 ); - +commit; insert into x_portal_user_role ( id, CREATE_TIME, UPDATE_TIME, USER_ID, USER_ROLE, STATUS @@ -549,32 +450,9 @@ insert into x_portal_user_role ( X_PORTAL_USER_ROLE_SEQ.NEXTVAL, SYSDATE, SYSDATE, 1, 'ROLE_SYS_ADMIN', 1 ); - +commit; insert into x_user (id,CREATE_TIME, UPDATE_TIME,user_name, status,descr) values ( X_USER_SEQ.NEXTVAL, SYSDATE, SYSDATE,'admin', 0,'Administrator'); - -INSERT INTO x_group (ID,ADDED_BY_ID, CREATE_TIME, DESCR, GROUP_TYPE, GROUP_NAME, STATUS, UPDATE_TIME, UPD_BY_ID) VALUES (X_GROUP_SEQ.nextval,1, sys_extract_utc(systimestamp), 'public group', 0, 'public', 0, sys_extract_utc(systimestamp), 1); -commit; - - - -CREATE OR REPLACE TRIGGER x_auth_sess_trigger - BEFORE INSERT - ON x_auth_sess - FOR EACH ROW - -- Optionally restrict this trigger to fire only when really needed - WHEN (new.id is null) -DECLARE - v_id x_auth_sess.id%TYPE; -BEGIN - -- Select a new value from the sequence into a local variable. As - -- commented, this step is optional. You can directly select into :new.qname_id - SELECT x_auth_sess_seq.nextval INTO v_id FROM DUAL; - - -- :new references the record that you are about to insert into qname. Hence, - -- you can overwrite the value of :new.qname_id (qname.qname_id) with the value - -- obtained from your sequence, before inserting - :new.id := v_id; -END my_trigger; -/ commit; +INSERT INTO x_group (ID,ADDED_BY_ID, CREATE_TIME, DESCR, GROUP_TYPE, GROUP_NAME, STATUS, UPDATE_TIME, UPD_BY_ID) VALUES (X_GROUP_SEQ.nextval,1, sys_extract_utc(systimestamp), 'public group', 0, 'public', 0, sys_extract_utc(systimestamp), 1); +commit; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/001-groupsource.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/patches/001-groupsource.sql b/security-admin/db/patches/001-groupsource.sql deleted file mode 100644 index c49d8cb..0000000 --- a/security-admin/db/patches/001-groupsource.sql +++ /dev/null @@ -1,34 +0,0 @@ --- Licensed to the Apache Software Foundation (ASF) under one or more --- contributor license agreements. See the NOTICE file distributed with --- this work for additional information regarding copyright ownership. --- The ASF licenses this file to You under the Apache License, Version 2.0 --- (the "License"); you may not use this file except in compliance with --- the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. - - drop procedure if exists add_group_source_column_to_x_group_table; - -delimiter ;; - create procedure add_group_source_column_to_x_group_table() begin - - /* add group source column if not exist */ - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_group') then - if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_group' and column_name = 'group_src') then - ALTER TABLE `x_group` ADD `group_src` INT NOT NULL DEFAULT 0; - end if; - end if; - -end;; - -delimiter ; - - call add_group_source_column_to_x_group_table(); - - drop procedure if exists add_group_source_column_to_x_group_table; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/002-policyname.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/patches/002-policyname.sql b/security-admin/db/patches/002-policyname.sql deleted file mode 100644 index 35927f5..0000000 --- a/security-admin/db/patches/002-policyname.sql +++ /dev/null @@ -1,37 +0,0 @@ --- Licensed to the Apache Software Foundation (ASF) under one or more --- contributor license agreements. See the NOTICE file distributed with --- this work for additional information regarding copyright ownership. --- The ASF licenses this file to You under the Apache License, Version 2.0 --- (the "License"); you may not use this file except in compliance with --- the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. - -drop procedure if exists add_policy_name_column_to_x_resource_table; - -delimiter ;; -create procedure add_policy_name_column_to_x_resource_table() begin - - /* add policy name column if not exist */ - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource') then - if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource' and column_name = 'policy_name') then - ALTER TABLE `x_resource` ADD `policy_name` VARCHAR( 500 ) NULL DEFAULT NULL; - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource' and column_name = 'policy_name') then - ALTER TABLE `x_resource` ADD UNIQUE `x_resource_UK_policy_name` ( `policy_name` ); - end if; - end if; - end if; - - -end;; - -delimiter ; -call add_policy_name_column_to_x_resource_table(); - -drop procedure if exists add_policy_name_column_to_x_resource_table; \ No newline at end of file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/003-knoxrepo.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/patches/003-knoxrepo.sql b/security-admin/db/patches/003-knoxrepo.sql deleted file mode 100644 index 04c050a..0000000 --- a/security-admin/db/patches/003-knoxrepo.sql +++ /dev/null @@ -1,48 +0,0 @@ --- Licensed to the Apache Software Foundation (ASF) under one or more --- contributor license agreements. See the NOTICE file distributed with --- this work for additional information regarding copyright ownership. --- The ASF licenses this file to You under the Apache License, Version 2.0 --- (the "License"); you may not use this file except in compliance with --- the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. - -drop procedure if exists add_columns_for_knox_repository; - -delimiter ;; -create procedure add_columns_for_knox_repository() begin - - /* add res_topologies if not exist */ - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource') then - if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource' and column_name = 'res_topologies') then - ALTER TABLE `x_resource` ADD `res_topologies` TEXT NULL DEFAULT NULL ; - end if; - end if; - - /* add res_services if not exist */ - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource') then - if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_resource' and column_name = 'res_services') then - ALTER TABLE `x_resource` ADD `res_services` TEXT NULL DEFAULT NULL; - end if; - end if; - - /* add ip_address if not exist */ - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_perm_map') then - if not exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_perm_map' and column_name = 'ip_address') then - ALTER TABLE `x_perm_map` ADD `ip_address` TEXT NULL DEFAULT NULL; - end if; - end if; - - -end;; - -delimiter ; -call add_columns_for_knox_repository(); - -drop procedure if exists add_columns_for_knox_repository; http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/004-assetconfigsize.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/patches/004-assetconfigsize.sql b/security-admin/db/patches/004-assetconfigsize.sql deleted file mode 100644 index bec992b..0000000 --- a/security-admin/db/patches/004-assetconfigsize.sql +++ /dev/null @@ -1,31 +0,0 @@ --- Licensed to the Apache Software Foundation (ASF) under one or more --- contributor license agreements. See the NOTICE file distributed with --- this work for additional information regarding copyright ownership. --- The ASF licenses this file to You under the Apache License, Version 2.0 --- (the "License"); you may not use this file except in compliance with --- the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. - -drop procedure if exists change_config_column_datatype_of_x_asset_table; - -delimiter ;; -create procedure change_config_column_datatype_of_x_asset_table() begin - - /* change config data type to longtext if not exist */ - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_asset' and column_name = 'config' and data_type='text') then - ALTER TABLE `x_asset` CHANGE `config` `config` MEDIUMTEXT NULL DEFAULT NULL ; - end if; - -end;; - -delimiter ; -call change_config_column_datatype_of_x_asset_table(); - -drop procedure if exists change_config_column_datatype_of_x_asset_table; http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/005-xtrxlogcolumnsize.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/patches/005-xtrxlogcolumnsize.sql b/security-admin/db/patches/005-xtrxlogcolumnsize.sql deleted file mode 100644 index 4ec9a6d..0000000 --- a/security-admin/db/patches/005-xtrxlogcolumnsize.sql +++ /dev/null @@ -1,34 +0,0 @@ --- Licensed to the Apache Software Foundation (ASF) under one or more --- contributor license agreements. See the NOTICE file distributed with --- this work for additional information regarding copyright ownership. --- The ASF licenses this file to You under the Apache License, Version 2.0 --- (the "License"); you may not use this file except in compliance with --- the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. - -drop procedure if exists change_values_columns_datatype_of_x_trx_log_table; - -delimiter ;; -create procedure change_values_columns_datatype_of_x_trx_log_table() begin - - /* change prev_value column data type to mediumtext */ - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_trx_log' and column_name = 'prev_val' and data_type='varchar') then - ALTER TABLE `x_trx_log` CHANGE `prev_val` `prev_val` MEDIUMTEXT NULL DEFAULT NULL ; - end if; - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_trx_log' and column_name = 'new_val' and data_type='varchar') then - ALTER TABLE `x_trx_log` CHANGE `new_val` `new_val` MEDIUMTEXT NULL DEFAULT NULL ; - end if; - -end;; - -delimiter ; -call change_values_columns_datatype_of_x_trx_log_table(); - -drop procedure if exists change_values_columns_datatype_of_x_trx_log_table; http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/006-createdefaultpublicgroup.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/patches/006-createdefaultpublicgroup.sql b/security-admin/db/patches/006-createdefaultpublicgroup.sql deleted file mode 100644 index ddb211e..0000000 --- a/security-admin/db/patches/006-createdefaultpublicgroup.sql +++ /dev/null @@ -1,34 +0,0 @@ --- Licensed to the Apache Software Foundation (ASF) under one or more --- contributor license agreements. See the NOTICE file distributed with --- this work for additional information regarding copyright ownership. --- The ASF licenses this file to You under the Apache License, Version 2.0 --- (the "License"); you may not use this file except in compliance with --- the License. You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. - -drop procedure if exists insert_public_group_in_x_group_table; - -delimiter ;; -create procedure insert_public_group_in_x_group_table() begin - - /* check table x_group exist or not */ - if exists (select * from information_schema.columns where table_schema=database() and table_name = 'x_group') then - /* check record for group name public exist or not */ - if not exists (select * from x_group where group_name = 'public') then - INSERT INTO x_group (ADDED_BY_ID, CREATE_TIME, DESCR, GROUP_SRC, GROUP_TYPE, GROUP_NAME, STATUS, UPDATE_TIME, UPD_BY_ID) VALUES (1, UTC_TIMESTAMP(), 'public group', 0, 0, 'public', 0, UTC_TIMESTAMP(), 1); - end if; - end if; - -end;; - -delimiter ; -call insert_public_group_in_x_group_table(); - -drop procedure if exists insert_public_group_in_x_group_table;
