text: -- 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 TABLE IF EXISTS `vx_trx_log`;
  DROP VIEW IF EXISTS `vx_trx_log`;
  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`;
  
  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` 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`)
  )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(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`)
  )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(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`)
  )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(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`)
  )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',
    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',
    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`)
  )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` 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`)
  )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 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);
  