| -- 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_policy_ref_resource_FK_policy_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_resource] DROP CONSTRAINT x_policy_ref_resource_FK_policy_id |
| END |
| IF (OBJECT_ID('x_policy_ref_resource_FK_resource_def_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_resource] DROP CONSTRAINT x_policy_ref_resource_FK_resource_def_id |
| END |
| IF (OBJECT_ID('x_policy_ref_resource_UK') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_resource] DROP CONSTRAINT x_policy_ref_resource_UK |
| END |
| IF (OBJECT_ID('x_policy_ref_resource') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_resource] |
| END |
| IF (OBJECT_ID('x_policy_ref_access_type_FK_policy_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_access_type] DROP CONSTRAINT x_policy_ref_access_type_FK_policy_id |
| END |
| IF (OBJECT_ID('x_policy_ref_access_type_FK_access_def_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_access_type] DROP CONSTRAINT x_policy_ref_access_type_FK_access_def_id |
| END |
| IF (OBJECT_ID('x_policy_ref_access_type_UK') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_access_type] DROP CONSTRAINT x_policy_ref_access_type_UK |
| END |
| IF (OBJECT_ID('x_policy_ref_access_type') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_access_type] |
| END |
| IF (OBJECT_ID('x_policy_ref_condition_FK_policy_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_condition] DROP CONSTRAINT x_policy_ref_condition_FK_policy_id |
| END |
| IF (OBJECT_ID('x_policy_ref_condition_FK_condition_def_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_condition] DROP CONSTRAINT x_policy_ref_condition_FK_condition_def_id |
| END |
| IF (OBJECT_ID('x_policy_ref_condition_UK') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_condition] DROP CONSTRAINT x_policy_ref_condition_UK |
| END |
| IF (OBJECT_ID('x_policy_ref_condition') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_condition] |
| END |
| IF (OBJECT_ID('x_policy_ref_datamask_type_FK_policy_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_datamask_type] DROP CONSTRAINT x_policy_ref_datamask_type_FK_policy_id |
| END |
| IF (OBJECT_ID('x_policy_ref_datamask_type_FK_datamask_def_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_datamask_type] DROP CONSTRAINT x_policy_ref_datamask_type_FK_datamask_def_id |
| END |
| IF (OBJECT_ID('x_policy_ref_datamask_type_UK') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_datamask_type] DROP CONSTRAINT x_policy_ref_datamask_type_UK |
| END |
| IF (OBJECT_ID('x_policy_ref_datamask_type') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_datamask_type] |
| END |
| IF (OBJECT_ID('x_policy_ref_user_FK_policy_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_user] DROP CONSTRAINT x_policy_ref_user_FK_policy_id |
| END |
| IF (OBJECT_ID('x_policy_ref_user_FK_user_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_user] DROP CONSTRAINT x_policy_ref_user_FK_user_id |
| END |
| IF (OBJECT_ID('x_policy_ref_user_UK') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_user] DROP CONSTRAINT x_policy_ref_user_UK |
| END |
| IF (OBJECT_ID('x_policy_ref_user') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_user] |
| END |
| IF (OBJECT_ID('x_policy_ref_group_FK_policy_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_group] DROP CONSTRAINT x_policy_ref_group_FK_policy_id |
| END |
| IF (OBJECT_ID('x_policy_ref_group_FK_group_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_group] DROP CONSTRAINT x_policy_ref_group_FK_group_id |
| END |
| IF (OBJECT_ID('x_policy_ref_group_UK') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy_ref_group] DROP CONSTRAINT x_policy_ref_group_UK |
| END |
| IF (OBJECT_ID('x_policy_ref_group') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_group] |
| 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_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_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_group_UK_group_name') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_group] DROP CONSTRAINT x_group_UK_group_name |
| 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('x_policy$x_policy_UK_name_service_zone') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_policy] DROP CONSTRAINT x_policy$x_policy_UK_name_service_zone |
| END |
| IF (OBJECT_ID('x_sz_ref_admin_group_FK_added_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_group] DROP CONSTRAINT x_sz_ref_group_FK_added_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_group_FK_upd_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_group] DROP CONSTRAINT x_sz_ref_group_FK_upd_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_group_FK_zone_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_group] DROP CONSTRAINT x_sz_ref_group_FK_zone_id |
| END |
| IF (OBJECT_ID('x_sz_ref_group_FK_group_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_group] DROP CONSTRAINT x_sz_ref_group_FK_group_id |
| END |
| IF (OBJECT_ID('x_sz_ref_user_FK_added_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_user] DROP CONSTRAINT x_sz_ref_user_FK_added_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_user_FK_upd_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_user] DROP CONSTRAINT x_sz_ref_user_FK_upd_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_user_FK_zone_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_user] DROP CONSTRAINT x_sz_ref_user_FK_zone_id |
| END |
| IF (OBJECT_ID('x_sz_ref_user_FK_user_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_user] DROP CONSTRAINT x_sz_ref_user_FK_user_id |
| END |
| IF (OBJECT_ID('x_sz_ref_user_FK_user_name') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_user] DROP CONSTRAINT x_sz_ref_user_FK_user_name |
| END |
| IF (OBJECT_ID('x_sz_ref_resource_FK_added_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_resource] DROP CONSTRAINT x_sz_ref_resource_FK_added_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_resource_FK_upd_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_resource] DROP CONSTRAINT x_sz_ref_resource_FK_upd_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_resource_FK_zone_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_resource] DROP CONSTRAINT x_sz_ref_resource_FK_zone_id |
| END |
| IF (OBJECT_ID('x_sz_ref_resource_FK_resource_def_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_resource] DROP CONSTRAINT x_sz_ref_resource_FK_resource_def_id |
| END |
| IF (OBJECT_ID('x_sz_ref_service_FK_added_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_service] DROP CONSTRAINT x_sz_ref_service_FK_added_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_service_FK_upd_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_service] DROP CONSTRAINT x_sz_ref_service_FK_upd_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_service_FK_zone_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_service] DROP CONSTRAINT x_sz_ref_service_FK_zone_id |
| END |
| IF (OBJECT_ID('x_sz_ref_service_FK_service_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_service] DROP CONSTRAINT x_sz_ref_service_FK_service_id |
| END |
| IF (OBJECT_ID('x_sz_ref_service_FK_service_name') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_service] DROP CONSTRAINT x_sz_ref_service_FK_service_name |
| END |
| IF (OBJECT_ID('x_sz_ref_tag_service_FK_added_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_tag_srvc] DROP CONSTRAINT x_sz_ref_tag_service_FK_added_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_tag_service_FK_upd_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_tag_srvc] DROP CONSTRAINT x_sz_ref_tag_service_FK_upd_by_id |
| END |
| IF (OBJECT_ID('x_sz_ref_tag_service_FK_zone_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_tag_srvc] DROP CONSTRAINT x_sz_ref_tag_service_FK_zone_id |
| END |
| IF (OBJECT_ID('x_sz_ref_tag_service_FK_tag_service_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_tag_srvc] DROP CONSTRAINT x_sz_ref_tag_service_FK_tag_service_id |
| END |
| IF (OBJECT_ID('x_sz_ref_tag_service_FK_tag_service_name') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone_ref_tag_srvc] DROP CONSTRAINT x_sz_ref_tag_service_FK_tag_service_name |
| END |
| IF (OBJECT_ID('x_ranger_global_state_FK_upd_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_ranger_global_state] DROP CONSTRAINT x_ranger_global_state_FK_upd_by_id |
| END |
| IF (OBJECT_ID('x_ranger_global_state_FK_added_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_ranger_global_state] DROP CONSTRAINT x_ranger_global_state_FK_added_by_id |
| END |
| IF (OBJECT_ID('x_security_zone_FK_added_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone] DROP CONSTRAINT x_security_zone_FK_added_by_id |
| END |
| IF (OBJECT_ID('x_security_zone_FK_upd_by_id') IS NOT NULL) |
| BEGIN |
| ALTER TABLE [dbo].[x_security_zone] DROP CONSTRAINT x_security_zone_FK_upd_by_id |
| END |
| IF (OBJECT_ID('vx_trx_log') IS NOT NULL) |
| BEGIN |
| DROP VIEW [dbo].[vx_trx_log] |
| END |
| IF (OBJECT_ID('x_policy_change_log') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_change_log] |
| END |
| IF (OBJECT_ID('x_tag_change_log') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_tag_change_log] |
| END |
| IF (OBJECT_ID('x_policy_ref_group') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_group] |
| END |
| IF (OBJECT_ID('x_policy_ref_user') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_user] |
| END |
| IF (OBJECT_ID('x_policy_ref_datamask_type') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_datamask_type] |
| END |
| IF (OBJECT_ID('x_policy_ref_condition') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_condition] |
| END |
| IF (OBJECT_ID('x_policy_ref_access_type') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_access_type] |
| END |
| IF (OBJECT_ID('x_policy_ref_resource') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_resource] |
| END |
| IF (OBJECT_ID('x_ugsync_audit_info') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_ugsync_audit_info] |
| END |
| IF (OBJECT_ID('x_policy_label_map') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_label_map] |
| END |
| IF (OBJECT_ID('x_policy_label') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_label] |
| 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_label_map') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_label_map] |
| END |
| IF (OBJECT_ID('x_policy_label') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_label] |
| END |
| IF (OBJECT_ID('x_policy') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy] |
| END |
| IF (OBJECT_ID('x_security_zone_ref_service') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_security_zone_ref_service] |
| END |
| IF (OBJECT_ID('x_security_zone_ref_tag_srvc') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_security_zone_ref_tag_srvc] |
| END |
| IF (OBJECT_ID('x_security_zone_ref_resource') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_security_zone_ref_resource] |
| END |
| IF (OBJECT_ID('x_security_zone_ref_user') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_security_zone_ref_user] |
| END |
| IF (OBJECT_ID('x_security_zone_ref_group') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_security_zone_ref_group] |
| END |
| IF (OBJECT_ID('x_ranger_global_state') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_ranger_global_state] |
| END |
| IF (OBJECT_ID('x_security_zone') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_security_zone] |
| 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_role_ref_role') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_role_ref_role] |
| END |
| |
| IF (OBJECT_ID('x_policy_ref_role') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_policy_ref_role] |
| END |
| |
| IF (OBJECT_ID('x_role_ref_group') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_role_ref_group] |
| END |
| |
| IF (OBJECT_ID('x_role_ref_user') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_role_ref_user] |
| END |
| |
| IF (OBJECT_ID('x_role') IS NOT NULL) |
| BEGIN |
| DROP TABLE [dbo].[x_role] |
| 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, |
| [other_attributes] [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](767) 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, |
| [other_attributes] [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_group$x_group_UK_group_name] UNIQUE NONCLUSTERED |
| ( |
| [group_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_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, |
| [other_attributes] [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_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](767) 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], |
| CONSTRAINT [[x_group_users$x_group_users_UK_uid_gname] UNIQUE NONCLUSTERED |
| ( |
| [user_id] ASC, |
| [group_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_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, |
| [zone_name] [varchar](255) DEFAULT NULL NULL, |
| [policy_version] [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] 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, |
| [display_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, |
| [display_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] |
| GO |
| SET ANSI_NULLS ON |
| SET QUOTED_IDENTIFIER ON |
| SET ANSI_PADDING ON |
| CREATE TABLE [dbo].[x_security_zone]( |
| [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, |
| [version] [bigint] DEFAULT NULL NULL, |
| [name] [varchar](255) NOT NULL, |
| [jsonData] [nvarchar](max) DEFAULT NULL NULL, |
| [description] [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], |
| CONSTRAINT [x_security_zone$x_security_zone_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] |
| GO |
| SET ANSI_NULLS ON |
| SET QUOTED_IDENTIFIER ON |
| SET ANSI_PADDING ON |
| CREATE TABLE [dbo].[x_ranger_global_state]( |
| [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, |
| [version] [bigint] DEFAULT NULL NULL, |
| [state_name] [varchar](255) NOT NULL, |
| [app_data] [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], |
| CONSTRAINT [x_ranger_global_state$x_ranger_global_state_UK_name] UNIQUE NONCLUSTERED |
| ( |
| [state_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] |
| GO |
| 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] NOT NULL, |
| [name] [varchar](512) NOT 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, |
| [policy_options] [varchar](4000) DEFAULT NULL NULL, |
| [policy_priority] [int] DEFAULT 0 NOT NULL, |
| [policy_text] [nvarchar](max) DEFAULT NULL NULL, |
| [zone_id] [bigint] 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_policy$x_policy_UK_name_service_zone] UNIQUE NONCLUSTERED |
| ( |
| [name] ASC, [service] ASC, [zone_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] [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_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] [int] 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] [int] 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] [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] |
| 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] [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_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] [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_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] [int] 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] [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_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] [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_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, |
| [tag_attrs_def_text] [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_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, |
| [policy_options] [varchar](4000) DEFAULT NULL NULL, |
| [tag_attrs_text] [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_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, |
| [service_resource_elements_text] [nvarchar](max) DEFAULT NULL NULL, |
| [tags_text] [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_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_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_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] [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] |
| 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, |
| [role_version] [bigint] NOT NULL DEFAULT 0, |
| [role_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 |
| CREATE TABLE [dbo].[x_policy_label] ( |
| [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, |
| [label_name] [varchar](512) DEFAULT 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_policy_label$x_policy_label_UK_label_name] UNIQUE NONCLUSTERED |
| ( |
| [label_name] ASC |
| )WITH (PAD_INDEX = OFF,STATISTICS_NORECOMPUTE = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] |
| ) |
| SET ANSI_NULLS ON |
| SET QUOTED_IDENTIFIER ON |
| SET ANSI_PADDING ON |
| CREATE TABLE dbo.x_policy_label_map ( |
| [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_id] [bigint] DEFAULT NULL, |
| [policy_label_id] [bigint] DEFAULT 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] |
| ) |
| SET ANSI_NULLS ON |
| SET QUOTED_IDENTIFIER ON |
| SET ANSI_PADDING ON |
| CREATE TABLE [dbo].[x_ugsync_audit_info]( |
| [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, |
| [event_time] [datetime2] DEFAULT NULL NULL, |
| [user_name] [varchar](255) NOT NULL, |
| [sync_source] [varchar](128) NOT NULL, |
| [no_of_new_users] [bigint] NOT NULL, |
| [no_of_new_groups] [bigint] NOT NULL, |
| [no_of_modified_users] [bigint] NOT NULL, |
| [no_of_modified_groups] [bigint] NOT NULL, |
| [sync_source_info] [varchar](4000) NOT NULL, |
| [session_id] [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_ref_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, |
| [resource_def_id] [bigint] NOT NULL, |
| [resource_name] [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_policy_ref_resource$x_policy_ref_resource_UK] UNIQUE NONCLUSTERED |
| ( |
| [policy_id] ASC, [resource_def_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_ref_access_type] ( |
| [id] [bigint] IDENTITY (1, 1) NOT NULL, |
| [guid] [varchar](1024) DEFAULT |
