/*
|
Navicat MySQL Data Transfer
|
|
Source Server : localhost
|
Source Server Version : 50509
|
Source Host : localhost:3306
|
Source Database : oasys
|
|
Target Server Type : MYSQL
|
Target Server Version : 50509
|
File Encoding : 65001
|
|
Date: 2018-02-01 14:58:51
|
*/
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
-- ----------------------------
|
-- Table structure for `act_evt_log`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_evt_log`;
|
CREATE TABLE `act_evt_log` (
|
`LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT,
|
`TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TIME_STAMP_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
`USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`DATA_` longblob,
|
`LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`LOCK_TIME_` timestamp NULL DEFAULT NULL,
|
`IS_PROCESSED_` tinyint(4) DEFAULT '0',
|
PRIMARY KEY (`LOG_NR_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_evt_log
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_ge_bytearray`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_ge_bytearray`;
|
CREATE TABLE `act_ge_bytearray` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`REV_` int(11) DEFAULT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`BYTES_` longblob,
|
`GENERATED_` tinyint(4) DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`),
|
CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ge_bytearray
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_ge_property`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_ge_property`;
|
CREATE TABLE `act_ge_property` (
|
`NAME_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
PRIMARY KEY (`NAME_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ge_property
|
-- ----------------------------
|
INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', '1');
|
INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(5.22.0.0)', '1');
|
INSERT INTO `act_ge_property` VALUES ('schema.version', '5.22.0.0', '1');
|
|
-- ----------------------------
|
-- Table structure for `act_hi_actinst`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_hi_actinst`;
|
CREATE TABLE `act_hi_actinst` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`START_TIME_` datetime NOT NULL,
|
`END_TIME_` datetime DEFAULT NULL,
|
`DURATION_` bigint(20) DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`),
|
KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`),
|
KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`),
|
KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_actinst
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_hi_attachment`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_hi_attachment`;
|
CREATE TABLE `act_hi_attachment` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TIME_` datetime DEFAULT NULL,
|
PRIMARY KEY (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_attachment
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_hi_comment`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_hi_comment`;
|
CREATE TABLE `act_hi_comment` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TIME_` datetime NOT NULL,
|
`USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`FULL_MSG_` longblob,
|
PRIMARY KEY (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_comment
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_hi_detail`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_hi_detail`;
|
CREATE TABLE `act_hi_detail` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`TIME_` datetime NOT NULL,
|
`BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`DOUBLE_` double DEFAULT NULL,
|
`LONG_` bigint(20) DEFAULT NULL,
|
`TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`),
|
KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`),
|
KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`),
|
KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`),
|
KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_detail
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_hi_identitylink`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_hi_identitylink`;
|
CREATE TABLE `act_hi_identitylink` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
|
KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`),
|
KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_identitylink
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_hi_procinst`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_hi_procinst`;
|
CREATE TABLE `act_hi_procinst` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`START_TIME_` datetime NOT NULL,
|
`END_TIME_` datetime DEFAULT NULL,
|
`DURATION_` bigint(20) DEFAULT NULL,
|
`START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`),
|
KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`),
|
KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_procinst
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_hi_taskinst`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_hi_taskinst`;
|
CREATE TABLE `act_hi_taskinst` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`START_TIME_` datetime NOT NULL,
|
`CLAIM_TIME_` datetime DEFAULT NULL,
|
`END_TIME_` datetime DEFAULT NULL,
|
`DURATION_` bigint(20) DEFAULT NULL,
|
`DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`PRIORITY_` int(11) DEFAULT NULL,
|
`DUE_DATE_` datetime DEFAULT NULL,
|
`FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_taskinst
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_hi_varinst`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_hi_varinst`;
|
CREATE TABLE `act_hi_varinst` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`DOUBLE_` double DEFAULT NULL,
|
`LONG_` bigint(20) DEFAULT NULL,
|
`TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`CREATE_TIME_` datetime DEFAULT NULL,
|
`LAST_UPDATED_TIME_` datetime DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`),
|
KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`),
|
KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_varinst
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_id_group`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_id_group`;
|
CREATE TABLE `act_id_group` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`REV_` int(11) DEFAULT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_id_group
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_id_info`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_id_info`;
|
CREATE TABLE `act_id_info` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`REV_` int(11) DEFAULT NULL,
|
`USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`PASSWORD_` longblob,
|
`PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_id_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_id_membership`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_id_membership`;
|
CREATE TABLE `act_id_membership` (
|
`USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
PRIMARY KEY (`USER_ID_`,`GROUP_ID_`),
|
KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
|
CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`),
|
CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_id_membership
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_id_user`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_id_user`;
|
CREATE TABLE `act_id_user` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`REV_` int(11) DEFAULT NULL,
|
`FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_id_user
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_procdef_info`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_procdef_info`;
|
CREATE TABLE `act_procdef_info` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`),
|
KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`),
|
KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`),
|
CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_procdef_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_re_deployment`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_re_deployment`;
|
CREATE TABLE `act_re_deployment` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
`DEPLOY_TIME_` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_re_deployment
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_re_model`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_re_model`;
|
CREATE TABLE `act_re_model` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`CREATE_TIME_` timestamp NULL DEFAULT NULL,
|
`LAST_UPDATE_TIME_` timestamp NULL DEFAULT NULL,
|
`VERSION_` int(11) DEFAULT NULL,
|
`META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`),
|
KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`),
|
KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`),
|
CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`),
|
CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_re_model
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_re_procdef`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_re_procdef`;
|
CREATE TABLE `act_re_procdef` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`KEY_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`VERSION_` int(11) NOT NULL,
|
`DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL,
|
`HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL,
|
`SUSPENSION_STATE_` int(11) DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_re_procdef
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_ru_event_subscr`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_ru_event_subscr`;
|
CREATE TABLE `act_ru_event_subscr` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`CREATED_` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`),
|
KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`),
|
CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_event_subscr
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_ru_execution`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_ru_execution`;
|
CREATE TABLE `act_ru_execution` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`REV_` int(11) DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`IS_ACTIVE_` tinyint(4) DEFAULT NULL,
|
`IS_CONCURRENT_` tinyint(4) DEFAULT NULL,
|
`IS_SCOPE_` tinyint(4) DEFAULT NULL,
|
`IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL,
|
`SUSPENSION_STATE_` int(11) DEFAULT NULL,
|
`CACHED_ENT_STATE_` int(11) DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`LOCK_TIME_` timestamp NULL DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`),
|
KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`),
|
KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`),
|
KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`),
|
KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`),
|
CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
|
CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_execution
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_ru_identitylink`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_ru_identitylink`;
|
CREATE TABLE `act_ru_identitylink` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`REV_` int(11) DEFAULT NULL,
|
`GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
|
KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
|
KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`),
|
KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`),
|
KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`),
|
CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_identitylink
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_ru_job`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_ru_job`;
|
CREATE TABLE `act_ru_job` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`LOCK_EXP_TIME_` timestamp NULL DEFAULT NULL,
|
`LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`EXCLUSIVE_` tinyint(1) DEFAULT NULL,
|
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`RETRIES_` int(11) DEFAULT NULL,
|
`EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`DUEDATE_` timestamp NULL DEFAULT NULL,
|
`REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
|
CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_job
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_ru_task`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_ru_task`;
|
CREATE TABLE `act_ru_task` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
`REV_` int(11) DEFAULT NULL,
|
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PRIORITY_` int(11) DEFAULT NULL,
|
`CREATE_TIME_` timestamp NULL DEFAULT NULL,
|
`DUE_DATE_` datetime DEFAULT NULL,
|
`CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`SUSPENSION_STATE_` int(11) DEFAULT NULL,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
`FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
|
KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`),
|
KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`),
|
KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`),
|
CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_task
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `act_ru_variable`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `act_ru_variable`;
|
CREATE TABLE `act_ru_variable` (
|
`ID_` varchar(64) COLLATE utf8_bin NOT NULL,
|
`REV_` int(11) DEFAULT NULL,
|
`TYPE_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`NAME_` varchar(255) COLLATE utf8_bin NOT NULL,
|
`EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL,
|
`DOUBLE_` double DEFAULT NULL,
|
`LONG_` bigint(20) DEFAULT NULL,
|
`TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
`TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`),
|
KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
|
KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
|
KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
|
CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_variable
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `tb_bill`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_bill`;
|
CREATE TABLE `tb_bill` (
|
`bill_id` int(11) NOT NULL AUTO_INCREMENT,
|
`name` varchar(255) DEFAULT NULL,
|
`type` varchar(255) DEFAULT NULL,
|
`reason` varchar(255) DEFAULT NULL,
|
`startTime` varchar(255) DEFAULT NULL,
|
`endTime` varchar(255) DEFAULT NULL,
|
`reMark` varchar(255) DEFAULT NULL,
|
`status` varchar(255) DEFAULT NULL,
|
PRIMARY KEY (`bill_id`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_bill
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for `tb_dept`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_dept`;
|
CREATE TABLE `tb_dept` (
|
`dept_id` int(11) NOT NULL AUTO_INCREMENT,
|
`dept_name` varchar(255) NOT NULL,
|
`dept_desc` varchar(255) DEFAULT NULL,
|
PRIMARY KEY (`dept_id`),
|
UNIQUE KEY `dept_name` (`dept_name`)
|
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_dept
|
-- ----------------------------
|
INSERT INTO `tb_dept` VALUES ('1', 'Êг¡²¿', 'Êг¡');
|
INSERT INTO `tb_dept` VALUES ('2', 'ÈËʲ¿', 'ÈËÊÂ');
|
INSERT INTO `tb_dept` VALUES ('3', 'it²¿', '¼¼Êõ');
|
INSERT INTO `tb_dept` VALUES ('4', '¶ÊÂ', '¶ÊÂ');
|
INSERT INTO `tb_dept` VALUES ('6', 'fdffds', 'fd');
|
INSERT INTO `tb_dept` VALUES ('7', '111', '');
|
INSERT INTO `tb_dept` VALUES ('11', '×éÖ¯²¿', 'wwwwwwww');
|
|
-- ----------------------------
|
-- Table structure for `tb_dept_opt`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_dept_opt`;
|
CREATE TABLE `tb_dept_opt` (
|
`dopt_id` int(11) NOT NULL AUTO_INCREMENT,
|
`d_id` int(11) DEFAULT NULL,
|
`dopt_name` varchar(255) DEFAULT NULL,
|
`dopt_type` varchar(255) DEFAULT NULL,
|
`dopt_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`dopt_id`),
|
KEY `did` (`d_id`),
|
CONSTRAINT `did` FOREIGN KEY (`d_id`) REFERENCES `tb_dept` (`dept_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_dept_opt
|
-- ----------------------------
|
INSERT INTO `tb_dept_opt` VALUES ('6', '6', 'admins', 'Ìí¼Ó', '2017-12-18 13:14:35');
|
INSERT INTO `tb_dept_opt` VALUES ('7', '7', 'admins', 'Ìí¼Ó', '2017-12-18 13:17:10');
|
INSERT INTO `tb_dept_opt` VALUES ('11', '7', 'admins', '¸üÐÂ', '2017-12-18 13:29:25');
|
INSERT INTO `tb_dept_opt` VALUES ('12', '7', 'admins', '¸üÐÂ', '2017-12-18 14:11:23');
|
INSERT INTO `tb_dept_opt` VALUES ('13', '11', 'admins', 'Ìí¼Ó', '2017-12-18 14:11:51');
|
INSERT INTO `tb_dept_opt` VALUES ('15', '11', 'admins', '¸üÐÂ', '2017-12-18 15:16:23');
|
INSERT INTO `tb_dept_opt` VALUES ('16', '6', 'admins', '¸üÐÂ', '2017-12-18 15:16:54');
|
INSERT INTO `tb_dept_opt` VALUES ('18', '7', 'admins', '¸üÐÂ', '2017-12-20 16:35:21');
|
INSERT INTO `tb_dept_opt` VALUES ('19', '11', 'admins', '¸üÐÂ', '2017-12-21 10:07:32');
|
|
-- ----------------------------
|
-- Table structure for `tb_menu`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_menu`;
|
CREATE TABLE `tb_menu` (
|
`menu_id` int(11) NOT NULL AUTO_INCREMENT,
|
`menu_name` varchar(255) DEFAULT NULL,
|
`url` varchar(255) DEFAULT NULL,
|
`parentID` int(11) DEFAULT NULL,
|
`icon` varchar(255) DEFAULT NULL,
|
`statu` varchar(255) DEFAULT NULL,
|
PRIMARY KEY (`menu_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=204 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_menu
|
-- ----------------------------
|
INSERT INTO `tb_menu` VALUES ('1', 'ϵͳ¹ÜÀí', null, '0', 'fa fa-cog', '0');
|
INSERT INTO `tb_menu` VALUES ('2', 'Á÷³Ì¹ÜÀí', null, '0', 'fa fa-random', '0');
|
INSERT INTO `tb_menu` VALUES ('3', '±¨±í¹ÜÀí', 'user/goChar.action', '0', 'fa fa-list-alt', '0');
|
INSERT INTO `tb_menu` VALUES ('101', '²Ëµ¥¹ÜÀí', 'user/goMenu.action', '1', 'fa fa-th-large', '0');
|
INSERT INTO `tb_menu` VALUES ('102', 'Óû§¹ÜÀí', 'user/goUser.action', '1', 'fa fa-user', '0');
|
INSERT INTO `tb_menu` VALUES ('103', '²¿ÃŹÜÀí', 'dept/goDept.action', '1', 'fa fa-home', '0');
|
INSERT INTO `tb_menu` VALUES ('104', '½ÇÉ«¹ÜÀí', 'user/goRole.action', '1', 'fa fa-globe', '0');
|
INSERT INTO `tb_menu` VALUES ('105', 'ȨÏÞ¹ÜÀí', 'user/goAuth.action', '1', 'fa fa-lock', '1');
|
INSERT INTO `tb_menu` VALUES ('201', 'ÎÒµÄÇëÇó', 'activiti/goQuest.action', '2', 'fa fa-comment', '0');
|
INSERT INTO `tb_menu` VALUES ('202', 'ÎÒµÄÈÎÎñ', 'activiti/goTask.action', '2', 'fa fa-tasks', '0');
|
INSERT INTO `tb_menu` VALUES ('203', 'Á÷³Ì²¿Êð', 'activiti/goProcess.action', '2', 'fa fa-wrench', '0');
|
|
-- ----------------------------
|
-- Table structure for `tb_role`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_role`;
|
CREATE TABLE `tb_role` (
|
`role_id` int(11) NOT NULL AUTO_INCREMENT,
|
`role_name` varchar(255) DEFAULT NULL,
|
`role_desc` varchar(255) DEFAULT NULL,
|
`pid` int(11) DEFAULT NULL,
|
PRIMARY KEY (`role_id`),
|
UNIQUE KEY `f` (`role_name`)
|
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_role
|
-- ----------------------------
|
INSERT INTO `tb_role` VALUES ('1', 'ÆÕͨԱ¹¤', '¹«Ë¾ÆÕͨԱ¹¤', '4');
|
INSERT INTO `tb_role` VALUES ('2', '²¿ÃžÀí', '²¿ÃžÀí', '3');
|
INSERT INTO `tb_role` VALUES ('3', '×ܾÀí', '×ܾÀí', '0');
|
INSERT INTO `tb_role` VALUES ('4', '×鳤', '×鳤', '2');
|
|
-- ----------------------------
|
-- Table structure for `tb_role_menu`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_role_menu`;
|
CREATE TABLE `tb_role_menu` (
|
`rm_id` int(11) NOT NULL AUTO_INCREMENT,
|
`menu_id` int(11) DEFAULT NULL,
|
`role_id` int(11) DEFAULT NULL,
|
PRIMARY KEY (`rm_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_role_menu
|
-- ----------------------------
|
INSERT INTO `tb_role_menu` VALUES ('20', '1', '1');
|
INSERT INTO `tb_role_menu` VALUES ('21', '101', '1');
|
INSERT INTO `tb_role_menu` VALUES ('22', '2', '1');
|
INSERT INTO `tb_role_menu` VALUES ('23', '201', '1');
|
INSERT INTO `tb_role_menu` VALUES ('24', '3', '1');
|
INSERT INTO `tb_role_menu` VALUES ('25', '4', '1');
|
INSERT INTO `tb_role_menu` VALUES ('48', '1', '2');
|
INSERT INTO `tb_role_menu` VALUES ('49', '102', '2');
|
INSERT INTO `tb_role_menu` VALUES ('50', '103', '2');
|
INSERT INTO `tb_role_menu` VALUES ('51', '2', '2');
|
INSERT INTO `tb_role_menu` VALUES ('52', '201', '2');
|
INSERT INTO `tb_role_menu` VALUES ('53', '202', '2');
|
INSERT INTO `tb_role_menu` VALUES ('54', '3', '2');
|
INSERT INTO `tb_role_menu` VALUES ('55', '4', '2');
|
INSERT INTO `tb_role_menu` VALUES ('56', '1', '3');
|
INSERT INTO `tb_role_menu` VALUES ('57', '101', '3');
|
INSERT INTO `tb_role_menu` VALUES ('58', '102', '3');
|
INSERT INTO `tb_role_menu` VALUES ('59', '103', '3');
|
INSERT INTO `tb_role_menu` VALUES ('60', '104', '3');
|
INSERT INTO `tb_role_menu` VALUES ('61', '2', '3');
|
INSERT INTO `tb_role_menu` VALUES ('62', '201', '3');
|
INSERT INTO `tb_role_menu` VALUES ('63', '202', '3');
|
INSERT INTO `tb_role_menu` VALUES ('64', '203', '3');
|
INSERT INTO `tb_role_menu` VALUES ('65', '3', '3');
|
INSERT INTO `tb_role_menu` VALUES ('66', '4', '3');
|
INSERT INTO `tb_role_menu` VALUES ('67', '1', '5');
|
INSERT INTO `tb_role_menu` VALUES ('68', '101', '5');
|
INSERT INTO `tb_role_menu` VALUES ('69', '102', '5');
|
INSERT INTO `tb_role_menu` VALUES ('70', '2', '5');
|
INSERT INTO `tb_role_menu` VALUES ('71', '201', '5');
|
INSERT INTO `tb_role_menu` VALUES ('72', '3', '5');
|
INSERT INTO `tb_role_menu` VALUES ('73', '4', '5');
|
INSERT INTO `tb_role_menu` VALUES ('81', '1', '4');
|
INSERT INTO `tb_role_menu` VALUES ('82', '101', '4');
|
INSERT INTO `tb_role_menu` VALUES ('83', '102', '4');
|
INSERT INTO `tb_role_menu` VALUES ('84', '2', '4');
|
INSERT INTO `tb_role_menu` VALUES ('85', '201', '4');
|
INSERT INTO `tb_role_menu` VALUES ('86', '202', '4');
|
INSERT INTO `tb_role_menu` VALUES ('87', '3', '4');
|
INSERT INTO `tb_role_menu` VALUES ('88', '4', '4');
|
|
-- ----------------------------
|
-- Table structure for `tb_role_opt`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_role_opt`;
|
CREATE TABLE `tb_role_opt` (
|
`ropt_id` int(11) NOT NULL AUTO_INCREMENT,
|
`r_id` int(11) DEFAULT NULL,
|
`ropt_name` varchar(255) DEFAULT NULL,
|
`ropt_type` varchar(255) DEFAULT NULL,
|
`ropt_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`ropt_id`),
|
KEY `fd` (`r_id`),
|
CONSTRAINT `fd` FOREIGN KEY (`r_id`) REFERENCES `tb_role` (`role_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_role_opt
|
-- ----------------------------
|
INSERT INTO `tb_role_opt` VALUES ('2', '3', 'admins', 'ÐÞ¸Ä', '2017-12-22 16:26:57');
|
|
-- ----------------------------
|
-- Table structure for `tb_user`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_user`;
|
CREATE TABLE `tb_user` (
|
`user_id` int(11) NOT NULL AUTO_INCREMENT,
|
`dept_id` int(11) DEFAULT NULL,
|
`user_account` varchar(100) DEFAULT NULL,
|
`user_password` varchar(100) DEFAULT NULL,
|
`user_name` varchar(100) DEFAULT NULL,
|
`img` varchar(200) DEFAULT NULL,
|
`user_age` int(11) DEFAULT NULL,
|
`user_sex` varchar(10) DEFAULT NULL,
|
`user_address` varchar(200) DEFAULT NULL,
|
`user_birth` date DEFAULT NULL,
|
`user_phone` varchar(100) DEFAULT NULL,
|
`email` varchar(100) DEFAULT NULL,
|
`reg_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`user_id`),
|
UNIQUE KEY `user_account` (`user_account`)
|
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_user
|
-- ----------------------------
|
INSERT INTO `tb_user` VALUES ('1', '4', 'admin', '111111', 'admins', null, '34', 'Å®', 'FGG', '2017-12-07', '34433434', 'rg233@GF', null);
|
INSERT INTO `tb_user` VALUES ('2', '3', 'zuidaima', '111111', '×î´úÂë', null, '23', 'ÄÐ', 'gg', '2017-12-13', '23232322', 'vv@df', null);
|
INSERT INTO `tb_user` VALUES ('9', '1', 'df', '111111', 'df', null, '12', 'ÄÐ', 'fg', '2017-11-28', '122121212', 'fd@fd', '2017-10-21 09:46:40');
|
INSERT INTO `tb_user` VALUES ('11', '12', 'e', '111111', 'we', null, '12', 'Å®', 'df', '2017-11-28', '23232323', 'sfdd@fd', '2017-12-21 10:03:22');
|
INSERT INTO `tb_user` VALUES ('12', '11', 'ff', '111111', 'w', null, '22', 'ÄÐ', 'ff', '2017-12-04', '11222333', 'ss@w', '2017-11-21 10:07:10');
|
INSERT INTO `tb_user` VALUES ('13', '7', 'er', '111111', 'df', null, '23', 'Å®', 'er', '2017-12-05', '23232332', 'fd@fd', '2017-12-21 13:33:57');
|
INSERT INTO `tb_user` VALUES ('14', null, 'd', 'aaaaaa', 'df2332', null, null, null, '·¢¸ø', null, '3443-3434', null, '2017-12-26 13:52:19');
|
INSERT INTO `tb_user` VALUES ('15', '2', 'gg', '111111', 'gg', null, '11', 'ÄÐ', 'hik', '2017-11-27', '111111111', '1sw@ww', '2017-12-27 11:36:30');
|
|
-- ----------------------------
|
-- Table structure for `tb_user_opt`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_user_opt`;
|
CREATE TABLE `tb_user_opt` (
|
`uopt_id` int(11) NOT NULL AUTO_INCREMENT,
|
`u_id` int(11) DEFAULT NULL,
|
`uopt_name` varchar(100) DEFAULT NULL,
|
`uopt_type` varchar(100) DEFAULT NULL,
|
`uopt_time` datetime DEFAULT NULL,
|
PRIMARY KEY (`uopt_id`),
|
KEY `u_id` (`u_id`),
|
CONSTRAINT `tb_user_opt_ibfk_1` FOREIGN KEY (`u_id`) REFERENCES `tb_user` (`user_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_user_opt
|
-- ----------------------------
|
INSERT INTO `tb_user_opt` VALUES ('1', '1', 'admins', 'ÐÞ¸Ä', '2017-12-19 11:17:26');
|
INSERT INTO `tb_user_opt` VALUES ('5', '2', 'admins', 'ÐÞ¸Ä', '2017-12-19 17:25:59');
|
INSERT INTO `tb_user_opt` VALUES ('6', '2', 'admins', 'ÐÞ¸Ä', '2017-12-19 17:27:47');
|
INSERT INTO `tb_user_opt` VALUES ('7', '1', 'admins', 'ÐÞ¸Ä', '2017-12-19 17:28:12');
|
INSERT INTO `tb_user_opt` VALUES ('8', '2', 'admins', 'ÐÞ¸Ä', '2017-12-19 17:28:49');
|
INSERT INTO `tb_user_opt` VALUES ('13', '9', 'admins', 'Ìí¼Ó', '2017-12-21 09:46:40');
|
INSERT INTO `tb_user_opt` VALUES ('15', '11', 'admins', 'Ìí¼Ó', '2017-12-21 10:03:22');
|
INSERT INTO `tb_user_opt` VALUES ('16', '11', 'admins', 'ÐÞ¸Ä', '2017-12-21 10:05:03');
|
INSERT INTO `tb_user_opt` VALUES ('17', '12', 'admins', 'Ìí¼Ó', '2017-12-21 10:07:10');
|
INSERT INTO `tb_user_opt` VALUES ('18', '13', 'admins', 'Ìí¼Ó', '2017-12-21 13:33:57');
|
INSERT INTO `tb_user_opt` VALUES ('19', '13', 'admins', 'ÐÞ¸Ä', '2017-12-27 11:08:39');
|
INSERT INTO `tb_user_opt` VALUES ('20', '1', 'admins', 'ÐÞ¸Ä', '2017-12-27 11:20:12');
|
INSERT INTO `tb_user_opt` VALUES ('21', '15', 'admins', 'Ìí¼Ó', '2017-12-27 11:36:30');
|
|
-- ----------------------------
|
-- Table structure for `tb_user_role`
|
-- ----------------------------
|
DROP TABLE IF EXISTS `tb_user_role`;
|
CREATE TABLE `tb_user_role` (
|
`ur_id` int(11) NOT NULL AUTO_INCREMENT,
|
`user_id` int(11) DEFAULT NULL,
|
`role_id` int(11) DEFAULT NULL,
|
PRIMARY KEY (`ur_id`)
|
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;
|
|
-- ----------------------------
|
-- Records of tb_user_role
|
-- ----------------------------
|
INSERT INTO `tb_user_role` VALUES ('1', '1', '3');
|
INSERT INTO `tb_user_role` VALUES ('2', '2', '2');
|
INSERT INTO `tb_user_role` VALUES ('4', '11', '1');
|
INSERT INTO `tb_user_role` VALUES ('13', '13', '1');
|
INSERT INTO `tb_user_role` VALUES ('15', '12', '4');
|
INSERT INTO `tb_user_role` VALUES ('16', '12', '5');
|
INSERT INTO `tb_user_role` VALUES ('17', '9', '4');
|
