security-admin/db/sqlanywhere/xa_core_db

-- 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. create table dbo.x_portal_user( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_portal_user_PK_id PRIMARY KEY CLUSTERED(id), CONSTRAINT x_portal_user_UK_email UNIQUE NONCLUSTERED (email), CONSTRAINT x_portal_user_UK_login_id UNIQUE NONCLUSTERED (login_id) ) GO create table dbo.x_portal_user_role( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_portal_user_role_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.xa_access_audit( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 datetime 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, seq_num bigint DEFAULT 0 NULL, event_count bigint DEFAULT 1 NULL, event_dur_ms bigint DEFAULT 1 NULL, CONSTRAINT xa_access_audit_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_asset( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 text NULL, sup_native tinyint DEFAULT 0 NOT NULL, CONSTRAINT x_asset_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_auth_sess( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 datetime 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, CONSTRAINT x_auth_sess_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_cred_store( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_cred_store_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_db_base( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime DEFAULT NULL NULL, added_by_id bigint DEFAULT NULL NULL, upd_by_id bigint DEFAULT NULL NULL, CONSTRAINT x_db_base_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_group( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_group_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_group_groups( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_group_groups_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_user( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime DEFAULT NULL NULL, added_by_id bigint DEFAULT NULL NULL, upd_by_id bigint DEFAULT NULL NULL, user_name varchar(1024) 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, CONSTRAINT x_user_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_group_users( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_group_users_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy_export_audit( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 datetime DEFAULT NULL NULL, repository_name varchar(1024) DEFAULT NULL NULL, exported_json text DEFAULT NULL NULL, http_ret_code int DEFAULT 0 NOT NULL, CONSTRAINT x_policy_export_audit_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_resource( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 text NULL, res_tables text NULL, res_col_fams text NULL, res_cols text NULL, res_udfs text 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 text DEFAULT NULL NULL, res_services text DEFAULT NULL NULL, CONSTRAINT x_resource_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_trx_log( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 text DEFAULT NULL NULL, new_val text 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, CONSTRAINT x_trx_log_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_perm_map( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 text DEFAULT NULL NULL, CONSTRAINT x_perm_map_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_audit_map( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_audit_map_PK_id PRIMARY KEY CLUSTERED(id) ) GO CREATE VIEW dbo.vx_trx_log AS select x_trx_log.id AS id,x_trx_log.create_time AS create_time,x_trx_log.update_time AS update_time,x_trx_log.added_by_id AS added_by_id,x_trx_log.upd_by_id AS upd_by_id,x_trx_log.class_type AS class_type,x_trx_log.object_id AS object_id,x_trx_log.parent_object_id AS parent_object_id,x_trx_log.parent_object_class_type AS parent_object_class_type,x_trx_log.attr_name AS attr_name,x_trx_log.parent_object_name AS parent_object_name,x_trx_log.object_name AS object_name,x_trx_log.prev_val AS prev_val,x_trx_log.new_val AS new_val,x_trx_log.trx_id AS trx_id,x_trx_log.action AS action,x_trx_log.sess_id AS sess_id,x_trx_log.req_id AS req_id,x_trx_log.sess_type AS sess_type from x_trx_log where id in(select min(x_trx_log.id) from x_trx_log group by x_trx_log.trx_id) GO create table dbo.x_service_def( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_service_def_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_service ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 datetime DEFAULT NULL NULL, description varchar(1024) DEFAULT NULL NULL, is_enabled tinyint DEFAULT 0 NOT NULL, CONSTRAINT x_service_def_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_policy_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_service_config_def ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_service_config_def_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_resource_def ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_resource_def_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_access_type_def ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_access_type_def_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_access_type_def_grants( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_access_type_def_grants_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy_condition_def ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_policy_condition_def_grants_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_context_enricher_def( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_context_enricher_def_grants_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_enum_def ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_enum_def_grants_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_enum_element_def ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_enum_element_def_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_service_config_map ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_service_config_map_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy_resource ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_policy_resource_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy_resource_map ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 tinyint DEFAULT 0 NULL, CONSTRAINT x_policy_resource_map_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy_item ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_policy_item_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy_item_access ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_policy_item_access_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy_item_condition ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_policy_item_condition_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy_item_user_perm ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 tinyint DEFAULT 0 NULL, CONSTRAINT x_policy_item_user_perm_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_policy_item_group_perm ( id bigint IDENTITY NOT NULL, guid varchar(1024) DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 tinyint DEFAULT 0 NULL, CONSTRAINT x_policy_item_group_perm_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_data_hist ( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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 datetime NOT NULL, to_time datetime DEFAULT NULL NULL, content text NOT NULL, CONSTRAINT x_data_hist_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_modules_master ( id bigint IDENTITY NOT NULL, create_time datetime DEFAULT NULL NULL, update_time datetime 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, CONSTRAINT x_modules_master_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_user_module_perm ( id bigint IDENTITY NOT NULL, user_id bigint DEFAULT NULL NULL, module_id bigint DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime DEFAULT NULL NULL, added_by_id bigint DEFAULT NULL NULL, upd_by_id bigint DEFAULT NULL NULL, is_allowed int DEFAULT 1 NOT NULL, CONSTRAINT x_user_module_perm_PK_id PRIMARY KEY CLUSTERED(id) ) GO create table dbo.x_group_module_perm ( id bigint IDENTITY NOT NULL, group_id bigint DEFAULT NULL NULL, module_id bigint DEFAULT NULL NULL, create_time datetime DEFAULT NULL NULL, update_time datetime DEFAULT NULL NULL, added_by_id bigint DEFAULT NULL NULL, upd_by_id bigint DEFAULT NULL NULL, is_allowed int DEFAULT 1 NOT NULL, CONSTRAINT x_group_module_perm_PK_id PRIMARY KEY CLUSTERED(id) ) ALTER TABLE dbo.x_asset ADD CONSTRAINT x_asset_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user(id) GO ALTER TABLE dbo.x_asset ADD CONSTRAINT x_asset_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_audit_map ADD CONSTRAINT x_audit_map_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_audit_map ADD CONSTRAINT x_audit_map_FK_group_id FOREIGN KEY(group_id) REFERENCES dbo.x_group (id) GO ALTER TABLE dbo.x_audit_map ADD CONSTRAINT x_audit_map_FK_res_id FOREIGN KEY(res_id) REFERENCES dbo.x_resource (id) GO ALTER TABLE dbo.x_audit_map ADD CONSTRAINT x_audit_map_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_audit_map ADD CONSTRAINT x_audit_map_FK_user_id FOREIGN KEY(user_id) REFERENCES dbo.x_user (id) GO ALTER TABLE dbo.x_auth_sess ADD CONSTRAINT x_auth_sess_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_auth_sess ADD CONSTRAINT x_auth_sess_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_auth_sess ADD CONSTRAINT x_auth_sess_FK_user_id FOREIGN KEY(user_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_cred_store ADD CONSTRAINT x_cred_store_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_cred_store ADD CONSTRAINT x_cred_store_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_db_base ADD CONSTRAINT x_db_base_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_db_base ADD CONSTRAINT x_db_base_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_group ADD CONSTRAINT x_group_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_group ADD CONSTRAINT x_group_FK_cred_store_id FOREIGN KEY(cred_store_id) REFERENCES dbo.x_cred_store (id) GO ALTER TABLE dbo.x_group ADD CONSTRAINT x_group_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_group_groups ADD CONSTRAINT x_group_groups_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_group_groups ADD CONSTRAINT x_group_groups_FK_group_id FOREIGN KEY(group_id) REFERENCES dbo.x_group (id) GO ALTER TABLE dbo.x_group_groups ADD CONSTRAINT x_group_groups_FK_p_group_id FOREIGN KEY(p_group_id) REFERENCES dbo.x_group (id) GO ALTER TABLE dbo.x_group_users ADD CONSTRAINT x_group_users_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_group_users ADD CONSTRAINT x_group_users_FK_p_group_id FOREIGN KEY(p_group_id) REFERENCES dbo.x_group (id) GO ALTER TABLE dbo.x_group_users ADD CONSTRAINT x_group_users_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_group_users ADD CONSTRAINT x_group_users_FK_user_id FOREIGN KEY(user_id) REFERENCES dbo.x_user (id) GO ALTER TABLE dbo.x_perm_map ADD CONSTRAINT x_perm_map_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_perm_map ADD CONSTRAINT x_perm_map_FK_group_id FOREIGN KEY(group_id) REFERENCES dbo.x_group (id) GO ALTER TABLE dbo.x_perm_map ADD CONSTRAINT x_perm_map_FK_res_id FOREIGN KEY(res_id) REFERENCES dbo.x_resource (id) GO ALTER TABLE dbo.x_perm_map ADD CONSTRAINT x_perm_map_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_perm_map ADD CONSTRAINT x_perm_map_FK_user_id FOREIGN KEY(user_id) REFERENCES dbo.x_user (id) GO ALTER TABLE dbo.x_policy_export_audit ADD CONSTRAINT x_policy_export_audit_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_export_audit ADD CONSTRAINT x_policy_export_audit_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_portal_user ADD CONSTRAINT x_portal_user_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_portal_user ADD CONSTRAINT x_portal_user_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_portal_user_role ADD CONSTRAINT x_portal_user_role_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_portal_user_role ADD CONSTRAINT x_portal_user_role_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_portal_user_role ADD CONSTRAINT x_portal_user_role_FK_user_id FOREIGN KEY(user_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_resource ADD CONSTRAINT x_resource_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_resource ADD CONSTRAINT x_resource_FK_asset_id FOREIGN KEY(asset_id) REFERENCES dbo.x_asset (id) GO ALTER TABLE dbo.x_resource ADD CONSTRAINT x_resource_FK_parent_id FOREIGN KEY(parent_id) REFERENCES dbo.x_resource (id) GO ALTER TABLE dbo.x_resource ADD CONSTRAINT x_resource_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_trx_log ADD CONSTRAINT x_trx_log_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_trx_log ADD CONSTRAINT x_trx_log_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_user ADD CONSTRAINT x_user_FK_added_by_id FOREIGN KEY(added_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_user ADD CONSTRAINT x_user_FK_cred_store_id FOREIGN KEY(cred_store_id) REFERENCES dbo.x_cred_store (id) GO ALTER TABLE dbo.x_user ADD CONSTRAINT x_user_FK_upd_by_id FOREIGN KEY(upd_by_id) REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_service_def ADD CONSTRAINT x_service_def_FK_added_by_id FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_service_def ADD CONSTRAINT x_service_def_FK_upd_by_id FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_service ADD CONSTRAINT x_service_FK_added_by_id FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_service ADD CONSTRAINT x_service_FK_upd_by_id FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_service ADD CONSTRAINT x_service_FK_type FOREIGN KEY(type)REFERENCES dbo.x_service_def (id) GO ALTER TABLE dbo.x_policy ADD CONSTRAINT x_policy_FK_added_by_id FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy ADD CONSTRAINT x_policy_FK_upd_by_id FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy ADD CONSTRAINT x_policy_FK_service FOREIGN KEY(service)REFERENCES dbo.x_service (id) GO ALTER TABLE dbo.x_service_config_def ADD CONSTRAINT x_service_config_def_FK_defid FOREIGN KEY(def_id)REFERENCES dbo.x_service_def (id) GO ALTER TABLE dbo.x_service_config_def ADD CONSTRAINT x_service_conf_def_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_service_config_def ADD CONSTRAINT x_service_conf_def_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_resource_def ADD CONSTRAINT x_resource_def_FK_parent FOREIGN KEY(parent)REFERENCES dbo.x_resource_def (id) GO ALTER TABLE dbo.x_resource_def ADD CONSTRAINT x_resource_def_FK_defid FOREIGN KEY(def_id)REFERENCES dbo.x_service_def (id) GO ALTER TABLE dbo.x_resource_def ADD CONSTRAINT x_resource_def_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_resource_def ADD CONSTRAINT x_resource_def_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_access_type_def ADD CONSTRAINT x_access_type_def_FK_defid FOREIGN KEY(def_id)REFERENCES dbo.x_service_def (id) GO ALTER TABLE dbo.x_access_type_def ADD CONSTRAINT x_access_type_def_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_access_type_def ADD CONSTRAINT x_access_type_def_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_access_type_def_grants ADD CONSTRAINT x_atd_grants_FK_atdid FOREIGN KEY(atd_id)REFERENCES dbo.x_access_type_def (id) GO ALTER TABLE dbo.x_access_type_def_grants ADD CONSTRAINT x_access_type_def_grants_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_access_type_def_grants ADD CONSTRAINT x_access_type_def_grants_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_condition_def ADD CONSTRAINT x_policy_condition_def_FK_defid FOREIGN KEY(def_id)REFERENCES dbo.x_service_def (id) GO ALTER TABLE dbo.x_policy_condition_def ADD CONSTRAINT x_policy_condition_def_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_condition_def ADD CONSTRAINT x_policy_condition_def_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_context_enricher_def ADD CONSTRAINT x_context_enricher_def_FK_defid FOREIGN KEY(def_id)REFERENCES dbo.x_service_def (id) GO ALTER TABLE dbo.x_context_enricher_def ADD CONSTRAINT x_context_enricher_def_FK_added_by_id FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_context_enricher_def ADD CONSTRAINT x_context_enricher_def_FK_upd_by_id FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_enum_def ADD CONSTRAINT x_enum_def_FK_defid FOREIGN KEY(def_id)REFERENCES dbo.x_service_def (id) GO ALTER TABLE dbo.x_enum_element_def ADD CONSTRAINT x_enum_element_def_FK_defid FOREIGN KEY(enum_def_id)REFERENCES dbo.x_enum_def (id) GO ALTER TABLE dbo.x_enum_def ADD CONSTRAINT x_enum_def_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_enum_def ADD CONSTRAINT x_enum_def_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_service_config_map ADD CONSTRAINT x_service_config_map_FK_ FOREIGN KEY(service)REFERENCES dbo.x_service (id) GO ALTER TABLE dbo.x_service_config_map ADD CONSTRAINT x_service_config_map_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_service_config_map ADD CONSTRAINT x_service_config_map_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_resource ADD CONSTRAINT x_policy_resource_FK_policy_id FOREIGN KEY(policy_id)REFERENCES dbo.x_policy (id) GO ALTER TABLE dbo.x_policy_resource ADD CONSTRAINT x_policy_resource_FK_res_def_id FOREIGN KEY(res_def_id)REFERENCES dbo.x_resource_def (id) GO ALTER TABLE dbo.x_policy_resource ADD CONSTRAINT x_policy_resource_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_resource ADD CONSTRAINT x_policy_resource_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_resource_map ADD CONSTRAINT x_policy_resource_map_FK_resource_id FOREIGN KEY(resource_id)REFERENCES dbo.x_policy_resource (id) GO ALTER TABLE dbo.x_policy_resource_map ADD CONSTRAINT x_policy_resource_map_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_resource_map ADD CONSTRAINT x_policy_resource_map_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item ADD CONSTRAINT x_policy_item_FK_policy_id FOREIGN KEY(policy_id)REFERENCES dbo.x_policy (id) GO ALTER TABLE dbo.x_policy_item ADD CONSTRAINT x_policy_item_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item ADD CONSTRAINT x_policy_item_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item_access ADD CONSTRAINT x_policy_item_access_FK_pi_id FOREIGN KEY(policy_item_id)REFERENCES dbo.x_policy_item (id) GO ALTER TABLE dbo.x_policy_item_access ADD CONSTRAINT x_policy_item_access_FK_atd_id FOREIGN KEY(type)REFERENCES dbo.x_access_type_def (id) GO ALTER TABLE dbo.x_policy_item_access ADD CONSTRAINT x_policy_item_access_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item_access ADD CONSTRAINT x_policy_item_access_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item_condition ADD CONSTRAINT x_policy_item_condition_FK_pi_id FOREIGN KEY(policy_item_id)REFERENCES dbo.x_policy_item (id) GO ALTER TABLE dbo.x_policy_item_condition ADD CONSTRAINT x_policy_item_condition_FK_pcd_id FOREIGN KEY(type)REFERENCES dbo.x_policy_condition_def (id) GO ALTER TABLE dbo.x_policy_item_condition ADD CONSTRAINT x_policy_item_condition_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item_condition ADD CONSTRAINT x_policy_item_condition_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item_user_perm ADD CONSTRAINT x_policy_item_user_perm_FK_pi_id FOREIGN KEY(policy_item_id)REFERENCES dbo.x_policy_item (id) GO ALTER TABLE dbo.x_policy_item_user_perm ADD CONSTRAINT x_policy_item_user_perm_FK_user_id FOREIGN KEY(user_id)REFERENCES dbo.x_user (id) GO ALTER TABLE dbo.x_policy_item_user_perm ADD CONSTRAINT x_policy_item_user_perm_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item_user_perm ADD CONSTRAINT x_policy_item_user_perm_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item_group_perm ADD CONSTRAINT x_policy_item_group_perm_FK_pi_id FOREIGN KEY(policy_item_id)REFERENCES dbo.x_policy_item (id) GO ALTER TABLE dbo.x_policy_item_group_perm ADD CONSTRAINT x_policy_item_group_perm_FK_group_id FOREIGN KEY(group_id)REFERENCES dbo.x_group (id) GO ALTER TABLE dbo.x_policy_item_group_perm ADD CONSTRAINT x_policy_item_group_perm_FK_added_by FOREIGN KEY(added_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_policy_item_group_perm ADD CONSTRAINT x_policy_item_group_perm_FK_upd_by FOREIGN KEY(upd_by_id)REFERENCES dbo.x_portal_user (id) GO ALTER TABLE dbo.x_user_module_perm ADD CONSTRAINT x_user_module_perm_FK_moduleid FOREIGN KEY(module_id) REFERENCES dbo.x_modules_master(id) GO ALTER TABLE dbo.x_user_module_perm ADD CONSTRAINT x_user_module_perm_FK_userid FOREIGN KEY(user_id) REFERENCES dbo.x_portal_user(id) GO ALTER TABLE dbo.x_group_module_perm ADD CONSTRAINT x_grp_module_perm_FK_module_id FOREIGN KEY(module_id) REFERENCES dbo.x_modules_master(id) GO ALTER TABLE dbo.x_group_module_perm ADD CONSTRAINT x_grp_module_perm_FK_group_id FOREIGN KEY(group_id) REFERENCES dbo.x_group(id) GO CREATE NONCLUSTERED INDEX x_asset_cr_time ON dbo.x_asset(create_time ASC) GO CREATE NONCLUSTERED INDEX x_asset_FK_added_by_id ON dbo.x_asset(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_asset_FK_upd_by_id ON dbo.x_asset(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_asset_up_time ON dbo.x_asset(update_time ASC) GO CREATE NONCLUSTERED INDEX x_audit_map_cr_time ON dbo.x_audit_map(create_time ASC) GO CREATE NONCLUSTERED INDEX x_audit_map_FK_added_by_id ON dbo.x_audit_map(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_audit_map_FK_group_id ON dbo.x_audit_map(group_id ASC) GO CREATE NONCLUSTERED INDEX x_audit_map_FK_res_id ON dbo.x_audit_map(res_id ASC) GO CREATE NONCLUSTERED INDEX x_audit_map_FK_upd_by_id ON dbo.x_audit_map(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_audit_map_FK_user_id ON dbo.x_audit_map(user_id ASC) GO CREATE NONCLUSTERED INDEX x_audit_map_up_time ON dbo.x_audit_map(update_time ASC) GO CREATE NONCLUSTERED INDEX x_auth_sess_cr_time ON dbo.x_auth_sess(create_time ASC) GO CREATE NONCLUSTERED INDEX x_auth_sess_FK_added_by_id ON dbo.x_auth_sess(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_auth_sess_FK_upd_by_id ON dbo.x_auth_sess(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_auth_sess_FK_user_id ON dbo.x_auth_sess(user_id ASC) GO CREATE NONCLUSTERED INDEX x_auth_sess_up_time ON dbo.x_auth_sess(update_time ASC) GO CREATE NONCLUSTERED INDEX x_cred_store_cr_time ON dbo.x_cred_store(create_time ASC) GO CREATE NONCLUSTERED INDEX x_cred_store_FK_added_by_id ON dbo.x_cred_store(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_cred_store_FK_upd_by_id ON dbo.x_cred_store(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_cred_store_up_time ON dbo.x_cred_store(update_time ASC) GO CREATE NONCLUSTERED INDEX x_db_base_cr_time ON dbo.x_db_base(create_time ASC) GO CREATE NONCLUSTERED INDEX x_db_base_FK_added_by_id ON dbo.x_db_base(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_db_base_FK_upd_by_id ON dbo.x_db_base(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_db_base_up_time ON dbo.x_db_base(update_time ASC) GO CREATE NONCLUSTERED INDEX x_group_cr_time ON dbo.x_group(create_time ASC) GO CREATE NONCLUSTERED INDEX x_group_FK_added_by_id ON dbo.x_group(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_group_FK_cred_store_id ON dbo.x_group(cred_store_id ASC) GO CREATE NONCLUSTERED INDEX x_group_FK_upd_by_id ON dbo.x_group(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_group_groups_cr_time ON dbo.x_group_groups(create_time ASC) GO CREATE NONCLUSTERED INDEX x_group_groups_FK_added_by_id ON dbo.x_group_groups(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_group_groups_FK_group_id ON dbo.x_group_groups(group_id ASC) GO CREATE NONCLUSTERED INDEX x_group_groups_FK_p_group_id ON dbo.x_group_groups(p_group_id ASC) GO CREATE NONCLUSTERED INDEX x_group_groups_FK_upd_by_id ON dbo.x_group_groups(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_group_groups_up_time ON dbo.x_group_groups(update_time ASC) GO CREATE NONCLUSTERED INDEX x_group_up_time ON dbo.x_group(update_time ASC) GO CREATE NONCLUSTERED INDEX x_group_users_cr_time ON dbo.x_group_users(create_time ASC) GO CREATE NONCLUSTERED INDEX x_group_users_FK_added_by_id ON dbo.x_group_users(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_group_users_FK_p_group_id ON dbo.x_group_users(p_group_id ASC) GO CREATE NONCLUSTERED INDEX x_group_users_FK_upd_by_id ON dbo.x_group_users(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_group_users_FK_user_id ON dbo.x_group_users(user_id ASC) GO CREATE NONCLUSTERED INDEX x_group_users_up_time ON dbo.x_group_users(update_time ASC) GO CREATE NONCLUSTERED INDEX x_perm_map_cr_time ON dbo.x_perm_map(create_time ASC) GO CREATE NONCLUSTERED INDEX x_perm_map_FK_added_by_id ON dbo.x_perm_map(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_perm_map_FK_group_id ON dbo.x_perm_map(group_id ASC) GO CREATE NONCLUSTERED INDEX x_perm_map_FK_res_id ON dbo.x_perm_map(res_id ASC) GO CREATE NONCLUSTERED INDEX x_perm_map_FK_upd_by_id ON dbo.x_perm_map(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_perm_map_FK_user_id ON dbo.x_perm_map(user_id ASC) GO CREATE NONCLUSTERED INDEX x_perm_map_up_time ON dbo.x_perm_map(update_time ASC) GO CREATE NONCLUSTERED INDEX x_policy_export_audit_cr_time ON dbo.x_policy_export_audit(create_time ASC) GO CREATE NONCLUSTERED INDEX x_policy_export_audit_FK_added_by_id ON dbo.x_policy_export_audit(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_policy_export_audit_FK_upd_by_id ON dbo.x_policy_export_audit(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_policy_export_audit_up_time ON dbo.x_policy_export_audit(update_time ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_cr_time ON dbo.x_portal_user(create_time ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_email ON dbo.x_portal_user(email ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_FK_added_by_id ON dbo.x_portal_user(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_FK_upd_by_id ON dbo.x_portal_user(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_name ON dbo.x_portal_user(first_name ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_role_cr_time ON dbo.x_portal_user_role(create_time ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_role_FK_added_by_id ON dbo.x_portal_user_role(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_role_FK_upd_by_id ON dbo.x_portal_user_role(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_role_FK_user_id ON dbo.x_portal_user_role(user_id ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_role_up_time ON dbo.x_portal_user_role(update_time ASC) GO CREATE NONCLUSTERED INDEX x_portal_user_up_time ON dbo.x_portal_user(update_time ASC) GO CREATE NONCLUSTERED INDEX x_resource_cr_time ON dbo.x_resource(create_time ASC) GO CREATE NONCLUSTERED INDEX x_resource_FK_added_by_id ON dbo.x_resource(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_resource_FK_asset_id ON dbo.x_resource(asset_id ASC) GO CREATE NONCLUSTERED INDEX x_resource_FK_parent_id ON dbo.x_resource(parent_id ASC) GO CREATE NONCLUSTERED INDEX x_resource_FK_upd_by_id ON dbo.x_resource(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_resource_up_time ON dbo.x_resource(update_time ASC) GO CREATE NONCLUSTERED INDEX x_trx_log_cr_time ON dbo.x_trx_log(create_time ASC) GO CREATE NONCLUSTERED INDEX x_trx_log_FK_added_by_id ON dbo.x_trx_log(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_trx_log_FK_upd_by_id ON dbo.x_trx_log(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_trx_log_up_time ON dbo.x_trx_log(update_time ASC) GO CREATE NONCLUSTERED INDEX x_user_cr_time ON dbo.x_user(create_time ASC) GO CREATE NONCLUSTERED INDEX x_user_FK_added_by_id ON dbo.x_user(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_user_FK_cred_store_id ON dbo.x_user(cred_store_id ASC) GO CREATE NONCLUSTERED INDEX x_user_FK_upd_by_id ON dbo.x_user(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_user_up_time ON dbo.x_user(update_time ASC) GO CREATE NONCLUSTERED INDEX xa_access_audit_cr_time ON dbo.xa_access_audit(create_time ASC) GO CREATE NONCLUSTERED INDEX xa_access_audit_event_time ON dbo.xa_access_audit(event_time ASC) GO CREATE NONCLUSTERED INDEX xa_access_audit_added_by_id ON dbo.xa_access_audit(added_by_id ASC) GO CREATE NONCLUSTERED INDEX xa_access_audit_upd_by_id ON dbo.xa_access_audit(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX xa_access_audit_up_time ON dbo.xa_access_audit(update_time ASC) GO CREATE NONCLUSTERED INDEX x_service_def_added_by_id ON dbo.x_service_def(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_service_def_upd_by_id ON dbo.x_service_def(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_service_def_cr_time ON dbo.x_service_def(create_time ASC) GO CREATE NONCLUSTERED INDEX x_service_def_up_time ON dbo.x_service_def(update_time ASC) GO CREATE NONCLUSTERED INDEX x_service_added_by_id ON dbo.x_service(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_service_upd_by_id ON dbo.x_service(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_service_cr_time ON dbo.x_service(create_time ASC) GO CREATE NONCLUSTERED INDEX x_service_up_time ON dbo.x_service(update_time ASC) GO CREATE NONCLUSTERED INDEX x_service_type ON dbo.x_service(type ASC) GO CREATE NONCLUSTERED INDEX x_policy_added_by_id ON dbo.x_policy(added_by_id ASC) GO CREATE NONCLUSTERED INDEX x_policy_upd_by_id ON dbo.x_policy(upd_by_id ASC) GO CREATE NONCLUSTERED INDEX x_policy_cr_time ON dbo.x_policy(create_time ASC) GO CREATE NONCLUSTERED INDEX x_policy_up_time ON dbo.x_policy(update_time ASC) GO CREATE NONCLUSTERED INDEX x_policy_service ON dbo.x_policy(service ASC) GO CREATE NONCLUSTERED INDEX x_policy_resource_signature ON dbo.x_policy(resource_signature ASC) GO CREATE NONCLUSTERED INDEX x_resource_def_parent ON dbo.x_resource_def(parent ASC) GO CREATE NONCLUSTERED INDEX x_usr_module_perm_idx_moduleid ON dbo.x_user_module_perm(module_id ASC) GO CREATE NONCLUSTERED INDEX x_usr_module_perm_idx_userid ON dbo.x_user_module_perm(user_id ASC) GO CREATE NONCLUSTERED INDEX x_grp_module_perm_idx_groupid ON dbo.x_group_module_perm(group_id ASC) GO CREATE NONCLUSTERED INDEX x_grp_module_perm_idx_moduleid ON dbo.x_group_module_perm(module_id ASC) GO insert into x_portal_user (create_time,update_time,first_name,last_name,pub_scr_name,login_id,password,email,status) values (GETDATE(),GETDATE(),'Admin','','Admin','admin','ceb4f32325eda6142bd65215f4c0f371','',1) GO insert into x_portal_user_role (create_time,update_time,user_id,user_role,status) values (GETDATE(),GETDATE(),1,'ROLE_SYS_ADMIN',1) GO insert into x_user (create_time,update_time,user_name,status,descr) values (GETDATE(),GETDATE(),'admin',0,'Administrator') GO insert into x_group (added_by_id,create_time,descr,group_type,group_name,status,update_time,upd_by_id) values (1,GETDATE(),'public group',0,'public',0,GETDATE(),1) GO INSERT INTO x_modules_master(create_time,update_time,added_by_id,upd_by_id,module,url) VALUES(GETDATE(),GETDATE(),1,1,'Resource Based Policies','') GO INSERT INTO x_modules_master(create_time,update_time,added_by_id,upd_by_id,module,url) VALUES(GETDATE(),GETDATE(),1,1,'Users/Groups','') GO INSERT INTO x_modules_master(create_time,update_time,added_by_id,upd_by_id,module,url) VALUES(GETDATE(),GETDATE(),1,1,'Reports','') GO INSERT INTO x_modules_master(create_time,update_time,added_by_id,upd_by_id,module,url) VALUES(GETDATE(),GETDATE(),1,1,'Audit','') GO INSERT INTO x_modules_master(create_time,update_time,added_by_id,upd_by_id,module,url) VALUES(GETDATE(),GETDATE(),1,1,'Key Manager','') GO insert into x_portal_user (create_time,update_time,first_name,last_name,pub_scr_name,login_id,password,email,status) values (GETDATE(),GETDATE(),'rangerusersync','','rangerusersync','rangerusersync','70b8374d3dfe0325aaa5002a688c7e3b','rangerusersync',1) GO insert into x_portal_user_role (create_time,update_time,user_id,user_role,status) values (GETDATE(),GETDATE(),2,'ROLE_SYS_ADMIN',1) GO insert into x_user (create_time,update_time,user_name,status,descr) values (GETDATE(),GETDATE(),'rangerusersync',0,'rangerusersync') GO insert into x_portal_user (create_time,update_time,first_name,last_name,pub_scr_name,login_id,password,email,status) values (GETDATE(),GETDATE(),'keyadmin','','keyadmin','keyadmin','a05f34d2dce2b4688fa82e82a89ba958','keyadmin',1) GO insert into x_portal_user_role (create_time,update_time,user_id,user_role,status) values (GETDATE(),GETDATE(),3,'ROLE_KEY_ADMIN',1) GO insert into x_user (create_time,update_time,user_name,status,descr) values (GETDATE(),GETDATE(),'keyadmin',0,'keyadmin') GO exit

security-admin/db/sqlanywhere/xa_core_db_sqlanywhere.sql (1,092 lines of code) (raw):