代码拉取完成，页面将自动刷新
同步操作将从 周老兽/jeasyframe 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Source Server Version : 50612
Source Host : localhost
Source Database : gmms_db
Target Server Type : MySQL
Target Server Version : 50612
File Encoding : utf-8
Date: 09/24/2013 19:24:35 PM
*/
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for `jbpm4_deployment`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_deployment`;
CREATE TABLE `jbpm4_deployment` (
`DBID_` bigint(20) NOT NULL,
`NAME_` text,
`TIMESTAMP_` bigint(20) DEFAULT NULL,
`STATE_` varchar(255) DEFAULT NULL,
PRIMARY KEY (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_deployprop`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_deployprop`;
CREATE TABLE `jbpm4_deployprop` (
`DBID_` bigint(20) NOT NULL,
`DEPLOYMENT_` bigint(20) DEFAULT NULL,
`OBJNAME_` varchar(255) DEFAULT NULL,
`KEY_` varchar(255) DEFAULT NULL,
`STRINGVAL_` varchar(255) DEFAULT NULL,
`LONGVAL_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `FK_DEPLPROP_DEPL` (`DEPLOYMENT_`),
KEY `IDX_DEPLPROP_DEPL` (`DEPLOYMENT_`),
CONSTRAINT `FK_DEPLPROP_DEPL` FOREIGN KEY (`DEPLOYMENT_`) REFERENCES `jbpm4_deployment` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_execution`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_execution`;
CREATE TABLE `jbpm4_execution` (
`DBID_` bigint(20) NOT NULL,
`CLASS_` varchar(255) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`ACTIVITYNAME_` varchar(255) DEFAULT NULL,
`PROCDEFID_` varchar(255) DEFAULT NULL,
`HASVARS_` bit(1) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`KEY_` varchar(255) DEFAULT NULL,
`ID_` varchar(255) DEFAULT NULL,
`OWNER_` varchar(255) DEFAULT NULL,
`STATE_` varchar(255) DEFAULT NULL,
`SUSPHISTSTATE_` varchar(255) DEFAULT NULL,
`PRIORITY_` int(11) DEFAULT NULL,
`HISACTINST_` bigint(20) DEFAULT NULL,
`PARENT_` bigint(20) DEFAULT NULL,
`INSTANCE_` bigint(20) DEFAULT NULL,
`SUPEREXEC_` bigint(20) DEFAULT NULL,
`SUBPROCINST_` bigint(20) DEFAULT NULL,
`PARENT_IDX_` int(11) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
UNIQUE KEY `ID_` (`ID_`),
KEY `FK_EXEC_SUBPI` (`SUBPROCINST_`),
KEY `FK_EXEC_INSTANCE` (`INSTANCE_`),
KEY `FK_EXEC_SUPEREXEC` (`SUPEREXEC_`),
KEY `FK_EXEC_PARENT` (`PARENT_`),
KEY `IDX_EXEC_SUBPI` (`SUBPROCINST_`),
KEY `IDX_EXEC_PARENT` (`PARENT_`),
KEY `IDX_EXEC_SUPEREXEC` (`SUPEREXEC_`),
KEY `IDX_EXEC_INSTANCE` (`INSTANCE_`),
CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`),
CONSTRAINT `FK_EXEC_PARENT` FOREIGN KEY (`PARENT_`) REFERENCES `jbpm4_execution` (`DBID_`),
CONSTRAINT `FK_EXEC_SUBPI` FOREIGN KEY (`SUBPROCINST_`) REFERENCES `jbpm4_execution` (`DBID_`),
CONSTRAINT `FK_EXEC_SUPEREXEC` FOREIGN KEY (`SUPEREXEC_`) REFERENCES `jbpm4_execution` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_form`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_form`;
CREATE TABLE `jbpm4_form` (
`DBID_` bigint(20) NOT NULL,
`URL_` varchar(255) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`DESCR_` text,
`STATE_` varchar(255) DEFAULT NULL,
`HEIGHT_` int(11) DEFAULT NULL,
`WIDTH_` int(11) DEFAULT NULL,
`PREVIEW_` varchar(255) DEFAULT NULL,
PRIMARY KEY (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_hist_actinst`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_hist_actinst`;
CREATE TABLE `jbpm4_hist_actinst` (
`DBID_` bigint(20) NOT NULL,
`HPROCI_` bigint(20) DEFAULT NULL,
`TYPE_` varchar(255) DEFAULT NULL,
`ACTIVITY_NAME_` varchar(255) DEFAULT NULL,
`TRANSITION_` varchar(255) DEFAULT NULL,
`DESTINATION_` varchar(255) DEFAULT NULL,
`TIME_` datetime DEFAULT NULL,
`USERID_` varchar(255) DEFAULT NULL,
PRIMARY KEY (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_hist_detail`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_hist_detail`;
CREATE TABLE `jbpm4_hist_detail` (
`DBID_` bigint(20) NOT NULL,
`CLASS_` varchar(255) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`USERID_` varchar(255) DEFAULT NULL,
`TIME_` datetime DEFAULT NULL,
`HPROCI_` bigint(20) DEFAULT NULL,
`HPROCIIDX_` int(11) DEFAULT NULL,
`HACTI_` bigint(20) DEFAULT NULL,
`HACTIIDX_` int(11) DEFAULT NULL,
`HTASK_` bigint(20) DEFAULT NULL,
`HTASKIDX_` int(11) DEFAULT NULL,
`HVAR_` bigint(20) DEFAULT NULL,
`HVARIDX_` int(11) DEFAULT NULL,
`MESSAGE_` text,
`OLD_STR_` varchar(255) DEFAULT NULL,
`NEW_STR_` varchar(255) DEFAULT NULL,
`OLD_INT_` int(11) DEFAULT NULL,
`NEW_INT_` int(11) DEFAULT NULL,
`OLD_TIME_` datetime DEFAULT NULL,
`NEW_TIME_` datetime DEFAULT NULL,
`PARENT_` bigint(20) DEFAULT NULL,
`PARENT_IDX_` int(11) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `FK_HDETAIL_HVAR` (`HVAR_`),
KEY `FK_HDETAIL_HPROCI` (`HPROCI_`),
KEY `FK_HDETAIL_HTASK` (`HTASK_`),
KEY `FK_HDETAIL_HACTI` (`HACTI_`),
KEY `IDX_HDET_HVAR` (`HVAR_`),
KEY `IDX_HDET_HACTI` (`HACTI_`),
KEY `IDX_HDET_HTASK` (`HTASK_`),
KEY `IDX_HDET_HPROCI` (`HPROCI_`),
CONSTRAINT `FK_HDETAIL_HACTI` FOREIGN KEY (`HACTI_`) REFERENCES `jbpm4_hist_actinst` (`DBID_`),
CONSTRAINT `FK_HDETAIL_HPROCI` FOREIGN KEY (`HPROCI_`) REFERENCES `jbpm4_hist_procinst` (`DBID_`),
CONSTRAINT `FK_HDETAIL_HTASK` FOREIGN KEY (`HTASK_`) REFERENCES `jbpm4_hist_task` (`DBID_`),
CONSTRAINT `FK_HDETAIL_HVAR` FOREIGN KEY (`HVAR_`) REFERENCES `jbpm4_hist_var` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_hist_procinst`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_hist_procinst`;
CREATE TABLE `jbpm4_hist_procinst` (
`DBID_` bigint(20) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`ID_` varchar(255) DEFAULT NULL,
`PROCDEFID_` varchar(255) DEFAULT NULL,
`KEY_` varchar(255) DEFAULT NULL,
`START_` datetime DEFAULT NULL,
`END_` datetime DEFAULT NULL,
`DURATION_` bigint(20) DEFAULT NULL,
`STATE_` varchar(255) DEFAULT NULL,
`ENDACTIVITY_` varchar(255) DEFAULT NULL,
`OWNER_` varchar(255) DEFAULT NULL,
PRIMARY KEY (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_hist_task`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_hist_task`;
CREATE TABLE `jbpm4_hist_task` (
`DBID_` bigint(20) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`EXECUTION_` varchar(255) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`DESCR_` text,
`OUTCOME_` varchar(255) DEFAULT NULL,
`OPERATOR_` varchar(255) DEFAULT NULL,
`ASSIGNEE_` varchar(255) DEFAULT NULL,
`PRIORITY_` int(11) DEFAULT NULL,
`STATE_` varchar(255) DEFAULT NULL,
`CREATE_` datetime DEFAULT NULL,
`END_` datetime DEFAULT NULL,
`DURATION_` bigint(20) DEFAULT NULL,
`COUNTERSIGN_` varchar(255) DEFAULT NULL,
`COUNTERSIGNTYPE_` int(11) DEFAULT NULL,
`SUPERTASK_` varchar(255) DEFAULT NULL,
`PROCDEFID_` varchar(255) DEFAULT NULL,
`NEXTIDX_` int(11) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `IDX_HSUPERT_SUB` (`SUPERTASK_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_hist_var`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_hist_var`;
CREATE TABLE `jbpm4_hist_var` (
`DBID_` bigint(20) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`PROCINSTID_` varchar(255) DEFAULT NULL,
`EXECUTIONID_` varchar(255) DEFAULT NULL,
`VARNAME_` varchar(255) DEFAULT NULL,
`VALUE_` varchar(255) DEFAULT NULL,
`HPROCI_` bigint(20) DEFAULT NULL,
`HTASK_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `FK_HVAR_HPROCI` (`HPROCI_`),
KEY `FK_HVAR_HTASK` (`HTASK_`),
KEY `IDX_HVAR_HTASK` (`HTASK_`),
KEY `IDX_HVAR_HPROCI` (`HPROCI_`),
CONSTRAINT `FK_HVAR_HPROCI` FOREIGN KEY (`HPROCI_`) REFERENCES `jbpm4_hist_procinst` (`DBID_`),
CONSTRAINT `FK_HVAR_HTASK` FOREIGN KEY (`HTASK_`) REFERENCES `jbpm4_hist_task` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_job`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_job`;
CREATE TABLE `jbpm4_job` (
`DBID_` bigint(20) NOT NULL,
`CLASS_` varchar(255) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`DUEDATE_` datetime DEFAULT NULL,
`STATE_` varchar(255) DEFAULT NULL,
`ISEXCLUSIVE_` bit(1) DEFAULT NULL,
`LOCKOWNER_` varchar(255) DEFAULT NULL,
`LOCKEXPTIME_` datetime DEFAULT NULL,
`EXCEPTION_` text,
`RETRIES_` int(11) DEFAULT NULL,
`PROCESSINSTANCE_` bigint(20) DEFAULT NULL,
`EXECUTION_` bigint(20) DEFAULT NULL,
`CFG_` bigint(20) DEFAULT NULL,
`SIGNAL_` varchar(255) DEFAULT NULL,
`EVENT_` varchar(255) DEFAULT NULL,
`REPEAT_` varchar(255) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `FK_JOB_CFG` (`CFG_`),
KEY `IDX_JOBRETRIES` (`RETRIES_`),
KEY `IDX_JOBDUEDATE` (`DUEDATE_`),
KEY `IDX_JOBLOCKEXP` (`LOCKEXPTIME_`),
KEY `IDX_JOB_CFG` (`CFG_`),
KEY `IDX_JOB_EXE` (`EXECUTION_`),
KEY `IDX_JOB_PRINST` (`PROCESSINSTANCE_`),
CONSTRAINT `FK_JOB_CFG` FOREIGN KEY (`CFG_`) REFERENCES `jbpm4_lob` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_lob`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_lob`;
CREATE TABLE `jbpm4_lob` (
`DBID_` bigint(20) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`BLOB_VALUE_` blob,
`DEPLOYMENT_` bigint(20) DEFAULT NULL,
`NAME_` text,
PRIMARY KEY (`DBID_`),
KEY `FK_LOB_DEPLOYMENT` (`DEPLOYMENT_`),
KEY `IDX_LOB_DEPLOYMENT` (`DEPLOYMENT_`),
CONSTRAINT `FK_LOB_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_`) REFERENCES `jbpm4_deployment` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_participation`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_participation`;
CREATE TABLE `jbpm4_participation` (
`DBID_` bigint(20) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`GROUPID_` varchar(255) DEFAULT NULL,
`USERID_` varchar(255) DEFAULT NULL,
`TYPE_` varchar(255) DEFAULT NULL,
`TASK_` bigint(20) DEFAULT NULL,
`SWIMLANE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `FK_PART_SWIMLANE` (`SWIMLANE_`),
KEY `FK_PART_TASK` (`TASK_`),
KEY `IDX_PART_TASK` (`TASK_`),
CONSTRAINT `FK_PART_SWIMLANE` FOREIGN KEY (`SWIMLANE_`) REFERENCES `jbpm4_swimlane` (`DBID_`),
CONSTRAINT `FK_PART_TASK` FOREIGN KEY (`TASK_`) REFERENCES `jbpm4_task` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_property`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_property`;
CREATE TABLE `jbpm4_property` (
`KEY_` varchar(255) NOT NULL,
`VERSION_` int(11) NOT NULL,
`VALUE_` varchar(255) DEFAULT NULL,
PRIMARY KEY (`KEY_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `jbpm4_property`
-- ----------------------------
BEGIN;
INSERT INTO `jbpm4_property` VALUES ('next.dbid', '0', '1');
COMMIT;
-- ----------------------------
-- Table structure for `jbpm4_swimlane`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_swimlane`;
CREATE TABLE `jbpm4_swimlane` (
`DBID_` bigint(20) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`ASSIGNEE_` varchar(255) DEFAULT NULL,
`EXECUTION_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `FK_SWIMLANE_EXEC` (`EXECUTION_`),
KEY `IDX_SWIMLANE_EXEC` (`EXECUTION_`),
CONSTRAINT `FK_SWIMLANE_EXEC` FOREIGN KEY (`EXECUTION_`) REFERENCES `jbpm4_execution` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_task`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_task`;
CREATE TABLE `jbpm4_task` (
`DBID_` bigint(20) NOT NULL,
`CLASS_` char(1) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`DESCR_` text,
`STATE_` varchar(255) DEFAULT NULL,
`SUSPHISTSTATE_` varchar(255) DEFAULT NULL,
`ASSIGNEE_` varchar(255) DEFAULT NULL,
`FORM_` varchar(255) DEFAULT NULL,
`COUNTERSIGN_` varchar(255) DEFAULT NULL,
`COUNTERSIGNTYPE_` int(11) DEFAULT NULL,
`PROCDEFID_` varchar(255) DEFAULT NULL,
`PRIORITY_` int(11) DEFAULT NULL,
`CREATE_` datetime DEFAULT NULL,
`DUEDATE_` datetime DEFAULT NULL,
`PROGRESS_` int(11) DEFAULT NULL,
`SIGNALLING_` bit(1) DEFAULT NULL,
`EXECUTION_ID_` varchar(255) DEFAULT NULL,
`ACTIVITY_NAME_` varchar(255) DEFAULT NULL,
`HASVARS_` bit(1) DEFAULT NULL,
`SUPERTASK_` bigint(20) DEFAULT NULL,
`EXECUTION_` bigint(20) DEFAULT NULL,
`PROCINST_` bigint(20) DEFAULT NULL,
`SWIMLANE_` bigint(20) DEFAULT NULL,
`TASKDEFNAME_` varchar(255) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `FK_TASK_SWIML` (`SWIMLANE_`),
KEY `FK_TASK_SUPERTASK` (`SUPERTASK_`),
KEY `IDX_TASK_SUPERTASK` (`SUPERTASK_`),
CONSTRAINT `FK_TASK_SUPERTASK` FOREIGN KEY (`SUPERTASK_`) REFERENCES `jbpm4_task` (`DBID_`),
CONSTRAINT `FK_TASK_SWIML` FOREIGN KEY (`SWIMLANE_`) REFERENCES `jbpm4_swimlane` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `jbpm4_variable`
-- ----------------------------
DROP TABLE IF EXISTS `jbpm4_variable`;
CREATE TABLE `jbpm4_variable` (
`DBID_` bigint(20) NOT NULL,
`CLASS_` varchar(255) NOT NULL,
`DBVERSION_` int(11) NOT NULL,
`KEY_` varchar(255) DEFAULT NULL,
`CONVERTER_` varchar(255) DEFAULT NULL,
`HIST_` bit(1) DEFAULT NULL,
`EXECUTION_` bigint(20) DEFAULT NULL,
`TASK_` bigint(20) DEFAULT NULL,
`LOB_` bigint(20) DEFAULT NULL,
`DATE_VALUE_` datetime DEFAULT NULL,
`DOUBLE_VALUE_` double DEFAULT NULL,
`CLASSNAME_` varchar(255) DEFAULT NULL,
`LONG_VALUE_` bigint(20) DEFAULT NULL,
`STRING_VALUE_` varchar(255) DEFAULT NULL,
`TEXT_VALUE_` text,
`EXESYS_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`DBID_`),
KEY `FK_VAR_EXESYS` (`EXESYS_`),
KEY `FK_VAR_LOB` (`LOB_`),
KEY `FK_VAR_TASK` (`TASK_`),
KEY `FK_VAR_EXECUTION` (`EXECUTION_`),
KEY `IDX_VAR_EXESYS` (`EXESYS_`),
KEY `IDX_VAR_TASK` (`TASK_`),
KEY `IDX_VAR_EXECUTION` (`EXECUTION_`),
KEY `IDX_VAR_LOB` (`LOB_`),
CONSTRAINT `FK_VAR_EXECUTION` FOREIGN KEY (`EXECUTION_`) REFERENCES `jbpm4_execution` (`DBID_`),
CONSTRAINT `FK_VAR_EXESYS` FOREIGN KEY (`EXESYS_`) REFERENCES `jbpm4_execution` (`DBID_`),
CONSTRAINT `FK_VAR_LOB` FOREIGN KEY (`LOB_`) REFERENCES `jbpm4_lob` (`DBID_`),
CONSTRAINT `FK_VAR_TASK` FOREIGN KEY (`TASK_`) REFERENCES `jbpm4_task` (`DBID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_announcement`
-- ----------------------------
DROP TABLE IF EXISTS `tb_announcement`;
CREATE TABLE `tb_announcement` (
`ANNOUNCEMENT_ID` int(11) NOT NULL AUTO_INCREMENT,
`ANNOUNCEMENT_TITLE` varchar(128) DEFAULT NULL,
`ANNOUNCEMENT_CONTENT` text,
`START_DATE` datetime DEFAULT NULL,
`END_DATE` datetime DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
PRIMARY KEY (`ANNOUNCEMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_attachment`
-- ----------------------------
DROP TABLE IF EXISTS `tb_attachment`;
CREATE TABLE `tb_attachment` (
`ATTACHMENT_ID` int(11) NOT NULL AUTO_INCREMENT,
`ATTACHMENT_NAME` varchar(128) DEFAULT NULL,
`ATTACHMENT_PATH` text,
`EMAIL_ID` int(11) DEFAULT NULL,
`ATTACHMENT_TYPE` int(11) DEFAULT NULL,
PRIMARY KEY (`ATTACHMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_authority`
-- ----------------------------
DROP TABLE IF EXISTS `tb_authority`;
CREATE TABLE `tb_authority` (
`AUTHORITY_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`AUTHORITY_NAME` varchar(128) DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`OP_USER` bigint(20) DEFAULT NULL,
`REMARK` text,
`COMPANY_ID` bigint(20) DEFAULT NULL,
`DEPARTMENT_ID` bigint(20) DEFAULT NULL,
`AUTHORITY_NO` varchar(128) DEFAULT NULL,
`AUTO_AUTHORITY_FLAG` int(11) DEFAULT NULL,
PRIMARY KEY (`AUTHORITY_ID`),
KEY `FK7B405EB21EDF38C4` (`DEPARTMENT_ID`),
KEY `FK7B405EB2AE09C3FB` (`COMPANY_ID`),
KEY `FK7B405EB2BFF465` (`OP_USER`),
CONSTRAINT `FK7B405EB21EDF38C4` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `tb_department` (`DEPARTMENT_ID`),
CONSTRAINT `FK7B405EB2AE09C3FB` FOREIGN KEY (`COMPANY_ID`) REFERENCES `tb_company` (`COMPANY_ID`),
CONSTRAINT `FK7B405EB2BFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_authority`
-- ----------------------------
BEGIN;
INSERT INTO `tb_authority` VALUES ('1', '完全控制', '0', '2012-07-15 00:00:00', '2012-07-15 00:00:00', '1', null, '1', '1', '0001', '999'), ('2', '添加', '0', '2012-07-15 00:00:00', '2012-07-15 00:00:00', '1', null, '1', '1', '0002', '999'), ('3', '编辑', '0', '2012-07-15 00:00:00', '2012-07-15 00:00:00', '1', null, '1', '1', '0003', '999'), ('4', '删除', '0', '2012-07-15 00:00:00', '2012-07-15 00:00:00', '1', null, '1', '1', '0004', '999'), ('5', '模糊查询', '0', '2012-07-15 00:00:00', '2012-07-15 00:00:00', '1', null, '1', '1', '0005', '999'), ('6', '可见', '0', '2012-07-15 00:00:00', '2012-07-15 00:00:00', '1', null, '1', '1', '0006', '999'), ('8', '提交', '0', '2013-09-11 12:05:16', '2013-09-11 12:05:16', '1', '', '1', null, '0008', '0'), ('9', '审核', '0', '2013-09-11 13:54:16', '2013-09-11 13:54:16', '1', '', '1', null, '0009', '0');
COMMIT;
-- ----------------------------
-- Table structure for `tb_backlog`
-- ----------------------------
DROP TABLE IF EXISTS `tb_backlog`;
CREATE TABLE `tb_backlog` (
`BACKLOG_ID` int(11) NOT NULL AUTO_INCREMENT,
`BACKLOG_TITLE` varchar(255) DEFAULT NULL,
`BACKLOG_URL` varchar(255) DEFAULT NULL,
`KEY_NAME` varchar(255) DEFAULT NULL,
`KEY_VALUE` varchar(255) DEFAULT NULL,
`PARAM_STR` varchar(255) DEFAULT NULL,
`AUTO_FLAG` int(11) DEFAULT NULL,
`USER_ID` int(11) DEFAULT NULL,
`BACKLOG_STATE` int(11) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
PRIMARY KEY (`BACKLOG_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_company`
-- ----------------------------
DROP TABLE IF EXISTS `tb_company`;
CREATE TABLE `tb_company` (
`COMPANY_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`COMPANY_NAME` varchar(128) DEFAULT NULL,
`COMPANY_NO` varchar(128) DEFAULT NULL,
`PARENT_COMPANY_ID` bigint(20) DEFAULT NULL,
`CHILD_COMPANY_FLAG` int(11) DEFAULT NULL,
`COMPANY_LEGAL_PERSON` varchar(128) DEFAULT NULL,
`COMPANY_PHONE` varchar(128) DEFAULT NULL,
`COMPANY_FAX` varchar(128) DEFAULT NULL,
`COMPANY_EMAIL` varchar(128) DEFAULT NULL,
`COMPANY_ADDRESS` varchar(128) DEFAULT NULL,
`COMPANY_BIRTHDAY` varchar(128) DEFAULT NULL,
`COMPANY_PROJECT` varchar(128) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`REMARK` text,
`OP_USER` bigint(20) DEFAULT NULL,
`BACKUP_DATA` text,
`COMPANY_PATH` varchar(255) DEFAULT NULL,
PRIMARY KEY (`COMPANY_ID`),
KEY `FK38B0A3ACBFF465` (`OP_USER`),
CONSTRAINT `FK38B0A3ACBFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_company`
-- ----------------------------
BEGIN;
INSERT INTO `tb_company` VALUES ('1', '默认公司-不可修改和删除', '00000000', '0', '0', 'DJZHOU', '18686848328', '', '', '', '', '', '2012-01-01 00:00:00', '2012-07-19 13:00:40', '0', '', '1', null, ',0,'), ('4', 'Jeasyframe开发工作室', 'Jeasyframe开发工作室', '0', '0', '周东剑', '', '', '', '', '', '', '2013-07-10 13:37:00', '2013-09-24 16:42:34', '0', '', '1', null, ',0,');
COMMIT;
-- ----------------------------
-- Table structure for `tb_department`
-- ----------------------------
DROP TABLE IF EXISTS `tb_department`;
CREATE TABLE `tb_department` (
`DEPARTMENT_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`DEPARTMENT_NAME` varchar(128) DEFAULT NULL,
`DEPARTMENT_NO` varchar(128) DEFAULT NULL,
`DEPARTMENT_DUTY` varchar(128) DEFAULT NULL,
`PARENT_DEPARTMENT_ID` bigint(20) DEFAULT NULL,
`COMPANY_ID` bigint(20) DEFAULT NULL,
`DEPARTMENT_MANAGER` varchar(128) DEFAULT NULL,
`DEPARTMENT_PHONE` varchar(128) DEFAULT NULL,
`DEPARTMENT_FAX` varchar(128) DEFAULT NULL,
`DEPARTMENT_EMAIL` varchar(128) DEFAULT NULL,
`DEPARTMENT_ADDRESS` varchar(128) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`REMARK` text,
`OP_USER` bigint(20) DEFAULT NULL,
`BACKUP_DATA` text,
`DEPARTMENT_PATH` varchar(255) DEFAULT NULL,
PRIMARY KEY (`DEPARTMENT_ID`),
KEY `FK78CCD9C3AE09C3FB` (`COMPANY_ID`),
KEY `FK78CCD9C3BFF465` (`OP_USER`),
CONSTRAINT `FK78CCD9C3AE09C3FB` FOREIGN KEY (`COMPANY_ID`) REFERENCES `tb_company` (`COMPANY_ID`),
CONSTRAINT `FK78CCD9C3BFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_department`
-- ----------------------------
BEGIN;
INSERT INTO `tb_department` VALUES ('1', '默认部门', '00000000', '啥也不干', '0', '1', '周东剑', '18686848328', null, null, null, '2012-01-01 00:00:00', '2012-01-01 00:00:00', '0', null, '1', null, null), ('6', '财务部', '财务部', '', '0', '4', '', '', '', '', '', '2013-07-10 13:37:00', '2013-09-24 15:44:33', '0', '', '1', null, null), ('7', '人力资源部', '人力资源部', '', '0', '4', '', '', '', '', '', '2013-07-10 13:37:00', '2013-09-24 15:44:51', '0', '', '1', null, null), ('8', '调度部门', '调度部门', '', '0', '4', '', '', '', '', '', '2013-07-10 13:37:00', '2013-09-24 15:44:15', '0', '', '1', null, null), ('9', '不归属部门', 'NO_DEPARTMENT', '', '0', '4', '', '', '', '', '', '2013-07-10 13:48:03', '2013-07-10 13:48:03', '0', '', '1', null, null), ('10', '行政部', '行政部', '', '0', null, '', '', '', '', '', '2013-09-24 15:44:59', '2013-09-24 15:44:59', '0', '', '1', null, null);
COMMIT;
-- ----------------------------
-- Table structure for `tb_dictionary`
-- ----------------------------
DROP TABLE IF EXISTS `tb_dictionary`;
CREATE TABLE `tb_dictionary` (
`DICTIONARY_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`DICTIONARY_NAME` text,
`DICTIONARY_TYPE_ID` bigint(20) DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`REMARK` text,
`OP_USER` bigint(20) DEFAULT NULL,
`BACKUP_DATA` text,
PRIMARY KEY (`DICTIONARY_ID`),
KEY `FK60E407074D8AE90D` (`DICTIONARY_TYPE_ID`),
KEY `FK60E40707BFF465` (`OP_USER`),
CONSTRAINT `FK60E407074D8AE90D` FOREIGN KEY (`DICTIONARY_TYPE_ID`) REFERENCES `tb_dictionary_type` (`DICTIONARY_TYPE_ID`),
CONSTRAINT `FK60E40707BFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_dictionary_type`
-- ----------------------------
DROP TABLE IF EXISTS `tb_dictionary_type`;
CREATE TABLE `tb_dictionary_type` (
`DICTIONARY_TYPE_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`DICTIONARY_TYPE_NAME` text,
`DELETE_FLAG` int(11) DEFAULT NULL,
`PARENT_ID` bigint(20) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`OP_USER` bigint(20) DEFAULT NULL,
`REMARK` text,
`BACKUP_DATA` text,
PRIMARY KEY (`DICTIONARY_TYPE_ID`),
KEY `FK90EB8D72BFF465` (`OP_USER`),
CONSTRAINT `FK90EB8D72BFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_email`
-- ----------------------------
DROP TABLE IF EXISTS `tb_email`;
CREATE TABLE `tb_email` (
`EMAIL_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`EMAIL_TITLE` varchar(128) DEFAULT NULL,
`EMAIL_CONTENT` text,
`SENDER` int(11) DEFAULT NULL,
`RECEIVER` int(11) DEFAULT NULL,
`SEND_DATE` datetime DEFAULT NULL,
`EMAIL_STATE` int(11) DEFAULT NULL,
`SEND_DELETE` int(11) DEFAULT NULL,
`RECEIVE_DELETE` int(11) DEFAULT NULL,
`DRAFT_FLAG` int(11) DEFAULT NULL,
`EMAIL_LEVEL` int(11) DEFAULT NULL,
`SEND_LEVEL` int(11) DEFAULT NULL,
PRIMARY KEY (`EMAIL_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_events`
-- ----------------------------
DROP TABLE IF EXISTS `tb_events`;
CREATE TABLE `tb_events` (
`EVENTS_ID` int(11) NOT NULL AUTO_INCREMENT,
`EVENTS_CID` int(11) DEFAULT NULL,
`EVENTS_TITLE` varchar(255) DEFAULT NULL,
`EVENTS_START` varchar(255) DEFAULT NULL,
`EVENTS_END` varchar(255) DEFAULT NULL,
`EVENTS_LOC` varchar(255) DEFAULT NULL,
`EVENTS_NOTES` varchar(255) DEFAULT NULL,
`EVENTS_URL` varchar(255) DEFAULT NULL,
`EVENTS_REM` int(11) DEFAULT NULL,
`EVENTS_AD` bit(1) DEFAULT NULL,
`USER_ID` int(11) DEFAULT NULL,
`EVENTS_READ` int(11) DEFAULT NULL,
PRIMARY KEY (`EVENTS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_log`
-- ----------------------------
DROP TABLE IF EXISTS `tb_log`;
CREATE TABLE `tb_log` (
`LOG_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`MENU_NAME` varchar(128) DEFAULT NULL,
`USER_ID` bigint(20) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`OP_WAY` text,
`KEY_ID` bigint(20) DEFAULT NULL,
`REMARK` text,
`BACKUP_DATA` text,
`OBJECT_NAME` varchar(128) DEFAULT NULL,
`COMPANY_ID` bigint(20) DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`DEPARTMENT_ID` int(11) DEFAULT NULL,
PRIMARY KEY (`LOG_ID`),
KEY `FKCB83F9F3AE09C3FB` (`COMPANY_ID`),
KEY `FKCB83F9F34396C70B` (`USER_ID`),
CONSTRAINT `FKCB83F9F34396C70B` FOREIGN KEY (`USER_ID`) REFERENCES `tb_user` (`USER_ID`),
CONSTRAINT `FKCB83F9F3AE09C3FB` FOREIGN KEY (`COMPANY_ID`) REFERENCES `tb_company` (`COMPANY_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=815 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_log`
-- ----------------------------
BEGIN;
INSERT INTO `tb_log` VALUES ('808', '用户登录', '1', '2013-09-24 16:42:08', '登录', '1', '周东剑(登录名:administrator)在2013年09月24日16时42分08秒通过用户登录执行了登录操作,记录ID为1', '', 'TbUser', '1', '0', '1'), ('809', '公司管理', '1', '2013-09-24 16:42:28', '编辑', '4', '周东剑(登录名:administrator)在2013年09月24日16时42分28秒通过公司管理执行了编辑操作,记录ID为4', '', 'TbCompany', '1', '0', '1'), ('810', '公司管理', '1', '2013-09-24 16:42:34', '编辑', '4', '周东剑(登录名:administrator)在2013年09月24日16时42分34秒通过公司管理执行了编辑操作,记录ID为4', '', 'TbCompany', '1', '0', '1'), ('811', '用户登录', '1', '2013-09-24 16:43:29', '登录', '1', '周东剑(登录名:administrator)在2013年09月24日16时43分29秒通过用户登录执行了登录操作,记录ID为1', '', 'TbUser', '1', '0', '1'), ('812', '基础信息', '1', '2013-09-24 16:44:18', '编辑', '1', '周东剑(登录名:administrator)在2013年09月24日16时44分18秒通过基础信息执行了编辑操作,记录ID为1', '', 'TbSystemInfo', '1', '0', '1'), ('813', '用户登录', '1', '2013-09-24 18:31:07', '登录', '1', '周东剑(登录名:administrator)在2013年09月24日18时31分07秒通过用户登录执行了登录操作,记录ID为1', '', 'TbUser', '1', '0', '1'), ('814', '用户登录', '1', '2013-09-24 18:38:03', '登录', '1', '周东剑(登录名:administrator)在2013年09月24日18时38分03秒通过用户登录执行了登录操作,记录ID为1', '', 'TbUser', '1', '0', '1');
COMMIT;
-- ----------------------------
-- Table structure for `tb_menu`
-- ----------------------------
DROP TABLE IF EXISTS `tb_menu`;
CREATE TABLE `tb_menu` (
`MENU_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`PARENT_MENU_ID` bigint(20) DEFAULT NULL,
`MENU_NAME` varchar(128) DEFAULT NULL,
`MENU_ICON` varchar(128) DEFAULT NULL,
`MENU_URL` varchar(128) DEFAULT NULL,
`OPEN_FLAG` int(11) DEFAULT NULL,
`MENU_DESC` text,
`MENU_NO` varchar(128) DEFAULT NULL,
`COMPANY_ID` bigint(20) DEFAULT NULL,
`DEPARTMENT_ID` bigint(20) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`REMARK` text,
`OP_USER` bigint(20) DEFAULT NULL,
`BACKUP_DATA` bigint(20) DEFAULT NULL,
`MENU_CSS` varchar(255) DEFAULT NULL,
`MENU_WIN_ID` varchar(255) DEFAULT NULL,
`PUBLIC_MENU` int(11) DEFAULT NULL,
PRIMARY KEY (`MENU_ID`),
KEY `FKA4FB94901EDF38C4` (`DEPARTMENT_ID`),
KEY `FKA4FB9490AE09C3FB` (`COMPANY_ID`),
KEY `FKA4FB9490BFF465` (`OP_USER`),
CONSTRAINT `FKA4FB94901EDF38C4` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `tb_department` (`DEPARTMENT_ID`),
CONSTRAINT `FKA4FB9490AE09C3FB` FOREIGN KEY (`COMPANY_ID`) REFERENCES `tb_company` (`COMPANY_ID`),
CONSTRAINT `FKA4FB9490BFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_menu`
-- ----------------------------
BEGIN;
INSERT INTO `tb_menu` VALUES ('1', '0', '系统管理', 'icons/system_manage.png', '', '1', 'system-shortcut', 'System Manager', '1', '1', '2012-07-12 00:00:00', '2013-09-22 18:43:46', '0', '0', '1', '1', null, null, '0'), ('2', '1', '公司管理', 'default_menu_bg.png', '/company/company_queryList_listAction.action', '1', '', '001001', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:22', '0', '0', '1', '2', null, null, '0'), ('3', '1', '部门管理', 'default_menu_bg.png', '/department/department_queryList_listAction.action', '1', '', '001002', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:25', '0', '0', '1', '3', null, null, '0'), ('4', '1', '权限管理', 'default_menu_bg.png', '/authority/authority_queryList_listAction.action', '1', '', '001003', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:27', '0', '0', '1', '5', null, null, '0'), ('5', '1', '日志管理', 'default_menu_bg.png', '/log/log_queryList_listAction.action', '1', '', '001004', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:32', '0', '0', '1', '11', null, null, '0'), ('6', '1', '菜单管理', 'default_menu_bg.png', '/menu/menu_queryList_listAction.action', '1', '', '001005', '1', '1', '2012-07-12 00:00:00', '2013-08-02 09:28:07', '0', '0', '1', '6', null, null, '0'), ('7', '1', '角色管理', 'default_menu_bg.png', '/role/role_queryList_listAction.action', '1', '', '001006', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:36', '0', '0', '1', '7', null, null, '0'), ('8', '1', '用户管理', 'default_menu_bg.png', '/user/user_queryList_listAction.action', '1', '', '001007', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:39', '0', '0', '1', '8', null, null, '0'), ('9', '1', '角色权限', 'default_menu_bg.png', '/roleauthority/roleauthority_toEdit_managerAction.action', '1', '', '001008', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:41', '0', '0', '1', '9', null, null, '0'), ('10', '1', '系统设置', 'default_menu_bg.png', '/sysinfo/sysinfo_toEdit_managerAction.action', '1', '', '001009', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:43', '0', '0', '1', '10', null, null, '0'), ('11', '1', '数据字典', 'default_menu_bg.png', '/dictionary/dictionary_queryList_listAction.action', '1', '', '001010', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:46', '0', '0', '1', '12', null, null, '0'), ('12', '1', '职位管理', 'default_menu_bg.png', '/position/position_queryList_listAction.action', '1', '', '001011', '1', '1', '2012-07-12 00:00:00', '2013-07-30 16:44:49', '0', '', '1', '4', null, null, '0'), ('30', '0', '流程管理', 'system-shortcut', '', '1', 'JBPM工作流等工作模块', '', '1', '1', '2013-06-08 17:33:30', '2013-07-10 13:28:48', '1', '', '1', '1000', null, null, '0'), ('31', '30', '流程定义', '', '/jbpm/processDefinition!queryForList.action', '1', '', '', '1', '1', '2013-06-17 09:48:26', '2013-07-10 13:28:19', '1', '', '1', '1100', null, null, '0'), ('32', '30', '流程实例', '', '/jbpm/processInstance!queryForList.action', '1', '', '', '1', '1', '2013-06-17 09:49:03', '2013-07-10 13:28:15', '1', '', '1', '1200', null, null, '0'), ('33', '30', '流程任务', '', '/jbpm/task!queryForList.action', '1', '', '', '1', '1', '2013-06-17 09:49:26', '2013-07-10 13:33:08', '1', '', '1', '1300', null, null, '0'), ('34', '0', '通知公告', 'icons/announcement.png', '', '1', '', 'Announcement', '1', '1', '2013-07-11 18:06:51', '2013-09-22 18:45:18', '0', '', '1', '2000', null, null, '1'), ('35', '34', '通知公告', '', '/announcement/announcement_queryList_listAction.action', '1', '', '', '1', '1', '2013-07-11 18:07:33', '2013-07-30 16:44:13', '0', '', '1', '2100', null, null, '1'), ('36', '0', '我的消息', 'icons/message.png', '', '1', '', 'My Message', '1', '1', '2013-07-11 18:08:01', '2013-09-22 18:45:12', '0', '', '1', '3000', null, null, '1'), ('37', '36', '收件箱', '', '/message/message_queryReceiver_receiverAction.action', '1', '', '', '1', '1', '2013-07-11 18:11:56', '2013-07-30 16:44:06', '0', '', '1', '3100', null, null, '1'), ('38', '36', '发件箱', '', '/message/message_querySender_senderAction.action', '1', '', '', '1', '1', '2013-07-11 18:12:23', '2013-07-30 16:44:02', '0', '', '1', '3200', null, null, '1'), ('39', '0', '内部邮件', 'icons/email.png', '', '1', '', 'My Email', '1', '1', '2013-07-11 18:13:37', '2013-09-22 18:45:03', '0', '', '1', '4000', null, null, '1'), ('40', '39', '收件箱', '', '/email/email_queryReceiver_receiverAction.action', '1', '', '', '1', '1', '2013-07-11 18:15:02', '2013-07-30 16:43:54', '0', '', '1', '4100', null, null, '1'), ('41', '39', '星标邮件', '', '/email/email_queryStar_starAction.action', '1', '', '', '1', '1', '2013-07-11 18:17:05', '2013-08-02 09:27:31', '0', '', '1', '4200', null, null, '1'), ('42', '39', '已发送', '', '/email/email_querySender_senderAction.action', '1', '', '', '1', '1', '2013-07-11 18:18:12', '2013-07-30 16:43:47', '0', '', '1', '4300', null, null, '1'), ('43', '39', '草稿箱', '', '/email/email_queryDraft_draftAction.action', '1', '', '', '1', '1', '2013-07-11 18:19:19', '2013-07-30 16:43:43', '0', '', '1', '4400', null, null, '1'), ('44', '39', '已删除', '', '/email/email_queryDelete_deleteAction.action', '1', '', '', '1', '1', '2013-07-11 18:20:06', '2013-07-30 16:43:40', '0', '', '1', '4500', null, null, '1'), ('45', '39', '云附件', '', '/attachment/attachment_queryList_listAction.action', '1', '', '', '1', '1', '2013-07-11 18:23:03', '2013-07-30 16:43:36', '0', '', '1', '4600', null, null, '1'), ('46', '0', '待办事项', 'icons/todo.png', '', '1', '', 'Backlog', '1', '1', '2013-07-27 11:47:24', '2013-09-22 18:44:55', '0', '', '1', '5000', null, null, '1'), ('47', '46', '待办事项', 'default_menu_bg.png', '/backlog/backlog_queryList_listAction.action', '1', '', '', '1', '1', '2013-07-27 11:47:56', '2013-07-30 16:43:28', '0', '', '1', '5100', null, null, '1'), ('48', '0', '预警信息', 'icons/warning.png', '', '1', '', 'Warning', '1', '1', '2013-07-27 11:55:19', '2013-09-22 18:45:44', '0', '', '1', '6000', null, null, '1'), ('49', '48', '预警信息', 'default_menu_bg.png', '/warning/warning_queryList_listAction.action', '1', '', '', '1', '1', '2013-07-27 11:55:53', '2013-07-30 16:43:21', '0', '', '1', '6100', null, null, '1');
COMMIT;
-- ----------------------------
-- Table structure for `tb_menu_authority`
-- ----------------------------
DROP TABLE IF EXISTS `tb_menu_authority`;
CREATE TABLE `tb_menu_authority` (
`KEY_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`MENU_ID` bigint(20) DEFAULT NULL,
`AUTHORITY_ID` bigint(20) DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`OP_USER` bigint(20) DEFAULT NULL,
`REMARK` text,
PRIMARY KEY (`KEY_ID`),
KEY `FKDE6C2254EFDF1677` (`MENU_ID`),
KEY `FKDE6C225451B483C1` (`AUTHORITY_ID`),
KEY `FKDE6C2254BFF465` (`OP_USER`),
CONSTRAINT `FKDE6C225451B483C1` FOREIGN KEY (`AUTHORITY_ID`) REFERENCES `tb_authority` (`AUTHORITY_ID`),
CONSTRAINT `FKDE6C2254BFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`),
CONSTRAINT `FKDE6C2254EFDF1677` FOREIGN KEY (`MENU_ID`) REFERENCES `tb_menu` (`MENU_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1616 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_menu_authority`
-- ----------------------------
BEGIN;
INSERT INTO `tb_menu_authority` VALUES ('498', '32', '1', '0', '2013-07-10 13:28:15', '2013-07-10 13:28:15', '1', ''), ('499', '32', '2', '0', '2013-07-10 13:28:15', '2013-07-10 13:28:15', '1', ''), ('500', '32', '3', '0', '2013-07-10 13:28:15', '2013-07-10 13:28:15', '1', ''), ('501', '32', '4', '0', '2013-07-10 13:28:15', '2013-07-10 13:28:15', '1', ''), ('502', '32', '5', '0', '2013-07-10 13:28:15', '2013-07-10 13:28:15', '1', ''), ('503', '32', '6', '0', '2013-07-10 13:28:15', '2013-07-10 13:28:15', '1', ''), ('504', '31', '1', '0', '2013-07-10 13:28:19', '2013-07-10 13:28:19', '1', ''), ('505', '31', '2', '0', '2013-07-10 13:28:19', '2013-07-10 13:28:19', '1', ''), ('506', '31', '3', '0', '2013-07-10 13:28:19', '2013-07-10 13:28:19', '1', ''), ('507', '31', '4', '0', '2013-07-10 13:28:19', '2013-07-10 13:28:19', '1', ''), ('508', '31', '5', '0', '2013-07-10 13:28:19', '2013-07-10 13:28:19', '1', ''), ('509', '31', '6', '0', '2013-07-10 13:28:19', '2013-07-10 13:28:19', '1', ''), ('516', '30', '1', '0', '2013-07-10 13:28:48', '2013-07-10 13:28:48', '1', ''), ('517', '30', '2', '0', '2013-07-10 13:28:48', '2013-07-10 13:28:48', '1', ''), ('518', '30', '3', '0', '2013-07-10 13:28:48', '2013-07-10 13:28:48', '1', ''), ('519', '30', '4', '0', '2013-07-10 13:28:48', '2013-07-10 13:28:48', '1', ''), ('520', '30', '5', '0', '2013-07-10 13:28:48', '2013-07-10 13:28:48', '1', ''), ('521', '30', '6', '0', '2013-07-10 13:28:48', '2013-07-10 13:28:48', '1', ''), ('546', '33', '1', '0', '2013-07-10 13:33:08', '2013-07-10 13:33:08', '1', ''), ('547', '33', '2', '0', '2013-07-10 13:33:08', '2013-07-10 13:33:08', '1', ''), ('548', '33', '3', '0', '2013-07-10 13:33:08', '2013-07-10 13:33:08', '1', ''), ('549', '33', '4', '0', '2013-07-10 13:33:08', '2013-07-10 13:33:08', '1', ''), ('550', '33', '5', '0', '2013-07-10 13:33:08', '2013-07-10 13:33:08', '1', ''), ('551', '33', '6', '0', '2013-07-10 13:33:08', '2013-07-10 13:33:08', '1', ''), ('718', '49', '1', '0', '2013-07-30 16:43:21', '2013-07-30 16:43:21', '1', ''), ('719', '49', '2', '0', '2013-07-30 16:43:21', '2013-07-30 16:43:21', '1', ''), ('720', '49', '3', '0', '2013-07-30 16:43:21', '2013-07-30 16:43:21', '1', ''), ('721', '49', '4', '0', '2013-07-30 16:43:21', '2013-07-30 16:43:21', '1', ''), ('722', '49', '5', '0', '2013-07-30 16:43:21', '2013-07-30 16:43:21', '1', ''), ('723', '49', '6', '0', '2013-07-30 16:43:21', '2013-07-30 16:43:21', '1', ''), ('730', '47', '1', '0', '2013-07-30 16:43:28', '2013-07-30 16:43:28', '1', ''), ('731', '47', '2', '0', '2013-07-30 16:43:28', '2013-07-30 16:43:28', '1', ''), ('732', '47', '3', '0', '2013-07-30 16:43:28', '2013-07-30 16:43:28', '1', ''), ('733', '47', '4', '0', '2013-07-30 16:43:28', '2013-07-30 16:43:28', '1', ''), ('734', '47', '5', '0', '2013-07-30 16:43:28', '2013-07-30 16:43:28', '1', ''), ('735', '47', '6', '0', '2013-07-30 16:43:28', '2013-07-30 16:43:28', '1', ''), ('742', '45', '1', '0', '2013-07-30 16:43:36', '2013-07-30 16:43:36', '1', ''), ('743', '45', '2', '0', '2013-07-30 16:43:36', '2013-07-30 16:43:36', '1', ''), ('744', '45', '3', '0', '2013-07-30 16:43:36', '2013-07-30 16:43:36', '1', ''), ('745', '45', '4', '0', '2013-07-30 16:43:36', '2013-07-30 16:43:36', '1', ''), ('746', '45', '5', '0', '2013-07-30 16:43:36', '2013-07-30 16:43:36', '1', ''), ('747', '45', '6', '0', '2013-07-30 16:43:36', '2013-07-30 16:43:36', '1', ''), ('748', '44', '1', '0', '2013-07-30 16:43:40', '2013-07-30 16:43:40', '1', ''), ('749', '44', '2', '0', '2013-07-30 16:43:40', '2013-07-30 16:43:40', '1', ''), ('750', '44', '3', '0', '2013-07-30 16:43:40', '2013-07-30 16:43:40', '1', ''), ('751', '44', '4', '0', '2013-07-30 16:43:40', '2013-07-30 16:43:40', '1', ''), ('752', '44', '5', '0', '2013-07-30 16:43:40', '2013-07-30 16:43:40', '1', ''), ('753', '44', '6', '0', '2013-07-30 16:43:40', '2013-07-30 16:43:40', '1', ''), ('754', '43', '1', '0', '2013-07-30 16:43:43', '2013-07-30 16:43:43', '1', ''), ('755', '43', '2', '0', '2013-07-30 16:43:43', '2013-07-30 16:43:43', '1', ''), ('756', '43', '3', '0', '2013-07-30 16:43:43', '2013-07-30 16:43:43', '1', ''), ('757', '43', '4', '0', '2013-07-30 16:43:43', '2013-07-30 16:43:43', '1', ''), ('758', '43', '5', '0', '2013-07-30 16:43:43', '2013-07-30 16:43:43', '1', ''), ('759', '43', '6', '0', '2013-07-30 16:43:43', '2013-07-30 16:43:43', '1', ''), ('760', '42', '1', '0', '2013-07-30 16:43:47', '2013-07-30 16:43:47', '1', ''), ('761', '42', '2', '0', '2013-07-30 16:43:47', '2013-07-30 16:43:47', '1', ''), ('762', '42', '3', '0', '2013-07-30 16:43:47', '2013-07-30 16:43:47', '1', ''), ('763', '42', '4', '0', '2013-07-30 16:43:47', '2013-07-30 16:43:47', '1', ''), ('764', '42', '5', '0', '2013-07-30 16:43:47', '2013-07-30 16:43:47', '1', ''), ('765', '42', '6', '0', '2013-07-30 16:43:47', '2013-07-30 16:43:47', '1', ''), ('772', '40', '1', '0', '2013-07-30 16:43:54', '2013-07-30 16:43:54', '1', ''), ('773', '40', '2', '0', '2013-07-30 16:43:54', '2013-07-30 16:43:54', '1', ''), ('774', '40', '3', '0', '2013-07-30 16:43:54', '2013-07-30 16:43:54', '1', ''), ('775', '40', '4', '0', '2013-07-30 16:43:54', '2013-07-30 16:43:54', '1', ''), ('776', '40', '5', '0', '2013-07-30 16:43:54', '2013-07-30 16:43:54', '1', ''), ('777', '40', '6', '0', '2013-07-30 16:43:54', '2013-07-30 16:43:54', '1', ''), ('784', '38', '1', '0', '2013-07-30 16:44:02', '2013-07-30 16:44:02', '1', ''), ('785', '38', '2', '0', '2013-07-30 16:44:02', '2013-07-30 16:44:02', '1', ''), ('786', '38', '3', '0', '2013-07-30 16:44:02', '2013-07-30 16:44:02', '1', ''), ('787', '38', '4', '0', '2013-07-30 16:44:02', '2013-07-30 16:44:02', '1', ''), ('788', '38', '5', '0', '2013-07-30 16:44:02', '2013-07-30 16:44:02', '1', ''), ('789', '38', '6', '0', '2013-07-30 16:44:02', '2013-07-30 16:44:02', '1', ''), ('790', '37', '1', '0', '2013-07-30 16:44:06', '2013-07-30 16:44:06', '1', ''), ('791', '37', '2', '0', '2013-07-30 16:44:06', '2013-07-30 16:44:06', '1', ''), ('792', '37', '3', '0', '2013-07-30 16:44:06', '2013-07-30 16:44:06', '1', ''), ('793', '37', '4', '0', '2013-07-30 16:44:06', '2013-07-30 16:44:06', '1', ''), ('794', '37', '5', '0', '2013-07-30 16:44:06', '2013-07-30 16:44:06', '1', ''), ('795', '37', '6', '0', '2013-07-30 16:44:06', '2013-07-30 16:44:06', '1', ''), ('802', '35', '1', '0', '2013-07-30 16:44:13', '2013-07-30 16:44:13', '1', ''), ('803', '35', '2', '0', '2013-07-30 16:44:13', '2013-07-30 16:44:13', '1', ''), ('804', '35', '3', '0', '2013-07-30 16:44:13', '2013-07-30 16:44:13', '1', ''), ('805', '35', '4', '0', '2013-07-30 16:44:13', '2013-07-30 16:44:13', '1', ''), ('806', '35', '5', '0', '2013-07-30 16:44:13', '2013-07-30 16:44:13', '1', ''), ('807', '35', '6', '0', '2013-07-30 16:44:13', '2013-07-30 16:44:13', '1', ''), ('816', '2', '1', '0', '2013-07-30 16:44:22', '2013-07-30 16:44:22', '1', ''), ('817', '2', '2', '0', '2013-07-30 16:44:22', '2013-07-30 16:44:22', '1', ''), ('818', '2', '3', '0', '2013-07-30 16:44:22', '2013-07-30 16:44:22', '1', ''), ('819', '2', '4', '0', '2013-07-30 16:44:22', '2013-07-30 16:44:22', '1', ''), ('820', '2', '5', '0', '2013-07-30 16:44:22', '2013-07-30 16:44:22', '1', ''), ('821', '2', '6', '0', '2013-07-30 16:44:22', '2013-07-30 16:44:22', '1', ''), ('822', '3', '1', '0', '2013-07-30 16:44:25', '2013-07-30 16:44:25', '1', ''), ('823', '3', '2', '0', '2013-07-30 16:44:25', '2013-07-30 16:44:25', '1', ''), ('824', '3', '3', '0', '2013-07-30 16:44:25', '2013-07-30 16:44:25', '1', ''), ('825', '3', '4', '0', '2013-07-30 16:44:25', '2013-07-30 16:44:25', '1', ''), ('826', '3', '5', '0', '2013-07-30 16:44:25', '2013-07-30 16:44:25', '1', ''), ('827', '3', '6', '0', '2013-07-30 16:44:25', '2013-07-30 16:44:25', '1', ''), ('828', '4', '1', '0', '2013-07-30 16:44:27', '2013-07-30 16:44:27', '1', ''), ('829', '4', '2', '0', '2013-07-30 16:44:27', '2013-07-30 16:44:27', '1', ''), ('830', '4', '3', '0', '2013-07-30 16:44:27', '2013-07-30 16:44:27', '1', ''), ('831', '4', '4', '0', '2013-07-30 16:44:27', '2013-07-30 16:44:27', '1', ''), ('832', '4', '5', '0', '2013-07-30 16:44:27', '2013-07-30 16:44:27', '1', ''), ('833', '4', '6', '0', '2013-07-30 16:44:27', '2013-07-30 16:44:27', '1', ''), ('834', '5', '1', '0', '2013-07-30 16:44:32', '2013-07-30 16:44:32', '1', ''), ('835', '5', '2', '0', '2013-07-30 16:44:32', '2013-07-30 16:44:32', '1', ''), ('836', '5', '3', '0', '2013-07-30 16:44:32', '2013-07-30 16:44:32', '1', ''), ('837', '5', '4', '0', '2013-07-30 16:44:32', '2013-07-30 16:44:32', '1', ''), ('838', '5', '5', '0', '2013-07-30 16:44:32', '2013-07-30 16:44:32', '1', ''), ('839', '5', '6', '0', '2013-07-30 16:44:32', '2013-07-30 16:44:32', '1', ''), ('846', '7', '1', '0', '2013-07-30 16:44:36', '2013-07-30 16:44:36', '1', ''), ('847', '7', '2', '0', '2013-07-30 16:44:36', '2013-07-30 16:44:36', '1', ''), ('848', '7', '3', '0', '2013-07-30 16:44:36', '2013-07-30 16:44:36', '1', ''), ('849', '7', '4', '0', '2013-07-30 16:44:36', '2013-07-30 16:44:36', '1', ''), ('850', '7', '5', '0', '2013-07-30 16:44:36', '2013-07-30 16:44:36', '1', ''), ('851', '7', '6', '0', '2013-07-30 16:44:37', '2013-07-30 16:44:37', '1', ''), ('852', '8', '1', '0', '2013-07-30 16:44:39', '2013-07-30 16:44:39', '1', ''), ('853', '8', '2', '0', '2013-07-30 16:44:39', '2013-07-30 16:44:39', '1', ''), ('854', '8', '3', '0', '2013-07-30 16:44:39', '2013-07-30 16:44:39', '1', ''), ('855', '8', '4', '0', '2013-07-30 16:44:39', '2013-07-30 16:44:39', '1', ''), ('856', '8', '5', '0', '2013-07-30 16:44:39', '2013-07-30 16:44:39', '1', ''), ('857', '8', '6', '0', '2013-07-30 16:44:39', '2013-07-30 16:44:39', '1', ''), ('858', '9', '1', '0', '2013-07-30 16:44:41', '2013-07-30 16:44:41', '1', ''), ('859', '9', '2', '0', '2013-07-30 16:44:41', '2013-07-30 16:44:41', '1', ''), ('860', '9', '3', '0', '2013-07-30 16:44:41', '2013-07-30 16:44:41', '1', ''), ('861', '9', '4', '0', '2013-07-30 16:44:41', '2013-07-30 16:44:41', '1', ''), ('862', '9', '5', '0', '2013-07-30 16:44:41', '2013-07-30 16:44:41', '1', ''), ('863', '9', '6', '0', '2013-07-30 16:44:41', '2013-07-30 16:44:41', '1', ''), ('864', '10', '1', '0', '2013-07-30 16:44:43', '2013-07-30 16:44:43', '1', ''), ('865', '10', '2', '0', '2013-07-30 16:44:43', '2013-07-30 16:44:43', '1', ''), ('866', '10', '3', '0', '2013-07-30 16:44:43', '2013-07-30 16:44:43', '1', ''), ('867', '10', '4', '0', '2013-07-30 16:44:43', '2013-07-30 16:44:43', '1', ''), ('868', '10', '5', '0', '2013-07-30 16:44:43', '2013-07-30 16:44:43', '1', ''), ('869', '10', '6', '0', '2013-07-30 16:44:43', '2013-07-30 16:44:43', '1', ''), ('870', '11', '1', '0', '2013-07-30 16:44:46', '2013-07-30 16:44:46', '1', ''), ('871', '11', '2', '0', '2013-07-30 16:44:46', '2013-07-30 16:44:46', '1', ''), ('872', '11', '3', '0', '2013-07-30 16:44:46', '2013-07-30 16:44:46', '1', ''), ('873', '11', '4', '0', '2013-07-30 16:44:46', '2013-07-30 16:44:46', '1', ''), ('874', '11', '5', '0', '2013-07-30 16:44:46', '2013-07-30 16:44:46', '1', ''), ('875', '11', '6', '0', '2013-07-30 16:44:46', '2013-07-30 16:44:46', '1', ''), ('876', '12', '1', '0', '2013-07-30 16:44:49', '2013-07-30 16:44:49', '1', ''), ('877', '12', '2', '0', '2013-07-30 16:44:49', '2013-07-30 16:44:49', '1', ''), ('878', '12', '3', '0', '2013-07-30 16:44:49', '2013-07-30 16:44:49', '1', ''), ('879', '12', '4', '0', '2013-07-30 16:44:49', '2013-07-30 16:44:49', '1', ''), ('880', '12', '5', '0', '2013-07-30 16:44:49', '2013-07-30 16:44:49', '1', ''), ('881', '12', '6', '0', '2013-07-30 16:44:49', '2013-07-30 16:44:49', '1', ''), ('882', '41', '1', '0', '2013-08-02 09:27:31', '2013-08-02 09:27:31', '1', ''), ('883', '41', '2', '0', '2013-08-02 09:27:31', '2013-08-02 09:27:31', '1', ''), ('884', '41', '3', '0', '2013-08-02 09:27:31', '2013-08-02 09:27:31', '1', ''), ('885', '41', '4', '0', '2013-08-02 09:27:31', '2013-08-02 09:27:31', '1', ''), ('886', '41', '5', '0', '2013-08-02 09:27:31', '2013-08-02 09:27:31', '1', ''), ('887', '41', '6', '0', '2013-08-02 09:27:31', '2013-08-02 09:27:31', '1', ''), ('888', '6', '1', '0', '2013-08-02 09:28:07', '2013-08-02 09:28:07', '1', ''), ('889', '6', '2', '0', '2013-08-02 09:28:07', '2013-08-02 09:28:07', '1', ''), ('890', '6', '3', '0', '2013-08-02 09:28:07', '2013-08-02 09:28:07', '1', ''), ('891', '6', '4', '0', '2013-08-02 09:28:07', '2013-08-02 09:28:07', '1', ''), ('892', '6', '5', '0', '2013-08-02 09:28:07', '2013-08-02 09:28:07', '1', ''), ('893', '6', '6', '0', '2013-08-02 09:28:07', '2013-08-02 09:28:07', '1', ''), ('1566', '1', '1', '0', '2013-09-22 18:43:46', '2013-09-22 18:43:46', '1', ''), ('1567', '1', '6', '0', '2013-09-22 18:43:46', '2013-09-22 18:43:46', '1', ''), ('1586', '46', '1', '0', '2013-09-22 18:44:55', '2013-09-22 18:44:55', '1', ''), ('1587', '46', '2', '0', '2013-09-22 18:44:55', '2013-09-22 18:44:55', '1', ''), ('1588', '46', '3', '0', '2013-09-22 18:44:55', '2013-09-22 18:44:55', '1', ''), ('1589', '46', '4', '0', '2013-09-22 18:44:55', '2013-09-22 18:44:55', '1', ''), ('1590', '46', '5', '0', '2013-09-22 18:44:55', '2013-09-22 18:44:55', '1', ''), ('1591', '46', '6', '0', '2013-09-22 18:44:55', '2013-09-22 18:44:55', '1', ''), ('1592', '39', '1', '0', '2013-09-22 18:45:03', '2013-09-22 18:45:03', '1', ''), ('1593', '39', '2', '0', '2013-09-22 18:45:03', '2013-09-22 18:45:03', '1', ''), ('1594', '39', '3', '0', '2013-09-22 18:45:03', '2013-09-22 18:45:03', '1', ''), ('1595', '39', '4', '0', '2013-09-22 18:45:03', '2013-09-22 18:45:03', '1', ''), ('1596', '39', '5', '0', '2013-09-22 18:45:03', '2013-09-22 18:45:03', '1', ''), ('1597', '39', '6', '0', '2013-09-22 18:45:03', '2013-09-22 18:45:03', '1', ''), ('1598', '36', '1', '0', '2013-09-22 18:45:12', '2013-09-22 18:45:12', '1', ''), ('1599', '36', '2', '0', '2013-09-22 18:45:12', '2013-09-22 18:45:12', '1', ''), ('1600', '36', '3', '0', '2013-09-22 18:45:12', '2013-09-22 18:45:12', '1', ''), ('1601', '36', '4', '0', '2013-09-22 18:45:12', '2013-09-22 18:45:12', '1', ''), ('1602', '36', '5', '0', '2013-09-22 18:45:12', '2013-09-22 18:45:12', '1', ''), ('1603', '36', '6', '0', '2013-09-22 18:45:12', '2013-09-22 18:45:12', '1', ''), ('1604', '34', '1', '0', '2013-09-22 18:45:18', '2013-09-22 18:45:18', '1', ''), ('1605', '34', '2', '0', '2013-09-22 18:45:18', '2013-09-22 18:45:18', '1', ''), ('1606', '34', '3', '0', '2013-09-22 18:45:18', '2013-09-22 18:45:18', '1', ''), ('1607', '34', '4', '0', '2013-09-22 18:45:18', '2013-09-22 18:45:18', '1', ''), ('1608', '34', '5', '0', '2013-09-22 18:45:18', '2013-09-22 18:45:18', '1', ''), ('1609', '34', '6', '0', '2013-09-22 18:45:18', '2013-09-22 18:45:18', '1', ''), ('1610', '48', '1', '0', '2013-09-22 18:45:44', '2013-09-22 18:45:44', '1', ''), ('1611', '48', '2', '0', '2013-09-22 18:45:44', '2013-09-22 18:45:44', '1', ''), ('1612', '48', '3', '0', '2013-09-22 18:45:44', '2013-09-22 18:45:44', '1', ''), ('1613', '48', '4', '0', '2013-09-22 18:45:44', '2013-09-22 18:45:44', '1', ''), ('1614', '48', '5', '0', '2013-09-22 18:45:44', '2013-09-22 18:45:44', '1', ''), ('1615', '48', '6', '0', '2013-09-22 18:45:44', '2013-09-22 18:45:44', '1', '');
COMMIT;
-- ----------------------------
-- Table structure for `tb_message`
-- ----------------------------
DROP TABLE IF EXISTS `tb_message`;
CREATE TABLE `tb_message` (
`MESSAGE_ID` int(11) NOT NULL AUTO_INCREMENT,
`MESSAGE_CONTENT` text,
`SENDER` int(11) DEFAULT NULL,
`RECEIVER` int(11) DEFAULT NULL,
`SEND_DATE` datetime DEFAULT NULL,
`MESSAGE_STATE` int(11) DEFAULT NULL,
`RECEIVE_DELETE` int(11) DEFAULT NULL,
`SEND_DELETE` int(11) DEFAULT NULL,
`MESSAGE_TIP` int(11) DEFAULT NULL,
PRIMARY KEY (`MESSAGE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_position`
-- ----------------------------
DROP TABLE IF EXISTS `tb_position`;
CREATE TABLE `tb_position` (
`POSITION_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`POSITION_NAME` text,
`POSITION_NO` text,
`POSITION_DUTY` text,
`DEPARTMENT_ID` bigint(20) DEFAULT NULL,
`COMPANY_ID` bigint(20) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`REMARK` text,
`OP_USER` bigint(20) DEFAULT NULL,
`BACKUP_DATA` text,
PRIMARY KEY (`POSITION_ID`),
KEY `FK2DB617DA1EDF38C4` (`DEPARTMENT_ID`),
KEY `FK2DB617DAAE09C3FB` (`COMPANY_ID`),
KEY `FK2DB617DABFF465` (`OP_USER`),
CONSTRAINT `FK2DB617DA1EDF38C4` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `tb_department` (`DEPARTMENT_ID`),
CONSTRAINT `FK2DB617DAAE09C3FB` FOREIGN KEY (`COMPANY_ID`) REFERENCES `tb_company` (`COMPANY_ID`),
CONSTRAINT `FK2DB617DABFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_position`
-- ----------------------------
BEGIN;
INSERT INTO `tb_position` VALUES ('1', '系统创始人', 'NULL_POSITION', null, '1', '1', '2012-01-01 00:00:00', '2012-01-01 00:00:00', '1', null, '1', null), ('2', '总经理', '', '', '1', '1', '2013-07-10 13:38:22', '2013-07-10 13:38:22', '0', '', '1', null), ('3', '部门经理', '', '', '1', '1', '2013-07-10 13:38:32', '2013-07-10 13:38:32', '0', '', '1', null), ('4', '项目主管', '', '', '1', '1', '2013-07-10 13:38:38', '2013-07-10 13:38:38', '0', '', '1', null);
COMMIT;
-- ----------------------------
-- Table structure for `tb_role`
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role` (
`ROLE_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`ROLE_NAME` varchar(128) DEFAULT NULL,
`ROLE_NO` varchar(128) DEFAULT NULL,
`DEPARTMENT_ID` bigint(20) DEFAULT NULL,
`COMPANY_ID` bigint(20) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`REMARK` text,
`OP_USER` bigint(20) DEFAULT NULL,
`BACKUP_DATA` text,
`COMPANY_AUTHORITY_FLAG` int(11) DEFAULT NULL,
`DEPARTMENT_AUTHORITY_FLAG` int(11) DEFAULT NULL,
`ALL_COMPANY_AUTHORITY_FLAG` int(11) DEFAULT NULL,
`ALL_DEPARTMENT_AUTHORITY_FLAG` int(11) DEFAULT NULL,
PRIMARY KEY (`ROLE_ID`),
KEY `FKA4FDFFA71EDF38C4` (`DEPARTMENT_ID`),
KEY `FKA4FDFFA7AE09C3FB` (`COMPANY_ID`),
KEY `FKA4FDFFA7BFF465` (`OP_USER`),
CONSTRAINT `FKA4FDFFA71EDF38C4` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `tb_department` (`DEPARTMENT_ID`),
CONSTRAINT `FKA4FDFFA7AE09C3FB` FOREIGN KEY (`COMPANY_ID`) REFERENCES `tb_company` (`COMPANY_ID`),
CONSTRAINT `FKA4FDFFA7BFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_role`
-- ----------------------------
BEGIN;
INSERT INTO `tb_role` VALUES ('1', '超级管理员', '00000', '1', '1', '2000-01-01 00:00:00', '2000-01-01 00:00:00', '0', '', '1', null, '1', '1', '1', '1'), ('5', '财务', '', '1', '1', '2013-07-10 13:39:18', '2013-09-16 16:15:59', '0', '', '1', null, '0', '0', '0', '0'), ('6', '司机', '', '1', '1', '2013-07-10 13:39:28', '2013-09-16 16:15:53', '0', '', '1', null, '0', '0', '0', '0'), ('7', '业务员', '', '1', '1', '2013-07-11 09:58:11', '2013-09-16 16:15:48', '0', '', '1', null, '0', '0', '0', '0'), ('8', '总经理', '', '1', '1', '2013-09-16 16:16:24', '2013-09-16 16:16:24', '0', '', '1', null, '0', '0', '0', '0'), ('9', '车辆调度', '', '1', '1', '2013-09-16 16:16:39', '2013-09-16 16:16:39', '0', '', '1', null, '0', '0', '0', '0'), ('10', '安全员', '', '1', '1', '2013-09-16 16:16:54', '2013-09-16 16:16:54', '0', '', '1', null, '0', '0', '0', '0'), ('11', '管理员', '', '1', '1', '2013-09-24 15:47:28', '2013-09-24 15:47:28', '0', '', '1', null, '0', '0', '0', '0');
COMMIT;
-- ----------------------------
-- Table structure for `tb_role_authority`
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_authority`;
CREATE TABLE `tb_role_authority` (
`KEY_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`ROLE_ID` bigint(20) DEFAULT NULL,
`AUTHORITY_ID` bigint(20) DEFAULT NULL,
`MENU_ID` bigint(20) DEFAULT NULL,
`OPEN_FLAG` int(11) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`OP_USER` bigint(20) DEFAULT NULL,
`REMARK` text,
PRIMARY KEY (`KEY_ID`),
KEY `FK3B30DCABD607E820` (`ROLE_ID`),
KEY `FK3B30DCAB51B483C1` (`AUTHORITY_ID`),
KEY `FK3B30DCABBFF465` (`OP_USER`),
KEY `FK3B30DCABEFDF1677` (`MENU_ID`),
CONSTRAINT `FK3B30DCAB51B483C1` FOREIGN KEY (`AUTHORITY_ID`) REFERENCES `tb_authority` (`AUTHORITY_ID`),
CONSTRAINT `FK3B30DCABBFF465` FOREIGN KEY (`OP_USER`) REFERENCES `tb_user` (`USER_ID`),
CONSTRAINT `FK3B30DCABD607E820` FOREIGN KEY (`ROLE_ID`) REFERENCES `tb_role` (`ROLE_ID`),
CONSTRAINT `FK3B30DCABEFDF1677` FOREIGN KEY (`MENU_ID`) REFERENCES `tb_menu` (`MENU_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=16104 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_role_authority`
-- ----------------------------
BEGIN;
INSERT INTO `tb_role_authority` VALUES ('5974', '5', '1', '1', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5975', '5', '6', '1', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5976', '5', '1', '2', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5977', '5', '2', '2', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5978', '5', '3', '2', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5979', '5', '4', '2', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5980', '5', '5', '2', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5981', '5', '6', '2', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5982', '5', '1', '3', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5983', '5', '2', '3', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5984', '5', '3', '3', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5985', '5', '4', '3', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5986', '5', '5', '3', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5987', '5', '6', '3', '1', '2013-07-17 12:25:43', '2013-07-17 12:25:43', '1', ''), ('5988', '7', '1', '12', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5989', '7', '2', '12', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5990', '7', '3', '12', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5991', '7', '4', '12', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5992', '7', '5', '12', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5993', '7', '6', '12', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5994', '7', '1', '4', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5995', '7', '2', '4', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5996', '7', '3', '4', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5997', '7', '4', '4', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5998', '7', '5', '4', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('5999', '7', '6', '4', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('6000', '7', '1', '6', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('6001', '7', '2', '6', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('6002', '7', '3', '6', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('6003', '7', '4', '6', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('6004', '7', '5', '6', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('6005', '7', '6', '6', '1', '2013-07-17 12:25:49', '2013-07-17 12:25:49', '1', ''), ('15940', '1', '1', '1', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15941', '1', '6', '1', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15942', '1', '1', '2', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15943', '1', '2', '2', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15944', '1', '3', '2', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15945', '1', '4', '2', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15946', '1', '5', '2', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15947', '1', '6', '2', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15948', '1', '1', '3', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15949', '1', '2', '3', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15950', '1', '3', '3', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15951', '1', '4', '3', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15952', '1', '5', '3', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15953', '1', '6', '3', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15954', '1', '1', '12', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15955', '1', '2', '12', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15956', '1', '3', '12', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15957', '1', '4', '12', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15958', '1', '5', '12', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15959', '1', '6', '12', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15960', '1', '1', '4', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15961', '1', '2', '4', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15962', '1', '3', '4', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15963', '1', '4', '4', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15964', '1', '5', '4', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15965', '1', '6', '4', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15966', '1', '1', '6', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15967', '1', '2', '6', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15968', '1', '3', '6', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15969', '1', '4', '6', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15970', '1', '5', '6', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15971', '1', '6', '6', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15972', '1', '1', '7', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15973', '1', '2', '7', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15974', '1', '3', '7', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15975', '1', '4', '7', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15976', '1', '5', '7', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15977', '1', '6', '7', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15978', '1', '1', '8', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15979', '1', '2', '8', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15980', '1', '3', '8', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15981', '1', '4', '8', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15982', '1', '5', '8', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15983', '1', '6', '8', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15984', '1', '1', '9', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15985', '1', '2', '9', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15986', '1', '3', '9', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15987', '1', '4', '9', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15988', '1', '5', '9', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15989', '1', '6', '9', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15990', '1', '1', '10', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15991', '1', '2', '10', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15992', '1', '3', '10', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15993', '1', '4', '10', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15994', '1', '5', '10', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15995', '1', '6', '10', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15996', '1', '1', '5', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15997', '1', '2', '5', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15998', '1', '3', '5', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('15999', '1', '4', '5', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16000', '1', '5', '5', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16001', '1', '6', '5', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16002', '1', '1', '11', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16003', '1', '2', '11', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16004', '1', '3', '11', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16005', '1', '4', '11', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16006', '1', '5', '11', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16007', '1', '6', '11', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16008', '1', '1', '34', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16009', '1', '2', '34', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16010', '1', '3', '34', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16011', '1', '4', '34', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16012', '1', '5', '34', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16013', '1', '6', '34', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16014', '1', '1', '35', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16015', '1', '2', '35', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16016', '1', '3', '35', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16017', '1', '4', '35', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16018', '1', '5', '35', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16019', '1', '6', '35', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16020', '1', '1', '36', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16021', '1', '2', '36', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16022', '1', '3', '36', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16023', '1', '4', '36', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16024', '1', '5', '36', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16025', '1', '6', '36', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16026', '1', '1', '37', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16027', '1', '2', '37', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16028', '1', '3', '37', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16029', '1', '4', '37', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16030', '1', '5', '37', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16031', '1', '6', '37', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16032', '1', '1', '38', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16033', '1', '2', '38', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16034', '1', '3', '38', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16035', '1', '4', '38', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16036', '1', '5', '38', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16037', '1', '6', '38', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16038', '1', '1', '39', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16039', '1', '2', '39', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16040', '1', '3', '39', '1', '2013-09-24 14:38:02', '2013-09-24 14:38:02', '1', ''), ('16041', '1', '4', '39', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16042', '1', '5', '39', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16043', '1', '6', '39', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16044', '1', '1', '40', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16045', '1', '2', '40', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16046', '1', '3', '40', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16047', '1', '4', '40', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16048', '1', '5', '40', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16049', '1', '6', '40', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16050', '1', '1', '41', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16051', '1', '2', '41', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16052', '1', '3', '41', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16053', '1', '4', '41', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16054', '1', '5', '41', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16055', '1', '6', '41', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16056', '1', '1', '42', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16057', '1', '2', '42', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16058', '1', '3', '42', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16059', '1', '4', '42', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16060', '1', '5', '42', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16061', '1', '6', '42', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16062', '1', '1', '43', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16063', '1', '2', '43', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16064', '1', '3', '43', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16065', '1', '4', '43', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16066', '1', '5', '43', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16067', '1', '6', '43', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16068', '1', '1', '44', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16069', '1', '2', '44', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16070', '1', '3', '44', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16071', '1', '4', '44', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16072', '1', '5', '44', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16073', '1', '6', '44', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16074', '1', '1', '45', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16075', '1', '2', '45', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16076', '1', '3', '45', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16077', '1', '4', '45', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16078', '1', '5', '45', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16079', '1', '6', '45', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16080', '1', '1', '46', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16081', '1', '2', '46', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16082', '1', '3', '46', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16083', '1', '4', '46', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16084', '1', '5', '46', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16085', '1', '6', '46', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16086', '1', '1', '47', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16087', '1', '2', '47', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16088', '1', '3', '47', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16089', '1', '4', '47', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16090', '1', '5', '47', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16091', '1', '6', '47', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16092', '1', '1', '48', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16093', '1', '2', '48', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16094', '1', '3', '48', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16095', '1', '4', '48', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16096', '1', '5', '48', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16097', '1', '6', '48', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16098', '1', '1', '49', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16099', '1', '2', '49', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16100', '1', '3', '49', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16101', '1', '4', '49', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16102', '1', '5', '49', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', ''), ('16103', '1', '6', '49', '1', '2013-09-24 14:38:03', '2013-09-24 14:38:03', '1', '');
COMMIT;
-- ----------------------------
-- Table structure for `tb_system_info`
-- ----------------------------
DROP TABLE IF EXISTS `tb_system_info`;
CREATE TABLE `tb_system_info` (
`SYSTEM_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`SYSTEM_NAME` text,
`SYSTEM_LOGO` text,
`REG_FLAG` int(11) DEFAULT NULL,
`OPEN_FLAG` int(11) DEFAULT NULL,
`LOGIN_VAL_FLAG` int(11) DEFAULT NULL,
`REG_VAL_FLAG` int(11) DEFAULT NULL,
`ADMIN_ID` bigint(20) DEFAULT NULL,
`REMARK` text,
`OPEN_LOG_FLAG` int(11) DEFAULT NULL,
`PAGESUM` int(11) DEFAULT NULL,
`SYSTEM_STYLE` int(11) DEFAULT NULL,
`MORE_ROLE` int(11) DEFAULT NULL,
PRIMARY KEY (`SYSTEM_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_system_info`
-- ----------------------------
BEGIN;
INSERT INTO `tb_system_info` VALUES ('1', 'Jeasyframe.org', 'images/frame/logo.png', '0', '1', '0', null, '1', '', '1', '10', '186', '1');
COMMIT;
-- ----------------------------
-- Table structure for `tb_user`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
`USER_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`LOGIN_NAME` varchar(128) DEFAULT NULL,
`LOGIN_PWD` text,
`REAL_NAME` varchar(128) DEFAULT NULL,
`IDENTITY_CARD` varchar(128) DEFAULT NULL,
`USER_NO` varchar(128) DEFAULT NULL,
`USER_EMAIL` varchar(128) DEFAULT NULL,
`USER_NICKNAME` varchar(128) DEFAULT NULL,
`USER_CREATE_WAY` varchar(128) DEFAULT NULL,
`USER_BIRTHDAY` varchar(128) DEFAULT NULL,
`USER_CONSTELLATION` varchar(128) DEFAULT NULL,
`USER_AGE` varchar(128) DEFAULT NULL,
`USER_PHONE` varchar(128) DEFAULT NULL,
`USER_QQ` varchar(128) DEFAULT NULL,
`USER_ADDRESS` text,
`USER_SEX` varchar(128) DEFAULT NULL,
`OTHER_INFO` text,
`REMARK` text,
`COMPANY_ID` bigint(20) DEFAULT NULL,
`DEPARTMENT_ID` bigint(20) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
`LAST_MODIFY_TIME` datetime DEFAULT NULL,
`DELETE_FLAG` int(11) DEFAULT NULL,
`OP_USER` bigint(20) DEFAULT NULL,
`BACKUP_DATA` text,
`USER_STATE` int(11) DEFAULT NULL,
`JOIN_TIME` datetime DEFAULT NULL,
`POSITION_STATE` int(11) DEFAULT NULL,
`POSITION_ID` int(11) DEFAULT NULL,
PRIMARY KEY (`USER_ID`),
KEY `FKA4FF6AFC1EDF38C4` (`DEPARTMENT_ID`),
KEY `FKA4FF6AFCAE09C3FB` (`COMPANY_ID`),
CONSTRAINT `FKA4FF6AFC1EDF38C4` FOREIGN KEY (`DEPARTMENT_ID`) REFERENCES `tb_department` (`DEPARTMENT_ID`),
CONSTRAINT `FKA4FF6AFCAE09C3FB` FOREIGN KEY (`COMPANY_ID`) REFERENCES `tb_company` (`COMPANY_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_user`
-- ----------------------------
BEGIN;
INSERT INTO `tb_user` VALUES ('1', 'administrator', 'E10ADC3949BA59ABBE56E057F20F883E', '周东剑', '232127198705270016', '10000', '[email protected]', '周东剑', '管理员添加', '1987-05-27', '双子座', '25', '18686848328', '6884349', '哈尔滨公路大桥', '1', null, null, '1', '1', '2012-01-01 00:00:00', '2012-01-01 00:00:00', '0', '1', null, '1', '2013-04-10 10:32:35', '1', '1'), ('6', '财务', 'E10ADC3949BA59ABBE56E057F20F883E', '财务', '232188199909090011', '10001', '', '财务', '管理员添加', '2010-7-1', '', '', '', '', '', '1', null, '', '4', '6', '2013-07-10 13:40:00', '2013-09-24 15:46:34', '0', '1', null, '1', null, '2', '3'), ('13', '管理员', 'E10ADC3949BA59ABBE56E057F20F883E', '管理员', '232127201301010527', '10002', '', '', '管理员添加', '', '', '', '', '', '', '1', null, '', '4', '9', '2013-07-17 12:11:00', '2013-09-24 15:48:22', '0', '1', null, '1', null, '1', '1'), ('14', '调度', 'E10ADC3949BA59ABBE56E057F20F883E', '调度', '2321272014434313123', '10003', '', '', '管理员添加', '', '', '', '', '', '', '1', null, '', '1', '1', '2013-09-24 15:47:11', '2013-09-24 15:47:11', '0', '1', null, '1', null, '2', '1');
COMMIT;
-- ----------------------------
-- Table structure for `tb_user_department`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user_department`;
CREATE TABLE `tb_user_department` (
`KEY_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`USER_ID` bigint(20) DEFAULT NULL,
`DEPARTMENT_ID` bigint(20) DEFAULT NULL,
PRIMARY KEY (`KEY_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for `tb_user_menu_config`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user_menu_config`;
CREATE TABLE `tb_user_menu_config` (
`KEY_ID` int(11) NOT NULL AUTO_INCREMENT,
`SHOW_DESKTOP` int(11) DEFAULT NULL,
`SHOW_QUICK_START` int(11) DEFAULT NULL,
`AUTO_RUN` int(11) DEFAULT NULL,
`SHOW_DOCK_BAR` int(11) DEFAULT NULL,
`MENU_ORDER` int(11) DEFAULT NULL,
`USER_ID` int(11) DEFAULT NULL,
`MENU_ID` int(11) DEFAULT NULL,
PRIMARY KEY (`KEY_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_user_menu_config`
-- ----------------------------
BEGIN;
INSERT INTO `tb_user_menu_config` VALUES ('1', '1', '1', '1', '1', '1', '1', '1');
COMMIT;
-- ----------------------------
-- Table structure for `tb_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user_role`;
CREATE TABLE `tb_user_role` (
`KEY_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`USER_ID` bigint(20) DEFAULT NULL,
`ROLE_ID` bigint(20) DEFAULT NULL,
`MAIN_ROLE_FLAG` int(11) DEFAULT NULL,
PRIMARY KEY (`KEY_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of `tb_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `tb_user_role` VALUES ('1', '1', '1', '1'), ('51', '6', '5', '1'), ('52', '14', '9', '1'), ('53', '13', '1', '1');
COMMIT;
-- ----------------------------
-- Table structure for `tb_warning`
-- ----------------------------
DROP TABLE IF EXISTS `tb_warning`;
CREATE TABLE `tb_warning` (
`WARNING_ID` int(11) NOT NULL AUTO_INCREMENT,
`WARNING_TITLE` varchar(255) DEFAULT NULL,
`WARNING_URL` varchar(255) DEFAULT NULL,
`KEY_NAME` varchar(255) DEFAULT NULL,
`KEY_VALUE` varchar(255) DEFAULT NULL,
`PARAM_STR` varchar(255) DEFAULT NULL,
`AUTO_FLAG` int(11) DEFAULT NULL,
`USER_ID` int(11) DEFAULT NULL,
`WARNING_STATE` int(11) DEFAULT NULL,
`WARNING_LEVEL` int(11) DEFAULT NULL,
`CREATE_TIME` datetime DEFAULT NULL,
PRIMARY KEY (`WARNING_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手