http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/007-updateBlankPolicyName.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/patches/007-updateBlankPolicyName.sql b/security-admin/db/patches/007-updateBlankPolicyName.sql deleted file mode 100644 index d251bc2..0000000 --- a/security-admin/db/patches/007-updateBlankPolicyName.sql +++ /dev/null @@ -1,186 +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. - --- -------------------------------------------------------------------------------- --- Function which will return tempPolicyCount --- which is being used by SP updateBlankPolicyName() --- -------------------------------------------------------------------------------- -DELIMITER $$ - -DROP FUNCTION if exists getTempPolicyCount $$ -CREATE FUNCTION `getTempPolicyCount`(assetId bigint, resId bigint) RETURNS int(11) -BEGIN - -DECLARE tempPolicyCount int default 1; -DECLARE dbResourceId bigint; -DECLARE exitLoop int DEFAULT FALSE; - -DECLARE policyList CURSOR FOR - SELECT id from x_resource where asset_id = assetId; - -DECLARE CONTINUE HANDLER FOR NOT FOUND SET exitLoop = true; -OPEN policyList; -readPolicy : LOOP - FETCH policyList into dbResourceId; - - IF exitLoop THEN - set tempPolicyCount = tempPolicyCount + 1; - LEAVE readPolicy; - END IF; - - IF (resId = dbResourceId) THEN - LEAVE readPolicy; - END IF; - set tempPolicyCount = tempPolicyCount + 1; - -END LOOP; -CLOSE policyList; - -RETURN tempPolicyCount; -END $$ - - --- -------------------------------------------------------------------------------- --- Procedure that will generate policy name of policies --- which were previously created without policy_name --- -------------------------------------------------------------------------------- -DELIMITER $$ - -DROP PROCEDURE if exists updateBlankPolicyName $$ -CREATE PROCEDURE `updateBlankPolicyName`() -BEGIN - -DECLARE done INT; -DECLARE resId bigint; -DECLARE assetId bigint; -DECLARE assetName varchar(512); -DECLARE genPolicyName varchar(1000); -DECLARE existPolId varchar(1000); -DECLARE policyCount bigint; -DECLARE currentTime varchar(100); -DECLARE tempPolicyCount int; -DECLARE totalPolicyCount int; -DECLARE resourceName varchar(4000); - --- TrxLog fields -DECLARE createTime datetime; -DECLARE addedById bigint; -DECLARE classType int; -DECLARE objId bigint; -DECLARE parentObjId bigint; -DECLARE parentObjClsType int; -DECLARE parentObjName varchar(1024); -DECLARE objName varchar(1024); -DECLARE attrName varchar(255); -DECLARE prevVal varchar(1024); -DECLARE newVal varchar(1024); -DECLARE trxId varchar(1024); -DECLARE act varchar(255); -DECLARE sessType varchar(30); -DECLARE assetTypeInt int; -DECLARE assetType varchar(50); -DECLARE transId varchar(50); - -DECLARE policyList CURSOR FOR - select id,asset_id, res_name from x_resource res - where res.policy_name is null or res.policy_name = ''; - -DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1; -OPEN policyList; - - SET done = 0; - - iLoop : LOOP - - FETCH policyList into resId, assetId, resourceName; - - set assetTypeInt = (select asset_type from x_asset where id = assetId); - - if (assetTypeInt = 1) then - set assetType = 'HDFS'; - elseif (assetTypeInt = 2) then - set assetType = 'HBase'; - elseif ((assetTypeInt = 3)) then - set assetType = 'Hive'; - elseif (assetTypeInt = 4) then - set assetType = 'XAAGENT'; - elseif (assetTypeInt = 5) then - set assetType = 'Knox'; - elseif (assetTypeInt = 6) then - set assetType = 'Storm'; - end if; - - set totalPolicyCount = (select count(*) from x_resource where asset_id = assetId); - set assetName = (select asset_name from x_asset asset where asset.id = assetId); - - set tempPolicyCount = getTempPolicyCount(assetId, resId); - set currentTime = DATE_FORMAT(utc_timestamp(), "%Y%m%d%H%i%s"); - - set genPolicyName = concat(assetName, '-', tempPolicyCount, '-', currentTime); - set existPolId = (select id from x_resource where policy_name = genPolicyName); - - if (existPolId != '') then - set genPolicyName = concat(assetName, '-', totalPolicyCount, '-', currentTime); - end if; - - if(done = 1) then - LEAVE iLoop; - end if; - - UPDATE x_resource set policy_name = genPolicyName where id = resId; - - -- Creating Trx Log - set createTime = utc_timestamp(); - set addedById = 1; - set classType = 1001; - set objId = resId; - set parentObjId = assetId; - set parentObjClsType = 1000; - set objName = resourceName; - set attrName = 'Policy Name'; - set prevVal = null; - set newVal = genPolicyName; - set act = 'update'; - set sessType = 'DB Script'; - set parentObjName = assetName; - - set transId = concat(DATE_FORMAT(utc_timestamp(), "%Y%m%d%H%i%s"), '_', rand()); - - insert into x_trx_log (create_time, update_time, added_by_id, upd_by_id, - class_type, object_id, parent_object_id, parent_object_class_type, - parent_object_name, object_name, attr_name, prev_val, new_val, `action`, - trx_id, sess_type) - values(createTime, createTime, addedById, addedById, classType, objId, - parentObjId, parentObjClsType, parentObjName, objName, attrName, prevVal, - newVal, act, transId, sessType); - - insert into x_trx_log (create_time, update_time, added_by_id, upd_by_id, - class_type, object_id, parent_object_id, parent_object_class_type, - parent_object_name, object_name, attr_name, prev_val, new_val, `action`, - trx_id, sess_type) - values(createTime, createTime, addedById, addedById, classType, objId, - parentObjId, parentObjClsType, parentObjName, objName, 'Repository Type', prevVal, - assetType, act, transId, sessType); - - END LOOP; - -CLOSE policyList; - -END $$ -DELIMITER ; -call updateBlankPolicyName(); - -DROP FUNCTION if exists getTempPolicyCount; -DROP PROCEDURE if exists updateBlankPolicyName;
http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/008-removeTrailingSlash.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/patches/008-removeTrailingSlash.sql b/security-admin/db/patches/008-removeTrailingSlash.sql deleted file mode 100644 index 2e00f5f..0000000 --- a/security-admin/db/patches/008-removeTrailingSlash.sql +++ /dev/null @@ -1,144 +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. - --- -------------------------------------------------------------------------------- --- Routine DDL --- Note: comments before and after the routine body will not be stored by the server --- -------------------------------------------------------------------------------- -DELIMITER $$ - -DROP FUNCTION if exists removeTrailingSlash $$ -CREATE FUNCTION `removeTrailingSlash`(resName varchar(4000), resId bigint, assetId bigint, policyName varchar(1000)) RETURNS varchar(4000) CHARSET latin1 -BEGIN - -DECLARE noOfCommas int; -DECLARE updatedResName varchar(4000) default ''; -DECLARE resource varchar(1000); -DECLARE count int default 0; -DECLARE proceedLoop boolean default true; - --- TrxLog fields -DECLARE createTime datetime; -DECLARE addedById bigint; -DECLARE classType int; -DECLARE objId bigint; -DECLARE parentObjId bigint; -DECLARE parentObjClsType int; -DECLARE parentObjName varchar(1024); -DECLARE objName varchar(1024); -DECLARE attrName varchar(255); -DECLARE prevVal varchar(1024); -DECLARE newVal varchar(1024); -DECLARE trxId varchar(1024); -DECLARE act varchar(255); -DECLARE sessType varchar(30); -DECLARE transId varchar(50); -DECLARE assetTypeInt int; -DECLARE assetType varchar(30); - -set noOfCommas = (LENGTH(resName)-LENGTH(REPLACE (resName, ",", ""))); -set assetTypeInt = (select asset_type from x_asset where id = assetId); - - if (assetTypeInt = 1) then - set assetType = 'HDFS'; - elseif (assetTypeInt = 2) then - set assetType = 'HBase'; - elseif ((assetTypeInt = 3)) then - set assetType = 'Hive'; - elseif (assetTypeInt = 4) then - set assetType = 'XAAGENT'; - elseif (assetTypeInt = 5) then - set assetType = 'Knox'; - elseif (assetTypeInt = 6) then - set assetType = 'Storm'; - end if; - -WHILE proceedLoop DO - set count = count +1; - - if (count > noOfCommas) then - set resource = SUBSTRING_INDEX(resName, ',', -1); - set proceedLoop = false; - else - set resource = REPLACE(SUBSTRING(SUBSTRING_INDEX(resName, ',', count), - LENGTH(SUBSTRING_INDEX(resName, ',', count -1)) + 1), ',', ''); - end if; - - if (LENGTH(resource) > 1 && SUBSTRING(resource, -(LENGTH(resource)-(LENGTH(resource)-1))) = '/') then - set resource = SUBSTRING(resource, 1, (LENGTH(resource)-1)); - else - set resource = resource; - end if; - - if(updatedResName != '') then - set updatedResName = CONCAT(updatedResName, ',', resource); - else - set updatedResName = resource; - end if; - -END WHILE; - -if (updatedResName != resName) then --- Generating Trx Log if value has been updated. - -set createTime = utc_timestamp(); -set addedById = 1; -set classType = 1001; -set objId = resId; -set parentObjId = assetId; -set parentObjClsType = 1000; -set objName = updatedResName; -set attrName = 'Resource Path'; -set prevVal = resName; -set newVal = updatedResName; -set act = 'update'; -set sessType = 'DB Script'; - -set parentObjName = (select asset_name from x_asset where id = assetId); -set transId = concat(DATE_FORMAT(utc_timestamp(), "%Y%m%d%H%i%s"), '_', rand()); - -insert into x_trx_log (create_time, update_time, added_by_id, upd_by_id, - class_type, object_id, parent_object_id, parent_object_class_type, - parent_object_name, object_name, attr_name, prev_val, new_val, `action`, - trx_id, sess_type) - values(createTime, createTime, addedById, addedById, classType, objId, - parentObjId, parentObjClsType, parentObjName, objName, attrName, prevVal, - newVal, act, transId, sessType); - -insert into x_trx_log (create_time, update_time, added_by_id, upd_by_id, - class_type, object_id, parent_object_id, parent_object_class_type, - parent_object_name, object_name, attr_name, prev_val, new_val, `action`, - trx_id, sess_type) - values(createTime, createTime, addedById, addedById, classType, objId, - parentObjId, parentObjClsType, parentObjName, objName, 'Policy Name', policyName, - policyName, act, transId, sessType); - -insert into x_trx_log (create_time, update_time, added_by_id, upd_by_id, - class_type, object_id, parent_object_id, parent_object_class_type, - parent_object_name, object_name, attr_name, new_val, `action`, - trx_id, sess_type) - values(createTime, createTime, addedById, addedById, classType, objId, - parentObjId, parentObjClsType, parentObjName, objName, 'Repository Type', - assetType, act, transId, sessType); - -end if; - -RETURN updatedResName; -END $$ -DELIMITER ; -UPDATE x_resource res, x_asset asset set res_name = removeTrailingSlash(res.res_name, res.id, res.asset_id, res.policy_name) - WHERE asset.asset_type = 1 and asset.id = res.asset_id; - -DROP FUNCTION if exists removeTrailingSlash; http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/patches/009-updated_schema.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/patches/009-updated_schema.sql b/security-admin/db/patches/009-updated_schema.sql deleted file mode 100644 index 401a1dc..0000000 --- a/security-admin/db/patches/009-updated_schema.sql +++ /dev/null @@ -1,419 +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. - --- Temporary table structure for view `vx_trx_log` --- - -DROP TABLE IF EXISTS `x_service_def`; -CREATE TABLE `x_service_def` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`version` bigint(20) DEFAULT NULL, -`name` varchar(1024) DEFAULT NULL, -`impl_class_name` varchar(1024) DEFAULT NULL, -`label` varchar(1024) DEFAULT NULL, -`description` varchar(1024) DEFAULT NULL, -`rb_key_label` varchar(1024) DEFAULT NULL, -`rb_key_description` varchar(1024) DEFAULT NULL, -`is_enabled` tinyint DEFAULT 1, -primary key (`id`), -KEY `x_service_def_added_by_id` (`added_by_id`), -KEY `x_service_def_upd_by_id` (`upd_by_id`), -KEY `x_service_def_cr_time` (`create_time`), -KEY `x_service_def_up_time` (`update_time`), -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`) -); - - -DROP TABLE IF EXISTS `x_service`; -CREATE TABLE `x_service` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`version` bigint(20) DEFAULT NULL, -`type` bigint(20) DEFAULT NULL, -`name` varchar(512) DEFAULT NULL, -`policy_version` bigint(20) DEFAULT NULL, -`policy_update_time`datetime DEFAULT NULL, -`description` varchar(1024) DEFAULT NULL, -`is_enabled` tinyint(1) NOT NULL DEFAULT '0', -primary key (`id`), -UNIQUE KEY `X_service_name` (`name`), -KEY `x_service_added_by_id` (`added_by_id`), -KEY `x_service_upd_by_id` (`upd_by_id`), -KEY `x_service_cr_time` (`create_time`), -KEY `x_service_up_time` (`update_time`), -KEY `x_service_type` (`type`), -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`) -); - -DROP TABLE IF EXISTS `x_policy`; -CREATE TABLE `x_policy` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`version` bigint(20) DEFAULT NULL, -`service` bigint(20) DEFAULT NULL, -`name` varchar(512) DEFAULT NULL, -`description` varchar(1024) DEFAULT NULL, -`is_enabled` tinyint(1) NOT NULL DEFAULT '0', -`is_audit_enabled` tinyint(1) NOT NULL DEFAULT '0', -primary key (`id`), -UNIQUE KEY `x_policy_name` (`name`), -KEY `x_policy_added_by_id` (`added_by_id`), -KEY `x_policy_upd_by_id` (`upd_by_id`), -KEY `x_policy_cr_time` (`create_time`), -KEY `x_policy_up_time` (`update_time`), -KEY `x_policy_service` (`service`), -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`) -); - - -DROP TABLE IF EXISTS `x_service_config_def`; -CREATE TABLE `x_service_config_def` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`def_id` bigint(20) NOT NULL, -`name` varchar(1024) DEFAULT NULL, -`type` varchar(1024) DEFAULT NULL, -`sub_type` varchar(1024) DEFAULT NULL, -`is_mandatory` tinyint(1) NOT NULL DEFAULT '0', -`default_value` varchar(1024) DEFAULT NULL, -`label` varchar(1024) DEFAULT NULL, -`description` varchar(1024) DEFAULT NULL, -`rb_key_label` varchar(1024) DEFAULT NULL, -`rb_key_decription` varchar(1024) DEFAULT NULL, -`sort_order` tinyint(3) DEFAULT '0', -primary key (`id`), -CONSTRAINT `x_service_config_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES `x_service_def` (`id`), -CONSTRAINT `x_service_config_def_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_service_config_def_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - - -DROP TABLE IF EXISTS `x_resource_def`; -CREATE TABLE `x_resource_def` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`def_id` bigint(20) NOT NULL, -`name` varchar(1024) DEFAULT NULL, -`type` varchar(1024) DEFAULT NULL, -`level` bigint(20) DEFAULT NULL, -`parent` bigint(20) DEFAULT NULL, -`mandatory` tinyint(1) NOT NULL DEFAULT '0', -`look_up_supported` tinyint(1) NOT NULL DEFAULT '0', -`recursive_supported` tinyint(1) NOT NULL DEFAULT '0', -`excludes_supported` tinyint(1) NOT NULL DEFAULT '0', -`matcher` varchar(1024) DEFAULT NULL, -`matcher_options` varchar(1024) DEFAULT NULL, -`label` varchar(1024) DEFAULT NULL, -`description` varchar(1024) DEFAULT NULL, -`rb_key_label` varchar(1024) DEFAULT NULL, -`rb_key_description` varchar(1024) DEFAULT NULL, -`sort_order` tinyint(3) DEFAULT '0', -primary key (`id`), -KEY `x_resource_def_FK_parent` (`parent`), -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`) -); - -DROP TABLE IF EXISTS `x_access_type_def`; -CREATE TABLE `x_access_type_def` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`def_id` bigint(20) NOT NULL, -`name` varchar(1024) DEFAULT NULL, -`label` varchar(1024) DEFAULT NULL, -`rb_key_label` varchar(1024) DEFAULT NULL, -`sort_order` tinyint(3) DEFAULT '0', -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_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_access_type_def_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - -DROP TABLE IF EXISTS `x_access_type_def_grants`; -CREATE TABLE `x_access_type_def_grants` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`atd_id` bigint(20) NOT NULL, -`implied_grant` varchar(1024) DEFAULT 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`) -); - -DROP TABLE IF EXISTS `x_policy_condition_def`; -CREATE TABLE `x_policy_condition_def` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`def_id` bigint(20) NOT NULL, -`name` varchar(1024) DEFAULT NULL, -`evaluator` varchar(1024) DEFAULT NULL, -`evaluator_options` varchar(1024) DEFAULT NULL, -`label` varchar(1024) DEFAULT NULL, -`description` varchar(1024) DEFAULT NULL, -`rb_key_label` varchar(1024) DEFAULT NULL, -`rb_key_description` varchar(1024) DEFAULT NULL, -`sort_order` tinyint(3) DEFAULT '0', -primary key (`id`) , -CONSTRAINT `x_policy_condition_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES `x_service_def` (`id`), -CONSTRAINT `x_policy_condition_def_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_policy_condition_def_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - -DROP TABLE IF EXISTS `x_enum_def`; -CREATE TABLE `x_enum_def` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`def_id` bigint(20) NOT NULL, -`name` varchar(1024) DEFAULT NULL, -`default_index` bigint(20) DEFAULT NULL, -primary key (`id`), -CONSTRAINT `x_enum_def_FK_defid` 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`) -); - - -DROP TABLE IF EXISTS `x_enum_element_def`; -CREATE TABLE `x_enum_element_def` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`enum_def_id` bigint(20) NOT NULL, -`name` varchar(1024) DEFAULT NULL, -`label` varchar(1024) DEFAULT NULL, -`rb_key_label` varchar(1024) DEFAULT NULL, -`sort_order` tinyint(3) DEFAULT '0', -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_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_enum_element_def_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - - -DROP TABLE IF EXISTS `x_service_config_map`; -CREATE TABLE `x_service_config_map` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`service` bigint(20) NOT NULL, -`config_key` varchar(1024) DEFAULT NULL, -`config_value` varchar(1024) DEFAULT NULL, -primary key (`id`), -CONSTRAINT `x_service_config_map_FK_` FOREIGN KEY (`service`) REFERENCES `x_service` (`id`), -CONSTRAINT `x_service_config_map_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_service_config_map_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - - -DROP TABLE IF EXISTS `x_policy_resource`; -CREATE TABLE `x_policy_resource` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`policy_id` bigint(20) NOT NULL, -`res_def_id` bigint(20) NOT NULL, -`is_excludes` tinyint(1) NOT NULL DEFAULT '0', -`is_recursive` tinyint(1) NOT NULL DEFAULT '0', -primary key (`id`), -CONSTRAINT `x_policy_resource_FK_policy_id` FOREIGN KEY (`policy_id`) REFERENCES `x_policy` (`id`), -CONSTRAINT `x_policy_resource_FK_res_def_id` FOREIGN KEY (`res_def_id`) REFERENCES `x_resource_def` (`id`), -CONSTRAINT `x_policy_resource_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_policy_resource_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - - -DROP TABLE IF EXISTS `x_policy_resource_map`; -CREATE TABLE `x_policy_resource_map` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`resource_id` bigint(20) NOT NULL, -`value` varchar(1024) DEFAULT NULL, -`sort_order` tinyint(3) DEFAULT '0', -primary key (`id`), -CONSTRAINT `x_policy_resource_map_FK_resource_id` FOREIGN KEY (`resource_id`) REFERENCES `x_policy_resource` (`id`), -CONSTRAINT `x_policy_resource_map_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_policy_resource_map_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - - - -DROP TABLE IF EXISTS `x_policy_item`; -CREATE TABLE `x_policy_item` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`policy_id` bigint(20) NOT NULL, -`delegate_admin` tinyint(1) NOT NULL DEFAULT '0', -`sort_order` tinyint(3) DEFAULT '0', -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`) -); - - -DROP TABLE IF EXISTS `x_policy_item_access`; -CREATE TABLE `x_policy_item_access` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`policy_item_id` bigint(20) NOT NULL, -`type` bigint(20) NOT NULL, -`is_allowed` tinyint(11) NOT NULL DEFAULT '0', -`sort_order` tinyint(3) DEFAULT '0', -primary key (id), -CONSTRAINT `x_policy_item_access_FK_pi_id` FOREIGN KEY (`policy_item_id`) REFERENCES `x_policy_item` (`id`) , -CONSTRAINT `x_policy_item_access_FK_atd_id` FOREIGN KEY (`type`) REFERENCES `x_access_type_def` (`id`), -CONSTRAINT `x_policy_item_access_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_policy_item_access_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - -DROP TABLE IF EXISTS `x_policy_item_condition`; -CREATE TABLE `x_policy_item_condition` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`policy_item_id` bigint(20) NOT NULL, -`type` bigint(20) NOT NULL, -`value` varchar(1024) DEFAULT NULL, -`sort_order` tinyint(3) DEFAULT '0', -primary key (id), -CONSTRAINT `x_policy_item_condition_FK_pi_id` FOREIGN KEY (`policy_item_id`) REFERENCES `x_policy_item` (`id`) , -CONSTRAINT `x_policy_item_condition_FK_pcd_id` FOREIGN KEY (`type`) REFERENCES `x_policy_condition_def` (`id`), -CONSTRAINT `x_policy_item_condition_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_policy_item_condition_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - -DROP TABLE IF EXISTS `x_policy_item_user_perm`; -CREATE TABLE `x_policy_item_user_perm` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`policy_item_id` bigint(20) NOT NULL, -`user_id` bigint(20) NULL DEFAULT NULL, -`sort_order` tinyint(3) DEFAULT '0', -primary key (`id`), -CONSTRAINT `x_policy_item_user_perm_FK_pi_id` FOREIGN KEY (`policy_item_id`) REFERENCES `x_policy_item` (`id`) , -CONSTRAINT `x_policy_item_user_perm_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_user` (`id`), -CONSTRAINT `x_policy_item_user_perm_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_policy_item_user_perm_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - - -DROP TABLE IF EXISTS `x_policy_item_group_perm`; -CREATE TABLE `x_policy_item_group_perm` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`guid` varchar(1024) DEFAULT NULL, -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`added_by_id` bigint(20) DEFAULT NULL, -`upd_by_id` bigint(20) DEFAULT NULL, -`policy_item_id` bigint(20) NOT NULL, -`group_id` bigint(20) NULL DEFAULT NULL, -`sort_order` tinyint(3) DEFAULT '0', -primary key (`id`), -CONSTRAINT `x_policy_item_group_perm_FK_pi_id` FOREIGN KEY (`policy_item_id`) REFERENCES `x_policy_item` (`id`) , -CONSTRAINT `x_policy_item_group_perm_FK_group_id` FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`), -CONSTRAINT `x_policy_item_group_perm_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), -CONSTRAINT `x_policy_item_group_perm_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) -); - -DROP TABLE IF EXISTS `x_data_hist`; -CREATE TABLE `x_data_hist` ( -`id` bigint(20) NOT NULL AUTO_INCREMENT , -`create_time` datetime DEFAULT NULL, -`update_time` datetime DEFAULT NULL, -`obj_guid` varchar(1024) not null, -`obj_class_type` int NOT NULL, -`obj_id` bigint(20) not null, -`obj_name` varchar(1024) NOT NULL, -`version` bigint(20) DEFAULT NULL, -`action` varchar(512) NOT NULL, -`from_time` datetime NOT NULL, -`to_time` datetime DEFAULT NULL, -`content` text NOT NULL, -primary key (`id`) -); - http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/reset_asset.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/reset_asset.sql b/security-admin/db/reset_asset.sql deleted file mode 100644 index 1d53819..0000000 --- a/security-admin/db/reset_asset.sql +++ /dev/null @@ -1,19 +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. - -update x_asset set config = '{"username":"policymgr","password":"policymgr","fs.default.name":"hdfs://sandbox.hortonworks.com:8020","hadoop.security.authorization":"false","hadoop.security.authentication":"simple","hadoop.security.auth_to_local":"RULE:[2:$1@$0]([rn]m@.*)s/.*/yarn/ RULE:[2:$1@$0](jhs@.*)s/.*/mapred/ RULE:[2:$1@$0]([nd]n@.*)s/.*/hdfs/ RULE:[2:$1@$0](hm@.*)s/.*/hbase/ RULE:[2:$1@$0](rs@.*)s/.*/hbase/ DEFAULT","dfs.datanode.kerberos.principal":"","dfs.namenode.kerberos.principal":"","dfs.secondary.namenode.kerberos.principal":"","commonNameForCertificate":""}' where asset_name = 'hadoopdev'; -update x_asset set config = '{"username":"policymgr","password":"policymgr","fs.default.name":"hdfs://sandbox.hortonworks.com:8020","hadoop.security.authorization":"false","hadoop.security.authentication":"simple","hadoop.security.auth_to_local":"RULE:[2:$1@$0]([rn]m@.*)s/.*/yarn/ RULE:[2:$1@$0](jhs@.*)s/.*/mapred/ RULE:[2:$1@$0]([nd]n@.*)s/.*/hdfs/ RULE:[2:$1@$0](hm@.*)s/.*/hbase/ RULE:[2:$1@$0](rs@.*)s/.*/hbase/ DEFAULT","dfs.datanode.kerberos.principal":"","dfs.namenode.kerberos.principal":"","dfs.secondary.namenode.kerberos.principal":"","hbase.master.kerberos.principal":"","hbase.rpc.engine":"org.apache.hadoop.hbase.ipc.SecureRpcEngine","hbase.rpc.protection":"privacy","hbase.security.authentication":"simple","hbase.zookeeper.property.clientPort":"2181","hbase.zookeeper.quorum":"sandbox.hortonworks.com","commonNameForCertificate":""}' where asset_name = 'hbase' ; -update x_asset set config = '{"username":"policymgr","password":"","jdbc.driverClassName":"org.apache.hive.jdbc.HiveDriver","jdbc.url":"jdbc:hive2://sandbox.hortonworks.com:10000/default","commonNameForCertificate":""}' where asset_name = 'dev-hive' ; -commit ; http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/reset_audit_mysql.sh ---------------------------------------------------------------------- diff --git a/security-admin/db/reset_audit_mysql.sh b/security-admin/db/reset_audit_mysql.sh deleted file mode 100755 index 51a5359..0000000 --- a/security-admin/db/reset_audit_mysql.sh +++ /dev/null @@ -1,44 +0,0 @@ -#!/bin/bash - -# 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. - -# -# Script to reset mysql database -# - -#if [ $# -lt 1 ]; then -# echo "Usage: $0 <db_root_password> [db_host] <db_name>" -# exit 1 -#fi -# -#db_root_password=$1 -#db_host="localhost" -#if [ "$2" != "" ]; then -# db_host="$2" -#fi -#db_name="xa_logger" -#if [ "$3" != "" ]; then -# db_name="$3" -#fi - -audit_db_user=xaadmin -audit_db_password=xaadmin -audit_db_file=xa_audit_db.sql -audit_db_name=xa_logger -echo "Importing database file $audit_db_file.sql ... " -set -x -mysql -u $audit_db_user --password=$audit_db_password -e "create database IF NOT EXISTS $audit_db_name" -mysql -u $audit_db_user --password=$audit_db_password --database=$audit_db_name < $audit_db_file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/reset_core_mysql.sh ---------------------------------------------------------------------- diff --git a/security-admin/db/reset_core_mysql.sh b/security-admin/db/reset_core_mysql.sh deleted file mode 100755 index 26f7d46..0000000 --- a/security-admin/db/reset_core_mysql.sh +++ /dev/null @@ -1,44 +0,0 @@ -#!/bin/bash - -# 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. - -# -# Script to reset mysql database -# - -#if [ $# -lt 1 ]; then -# echo "Usage: $0 <db_root_password> [db_host] <db_name>" -# exit 1 -#fi -# -#db_root_password=$1 -#db_host="localhost" -#if [ "$2" != "" ]; then -# db_host="$2" -#fi -#db_name="xa_db" -#if [ "$3" != "" ]; then -# db_name="$3" -#fi - -db_user=xaadmin -db_password=xaadmin -db_file=xa_core_db.sql -db_name=xa_db - -echo "Importing database file $db_file.sql ... " -set -x -mysql -u $db_user --password=$db_password --database=$db_name < $db_file http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/resetdb_dev_mysql.sh ---------------------------------------------------------------------- diff --git a/security-admin/db/resetdb_dev_mysql.sh b/security-admin/db/resetdb_dev_mysql.sh deleted file mode 100755 index c2bf5fb..0000000 --- a/security-admin/db/resetdb_dev_mysql.sh +++ /dev/null @@ -1,137 +0,0 @@ -#!/bin/bash - -# 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. - -# -# Script to reset mysql database -# - -#if [ $# -lt 1 ]; then -# echo "Usage: $0 <db_root_password> [db_host]" -# exit 1 -#fi -# -#db_root_password=$1 -#db_host="localhost" -#if [ "$2" != "" ]; then -# db_host="$2" -#fi - -db_user=xaadmin -db_password=xaadmin -db_file=xa_core_db.sql -db_core_file=xa_core_db.sql -db_name=xa_db - -MYSQL_BIN='mysql' -MYSQL_HOST='localhost' - -mysqlexec="${MYSQL_BIN} -u ${db_user} --password=${db_password} -h ${MYSQL_HOST} ${db_name}" - - -#echo "Importing database file $db_file ... " -#set -x -#mysql -u $db_user --password=$db_password < $db_file - - -log() { - local prefix="[$(date +%Y/%m/%d\ %H:%M:%S)]: " - echo "${prefix} $@" -} - -check_ret_status(){ - if [ $1 -ne 0 ]; then - log "[E] $2"; - exit 1; - fi -} - -import_db () { - - log "[I] Verifying Database: $db_name"; - existdb=`${MYSQL_BIN} -u ${db_user} --password=$db_password -h $MYSQL_HOST -B --skip-column-names -e "show databases like '${db_name}' ;"` - - if [ "${existdb}" = "${db_name}" ] - then - log "[I] - database ${db_name} already exists. deleting ..." - $MYSQL_BIN -u $db_user --password=$db_password -h $MYSQL_HOST -e "drop database $db_name" - - fi - - log "[I] Creating Database: $db_name"; - $MYSQL_BIN -u $db_user --password=$db_password -h $MYSQL_HOST -e "create database $db_name" - check_ret_status $? "Creating database Failed.." - - - log "[I] Importing Core Database file: $db_core_file " - $MYSQL_BIN -u $db_user --password=$db_password -h $MYSQL_HOST $db_name < $db_core_file - check_ret_status $? "Importing Database Failed.." - - log "[I] Importing Database file : $db_core_file DONE"; -} - -run_patches(){ - log "[I] - starting upgradedb ... " - - DBVERSION_CATALOG_CREATION=create_dbversion_catalog.sql - - mysqlexec="${MYSQL_BIN} -u ${db_user} --password=${db_password} -h ${MYSQL_HOST} ${db_name}" - - if [ -f ${DBVERSION_CATALOG_CREATION} ] - then - log "[I] Verifying database version catalog table .... " - ${mysqlexec} < ${DBVERSION_CATALOG_CREATION} - fi - - dt=`date '+%s'` - tempFile=/tmp/sql_${dt}_$$.sql - sqlfiles=`ls -1 patches/*.sql 2> /dev/null | awk -F/ '{ print $NF }' | awk -F- '{ print $1, $0 }' | sort -k1 -n | awk '{ printf("patches/%s\n",$2) ; }'` - for sql in ${sqlfiles} - do - if [ -f ${sql} ] - then - bn=`basename ${sql}` - version=`echo ${bn} | awk -F'-' '{ print $1 }'` - if [ "${version}" != "" ] - then - c=`${mysqlexec} -B --skip-column-names -e "select count(id) from x_db_version_h where version = '${version}' and active = 'Y'"` - check_ret_status $? "DBVerionCheck - ${version} Failed." - if [ ${c} -eq 0 ] - then - cat ${sql} > ${tempFile} - echo >> ${tempFile} - echo "insert into x_db_version_h (version, inst_at, inst_by, updated_at, updated_by) values ( '${version}', now(), user(), now(), user()) ;" >> ${tempFile} - log "[I] - patch [${version}] is being applied." - ${mysqlexec} < ${tempFile} - check_ret_status $? "Update patch - ${version} Failed. See sql file : [${tempFile}]" - rm -f ${tempFile} - else - log "[I] - patch [${version}] is already applied. Skipping ..." - fi - fi - fi - done -} - - -import_db -run_patches - - - - - - http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/xa_audit_db.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/xa_audit_db.sql b/security-admin/db/xa_audit_db.sql deleted file mode 100644 index dba98ce..0000000 --- a/security-admin/db/xa_audit_db.sql +++ /dev/null @@ -1,82 +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. - --- 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 */; - --- --- 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_added_by_id` (`added_by_id`), - KEY `xa_access_audit_upd_by_id` (`upd_by_id`), - 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; -/*!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; - --- Dump completed on 2014-05-25 0:07:27 http://git-wip-us.apache.org/repos/asf/incubator-ranger/blob/9c2f0d1f/security-admin/db/xa_core_db.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/xa_core_db.sql b/security-admin/db/xa_core_db.sql deleted file mode 100644 index 9d889a0..0000000 --- a/security-admin/db/xa_core_db.sql +++ /dev/null @@ -1,754 +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. - --- 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 */; - --- --- 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', - `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', - 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, - `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', - PRIMARY KEY (`id`), - 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_added_by_id` (`added_by_id`), - KEY `xa_access_audit_upd_by_id` (`upd_by_id`), - 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; -/*!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; - --- --- 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 */ -/*!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 \ No newline at end of file
