develop

分支 (2)

管理

管理

develop

master

iFramework-By-Jeesite-Eclipse
/
创建数据库列表.sql

SET SESSION FOREIGN_KEY_CHECKS=0;

/* Drop Indexes */

DROP INDEX ACT_FK_BYTEARR_DEPL ON act_ge_bytearray;
DROP INDEX ACT_IDX_HI_ACT_INST_END ON act_hi_actinst;
DROP INDEX ACT_IDX_HI_ACT_INST_EXEC ON act_hi_actinst;
DROP INDEX ACT_IDX_HI_ACT_INST_PROCINST ON act_hi_actinst;
DROP INDEX ACT_IDX_HI_ACT_INST_START ON act_hi_actinst;
DROP INDEX ACT_IDX_HI_DETAIL_ACT_INST ON act_hi_detail;
DROP INDEX ACT_IDX_HI_DETAIL_NAME ON act_hi_detail;
DROP INDEX ACT_IDX_HI_DETAIL_PROC_INST ON act_hi_detail;
DROP INDEX ACT_IDX_HI_DETAIL_TASK_ID ON act_hi_detail;
DROP INDEX ACT_IDX_HI_DETAIL_TIME ON act_hi_detail;
DROP INDEX ACT_IDX_HI_IDENT_LNK_PROCINST ON act_hi_identitylink;
DROP INDEX ACT_IDX_HI_IDENT_LNK_TASK ON act_hi_identitylink;
DROP INDEX ACT_IDX_HI_IDENT_LNK_USER ON act_hi_identitylink;
DROP INDEX ACT_IDX_HI_PRO_I_BUSKEY ON act_hi_procinst;
DROP INDEX ACT_IDX_HI_PRO_INST_END ON act_hi_procinst;
DROP INDEX ACT_IDX_HI_PROCVAR_NAME_TYPE ON act_hi_varinst;
DROP INDEX ACT_IDX_HI_PROCVAR_PROC_INST ON act_hi_varinst;
DROP INDEX ACT_FK_MEMB_GROUP ON act_id_membership;
DROP INDEX ACT_FK_MODEL_DEPLOYMENT ON act_re_model;
DROP INDEX ACT_FK_MODEL_SOURCE ON act_re_model;
DROP INDEX ACT_FK_MODEL_SOURCE_EXTRA ON act_re_model;
DROP INDEX ACT_UNIQ_PROCDEF ON act_re_procdef;
DROP INDEX ACT_FK_EVENT_EXEC ON act_ru_event_subscr;
DROP INDEX ACT_IDX_EVENT_SUBSCR_CONFIG_ ON act_ru_event_subscr;
DROP INDEX ACT_FK_EXE_PARENT ON act_ru_execution;
DROP INDEX ACT_FK_EXE_PROCDEF ON act_ru_execution;
DROP INDEX ACT_FK_EXE_PROCINST ON act_ru_execution;
DROP INDEX ACT_FK_EXE_SUPER ON act_ru_execution;
DROP INDEX ACT_IDX_EXEC_BUSKEY ON act_ru_execution;
DROP INDEX ACT_FK_IDL_PROCINST ON act_ru_identitylink;
DROP INDEX ACT_FK_TSKASS_TASK ON act_ru_identitylink;
DROP INDEX ACT_IDX_ATHRZ_PROCEDEF ON act_ru_identitylink;
DROP INDEX ACT_IDX_IDENT_LNK_GROUP ON act_ru_identitylink;
DROP INDEX ACT_IDX_IDENT_LNK_USER ON act_ru_identitylink;
DROP INDEX ACT_FK_JOB_EXCEPTION ON act_ru_job;
DROP INDEX ACT_FK_TASK_EXE ON act_ru_task;
DROP INDEX ACT_FK_TASK_PROCDEF ON act_ru_task;
DROP INDEX ACT_FK_TASK_PROCINST ON act_ru_task;
DROP INDEX ACT_IDX_TASK_CREATE ON act_ru_task;
DROP INDEX ACT_FK_VAR_BYTEARRAY ON act_ru_variable;
DROP INDEX ACT_FK_VAR_EXE ON act_ru_variable;
DROP INDEX ACT_FK_VAR_PROCINST ON act_ru_variable;
DROP INDEX ACT_IDX_VARIABLE_TASK_ID ON act_ru_variable;
DROP INDEX cms_article_category_id ON cms_article;
DROP INDEX cms_article_create_by ON cms_article;
DROP INDEX cms_article_del_flag ON cms_article;
DROP INDEX cms_article_keywords ON cms_article;
DROP INDEX cms_article_title ON cms_article;
DROP INDEX cms_article_update_date ON cms_article;
DROP INDEX cms_article_weight ON cms_article;
DROP INDEX cms_category_del_flag ON cms_category;
DROP INDEX cms_category_module ON cms_category;
DROP INDEX cms_category_name ON cms_category;
DROP INDEX cms_category_office_id ON cms_category;
DROP INDEX cms_category_parent_id ON cms_category;
DROP INDEX cms_category_site_id ON cms_category;
DROP INDEX cms_category_sort ON cms_category;
DROP INDEX cms_comment_category_id ON cms_comment;
DROP INDEX cms_comment_content_id ON cms_comment;
DROP INDEX cms_comment_status ON cms_comment;
DROP INDEX cms_guestbook_del_flag ON cms_guestbook;
DROP INDEX cms_link_category_id ON cms_link;
DROP INDEX cms_link_create_by ON cms_link;
DROP INDEX cms_link_del_flag ON cms_link;
DROP INDEX cms_link_title ON cms_link;
DROP INDEX cms_link_update_date ON cms_link;
DROP INDEX cms_link_weight ON cms_link;
DROP INDEX cms_site_del_flag ON cms_site;
DROP INDEX gen_scheme_del_flag ON gen_scheme;
DROP INDEX gen_table_del_flag ON gen_table;
DROP INDEX gen_table_name ON gen_table;
DROP INDEX gen_table_column_del_flag ON gen_table_column;
DROP INDEX gen_table_column_name ON gen_table_column;
DROP INDEX gen_table_column_sort ON gen_table_column;
DROP INDEX gen_table_column_table_id ON gen_table_column;
DROP INDEX gen_template_del_falg ON gen_template;
DROP INDEX oa_leave_create_by ON oa_leave;
DROP INDEX oa_leave_del_flag ON oa_leave;
DROP INDEX oa_leave_process_instance_id ON oa_leave;
DROP INDEX oa_notify_del_flag ON oa_notify;
DROP INDEX oa_notify_record_notify_id ON oa_notify_record;
DROP INDEX oa_notify_record_read_flag ON oa_notify_record;
DROP INDEX oa_notify_record_user_id ON oa_notify_record;
DROP INDEX OA_TEST_AUDIT_del_flag ON oa_test_audit;
DROP INDEX sys_area_del_flag ON sys_area;
DROP INDEX sys_area_parent_id ON sys_area;
DROP INDEX sys_dict_del_flag ON sys_dict;
DROP INDEX sys_dict_label ON sys_dict;
DROP INDEX sys_dict_value ON sys_dict;
DROP INDEX sys_log_create_by ON sys_log;
DROP INDEX sys_log_create_date ON sys_log;
DROP INDEX sys_log_request_uri ON sys_log;
DROP INDEX sys_log_type ON sys_log;
DROP INDEX sys_mdict_del_flag ON sys_mdict;
DROP INDEX sys_mdict_parent_id ON sys_mdict;
DROP INDEX sys_menu_del_flag ON sys_menu;
DROP INDEX sys_menu_parent_id ON sys_menu;
DROP INDEX sys_office_del_flag ON sys_office;
DROP INDEX sys_office_parent_id ON sys_office;
DROP INDEX sys_office_type ON sys_office;
DROP INDEX sys_role_del_flag ON sys_role;
DROP INDEX sys_role_enname ON sys_role;
DROP INDEX sys_user_company_id ON sys_user;
DROP INDEX sys_user_del_flag ON sys_user;
DROP INDEX sys_user_login_name ON sys_user;
DROP INDEX sys_user_office_id ON sys_user;
DROP INDEX sys_user_update_date ON sys_user;
DROP INDEX test_data_del_flag ON test_data;
DROP INDEX test_data_child_del_flag ON test_data_child;
DROP INDEX test_data_main_del_flag ON test_data_main;
DROP INDEX test_data_parent_id ON test_tree;
DROP INDEX test_tree_del_flag ON test_tree;


/* Drop Tables */

DROP TABLE IF EXISTS act_re_model;
DROP TABLE IF EXISTS act_ru_job;
DROP TABLE IF EXISTS act_ru_variable;
DROP TABLE IF EXISTS act_ge_bytearray;
DROP TABLE IF EXISTS act_ge_property;
DROP TABLE IF EXISTS act_hi_actinst;
DROP TABLE IF EXISTS act_hi_attachment;
DROP TABLE IF EXISTS act_hi_comment;
DROP TABLE IF EXISTS act_hi_detail;
DROP TABLE IF EXISTS act_hi_identitylink;
DROP TABLE IF EXISTS act_hi_procinst;
DROP TABLE IF EXISTS act_hi_taskinst;
DROP TABLE IF EXISTS act_hi_varinst;
DROP TABLE IF EXISTS act_id_membership;
DROP TABLE IF EXISTS act_id_group;
DROP TABLE IF EXISTS act_id_info;
DROP TABLE IF EXISTS act_id_user;
DROP TABLE IF EXISTS act_re_deployment;
DROP TABLE IF EXISTS act_ru_event_subscr;
DROP TABLE IF EXISTS act_ru_identitylink;
DROP TABLE IF EXISTS act_ru_task;
DROP TABLE IF EXISTS act_ru_execution;
DROP TABLE IF EXISTS act_re_procdef;
DROP TABLE IF EXISTS cms_article;
DROP TABLE IF EXISTS cms_article_data;
DROP TABLE IF EXISTS cms_db;
DROP TABLE IF EXISTS cms_bussines_system;
DROP TABLE IF EXISTS cms_category;
DROP TABLE IF EXISTS cms_comment;
DROP TABLE IF EXISTS cms_guestbook;
DROP TABLE IF EXISTS cms_link;
DROP TABLE IF EXISTS cms_site;
DROP TABLE IF EXISTS gen_scheme;
DROP TABLE IF EXISTS gen_table;
DROP TABLE IF EXISTS gen_table_column;
DROP TABLE IF EXISTS gen_template;
DROP TABLE IF EXISTS oa_leave;
DROP TABLE IF EXISTS oa_notify;
DROP TABLE IF EXISTS oa_notify_record;
DROP TABLE IF EXISTS oa_test_audit;
DROP TABLE IF EXISTS sys_area;
DROP TABLE IF EXISTS sys_dict;
DROP TABLE IF EXISTS sys_log;
DROP TABLE IF EXISTS sys_mdict;
DROP TABLE IF EXISTS sys_menu;
DROP TABLE IF EXISTS sys_office;
DROP TABLE IF EXISTS sys_role;
DROP TABLE IF EXISTS sys_role_menu;
DROP TABLE IF EXISTS sys_role_office;
DROP TABLE IF EXISTS sys_user;
DROP TABLE IF EXISTS sys_user_role;
DROP TABLE IF EXISTS test_data;
DROP TABLE IF EXISTS test_data_child;
DROP TABLE IF EXISTS test_data_main;
DROP TABLE IF EXISTS test_tree;


/* Create Tables */

CREATE TABLE act_ge_bytearray
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	NAME_ varchar(255) BINARY,
	DEPLOYMENT_ID_ varchar(64) BINARY,
	BYTES_ longblob,
	GENERATED_ tinyint,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_ge_property
(
	NAME_ varchar(64) BINARY NOT NULL,
	VALUE_ varchar(300) BINARY,
	REV_ int,
	PRIMARY KEY (NAME_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_hi_actinst
(
	ID_ varchar(64) BINARY NOT NULL,
	PROC_DEF_ID_ varchar(64) BINARY NOT NULL,
	PROC_INST_ID_ varchar(64) BINARY NOT NULL,
	EXECUTION_ID_ varchar(64) BINARY NOT NULL,
	ACT_ID_ varchar(255) BINARY NOT NULL,
	TASK_ID_ varchar(64) BINARY,
	CALL_PROC_INST_ID_ varchar(64) BINARY,
	ACT_NAME_ varchar(255) BINARY,
	ACT_TYPE_ varchar(255) BINARY NOT NULL,
	ASSIGNEE_ varchar(255) BINARY,
	START_TIME_ datetime NOT NULL,
	END_TIME_ datetime,
	DURATION_ bigint(20),
	TENANT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_hi_attachment
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	USER_ID_ varchar(255) BINARY,
	NAME_ varchar(255) BINARY,
	DESCRIPTION_ varchar(4000) BINARY,
	TYPE_ varchar(255) BINARY,
	TASK_ID_ varchar(64) BINARY,
	PROC_INST_ID_ varchar(64) BINARY,
	URL_ varchar(4000) BINARY,
	CONTENT_ID_ varchar(64) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_hi_comment
(
	ID_ varchar(64) BINARY NOT NULL,
	TYPE_ varchar(255) BINARY,
	TIME_ datetime NOT NULL,
	USER_ID_ varchar(255) BINARY,
	TASK_ID_ varchar(64) BINARY,
	PROC_INST_ID_ varchar(64) BINARY,
	ACTION_ varchar(255) BINARY,
	MESSAGE_ varchar(4000) BINARY,
	FULL_MSG_ longblob,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_hi_detail
(
	ID_ varchar(64) BINARY NOT NULL,
	TYPE_ varchar(255) BINARY NOT NULL,
	PROC_INST_ID_ varchar(64) BINARY,
	EXECUTION_ID_ varchar(64) BINARY,
	TASK_ID_ varchar(64) BINARY,
	ACT_INST_ID_ varchar(64) BINARY,
	NAME_ varchar(255) BINARY NOT NULL,
	VAR_TYPE_ varchar(255) BINARY,
	REV_ int,
	TIME_ datetime NOT NULL,
	BYTEARRAY_ID_ varchar(64) BINARY,
	DOUBLE_ double,
	LONG_ bigint(20),
	TEXT_ varchar(4000) BINARY,
	TEXT2_ varchar(4000) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_hi_identitylink
(
	ID_ varchar(64) BINARY NOT NULL,
	GROUP_ID_ varchar(255) BINARY,
	TYPE_ varchar(255) BINARY,
	USER_ID_ varchar(255) BINARY,
	TASK_ID_ varchar(64) BINARY,
	PROC_INST_ID_ varchar(64) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_hi_procinst
(
	ID_ varchar(64) BINARY NOT NULL,
	PROC_INST_ID_ varchar(64) BINARY NOT NULL,
	BUSINESS_KEY_ varchar(255) BINARY,
	PROC_DEF_ID_ varchar(64) BINARY NOT NULL,
	START_TIME_ datetime NOT NULL,
	END_TIME_ datetime,
	DURATION_ bigint(20),
	START_USER_ID_ varchar(255) BINARY,
	START_ACT_ID_ varchar(255) BINARY,
	END_ACT_ID_ varchar(255) BINARY,
	SUPER_PROCESS_INSTANCE_ID_ varchar(64) BINARY,
	DELETE_REASON_ varchar(4000) BINARY,
	TENANT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_),
	UNIQUE (PROC_INST_ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_hi_taskinst
(
	ID_ varchar(64) BINARY NOT NULL,
	PROC_DEF_ID_ varchar(64) BINARY,
	TASK_DEF_KEY_ varchar(255) BINARY,
	PROC_INST_ID_ varchar(64) BINARY,
	EXECUTION_ID_ varchar(64) BINARY,
	NAME_ varchar(255) BINARY,
	PARENT_TASK_ID_ varchar(64) BINARY,
	DESCRIPTION_ varchar(4000) BINARY,
	OWNER_ varchar(255) BINARY,
	ASSIGNEE_ varchar(255) BINARY,
	START_TIME_ datetime NOT NULL,
	CLAIM_TIME_ datetime,
	END_TIME_ datetime,
	DURATION_ bigint(20),
	DELETE_REASON_ varchar(4000) BINARY,
	PRIORITY_ int,
	DUE_DATE_ datetime,
	FORM_KEY_ varchar(255) BINARY,
	CATEGORY_ varchar(255) BINARY,
	TENANT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_hi_varinst
(
	ID_ varchar(64) BINARY NOT NULL,
	PROC_INST_ID_ varchar(64) BINARY,
	EXECUTION_ID_ varchar(64) BINARY,
	TASK_ID_ varchar(64) BINARY,
	NAME_ varchar(255) BINARY NOT NULL,
	VAR_TYPE_ varchar(100) BINARY,
	REV_ int,
	BYTEARRAY_ID_ varchar(64) BINARY,
	DOUBLE_ double,
	LONG_ bigint(20),
	TEXT_ varchar(4000) BINARY,
	TEXT2_ varchar(4000) BINARY,
	CREATE_TIME_ datetime,
	LAST_UPDATED_TIME_ datetime,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_id_group
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	NAME_ varchar(255) BINARY,
	TYPE_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_id_info
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	USER_ID_ varchar(64) BINARY,
	TYPE_ varchar(64) BINARY,
	KEY_ varchar(255) BINARY,
	VALUE_ varchar(255) BINARY,
	PASSWORD_ longblob,
	PARENT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_id_membership
(
	USER_ID_ varchar(64) BINARY NOT NULL,
	GROUP_ID_ varchar(64) BINARY NOT NULL,
	PRIMARY KEY (USER_ID_, GROUP_ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_id_user
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	FIRST_ varchar(255) BINARY,
	LAST_ varchar(255) BINARY,
	EMAIL_ varchar(255) BINARY,
	PWD_ varchar(255) BINARY,
	PICTURE_ID_ varchar(64) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_re_deployment
(
	ID_ varchar(64) BINARY NOT NULL,
	NAME_ varchar(255) BINARY,
	CATEGORY_ varchar(255) BINARY,
	TENANT_ID_ varchar(255) BINARY,
	DEPLOY_TIME_ timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_re_model
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	NAME_ varchar(255) BINARY,
	KEY_ varchar(255) BINARY,
	CATEGORY_ varchar(255) BINARY,
	CREATE_TIME_ timestamp,
	LAST_UPDATE_TIME_ timestamp,
	VERSION_ int,
	META_INFO_ varchar(4000) BINARY,
	DEPLOYMENT_ID_ varchar(64) BINARY,
	EDITOR_SOURCE_VALUE_ID_ varchar(64) BINARY,
	EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64) BINARY,
	TENANT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_re_procdef
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	CATEGORY_ varchar(255) BINARY,
	NAME_ varchar(255) BINARY,
	KEY_ varchar(255) BINARY NOT NULL,
	VERSION_ int NOT NULL,
	DEPLOYMENT_ID_ varchar(64) BINARY,
	RESOURCE_NAME_ varchar(4000) BINARY,
	DGRM_RESOURCE_NAME_ varchar(4000) BINARY,
	DESCRIPTION_ varchar(4000) BINARY,
	HAS_START_FORM_KEY_ tinyint,
	SUSPENSION_STATE_ int,
	TENANT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_ru_event_subscr
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	EVENT_TYPE_ varchar(255) BINARY NOT NULL,
	EVENT_NAME_ varchar(255) BINARY,
	EXECUTION_ID_ varchar(64) BINARY,
	PROC_INST_ID_ varchar(64) BINARY,
	ACTIVITY_ID_ varchar(64) BINARY,
	CONFIGURATION_ varchar(255) BINARY,
	CREATED_ timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
	PROC_DEF_ID_ varchar(64) BINARY,
	TENANT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_ru_execution
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	PROC_INST_ID_ varchar(64) BINARY,
	BUSINESS_KEY_ varchar(255) BINARY,
	PARENT_ID_ varchar(64) BINARY,
	PROC_DEF_ID_ varchar(64) BINARY,
	SUPER_EXEC_ varchar(64) BINARY,
	ACT_ID_ varchar(255) BINARY,
	IS_ACTIVE_ tinyint,
	IS_CONCURRENT_ tinyint,
	IS_SCOPE_ tinyint,
	IS_EVENT_SCOPE_ tinyint,
	SUSPENSION_STATE_ int,
	CACHED_ENT_STATE_ int,
	TENANT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_ru_identitylink
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	GROUP_ID_ varchar(255) BINARY,
	TYPE_ varchar(255) BINARY,
	USER_ID_ varchar(255) BINARY,
	TASK_ID_ varchar(64) BINARY,
	PROC_INST_ID_ varchar(64) BINARY,
	PROC_DEF_ID_ varchar(64) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_ru_job
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	TYPE_ varchar(255) BINARY NOT NULL,
	LOCK_EXP_TIME_ timestamp,
	LOCK_OWNER_ varchar(255) BINARY,
	EXCLUSIVE_ boolean,
	EXECUTION_ID_ varchar(64) BINARY,
	PROCESS_INSTANCE_ID_ varchar(64) BINARY,
	PROC_DEF_ID_ varchar(64) BINARY,
	RETRIES_ int,
	EXCEPTION_STACK_ID_ varchar(64) BINARY,
	EXCEPTION_MSG_ varchar(4000) BINARY,
	DUEDATE_ timestamp,
	REPEAT_ varchar(255) BINARY,
	HANDLER_TYPE_ varchar(255) BINARY,
	HANDLER_CFG_ varchar(4000) BINARY,
	TENANT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_ru_task
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	EXECUTION_ID_ varchar(64) BINARY,
	PROC_INST_ID_ varchar(64) BINARY,
	PROC_DEF_ID_ varchar(64) BINARY,
	NAME_ varchar(255) BINARY,
	PARENT_TASK_ID_ varchar(64) BINARY,
	DESCRIPTION_ varchar(4000) BINARY,
	TASK_DEF_KEY_ varchar(255) BINARY,
	OWNER_ varchar(255) BINARY,
	ASSIGNEE_ varchar(255) BINARY,
	DELEGATION_ varchar(64) BINARY,
	PRIORITY_ int,
	CREATE_TIME_ timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
	DUE_DATE_ datetime,
	CATEGORY_ varchar(255) BINARY,
	SUSPENSION_STATE_ int,
	TENANT_ID_ varchar(255) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE act_ru_variable
(
	ID_ varchar(64) BINARY NOT NULL,
	REV_ int,
	TYPE_ varchar(255) BINARY NOT NULL,
	NAME_ varchar(255) BINARY NOT NULL,
	EXECUTION_ID_ varchar(64) BINARY,
	PROC_INST_ID_ varchar(64) BINARY,
	TASK_ID_ varchar(64) BINARY,
	BYTEARRAY_ID_ varchar(64) BINARY,
	DOUBLE_ double,
	LONG_ bigint(20),
	TEXT_ varchar(4000) BINARY,
	TEXT2_ varchar(4000) BINARY,
	PRIMARY KEY (ID_)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;


CREATE TABLE cms_article
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鏍忕洰缂栧彿
	category_id varchar(64) NOT NULL COMMENT '鏍忕洰缂栧彿',
	-- 鏍囬
	title varchar(255) NOT NULL COMMENT '鏍囬',
	-- 鏂囩珷閾炬帴
	link varchar(255) COMMENT '鏂囩珷閾炬帴',
	-- 鏍囬棰滆壊
	color varchar(50) COMMENT '鏍囬棰滆壊',
	-- 鏂囩珷鍥剧墖
	image varchar(255) COMMENT '鏂囩珷鍥剧墖',
	-- 鍏抽敭瀛�	keywords varchar(255) COMMENT '鍏抽敭瀛�,
	-- 鎻忚堪銆佹憳瑕�	description varchar(255) COMMENT '鎻忚堪銆佹憳瑕�,
	-- 鏉冮噸锛岃秺澶ц秺闈犲墠
	weight int DEFAULT 0 COMMENT '鏉冮噸锛岃秺澶ц秺闈犲墠',
	-- 鏉冮噸鏈熼檺
	weight_date datetime COMMENT '鏉冮噸鏈熼檺',
	-- 鐐瑰嚮鏁�	hits int DEFAULT 0 COMMENT '鐐瑰嚮鏁�,
	-- 鎺ㄨ崘浣嶏紝澶氶�
	posid varchar(10) COMMENT '鎺ㄨ崘浣嶏紝澶氶�',
	-- 鑷畾涔夊唴瀹硅鍥�	custom_content_view varchar(255) COMMENT '鑷畾涔夊唴瀹硅鍥�,
	-- 瑙嗗浘閰嶇疆
	view_config text COMMENT '瑙嗗浘閰嶇疆',
	-- 鍒涘缓鑰�	create_by varchar(64) COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE cms_article_data
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鏂囩珷鍐呭
	content text COMMENT '鏂囩珷鍐呭',
	-- 鏂囩珷鏉ユ簮
	copyfrom varchar(255) COMMENT '鏂囩珷鏉ユ簮',
	-- 鐩稿叧鏂囩珷
	relation varchar(255) COMMENT '鐩稿叧鏂囩珷',
	-- 鏄惁鍏佽璇勮
	allow_comment char COMMENT '鏄惁鍏佽璇勮',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE cms_bussines_system
(
	-- 涓氬姟绯荤粺缂栧彿
	buss_sys_id varchar(64) NOT NULL COMMENT '涓氬姟绯荤粺缂栧彿',
	-- 涓氬姟绯荤粺鍚嶇О
	name text NOT NULL COMMENT '涓氬姟绯荤粺鍚嶇О',
	-- 绯荤粺寮�彂鍏徃
	company text NOT NULL COMMENT '绯荤粺寮�彂鍏徃',
	-- 缁存姢浜哄憳
	maintenance_personnel text COMMENT '缁存姢浜哄憳',
	-- 缁存姢鑱旂郴鐢佃瘽
	Maintenance_call varchar(64) COMMENT '缁存姢鑱旂郴鐢佃瘽',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
	PRIMARY KEY (buss_sys_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE cms_category
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鐖剁骇缂栧彿
	parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
	-- 鎵�湁鐖剁骇缂栧彿
	parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
	-- 绔欑偣缂栧彿
	site_id varchar(64) DEFAULT '1' COMMENT '绔欑偣缂栧彿',
	-- 褰掑睘鏈烘瀯
	office_id varchar(64) COMMENT '褰掑睘鏈烘瀯',
	-- 鏍忕洰妯″潡
	module varchar(20) COMMENT '鏍忕洰妯″潡',
	-- 鏍忕洰鍚嶇О
	name varchar(100) NOT NULL COMMENT '鏍忕洰鍚嶇О',
	-- 鏍忕洰鍥剧墖
	image varchar(255) COMMENT '鏍忕洰鍥剧墖',
	-- 閾炬帴
	href varchar(255) COMMENT '閾炬帴',
	-- 鐩爣
	target varchar(20) COMMENT '鐩爣',
	-- 鎻忚堪
	description varchar(255) COMMENT '鎻忚堪',
	-- 鍏抽敭瀛�	keywords varchar(255) COMMENT '鍏抽敭瀛�,
	-- 鎺掑簭锛堝崌搴忥級
	sort int DEFAULT 30 COMMENT '鎺掑簭锛堝崌搴忥級',
	-- 鏄惁鍦ㄥ鑸腑鏄剧ず
	in_menu char DEFAULT '1' COMMENT '鏄惁鍦ㄥ鑸腑鏄剧ず',
	-- 鏄惁鍦ㄥ垎绫婚〉涓樉绀哄垪琛�	in_list char DEFAULT '1' COMMENT '鏄惁鍦ㄥ垎绫婚〉涓樉绀哄垪琛�,
	-- 灞曠幇鏂瑰紡
	show_modes char DEFAULT '0' COMMENT '灞曠幇鏂瑰紡',
	-- 鏄惁鍏佽璇勮
	allow_comment char COMMENT '鏄惁鍏佽璇勮',
	-- 鏄惁闇�瀹℃牳
	is_audit char COMMENT '鏄惁闇�瀹℃牳',
	-- 鑷畾涔夊垪琛ㄨ鍥�	custom_list_view varchar(255) COMMENT '鑷畾涔夊垪琛ㄨ鍥�,
	-- 鑷畾涔夊唴瀹硅鍥�	custom_content_view varchar(255) COMMENT '鑷畾涔夊唴瀹硅鍥�,
	-- 瑙嗗浘閰嶇疆
	view_config text COMMENT '瑙嗗浘閰嶇疆',
	-- 鍒涘缓鑰�	create_by varchar(64) COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE cms_comment
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鏍忕洰缂栧彿
	category_id varchar(64) NOT NULL COMMENT '鏍忕洰缂栧彿',
	-- 鏍忕洰鍐呭鐨勭紪鍙�	content_id varchar(64) NOT NULL COMMENT '鏍忕洰鍐呭鐨勭紪鍙�,
	-- 鏍忕洰鍐呭鐨勬爣棰�	title varchar(255) COMMENT '鏍忕洰鍐呭鐨勬爣棰�,
	-- 璇勮鍐呭
	content varchar(255) COMMENT '璇勮鍐呭',
	-- 璇勮濮撳悕
	name varchar(100) COMMENT '璇勮濮撳悕',
	-- 璇勮IP
	ip varchar(100) COMMENT '璇勮IP',
	-- 璇勮鏃堕棿
	create_date datetime NOT NULL COMMENT '璇勮鏃堕棿',
	-- 瀹℃牳浜�	audit_user_id varchar(64) COMMENT '瀹℃牳浜�,
	-- 瀹℃牳鏃堕棿
	audit_date datetime COMMENT '瀹℃牳鏃堕棿',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE cms_db
(
	-- 鏁版嵁搴撶紪鍙�	db_id varchar(64) NOT NULL COMMENT '鏁版嵁搴撶紪鍙�,
	-- 鍚嶇О
	name text NOT NULL COMMENT '鍚嶇О',
	-- 绫诲瀷
	type int NOT NULL COMMENT '绫诲瀷',
	-- 鎿嶄綔绯荤粺绫诲瀷
	system_type int NOT NULL COMMENT '鎿嶄綔绯荤粺绫诲瀷',
	-- 寤哄簱鏃堕棿
	construction_time datetime NOT NULL COMMENT '寤哄簱鏃堕棿',
	-- 鏈�悗鎿嶄綔鏃堕棿
	last_action_time datetime COMMENT '鏈�悗鎿嶄綔鏃堕棿',
	-- 閰嶇疆鏂囦欢璺緞
	profile_path longtext NOT NULL COMMENT '閰嶇疆鏂囦欢璺緞',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
	-- 涓氬姟绯荤粺缂栧彿
	buss_sys_id varchar(64) NOT NULL COMMENT '涓氬姟绯荤粺缂栧彿',
	PRIMARY KEY (db_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE cms_guestbook
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鐣欒█鍒嗙被
	type char NOT NULL COMMENT '鐣欒█鍒嗙被',
	-- 鐣欒█鍐呭
	content varchar(255) NOT NULL COMMENT '鐣欒█鍐呭',
	-- 濮撳悕
	name varchar(100) NOT NULL COMMENT '濮撳悕',
	-- 閭
	email varchar(100) NOT NULL COMMENT '閭',
	-- 鐢佃瘽
	phone varchar(100) NOT NULL COMMENT '鐢佃瘽',
	-- 鍗曚綅
	workunit varchar(100) NOT NULL COMMENT '鍗曚綅',
	-- IP
	ip varchar(100) NOT NULL COMMENT 'IP',
	-- 鐣欒█鏃堕棿
	create_date datetime NOT NULL COMMENT '鐣欒█鏃堕棿',
	-- 鍥炲浜�	re_user_id varchar(64) COMMENT '鍥炲浜�,
	-- 鍥炲鏃堕棿
	re_date datetime COMMENT '鍥炲鏃堕棿',
	-- 鍥炲鍐呭
	re_content varchar(100) COMMENT '鍥炲鍐呭',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE cms_link
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鏍忕洰缂栧彿
	category_id varchar(64) NOT NULL COMMENT '鏍忕洰缂栧彿',
	-- 閾炬帴鍚嶇О
	title varchar(255) NOT NULL COMMENT '閾炬帴鍚嶇О',
	-- 鏍囬棰滆壊
	color varchar(50) COMMENT '鏍囬棰滆壊',
	-- 閾炬帴鍥剧墖
	image varchar(255) COMMENT '閾炬帴鍥剧墖',
	-- 閾炬帴鍦板潃
	href varchar(255) COMMENT '閾炬帴鍦板潃',
	-- 鏉冮噸锛岃秺澶ц秺闈犲墠
	weight int DEFAULT 0 COMMENT '鏉冮噸锛岃秺澶ц秺闈犲墠',
	-- 鏉冮噸鏈熼檺
	weight_date datetime COMMENT '鏉冮噸鏈熼檺',
	-- 鍒涘缓鑰�	create_by varchar(64) COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE cms_site
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 绔欑偣鍚嶇О
	name varchar(100) NOT NULL COMMENT '绔欑偣鍚嶇О',
	-- 绔欑偣鏍囬
	title varchar(100) NOT NULL COMMENT '绔欑偣鏍囬',
	-- 绔欑偣Logo
	logo varchar(255) COMMENT '绔欑偣Logo',
	-- 绔欑偣鍩熷悕
	domain varchar(255) COMMENT '绔欑偣鍩熷悕',
	-- 鎻忚堪
	description varchar(255) COMMENT '鎻忚堪',
	-- 鍏抽敭瀛�	keywords varchar(255) COMMENT '鍏抽敭瀛�,
	-- 涓婚
	theme varchar(255) DEFAULT 'default' COMMENT '涓婚',
	-- 鐗堟潈淇℃伅
	copyright text COMMENT '鐗堟潈淇℃伅',
	-- 鑷畾涔夌珯鐐归椤佃鍥�	custom_index_view varchar(255) COMMENT '鑷畾涔夌珯鐐归椤佃鍥�,
	-- 鍒涘缓鑰�	create_by varchar(64) COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE gen_scheme
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鍚嶇О
	name varchar(200) COMMENT '鍚嶇О',
	-- 鍒嗙被
	category varchar(2000) COMMENT '鍒嗙被',
	-- 鐢熸垚鍖呰矾寰�	package_name varchar(500) COMMENT '鐢熸垚鍖呰矾寰�,
	-- 鐢熸垚妯″潡鍚�	module_name varchar(30) COMMENT '鐢熸垚妯″潡鍚�,
	-- 鐢熸垚瀛愭ā鍧楀悕
	sub_module_name varchar(30) COMMENT '鐢熸垚瀛愭ā鍧楀悕',
	-- 鐢熸垚鍔熻兘鍚�	function_name varchar(500) COMMENT '鐢熸垚鍔熻兘鍚�,
	-- 鐢熸垚鍔熻兘鍚嶏紙绠�啓锛�	function_name_simple varchar(100) COMMENT '鐢熸垚鍔熻兘鍚嶏紙绠�啓锛�,
	-- 鐢熸垚鍔熻兘浣滆�
	function_author varchar(100) COMMENT '鐢熸垚鍔熻兘浣滆�',
	-- 鐢熸垚琛ㄧ紪鍙�	gen_table_id varchar(200) COMMENT '鐢熸垚琛ㄧ紪鍙�,
	-- 鍒涘缓鑰�	create_by varchar(64) COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE gen_table
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鍚嶇О
	name varchar(200) COMMENT '鍚嶇О',
	-- 鎻忚堪
	comments varchar(500) COMMENT '鎻忚堪',
	-- 瀹炰綋绫诲悕绉�	class_name varchar(100) COMMENT '瀹炰綋绫诲悕绉�,
	-- 鍏宠仈鐖惰〃
	parent_table varchar(200) COMMENT '鍏宠仈鐖惰〃',
	-- 鍏宠仈鐖惰〃澶栭敭
	parent_table_fk varchar(100) COMMENT '鍏宠仈鐖惰〃澶栭敭',
	-- 鍒涘缓鑰�	create_by varchar(64) COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE gen_table_column
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 褰掑睘琛ㄧ紪鍙�	gen_table_id varchar(64) COMMENT '褰掑睘琛ㄧ紪鍙�,
	-- 鍚嶇О
	name varchar(200) COMMENT '鍚嶇О',
	-- 鎻忚堪
	comments varchar(500) COMMENT '鎻忚堪',
	-- 鍒楃殑鏁版嵁绫诲瀷鐨勫瓧鑺傞暱搴�	jdbc_type varchar(100) COMMENT '鍒楃殑鏁版嵁绫诲瀷鐨勫瓧鑺傞暱搴�,
	-- JAVA绫诲瀷
	java_type varchar(500) COMMENT 'JAVA绫诲瀷',
	-- JAVA瀛楁鍚�	java_field varchar(200) COMMENT 'JAVA瀛楁鍚�,
	-- 鏄惁涓婚敭
	is_pk char COMMENT '鏄惁涓婚敭',
	-- 鏄惁鍙负绌�	is_null char COMMENT '鏄惁鍙负绌�,
	-- 鏄惁涓烘彃鍏ュ瓧娈�	is_insert char COMMENT '鏄惁涓烘彃鍏ュ瓧娈�,
	-- 鏄惁缂栬緫瀛楁
	is_edit char COMMENT '鏄惁缂栬緫瀛楁',
	-- 鏄惁鍒楄〃瀛楁
	is_list char COMMENT '鏄惁鍒楄〃瀛楁',
	-- 鏄惁鏌ヨ瀛楁
	is_query char COMMENT '鏄惁鏌ヨ瀛楁',
	-- 鏌ヨ鏂瑰紡锛堢瓑浜庛�涓嶇瓑浜庛�澶т簬銆佸皬浜庛�鑼冨洿銆佸乏LIKE銆佸彸LIKE銆佸乏鍙矻IKE锛�	query_type varchar(200) COMMENT '鏌ヨ鏂瑰紡锛堢瓑浜庛�涓嶇瓑浜庛�澶т簬銆佸皬浜庛�鑼冨洿銆佸乏LIKE銆佸彸LIKE銆佸乏鍙矻IKE锛�,
	-- 瀛楁鐢熸垚鏂规锛堟枃鏈銆佹枃鏈煙銆佷笅鎷夋銆佸閫夋銆佸崟閫夋銆佸瓧鍏搁�鎷┿�浜哄憳閫夋嫨銆侀儴闂ㄩ�鎷┿�鍖哄煙閫夋嫨锛�	show_type varchar(200) COMMENT '瀛楁鐢熸垚鏂规锛堟枃鏈銆佹枃鏈煙銆佷笅鎷夋銆佸閫夋銆佸崟閫夋銆佸瓧鍏搁�鎷┿�浜哄憳閫夋嫨銆侀儴闂ㄩ�鎷┿�鍖哄煙閫夋嫨锛�,
	-- 瀛楀吀绫诲瀷
	dict_type varchar(200) COMMENT '瀛楀吀绫诲瀷',
	-- 鍏跺畠璁剧疆锛堟墿灞曞瓧娈礘SON锛�	settings varchar(2000) COMMENT '鍏跺畠璁剧疆锛堟墿灞曞瓧娈礘SON锛�,
	-- 鎺掑簭锛堝崌搴忥級
	sort decimal COMMENT '鎺掑簭锛堝崌搴忥級',
	-- 鍒涘缓鑰�	create_by varchar(64) COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE gen_template
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鍚嶇О
	name varchar(200) COMMENT '鍚嶇О',
	-- 鍒嗙被
	category varchar(2000) COMMENT '鍒嗙被',
	-- 鐢熸垚鏂囦欢璺緞
	file_path varchar(500) COMMENT '鐢熸垚鏂囦欢璺緞',
	-- 鐢熸垚鏂囦欢鍚�	file_name varchar(200) COMMENT '鐢熸垚鏂囦欢鍚�,
	-- 鍐呭
	content text COMMENT '鍐呭',
	-- 鍒涘缓鑰�	create_by varchar(64) COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪锛�锛氭甯革紱1锛氬垹闄わ級',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE oa_leave
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 娴佺▼瀹炰緥缂栧彿
	process_instance_id varchar(64) COMMENT '娴佺▼瀹炰緥缂栧彿',
	-- 寮�鏃堕棿
	start_time datetime COMMENT '寮�鏃堕棿',
	-- 缁撴潫鏃堕棿
	end_time datetime COMMENT '缁撴潫鏃堕棿',
	-- 璇峰亣绫诲瀷
	leave_type varchar(20) COMMENT '璇峰亣绫诲瀷',
	-- 璇峰亣鐞嗙敱
	reason varchar(255) COMMENT '璇峰亣鐞嗙敱',
	-- 鐢宠鏃堕棿
	apply_time datetime COMMENT '鐢宠鏃堕棿',
	-- 瀹為檯寮�鏃堕棿
	reality_start_time datetime COMMENT '瀹為檯寮�鏃堕棿',
	-- 瀹為檯缁撴潫鏃堕棿
	reality_end_time datetime COMMENT '瀹為檯缁撴潫鏃堕棿',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE oa_notify
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 绫诲瀷
	type char COMMENT '绫诲瀷',
	-- 鏍囬
	title varchar(200) COMMENT '鏍囬',
	-- 鍐呭
	content varchar(2000) COMMENT '鍐呭',
	-- 闄勪欢
	files varchar(2000) COMMENT '闄勪欢',
	-- 鐘舵�
	status char COMMENT '鐘舵�',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE oa_notify_record
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 閫氱煡閫氬憡ID
	oa_notify_id varchar(64) COMMENT '閫氱煡閫氬憡ID',
	-- 鎺ュ彈浜�	user_id varchar(64) COMMENT '鎺ュ彈浜�,
	-- 闃呰鏍囪
	read_flag char DEFAULT '0' COMMENT '闃呰鏍囪',
	-- 闃呰鏃堕棿
	read_date date COMMENT '闃呰鏃堕棿',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE oa_test_audit
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 娴佺▼瀹炰緥ID
	PROC_INS_ID varchar(64) COMMENT '娴佺▼瀹炰緥ID',
	-- 鍙樺姩鐢ㄦ埛
	USER_ID varchar(64) COMMENT '鍙樺姩鐢ㄦ埛',
	-- 褰掑睘閮ㄩ棬
	OFFICE_ID varchar(64) COMMENT '褰掑睘閮ㄩ棬',
	-- 宀椾綅
	POST varchar(255) COMMENT '宀椾綅',
	-- 鎬у埆
	AGE char COMMENT '鎬у埆',
	-- 瀛﹀巻
	EDU varchar(255) COMMENT '瀛﹀巻',
	-- 璋冩暣鍘熷洜
	CONTENT varchar(255) COMMENT '璋冩暣鍘熷洜',
	-- 鐜拌鏍囧噯 钖叕妗ｇ骇
	OLDA varchar(255) COMMENT '鐜拌鏍囧噯 钖叕妗ｇ骇',
	-- 鐜拌鏍囧噯 鏈堝伐璧勯
	OLDB varchar(255) COMMENT '鐜拌鏍囧噯 鏈堝伐璧勯',
	-- 鐜拌鏍囧噯 骞磋柂鎬婚
	OLDC varchar(255) COMMENT '鐜拌鏍囧噯 骞磋柂鎬婚',
	-- 璋冩暣鍚庢爣鍑�钖叕妗ｇ骇
	NEWA varchar(255) COMMENT '璋冩暣鍚庢爣鍑�钖叕妗ｇ骇',
	-- 璋冩暣鍚庢爣鍑�鏈堝伐璧勯
	NEWB varchar(255) COMMENT '璋冩暣鍚庢爣鍑�鏈堝伐璧勯',
	-- 璋冩暣鍚庢爣鍑�骞磋柂鎬婚
	NEWC varchar(255) COMMENT '璋冩暣鍚庢爣鍑�骞磋柂鎬婚',
	-- 鏈堝璧�	ADD_NUM varchar(255) COMMENT '鏈堝璧�,
	-- 鎵ц鏃堕棿
	EXE_DATE varchar(255) COMMENT '鎵ц鏃堕棿',
	-- 浜哄姏璧勬簮閮ㄩ棬鎰忚
	HR_TEXT varchar(255) COMMENT '浜哄姏璧勬簮閮ㄩ棬鎰忚',
	-- 鍒嗙棰嗗鎰忚
	LEAD_TEXT varchar(255) COMMENT '鍒嗙棰嗗鎰忚',
	-- 闆嗗洟涓昏棰嗗鎰忚
	MAIN_LEAD_TEXT varchar(255) COMMENT '闆嗗洟涓昏棰嗗鎰忚',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_area
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鐖剁骇缂栧彿
	parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
	-- 鎵�湁鐖剁骇缂栧彿
	parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
	-- 鍚嶇О
	name varchar(100) NOT NULL COMMENT '鍚嶇О',
	-- 鎺掑簭
	sort decimal NOT NULL COMMENT '鎺掑簭',
	-- 鍖哄煙缂栫爜
	code varchar(100) COMMENT '鍖哄煙缂栫爜',
	-- 鍖哄煙绫诲瀷
	type char COMMENT '鍖哄煙绫诲瀷',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_dict
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鏁版嵁鍊�	value varchar(100) NOT NULL COMMENT '鏁版嵁鍊�,
	-- 鏍囩鍚�	label varchar(100) NOT NULL COMMENT '鏍囩鍚�,
	-- 绫诲瀷
	type varchar(100) NOT NULL COMMENT '绫诲瀷',
	-- 鎻忚堪
	description varchar(100) NOT NULL COMMENT '鎻忚堪',
	-- 鎺掑簭锛堝崌搴忥級
	sort decimal NOT NULL COMMENT '鎺掑簭锛堝崌搴忥級',
	-- 鐖剁骇缂栧彿
	parent_id varchar(64) DEFAULT '0' COMMENT '鐖剁骇缂栧彿',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_log
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鏃ュ織绫诲瀷
	type char DEFAULT '1' COMMENT '鏃ュ織绫诲瀷',
	-- 鏃ュ織鏍囬
	title varchar(255) COMMENT '鏃ュ織鏍囬',
	-- 鍒涘缓鑰�	create_by varchar(64) COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime COMMENT '鍒涘缓鏃堕棿',
	-- 鎿嶄綔IP鍦板潃
	remote_addr varchar(255) COMMENT '鎿嶄綔IP鍦板潃',
	-- 鐢ㄦ埛浠ｇ悊
	user_agent varchar(255) COMMENT '鐢ㄦ埛浠ｇ悊',
	-- 璇锋眰URI
	request_uri varchar(255) COMMENT '璇锋眰URI',
	-- 鎿嶄綔鏂瑰紡
	method varchar(5) COMMENT '鎿嶄綔鏂瑰紡',
	-- 鎿嶄綔鎻愪氦鐨勬暟鎹�	params text COMMENT '鎿嶄綔鎻愪氦鐨勬暟鎹�,
	-- 寮傚父淇℃伅
	exception text COMMENT '寮傚父淇℃伅',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_mdict
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鐖剁骇缂栧彿
	parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
	-- 鎵�湁鐖剁骇缂栧彿
	parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
	-- 鍚嶇О
	name varchar(100) NOT NULL COMMENT '鍚嶇О',
	-- 鎺掑簭
	sort decimal NOT NULL COMMENT '鎺掑簭',
	-- 鎻忚堪
	description varchar(100) COMMENT '鎻忚堪',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_menu
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鐖剁骇缂栧彿
	parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
	-- 鎵�湁鐖剁骇缂栧彿
	parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
	-- 鍚嶇О
	name varchar(100) NOT NULL COMMENT '鍚嶇О',
	-- 鎺掑簭
	sort decimal NOT NULL COMMENT '鎺掑簭',
	-- 閾炬帴
	href varchar(2000) COMMENT '閾炬帴',
	-- 鐩爣
	target varchar(20) COMMENT '鐩爣',
	-- 鍥炬爣
	icon varchar(100) COMMENT '鍥炬爣',
	-- 鏄惁鍦ㄨ彍鍗曚腑鏄剧ず
	is_show char NOT NULL COMMENT '鏄惁鍦ㄨ彍鍗曚腑鏄剧ず',
	-- 鏉冮檺鏍囪瘑
	permission varchar(200) COMMENT '鏉冮檺鏍囪瘑',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_office
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鐖剁骇缂栧彿
	parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
	-- 鎵�湁鐖剁骇缂栧彿
	parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
	-- 鍚嶇О
	name varchar(100) NOT NULL COMMENT '鍚嶇О',
	-- 鎺掑簭
	sort decimal NOT NULL COMMENT '鎺掑簭',
	-- 褰掑睘鍖哄煙
	area_id varchar(64) NOT NULL COMMENT '褰掑睘鍖哄煙',
	-- 鍖哄煙缂栫爜
	code varchar(100) COMMENT '鍖哄煙缂栫爜',
	-- 鏈烘瀯绫诲瀷
	type char NOT NULL COMMENT '鏈烘瀯绫诲瀷',
	-- 鏈烘瀯绛夌骇
	grade char NOT NULL COMMENT '鏈烘瀯绛夌骇',
	-- 鑱旂郴鍦板潃
	address varchar(255) COMMENT '鑱旂郴鍦板潃',
	-- 閭斂缂栫爜
	zip_code varchar(100) COMMENT '閭斂缂栫爜',
	-- 璐熻矗浜�	master varchar(100) COMMENT '璐熻矗浜�,
	-- 鐢佃瘽
	phone varchar(200) COMMENT '鐢佃瘽',
	-- 浼犵湡
	fax varchar(200) COMMENT '浼犵湡',
	-- 閭
	email varchar(200) COMMENT '閭',
	-- 鏄惁鍚敤
	USEABLE varchar(64) COMMENT '鏄惁鍚敤',
	-- 涓昏礋璐ｄ汉
	PRIMARY_PERSON varchar(64) COMMENT '涓昏礋璐ｄ汉',
	-- 鍓礋璐ｄ汉
	DEPUTY_PERSON varchar(64) COMMENT '鍓礋璐ｄ汉',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_role
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 褰掑睘鏈烘瀯
	office_id varchar(64) COMMENT '褰掑睘鏈烘瀯',
	-- 瑙掕壊鍚嶇О
	name varchar(100) NOT NULL COMMENT '瑙掕壊鍚嶇О',
	-- 鑻辨枃鍚嶇О
	enname varchar(255) COMMENT '鑻辨枃鍚嶇О',
	-- 瑙掕壊绫诲瀷
	role_type varchar(255) COMMENT '瑙掕壊绫诲瀷',
	-- 鏁版嵁鑼冨洿
	data_scope char COMMENT '鏁版嵁鑼冨洿',
	-- 鏄惁绯荤粺鏁版嵁
	is_sys varchar(64) COMMENT '鏄惁绯荤粺鏁版嵁',
	-- 鏄惁鍙敤
	useable varchar(64) COMMENT '鏄惁鍙敤',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_role_menu
(
	-- 瑙掕壊缂栧彿
	role_id varchar(64) NOT NULL COMMENT '瑙掕壊缂栧彿',
	-- 鑿滃崟缂栧彿
	menu_id varchar(64) NOT NULL COMMENT '鑿滃崟缂栧彿',
	PRIMARY KEY (role_id, menu_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_role_office
(
	-- 瑙掕壊缂栧彿
	role_id varchar(64) NOT NULL COMMENT '瑙掕壊缂栧彿',
	-- 鏈烘瀯缂栧彿
	office_id varchar(64) NOT NULL COMMENT '鏈烘瀯缂栧彿',
	PRIMARY KEY (role_id, office_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_user
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 褰掑睘鍏徃
	company_id varchar(64) NOT NULL COMMENT '褰掑睘鍏徃',
	-- 褰掑睘閮ㄩ棬
	office_id varchar(64) NOT NULL COMMENT '褰掑睘閮ㄩ棬',
	-- 鐧诲綍鍚�	login_name varchar(100) NOT NULL COMMENT '鐧诲綍鍚�,
	-- 瀵嗙爜
	password varchar(100) NOT NULL COMMENT '瀵嗙爜',
	-- 宸ュ彿
	no varchar(100) COMMENT '宸ュ彿',
	-- 濮撳悕
	name varchar(100) NOT NULL COMMENT '濮撳悕',
	-- 閭
	email varchar(200) COMMENT '閭',
	-- 鐢佃瘽
	phone varchar(200) COMMENT '鐢佃瘽',
	-- 鎵嬫満
	mobile varchar(200) COMMENT '鎵嬫満',
	-- 鐢ㄦ埛绫诲瀷
	user_type char COMMENT '鐢ㄦ埛绫诲瀷',
	-- 鐢ㄦ埛澶村儚
	photo varchar(1000) COMMENT '鐢ㄦ埛澶村儚',
	-- 鏈�悗鐧婚檰IP
	login_ip varchar(100) COMMENT '鏈�悗鐧婚檰IP',
	-- 鏈�悗鐧婚檰鏃堕棿
	login_date datetime COMMENT '鏈�悗鐧婚檰鏃堕棿',
	-- 鏄惁鍙櫥褰�	login_flag varchar(64) COMMENT '鏄惁鍙櫥褰�,
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE sys_user_role
(
	-- 鐢ㄦ埛缂栧彿
	user_id varchar(64) NOT NULL COMMENT '鐢ㄦ埛缂栧彿',
	-- 瑙掕壊缂栧彿
	role_id varchar(64) NOT NULL COMMENT '瑙掕壊缂栧彿',
	PRIMARY KEY (user_id, role_id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE test_data
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 褰掑睘鐢ㄦ埛
	user_id varchar(64) COMMENT '褰掑睘鐢ㄦ埛',
	-- 褰掑睘閮ㄩ棬
	office_id varchar(64) COMMENT '褰掑睘閮ㄩ棬',
	-- 褰掑睘鍖哄煙
	area_id varchar(64) COMMENT '褰掑睘鍖哄煙',
	-- 鍚嶇О
	name varchar(100) COMMENT '鍚嶇О',
	-- 鎬у埆
	sex char COMMENT '鎬у埆',
	-- 鍔犲叆鏃ユ湡
	in_date date COMMENT '鍔犲叆鏃ユ湡',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE test_data_child
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 涓氬姟涓昏〃ID
	test_data_main_id varchar(64) COMMENT '涓氬姟涓昏〃ID',
	-- 鍚嶇О
	name varchar(100) COMMENT '鍚嶇О',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE test_data_main
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 褰掑睘鐢ㄦ埛
	user_id varchar(64) COMMENT '褰掑睘鐢ㄦ埛',
	-- 褰掑睘閮ㄩ棬
	office_id varchar(64) COMMENT '褰掑睘閮ㄩ棬',
	-- 褰掑睘鍖哄煙
	area_id varchar(64) COMMENT '褰掑睘鍖哄煙',
	-- 鍚嶇О
	name varchar(100) COMMENT '鍚嶇О',
	-- 鎬у埆
	sex char COMMENT '鎬у埆',
	-- 鍔犲叆鏃ユ湡
	in_date date COMMENT '鍔犲叆鏃ユ湡',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


CREATE TABLE test_tree
(
	-- 缂栧彿
	id varchar(64) NOT NULL COMMENT '缂栧彿',
	-- 鐖剁骇缂栧彿
	parent_id varchar(64) NOT NULL COMMENT '鐖剁骇缂栧彿',
	-- 鎵�湁鐖剁骇缂栧彿
	parent_ids varchar(2000) NOT NULL COMMENT '鎵�湁鐖剁骇缂栧彿',
	-- 鍚嶇О
	name varchar(100) NOT NULL COMMENT '鍚嶇О',
	-- 鎺掑簭
	sort decimal NOT NULL COMMENT '鎺掑簭',
	-- 鍒涘缓鑰�	create_by varchar(64) NOT NULL COMMENT '鍒涘缓鑰�,
	-- 鍒涘缓鏃堕棿
	create_date datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
	-- 鏇存柊鑰�	update_by varchar(64) NOT NULL COMMENT '鏇存柊鑰�,
	-- 鏇存柊鏃堕棿
	update_date datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
	-- 澶囨敞淇℃伅
	remarks varchar(255) COMMENT '澶囨敞淇℃伅',
	-- 鍒犻櫎鏍囪
	del_flag char DEFAULT '0' NOT NULL COMMENT '鍒犻櫎鏍囪',
	PRIMARY KEY (id)
) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;


/* Create Foreign Keys */

ALTER TABLE act_re_model
	ADD CONSTRAINT ACT_FK_MODEL_SOURCE_EXTRA FOREIGN KEY (EDITOR_SOURCE_EXTRA_VALUE_ID_)
	REFERENCES act_ge_bytearray (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_re_model
	ADD CONSTRAINT ACT_FK_MODEL_SOURCE FOREIGN KEY (EDITOR_SOURCE_VALUE_ID_)
	REFERENCES act_ge_bytearray (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_job
	ADD CONSTRAINT ACT_FK_JOB_EXCEPTION FOREIGN KEY (EXCEPTION_STACK_ID_)
	REFERENCES act_ge_bytearray (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_variable
	ADD CONSTRAINT ACT_FK_VAR_BYTEARRAY FOREIGN KEY (BYTEARRAY_ID_)
	REFERENCES act_ge_bytearray (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_id_membership
	ADD CONSTRAINT ACT_FK_MEMB_GROUP FOREIGN KEY (GROUP_ID_)
	REFERENCES act_id_group (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_id_membership
	ADD CONSTRAINT ACT_FK_MEMB_USER FOREIGN KEY (USER_ID_)
	REFERENCES act_id_user (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ge_bytearray
	ADD CONSTRAINT ACT_FK_BYTEARR_DEPL FOREIGN KEY (DEPLOYMENT_ID_)
	REFERENCES act_re_deployment (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_re_model
	ADD CONSTRAINT ACT_FK_MODEL_DEPLOYMENT FOREIGN KEY (DEPLOYMENT_ID_)
	REFERENCES act_re_deployment (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_execution
	ADD CONSTRAINT ACT_FK_EXE_PROCDEF FOREIGN KEY (PROC_DEF_ID_)
	REFERENCES act_re_procdef (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_identitylink
	ADD CONSTRAINT ACT_FK_ATHRZ_PROCEDEF FOREIGN KEY (PROC_DEF_ID_)
	REFERENCES act_re_procdef (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_task
	ADD CONSTRAINT ACT_FK_TASK_PROCDEF FOREIGN KEY (PROC_DEF_ID_)
	REFERENCES act_re_procdef (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_event_subscr
	ADD CONSTRAINT ACT_FK_EVENT_EXEC FOREIGN KEY (EXECUTION_ID_)
	REFERENCES act_ru_execution (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_execution
	ADD CONSTRAINT ACT_FK_EXE_PROCINST FOREIGN KEY (PROC_INST_ID_)
	REFERENCES act_ru_execution (ID_)
	ON UPDATE CASCADE
	ON DELETE CASCADE
;


ALTER TABLE act_ru_execution
	ADD CONSTRAINT ACT_FK_EXE_PARENT FOREIGN KEY (PARENT_ID_)
	REFERENCES act_ru_execution (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_execution
	ADD CONSTRAINT ACT_FK_EXE_SUPER FOREIGN KEY (SUPER_EXEC_)
	REFERENCES act_ru_execution (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_identitylink
	ADD CONSTRAINT ACT_FK_IDL_PROCINST FOREIGN KEY (PROC_INST_ID_)
	REFERENCES act_ru_execution (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_task
	ADD CONSTRAINT ACT_FK_TASK_EXE FOREIGN KEY (EXECUTION_ID_)
	REFERENCES act_ru_execution (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_task
	ADD CONSTRAINT ACT_FK_TASK_PROCINST FOREIGN KEY (PROC_INST_ID_)
	REFERENCES act_ru_execution (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_variable
	ADD CONSTRAINT ACT_FK_VAR_EXE FOREIGN KEY (EXECUTION_ID_)
	REFERENCES act_ru_execution (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_variable
	ADD CONSTRAINT ACT_FK_VAR_PROCINST FOREIGN KEY (PROC_INST_ID_)
	REFERENCES act_ru_execution (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE act_ru_identitylink
	ADD CONSTRAINT ACT_FK_TSKASS_TASK FOREIGN KEY (TASK_ID_)
	REFERENCES act_ru_task (ID_)
	ON UPDATE NO ACTION
	ON DELETE NO ACTION
;


ALTER TABLE cms_db
	ADD FOREIGN KEY (buss_sys_id)
	REFERENCES cms_bussines_system (buss_sys_id)
	ON UPDATE RESTRICT
	ON DELETE RESTRICT
;


/* Create Indexes */

CREATE INDEX ACT_FK_BYTEARR_DEPL USING BTREE ON act_ge_bytearray (DEPLOYMENT_ID_ ASC);
CREATE INDEX ACT_IDX_HI_ACT_INST_END USING BTREE ON act_hi_actinst (END_TIME_ ASC);
CREATE INDEX ACT_IDX_HI_ACT_INST_EXEC USING BTREE ON act_hi_actinst (EXECUTION_ID_ ASC, ACT_ID_ ASC);
CREATE INDEX ACT_IDX_HI_ACT_INST_PROCINST USING BTREE ON act_hi_actinst (PROC_INST_ID_ ASC, ACT_ID_ ASC);
CREATE INDEX ACT_IDX_HI_ACT_INST_START USING BTREE ON act_hi_actinst (START_TIME_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_ACT_INST USING BTREE ON act_hi_detail (ACT_INST_ID_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_NAME USING BTREE ON act_hi_detail (NAME_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_PROC_INST USING BTREE ON act_hi_detail (PROC_INST_ID_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_TASK_ID USING BTREE ON act_hi_detail (TASK_ID_ ASC);
CREATE INDEX ACT_IDX_HI_DETAIL_TIME USING BTREE ON act_hi_detail (TIME_ ASC);
CREATE INDEX ACT_IDX_HI_IDENT_LNK_PROCINST USING BTREE ON act_hi_identitylink (PROC_INST_ID_ ASC);
CREATE INDEX ACT_IDX_HI_IDENT_LNK_TASK USING BTREE ON act_hi_identitylink (TASK_ID_ ASC);
CREATE INDEX ACT_IDX_HI_IDENT_LNK_USER USING BTREE ON act_hi_identitylink (USER_ID_ ASC);
CREATE INDEX ACT_IDX_HI_PRO_I_BUSKEY USING BTREE ON act_hi_procinst (BUSINESS_KEY_ ASC);
CREATE INDEX ACT_IDX_HI_PRO_INST_END USING BTREE ON act_hi_procinst (END_TIME_ ASC);
CREATE INDEX ACT_IDX_HI_PROCVAR_NAME_TYPE USING BTREE ON act_hi_varinst (NAME_ ASC, VAR_TYPE_ ASC);
CREATE INDEX ACT_IDX_HI_PROCVAR_PROC_INST USING BTREE ON act_hi_varinst (PROC_INST_ID_ ASC);
CREATE INDEX ACT_FK_MEMB_GROUP USING BTREE ON act_id_membership (GROUP_ID_ ASC);
CREATE INDEX ACT_FK_MODEL_DEPLOYMENT USING BTREE ON act_re_model (DEPLOYMENT_ID_ ASC);
CREATE INDEX ACT_FK_MODEL_SOURCE USING BTREE ON act_re_model (EDITOR_SOURCE_VALUE_ID_ ASC);
CREATE INDEX ACT_FK_MODEL_SOURCE_EXTRA USING BTREE ON act_re_model (EDITOR_SOURCE_EXTRA_VALUE_ID_ ASC);
CREATE UNIQUE INDEX ACT_UNIQ_PROCDEF USING BTREE ON act_re_procdef (KEY_ ASC, VERSION_ ASC, TENANT_ID_ ASC);
CREATE INDEX ACT_FK_EVENT_EXEC USING BTREE ON act_ru_event_subscr (EXECUTION_ID_ ASC);
CREATE INDEX ACT_IDX_EVENT_SUBSCR_CONFIG_ USING BTREE ON act_ru_event_subscr (CONFIGURATION_ ASC);
CREATE INDEX ACT_FK_EXE_PARENT USING BTREE ON act_ru_execution (PARENT_ID_ ASC);
CREATE INDEX ACT_FK_EXE_PROCDEF USING BTREE ON act_ru_execution (PROC_DEF_ID_ ASC);
CREATE INDEX ACT_FK_EXE_PROCINST USING BTREE ON act_ru_execution (PROC_INST_ID_ ASC);
CREATE INDEX ACT_FK_EXE_SUPER USING BTREE ON act_ru_execution (SUPER_EXEC_ ASC);
CREATE INDEX ACT_IDX_EXEC_BUSKEY USING BTREE ON act_ru_execution (BUSINESS_KEY_ ASC);
CREATE INDEX ACT_FK_IDL_PROCINST USING BTREE ON act_ru_identitylink (PROC_INST_ID_ ASC);
CREATE INDEX ACT_FK_TSKASS_TASK USING BTREE ON act_ru_identitylink (TASK_ID_ ASC);
CREATE INDEX ACT_IDX_ATHRZ_PROCEDEF USING BTREE ON act_ru_identitylink (PROC_DEF_ID_ ASC);
CREATE INDEX ACT_IDX_IDENT_LNK_GROUP USING BTREE ON act_ru_identitylink (GROUP_ID_ ASC);
CREATE INDEX ACT_IDX_IDENT_LNK_USER USING BTREE ON act_ru_identitylink (USER_ID_ ASC);
CREATE INDEX ACT_FK_JOB_EXCEPTION USING BTREE ON act_ru_job (EXCEPTION_STACK_ID_ ASC);
CREATE INDEX ACT_FK_TASK_EXE USING BTREE ON act_ru_task (EXECUTION_ID_ ASC);
CREATE INDEX ACT_FK_TASK_PROCDEF USING BTREE ON act_ru_task (PROC_DEF_ID_ ASC);
CREATE INDEX ACT_FK_TASK_PROCINST USING BTREE ON act_ru_task (PROC_INST_ID_ ASC);
CREATE INDEX ACT_IDX_TASK_CREATE USING BTREE ON act_ru_task (CREATE_TIME_ ASC);
CREATE INDEX ACT_FK_VAR_BYTEARRAY USING BTREE ON act_ru_variable (BYTEARRAY_ID_ ASC);
CREATE INDEX ACT_FK_VAR_EXE USING BTREE ON act_ru_variable (EXECUTION_ID_ ASC);
CREATE INDEX ACT_FK_VAR_PROCINST USING BTREE ON act_ru_variable (PROC_INST_ID_ ASC);
CREATE INDEX ACT_IDX_VARIABLE_TASK_ID USING BTREE ON act_ru_variable (TASK_ID_ ASC);
CREATE INDEX cms_article_category_id USING BTREE ON cms_article (category_id ASC);
CREATE INDEX cms_article_create_by USING BTREE ON cms_article (create_by ASC);
CREATE INDEX cms_article_del_flag USING BTREE ON cms_article (del_flag ASC);
CREATE INDEX cms_article_keywords USING BTREE ON cms_article (keywords ASC);
CREATE INDEX cms_article_title USING BTREE ON cms_article (title ASC);
CREATE INDEX cms_article_update_date USING BTREE ON cms_article (update_date ASC);
CREATE INDEX cms_article_weight USING BTREE ON cms_article (weight ASC);
CREATE INDEX cms_category_del_flag USING BTREE ON cms_category (del_flag ASC);
CREATE INDEX cms_category_module USING BTREE ON cms_category (module ASC);
CREATE INDEX cms_category_name USING BTREE ON cms_category (name ASC);
CREATE INDEX cms_category_office_id USING BTREE ON cms_category (office_id ASC);
CREATE INDEX cms_category_parent_id USING BTREE ON cms_category (parent_id ASC);
CREATE INDEX cms_category_site_id USING BTREE ON cms_category (site_id ASC);
CREATE INDEX cms_category_sort USING BTREE ON cms_category (sort ASC);
CREATE INDEX cms_comment_category_id USING BTREE ON cms_comment (category_id ASC);
CREATE INDEX cms_comment_content_id USING BTREE ON cms_comment (content_id ASC);
CREATE INDEX cms_comment_status USING BTREE ON cms_comment (del_flag ASC);
CREATE INDEX cms_guestbook_del_flag USING BTREE ON cms_guestbook (del_flag ASC);
CREATE INDEX cms_link_category_id USING BTREE ON cms_link (category_id ASC);
CREATE INDEX cms_link_create_by USING BTREE ON cms_link (create_by ASC);
CREATE INDEX cms_link_del_flag USING BTREE ON cms_link (del_flag ASC);
CREATE INDEX cms_link_title USING BTREE ON cms_link (title ASC);
CREATE INDEX cms_link_update_date USING BTREE ON cms_link (update_date ASC);
CREATE INDEX cms_link_weight USING BTREE ON cms_link (weight ASC);
CREATE INDEX cms_site_del_flag USING BTREE ON cms_site (del_flag ASC);
CREATE INDEX gen_scheme_del_flag USING BTREE ON gen_scheme (del_flag ASC);
CREATE INDEX gen_table_del_flag USING BTREE ON gen_table (del_flag ASC);
CREATE INDEX gen_table_name USING BTREE ON gen_table (name ASC);
CREATE INDEX gen_table_column_del_flag USING BTREE ON gen_table_column (del_flag ASC);
CREATE INDEX gen_table_column_name USING BTREE ON gen_table_column (name ASC);
CREATE INDEX gen_table_column_sort USING BTREE ON gen_table_column (sort ASC);
CREATE INDEX gen_table_column_table_id USING BTREE ON gen_table_column (gen_table_id ASC);
CREATE INDEX gen_template_del_falg USING BTREE ON gen_template (del_flag ASC);
CREATE INDEX oa_leave_create_by USING BTREE ON oa_leave (create_by ASC);
CREATE INDEX oa_leave_del_flag USING BTREE ON oa_leave (del_flag ASC);
CREATE INDEX oa_leave_process_instance_id USING BTREE ON oa_leave (process_instance_id ASC);
CREATE INDEX oa_notify_del_flag USING BTREE ON oa_notify (del_flag ASC);
CREATE INDEX oa_notify_record_notify_id USING BTREE ON oa_notify_record (oa_notify_id ASC);
CREATE INDEX oa_notify_record_read_flag USING BTREE ON oa_notify_record (read_flag ASC);
CREATE INDEX oa_notify_record_user_id USING BTREE ON oa_notify_record (user_id ASC);
CREATE INDEX OA_TEST_AUDIT_del_flag USING BTREE ON oa_test_audit (del_flag ASC);
CREATE INDEX sys_area_del_flag USING BTREE ON sys_area (del_flag ASC);
CREATE INDEX sys_area_parent_id USING BTREE ON sys_area (parent_id ASC);
CREATE INDEX sys_dict_del_flag USING BTREE ON sys_dict (del_flag ASC);
CREATE INDEX sys_dict_label USING BTREE ON sys_dict (label ASC);
CREATE INDEX sys_dict_value USING BTREE ON sys_dict (value ASC);
CREATE INDEX sys_log_create_by USING BTREE ON sys_log (create_by ASC);
CREATE INDEX sys_log_create_date USING BTREE ON sys_log (create_date ASC);
CREATE INDEX sys_log_request_uri USING BTREE ON sys_log (request_uri ASC);
CREATE INDEX sys_log_type USING BTREE ON sys_log (type ASC);
CREATE INDEX sys_mdict_del_flag USING BTREE ON sys_mdict (del_flag ASC);
CREATE INDEX sys_mdict_parent_id USING BTREE ON sys_mdict (parent_id ASC);
CREATE INDEX sys_menu_del_flag USING BTREE ON sys_menu (del_flag ASC);
CREATE INDEX sys_menu_parent_id USING BTREE ON sys_menu (parent_id ASC);
CREATE INDEX sys_office_del_flag USING BTREE ON sys_office (del_flag ASC);
CREATE INDEX sys_office_parent_id USING BTREE ON sys_office (parent_id ASC);
CREATE INDEX sys_office_type USING BTREE ON sys_office (type ASC);
CREATE INDEX sys_role_del_flag USING BTREE ON sys_role (del_flag ASC);
CREATE INDEX sys_role_enname USING BTREE ON sys_role (enname ASC);
CREATE INDEX sys_user_company_id USING BTREE ON sys_user (company_id ASC);
CREATE INDEX sys_user_del_flag USING BTREE ON sys_user (del_flag ASC);
CREATE INDEX sys_user_login_name USING BTREE ON sys_user (login_name ASC);
CREATE INDEX sys_user_office_id USING BTREE ON sys_user (office_id ASC);
CREATE INDEX sys_user_update_date USING BTREE ON sys_user (update_date ASC);
CREATE INDEX test_data_del_flag USING BTREE ON test_data (del_flag ASC);
CREATE INDEX test_data_child_del_flag USING BTREE ON test_data_child (del_flag ASC);
CREATE INDEX test_data_main_del_flag USING BTREE ON test_data_main (del_flag ASC);
CREATE INDEX test_data_parent_id USING BTREE ON test_tree (parent_id ASC);
CREATE INDEX test_tree_del_flag USING BTREE ON test_tree (del_flag ASC);