security-admin/db/mysql/init/schema_mysql.sql

-- 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.


SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

drop table if exists x_db_base;
create table x_db_base (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_auth_sess;
create table x_auth_sess (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	login_id VARCHAR  (767)  NOT NULL,
	user_id BIGINT  ,
	ext_sess_id VARCHAR  (512) ,
	auth_time DATETIME   NOT NULL,
	auth_status INT   NOT NULL DEFAULT 0,
	auth_type INT   NOT NULL DEFAULT 0,
	auth_provider INT   NOT NULL DEFAULT 0,
	device_type INT   NOT NULL DEFAULT 0,
	req_ip VARCHAR  (48)  NOT NULL,
	req_ua VARCHAR  (1024) ,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_portal_user;
create table x_portal_user (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	first_name VARCHAR  (1022) ,
	last_name VARCHAR  (1022) ,
	pub_scr_name VARCHAR  (2048) ,
	login_id VARCHAR  (767) ,
	password VARCHAR  (512)  NOT NULL,
	email VARCHAR  (512) ,
	status INT   NOT NULL DEFAULT 0,
	user_src INT   NOT NULL DEFAULT 0,
	notes VARCHAR  (4000) ,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_portal_user_role;
create table x_portal_user_role (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	user_id BIGINT   NOT NULL,
	user_role VARCHAR  (128) ,
	status INT   NOT NULL DEFAULT 0,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_asset;
create table x_asset (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	asset_name VARCHAR  (1024)  NOT NULL,
	descr VARCHAR  (4000)  NOT NULL,
	act_status INT   NOT NULL DEFAULT 0,
	asset_type INT   NOT NULL DEFAULT 0,
	config TEXT  ,
	sup_native TINYINT  (1)  NOT NULL DEFAULT 0,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_resource;
create table x_resource (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	res_name VARCHAR  (4000) ,
	descr VARCHAR  (4000) ,
	res_type INT   NOT NULL DEFAULT 0,
	asset_id BIGINT   NOT NULL,
	parent_id BIGINT  ,
	parent_path VARCHAR  (4000) ,
	is_encrypt INT   NOT NULL DEFAULT 0,
	is_recursive INT   NOT NULL DEFAULT 0,
	res_group VARCHAR  (1024) ,
	res_dbs TEXT  ,
	res_tables TEXT  ,
	res_col_fams TEXT  ,
	res_cols TEXT  ,
	res_udfs TEXT  ,
	res_status INT   NOT NULL DEFAULT 1,
	table_type INT   NOT NULL DEFAULT 0,
	col_type INT   NOT NULL DEFAULT 0,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_cred_store;
create table x_cred_store (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	store_name VARCHAR  (1024)  NOT NULL,
	descr VARCHAR  (4000)  NOT NULL,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_group;
create table x_group (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	group_name VARCHAR  (1024)  NOT NULL,
	descr VARCHAR  (4000)  NOT NULL,
	status INT   NOT NULL DEFAULT 0,
	group_type INT   NOT NULL DEFAULT 0,
	cred_store_id BIGINT  ,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_user;
create table x_user (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	user_name VARCHAR  (1024)  NOT NULL,
	descr VARCHAR  (4000)  NOT NULL,
	status INT   NOT NULL DEFAULT 0,
	cred_store_id BIGINT  ,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_group_users;
create table x_group_users (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	group_name VARCHAR  (1024)  NOT NULL,
	p_group_id BIGINT  ,
	user_id BIGINT  ,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_group_groups;
create table x_group_groups (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	group_name VARCHAR  (1024)  NOT NULL,
	p_group_id BIGINT  ,
	group_id BIGINT  ,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_perm_map;
create table x_perm_map (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	perm_group VARCHAR  (1024) ,
	res_id BIGINT  ,
	group_id BIGINT  ,
	user_id BIGINT  ,
	perm_for INT   NOT NULL DEFAULT 0,
	perm_type INT   NOT NULL DEFAULT 0,
	is_recursive INT   NOT NULL DEFAULT 0,
	is_wild_card TINYINT  (1)  NOT NULL DEFAULT 1,
	grant_revoke TINYINT  (1)  NOT NULL DEFAULT 1,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_audit_map;
create table x_audit_map (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	res_id BIGINT  ,
	group_id BIGINT  ,
	user_id BIGINT  ,
	audit_type INT   NOT NULL DEFAULT 0,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_policy_export_audit;
create table x_policy_export_audit (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	client_ip VARCHAR  (255)  NOT NULL,
	agent_id VARCHAR  (255) ,
	req_epoch BIGINT   NOT NULL,
	last_updated DATETIME  ,
	repository_name VARCHAR  (1024) ,
	exported_json TEXT  ,
	http_ret_code INT   NOT NULL DEFAULT 0,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists x_trx_log;
create table x_trx_log (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	class_type INT   NOT NULL DEFAULT 0,
	object_id BIGINT  ,
	parent_object_id BIGINT  ,
	parent_object_class_type INT   NOT NULL DEFAULT 0,
	parent_object_name VARCHAR  (1024) ,
	object_name VARCHAR  (1024) ,
	attr_name VARCHAR  (255) ,
	prev_val VARCHAR  (1024) ,
	new_val VARCHAR  (1024) ,
	trx_id VARCHAR  (1024) ,
	action VARCHAR  (255) ,
	sess_id VARCHAR  (512) ,
	req_id VARCHAR  (30) ,
	sess_type VARCHAR  (30) ,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

drop table if exists xa_access_audit;
create table xa_access_audit (
	id BIGINT   NOT NULL AUTO_INCREMENT,
	create_time DATETIME  ,
	update_time DATETIME  ,
	added_by_id BIGINT  ,
	upd_by_id BIGINT  ,
	audit_type INT   NOT NULL DEFAULT 0,
	access_result INT   DEFAULT 0,
	access_type VARCHAR  (255) ,
	acl_enforcer VARCHAR  (255) ,
	agent_id VARCHAR  (255) ,
	client_ip VARCHAR  (255) ,
	client_type VARCHAR  (255) ,
	policy_id BIGINT   DEFAULT 0,
	repo_name VARCHAR  (255) ,
	repo_type INT   DEFAULT 0,
	result_reason VARCHAR  (255) ,
	session_id VARCHAR  (255) ,
	event_time DATETIME  ,
	request_user VARCHAR  (255) ,
	action VARCHAR  (2000) ,
	request_data VARCHAR  (2000) ,
	resource_path VARCHAR  (2000) ,
	resource_type VARCHAR  (255) ,
	PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


ALTER TABLE x_db_base ADD (
  CONSTRAINT x_db_base_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_db_base ADD (
  CONSTRAINT x_db_base_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_auth_sess ADD (
  CONSTRAINT x_auth_sess_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_auth_sess ADD (
  CONSTRAINT x_auth_sess_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_auth_sess ADD (
  CONSTRAINT x_auth_sess_FK_user_id FOREIGN KEY (user_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_portal_user ADD (
  CONSTRAINT x_portal_user_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_portal_user ADD (
  CONSTRAINT x_portal_user_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_portal_user_role ADD (
  CONSTRAINT x_portal_user_role_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_portal_user_role ADD (
  CONSTRAINT x_portal_user_role_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_portal_user_role ADD (
  CONSTRAINT x_portal_user_role_FK_user_id FOREIGN KEY (user_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_asset ADD (
  CONSTRAINT x_asset_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_asset ADD (
  CONSTRAINT x_asset_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_resource ADD (
  CONSTRAINT x_resource_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_resource ADD (
  CONSTRAINT x_resource_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_resource ADD (
  CONSTRAINT x_resource_FK_asset_id FOREIGN KEY (asset_id)
    REFERENCES x_asset (id));
ALTER TABLE x_resource ADD (
  CONSTRAINT x_resource_FK_parent_id FOREIGN KEY (parent_id)
    REFERENCES x_resource (id));
ALTER TABLE x_cred_store ADD (
  CONSTRAINT x_cred_store_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_cred_store ADD (
  CONSTRAINT x_cred_store_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_group ADD (
  CONSTRAINT x_group_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_group ADD (
  CONSTRAINT x_group_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_group ADD (
  CONSTRAINT x_group_FK_cred_store_id FOREIGN KEY (cred_store_id)
    REFERENCES x_cred_store (id));
ALTER TABLE x_user ADD (
  CONSTRAINT x_user_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_user ADD (
  CONSTRAINT x_user_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_user ADD (
  CONSTRAINT x_user_FK_cred_store_id FOREIGN KEY (cred_store_id)
    REFERENCES x_cred_store (id));
ALTER TABLE x_group_users ADD (
  CONSTRAINT x_group_users_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_group_users ADD (
  CONSTRAINT x_group_users_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_group_users ADD (
  CONSTRAINT x_group_users_FK_p_group_id FOREIGN KEY (p_group_id)
    REFERENCES x_group (id));
ALTER TABLE x_group_users ADD (
  CONSTRAINT x_group_users_FK_user_id FOREIGN KEY (user_id)
    REFERENCES x_user (id));
ALTER TABLE x_group_groups ADD (
  CONSTRAINT x_group_groups_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_group_groups ADD (
  CONSTRAINT x_group_groups_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_group_groups ADD (
  CONSTRAINT x_group_groups_FK_p_group_id FOREIGN KEY (p_group_id)
    REFERENCES x_group (id));
ALTER TABLE x_group_groups ADD (
  CONSTRAINT x_group_groups_FK_group_id FOREIGN KEY (group_id)
    REFERENCES x_group (id));
ALTER TABLE x_perm_map ADD (
  CONSTRAINT x_perm_map_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_perm_map ADD (
  CONSTRAINT x_perm_map_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_perm_map ADD (
  CONSTRAINT x_perm_map_FK_res_id FOREIGN KEY (res_id)
    REFERENCES x_resource (id));
ALTER TABLE x_perm_map ADD (
  CONSTRAINT x_perm_map_FK_group_id FOREIGN KEY (group_id)
    REFERENCES x_group (id));
ALTER TABLE x_perm_map ADD (
  CONSTRAINT x_perm_map_FK_user_id FOREIGN KEY (user_id)
    REFERENCES x_user (id));
ALTER TABLE x_audit_map ADD (
  CONSTRAINT x_audit_map_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_audit_map ADD (
  CONSTRAINT x_audit_map_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_audit_map ADD (
  CONSTRAINT x_audit_map_FK_res_id FOREIGN KEY (res_id)
    REFERENCES x_resource (id));
ALTER TABLE x_audit_map ADD (
  CONSTRAINT x_audit_map_FK_group_id FOREIGN KEY (group_id)
    REFERENCES x_group (id));
ALTER TABLE x_audit_map ADD (
  CONSTRAINT x_audit_map_FK_user_id FOREIGN KEY (user_id)
    REFERENCES x_user (id));
ALTER TABLE x_policy_export_audit ADD (
  CONSTRAINT x_policy_export_audit_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_policy_export_audit ADD (
  CONSTRAINT x_policy_export_audit_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_trx_log ADD (
  CONSTRAINT x_trx_log_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE x_trx_log ADD (
  CONSTRAINT x_trx_log_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE xa_access_audit ADD (
  CONSTRAINT xa_access_audit_FK_added_by_id FOREIGN KEY (added_by_id)
    REFERENCES x_portal_user (id));
ALTER TABLE xa_access_audit ADD (
  CONSTRAINT xa_access_audit_FK_upd_by_id FOREIGN KEY (upd_by_id)
    REFERENCES x_portal_user (id));

ALTER TABLE x_portal_user ADD (
  CONSTRAINT x_portal_user_UK_login_id UNIQUE (login_id(767)) );
ALTER TABLE x_portal_user ADD (
  CONSTRAINT x_portal_user_UK_email UNIQUE (email(512)) );

ALTER TABLE x_db_base ADD (INDEX x_db_base_cr_time (create_time));
ALTER TABLE x_db_base ADD (INDEX x_db_base_up_time (update_time));
ALTER TABLE x_auth_sess ADD (INDEX x_auth_sess_cr_time (create_time));
ALTER TABLE x_auth_sess ADD (INDEX x_auth_sess_up_time (update_time));
ALTER TABLE x_portal_user ADD (INDEX x_portal_user_cr_time (create_time));
ALTER TABLE x_portal_user ADD (INDEX x_portal_user_up_time (update_time));
ALTER TABLE x_portal_user ADD (INDEX x_portal_user_name (first_name(767)));
ALTER TABLE x_portal_user ADD (INDEX x_portal_user_email (email(512)));
ALTER TABLE x_portal_user_role ADD (INDEX x_portal_user_role_cr_time (create_time));
ALTER TABLE x_portal_user_role ADD (INDEX x_portal_user_role_up_time (update_time));
ALTER TABLE x_asset ADD (INDEX x_asset_cr_time (create_time));
ALTER TABLE x_asset ADD (INDEX x_asset_up_time (update_time));
ALTER TABLE x_resource ADD (INDEX x_resource_cr_time (create_time));
ALTER TABLE x_resource ADD (INDEX x_resource_up_time (update_time));
ALTER TABLE x_cred_store ADD (INDEX x_cred_store_cr_time (create_time));
ALTER TABLE x_cred_store ADD (INDEX x_cred_store_up_time (update_time));
ALTER TABLE x_group ADD (INDEX x_group_cr_time (create_time));
ALTER TABLE x_group ADD (INDEX x_group_up_time (update_time));
ALTER TABLE x_user ADD (INDEX x_user_cr_time (create_time));
ALTER TABLE x_user ADD (INDEX x_user_up_time (update_time));
ALTER TABLE x_group_users ADD (INDEX x_group_users_cr_time (create_time));
ALTER TABLE x_group_users ADD (INDEX x_group_users_up_time (update_time));
ALTER TABLE x_group_groups ADD (INDEX x_group_groups_cr_time (create_time));
ALTER TABLE x_group_groups ADD (INDEX x_group_groups_up_time (update_time));
ALTER TABLE x_perm_map ADD (INDEX x_perm_map_cr_time (create_time));
ALTER TABLE x_perm_map ADD (INDEX x_perm_map_up_time (update_time));
ALTER TABLE x_audit_map ADD (INDEX x_audit_map_cr_time (create_time));
ALTER TABLE x_audit_map ADD (INDEX x_audit_map_up_time (update_time));
ALTER TABLE x_policy_export_audit ADD (INDEX x_policy_export_audit_cr_time (create_time));
ALTER TABLE x_policy_export_audit ADD (INDEX x_policy_export_audit_up_time (update_time));
ALTER TABLE x_trx_log ADD (INDEX x_trx_log_cr_time (create_time));
ALTER TABLE x_trx_log ADD (INDEX x_trx_log_up_time (update_time));
ALTER TABLE xa_access_audit ADD (INDEX xa_access_audit_cr_time (create_time));
ALTER TABLE xa_access_audit ADD (INDEX xa_access_audit_up_time (update_time));
SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
##champlain changes
ALTER TABLE  `x_group` ADD  `group_src` INT NOT NULL DEFAULT 0;
ALTER TABLE  `x_resource` ADD  `policy_name` VARCHAR( 500 ) NULL DEFAULT NULL;
ALTER TABLE  `x_resource` ADD UNIQUE  `x_resource_UK_policy_name` (  `policy_name` );
ALTER TABLE  `x_resource` ADD  `res_topologies` TEXT NULL DEFAULT NULL ;
ALTER TABLE  `x_resource` ADD  `res_services` TEXT NULL DEFAULT NULL;
ALTER TABLE  `x_perm_map` ADD  `ip_address` TEXT NULL DEFAULT NULL;
ALTER TABLE  `x_asset` CHANGE  `config`  `config` LONGTEXT NULL DEFAULT NULL ;