RMP-9160:Add consolidated db schema script for all supported DB flavor Signed-off-by: pradeep <[email protected]>
Project: http://git-wip-us.apache.org/repos/asf/ranger/repo Commit: http://git-wip-us.apache.org/repos/asf/ranger/commit/8ef10c06 Tree: http://git-wip-us.apache.org/repos/asf/ranger/tree/8ef10c06 Diff: http://git-wip-us.apache.org/repos/asf/ranger/diff/8ef10c06 Branch: refs/heads/master Commit: 8ef10c06114fb46f8cea3b3e8f6b2f852a0fb842 Parents: 8db0cec Author: Bhavik Patel <[email protected]> Authored: Fri Dec 29 11:18:42 2017 +0530 Committer: pradeep <[email protected]> Committed: Wed Jan 17 12:02:53 2018 +0530 ---------------------------------------------------------------------- .../optimized/current/ranger_core_db_mysql.sql | 1306 +++++++++++++++ .../optimized/current/ranger_core_db_oracle.sql | 1292 ++++++++++++++ .../current/ranger_core_db_postgres.sql | 1400 ++++++++++++++++ .../current/ranger_core_db_sqlanywhere.sql | 1574 ++++++++++++++++++ .../current/ranger_core_db_sqlserver.sql | 3 + 5 files changed, 5575 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/ranger/blob/8ef10c06/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql ---------------------------------------------------------------------- diff --git a/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql b/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql new file mode 100644 index 0000000..69f3768 --- /dev/null +++ b/security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql @@ -0,0 +1,1306 @@ +-- 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 VIEW IF EXISTS `vx_trx_log`; +DROP TABLE IF EXISTS `x_plugin_info`; +DROP TABLE IF EXISTS `x_service_version_info`; +DROP TABLE IF EXISTS `x_policy_item_rowfilter`; +DROP TABLE IF EXISTS `x_policy_item_datamask`; +DROP TABLE IF EXISTS `x_datamask_type_def`; +DROP TABLE IF EXISTS `x_service_resource_element_val`; +DROP TABLE IF EXISTS `x_tag_resource_map`; +DROP TABLE IF EXISTS `x_tag_attr`; +DROP TABLE IF EXISTS `x_tag_attr_def`; +DROP TABLE IF EXISTS `x_service_resource_element`; +DROP TABLE IF EXISTS `x_service_resource`; +DROP TABLE IF EXISTS `x_tag`; +DROP TABLE IF EXISTS `x_tag_def`; +DROP TABLE IF EXISTS `x_group_module_perm`; +DROP TABLE IF EXISTS `x_user_module_perm`; +DROP TABLE IF EXISTS `x_modules_master`; +DROP TABLE IF EXISTS `x_data_hist`; +DROP TABLE IF EXISTS `x_policy_item_group_perm`; +DROP TABLE IF EXISTS `x_policy_item_user_perm`; +DROP TABLE IF EXISTS `x_policy_item_condition`; +DROP TABLE IF EXISTS `x_policy_item_access`; +DROP TABLE IF EXISTS `x_policy_item`; +DROP TABLE IF EXISTS `x_policy_resource_map`; +DROP TABLE IF EXISTS `x_policy_resource`; +DROP TABLE IF EXISTS `x_service_config_map`; +DROP TABLE IF EXISTS `x_enum_element_def`; +DROP TABLE IF EXISTS `x_enum_def`; +DROP TABLE IF EXISTS `x_context_enricher_def`; +DROP TABLE IF EXISTS `x_policy_condition_def`; +DROP TABLE IF EXISTS `x_access_type_def_grants`; +DROP TABLE IF EXISTS `x_access_type_def`; +DROP TABLE IF EXISTS `x_resource_def`; +DROP TABLE IF EXISTS `x_service_config_def`; +DROP TABLE IF EXISTS `x_policy`; +DROP TABLE IF EXISTS `x_service`; +DROP TABLE IF EXISTS `x_service_def`; +DROP TABLE IF EXISTS `x_audit_map`; +DROP TABLE IF EXISTS `x_perm_map`; +DROP TABLE IF EXISTS `x_trx_log`; +DROP TABLE IF EXISTS `x_resource`; +DROP TABLE IF EXISTS `x_policy_export_audit`; +DROP TABLE IF EXISTS `x_group_users`; +DROP TABLE IF EXISTS `x_user`; +DROP TABLE IF EXISTS `x_group_groups`; +DROP TABLE IF EXISTS `x_group`; +DROP TABLE IF EXISTS `x_db_base`; +DROP TABLE IF EXISTS `x_cred_store`; +DROP TABLE IF EXISTS `x_auth_sess`; +DROP TABLE IF EXISTS `x_asset`; +DROP TABLE IF EXISTS `xa_access_audit`; +DROP TABLE IF EXISTS `x_portal_user_role`; +DROP TABLE IF EXISTS `x_portal_user`; +DROP TABLE IF EXISTS `x_db_version_h`; + +CREATE TABLE `x_db_version_h` ( + `id` bigint NOT NULL auto_increment primary key, + `version` varchar(64) NOT NULL, + `inst_at` timestamp NOT NULL DEFAULT current_timestamp, + `inst_by` varchar(256) NOT NULL, + `updated_at` timestamp NULL DEFAULT NULL, + `updated_by` varchar(256) NOT NULL, + `active` ENUM('Y', 'N') DEFAULT 'Y' +)ROW_FORMAT=DYNAMIC; + +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`) +)AUTO_INCREMENT=2 ROW_FORMAT=DYNAMIC; + +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`) +)AUTO_INCREMENT=2 ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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` MEDIUMTEXT NULL DEFAULT NULL, + `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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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(767) 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, + `group_src` INT NOT NULL DEFAULT 0, + `is_visible` INT(11) NOT NULL DEFAULT '1', + PRIMARY KEY (`id`), + UNIQUE KEY `x_group_UK_group_name` (`group_name`), + 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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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(767) NOT NULL, + `descr` varchar(4000) NOT NULL, + `status` int(11) NOT NULL DEFAULT '0', + `cred_store_id` bigint(20) DEFAULT NULL, + `is_visible` INT(11) NOT NULL DEFAULT '1', + 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_UK_user_name UNIQUE(user_name(767)), + 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`) +)ROW_FORMAT=DYNAMIC; + +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(740) NOT NULL, + `p_group_id` bigint(20) DEFAULT NULL, + `user_id` bigint(20) DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `x_group_users_UK_uid_gname` (`user_id`, `group_name`), + 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`) +)ROW_FORMAT=DYNAMIC; + +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', + `cluster_name` varchar(255) NULL DEFAULT NULL, + 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`) +)ROW_FORMAT=DYNAMIC; + +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', + `policy_name` VARCHAR( 500 ) NULL DEFAULT NULL, + `res_topologies` TEXT NULL DEFAULT NULL, + `res_services` TEXT NULL DEFAULT NULL, + `ip_address` TEXT NULL DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `x_resource_UK_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`) +)ROW_FORMAT=DYNAMIC; + +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` MEDIUMTEXT NULL DEFAULT NULL, + `new_val` MEDIUMTEXT NULL 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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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, +`def_options` VARCHAR(1024) DEFAULT NULL NULL, +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`) +)ROW_FORMAT=DYNAMIC; + +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(255) 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', +`tag_service` BIGINT DEFAULT NULL NULL, +`tag_version` BIGINT DEFAULT 0 NOT NULL, +`tag_update_time` DATETIME DEFAULT NULL NULL, +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`), +CONSTRAINT `x_service_FK_tag_service` FOREIGN KEY (`tag_service`) REFERENCES `x_service` (`id`) +)ROW_FORMAT=DYNAMIC; + +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, +`policy_type` int(11) DEFAULT 0, +`description` varchar(1024) DEFAULT NULL, +`resource_signature` varchar(128) DEFAULT NULL, +`is_enabled` tinyint(1) NOT NULL DEFAULT '0', +`is_audit_enabled` tinyint(1) NOT NULL DEFAULT '0', +primary key (`id`), +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`), +KEY `x_policy_resource_signature` (`resource_signature`), +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`) +)ROW_FORMAT=DYNAMIC; + +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, +`item_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, +`validation_reg_ex` varchar(1024) DEFAULT NULL, +`validation_message` varchar(1024) DEFAULT NULL, +`ui_hint` 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, +`rb_key_validation_message` 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`) +)ROW_FORMAT=DYNAMIC; + +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, +`item_id` bigint(20) NOT NULL, +`name` varchar(1024) DEFAULT NULL, +`type` varchar(1024) DEFAULT NULL, +`res_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, +`validation_reg_ex` varchar(1024) DEFAULT NULL, +`validation_message` varchar(1024) DEFAULT NULL, +`ui_hint` 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, +`rb_key_validation_message` varchar(1024) DEFAULT NULL, +`sort_order` tinyint(3) DEFAULT '0', +`datamask_options` varchar(1024) NULL DEFAULT NULL, +`rowfilter_options` varchar(1024) NULL DEFAULT NULL, +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`) +)ROW_FORMAT=DYNAMIC; + +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, +`item_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', +`datamask_options` varchar(1024) NULL DEFAULT NULL, +`rowfilter_options` varchar(1024) NULL DEFAULT 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_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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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, +`item_id` bigint(20) NOT NULL, +`name` varchar(1024) DEFAULT NULL, +`evaluator` varchar(1024) DEFAULT NULL, +`evaluator_options` varchar(1024) DEFAULT NULL, +`validation_reg_ex` varchar(1024) DEFAULT NULL, +`validation_message` varchar(1024) DEFAULT NULL, +`ui_hint` 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, +`rb_key_validation_message` 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`) +)ROW_FORMAT=DYNAMIC; + +CREATE TABLE `x_context_enricher_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, +`item_id` bigint(20) NOT NULL, +`name` varchar(1024) DEFAULT NULL, +`enricher` varchar(1024) DEFAULT NULL, +`enricher_options` varchar(1024) DEFAULT NULL, +`sort_order` tinyint(3) DEFAULT '0', +primary key (`id`) , +CONSTRAINT `x_context_enricher_def_FK_defid` FOREIGN KEY (`def_id`) REFERENCES `x_service_def` (`id`), +CONSTRAINT `x_context_enricher_def_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_context_enricher_def_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; + +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, +`item_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`) +)ROW_FORMAT=DYNAMIC; + +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, +`item_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`) +)ROW_FORMAT=DYNAMIC; + +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(4000) 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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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` INT 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`) +)ROW_FORMAT=DYNAMIC; + +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', +`item_type` INT DEFAULT 0 NOT NULL, +`is_enabled` TINYINT(1) NOT NULL DEFAULT '1', +`comments` VARCHAR(255) DEFAULT NULL 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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +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` INT 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`) +)ROW_FORMAT=DYNAMIC; + +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` INT 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`) +)ROW_FORMAT=DYNAMIC; + +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`) +)ROW_FORMAT=DYNAMIC; + +CREATE TABLE `x_modules_master` ( +`id` bigint(20) NOT NULL AUTO_INCREMENT, +`create_time` datetime NULL DEFAULT NULL, +`update_time` datetime NULL DEFAULT NULL, +`added_by_id` bigint(20) NULL DEFAULT NULL, +`upd_by_id` bigint(20) NULL DEFAULT NULL, +`module` varchar(1024) NOT NULL, +`url` varchar(1024) NULL DEFAULT NULL, +PRIMARY KEY (`id`) +)ROW_FORMAT=DYNAMIC; + +INSERT INTO `x_modules_master` VALUES (1,now(),now(),1,1,'Resource Based Policies',''),(2,now(),now(),1,1,'Users/Groups',''),(3,now(),now(),1,1,'Reports',''),(4,now(),now(),1,1,'Audit',''),(5,now(),now(),1,1,'Key Manager',''); + +CREATE TABLE `x_user_module_perm` ( +`id` bigint(20) NOT NULL AUTO_INCREMENT, +`user_id` bigint(20) NULL DEFAULT NULL, +`module_id` bigint(20) NULL DEFAULT NULL, +`create_time` datetime NULL DEFAULT NULL, +`update_time` datetime NULL DEFAULT NULL, +`added_by_id` bigint(20) NULL DEFAULT NULL, +`upd_by_id` bigint(20) NULL DEFAULT NULL, +`is_allowed` int(11) NOT NULL DEFAULT '1', +PRIMARY KEY (`id`), +KEY `x_user_module_perm_idx_module_id` (`module_id`), +KEY `x_user_module_perm_idx_user_id` (`user_id`), +CONSTRAINT `x_user_module_perm_FK_module_id` FOREIGN KEY (`module_id`) REFERENCES `x_modules_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, +CONSTRAINT `x_user_module_perm_FK_user_id` FOREIGN KEY (`user_id`) REFERENCES `x_portal_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE +)ROW_FORMAT=DYNAMIC; + +CREATE TABLE `x_group_module_perm` ( +`id` bigint(20) NOT NULL AUTO_INCREMENT, +`group_id` bigint(20) NULL DEFAULT NULL, +`module_id` bigint(20) NULL DEFAULT NULL, +`create_time` datetime NULL DEFAULT NULL, +`update_time` datetime NULL DEFAULT NULL, +`added_by_id` bigint(20) NULL DEFAULT NULL, +`upd_by_id` bigint(20) NULL DEFAULT NULL, +`is_allowed` int(11) NOT NULL DEFAULT '1', +PRIMARY KEY (`id`), +KEY `x_group_module_perm_idx_group_id` (`group_id`), +KEY `x_group_module_perm_idx_module_id` (`module_id`), +CONSTRAINT `x_group_module_perm_FK_module_id` FOREIGN KEY (`module_id`) REFERENCES `x_modules_master` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, +CONSTRAINT `x_group_module_perm_FK_user_id` FOREIGN KEY (`group_id`) REFERENCES `x_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE +)ROW_FORMAT=DYNAMIC; + +-- ----------------------------------------------------- +-- Table `x_tag_def` +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS `x_tag_def` ( +`id` BIGINT(20) NOT NULL AUTO_INCREMENT, +`guid` VARCHAR(64) NOT NULL, +`create_time` DATETIME NULL DEFAULT NULL, +`update_time` DATETIME NULL DEFAULT NULL, +`added_by_id` BIGINT(20) NULL DEFAULT NULL, +`upd_by_id` BIGINT(20) NULL DEFAULT NULL, +`version` BIGINT(20) NULL DEFAULT NULL, +`name` VARCHAR(255) NOT NULL, +`source` VARCHAR(128) NULL DEFAULT NULL, +`is_enabled` TINYINT(1) NOT NULL DEFAULT '0', +PRIMARY KEY (`id`), +UNIQUE KEY `x_tag_def_UK_guid` (`guid`), +UNIQUE KEY `x_tag_def_UK_name` (`name`), +KEY `x_tag_def_IDX_added_by_id` (`added_by_id`), +KEY `x_tag_def_IDX_upd_by_id` (`upd_by_id`), +CONSTRAINT `x_tag_def_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_tag_def_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; +-- ----------------------------------------------------- +-- Table `x_tag` +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS `x_tag` ( +`id` BIGINT(20) NOT NULL AUTO_INCREMENT, +`guid` VARCHAR(64) NOT NULL, +`create_time` DATETIME NULL DEFAULT NULL, +`update_time` DATETIME NULL DEFAULT NULL, +`added_by_id` BIGINT(20) NULL DEFAULT NULL, +`upd_by_id` BIGINT(20) NULL DEFAULT NULL, +`version` BIGINT(20) NULL DEFAULT NULL, +`type` BIGINT(20) NOT NULL, +`owned_by` SMALLINT DEFAULT 0 NOT NULL, +PRIMARY KEY (`id`), +UNIQUE KEY `x_tag_UK_guid` (`guid`), +KEY `x_tag_IDX_type` (`type`), +KEY `x_tag_IDX_added_by_id` (`added_by_id`), +KEY `x_tag_IDX_upd_by_id` (`upd_by_id`), +CONSTRAINT `x_tag_FK_type` FOREIGN KEY (`type`) REFERENCES `x_tag_def` (`id`), +CONSTRAINT `x_tag_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_tag_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; +-- ----------------------------------------------------- +-- Table `x_service_resource` +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS `x_service_resource` ( +`id` BIGINT(20) NOT NULL AUTO_INCREMENT, +`guid` VARCHAR(64) NOT NULL, +`create_time` DATETIME NULL DEFAULT NULL, +`update_time` DATETIME NULL DEFAULT NULL, +`added_by_id` BIGINT(20) NULL DEFAULT NULL, +`upd_by_id` BIGINT(20) NULL DEFAULT NULL, +`version` BIGINT(20) NULL DEFAULT NULL, +`service_id` BIGINT(20) NOT NULL, +`resource_signature` varchar(128) NULL DEFAULT NULL, +`is_enabled` TINYINT NOT NULL DEFAULT '1', +PRIMARY KEY (`id`), +UNIQUE KEY `x_service_res_UK_guid` (`guid`), +KEY `x_service_res_IDX_added_by_id` (`added_by_id`), +KEY `x_service_res_IDX_upd_by_id` (`upd_by_id`), +CONSTRAINT `x_service_res_FK_service_id` FOREIGN KEY (`service_id`) REFERENCES `x_service` (`id`), +CONSTRAINT `x_service_res_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_service_res_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; +-- ----------------------------------------------------- +-- Table `x_service_resource_element` +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS `x_service_resource_element` ( +`id` BIGINT(20) NOT NULL AUTO_INCREMENT, +`create_time` DATETIME NULL DEFAULT NULL, +`update_time` DATETIME NULL DEFAULT NULL, +`added_by_id` BIGINT(20) NULL DEFAULT NULL, +`upd_by_id` BIGINT(20) NULL DEFAULT NULL, +`res_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`), +KEY `x_srvc_res_el_IDX_added_by_id` (`added_by_id`), +KEY `x_srvc_res_el_IDX_upd_by_id` (`upd_by_id`), +CONSTRAINT `x_srvc_res_el_FK_res_def_id` FOREIGN KEY (`res_def_id`) REFERENCES `x_resource_def` (`id`), +CONSTRAINT `x_srvc_res_el_FK_res_id` FOREIGN KEY (`res_id`) REFERENCES `x_service_resource` (`id`), +CONSTRAINT `x_srvc_res_el_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_srvc_res_el_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; +-- ----------------------------------------------------- +-- Table `x_tag_attr_def` +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS `x_tag_attr_def` ( +`id` BIGINT(20) NOT NULL AUTO_INCREMENT, +`create_time` DATETIME NULL DEFAULT NULL, +`update_time` DATETIME NULL DEFAULT NULL, +`added_by_id` BIGINT(20) NULL DEFAULT NULL, +`upd_by_id` BIGINT(20) NULL DEFAULT NULL, +`tag_def_id` BIGINT(20) NOT NULL, +`name` VARCHAR(255) NOT NULL, +`type` VARCHAR(50) NOT NULL, +PRIMARY KEY (`id`), +KEY `x_tag_attr_def_IDX_tag_def_id` (`tag_def_id`), +KEY `x_tag_attr_def_IDX_added_by_id` (`added_by_id`), +KEY `x_tag_attr_def_IDX_upd_by_id` (`upd_by_id`), +CONSTRAINT `x_tag_attr_def_FK_tag_def_id` FOREIGN KEY (`tag_def_id`) REFERENCES `x_tag_def` (`id`), +CONSTRAINT `x_tag_attr_def_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_tag_attr_def_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; +-- ----------------------------------------------------- +-- Table `x_tag_attr` +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS `x_tag_attr` ( +`id` BIGINT(20) NOT NULL AUTO_INCREMENT, +`create_time` DATETIME NULL DEFAULT NULL, +`update_time` DATETIME NULL DEFAULT NULL, +`added_by_id` BIGINT(20) NULL DEFAULT NULL, +`upd_by_id` BIGINT(20) NULL DEFAULT NULL, +`tag_id` BIGINT(20) NOT NULL, +`name` VARCHAR(255) NOT NULL, +`value` VARCHAR(512) NULL, +PRIMARY KEY (`id`), +KEY `x_tag_attr_IDX_tag_id` (`tag_id`), +KEY `x_tag_attr_IDX_added_by_id` (`added_by_id`), +KEY `x_tag_attr_IDX_upd_by_id` (`upd_by_id`), +CONSTRAINT `x_tag_attr_FK_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `x_tag` (`id`), +CONSTRAINT `x_tag_attr_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_tag_attr_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; +-- ----------------------------------------------------- +-- Table `x_tag_resource_map` +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS `x_tag_resource_map` ( +`id` BIGINT(20) NOT NULL AUTO_INCREMENT, +`guid` VARCHAR(64) NOT NULL, +`create_time` DATETIME NULL DEFAULT NULL, +`update_time` DATETIME NULL DEFAULT NULL, +`added_by_id` BIGINT(20) NULL DEFAULT NULL, +`upd_by_id` BIGINT(20) NULL DEFAULT NULL, +`tag_id` BIGINT(20) NOT NULL, +`res_id` BIGINT(20) NOT NULL, +PRIMARY KEY (`id`), +UNIQUE KEY `x_tag_res_map_UK_guid` (`guid`), +KEY `x_tag_res_map_IDX_tag_id` (`tag_id`), +KEY `x_tag_res_map_IDX_res_id` (`res_id`), +KEY `x_tag_res_map_IDX_added_by_id` (`added_by_id`), +KEY `x_tag_res_map_IDX_upd_by_id` (`upd_by_id`), +CONSTRAINT `x_tag_res_map_FK_tag_id` FOREIGN KEY (`tag_id`) REFERENCES `x_tag` (`id`), +CONSTRAINT `x_tag_res_map_FK_res_id` FOREIGN KEY (`res_id`) REFERENCES `x_service_resource` (`id`), +CONSTRAINT `x_tag_res_map_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_tag_res_map_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; +-- ----------------------------------------------------- +-- Table `x_service_resource_element_val` +-- ----------------------------------------------------- +CREATE TABLE IF NOT EXISTS `x_service_resource_element_val` ( +`id` BIGINT(20) NOT NULL AUTO_INCREMENT, +`create_time` DATETIME NULL DEFAULT NULL, +`update_time` DATETIME NULL DEFAULT NULL, +`added_by_id` BIGINT(20) NULL DEFAULT NULL, +`upd_by_id` BIGINT(20) NULL DEFAULT NULL, +`res_element_id` BIGINT(20) NOT NULL, +`value` VARCHAR(1024) NOT NULL, +`sort_order` tinyint(3) NULL DEFAULT '0', +PRIMARY KEY (`id`), +KEY `x_srvc_res_el_val_IDX_resel_id` (`res_element_id`), +KEY `x_srvc_res_el_val_IDX_addby_id` (`added_by_id`), +KEY `x_srvc_res_el_val_IDX_updby_id` (`upd_by_id`), +CONSTRAINT `x_srvc_res_el_val_FK_res_el_id` FOREIGN KEY (`res_element_id`) REFERENCES `x_service_resource_element` (`id`), +CONSTRAINT `x_srvc_res_el_val_FK_add_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_srvc_res_el_val_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; +INSERT INTO `x_modules_master` VALUES (6,now(),now(),1,1,'Tag Based Policies',''); + +CREATE TABLE `x_datamask_type_def` ( +`id` bigint(20) NOT NULL AUTO_INCREMENT , +`guid` varchar(64) NULL DEFAULT NULL, +`create_time` datetime NULL DEFAULT NULL, +`update_time` datetime NULL DEFAULT NULL, +`added_by_id` bigint(20) NULL DEFAULT NULL, +`upd_by_id` bigint(20) NULL DEFAULT NULL, +`def_id` bigint(20) NOT NULL, +`item_id` bigint(20) NOT NULL, +`name` varchar(1024) NOT NULL, +`label` varchar(1024) NOT NULL, +`description` varchar(1024) NULL DEFAULT NULL, +`transformer` varchar(1024) NULL DEFAULT NULL, +`datamask_options` varchar(1024) NULL DEFAULT NULL, +`rb_key_label` varchar(1024) NULL DEFAULT NULL, +`rb_key_description` varchar(1024) DEFAULT NULL, +`sort_order` tinyint(3) DEFAULT '0', +primary key (`id`), +CONSTRAINT `x_datamask_type_def_FK_def_id` FOREIGN KEY (`def_id`) REFERENCES `x_service_def` (`id`) , +CONSTRAINT `x_datamask_type_def_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_datamask_type_def_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; + +CREATE TABLE `x_policy_item_datamask` ( +`id` bigint(20) NOT NULL AUTO_INCREMENT , +`guid` varchar(64) NULL DEFAULT NULL, +`create_time` datetime NULL DEFAULT NULL, +`update_time` datetime NULL DEFAULT NULL, +`added_by_id` bigint(20) NULL DEFAULT NULL, +`upd_by_id` bigint(20) NULL DEFAULT NULL, +`policy_item_id` bigint(20) NOT NULL, +`type` bigint(20) NOT NULL, +`condition_expr` varchar(1024) NULL DEFAULT NULL, +`value_expr` varchar(1024) NULL DEFAULT NULL, +primary key (id), +CONSTRAINT `x_policy_item_datamask_FK_policy_item_id` FOREIGN KEY (`policy_item_id`) REFERENCES `x_policy_item` (`id`) , +CONSTRAINT `x_policy_item_datamask_FK_type` FOREIGN KEY (`type`) REFERENCES `x_datamask_type_def` (`id`), +CONSTRAINT `x_policy_item_datamask_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_policy_item_datamask_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; + +CREATE TABLE `x_policy_item_rowfilter` ( +`id` bigint(20) NOT NULL AUTO_INCREMENT , +`guid` varchar(64) NULL DEFAULT NULL, +`create_time` datetime NULL DEFAULT NULL, +`update_time` datetime NULL DEFAULT NULL, +`added_by_id` bigint(20) NULL DEFAULT NULL, +`upd_by_id` bigint(20) NULL DEFAULT NULL, +`policy_item_id` bigint(20) NOT NULL, +`filter_expr` varchar(1024) NULL DEFAULT NULL, +primary key (id), +CONSTRAINT `x_policy_item_rowfilter_FK_policy_item_id` FOREIGN KEY (`policy_item_id`) REFERENCES `x_policy_item` (`id`) , +CONSTRAINT `x_policy_item_rowfilter_FK_added_by_id` FOREIGN KEY (`added_by_id`) REFERENCES `x_portal_user` (`id`), +CONSTRAINT `x_policy_item_rowfilter_FK_upd_by_id` FOREIGN KEY (`upd_by_id`) REFERENCES `x_portal_user` (`id`) +)ROW_FORMAT=DYNAMIC; + +CREATE TABLE `x_service_version_info` ( +`id` bigint(20) NOT NULL AUTO_INCREMENT, +`service_id` bigint(20) NOT NULL, +`policy_version` bigint(20) NOT NULL DEFAULT 0, +`policy_update_time` datetime NULL DEFAULT NULL, +`tag_version` bigint(20) NOT NULL DEFAULT 0, +`tag_update_time` datetime NULL DEFAULT NULL, +primary key (`id`), +CONSTRAINT `x_service_version_info_FK_service_id` FOREIGN KEY (`service_id`) REFERENCES `x_service` (`id`) +)ROW_FORMAT=DYNAMIC; + +CREATE TABLE IF NOT EXISTS `x_plugin_info`( +`id` bigint(20) NOT NULL AUTO_INCREMENT, +`create_time` datetime NULL DEFAULT NULL, +`update_time` datetime NULL DEFAULT NULL, +`service_name` varchar(255) NOT NULL, +`app_type` varchar(128) NOT NULL, +`host_name` varchar(255) NOT NULL, +`ip_address` varchar(64) NOT NULL, +`info` varchar(1024) NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `x_plugin_info_UK`(`service_name`, `host_name`, `app_type`), + KEY `x_plugin_info_IDX_service_name`(`service_name`), + KEY `x_plugin_info_IDX_host_name`(`host_name`) +)ROW_FORMAT=DYNAMIC; + + +CREATE INDEX x_service_config_def_IDX_def_id ON x_service_config_def(def_id); +CREATE INDEX x_resource_def_IDX_def_id ON x_resource_def(def_id); +CREATE INDEX x_access_type_def_IDX_def_id ON x_access_type_def(def_id); +CREATE INDEX x_access_type_def_IDX_grants_atd_id ON x_access_type_def_grants(atd_id); +CREATE INDEX x_context_enricher_def_IDX_def_id ON x_context_enricher_def(def_id); +CREATE INDEX x_enum_def_IDX_def_id ON x_enum_def(def_id); +CREATE INDEX x_enum_element_def_IDX_enum_def_id ON x_enum_element_def(enum_def_id); +CREATE INDEX x_service_config_map_IDX_service ON x_service_config_map(service); +CREATE INDEX x_policy_resource_IDX_policy_id ON x_policy_resource(policy_id); +CREATE INDEX x_policy_resource_IDX_res_def_id ON x_policy_resource(res_def_id); +CREATE INDEX x_policy_resource_map_IDX_resource_id ON x_policy_resource_map(resource_id); +CREATE INDEX x_policy_item_IDX_policy_id ON x_policy_item(policy_id); +CREATE INDEX x_policy_item_access_IDX_policy_item_id ON x_policy_item_access(policy_item_id); +CREATE INDEX x_policy_item_access_IDX_type ON x_policy_item_access(type); +CREATE INDEX x_policy_item_condition_IDX_policy_item_id ON x_policy_item_condition(policy_item_id); +CREATE INDEX x_policy_item_condition_IDX_type ON x_policy_item_condition(type); +CREATE INDEX x_policy_item_user_perm_IDX_policy_item_id ON x_policy_item_user_perm(policy_item_id); +CREATE INDEX x_policy_item_user_perm_IDX_user_id ON x_policy_item_user_perm(user_id); +CREATE INDEX x_policy_item_group_perm_IDX_policy_item_id ON x_policy_item_group_perm(policy_item_id); +CREATE INDEX x_policy_item_group_perm_IDX_group_id ON x_policy_item_group_perm(group_id); +CREATE INDEX x_service_resource_IDX_service_id ON x_service_resource(service_id); +CREATE INDEX x_service_resource_element_IDX_res_id ON x_service_resource_element(res_id); +CREATE INDEX x_service_resource_element_IDX_res_def_id ON x_service_resource_element(res_def_id); +CREATE INDEX x_datamask_type_def_IDX_def_id ON x_datamask_type_def(def_id); +CREATE INDEX x_policy_item_datamask_IDX_policy_item_id ON x_policy_item_datamask(policy_item_id); +CREATE INDEX x_policy_item_rowfilter_IDX_policy_item_id ON x_policy_item_rowfilter(policy_item_id); +CREATE INDEX x_service_version_info_IDX_service_id ON x_service_version_info(service_id); + +CREATE 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 where id in(select min(x_trx_log.id) from x_trx_log group by x_trx_log.trx_id); + +INSERT INTO `x_portal_user` VALUES (1,now(),now(),NULL,NULL,'Admin','','Admin','admin','ceb4f32325eda6142bd65215f4c0f371','',1,0,NULL); +INSERT INTO `x_portal_user_role` VALUES (1,now(),now(),NULL,NULL,1,'ROLE_SYS_ADMIN',1); +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); +INSERT INTO x_portal_user(create_time,update_time,added_by_id,upd_by_id,first_name,last_name,pub_scr_name,login_id,password,email,status,user_src,notes) VALUES (UTC_TIMESTAMP(),UTC_TIMESTAMP(),NULL,NULL,'rangerusersync','','rangerusersync','rangerusersync','70b8374d3dfe0325aaa5002a688c7e3b','rangerusersync',1,0,NULL); +INSERT INTO x_portal_user_role(create_time,update_time,added_by_id,upd_by_id,user_id,user_role,status) VALUES (UTC_TIMESTAMP(),UTC_TIMESTAMP(),NULL,NULL,2,'ROLE_SYS_ADMIN',1); +INSERT INTO x_user(create_time,update_time,added_by_id,upd_by_id,user_name,descr,status) values (UTC_TIMESTAMP(), UTC_TIMESTAMP(),NULL,NULL,'admin','Administrator',0); +INSERT INTO x_user(create_time,update_time,added_by_id,upd_by_id,user_name,descr,status) values (UTC_TIMESTAMP(), UTC_TIMESTAMP(),NULL,NULL,'rangerusersync','rangerusersync',0); +INSERT INTO x_portal_user(create_time,update_time,added_by_id,upd_by_id,first_name,last_name,pub_scr_name,login_id,password,email,status,user_src,notes) VALUES (UTC_TIMESTAMP(),UTC_TIMESTAMP(),NULL,NULL,'keyadmin','','keyadmin','keyadmin','a05f34d2dce2b4688fa82e82a89ba958','keyadmin',1,0,NULL); +INSERT INTO x_portal_user_role(create_time,update_time,added_by_id,upd_by_id,user_id,user_role,status) VALUES (UTC_TIMESTAMP(),UTC_TIMESTAMP(),NULL,NULL,3,'ROLE_KEY_ADMIN',1); +INSERT INTO x_user(create_time,update_time,added_by_id,upd_by_id,user_name,descr,status) values (UTC_TIMESTAMP(), UTC_TIMESTAMP(),NULL,NULL,'keyadmin','keyadmin',0); +INSERT INTO x_portal_user(create_time,update_time,added_by_id,upd_by_id,first_name,last_name,pub_scr_name,login_id,password,email,status,user_src,notes) VALUES (UTC_TIMESTAMP(),UTC_TIMESTAMP(),NULL,NULL,'rangertagsync','','rangertagsync','rangertagsync','f5820e1229418dcf2575908f2c493da5','rangertagsync',1,0,NULL); +INSERT INTO x_portal_user_role(create_time,update_time,added_by_id,upd_by_id,user_id,user_role,status) VALUES (UTC_TIMESTAMP(),UTC_TIMESTAMP(),NULL,NULL,4,'ROLE_SYS_ADMIN',1); +INSERT INTO x_user(create_time,update_time,added_by_id,upd_by_id,user_name,descr,status) values (UTC_TIMESTAMP(), UTC_TIMESTAMP(),NULL,NULL,'rangertagsync','rangertagsync',0); + +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('CORE_DB_SCHEMA',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('001',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('002',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('003',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('004',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('005',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('006',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('007',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('008',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('009',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('010',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('012',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('013',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('014',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('016',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('018',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('019',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('020',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('021',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('022',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('023',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('024',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('025',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('026',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('027',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('028',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('029',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('DB_PATCHES',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (1,3,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (1,1,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (1,4,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (1,2,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (1,6,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (2,3,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (2,1,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (2,4,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (2,2,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (2,6,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (3,5,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (3,3,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (3,1,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (4,3,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (4,1,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (4,4,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (4,2,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_user_module_perm (user_id,module_id,create_time,update_time,added_by_id,upd_by_id,is_allowed) VALUES (4,6,UTC_TIMESTAMP(),UTC_TIMESTAMP(),1,1,1); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10001',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10002',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10003',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10004',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10005',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10006',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10007',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10008',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10009',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10010',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10011',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('J10012',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y'); +INSERT INTO x_db_version_h (version,inst_at,inst_by,updated_at,updated_by,active) VALUES ('JAVA_PATCHES',UTC_TIMESTAMP(),'Ranger 1.0.0',UTC_TIMESTAMP(),'localhost','Y');
