代码拉取完成,页面将自动刷新
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 '璋冩暣鍘熷洜',
-- 鐜拌鏍囧噯 钖叕妗g骇
OLDA varchar(255) COMMENT '鐜拌鏍囧噯 钖叕妗g骇',
-- 鐜拌鏍囧噯 鏈堝伐璧勯
OLDB varchar(255) COMMENT '鐜拌鏍囧噯 鏈堝伐璧勯',
-- 鐜拌鏍囧噯 骞磋柂鎬婚
OLDC varchar(255) COMMENT '鐜拌鏍囧噯 骞磋柂鎬婚',
-- 璋冩暣鍚庢爣鍑�钖叕妗g骇
NEWA varchar(255) COMMENT '璋冩暣鍚庢爣鍑�钖叕妗g骇',
-- 璋冩暣鍚庢爣鍑�鏈堝伐璧勯
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鍦板潃',
-- 鐢ㄦ埛浠g悊
user_agent varchar(255) COMMENT '鐢ㄦ埛浠g悊',
-- 璇锋眰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 '鏄惁鍚敤',
-- 涓昏礋璐d汉
PRIMARY_PERSON varchar(64) COMMENT '涓昏礋璐d汉',
-- 鍓礋璐d汉
DEPUTY_PERSON varchar(64) COMMENT '鍓礋璐d汉',
-- 鍒涘缓鑰� 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);
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。