You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ranger.apache.org by ga...@apache.org on 2017/04/27 19:36:56 UTC
[1/3] ranger git commit: RANGER-1522 : Update consolidated db schema
script for SQLServer DB flavor to reduce execution time
Repository: ranger
Updated Branches:
refs/heads/master c77848761 -> c01d01f54
http://git-wip-us.apache.org/repos/asf/ranger/blob/c01d01f5/security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql b/security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
new file mode 100644
index 0000000..68d3a05
--- /dev/null
+++ b/security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
@@ -0,0 +1,3008 @@
+-- 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.
+
+IF (OBJECT_ID('x_user_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_user] DROP CONSTRAINT x_user_FK_upd_by_id
+END
+IF (OBJECT_ID('x_user_FK_cred_store_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_user] DROP CONSTRAINT x_user_FK_cred_store_id
+END
+IF (OBJECT_ID('x_user_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_user] DROP CONSTRAINT x_user_FK_added_by_id
+END
+IF (OBJECT_ID('x_trx_log_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_trx_log] DROP CONSTRAINT x_trx_log_FK_upd_by_id
+END
+IF (OBJECT_ID('x_trx_log_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_trx_log] DROP CONSTRAINT x_trx_log_FK_added_by_id
+END
+IF (OBJECT_ID('x_resource_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource] DROP CONSTRAINT x_resource_FK_upd_by_id
+END
+IF (OBJECT_ID('x_resource_FK_parent_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource] DROP CONSTRAINT x_resource_FK_parent_id
+END
+IF (OBJECT_ID('x_resource_FK_asset_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource] DROP CONSTRAINT x_resource_FK_asset_id
+END
+IF (OBJECT_ID('x_resource_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource] DROP CONSTRAINT x_resource_FK_added_by_id
+END
+IF (OBJECT_ID('x_portal_user_role_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user_role] DROP CONSTRAINT x_portal_user_role_FK_user_id
+END
+IF (OBJECT_ID('x_portal_user_role_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user_role] DROP CONSTRAINT x_portal_user_role_FK_upd_by_id
+END
+IF (OBJECT_ID('x_portal_user_role_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user_role] DROP CONSTRAINT x_portal_user_role_FK_added_by_id
+END
+IF (OBJECT_ID('x_portal_user_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user] DROP CONSTRAINT x_portal_user_FK_upd_by_id
+END
+IF (OBJECT_ID('x_portal_user_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user] DROP CONSTRAINT x_portal_user_FK_added_by_id
+END
+IF (OBJECT_ID('x_policy_export_audit_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_export_audit] DROP CONSTRAINT x_policy_export_audit_FK_upd_by_id
+END
+IF (OBJECT_ID('x_policy_export_audit_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_export_audit] DROP CONSTRAINT x_policy_export_audit_FK_added_by_id
+END
+IF (OBJECT_ID('x_perm_map_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_user_id
+END
+IF (OBJECT_ID('x_user_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_upd_by_id
+END
+IF (OBJECT_ID('x_perm_map_FK_res_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_res_id
+END
+IF (OBJECT_ID('x_perm_map_FK_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_group_id
+END
+IF (OBJECT_ID('x_perm_map_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_added_by_id
+END
+IF (OBJECT_ID('x_group_users_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_users] DROP CONSTRAINT x_group_users_FK_user_id
+END
+IF (OBJECT_ID('x_group_users_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_users] DROP CONSTRAINT x_group_users_FK_upd_by_id
+END
+IF (OBJECT_ID('x_group_users_FK_p_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_users] DROP CONSTRAINT x_group_users_FK_p_group_id
+END
+IF (OBJECT_ID('x_group_users_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_users] DROP CONSTRAINT x_group_users_FK_added_by_id
+END
+IF (OBJECT_ID('x_group_groups_FK_p_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_groups] DROP CONSTRAINT x_group_groups_FK_p_group_id
+END
+IF (OBJECT_ID('x_group_groups_FK_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_groups] DROP CONSTRAINT x_group_groups_FK_group_id
+END
+IF (OBJECT_ID('x_group_groups_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_groups] DROP CONSTRAINT x_group_groups_FK_added_by_id
+END
+IF (OBJECT_ID('x_group_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group] DROP CONSTRAINT x_group_FK_upd_by_id
+END
+IF (OBJECT_ID('x_group_FK_cred_store_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group] DROP CONSTRAINT x_group_FK_cred_store_id
+END
+IF (OBJECT_ID('x_group_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group] DROP CONSTRAINT x_group_FK_added_by_id
+END
+IF (OBJECT_ID('x_db_base_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_db_base] DROP CONSTRAINT x_db_base_FK_upd_by_id
+END
+IF (OBJECT_ID('x_db_base_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_db_base] DROP CONSTRAINT x_db_base_FK_added_by_id
+END
+IF (OBJECT_ID('x_cred_store_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_cred_store] DROP CONSTRAINT x_cred_store_FK_upd_by_id
+END
+IF (OBJECT_ID('x_cred_store_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_cred_store] DROP CONSTRAINT x_cred_store_FK_added_by_id
+END
+IF (OBJECT_ID('x_auth_sess_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_auth_sess] DROP CONSTRAINT x_auth_sess_FK_user_id
+END
+IF (OBJECT_ID('x_auth_sess_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_auth_sess] DROP CONSTRAINT x_auth_sess_FK_upd_by_id
+END
+IF (OBJECT_ID('x_auth_sess_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_auth_sess] DROP CONSTRAINT x_auth_sess_FK_added_by_id
+END
+IF (OBJECT_ID('x_audit_map_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_user_id
+END
+IF (OBJECT_ID('x_audit_map_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_upd_by_id
+END
+IF (OBJECT_ID('x_audit_map_FK_res_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_res_id
+END
+IF (OBJECT_ID('x_audit_map_FK_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_group_id
+END
+IF (OBJECT_ID('x_audit_map_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_added_by_id
+END
+IF (OBJECT_ID('x_user_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_asset_FK_upd_by_id] DROP CONSTRAINT x_asset_FK_upd_by_id
+END
+IF (OBJECT_ID('x_asset_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_asset] DROP CONSTRAINT x_asset_FK_added_by_id
+END
+IF (OBJECT_ID('x_service_def_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_def] DROP CONSTRAINT x_service_def_FK_added_by_id
+END
+IF (OBJECT_ID('x_service_def_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_def] DROP CONSTRAINT x_service_def_FK_upd_by_id
+END
+IF (OBJECT_ID('x_service_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service] DROP CONSTRAINT x_service_FK_added_by_id
+END
+IF (OBJECT_ID('x_service_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service] DROP CONSTRAINT x_service_FK_upd_by_id
+END
+IF (OBJECT_ID('x_service_FK_type') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service] DROP CONSTRAINT x_service_FK_type
+END
+IF (OBJECT_ID('x_policy_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy] DROP CONSTRAINT x_policy_FK_added_by_id
+END
+IF (OBJECT_ID('x_policy_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy] DROP CONSTRAINT x_policy_FK_upd_by_id
+END
+IF (OBJECT_ID('x_policy_FK_service') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy] DROP CONSTRAINT x_policy_FK_service
+END
+IF (OBJECT_ID('x_service_config_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_config_def] DROP CONSTRAINT x_service_config_def_FK_defid
+END
+IF (OBJECT_ID('x_resource_def_FK_parent') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource_def] DROP CONSTRAINT x_resource_def_FK_parent
+END
+IF (OBJECT_ID('x_resource_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource_def] DROP CONSTRAINT x_resource_def_FK_defid
+END
+IF (OBJECT_ID('x_access_type_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_access_type_def] DROP CONSTRAINT x_access_type_def_FK_defid
+END
+IF (OBJECT_ID('x_atd_grants_FK_atdid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_access_type_def_grants] DROP CONSTRAINT x_atd_grants_FK_atdid
+END
+IF (OBJECT_ID('x_policy_condition_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_condition_def] DROP CONSTRAINT x_policy_condition_def_FK_defid
+END
+IF (OBJECT_ID('x_enum_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_enum_def] DROP CONSTRAINT x_enum_def_FK_defid
+END
+IF (OBJECT_ID('x_enum_element_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_enum_element_def] DROP CONSTRAINT x_enum_element_def_FK_defid
+END
+IF (OBJECT_ID('x_service_config_map_FK_') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_config_map] DROP CONSTRAINT x_service_config_map_FK_
+END
+IF (OBJECT_ID('x_policy_resource_FK_policy_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_resource] DROP CONSTRAINT x_policy_resource_FK_policy_id
+END
+IF (OBJECT_ID('x_policy_resource_FK_res_def_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_resource] DROP CONSTRAINT x_policy_resource_FK_res_def_id
+END
+IF (OBJECT_ID('x_policy_resource_map_FK_resource_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_resource_map] DROP CONSTRAINT x_policy_resource_map_FK_resource_id
+END
+IF (OBJECT_ID('x_policy_item_FK_policy_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item] DROP CONSTRAINT x_policy_item_FK_policy_id
+END
+IF (OBJECT_ID('x_policy_item_access_FK_pi_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_access] DROP CONSTRAINT x_policy_item_access_FK_pi_id
+END
+IF (OBJECT_ID('x_policy_item_access_FK_atd_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_access] DROP CONSTRAINT x_policy_item_access_FK_atd_id
+END
+IF (OBJECT_ID('x_policy_item_condition_FK_pi_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_condition] DROP CONSTRAINT x_policy_item_condition_FK_pi_id
+END
+IF (OBJECT_ID('x_policy_item_condition_FK_pcd_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_condition] DROP CONSTRAINT x_policy_item_condition_FK_pcd_id
+END
+IF (OBJECT_ID('x_policy_item_user_perm_FK_pi_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_user_perm] DROP CONSTRAINT x_policy_item_user_perm_FK_pi_id
+END
+IF (OBJECT_ID('x_policy_item_user_perm_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_user_perm] DROP CONSTRAINT x_policy_item_user_perm_FK_user_id
+END
+IF (OBJECT_ID('x_policy_item_group_perm_FK_pi_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_group_perm] DROP CONSTRAINT x_policy_item_group_perm_FK_pi_id
+END
+IF (OBJECT_ID('x_policy_item_group_perm_FK_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_group_perm] DROP CONSTRAINT x_policy_item_group_perm_FK_group_id
+END
+IF (OBJECT_ID('x_tag_def_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_def] DROP CONSTRAINT x_tag_def_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_def_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_def] DROP CONSTRAINT x_tag_def_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag] DROP CONSTRAINT x_tag_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag] DROP CONSTRAINT x_tag_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_FK_type') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag] DROP CONSTRAINT x_tag_FK_type
+END
+IF (OBJECT_ID('x_service_res_FK_service_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource] DROP CONSTRAINT x_service_res_FK_service_id
+END
+IF (OBJECT_ID('x_service_res_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource] DROP CONSTRAINT x_service_res_FK_added_by_id
+END
+IF (OBJECT_ID('x_service_res_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource] DROP CONSTRAINT x_service_res_FK_upd_by_id
+END
+IF (OBJECT_ID('x_srvc_res_el_FK_res_def_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element] DROP CONSTRAINT x_srvc_res_el_FK_res_def_id
+END
+IF (OBJECT_ID('x_srvc_res_el_FK_res_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element] DROP CONSTRAINT x_srvc_res_el_FK_res_id
+END
+IF (OBJECT_ID('x_srvc_res_el_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element] DROP CONSTRAINT x_srvc_res_el_FK_added_by_id
+END
+IF (OBJECT_ID('x_srvc_res_el_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element] DROP CONSTRAINT x_srvc_res_el_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_attr_def_FK_tag_def_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr_def] DROP CONSTRAINT x_tag_attr_def_FK_tag_def_id
+END
+IF (OBJECT_ID('x_tag_attr_def_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr_def] DROP CONSTRAINT x_tag_attr_def_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_attr_def_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr_def] DROP CONSTRAINT x_tag_attr_def_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_attr_FK_tag_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr] DROP CONSTRAINT x_tag_attr_FK_tag_id
+END
+IF (OBJECT_ID('x_tag_attr_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr] DROP CONSTRAINT x_tag_attr_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_attr_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr] DROP CONSTRAINT x_tag_attr_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_res_map_FK_tag_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_resource_map] DROP CONSTRAINT x_tag_res_map_FK_tag_id
+END
+IF (OBJECT_ID('x_tag_attr_FK_tag_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_resource_map] DROP CONSTRAINT x_tag_res_map_FK_res_id
+END
+IF (OBJECT_ID('x_tag_res_map_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_resource_map] DROP CONSTRAINT x_tag_res_map_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_res_map_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_resource_map] DROP CONSTRAINT x_tag_res_map_FK_upd_by_id
+END
+IF (OBJECT_ID('x_srvc_res_el_val_FK_res_el_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element_val] DROP CONSTRAINT x_srvc_res_el_val_FK_res_el_id
+END
+IF (OBJECT_ID('x_srvc_res_el_val_FK_add_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element_val] DROP CONSTRAINT x_srvc_res_el_val_FK_add_by_id
+END
+IF (OBJECT_ID('x_srvc_res_el_val_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element_val] DROP CONSTRAINT x_srvc_res_el_val_FK_upd_by_id
+END
+IF (OBJECT_ID('x_datamask_type_def_FK_def_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_datamask_type_def] DROP CONSTRAINT x_datamask_type_def_FK_def_id
+END
+IF (OBJECT_ID('x_datamask_type_def_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_datamask_type_def] DROP CONSTRAINT x_datamask_type_def_FK_added_by_id
+END
+IF (OBJECT_ID('x_datamask_type_def_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_datamask_type_def] DROP CONSTRAINT x_datamask_type_def_FK_upd_by_id
+END
+IF (OBJECT_ID('x_policy_item_datamask_FK_policy_item_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_datamask] DROP CONSTRAINT x_policy_item_datamask_FK_policy_item_id
+END
+IF (OBJECT_ID('x_policy_item_datamask_FK_type') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_datamask] DROP CONSTRAINT x_policy_item_datamask_FK_type
+END
+IF (OBJECT_ID('x_policy_item_datamask_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_datamask] DROP CONSTRAINT x_policy_item_datamask_FK_added_by_id
+END
+IF (OBJECT_ID('x_policy_item_datamask_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_datamask] DROP CONSTRAINT x_policy_item_datamask_FK_upd_by_id
+END
+IF (OBJECT_ID('x_policy_item_rowfilter_FK_policy_item_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_rowfilter] DROP CONSTRAINT x_policy_item_rowfilter_FK_policy_item_id
+END
+IF (OBJECT_ID('x_policy_item_rowfilter_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_rowfilter] DROP CONSTRAINT x_policy_item_rowfilter_FK_added_by_id
+END
+IF (OBJECT_ID('x_policy_item_rowfilter_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_rowfilter] DROP CONSTRAINT x_policy_item_rowfilter_FK_upd_by_id
+END
+IF (OBJECT_ID('x_service_version_info_service_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_version_info] DROP CONSTRAINT x_service_version_info_service_id
+END
+IF (OBJECT_ID('x_plugin_info_UK') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_plugin_info] DROP CONSTRAINT x_plugin_info_UK
+END
+IF (OBJECT_ID('vx_trx_log') IS NOT NULL)
+BEGIN
+ DROP VIEW [dbo].[vx_trx_log]
+END
+IF (OBJECT_ID('x_plugin_info') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_plugin_info]
+END
+IF (OBJECT_ID('x_service_version_info') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_version_info]
+END
+IF (OBJECT_ID('x_policy_item_rowfilter') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_rowfilter]
+END
+IF (OBJECT_ID('x_policy_item_datamask') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_datamask]
+END
+IF (OBJECT_ID('x_datamask_type_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_datamask_type_def]
+END
+IF (OBJECT_ID('x_service_resource_element_val') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_resource_element_val]
+END
+IF (OBJECT_ID('x_tag_resource_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag_resource_map]
+END
+IF (OBJECT_ID('x_tag_attr') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag_attr]
+END
+IF (OBJECT_ID('x_tag_attr_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag_attr_def]
+END
+IF (OBJECT_ID('x_service_resource_element') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_resource_element]
+END
+IF (OBJECT_ID('x_service_resource') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_resource]
+END
+IF (OBJECT_ID('x_tag') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag]
+END
+IF (OBJECT_ID('x_tag_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag_def]
+END
+IF (OBJECT_ID('x_group_module_perm') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_group_module_perm]
+END
+IF (OBJECT_ID('x_user_module_perm') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_user_module_perm]
+END
+IF (OBJECT_ID('x_modules_master') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_modules_master]
+END
+IF (OBJECT_ID('x_data_hist') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_data_hist]
+END
+IF (OBJECT_ID('x_policy_item_group_perm') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_group_perm]
+END
+IF (OBJECT_ID('x_policy_item_user_perm') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_user_perm]
+END
+IF (OBJECT_ID('x_policy_item_condition') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_condition]
+END
+IF (OBJECT_ID('x_policy_item_access') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_access]
+END
+IF (OBJECT_ID('x_policy_item') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item]
+END
+IF (OBJECT_ID('x_policy_resource_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_resource_map]
+END
+IF (OBJECT_ID('x_policy_resource') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_resource]
+END
+IF (OBJECT_ID('x_service_config_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_config_map]
+END
+IF (OBJECT_ID('x_enum_element_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_enum_element_def]
+END
+IF (OBJECT_ID('x_enum_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_enum_def]
+END
+IF (OBJECT_ID('x_context_enricher_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_context_enricher_def]
+END
+IF (OBJECT_ID('x_policy_condition_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_condition_def]
+END
+IF (OBJECT_ID('x_access_type_def_grants') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_access_type_def_grants]
+END
+IF (OBJECT_ID('x_access_type_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_access_type_def]
+END
+IF (OBJECT_ID('x_resource_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_resource_def]
+END
+IF (OBJECT_ID('x_service_config_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_config_def]
+END
+IF (OBJECT_ID('x_policy') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy]
+END
+IF (OBJECT_ID('x_service') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service]
+END
+IF (OBJECT_ID('x_service_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_def]
+END
+IF (OBJECT_ID('x_audit_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_audit_map]
+END
+IF (OBJECT_ID('x_perm_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_perm_map]
+END
+IF (OBJECT_ID('x_trx_log') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_trx_log]
+END
+IF (OBJECT_ID('x_resource') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_resource]
+END
+IF (OBJECT_ID('x_policy_export_audit') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_export_audit]
+END
+IF (OBJECT_ID('x_group_users') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_group_users]
+END
+IF (OBJECT_ID('x_user') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_user]
+END
+IF (OBJECT_ID('x_group_groups') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_group_groups]
+END
+IF (OBJECT_ID('x_group') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_group]
+END
+IF (OBJECT_ID('x_db_base') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_db_base]
+END
+IF (OBJECT_ID('x_cred_store') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_cred_store]
+END
+IF (OBJECT_ID('x_auth_sess') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_auth_sess]
+END
+IF (OBJECT_ID('x_asset') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_asset]
+END
+IF (OBJECT_ID('xa_access_audit') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[xa_access_audit]
+END
+IF (OBJECT_ID('x_portal_user_role') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_portal_user_role]
+END
+IF (OBJECT_ID('x_portal_user') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_portal_user]
+END
+IF (OBJECT_ID('x_db_version_h') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_db_version_h]
+END
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_db_version_h](
+ [id] [bigint] identity(1,1) NOT NULL,
+ [version] [varchar](64) NOT NULL,
+ [inst_at] [datetime2] NOT NULL,
+ [inst_by] [varchar](256) NOT NULL,
+ [updated_at] [datetime2] NOT NULL,
+ [updated_by] [varchar](256) NOT NULL,
+ [active] [varchar](1) check(active IN ('Y', 'N')) DEFAULT 'Y',
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_portal_user](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [first_name] [varchar](256) DEFAULT NULL NULL,
+ [last_name] [varchar](256) DEFAULT NULL NULL,
+ [pub_scr_name] [varchar](2048) DEFAULT NULL NULL,
+ [login_id] [varchar](767) DEFAULT NULL NULL,
+ [password] [varchar](512) NOT NULL,
+ [email] [varchar](512) DEFAULT NULL NULL,
+ [status] [int] DEFAULT 0 NOT NULL,
+ [user_src] [int] DEFAULT 0 NOT NULL,
+ [notes] [varchar](4000) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+ CONSTRAINT [x_portal_user$x_portal_user_UK_login_id] UNIQUE NONCLUSTERED
+(
+ [login_id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_portal_user_role](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [user_id] [bigint] NOT NULL,
+ [user_role] [varchar](128) DEFAULT NULL NULL,
+ [status] [int] DEFAULT 0 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[xa_access_audit](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [audit_type] [int] DEFAULT 0 NOT NULL,
+ [access_result] [int] DEFAULT 0 NULL,
+ [access_type] [varchar](255) DEFAULT NULL NULL,
+ [acl_enforcer] [varchar](255) DEFAULT NULL NULL,
+ [agent_id] [varchar](255) DEFAULT NULL NULL,
+ [client_ip] [varchar](255) DEFAULT NULL NULL,
+ [client_type] [varchar](255) DEFAULT NULL NULL,
+ [policy_id] [bigint] DEFAULT 0 NULL,
+ [repo_name] [varchar](255) DEFAULT NULL NULL,
+ [repo_type] [int] DEFAULT 0 NULL,
+ [result_reason] [varchar](255) DEFAULT NULL NULL,
+ [session_id] [varchar](255) DEFAULT NULL NULL,
+ [event_time] [datetime2] DEFAULT NULL NULL,
+ [request_user] [varchar](255) DEFAULT NULL NULL,
+ [action] [varchar](2000) DEFAULT NULL NULL,
+ [request_data] [varchar](4000) DEFAULT NULL NULL,
+ [resource_path] [varchar](4000) DEFAULT NULL NULL,
+ [resource_type] [varchar](255) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_PADDING OFF
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_asset](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [asset_name] [varchar](1024) NOT NULL,
+ [descr] [varchar](4000) NOT NULL,
+ [act_status] [int] DEFAULT 0 NOT NULL,
+ [asset_type] [int] DEFAULT 0 NOT NULL,
+ [config] [nvarchar](max) NULL,
+ [sup_native] [tinyint] DEFAULT 0 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_auth_sess](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [login_id] [varchar](767) NOT NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [ext_sess_id] [varchar](512) DEFAULT NULL NULL,
+ [auth_time] [datetime2] NOT NULL,
+ [auth_status] [int] DEFAULT 0 NOT NULL,
+ [auth_type] [int] DEFAULT 0 NOT NULL,
+ [auth_provider] [int] DEFAULT 0 NOT NULL,
+ [device_type] [int] DEFAULT 0 NOT NULL,
+ [req_ip] [varchar](48) NOT NULL,
+ [req_ua] [varchar](1024) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_cred_store](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [store_name] [varchar](1024) NOT NULL,
+ [descr] [varchar](4000) NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+CREATE TABLE [dbo].[x_db_base](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_group](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [group_name] [varchar](1024) NOT NULL,
+ [descr] [varchar](4000) NOT NULL,
+ [status] [int] DEFAULT 0 NOT NULL,
+ [group_type] [int] DEFAULT 0 NOT NULL,
+ [cred_store_id] [bigint] DEFAULT NULL NULL,
+ [group_src] [int] DEFAULT 0 NOT NULL,
+ [is_visible] [int] DEFAULT 1 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_group_groups](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [group_name] [varchar](1024) NOT NULL,
+ [p_group_id] [bigint] DEFAULT NULL NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_user](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [user_name] [varchar](767) NOT NULL,
+ [descr] [varchar](4000) NOT NULL,
+ [status] [int] DEFAULT 0 NOT NULL,
+ [cred_store_id] [bigint] DEFAULT NULL NULL,
+ [is_visible] [int] DEFAULT 1 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+ CONSTRAINT [x_user$x_user_UK_user_name] UNIQUE NONCLUSTERED
+(
+ [user_name] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_group_users](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [group_name] [varchar](1024) NOT NULL,
+ [p_group_id] [bigint] DEFAULT NULL NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_export_audit](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [client_ip] [varchar](255) NOT NULL,
+ [agent_id] [varchar](255) DEFAULT NULL NULL,
+ [req_epoch] [bigint] NOT NULL,
+ [last_updated] [datetime2] DEFAULT NULL NULL,
+ [repository_name] [varchar](1024) DEFAULT NULL NULL,
+ [exported_json] [nvarchar](max) DEFAULT NULL NULL,
+ [http_ret_code] [int] DEFAULT 0 NOT NULL,
+ [cluster_name] [varchar](255) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_resource](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [res_name] [varchar](4000) DEFAULT NULL NULL,
+ [descr] [varchar](4000) DEFAULT NULL NULL,
+ [res_type] [int] DEFAULT 0 NOT NULL,
+ [asset_id] [bigint] NOT NULL,
+ [parent_id] [bigint] DEFAULT NULL NULL,
+ [parent_path] [varchar](4000) DEFAULT NULL NULL,
+ [is_encrypt] [int] DEFAULT 0 NOT NULL,
+ [is_recursive] [int] DEFAULT 0 NOT NULL,
+ [res_group] [varchar](1024) DEFAULT NULL NULL,
+ [res_dbs] [nvarchar](max) NULL,
+ [res_tables] [nvarchar](max) NULL,
+ [res_col_fams] [nvarchar](max) NULL,
+ [res_cols] [nvarchar](max) NULL,
+ [res_udfs] [nvarchar](max) NULL,
+ [res_status] [int] DEFAULT 1 NOT NULL,
+ [table_type] [int] DEFAULT 0 NOT NULL,
+ [col_type] [int] DEFAULT 0 NOT NULL,
+ [policy_name] [varchar](500) DEFAULT NULL NULL,
+ [res_topologies] [nvarchar](max) DEFAULT NULL NULL,
+ [res_services] [nvarchar](max) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_resource$x_resource_UK_policy_name] UNIQUE NONCLUSTERED
+(
+ [policy_name] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_trx_log](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [class_type] [int] DEFAULT 0 NOT NULL,
+ [object_id] [bigint] DEFAULT NULL NULL,
+ [parent_object_id] [bigint] DEFAULT NULL NULL,
+ [parent_object_class_type] [int] DEFAULT 0 NOT NULL,
+ [parent_object_name] [varchar](1024)DEFAULT NULL NULL,
+ [object_name] [varchar](1024) DEFAULT NULL NULL,
+ [attr_name] [varchar](255) DEFAULT NULL NULL,
+ [prev_val] [nvarchar](max) DEFAULT NULL NULL,
+ [new_val] [nvarchar](max)DEFAULT NULL NULL,
+ [trx_id] [varchar](1024)DEFAULT NULL NULL,
+ [action] [varchar](255) DEFAULT NULL NULL,
+ [sess_id] [varchar](512) DEFAULT NULL NULL,
+ [req_id] [varchar](30) DEFAULT NULL NULL,
+ [sess_type] [varchar](30) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_perm_map](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [perm_group] [varchar](1024) DEFAULT NULL NULL,
+ [res_id] [bigint] DEFAULT NULL NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [perm_for] [int] DEFAULT 0 NOT NULL,
+ [perm_type] [int] DEFAULT 0 NOT NULL,
+ [is_recursive] [int] DEFAULT 0 NOT NULL,
+ [is_wild_card] [tinyint] DEFAULT 1 NOT NULL,
+ [grant_revoke] [tinyint] DEFAULT 1 NOT NULL,
+ [ip_address] [nvarchar](max) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_audit_map](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [res_id] [bigint] DEFAULT NULL NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [audit_type] [int] DEFAULT 0 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [impl_class_name] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 1 NULL,
+ [def_options] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [type] [bigint] DEFAULT NULL NULL,
+ [name] [varchar](255) DEFAULT NULL NULL,
+ [policy_version] [bigint] DEFAULT NULL NULL,
+ [policy_update_time] [datetime2] DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 0 NOT NULL,
+ [tag_service] [bigint] DEFAULT NULL NULL,
+ [tag_version] [bigint] DEFAULT 0 NOT NULL,
+ [tag_update_time] [datetime2] DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_service$x_service_name] UNIQUE NONCLUSTERED
+(
+ [name] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [service] [bigint] DEFAULT NULL NULL,
+ [name] [varchar](512) DEFAULT NULL NULL,
+ [policy_type] [int] DEFAULT 0 NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [resource_signature] [varchar](128) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 0 NOT NULL,
+ [is_audit_enabled] [tinyint] DEFAULT 0 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_config_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [type] [varchar](1024) DEFAULT NULL NULL,
+ [sub_type] [varchar](1024) DEFAULT NULL NULL,
+ [is_mandatory] [tinyint] DEFAULT 0 NOT NULL,
+ [default_value] [varchar](1024) DEFAULT NULL NULL,
+ [validation_reg_ex] [varchar](1024) DEFAULT NULL NULL,
+ [validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [ui_hint] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_resource_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [type] [varchar](1024) DEFAULT NULL NULL,
+ [res_level] [bigint] DEFAULT NULL NULL,
+ [parent] [bigint] DEFAULT NULL NULL,
+ [mandatory] [tinyint] DEFAULT 0 NOT NULL,
+ [look_up_supported] [tinyint] DEFAULT 0 NOT NULL,
+ [recursive_supported] [tinyint] DEFAULT 0 NOT NULL,
+ [excludes_supported] [tinyint] DEFAULT 0 NOT NULL,
+ [matcher] [varchar](1024) DEFAULT NULL NULL,
+ [matcher_options] [varchar](1024) DEFAULT NULL NULL,
+ [validation_reg_ex] [varchar](1024) DEFAULT NULL NULL,
+ [validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [ui_hint] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ [datamask_options] [varchar](1024) DEFAULT NULL NULL,
+ [rowfilter_options] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_access_type_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ [datamask_options] [varchar](1024) DEFAULT NULL NULL,
+ [rowfilter_options] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_access_type_def_grants](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [atd_id] [bigint] NOT NULL,
+ [implied_grant] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_condition_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [evaluator] [varchar](1024) DEFAULT NULL NULL,
+ [evaluator_options] [varchar](1024) DEFAULT NULL NULL,
+ [validation_reg_ex] [varchar](1024) DEFAULT NULL NULL,
+ [validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [ui_hint] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+CREATE TABLE [dbo].[x_context_enricher_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint]NOT NULL,
+ [item_id] [bigint]NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [enricher] [varchar](1024) DEFAULT NULL NULL,
+ [enricher_options] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_enum_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [default_index] [bigint] DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_enum_element_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [enum_def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_config_map] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [service] [bigint] NOT NULL,
+ [config_key] [varchar](1024) DEFAULT NULL NULL,
+ [config_value] [varchar](4000) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_resource] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_id] [bigint] NOT NULL,
+ [res_def_id] [bigint] NOT NULL,
+ [is_excludes] [tinyint] DEFAULT 0 NOT NULL,
+ [is_recursive] [tinyint] DEFAULT 0 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_resource_map] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [resource_id] [bigint] NOT NULL,
+ [value] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_id] [bigint] NOT NULL,
+ [delegate_admin] [tinyint] DEFAULT 0 NOT NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ [item_type] [int] DEFAULT 0 NOT NULL,
+ [is_enabled] [tinyint] DEFAULT 1 NOT NULL,
+ [comments] [varchar](255) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item_access] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [type] [bigint] NOT NULL,
+ [is_allowed] [tinyint] DEFAULT 0 NOT NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item_condition] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [type] [bigint] NOT NULL,
+ [value] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item_user_perm] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item_group_perm] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_data_hist] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [obj_guid] [varchar](1024) NOT NULL,
+ [obj_class_type] [int] NOT NULL,
+ [obj_id] [bigint] NOT NULL,
+ [obj_name] [varchar](1024) NOT NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [action] [varchar](512) NOT NULL,
+ [from_time] [datetime2] NOT NULL,
+ [to_time] [datetime2] DEFAULT NULL NULL,
+ [content] [nvarchar](max) NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_modules_master] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [module] [varchar](1024)NOT NULL,
+ [url] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_user_module_perm] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [module_id] [bigint] DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [is_allowed] [int] DEFAULT 1 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_group_module_perm] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+ [module_id] [bigint] DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [is_allowed] [int] DEFAULT 1 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [name] [varchar](255) NOT NULL,
+ [source] [varchar](128) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 0 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_tag_def$x_tag_def_UK_guid] UNIQUE NONCLUSTERED
+(
+ [guid] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_tag_def$x_tag_def_UK_name] UNIQUE NONCLUSTERED
+(
+ [name] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [type] [bigint] NOT NULL,
+ [owned_by] [smallint] DEFAULT 0 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_tag$x_tag_UK_guid] UNIQUE NONCLUSTERED
+(
+ [guid] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_resource](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [service_id] [bigint] NOT NULL,
+ [resource_signature] [varchar](128) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 1 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_service_resource$x_service_res_UK_guid] UNIQUE NONCLUSTERED
+(
+ [guid] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_resource_element](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [res_id] [bigint] NOT NULL,
+ [res_def_id] [bigint] NOT NULL,
+ [is_excludes] [tinyint] DEFAULT 0 NOT NULL,
+ [is_recursive] [tinyint] DEFAULT 0 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag_attr_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [tag_def_id] [bigint] NOT NULL,
+ [name] [varchar](255) NOT NULL,
+ [type] [varchar](50) NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag_attr](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [tag_id] [bigint] NOT NULL,
+ [name] [varchar](255) NOT NULL,
+ [value] [varchar](512) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag_resource_map](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [tag_id] [bigint] NOT NULL,
+ [res_id] [bigint] NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_tag_resource_map$x_tag_resource_map_UK_guid] UNIQUE NONCLUSTERED
+(
+ [guid] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_resource_element_val](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [res_element_id] [bigint] NOT NULL,
+ [value] [varchar](1024) NOT NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_datamask_type_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) NOT NULL,
+ [label] [varchar](1024) NOT NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [transformer] [varchar](1024) DEFAULT NULL NULL,
+ [datamask_options] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+CREATE TABLE [dbo].[x_policy_item_datamask](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [type] [bigint] NOT NULL,
+ [condition_expr] [varchar](1024) DEFAULT NULL NULL,
+ [value_expr] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+CREATE TABLE [dbo].[x_policy_item_rowfilter](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [filter_expr] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_version_info](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [service_id] [bigint] NOT NULL,
+ [policy_version] [bigint] NOT NULL DEFAULT 0,
+ [policy_update_time] [datetime2] DEFAULT NULL NULL,
+ [tag_version] [bigint] NOT NULL DEFAULT 0,
+ [tag_update_time] [datetime2] DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_plugin_info](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL 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 CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_plugin_info$x_plugin_info_UK] UNIQUE NONCLUSTERED
+(
+ [service_name] ASC, [host_name] ASC, [app_type] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+
+ALTER TABLE [dbo].[x_asset] WITH CHECK ADD CONSTRAINT [x_asset_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_asset] CHECK CONSTRAINT [x_asset_FK_added_by_id]
+ALTER TABLE [dbo].[x_asset] WITH CHECK ADD CONSTRAINT [x_asset_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_asset] CHECK CONSTRAINT [x_asset_FK_upd_by_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_added_by_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_group_id] FOREIGN KEY([group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_group_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_res_id] FOREIGN KEY([res_id])
+REFERENCES [dbo].[x_resource] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_res_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_upd_by_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_user] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_user_id]
+ALTER TABLE [dbo].[x_auth_sess] WITH CHECK ADD CONSTRAINT [x_auth_sess_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_auth_sess] CHECK CONSTRAINT [x_auth_sess_FK_added_by_id]
+ALTER TABLE [dbo].[x_auth_sess] WITH CHECK ADD CONSTRAINT [x_auth_sess_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_auth_sess] CHECK CONSTRAINT [x_auth_sess_FK_upd_by_id]
+ALTER TABLE [dbo].[x_auth_sess] WITH CHECK ADD CONSTRAINT [x_auth_sess_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_auth_sess] CHECK CONSTRAINT [x_auth_sess_FK_user_id]
+ALTER TABLE [dbo].[x_cred_store] WITH CHECK ADD CONSTRAINT [x_cred_store_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_cred_store] CHECK CONSTRAINT [x_cred_store_FK_added_by_id]
+ALTER TABLE [dbo].[x_cred_store] WITH CHECK ADD CONSTRAINT [x_cred_store_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_cred_store] CHECK CONSTRAINT [x_cred_store_FK_upd_by_id]
+ALTER TABLE [dbo].[x_db_base] WITH CHECK ADD CONSTRAINT [x_db_base_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_db_base] CHECK CONSTRAINT [x_db_base_FK_added_by_id]
+ALTER TABLE [dbo].[x_db_base] WITH CHECK ADD CONSTRAINT [x_db_base_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_db_base] CHECK CONSTRAINT [x_db_base_FK_upd_by_id]
+ALTER TABLE [dbo].[x_group] WITH CHECK ADD CONSTRAINT [x_group_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group] CHECK CONSTRAINT [x_group_FK_added_by_id]
+ALTER TABLE [dbo].[x_group] WITH CHECK ADD CONSTRAINT [x_group_FK_cred_store_id] FOREIGN KEY([cred_store_id])
+REFERENCES [dbo].[x_cred_store] ([id])
+ALTER TABLE [dbo].[x_group] CHECK CONSTRAINT [x_group_FK_cred_store_id]
+ALTER TABLE [dbo].[x_group] WITH CHECK ADD CONSTRAINT [x_group_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group] CHECK CONSTRAINT [x_group_FK_upd_by_id]
+ALTER TABLE [dbo].[x_group_groups] WITH CHECK ADD CONSTRAINT [x_group_groups_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group_groups] CHECK CONSTRAINT [x_group_groups_FK_added_by_id]
+ALTER TABLE [dbo].[x_group_groups] WITH CHECK ADD CONSTRAINT [x_group_groups_FK_group_id] FOREIGN KEY([group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_group_groups] CHECK CONSTRAINT [x_group_groups_FK_group_id]
+ALTER TABLE [dbo].[x_group_groups] WITH CHECK ADD CONSTRAINT [x_group_groups_FK_p_group_id] FOREIGN KEY([p_group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_group_groups] CHECK CONSTRAINT [x_group_groups_FK_p_group_id]
+ALTER TABLE [dbo].[x_group_users] WITH CHECK ADD CONSTRAINT [x_group_users_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group_users] CHECK CONSTRAINT [x_group_users_FK_added_by_id]
+ALTER TABLE [dbo].[x_group_users] WITH CHECK ADD CONSTRAINT [x_group_users_FK_p_group_id] FOREIGN KEY([p_group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_group_users] CHECK CONSTRAINT [x_group_users_FK_p_group_id]
+ALTER TABLE [dbo].[x_group_users] WITH CHECK ADD CONSTRAINT [x_group_users_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group_users] CHECK CONSTRAINT [x_group_users_FK_upd_by_id]
+ALTER TABLE [dbo].[x_group_users] WITH CHECK ADD CONSTRAINT [x_group_users_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_user] ([id])
+ALTER TABLE [dbo].[x_group_users] CHECK CONSTRAINT [x_group_users_FK_user_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_added_by_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_group_id] FOREIGN KEY([group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_group_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_res_id] FOREIGN KEY([res_id])
+REFERENCES [dbo].[x_resource] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_res_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_upd_by_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_user] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_user_id]
+ALTER TABLE [dbo].[x_policy_export_audit] WITH CHECK ADD CONSTRAINT [x_policy_export_audit_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_policy_export_audit] CHECK CONSTRAINT [x_policy_export_audit_FK_added_by_id]
+ALTER TABLE [dbo].[x_policy_export_audit] WITH CHECK ADD CONSTRAINT [x_policy_export_audit_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_policy_export_audit] CHECK CONSTRAINT [x_policy_export_audit_FK_upd_by_id]
+ALTER TABLE [dbo].[x_portal_user] WITH CHECK ADD CONSTRAINT [x_portal_user_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user] CHECK CONSTRAINT [x_portal_user_FK_added_by_id]
+ALTER TABLE [dbo].[x_portal_user] WITH CHECK ADD CONSTRAINT [x_portal_user_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user] CHECK CONSTRAINT [x_portal_user_FK_upd_by_id]
+ALTER TABLE [dbo].[x_portal_user_role] WITH CHECK ADD CONSTRAINT [x_portal_user_role_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user_role] CHECK CONSTRAINT [x_portal_user_role_FK_added_by_id]
+ALTER TABLE [dbo].[x_portal_user_role] WITH CHECK ADD CONSTRAINT [x_portal_user_role_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user_role] CHECK CONSTRAINT [x_portal_user_role_FK_upd_by_id]
+ALTER TABLE [dbo].[x_portal_user_role] WITH CHECK ADD CONSTRAINT [x_portal_user_role_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user_role] CHECK CONSTRAINT [x_portal_user_role_FK_user_id]
+ALTER TABLE [dbo].[x_resource] WITH CHECK ADD CONSTRAINT [x_resource_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_resource] CHECK CONSTRAINT [x_resource_FK_added_by_id]
+ALTER TABLE [dbo].[x_resource] WITH CHECK ADD CONSTRAINT [x_resource_FK_asset_id] FOREIGN KEY([asset_id])
+REFERENCES [dbo].[x_asset] ([id])
+ALTER TABLE [dbo].[x_resource] CHECK CONSTRAINT [x_resource_FK_asset_id]
+ALTER TABLE [dbo].[x_resource] WITH CHECK ADD CONSTRAINT [x_resource_FK_parent_id] FOREIGN KEY([parent_id])
+REFERENCES [dbo].[x_resource] ([id])
+ALTER TABLE [dbo].[x_resource] CHECK CONSTRAINT [x_resource_FK_parent_id]
+ALTER TABLE [dbo].[x_resource] WITH CHECK ADD CONSTRAINT [x_resource_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_resource] CHECK CONSTRAINT [x_resource_FK_upd_by_id]
+ALTER TABLE [dbo].[x_trx_log] WITH CHECK ADD CONSTRAINT [x_trx_log_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_trx_log] CHECK CONSTRAINT [x_trx_log_FK_added_by_id]
+ALTER TABLE [dbo].[x_trx_log] WITH CHECK ADD CONSTRAINT [x_trx_log_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_trx_log] CHECK CONSTRAINT [x_trx_log_FK_upd_by_id]
+ALTER TABLE [dbo].[x_user] WITH CHECK ADD CONSTRAINT [x_user_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_user] CHECK CONSTRAINT [x_user_FK_added_by_id]
+ALTER TABLE [dbo].[x_user] WITH CHECK ADD CONSTRAINT [x_user_FK_cred_store_id] FOREIGN KEY([cred_store_id])
+REFERENCES [dbo].[x_cred_store] ([id])
+ALTER TABLE [dbo].[x_user] CHECK CONSTRAINT [x_user_FK_cred_store_id]
+ALTER TABLE [dbo].[x_user] WITH CHECK ADD CONSTRAINT [x_user_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_user] CHECK CONSTRAINT [x_user_FK_upd_by_id]
+ALTER TABLE [dbo].[x_user_module_perm] WITH CHECK ADD CONSTRAINT [x_user_module_perm_FK_moduleid] FOREIGN KEY([module_id])
+REFERENCES [dbo].[x_modules_master] ([id])
+ALTER TABLE [dbo].[x_user_module_perm] WITH CHECK ADD CONSTRAINT [x_user_module_perm_FK_userid] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group_module_perm] WITH CHECK ADD CONSTRAINT [x_grp_module_perm_FK_module_id] FOREIGN KEY([module_id])
+REFERENCES [dbo].[x_modules_master] ([id])
+ALTER TABLE [dbo].[x_group_module_perm] WITH CHECK ADD CONSTRAINT [x_grp_module_perm_FK_group_id] FOREIGN KEY([group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_service_def] WITH CHECK ADD CONSTRAINT [x_service_def_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service_def] CHECK CONSTRAINT [x_service_def_FK_added_by_id]
+ALTER TABLE [dbo].[x_service_def] WITH CHECK ADD CONSTRAINT [x_service_def_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service_def] CHECK CONSTRAINT [x_service_def_FK_upd_by_id]
+ALTER TABLE [dbo].[x_service] WITH CHECK ADD CONSTRAINT [x_service_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service] CHECK CONSTRAINT [x_service_FK_added_by_id]
+ALTER TABLE [dbo].[x_service] WITH CHECK ADD CONSTRAINT [x_service_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service] CHECK CONSTRAINT [x_service_FK_upd_by_id]
+ALTER TABLE [dbo].[x_service] WITH CHECK ADD CONSTRAINT [x_service_FK_type] FOREIGN KEY([type])
+REFERENCES [dbo].[x_service_def] ([id])
+ALTER TABLE [dbo].[x_service] CHECK CONSTRAINT [x_service_FK_type]
+ALTER TABLE [dbo].[x_service] WITH CHECK ADD CONSTRAINT [x_service_FK_tag_service] FOREIGN KEY([tag_service])
+REFERENCES [dbo].[x_service] ([id])
+ALTER TABLE [dbo].[x_policy] WITH CHECK ADD CONSTRAINT [x_policy_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_policy] CHECK CONSTRAINT [x_policy_FK_added_by_id]
+ALTER TABLE [dbo].[x_policy] WITH CHECK ADD CONSTRAINT [x_policy_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_policy] CHECK CONSTRAINT [x_policy_FK_upd_by_id]
+ALTER TABLE [dbo].[x_policy] WITH CHECK ADD CONSTRAINT [x_policy_FK_service] FOREIGN KEY([service])
+REFERENCES [dbo].[x_service] ([id])
+ALTER TABLE [dbo].[x_policy] CHECK CONSTRAINT [x_policy_FK_service]
+ALTER TABLE [dbo].[x_service_config_def] WITH CHECK ADD CONSTRAINT [x_service_config_def_FK_defid] FOREIGN KEY([def_id])
+REFERENCES [dbo].[x_service_def] ([id])
+ALTER TABLE [dbo].[x_service_config_def] CHECK CONSTRAINT [x_service_config_def_FK_defid]
+ALTER TABLE [dbo].[x_service_config_def] WITH CHECK ADD CONSTRAINT [x_service_conf_def_FK_added_by] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service_config_def] CHECK CONSTRAINT [x_service_conf_def_FK_added_by]
+ALTER TABLE [dbo].[x_service_config_def] WITH CHECK ADD CONSTRAINT [x_service_conf_def_FK_upd_by] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service_config_def] CHECK CONSTRAINT [x_service_conf_def_FK_upd_by]
+ALTER TABLE [dbo].[x_resource_def] WITH CHECK ADD CONSTRAINT [x_resource_def_FK_parent] FOREIGN KEY([parent])
+REFERENCES [dbo].[x_resource_def] ([id])
+ALTER TABLE [dbo].[x_resource_def] CHECK CONSTRAINT [x_resource_def_FK_parent]
+ALTER TABLE [dbo].[x_resource_def] WITH CHECK ADD CONSTRAINT [x_resource_def_FK_defid] FOREIGN KEY([def_id])
+REFERENCES [dbo].[x_service_def] ([id])
+ALTER TABLE [dbo].[x_resource_def] CHECK CONSTRAINT [x_resource_def_FK_defid]
+ALTER TABLE [dbo].[x_resource_def] WITH CHECK ADD CONSTRAINT [x_resource_def_FK_added_by] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_resource_def] CHECK CONSTRAINT [x_resource_def_FK_added_by]
+ALTER TABLE [dbo].[x_resource_def] WITH CHECK ADD CONSTRAINT [x_resource_def_FK_upd_by] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_resource_def] CHECK CONSTRAINT [x_resource_def_FK_upd_by]
+ALTER TABLE [dbo].[x_access_type_def] WITH CHECK ADD CONSTRAINT [x_access_type_def_FK_defid] FOREIGN KEY([def_id])
+REFERENCES [dbo].[x_service_def] ([id])
+ALTER TABLE [dbo].[x_access_type_def] CHECK CONSTRAINT [x_access_type_def_FK_defid]
+ALTER TABLE [dbo].[x_access_type_def] WITH CHECK ADD CONSTRAINT [x_access_type_def_FK_added_by] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_access_type_def] CHECK CONSTRAINT [x_access_type_def_FK_added_by]
+ALTER TABLE [dbo].[x_access_type_def] WITH CHECK ADD CONSTRAINT [x_access_type_def_FK_upd_by] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_access_type_def] CHECK CONSTRAINT [x_access_type_def_FK_upd_by]
+ALTER TABLE [dbo].[x_access_type_def_grants] WITH CHECK ADD CONSTRAINT [x_atd_grants_FK_atdid] FOREIGN KEY([atd_id])
+REFERENCES [dbo].[x_access_type_def] ([id])
+ALTER TABLE [dbo].[x_access_type_def_grants] CHECK CONSTRAINT [x_atd_grants_FK_atdid]
+ALTER TABLE [dbo].[x_access_type_def_grants] WITH CHECK ADD CONSTRAINT [x_access_type_def_grants_FK_added_by] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_access_type_def_grants] CHECK CONSTRAINT [x_access_type_def_grants_FK_added_by]
+ALTER TABLE [dbo].[x_access_type_def_grants] WITH CHECK ADD CONSTRAINT [x_access_type_def_grants_FK_upd_by] FOREIGN KEY([upd_by_
<TRUNCATED>
[2/3] ranger git commit: RANGER-1522 : Update consolidated db schema
script for SQLServer DB flavor to reduce execution time
Posted by ga...@apache.org.
http://git-wip-us.apache.org/repos/asf/ranger/blob/c01d01f5/security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql
----------------------------------------------------------------------
diff --git a/security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql b/security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql
new file mode 100644
index 0000000..68d3a05
--- /dev/null
+++ b/security-admin/db/sqlserver/optimized/1.0.0/ranger_core_db_sqlserver.sql
@@ -0,0 +1,3008 @@
+-- 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.
+
+IF (OBJECT_ID('x_user_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_user] DROP CONSTRAINT x_user_FK_upd_by_id
+END
+IF (OBJECT_ID('x_user_FK_cred_store_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_user] DROP CONSTRAINT x_user_FK_cred_store_id
+END
+IF (OBJECT_ID('x_user_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_user] DROP CONSTRAINT x_user_FK_added_by_id
+END
+IF (OBJECT_ID('x_trx_log_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_trx_log] DROP CONSTRAINT x_trx_log_FK_upd_by_id
+END
+IF (OBJECT_ID('x_trx_log_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_trx_log] DROP CONSTRAINT x_trx_log_FK_added_by_id
+END
+IF (OBJECT_ID('x_resource_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource] DROP CONSTRAINT x_resource_FK_upd_by_id
+END
+IF (OBJECT_ID('x_resource_FK_parent_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource] DROP CONSTRAINT x_resource_FK_parent_id
+END
+IF (OBJECT_ID('x_resource_FK_asset_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource] DROP CONSTRAINT x_resource_FK_asset_id
+END
+IF (OBJECT_ID('x_resource_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource] DROP CONSTRAINT x_resource_FK_added_by_id
+END
+IF (OBJECT_ID('x_portal_user_role_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user_role] DROP CONSTRAINT x_portal_user_role_FK_user_id
+END
+IF (OBJECT_ID('x_portal_user_role_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user_role] DROP CONSTRAINT x_portal_user_role_FK_upd_by_id
+END
+IF (OBJECT_ID('x_portal_user_role_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user_role] DROP CONSTRAINT x_portal_user_role_FK_added_by_id
+END
+IF (OBJECT_ID('x_portal_user_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user] DROP CONSTRAINT x_portal_user_FK_upd_by_id
+END
+IF (OBJECT_ID('x_portal_user_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_portal_user] DROP CONSTRAINT x_portal_user_FK_added_by_id
+END
+IF (OBJECT_ID('x_policy_export_audit_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_export_audit] DROP CONSTRAINT x_policy_export_audit_FK_upd_by_id
+END
+IF (OBJECT_ID('x_policy_export_audit_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_export_audit] DROP CONSTRAINT x_policy_export_audit_FK_added_by_id
+END
+IF (OBJECT_ID('x_perm_map_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_user_id
+END
+IF (OBJECT_ID('x_user_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_upd_by_id
+END
+IF (OBJECT_ID('x_perm_map_FK_res_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_res_id
+END
+IF (OBJECT_ID('x_perm_map_FK_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_group_id
+END
+IF (OBJECT_ID('x_perm_map_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_perm_map] DROP CONSTRAINT x_perm_map_FK_added_by_id
+END
+IF (OBJECT_ID('x_group_users_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_users] DROP CONSTRAINT x_group_users_FK_user_id
+END
+IF (OBJECT_ID('x_group_users_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_users] DROP CONSTRAINT x_group_users_FK_upd_by_id
+END
+IF (OBJECT_ID('x_group_users_FK_p_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_users] DROP CONSTRAINT x_group_users_FK_p_group_id
+END
+IF (OBJECT_ID('x_group_users_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_users] DROP CONSTRAINT x_group_users_FK_added_by_id
+END
+IF (OBJECT_ID('x_group_groups_FK_p_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_groups] DROP CONSTRAINT x_group_groups_FK_p_group_id
+END
+IF (OBJECT_ID('x_group_groups_FK_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_groups] DROP CONSTRAINT x_group_groups_FK_group_id
+END
+IF (OBJECT_ID('x_group_groups_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group_groups] DROP CONSTRAINT x_group_groups_FK_added_by_id
+END
+IF (OBJECT_ID('x_group_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group] DROP CONSTRAINT x_group_FK_upd_by_id
+END
+IF (OBJECT_ID('x_group_FK_cred_store_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group] DROP CONSTRAINT x_group_FK_cred_store_id
+END
+IF (OBJECT_ID('x_group_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_group] DROP CONSTRAINT x_group_FK_added_by_id
+END
+IF (OBJECT_ID('x_db_base_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_db_base] DROP CONSTRAINT x_db_base_FK_upd_by_id
+END
+IF (OBJECT_ID('x_db_base_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_db_base] DROP CONSTRAINT x_db_base_FK_added_by_id
+END
+IF (OBJECT_ID('x_cred_store_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_cred_store] DROP CONSTRAINT x_cred_store_FK_upd_by_id
+END
+IF (OBJECT_ID('x_cred_store_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_cred_store] DROP CONSTRAINT x_cred_store_FK_added_by_id
+END
+IF (OBJECT_ID('x_auth_sess_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_auth_sess] DROP CONSTRAINT x_auth_sess_FK_user_id
+END
+IF (OBJECT_ID('x_auth_sess_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_auth_sess] DROP CONSTRAINT x_auth_sess_FK_upd_by_id
+END
+IF (OBJECT_ID('x_auth_sess_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_auth_sess] DROP CONSTRAINT x_auth_sess_FK_added_by_id
+END
+IF (OBJECT_ID('x_audit_map_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_user_id
+END
+IF (OBJECT_ID('x_audit_map_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_upd_by_id
+END
+IF (OBJECT_ID('x_audit_map_FK_res_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_res_id
+END
+IF (OBJECT_ID('x_audit_map_FK_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_group_id
+END
+IF (OBJECT_ID('x_audit_map_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_audit_map] DROP CONSTRAINT x_audit_map_FK_added_by_id
+END
+IF (OBJECT_ID('x_user_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_asset_FK_upd_by_id] DROP CONSTRAINT x_asset_FK_upd_by_id
+END
+IF (OBJECT_ID('x_asset_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_asset] DROP CONSTRAINT x_asset_FK_added_by_id
+END
+IF (OBJECT_ID('x_service_def_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_def] DROP CONSTRAINT x_service_def_FK_added_by_id
+END
+IF (OBJECT_ID('x_service_def_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_def] DROP CONSTRAINT x_service_def_FK_upd_by_id
+END
+IF (OBJECT_ID('x_service_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service] DROP CONSTRAINT x_service_FK_added_by_id
+END
+IF (OBJECT_ID('x_service_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service] DROP CONSTRAINT x_service_FK_upd_by_id
+END
+IF (OBJECT_ID('x_service_FK_type') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service] DROP CONSTRAINT x_service_FK_type
+END
+IF (OBJECT_ID('x_policy_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy] DROP CONSTRAINT x_policy_FK_added_by_id
+END
+IF (OBJECT_ID('x_policy_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy] DROP CONSTRAINT x_policy_FK_upd_by_id
+END
+IF (OBJECT_ID('x_policy_FK_service') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy] DROP CONSTRAINT x_policy_FK_service
+END
+IF (OBJECT_ID('x_service_config_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_config_def] DROP CONSTRAINT x_service_config_def_FK_defid
+END
+IF (OBJECT_ID('x_resource_def_FK_parent') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource_def] DROP CONSTRAINT x_resource_def_FK_parent
+END
+IF (OBJECT_ID('x_resource_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_resource_def] DROP CONSTRAINT x_resource_def_FK_defid
+END
+IF (OBJECT_ID('x_access_type_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_access_type_def] DROP CONSTRAINT x_access_type_def_FK_defid
+END
+IF (OBJECT_ID('x_atd_grants_FK_atdid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_access_type_def_grants] DROP CONSTRAINT x_atd_grants_FK_atdid
+END
+IF (OBJECT_ID('x_policy_condition_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_condition_def] DROP CONSTRAINT x_policy_condition_def_FK_defid
+END
+IF (OBJECT_ID('x_enum_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_enum_def] DROP CONSTRAINT x_enum_def_FK_defid
+END
+IF (OBJECT_ID('x_enum_element_def_FK_defid') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_enum_element_def] DROP CONSTRAINT x_enum_element_def_FK_defid
+END
+IF (OBJECT_ID('x_service_config_map_FK_') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_config_map] DROP CONSTRAINT x_service_config_map_FK_
+END
+IF (OBJECT_ID('x_policy_resource_FK_policy_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_resource] DROP CONSTRAINT x_policy_resource_FK_policy_id
+END
+IF (OBJECT_ID('x_policy_resource_FK_res_def_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_resource] DROP CONSTRAINT x_policy_resource_FK_res_def_id
+END
+IF (OBJECT_ID('x_policy_resource_map_FK_resource_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_resource_map] DROP CONSTRAINT x_policy_resource_map_FK_resource_id
+END
+IF (OBJECT_ID('x_policy_item_FK_policy_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item] DROP CONSTRAINT x_policy_item_FK_policy_id
+END
+IF (OBJECT_ID('x_policy_item_access_FK_pi_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_access] DROP CONSTRAINT x_policy_item_access_FK_pi_id
+END
+IF (OBJECT_ID('x_policy_item_access_FK_atd_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_access] DROP CONSTRAINT x_policy_item_access_FK_atd_id
+END
+IF (OBJECT_ID('x_policy_item_condition_FK_pi_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_condition] DROP CONSTRAINT x_policy_item_condition_FK_pi_id
+END
+IF (OBJECT_ID('x_policy_item_condition_FK_pcd_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_condition] DROP CONSTRAINT x_policy_item_condition_FK_pcd_id
+END
+IF (OBJECT_ID('x_policy_item_user_perm_FK_pi_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_user_perm] DROP CONSTRAINT x_policy_item_user_perm_FK_pi_id
+END
+IF (OBJECT_ID('x_policy_item_user_perm_FK_user_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_user_perm] DROP CONSTRAINT x_policy_item_user_perm_FK_user_id
+END
+IF (OBJECT_ID('x_policy_item_group_perm_FK_pi_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_group_perm] DROP CONSTRAINT x_policy_item_group_perm_FK_pi_id
+END
+IF (OBJECT_ID('x_policy_item_group_perm_FK_group_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_group_perm] DROP CONSTRAINT x_policy_item_group_perm_FK_group_id
+END
+IF (OBJECT_ID('x_tag_def_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_def] DROP CONSTRAINT x_tag_def_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_def_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_def] DROP CONSTRAINT x_tag_def_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag] DROP CONSTRAINT x_tag_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag] DROP CONSTRAINT x_tag_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_FK_type') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag] DROP CONSTRAINT x_tag_FK_type
+END
+IF (OBJECT_ID('x_service_res_FK_service_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource] DROP CONSTRAINT x_service_res_FK_service_id
+END
+IF (OBJECT_ID('x_service_res_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource] DROP CONSTRAINT x_service_res_FK_added_by_id
+END
+IF (OBJECT_ID('x_service_res_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource] DROP CONSTRAINT x_service_res_FK_upd_by_id
+END
+IF (OBJECT_ID('x_srvc_res_el_FK_res_def_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element] DROP CONSTRAINT x_srvc_res_el_FK_res_def_id
+END
+IF (OBJECT_ID('x_srvc_res_el_FK_res_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element] DROP CONSTRAINT x_srvc_res_el_FK_res_id
+END
+IF (OBJECT_ID('x_srvc_res_el_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element] DROP CONSTRAINT x_srvc_res_el_FK_added_by_id
+END
+IF (OBJECT_ID('x_srvc_res_el_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element] DROP CONSTRAINT x_srvc_res_el_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_attr_def_FK_tag_def_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr_def] DROP CONSTRAINT x_tag_attr_def_FK_tag_def_id
+END
+IF (OBJECT_ID('x_tag_attr_def_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr_def] DROP CONSTRAINT x_tag_attr_def_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_attr_def_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr_def] DROP CONSTRAINT x_tag_attr_def_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_attr_FK_tag_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr] DROP CONSTRAINT x_tag_attr_FK_tag_id
+END
+IF (OBJECT_ID('x_tag_attr_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr] DROP CONSTRAINT x_tag_attr_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_attr_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_attr] DROP CONSTRAINT x_tag_attr_FK_upd_by_id
+END
+IF (OBJECT_ID('x_tag_res_map_FK_tag_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_resource_map] DROP CONSTRAINT x_tag_res_map_FK_tag_id
+END
+IF (OBJECT_ID('x_tag_attr_FK_tag_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_resource_map] DROP CONSTRAINT x_tag_res_map_FK_res_id
+END
+IF (OBJECT_ID('x_tag_res_map_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_resource_map] DROP CONSTRAINT x_tag_res_map_FK_added_by_id
+END
+IF (OBJECT_ID('x_tag_res_map_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_tag_resource_map] DROP CONSTRAINT x_tag_res_map_FK_upd_by_id
+END
+IF (OBJECT_ID('x_srvc_res_el_val_FK_res_el_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element_val] DROP CONSTRAINT x_srvc_res_el_val_FK_res_el_id
+END
+IF (OBJECT_ID('x_srvc_res_el_val_FK_add_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element_val] DROP CONSTRAINT x_srvc_res_el_val_FK_add_by_id
+END
+IF (OBJECT_ID('x_srvc_res_el_val_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_resource_element_val] DROP CONSTRAINT x_srvc_res_el_val_FK_upd_by_id
+END
+IF (OBJECT_ID('x_datamask_type_def_FK_def_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_datamask_type_def] DROP CONSTRAINT x_datamask_type_def_FK_def_id
+END
+IF (OBJECT_ID('x_datamask_type_def_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_datamask_type_def] DROP CONSTRAINT x_datamask_type_def_FK_added_by_id
+END
+IF (OBJECT_ID('x_datamask_type_def_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_datamask_type_def] DROP CONSTRAINT x_datamask_type_def_FK_upd_by_id
+END
+IF (OBJECT_ID('x_policy_item_datamask_FK_policy_item_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_datamask] DROP CONSTRAINT x_policy_item_datamask_FK_policy_item_id
+END
+IF (OBJECT_ID('x_policy_item_datamask_FK_type') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_datamask] DROP CONSTRAINT x_policy_item_datamask_FK_type
+END
+IF (OBJECT_ID('x_policy_item_datamask_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_datamask] DROP CONSTRAINT x_policy_item_datamask_FK_added_by_id
+END
+IF (OBJECT_ID('x_policy_item_datamask_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_datamask] DROP CONSTRAINT x_policy_item_datamask_FK_upd_by_id
+END
+IF (OBJECT_ID('x_policy_item_rowfilter_FK_policy_item_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_rowfilter] DROP CONSTRAINT x_policy_item_rowfilter_FK_policy_item_id
+END
+IF (OBJECT_ID('x_policy_item_rowfilter_FK_added_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_rowfilter] DROP CONSTRAINT x_policy_item_rowfilter_FK_added_by_id
+END
+IF (OBJECT_ID('x_policy_item_rowfilter_FK_upd_by_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_policy_item_rowfilter] DROP CONSTRAINT x_policy_item_rowfilter_FK_upd_by_id
+END
+IF (OBJECT_ID('x_service_version_info_service_id') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_service_version_info] DROP CONSTRAINT x_service_version_info_service_id
+END
+IF (OBJECT_ID('x_plugin_info_UK') IS NOT NULL)
+BEGIN
+ ALTER TABLE [dbo].[x_plugin_info] DROP CONSTRAINT x_plugin_info_UK
+END
+IF (OBJECT_ID('vx_trx_log') IS NOT NULL)
+BEGIN
+ DROP VIEW [dbo].[vx_trx_log]
+END
+IF (OBJECT_ID('x_plugin_info') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_plugin_info]
+END
+IF (OBJECT_ID('x_service_version_info') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_version_info]
+END
+IF (OBJECT_ID('x_policy_item_rowfilter') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_rowfilter]
+END
+IF (OBJECT_ID('x_policy_item_datamask') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_datamask]
+END
+IF (OBJECT_ID('x_datamask_type_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_datamask_type_def]
+END
+IF (OBJECT_ID('x_service_resource_element_val') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_resource_element_val]
+END
+IF (OBJECT_ID('x_tag_resource_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag_resource_map]
+END
+IF (OBJECT_ID('x_tag_attr') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag_attr]
+END
+IF (OBJECT_ID('x_tag_attr_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag_attr_def]
+END
+IF (OBJECT_ID('x_service_resource_element') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_resource_element]
+END
+IF (OBJECT_ID('x_service_resource') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_resource]
+END
+IF (OBJECT_ID('x_tag') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag]
+END
+IF (OBJECT_ID('x_tag_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_tag_def]
+END
+IF (OBJECT_ID('x_group_module_perm') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_group_module_perm]
+END
+IF (OBJECT_ID('x_user_module_perm') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_user_module_perm]
+END
+IF (OBJECT_ID('x_modules_master') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_modules_master]
+END
+IF (OBJECT_ID('x_data_hist') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_data_hist]
+END
+IF (OBJECT_ID('x_policy_item_group_perm') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_group_perm]
+END
+IF (OBJECT_ID('x_policy_item_user_perm') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_user_perm]
+END
+IF (OBJECT_ID('x_policy_item_condition') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_condition]
+END
+IF (OBJECT_ID('x_policy_item_access') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item_access]
+END
+IF (OBJECT_ID('x_policy_item') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_item]
+END
+IF (OBJECT_ID('x_policy_resource_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_resource_map]
+END
+IF (OBJECT_ID('x_policy_resource') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_resource]
+END
+IF (OBJECT_ID('x_service_config_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_config_map]
+END
+IF (OBJECT_ID('x_enum_element_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_enum_element_def]
+END
+IF (OBJECT_ID('x_enum_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_enum_def]
+END
+IF (OBJECT_ID('x_context_enricher_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_context_enricher_def]
+END
+IF (OBJECT_ID('x_policy_condition_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_condition_def]
+END
+IF (OBJECT_ID('x_access_type_def_grants') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_access_type_def_grants]
+END
+IF (OBJECT_ID('x_access_type_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_access_type_def]
+END
+IF (OBJECT_ID('x_resource_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_resource_def]
+END
+IF (OBJECT_ID('x_service_config_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_config_def]
+END
+IF (OBJECT_ID('x_policy') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy]
+END
+IF (OBJECT_ID('x_service') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service]
+END
+IF (OBJECT_ID('x_service_def') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_service_def]
+END
+IF (OBJECT_ID('x_audit_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_audit_map]
+END
+IF (OBJECT_ID('x_perm_map') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_perm_map]
+END
+IF (OBJECT_ID('x_trx_log') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_trx_log]
+END
+IF (OBJECT_ID('x_resource') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_resource]
+END
+IF (OBJECT_ID('x_policy_export_audit') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_policy_export_audit]
+END
+IF (OBJECT_ID('x_group_users') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_group_users]
+END
+IF (OBJECT_ID('x_user') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_user]
+END
+IF (OBJECT_ID('x_group_groups') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_group_groups]
+END
+IF (OBJECT_ID('x_group') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_group]
+END
+IF (OBJECT_ID('x_db_base') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_db_base]
+END
+IF (OBJECT_ID('x_cred_store') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_cred_store]
+END
+IF (OBJECT_ID('x_auth_sess') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_auth_sess]
+END
+IF (OBJECT_ID('x_asset') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_asset]
+END
+IF (OBJECT_ID('xa_access_audit') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[xa_access_audit]
+END
+IF (OBJECT_ID('x_portal_user_role') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_portal_user_role]
+END
+IF (OBJECT_ID('x_portal_user') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_portal_user]
+END
+IF (OBJECT_ID('x_db_version_h') IS NOT NULL)
+BEGIN
+ DROP TABLE [dbo].[x_db_version_h]
+END
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_db_version_h](
+ [id] [bigint] identity(1,1) NOT NULL,
+ [version] [varchar](64) NOT NULL,
+ [inst_at] [datetime2] NOT NULL,
+ [inst_by] [varchar](256) NOT NULL,
+ [updated_at] [datetime2] NOT NULL,
+ [updated_by] [varchar](256) NOT NULL,
+ [active] [varchar](1) check(active IN ('Y', 'N')) DEFAULT 'Y',
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_portal_user](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [first_name] [varchar](256) DEFAULT NULL NULL,
+ [last_name] [varchar](256) DEFAULT NULL NULL,
+ [pub_scr_name] [varchar](2048) DEFAULT NULL NULL,
+ [login_id] [varchar](767) DEFAULT NULL NULL,
+ [password] [varchar](512) NOT NULL,
+ [email] [varchar](512) DEFAULT NULL NULL,
+ [status] [int] DEFAULT 0 NOT NULL,
+ [user_src] [int] DEFAULT 0 NOT NULL,
+ [notes] [varchar](4000) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+ CONSTRAINT [x_portal_user$x_portal_user_UK_login_id] UNIQUE NONCLUSTERED
+(
+ [login_id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_portal_user_role](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [user_id] [bigint] NOT NULL,
+ [user_role] [varchar](128) DEFAULT NULL NULL,
+ [status] [int] DEFAULT 0 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[xa_access_audit](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [audit_type] [int] DEFAULT 0 NOT NULL,
+ [access_result] [int] DEFAULT 0 NULL,
+ [access_type] [varchar](255) DEFAULT NULL NULL,
+ [acl_enforcer] [varchar](255) DEFAULT NULL NULL,
+ [agent_id] [varchar](255) DEFAULT NULL NULL,
+ [client_ip] [varchar](255) DEFAULT NULL NULL,
+ [client_type] [varchar](255) DEFAULT NULL NULL,
+ [policy_id] [bigint] DEFAULT 0 NULL,
+ [repo_name] [varchar](255) DEFAULT NULL NULL,
+ [repo_type] [int] DEFAULT 0 NULL,
+ [result_reason] [varchar](255) DEFAULT NULL NULL,
+ [session_id] [varchar](255) DEFAULT NULL NULL,
+ [event_time] [datetime2] DEFAULT NULL NULL,
+ [request_user] [varchar](255) DEFAULT NULL NULL,
+ [action] [varchar](2000) DEFAULT NULL NULL,
+ [request_data] [varchar](4000) DEFAULT NULL NULL,
+ [resource_path] [varchar](4000) DEFAULT NULL NULL,
+ [resource_type] [varchar](255) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_PADDING OFF
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_asset](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [asset_name] [varchar](1024) NOT NULL,
+ [descr] [varchar](4000) NOT NULL,
+ [act_status] [int] DEFAULT 0 NOT NULL,
+ [asset_type] [int] DEFAULT 0 NOT NULL,
+ [config] [nvarchar](max) NULL,
+ [sup_native] [tinyint] DEFAULT 0 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_auth_sess](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [login_id] [varchar](767) NOT NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [ext_sess_id] [varchar](512) DEFAULT NULL NULL,
+ [auth_time] [datetime2] NOT NULL,
+ [auth_status] [int] DEFAULT 0 NOT NULL,
+ [auth_type] [int] DEFAULT 0 NOT NULL,
+ [auth_provider] [int] DEFAULT 0 NOT NULL,
+ [device_type] [int] DEFAULT 0 NOT NULL,
+ [req_ip] [varchar](48) NOT NULL,
+ [req_ua] [varchar](1024) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_cred_store](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [store_name] [varchar](1024) NOT NULL,
+ [descr] [varchar](4000) NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+CREATE TABLE [dbo].[x_db_base](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_group](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [group_name] [varchar](1024) NOT NULL,
+ [descr] [varchar](4000) NOT NULL,
+ [status] [int] DEFAULT 0 NOT NULL,
+ [group_type] [int] DEFAULT 0 NOT NULL,
+ [cred_store_id] [bigint] DEFAULT NULL NULL,
+ [group_src] [int] DEFAULT 0 NOT NULL,
+ [is_visible] [int] DEFAULT 1 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_group_groups](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [group_name] [varchar](1024) NOT NULL,
+ [p_group_id] [bigint] DEFAULT NULL NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_user](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [user_name] [varchar](767) NOT NULL,
+ [descr] [varchar](4000) NOT NULL,
+ [status] [int] DEFAULT 0 NOT NULL,
+ [cred_store_id] [bigint] DEFAULT NULL NULL,
+ [is_visible] [int] DEFAULT 1 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+ CONSTRAINT [x_user$x_user_UK_user_name] UNIQUE NONCLUSTERED
+(
+ [user_name] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_group_users](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [group_name] [varchar](1024) NOT NULL,
+ [p_group_id] [bigint] DEFAULT NULL NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_export_audit](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [client_ip] [varchar](255) NOT NULL,
+ [agent_id] [varchar](255) DEFAULT NULL NULL,
+ [req_epoch] [bigint] NOT NULL,
+ [last_updated] [datetime2] DEFAULT NULL NULL,
+ [repository_name] [varchar](1024) DEFAULT NULL NULL,
+ [exported_json] [nvarchar](max) DEFAULT NULL NULL,
+ [http_ret_code] [int] DEFAULT 0 NOT NULL,
+ [cluster_name] [varchar](255) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_resource](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [res_name] [varchar](4000) DEFAULT NULL NULL,
+ [descr] [varchar](4000) DEFAULT NULL NULL,
+ [res_type] [int] DEFAULT 0 NOT NULL,
+ [asset_id] [bigint] NOT NULL,
+ [parent_id] [bigint] DEFAULT NULL NULL,
+ [parent_path] [varchar](4000) DEFAULT NULL NULL,
+ [is_encrypt] [int] DEFAULT 0 NOT NULL,
+ [is_recursive] [int] DEFAULT 0 NOT NULL,
+ [res_group] [varchar](1024) DEFAULT NULL NULL,
+ [res_dbs] [nvarchar](max) NULL,
+ [res_tables] [nvarchar](max) NULL,
+ [res_col_fams] [nvarchar](max) NULL,
+ [res_cols] [nvarchar](max) NULL,
+ [res_udfs] [nvarchar](max) NULL,
+ [res_status] [int] DEFAULT 1 NOT NULL,
+ [table_type] [int] DEFAULT 0 NOT NULL,
+ [col_type] [int] DEFAULT 0 NOT NULL,
+ [policy_name] [varchar](500) DEFAULT NULL NULL,
+ [res_topologies] [nvarchar](max) DEFAULT NULL NULL,
+ [res_services] [nvarchar](max) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_resource$x_resource_UK_policy_name] UNIQUE NONCLUSTERED
+(
+ [policy_name] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_trx_log](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [class_type] [int] DEFAULT 0 NOT NULL,
+ [object_id] [bigint] DEFAULT NULL NULL,
+ [parent_object_id] [bigint] DEFAULT NULL NULL,
+ [parent_object_class_type] [int] DEFAULT 0 NOT NULL,
+ [parent_object_name] [varchar](1024)DEFAULT NULL NULL,
+ [object_name] [varchar](1024) DEFAULT NULL NULL,
+ [attr_name] [varchar](255) DEFAULT NULL NULL,
+ [prev_val] [nvarchar](max) DEFAULT NULL NULL,
+ [new_val] [nvarchar](max)DEFAULT NULL NULL,
+ [trx_id] [varchar](1024)DEFAULT NULL NULL,
+ [action] [varchar](255) DEFAULT NULL NULL,
+ [sess_id] [varchar](512) DEFAULT NULL NULL,
+ [req_id] [varchar](30) DEFAULT NULL NULL,
+ [sess_type] [varchar](30) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_perm_map](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [perm_group] [varchar](1024) DEFAULT NULL NULL,
+ [res_id] [bigint] DEFAULT NULL NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [perm_for] [int] DEFAULT 0 NOT NULL,
+ [perm_type] [int] DEFAULT 0 NOT NULL,
+ [is_recursive] [int] DEFAULT 0 NOT NULL,
+ [is_wild_card] [tinyint] DEFAULT 1 NOT NULL,
+ [grant_revoke] [tinyint] DEFAULT 1 NOT NULL,
+ [ip_address] [nvarchar](max) DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_audit_map](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [res_id] [bigint] DEFAULT NULL NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [audit_type] [int] DEFAULT 0 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [impl_class_name] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 1 NULL,
+ [def_options] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [type] [bigint] DEFAULT NULL NULL,
+ [name] [varchar](255) DEFAULT NULL NULL,
+ [policy_version] [bigint] DEFAULT NULL NULL,
+ [policy_update_time] [datetime2] DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 0 NOT NULL,
+ [tag_service] [bigint] DEFAULT NULL NULL,
+ [tag_version] [bigint] DEFAULT 0 NOT NULL,
+ [tag_update_time] [datetime2] DEFAULT NULL NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_service$x_service_name] UNIQUE NONCLUSTERED
+(
+ [name] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [service] [bigint] DEFAULT NULL NULL,
+ [name] [varchar](512) DEFAULT NULL NULL,
+ [policy_type] [int] DEFAULT 0 NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [resource_signature] [varchar](128) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 0 NOT NULL,
+ [is_audit_enabled] [tinyint] DEFAULT 0 NOT NULL,
+PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_config_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [type] [varchar](1024) DEFAULT NULL NULL,
+ [sub_type] [varchar](1024) DEFAULT NULL NULL,
+ [is_mandatory] [tinyint] DEFAULT 0 NOT NULL,
+ [default_value] [varchar](1024) DEFAULT NULL NULL,
+ [validation_reg_ex] [varchar](1024) DEFAULT NULL NULL,
+ [validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [ui_hint] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_resource_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [type] [varchar](1024) DEFAULT NULL NULL,
+ [res_level] [bigint] DEFAULT NULL NULL,
+ [parent] [bigint] DEFAULT NULL NULL,
+ [mandatory] [tinyint] DEFAULT 0 NOT NULL,
+ [look_up_supported] [tinyint] DEFAULT 0 NOT NULL,
+ [recursive_supported] [tinyint] DEFAULT 0 NOT NULL,
+ [excludes_supported] [tinyint] DEFAULT 0 NOT NULL,
+ [matcher] [varchar](1024) DEFAULT NULL NULL,
+ [matcher_options] [varchar](1024) DEFAULT NULL NULL,
+ [validation_reg_ex] [varchar](1024) DEFAULT NULL NULL,
+ [validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [ui_hint] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ [datamask_options] [varchar](1024) DEFAULT NULL NULL,
+ [rowfilter_options] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_access_type_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ [datamask_options] [varchar](1024) DEFAULT NULL NULL,
+ [rowfilter_options] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_access_type_def_grants](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [atd_id] [bigint] NOT NULL,
+ [implied_grant] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_condition_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [evaluator] [varchar](1024) DEFAULT NULL NULL,
+ [evaluator_options] [varchar](1024) DEFAULT NULL NULL,
+ [validation_reg_ex] [varchar](1024) DEFAULT NULL NULL,
+ [validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [ui_hint] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_validation_message] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+CREATE TABLE [dbo].[x_context_enricher_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint]NOT NULL,
+ [item_id] [bigint]NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [enricher] [varchar](1024) DEFAULT NULL NULL,
+ [enricher_options] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_enum_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [default_index] [bigint] DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_enum_element_def] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [enum_def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) DEFAULT NULL NULL,
+ [label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_config_map] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [service] [bigint] NOT NULL,
+ [config_key] [varchar](1024) DEFAULT NULL NULL,
+ [config_value] [varchar](4000) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_resource] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_id] [bigint] NOT NULL,
+ [res_def_id] [bigint] NOT NULL,
+ [is_excludes] [tinyint] DEFAULT 0 NOT NULL,
+ [is_recursive] [tinyint] DEFAULT 0 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_resource_map] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [resource_id] [bigint] NOT NULL,
+ [value] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_id] [bigint] NOT NULL,
+ [delegate_admin] [tinyint] DEFAULT 0 NOT NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ [item_type] [int] DEFAULT 0 NOT NULL,
+ [is_enabled] [tinyint] DEFAULT 1 NOT NULL,
+ [comments] [varchar](255) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item_access] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [type] [bigint] NOT NULL,
+ [is_allowed] [tinyint] DEFAULT 0 NOT NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item_condition] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [type] [bigint] NOT NULL,
+ [value] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item_user_perm] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_policy_item_group_perm] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](1024) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+ [sort_order] [int] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_data_hist] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [obj_guid] [varchar](1024) NOT NULL,
+ [obj_class_type] [int] NOT NULL,
+ [obj_id] [bigint] NOT NULL,
+ [obj_name] [varchar](1024) NOT NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [action] [varchar](512) NOT NULL,
+ [from_time] [datetime2] NOT NULL,
+ [to_time] [datetime2] DEFAULT NULL NULL,
+ [content] [nvarchar](max) NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_modules_master] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [module] [varchar](1024)NOT NULL,
+ [url] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_user_module_perm] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [user_id] [bigint] DEFAULT NULL NULL,
+ [module_id] [bigint] DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [is_allowed] [int] DEFAULT 1 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_group_module_perm] (
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [group_id] [bigint] DEFAULT NULL NULL,
+ [module_id] [bigint] DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [is_allowed] [int] DEFAULT 1 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [name] [varchar](255) NOT NULL,
+ [source] [varchar](128) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 0 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_tag_def$x_tag_def_UK_guid] UNIQUE NONCLUSTERED
+(
+ [guid] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_tag_def$x_tag_def_UK_name] UNIQUE NONCLUSTERED
+(
+ [name] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [type] [bigint] NOT NULL,
+ [owned_by] [smallint] DEFAULT 0 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_tag$x_tag_UK_guid] UNIQUE NONCLUSTERED
+(
+ [guid] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_resource](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [version] [bigint] DEFAULT NULL NULL,
+ [service_id] [bigint] NOT NULL,
+ [resource_signature] [varchar](128) DEFAULT NULL NULL,
+ [is_enabled] [tinyint] DEFAULT 1 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_service_resource$x_service_res_UK_guid] UNIQUE NONCLUSTERED
+(
+ [guid] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_resource_element](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [res_id] [bigint] NOT NULL,
+ [res_def_id] [bigint] NOT NULL,
+ [is_excludes] [tinyint] DEFAULT 0 NOT NULL,
+ [is_recursive] [tinyint] DEFAULT 0 NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag_attr_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [tag_def_id] [bigint] NOT NULL,
+ [name] [varchar](255) NOT NULL,
+ [type] [varchar](50) NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag_attr](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [tag_id] [bigint] NOT NULL,
+ [name] [varchar](255) NOT NULL,
+ [value] [varchar](512) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_tag_resource_map](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [tag_id] [bigint] NOT NULL,
+ [res_id] [bigint] NOT NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_tag_resource_map$x_tag_resource_map_UK_guid] UNIQUE NONCLUSTERED
+(
+ [guid] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_resource_element_val](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [res_element_id] [bigint] NOT NULL,
+ [value] [varchar](1024) NOT NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_datamask_type_def](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [def_id] [bigint] NOT NULL,
+ [item_id] [bigint] NOT NULL,
+ [name] [varchar](1024) NOT NULL,
+ [label] [varchar](1024) NOT NULL,
+ [description] [varchar](1024) DEFAULT NULL NULL,
+ [transformer] [varchar](1024) DEFAULT NULL NULL,
+ [datamask_options] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_label] [varchar](1024) DEFAULT NULL NULL,
+ [rb_key_description] [varchar](1024) DEFAULT NULL NULL,
+ [sort_order] [tinyint] DEFAULT 0 NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+CREATE TABLE [dbo].[x_policy_item_datamask](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [type] [bigint] NOT NULL,
+ [condition_expr] [varchar](1024) DEFAULT NULL NULL,
+ [value_expr] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+CREATE TABLE [dbo].[x_policy_item_rowfilter](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [guid] [varchar](64) DEFAULT NULL NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL NULL,
+ [added_by_id] [bigint] DEFAULT NULL NULL,
+ [upd_by_id] [bigint] DEFAULT NULL NULL,
+ [policy_item_id] [bigint] NOT NULL,
+ [filter_expr] [varchar](1024) DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_service_version_info](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [service_id] [bigint] NOT NULL,
+ [policy_version] [bigint] NOT NULL DEFAULT 0,
+ [policy_update_time] [datetime2] DEFAULT NULL NULL,
+ [tag_version] [bigint] NOT NULL DEFAULT 0,
+ [tag_update_time] [datetime2] DEFAULT NULL NULL,
+ PRIMARY KEY CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+CREATE TABLE [dbo].[x_plugin_info](
+ [id] [bigint] IDENTITY(1,1) NOT NULL,
+ [create_time] [datetime2] DEFAULT NULL NULL,
+ [update_time] [datetime2] DEFAULT NULL 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 CLUSTERED
+(
+ [id] ASC
+)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
+CONSTRAINT [x_plugin_info$x_plugin_info_UK] UNIQUE NONCLUSTERED
+(
+ [service_name] ASC, [host_name] ASC, [app_type] ASC
+)WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
+) ON [PRIMARY]
+SET ANSI_NULLS ON
+SET QUOTED_IDENTIFIER ON
+SET ANSI_PADDING ON
+
+ALTER TABLE [dbo].[x_asset] WITH CHECK ADD CONSTRAINT [x_asset_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_asset] CHECK CONSTRAINT [x_asset_FK_added_by_id]
+ALTER TABLE [dbo].[x_asset] WITH CHECK ADD CONSTRAINT [x_asset_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_asset] CHECK CONSTRAINT [x_asset_FK_upd_by_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_added_by_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_group_id] FOREIGN KEY([group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_group_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_res_id] FOREIGN KEY([res_id])
+REFERENCES [dbo].[x_resource] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_res_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_upd_by_id]
+ALTER TABLE [dbo].[x_audit_map] WITH CHECK ADD CONSTRAINT [x_audit_map_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_user] ([id])
+ALTER TABLE [dbo].[x_audit_map] CHECK CONSTRAINT [x_audit_map_FK_user_id]
+ALTER TABLE [dbo].[x_auth_sess] WITH CHECK ADD CONSTRAINT [x_auth_sess_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_auth_sess] CHECK CONSTRAINT [x_auth_sess_FK_added_by_id]
+ALTER TABLE [dbo].[x_auth_sess] WITH CHECK ADD CONSTRAINT [x_auth_sess_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_auth_sess] CHECK CONSTRAINT [x_auth_sess_FK_upd_by_id]
+ALTER TABLE [dbo].[x_auth_sess] WITH CHECK ADD CONSTRAINT [x_auth_sess_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_auth_sess] CHECK CONSTRAINT [x_auth_sess_FK_user_id]
+ALTER TABLE [dbo].[x_cred_store] WITH CHECK ADD CONSTRAINT [x_cred_store_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_cred_store] CHECK CONSTRAINT [x_cred_store_FK_added_by_id]
+ALTER TABLE [dbo].[x_cred_store] WITH CHECK ADD CONSTRAINT [x_cred_store_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_cred_store] CHECK CONSTRAINT [x_cred_store_FK_upd_by_id]
+ALTER TABLE [dbo].[x_db_base] WITH CHECK ADD CONSTRAINT [x_db_base_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_db_base] CHECK CONSTRAINT [x_db_base_FK_added_by_id]
+ALTER TABLE [dbo].[x_db_base] WITH CHECK ADD CONSTRAINT [x_db_base_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_db_base] CHECK CONSTRAINT [x_db_base_FK_upd_by_id]
+ALTER TABLE [dbo].[x_group] WITH CHECK ADD CONSTRAINT [x_group_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group] CHECK CONSTRAINT [x_group_FK_added_by_id]
+ALTER TABLE [dbo].[x_group] WITH CHECK ADD CONSTRAINT [x_group_FK_cred_store_id] FOREIGN KEY([cred_store_id])
+REFERENCES [dbo].[x_cred_store] ([id])
+ALTER TABLE [dbo].[x_group] CHECK CONSTRAINT [x_group_FK_cred_store_id]
+ALTER TABLE [dbo].[x_group] WITH CHECK ADD CONSTRAINT [x_group_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group] CHECK CONSTRAINT [x_group_FK_upd_by_id]
+ALTER TABLE [dbo].[x_group_groups] WITH CHECK ADD CONSTRAINT [x_group_groups_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group_groups] CHECK CONSTRAINT [x_group_groups_FK_added_by_id]
+ALTER TABLE [dbo].[x_group_groups] WITH CHECK ADD CONSTRAINT [x_group_groups_FK_group_id] FOREIGN KEY([group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_group_groups] CHECK CONSTRAINT [x_group_groups_FK_group_id]
+ALTER TABLE [dbo].[x_group_groups] WITH CHECK ADD CONSTRAINT [x_group_groups_FK_p_group_id] FOREIGN KEY([p_group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_group_groups] CHECK CONSTRAINT [x_group_groups_FK_p_group_id]
+ALTER TABLE [dbo].[x_group_users] WITH CHECK ADD CONSTRAINT [x_group_users_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group_users] CHECK CONSTRAINT [x_group_users_FK_added_by_id]
+ALTER TABLE [dbo].[x_group_users] WITH CHECK ADD CONSTRAINT [x_group_users_FK_p_group_id] FOREIGN KEY([p_group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_group_users] CHECK CONSTRAINT [x_group_users_FK_p_group_id]
+ALTER TABLE [dbo].[x_group_users] WITH CHECK ADD CONSTRAINT [x_group_users_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group_users] CHECK CONSTRAINT [x_group_users_FK_upd_by_id]
+ALTER TABLE [dbo].[x_group_users] WITH CHECK ADD CONSTRAINT [x_group_users_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_user] ([id])
+ALTER TABLE [dbo].[x_group_users] CHECK CONSTRAINT [x_group_users_FK_user_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_added_by_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_group_id] FOREIGN KEY([group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_group_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_res_id] FOREIGN KEY([res_id])
+REFERENCES [dbo].[x_resource] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_res_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_upd_by_id]
+ALTER TABLE [dbo].[x_perm_map] WITH CHECK ADD CONSTRAINT [x_perm_map_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_user] ([id])
+ALTER TABLE [dbo].[x_perm_map] CHECK CONSTRAINT [x_perm_map_FK_user_id]
+ALTER TABLE [dbo].[x_policy_export_audit] WITH CHECK ADD CONSTRAINT [x_policy_export_audit_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_policy_export_audit] CHECK CONSTRAINT [x_policy_export_audit_FK_added_by_id]
+ALTER TABLE [dbo].[x_policy_export_audit] WITH CHECK ADD CONSTRAINT [x_policy_export_audit_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_policy_export_audit] CHECK CONSTRAINT [x_policy_export_audit_FK_upd_by_id]
+ALTER TABLE [dbo].[x_portal_user] WITH CHECK ADD CONSTRAINT [x_portal_user_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user] CHECK CONSTRAINT [x_portal_user_FK_added_by_id]
+ALTER TABLE [dbo].[x_portal_user] WITH CHECK ADD CONSTRAINT [x_portal_user_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user] CHECK CONSTRAINT [x_portal_user_FK_upd_by_id]
+ALTER TABLE [dbo].[x_portal_user_role] WITH CHECK ADD CONSTRAINT [x_portal_user_role_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user_role] CHECK CONSTRAINT [x_portal_user_role_FK_added_by_id]
+ALTER TABLE [dbo].[x_portal_user_role] WITH CHECK ADD CONSTRAINT [x_portal_user_role_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user_role] CHECK CONSTRAINT [x_portal_user_role_FK_upd_by_id]
+ALTER TABLE [dbo].[x_portal_user_role] WITH CHECK ADD CONSTRAINT [x_portal_user_role_FK_user_id] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_portal_user_role] CHECK CONSTRAINT [x_portal_user_role_FK_user_id]
+ALTER TABLE [dbo].[x_resource] WITH CHECK ADD CONSTRAINT [x_resource_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_resource] CHECK CONSTRAINT [x_resource_FK_added_by_id]
+ALTER TABLE [dbo].[x_resource] WITH CHECK ADD CONSTRAINT [x_resource_FK_asset_id] FOREIGN KEY([asset_id])
+REFERENCES [dbo].[x_asset] ([id])
+ALTER TABLE [dbo].[x_resource] CHECK CONSTRAINT [x_resource_FK_asset_id]
+ALTER TABLE [dbo].[x_resource] WITH CHECK ADD CONSTRAINT [x_resource_FK_parent_id] FOREIGN KEY([parent_id])
+REFERENCES [dbo].[x_resource] ([id])
+ALTER TABLE [dbo].[x_resource] CHECK CONSTRAINT [x_resource_FK_parent_id]
+ALTER TABLE [dbo].[x_resource] WITH CHECK ADD CONSTRAINT [x_resource_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_resource] CHECK CONSTRAINT [x_resource_FK_upd_by_id]
+ALTER TABLE [dbo].[x_trx_log] WITH CHECK ADD CONSTRAINT [x_trx_log_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_trx_log] CHECK CONSTRAINT [x_trx_log_FK_added_by_id]
+ALTER TABLE [dbo].[x_trx_log] WITH CHECK ADD CONSTRAINT [x_trx_log_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_trx_log] CHECK CONSTRAINT [x_trx_log_FK_upd_by_id]
+ALTER TABLE [dbo].[x_user] WITH CHECK ADD CONSTRAINT [x_user_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_user] CHECK CONSTRAINT [x_user_FK_added_by_id]
+ALTER TABLE [dbo].[x_user] WITH CHECK ADD CONSTRAINT [x_user_FK_cred_store_id] FOREIGN KEY([cred_store_id])
+REFERENCES [dbo].[x_cred_store] ([id])
+ALTER TABLE [dbo].[x_user] CHECK CONSTRAINT [x_user_FK_cred_store_id]
+ALTER TABLE [dbo].[x_user] WITH CHECK ADD CONSTRAINT [x_user_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_user] CHECK CONSTRAINT [x_user_FK_upd_by_id]
+ALTER TABLE [dbo].[x_user_module_perm] WITH CHECK ADD CONSTRAINT [x_user_module_perm_FK_moduleid] FOREIGN KEY([module_id])
+REFERENCES [dbo].[x_modules_master] ([id])
+ALTER TABLE [dbo].[x_user_module_perm] WITH CHECK ADD CONSTRAINT [x_user_module_perm_FK_userid] FOREIGN KEY([user_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_group_module_perm] WITH CHECK ADD CONSTRAINT [x_grp_module_perm_FK_module_id] FOREIGN KEY([module_id])
+REFERENCES [dbo].[x_modules_master] ([id])
+ALTER TABLE [dbo].[x_group_module_perm] WITH CHECK ADD CONSTRAINT [x_grp_module_perm_FK_group_id] FOREIGN KEY([group_id])
+REFERENCES [dbo].[x_group] ([id])
+ALTER TABLE [dbo].[x_service_def] WITH CHECK ADD CONSTRAINT [x_service_def_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service_def] CHECK CONSTRAINT [x_service_def_FK_added_by_id]
+ALTER TABLE [dbo].[x_service_def] WITH CHECK ADD CONSTRAINT [x_service_def_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service_def] CHECK CONSTRAINT [x_service_def_FK_upd_by_id]
+ALTER TABLE [dbo].[x_service] WITH CHECK ADD CONSTRAINT [x_service_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service] CHECK CONSTRAINT [x_service_FK_added_by_id]
+ALTER TABLE [dbo].[x_service] WITH CHECK ADD CONSTRAINT [x_service_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service] CHECK CONSTRAINT [x_service_FK_upd_by_id]
+ALTER TABLE [dbo].[x_service] WITH CHECK ADD CONSTRAINT [x_service_FK_type] FOREIGN KEY([type])
+REFERENCES [dbo].[x_service_def] ([id])
+ALTER TABLE [dbo].[x_service] CHECK CONSTRAINT [x_service_FK_type]
+ALTER TABLE [dbo].[x_service] WITH CHECK ADD CONSTRAINT [x_service_FK_tag_service] FOREIGN KEY([tag_service])
+REFERENCES [dbo].[x_service] ([id])
+ALTER TABLE [dbo].[x_policy] WITH CHECK ADD CONSTRAINT [x_policy_FK_added_by_id] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_policy] CHECK CONSTRAINT [x_policy_FK_added_by_id]
+ALTER TABLE [dbo].[x_policy] WITH CHECK ADD CONSTRAINT [x_policy_FK_upd_by_id] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_policy] CHECK CONSTRAINT [x_policy_FK_upd_by_id]
+ALTER TABLE [dbo].[x_policy] WITH CHECK ADD CONSTRAINT [x_policy_FK_service] FOREIGN KEY([service])
+REFERENCES [dbo].[x_service] ([id])
+ALTER TABLE [dbo].[x_policy] CHECK CONSTRAINT [x_policy_FK_service]
+ALTER TABLE [dbo].[x_service_config_def] WITH CHECK ADD CONSTRAINT [x_service_config_def_FK_defid] FOREIGN KEY([def_id])
+REFERENCES [dbo].[x_service_def] ([id])
+ALTER TABLE [dbo].[x_service_config_def] CHECK CONSTRAINT [x_service_config_def_FK_defid]
+ALTER TABLE [dbo].[x_service_config_def] WITH CHECK ADD CONSTRAINT [x_service_conf_def_FK_added_by] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service_config_def] CHECK CONSTRAINT [x_service_conf_def_FK_added_by]
+ALTER TABLE [dbo].[x_service_config_def] WITH CHECK ADD CONSTRAINT [x_service_conf_def_FK_upd_by] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_service_config_def] CHECK CONSTRAINT [x_service_conf_def_FK_upd_by]
+ALTER TABLE [dbo].[x_resource_def] WITH CHECK ADD CONSTRAINT [x_resource_def_FK_parent] FOREIGN KEY([parent])
+REFERENCES [dbo].[x_resource_def] ([id])
+ALTER TABLE [dbo].[x_resource_def] CHECK CONSTRAINT [x_resource_def_FK_parent]
+ALTER TABLE [dbo].[x_resource_def] WITH CHECK ADD CONSTRAINT [x_resource_def_FK_defid] FOREIGN KEY([def_id])
+REFERENCES [dbo].[x_service_def] ([id])
+ALTER TABLE [dbo].[x_resource_def] CHECK CONSTRAINT [x_resource_def_FK_defid]
+ALTER TABLE [dbo].[x_resource_def] WITH CHECK ADD CONSTRAINT [x_resource_def_FK_added_by] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_resource_def] CHECK CONSTRAINT [x_resource_def_FK_added_by]
+ALTER TABLE [dbo].[x_resource_def] WITH CHECK ADD CONSTRAINT [x_resource_def_FK_upd_by] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_resource_def] CHECK CONSTRAINT [x_resource_def_FK_upd_by]
+ALTER TABLE [dbo].[x_access_type_def] WITH CHECK ADD CONSTRAINT [x_access_type_def_FK_defid] FOREIGN KEY([def_id])
+REFERENCES [dbo].[x_service_def] ([id])
+ALTER TABLE [dbo].[x_access_type_def] CHECK CONSTRAINT [x_access_type_def_FK_defid]
+ALTER TABLE [dbo].[x_access_type_def] WITH CHECK ADD CONSTRAINT [x_access_type_def_FK_added_by] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_access_type_def] CHECK CONSTRAINT [x_access_type_def_FK_added_by]
+ALTER TABLE [dbo].[x_access_type_def] WITH CHECK ADD CONSTRAINT [x_access_type_def_FK_upd_by] FOREIGN KEY([upd_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_access_type_def] CHECK CONSTRAINT [x_access_type_def_FK_upd_by]
+ALTER TABLE [dbo].[x_access_type_def_grants] WITH CHECK ADD CONSTRAINT [x_atd_grants_FK_atdid] FOREIGN KEY([atd_id])
+REFERENCES [dbo].[x_access_type_def] ([id])
+ALTER TABLE [dbo].[x_access_type_def_grants] CHECK CONSTRAINT [x_atd_grants_FK_atdid]
+ALTER TABLE [dbo].[x_access_type_def_grants] WITH CHECK ADD CONSTRAINT [x_access_type_def_grants_FK_added_by] FOREIGN KEY([added_by_id])
+REFERENCES [dbo].[x_portal_user] ([id])
+ALTER TABLE [dbo].[x_access_type_def_grants] CHECK CONSTRAINT [x_access_type_def_grants_FK_added_by]
+ALTER TABLE [dbo].[x_access_type_def_grants] WITH CHECK ADD CONSTRAINT [x_access_type_def_grants_FK_upd_by] FOREIGN KEY([upd_by_id])
+RE
<TRUNCATED>
[3/3] ranger git commit: RANGER-1522 : Update consolidated db schema
script for SQLServer DB flavor to reduce execution time
Posted by ga...@apache.org.
RANGER-1522 : Update consolidated db schema script for SQLServer DB flavor to reduce execution time
Signed-off-by: Gautam Borad <ga...@apache.org>
Project: http://git-wip-us.apache.org/repos/asf/ranger/repo
Commit: http://git-wip-us.apache.org/repos/asf/ranger/commit/c01d01f5
Tree: http://git-wip-us.apache.org/repos/asf/ranger/tree/c01d01f5
Diff: http://git-wip-us.apache.org/repos/asf/ranger/diff/c01d01f5
Branch: refs/heads/master
Commit: c01d01f54622286de7ef17b302ae0a734664a9d1
Parents: c778487
Author: pradeep <pr...@apache.org>
Authored: Wed Apr 26 22:07:52 2017 +0530
Committer: Gautam Borad <ga...@apache.org>
Committed: Fri Apr 28 01:06:46 2017 +0530
----------------------------------------------------------------------
.../1.0.0/ranger_core_db_sqlserver.sql | 3008 ++++++++++++++++++
.../current/ranger_core_db_sqlserver.sql | 3008 ++++++++++++++++++
2 files changed, 6016 insertions(+)
----------------------------------------------------------------------