/*MySQL Data TransferSource Host: 192.168.1.11Source Database: oaTarget Host: 192.168.1.11Target Database: oaDate: 2010-3-30 9:54:21*/SET FOREIGN_KEY_CHECKS=0;-- ------------------------------ Table structure for jbpm_action-- ----------------------------CREATE TABLE `jbpm_action` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`class` char(1) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`ISPROPAGATIONALLOWED_` bit(1) DEFAULT NULL,
`ACTIONEXPRESSION_` varchar(255) DEFAULT NULL,
`ISASYNC_` bit(1) DEFAULT NULL,
`REFERENCEDACTION_` bigint(20) DEFAULT NULL,
`ACTIONDELEGATION_` bigint(20) DEFAULT NULL,
`EVENT_` bigint(20) DEFAULT NULL,
`PROCESSDEFINITION_` bigint(20) DEFAULT NULL,
`TIMERNAME_` varchar(255) DEFAULT NULL,
`DUEDATE_` varchar(255) DEFAULT NULL,
`REPEAT_` varchar(255) DEFAULT NULL,
`TRANSITIONNAME_` varchar(255) DEFAULT NULL,
`TIMERACTION_` bigint(20) DEFAULT NULL,
`EXPRESSION_` text,
`EVENTINDEX_` int(11) DEFAULT NULL,
`EXCEPTIONHANDLER_` bigint(20) DEFAULT NULL,
`EXCEPTIONHANDLERINDEX_` int(11) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_ACTION_EVENT` (`EVENT_`),
KEY `IDX_ACTION_ACTNDL` (`ACTIONDELEGATION_`),
KEY `IDX_ACTION_PROCDF` (`PROCESSDEFINITION_`),
KEY `FK_ACTION_EVENT` (`EVENT_`),
KEY `FK_ACTION_EXPTHDL` (`EXCEPTIONHANDLER_`),
KEY `FK_ACTION_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_CRTETIMERACT_TA` (`TIMERACTION_`),
KEY `FK_ACTION_ACTNDEL` (`ACTIONDELEGATION_`),
KEY `FK_ACTION_REFACT` (`REFERENCEDACTION_`),
CONSTRAINT `FK_ACTION_REFACT` FOREIGN KEY (`REFERENCEDACTION_`) REFERENCES `jbpm_action` (`ID_`),
CONSTRAINT `FK_ACTION_ACTNDEL` FOREIGN KEY (`ACTIONDELEGATION_`) REFERENCES `jbpm_delegation` (`ID_`),
CONSTRAINT `FK_ACTION_EVENT` FOREIGN KEY (`EVENT_`) REFERENCES `jbpm_event` (`ID_`),
CONSTRAINT `FK_ACTION_EXPTHDL` FOREIGN KEY (`EXCEPTIONHANDLER_`) REFERENCES `jbpm_exceptionhandler` (`ID_`),
CONSTRAINT `FK_ACTION_PROCDEF` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `jbpm_processdefinition` (`ID_`),
CONSTRAINT `FK_CRTETIMERACT_TA` FOREIGN KEY (`TIMERACTION_`) REFERENCES `jbpm_action` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_bytearray-- ----------------------------CREATE TABLE `jbpm_bytearray` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`NAME_` varchar(255) DEFAULT NULL,
`FILEDEFINITION_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `FK_BYTEARR_FILDEF` (`FILEDEFINITION_`),
CONSTRAINT `FK_BYTEARR_FILDEF` FOREIGN KEY (`FILEDEFINITION_`) REFERENCES `jbpm_moduledefinition` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_byteblock-- ----------------------------CREATE TABLE `jbpm_byteblock` (
`PROCESSFILE_` bigint(20) NOT NULL,
`BYTES_` blob,
`INDEX_` int(11) NOT NULL,
PRIMARY KEY (`PROCESSFILE_`,`INDEX_`),
KEY `FK_BYTEBLOCK_FILE` (`PROCESSFILE_`),
CONSTRAINT `FK_BYTEBL
OCK_FILE` FOREIGN KEY (`PROCESSFILE_`) REFERENCES `jbpm_bytearray` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_comment-- ----------------------------CREATE TABLE `jbpm_comment` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`VERSION_` int(11) NOT NULL,
`ACTORID_` varchar(255) DEFAULT NULL,
`TIME_` datetime DEFAULT NULL,
`MESSAGE_` text,
`TOKEN_` bigint(20) DEFAULT NULL,
`TASKINSTANCE_` bigint(20) DEFAULT NULL,
`TOKENINDEX_` int(11) DEFAULT NULL,
`TASKINSTANCEINDEX_` int(11) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_COMMENT_TOKEN` (`TOKEN_`),
KEY `IDX_COMMENT_TSK` (`TASKINSTANCE_`),
KEY `FK_COMMENT_TOKEN` (`TOKEN_`),
KEY `FK_COMMENT_TSK` (`TASKINSTANCE_`),
CONSTRAINT `FK_COMMENT_TSK` FOREIGN KEY (`TASKINSTANCE_`) REFERENCES `jbpm_taskinstance` (`ID_`),
CONSTRAINT `FK_COMMENT_TOKEN` FOREIGN KEY (`TOKEN_`) REFERENCES `jbpm_token` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_decisionconditions-- ----------------------------CREATE TABLE `jbpm_decisionconditions` (
`DECISION_` bigint(20) NOT NULL,
`TRANSITIONNAME_` varchar(255) DEFAULT NULL,
`EXPRESSION_` varchar(255) DEFAULT NULL,
`INDEX_` int(11) NOT NULL,
PRIMARY KEY (`DECISION_`,`INDEX_`),
KEY `FK_DECCOND_DEC` (`DECISION_`),
CONSTRAINT `FK_DECCOND_DEC` FOREIGN KEY (`DECISION_`) REFERENCES `jbpm_node` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_delegation-- ----------------------------CREATE TABLE `jbpm_delegation` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASSNAME_` text,
`CONFIGURATION_` text,
`CONFIGTYPE_` varchar(255) DEFAULT NULL,
`PROCESSDEFINITION_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_DELEG_PRCD` (`PROCESSDEFINITION_`),
KEY `FK_DELEGATION_PRCD` (`PROCESSDEFINITION_`),
CONSTRAINT `FK_DELEGATION_PRCD` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `jbpm_processdefinition` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_event-- ----------------------------CREATE TABLE `jbpm_event` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`EVENTTYPE_` varchar(255) DEFAULT NULL,
`TYPE_` char(1) DEFAULT NULL,
`GRAPHELEMENT_` bigint(20) DEFAULT NULL,
`PROCESSDEFINITION_` bigint(20) DEFAULT NULL,
`NODE_` bigint(20) DEFAULT NULL,
`TRANSITION_` bigint(20) DEFAULT NULL,
`TASK_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `FK_EVENT_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_EVENT_NODE` (`NODE_`),
KEY `FK_EVENT_TRANS` (`TRANSITION_`),
KEY `FK_EVENT_TASK` (`TASK_`),
CONSTRAINT `FK_EVENT_TASK` FOREIGN KEY (`TASK_`) REFERENCES `jbpm_task` (`ID_`),
CONSTRAINT `FK_EVENT_NODE` FOREIGN KEY (`NODE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_EVENT_PROCDEF` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `jbpm_proces
sdefinition` (`ID_`),
CONSTRAINT `FK_EVENT_TRANS` FOREIGN KEY (`TRANSITION_`) REFERENCES `jbpm_transition` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_exceptionhandler-- ----------------------------CREATE TABLE `jbpm_exceptionhandler` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`EXCEPTIONCLASSNAME_` text,
`TYPE_` char(1) DEFAULT NULL,
`GRAPHELEMENT_` bigint(20) DEFAULT NULL,
`PROCESSDEFINITION_` bigint(20) DEFAULT NULL,
`GRAPHELEMENTINDEX_` int(11) DEFAULT NULL,
`NODE_` bigint(20) DEFAULT NULL,
`TRANSITION_` bigint(20) DEFAULT NULL,
`TASK_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_id_group-- ----------------------------CREATE TABLE `jbpm_id_group` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`TYPE_` varchar(255) DEFAULT NULL,
`PARENT_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `FK_ID_GRP_PARENT` (`PARENT_`),
CONSTRAINT `FK_ID_GRP_PARENT` FOREIGN KEY (`PARENT_`) REFERENCES `jbpm_id_group` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_id_membership-- ----------------------------CREATE TABLE `jbpm_id_membership` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`ROLE_` varchar(255) DEFAULT NULL,
`USER_` bigint(20) DEFAULT NULL,
`GROUP_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `FK_ID_MEMSHIP_GRP` (`GROUP_`),
KEY `FK_ID_MEMSHIP_USR` (`USER_`),
CONSTRAINT `FK_ID_MEMSHIP_USR` FOREIGN KEY (`USER_`) REFERENCES `jbpm_id_user` (`ID_`),
CONSTRAINT `FK_ID_MEMSHIP_GRP` FOREIGN KEY (`GROUP_`) REFERENCES `jbpm_id_group` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_id_permissions-- ----------------------------CREATE TABLE `jbpm_id_permissions` (
`ENTITY_` bigint(20) NOT NULL,
`CLASS_` varchar(255) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`ACTION_` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_id_user-- ----------------------------CREATE TABLE `jbpm_id_user` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`EMAIL_` varchar(255) DEFAULT NULL,
`PASSWORD_` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_job-- ----------------------------CREATE TABLE `jbpm_job` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`VERSION_` int(11) NOT NULL,
`DUEDATE_` datetime DEFAULT NULL,
`PROCESSINSTANCE_` bigint(20) DEFAULT NULL,
`TOKEN_` bigint(20) DEFAULT NULL,
`TASKIN
STANCE_` bigint(20) DEFAULT NULL,
`ISSUSPENDED_` bit(1) DEFAULT NULL,
`ISEXCLUSIVE_` bit(1) DEFAULT NULL,
`LOCKOWNER_` varchar(255) DEFAULT NULL,
`LOCKTIME_` datetime DEFAULT NULL,
`EXCEPTION_` text,
`RETRIES_` int(11) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`REPEAT_` varchar(255) DEFAULT NULL,
`TRANSITIONNAME_` varchar(255) DEFAULT NULL,
`ACTION_` bigint(20) DEFAULT NULL,
`GRAPHELEMENTTYPE_` varchar(255) DEFAULT NULL,
`GRAPHELEMENT_` bigint(20) DEFAULT NULL,
`NODE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_JOB_TSKINST` (`TASKINSTANCE_`),
KEY `IDX_JOB_PRINST` (`PROCESSINSTANCE_`),
KEY `IDX_JOB_TOKEN` (`TOKEN_`),
KEY `FK_JOB_TOKEN` (`TOKEN_`),
KEY `FK_JOB_NODE` (`NODE_`),
KEY `FK_JOB_PRINST` (`PROCESSINSTANCE_`),
KEY `FK_JOB_ACTION` (`ACTION_`),
KEY `FK_JOB_TSKINST` (`TASKINSTANCE_`),
CONSTRAINT `FK_JOB_TSKINST` FOREIGN KEY (`TASKINSTANCE_`) REFERENCES `jbpm_taskinstance` (`ID_`),
CONSTRAINT `FK_JOB_ACTION` FOREIGN KEY (`ACTION_`) REFERENCES `jbpm_action` (`ID_`),
CONSTRAINT `FK_JOB_NODE` FOREIGN KEY (`NODE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_JOB_PRINST` FOREIGN KEY (`PROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`),
CONSTRAINT `FK_JOB_TOKEN` FOREIGN KEY (`TOKEN_`) REFERENCES `jbpm_token` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_log-- ----------------------------CREATE TABLE `jbpm_log` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`INDEX_` int(11) DEFAULT NULL,
`DATE_` datetime DEFAULT NULL,
`TOKEN_` bigint(20) DEFAULT NULL,
`PARENT_` bigint(20) DEFAULT NULL,
`MESSAGE_` text,
`EXCEPTION_` text,
`ACTION_` bigint(20) DEFAULT NULL,
`NODE_` bigint(20) DEFAULT NULL,
`ENTER_` datetime DEFAULT NULL,
`LEAVE_` datetime DEFAULT NULL,
`DURATION_` bigint(20) DEFAULT NULL,
`NEWLONGVALUE_` bigint(20) DEFAULT NULL,
`TRANSITION_` bigint(20) DEFAULT NULL,
`CHILD_` bigint(20) DEFAULT NULL,
`SOURCENODE_` bigint(20) DEFAULT NULL,
`DESTINATIONNODE_` bigint(20) DEFAULT NULL,
`VARIABLEINSTANCE_` bigint(20) DEFAULT NULL,
`OLDBYTEARRAY_` bigint(20) DEFAULT NULL,
`NEWBYTEARRAY_` bigint(20) DEFAULT NULL,
`OLDDATEVALUE_` datetime DEFAULT NULL,
`NEWDATEVALUE_` datetime DEFAULT NULL,
`OLDDOUBLEVALUE_` double DEFAULT NULL,
`NEWDOUBLEVALUE_` double DEFAULT NULL,
`OLDLONGIDCLASS_` varchar(255) DEFAULT NULL,
`OLDLONGIDVALUE_` bigint(20) DEFAULT NULL,
`NEWLONGIDCLASS_` varchar(255) DEFAULT NULL,
`NEWLONGIDVALUE_` bigint(20) DEFAULT NULL,
`OLDSTRINGIDCLASS_` varchar(255) DEFAULT NULL,
`OLDSTRINGIDVALUE_` varchar(255) DEFAULT NULL,
`NEWSTRINGIDCLASS_` varchar(255) DEFAULT NULL,
`NEWSTRINGIDVALUE_` varchar(255) DEFAULT NULL,
`OLDLONGVALUE_` bigint(20) DEFAULT NULL,
`OLDSTRINGVALUE_` text,
`NEWSTRINGVALUE_` text,
`TASKINSTANCE_` bigint(20) DEFAULT NULL,
`TA
SKACTORID_` varchar(255) DEFAULT NULL,
`TASKOLDACTORID_` varchar(255) DEFAULT NULL,
`SWIMLANEINSTANCE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `FK_LOG_SOURCENODE` (`SOURCENODE_`),
KEY `FK_LOG_TOKEN` (`TOKEN_`),
KEY `FK_LOG_OLDBYTES` (`OLDBYTEARRAY_`),
KEY `FK_LOG_NEWBYTES` (`NEWBYTEARRAY_`),
KEY `FK_LOG_CHILDTOKEN` (`CHILD_`),
KEY `FK_LOG_DESTNODE` (`DESTINATIONNODE_`),
KEY `FK_LOG_TASKINST` (`TASKINSTANCE_`),
KEY `FK_LOG_SWIMINST` (`SWIMLANEINSTANCE_`),
KEY `FK_LOG_PARENT` (`PARENT_`),
KEY `FK_LOG_NODE` (`NODE_`),
KEY `FK_LOG_ACTION` (`ACTION_`),
KEY `FK_LOG_VARINST` (`VARIABLEINSTANCE_`),
KEY `FK_LOG_TRANSITION` (`TRANSITION_`),
CONSTRAINT `FK_LOG_TRANSITION` FOREIGN KEY (`TRANSITION_`) REFERENCES `jbpm_transition` (`ID_`),
CONSTRAINT `FK_LOG_ACTION` FOREIGN KEY (`ACTION_`) REFERENCES `jbpm_action` (`ID_`),
CONSTRAINT `FK_LOG_CHILDTOKEN` FOREIGN KEY (`CHILD_`) REFERENCES `jbpm_token` (`ID_`),
CONSTRAINT `FK_LOG_DESTNODE` FOREIGN KEY (`DESTINATIONNODE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_LOG_NEWBYTES` FOREIGN KEY (`NEWBYTEARRAY_`) REFERENCES `jbpm_bytearray` (`ID_`),
CONSTRAINT `FK_LOG_NODE` FOREIGN KEY (`NODE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_LOG_OLDBYTES` FOREIGN KEY (`OLDBYTEARRAY_`) REFERENCES `jbpm_bytearray` (`ID_`),
CONSTRAINT `FK_LOG_PARENT` FOREIGN KEY (`PARENT_`) REFERENCES `jbpm_log` (`ID_`),
CONSTRAINT `FK_LOG_SOURCENODE` FOREIGN KEY (`SOURCENODE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_LOG_SWIMINST` FOREIGN KEY (`SWIMLANEINSTANCE_`) REFERENCES `jbpm_swimlaneinstance` (`ID_`),
CONSTRAINT `FK_LOG_TASKINST` FOREIGN KEY (`TASKINSTANCE_`) REFERENCES `jbpm_taskinstance` (`ID_`),
CONSTRAINT `FK_LOG_TOKEN` FOREIGN KEY (`TOKEN_`) REFERENCES `jbpm_token` (`ID_`),
CONSTRAINT `FK_LOG_VARINST` FOREIGN KEY (`VARIABLEINSTANCE_`) REFERENCES `jbpm_variableinstance` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_moduledefinition-- ----------------------------CREATE TABLE `jbpm_moduledefinition` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`NAME_` text,
`PROCESSDEFINITION_` bigint(20) DEFAULT NULL,
`STARTTASK_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_MODDEF_PROCDF` (`PROCESSDEFINITION_`),
KEY `FK_TSKDEF_START` (`STARTTASK_`),
KEY `FK_MODDEF_PROCDEF` (`PROCESSDEFINITION_`),
CONSTRAINT `FK_MODDEF_PROCDEF` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `jbpm_processdefinition` (`ID_`),
CONSTRAINT `FK_TSKDEF_START` FOREIGN KEY (`STARTTASK_`) REFERENCES `jbpm_task` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_moduleinstance-- ----------------------------CREATE TABLE `jbpm_moduleinstance` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`VERSION_` int(11) NOT NULL,
`PROCESSINSTANCE_` bigint(20) DEFA
ULT NULL,
`TASKMGMTDEFINITION_` bigint(20) DEFAULT NULL,
`NAME_` varchar(255) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_MODINST_PRINST` (`PROCESSINSTANCE_`),
KEY `FK_TASKMGTINST_TMD` (`TASKMGMTDEFINITION_`),
KEY `FK_MODINST_PRCINST` (`PROCESSINSTANCE_`),
CONSTRAINT `FK_MODINST_PRCINST` FOREIGN KEY (`PROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`),
CONSTRAINT `FK_TASKMGTINST_TMD` FOREIGN KEY (`TASKMGMTDEFINITION_`) REFERENCES `jbpm_moduledefinition` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_node-- ----------------------------CREATE TABLE `jbpm_node` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`DESCRIPTION_` text,
`PROCESSDEFINITION_` bigint(20) DEFAULT NULL,
`ISASYNC_` bit(1) DEFAULT NULL,
`ISASYNCEXCL_` bit(1) DEFAULT NULL,
`ACTION_` bigint(20) DEFAULT NULL,
`SUPERSTATE_` bigint(20) DEFAULT NULL,
`SUBPROCNAME_` varchar(255) DEFAULT NULL,
`SUBPROCESSDEFINITION_` bigint(20) DEFAULT NULL,
`DECISIONEXPRESSION_` varchar(255) DEFAULT NULL,
`DECISIONDELEGATION` bigint(20) DEFAULT NULL,
`SCRIPT_` bigint(20) DEFAULT NULL,
`SIGNAL_` int(11) DEFAULT NULL,
`CREATETASKS_` bit(1) DEFAULT NULL,
`ENDTASKS_` bit(1) DEFAULT NULL,
`NODECOLLECTIONINDEX_` int(11) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_PSTATE_SBPRCDEF` (`SUBPROCESSDEFINITION_`),
KEY `IDX_NODE_SUPRSTATE` (`SUPERSTATE_`),
KEY `IDX_NODE_PROCDEF` (`PROCESSDEFINITION_`),
KEY `IDX_NODE_ACTION` (`ACTION_`),
KEY `FK_PROCST_SBPRCDEF` (`SUBPROCESSDEFINITION_`),
KEY `FK_NODE_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_NODE_SCRIPT` (`SCRIPT_`),
KEY `FK_NODE_ACTION` (`ACTION_`),
KEY `FK_DECISION_DELEG` (`DECISIONDELEGATION`),
KEY `FK_NODE_SUPERSTATE` (`SUPERSTATE_`),
CONSTRAINT `FK_NODE_SUPERSTATE` FOREIGN KEY (`SUPERSTATE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_DECISION_DELEG` FOREIGN KEY (`DECISIONDELEGATION`) REFERENCES `jbpm_delegation` (`ID_`),
CONSTRAINT `FK_NODE_ACTION` FOREIGN KEY (`ACTION_`) REFERENCES `jbpm_action` (`ID_`),
CONSTRAINT `FK_NODE_PROCDEF` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `jbpm_processdefinition` (`ID_`),
CONSTRAINT `FK_NODE_SCRIPT` FOREIGN KEY (`SCRIPT_`) REFERENCES `jbpm_action` (`ID_`),
CONSTRAINT `FK_PROCST_SBPRCDEF` FOREIGN KEY (`SUBPROCESSDEFINITION_`) REFERENCES `jbpm_processdefinition` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_pooledactor-- ----------------------------CREATE TABLE `jbpm_pooledactor` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`VERSION_` int(11) NOT NULL,
`ACTORID_` varchar(255) DEFAULT NULL,
`SWIMLANEINSTANCE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_PLDACTR_ACTID` (`ACTORID_`),
KEY `IDX_TSKINST_SWLANE` (`SWIMLANEINSTANCE_`),
KEY `FK_POOLEDACTOR_SLI` (`SWIMLANEINSTANCE_`),
CONSTRAINT `FK_POOLEDACTOR_SLI` FOREIGN KEY (`SWIMLANEINSTANCE_`) REFERENCES `jbpm_swimlaneinstance` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_processdefinition-- ----------------------------CREATE TABLE `jbpm_processdefinition` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`DESCRIPTION_` text,
`VERSION_` int(11) DEFAULT NULL,
`ISTERMINATIONIMPLICIT_` bit(1) DEFAULT NULL,
`STARTSTATE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_PROCDEF_STRTST` (`STARTSTATE_`),
KEY `FK_PROCDEF_STRTSTA` (`STARTSTATE_`),
CONSTRAINT `FK_PROCDEF_STRTSTA` FOREIGN KEY (`STARTSTATE_`) REFERENCES `jbpm_node` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_processinstance-- ----------------------------CREATE TABLE `jbpm_processinstance` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`VERSION_` int(11) NOT NULL,
`KEY_` varchar(255) DEFAULT NULL,
`START_` datetime DEFAULT NULL,
`END_` datetime DEFAULT NULL,
`ISSUSPENDED_` bit(1) DEFAULT NULL,
`PROCESSDEFINITION_` bigint(20) DEFAULT NULL,
`ROOTTOKEN_` bigint(20) DEFAULT NULL,
`SUPERPROCESSTOKEN_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
UNIQUE KEY `KEY_` (`KEY_`,`PROCESSDEFINITION_`),
KEY `IDX_PROCIN_ROOTTK` (`ROOTTOKEN_`),
KEY `IDX_PROCIN_SPROCTK` (`SUPERPROCESSTOKEN_`),
KEY `IDX_PROCIN_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_PROCIN_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_PROCIN_ROOTTKN` (`ROOTTOKEN_`),
KEY `FK_PROCIN_SPROCTKN` (`SUPERPROCESSTOKEN_`),
CONSTRAINT `FK_PROCIN_SPROCTKN` FOREIGN KEY (`SUPERPROCESSTOKEN_`) REFERENCES `jbpm_token` (`ID_`),
CONSTRAINT `FK_PROCIN_PROCDEF` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `jbpm_processdefinition` (`ID_`),
CONSTRAINT `FK_PROCIN_ROOTTKN` FOREIGN KEY (`ROOTTOKEN_`) REFERENCES `jbpm_token` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_runtimeaction-- ----------------------------CREATE TABLE `jbpm_runtimeaction` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`VERSION_` int(11) NOT NULL,
`EVENTTYPE_` varchar(255) DEFAULT NULL,
`TYPE_` char(1) DEFAULT NULL,
`GRAPHELEMENT_` bigint(20) DEFAULT NULL,
`PROCESSINSTANCE_` bigint(20) DEFAULT NULL,
`ACTION_` bigint(20) DEFAULT NULL,
`PROCESSINSTANCEINDEX_` int(11) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_RTACTN_PRCINST` (`PROCESSINSTANCE_`),
KEY `IDX_RTACTN_ACTION` (`ACTION_`),
KEY `FK_RTACTN_PROCINST` (`PROCESSINSTANCE_`),
KEY `FK_RTACTN_ACTION` (`ACTION_`),
CONSTRAINT `FK_RTACTN_ACTION` FOREIGN KEY (`ACTION_`) REFERENCES `jbpm_action` (`ID_`),
CONSTRAINT `FK_RTACTN_PROCINST` FOREIGN KEY (`PROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for
jbpm_swimlane-- ----------------------------CREATE TABLE `jbpm_swimlane` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`NAME_` varchar(255) DEFAULT NULL,
`ACTORIDEXPRESSION_` varchar(255) DEFAULT NULL,
`POOLEDACTORSEXPRESSION_` varchar(255) DEFAULT NULL,
`ASSIGNMENTDELEGATION_` bigint(20) DEFAULT NULL,
`TASKMGMTDEFINITION_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `FK_SWL_ASSDEL` (`ASSIGNMENTDELEGATION_`),
KEY `FK_SWL_TSKMGMTDEF` (`TASKMGMTDEFINITION_`),
CONSTRAINT `FK_SWL_TSKMGMTDEF` FOREIGN KEY (`TASKMGMTDEFINITION_`) REFERENCES `jbpm_moduledefinition` (`ID_`),
CONSTRAINT `FK_SWL_ASSDEL` FOREIGN KEY (`ASSIGNMENTDELEGATION_`) REFERENCES `jbpm_delegation` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_swimlaneinstance-- ----------------------------CREATE TABLE `jbpm_swimlaneinstance` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`VERSION_` int(11) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`ACTORID_` varchar(255) DEFAULT NULL,
`SWIMLANE_` bigint(20) DEFAULT NULL,
`TASKMGMTINSTANCE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_SWIMLINST_SL` (`SWIMLANE_`),
KEY `FK_SWIMLANEINST_TM` (`TASKMGMTINSTANCE_`),
KEY `FK_SWIMLANEINST_SL` (`SWIMLANE_`),
CONSTRAINT `FK_SWIMLANEINST_SL` FOREIGN KEY (`SWIMLANE_`) REFERENCES `jbpm_swimlane` (`ID_`),
CONSTRAINT `FK_SWIMLANEINST_TM` FOREIGN KEY (`TASKMGMTINSTANCE_`) REFERENCES `jbpm_moduleinstance` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_task-- ----------------------------CREATE TABLE `jbpm_task` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`NAME_` varchar(255) DEFAULT NULL,
`DESCRIPTION_` text,
`PROCESSDEFINITION_` bigint(20) DEFAULT NULL,
`ISBLOCKING_` bit(1) DEFAULT NULL,
`ISSIGNALLING_` bit(1) DEFAULT NULL,
`CONDITION_` varchar(255) DEFAULT NULL,
`DUEDATE_` varchar(255) DEFAULT NULL,
`PRIORITY_` int(11) DEFAULT NULL,
`ACTORIDEXPRESSION_` varchar(255) DEFAULT NULL,
`POOLEDACTORSEXPRESSION_` varchar(255) DEFAULT NULL,
`TASKMGMTDEFINITION_` bigint(20) DEFAULT NULL,
`TASKNODE_` bigint(20) DEFAULT NULL,
`STARTSTATE_` bigint(20) DEFAULT NULL,
`ASSIGNMENTDELEGATION_` bigint(20) DEFAULT NULL,
`SWIMLANE_` bigint(20) DEFAULT NULL,
`TASKCONTROLLER_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TASK_TSKNODE` (`TASKNODE_`),
KEY `IDX_TASK_PROCDEF` (`PROCESSDEFINITION_`),
KEY `IDX_TASK_TASKMGTDF` (`TASKMGMTDEFINITION_`),
KEY `FK_TSK_TSKCTRL` (`TASKCONTROLLER_`),
KEY `FK_TASK_ASSDEL` (`ASSIGNMENTDELEGATION_`),
KEY `FK_TASK_TASKNODE` (`TASKNODE_`),
KEY `FK_TASK_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_TASK_STARTST` (`STARTSTATE_`),
KEY `FK_TASK_TASKMGTDEF` (`TASKMGMTDEFINITION_`),
KEY `FK_TASK_SWIMLANE` (`SWIMLANE_`),
CONSTRAINT `FK_TASK_SWIMLANE` FOREIGN KEY (`SWIMLANE_`) REFERENCES `jbpm_swimlane` (`ID_`),
CONSTRAINT `
FK_TASK_ASSDEL` FOREIGN KEY (`ASSIGNMENTDELEGATION_`) REFERENCES `jbpm_delegation` (`ID_`),
CONSTRAINT `FK_TASK_PROCDEF` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `jbpm_processdefinition` (`ID_`),
CONSTRAINT `FK_TASK_STARTST` FOREIGN KEY (`STARTSTATE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_TASK_TASKMGTDEF` FOREIGN KEY (`TASKMGMTDEFINITION_`) REFERENCES `jbpm_moduledefinition` (`ID_`),
CONSTRAINT `FK_TASK_TASKNODE` FOREIGN KEY (`TASKNODE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_TSK_TSKCTRL` FOREIGN KEY (`TASKCONTROLLER_`) REFERENCES `jbpm_taskcontroller` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_taskactorpool-- ----------------------------CREATE TABLE `jbpm_taskactorpool` (
`TASKINSTANCE_` bigint(20) NOT NULL,
`POOLEDACTOR_` bigint(20) NOT NULL,
PRIMARY KEY (`TASKINSTANCE_`,`POOLEDACTOR_`),
KEY `FK_TSKACTPOL_PLACT` (`POOLEDACTOR_`),
KEY `FK_TASKACTPL_TSKI` (`TASKINSTANCE_`),
CONSTRAINT `FK_TASKACTPL_TSKI` FOREIGN KEY (`TASKINSTANCE_`) REFERENCES `jbpm_taskinstance` (`ID_`),
CONSTRAINT `FK_TSKACTPOL_PLACT` FOREIGN KEY (`POOLEDACTOR_`) REFERENCES `jbpm_pooledactor` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_taskcontroller-- ----------------------------CREATE TABLE `jbpm_taskcontroller` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`TASKCONTROLLERDELEGATION_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `FK_TSKCTRL_DELEG` (`TASKCONTROLLERDELEGATION_`),
CONSTRAINT `FK_TSKCTRL_DELEG` FOREIGN KEY (`TASKCONTROLLERDELEGATION_`) REFERENCES `jbpm_delegation` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_taskinstance-- ----------------------------CREATE TABLE `jbpm_taskinstance` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`VERSION_` int(11) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`DESCRIPTION_` text,
`ACTORID_` varchar(255) DEFAULT NULL,
`CREATE_` datetime DEFAULT NULL,
`START_` datetime DEFAULT NULL,
`END_` datetime DEFAULT NULL,
`DUEDATE_` datetime DEFAULT NULL,
`PRIORITY_` int(11) DEFAULT NULL,
`ISCANCELLED_` bit(1) DEFAULT NULL,
`ISSUSPENDED_` bit(1) DEFAULT NULL,
`ISOPEN_` bit(1) DEFAULT NULL,
`ISSIGNALLING_` bit(1) DEFAULT NULL,
`ISBLOCKING_` bit(1) DEFAULT NULL,
`TASK_` bigint(20) DEFAULT NULL,
`TOKEN_` bigint(20) DEFAULT NULL,
`PROCINST_` bigint(20) DEFAULT NULL,
`SWIMLANINSTANCE_` bigint(20) DEFAULT NULL,
`TASKMGMTINSTANCE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TASKINST_TOKN` (`TOKEN_`),
KEY `IDX_TASKINST_TSK` (`TASK_`,`PROCINST_`),
KEY `IDX_TSKINST_TMINST` (`TASKMGMTINSTANCE_`),
KEY `IDX_TSKINST_SLINST` (`SWIMLANINSTANCE_`),
KEY `IDX_TASK_ACTORID` (`ACTORID_`),
KEY `FK_TSKINS_PRCINS` (`PROCINST_`),
KEY `FK_TASKINST_TMINST` (`TASKMGMTINSTANCE_`),
KEY
`FK_TASKINST_TOKEN` (`TOKEN_`),
KEY `FK_TASKINST_SLINST` (`SWIMLANINSTANCE_`),
KEY `FK_TASKINST_TASK` (`TASK_`),
CONSTRAINT `FK_TASKINST_TASK` FOREIGN KEY (`TASK_`) REFERENCES `jbpm_task` (`ID_`),
CONSTRAINT `FK_TASKINST_SLINST` FOREIGN KEY (`SWIMLANINSTANCE_`) REFERENCES `jbpm_swimlaneinstance` (`ID_`),
CONSTRAINT `FK_TASKINST_TMINST` FOREIGN KEY (`TASKMGMTINSTANCE_`) REFERENCES `jbpm_moduleinstance` (`ID_`),
CONSTRAINT `FK_TASKINST_TOKEN` FOREIGN KEY (`TOKEN_`) REFERENCES `jbpm_token` (`ID_`),
CONSTRAINT `FK_TSKINS_PRCINS` FOREIGN KEY (`PROCINST_`) REFERENCES `jbpm_processinstance` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_token-- ----------------------------CREATE TABLE `jbpm_token` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`VERSION_` int(11) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`START_` datetime DEFAULT NULL,
`END_` datetime DEFAULT NULL,
`NODEENTER_` datetime DEFAULT NULL,
`NEXTLOGINDEX_` int(11) DEFAULT NULL,
`ISABLETOREACTIVATEPARENT_` bit(1) DEFAULT NULL,
`ISTERMINATIONIMPLICIT_` bit(1) DEFAULT NULL,
`ISSUSPENDED_` bit(1) DEFAULT NULL,
`LOCK_` varchar(255) DEFAULT NULL,
`NODE_` bigint(20) DEFAULT NULL,
`PROCESSINSTANCE_` bigint(20) DEFAULT NULL,
`PARENT_` bigint(20) DEFAULT NULL,
`SUBPROCESSINSTANCE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TOKEN_PROCIN` (`PROCESSINSTANCE_`),
KEY `IDX_TOKEN_SUBPI` (`SUBPROCESSINSTANCE_`),
KEY `IDX_TOKEN_NODE` (`NODE_`),
KEY `IDX_TOKEN_PARENT` (`PARENT_`),
KEY `FK_TOKEN_PARENT` (`PARENT_`),
KEY `FK_TOKEN_NODE` (`NODE_`),
KEY `FK_TOKEN_PROCINST` (`PROCESSINSTANCE_`),
KEY `FK_TOKEN_SUBPI` (`SUBPROCESSINSTANCE_`),
CONSTRAINT `FK_TOKEN_SUBPI` FOREIGN KEY (`SUBPROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`),
CONSTRAINT `FK_TOKEN_NODE` FOREIGN KEY (`NODE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_TOKEN_PARENT` FOREIGN KEY (`PARENT_`) REFERENCES `jbpm_token` (`ID_`),
CONSTRAINT `FK_TOKEN_PROCINST` FOREIGN KEY (`PROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_tokenvariablemap-- ----------------------------CREATE TABLE `jbpm_tokenvariablemap` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`VERSION_` int(11) NOT NULL,
`TOKEN_` bigint(20) DEFAULT NULL,
`CONTEXTINSTANCE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TKVARMAP_CTXT` (`CONTEXTINSTANCE_`),
KEY `IDX_TKVVARMP_TOKEN` (`TOKEN_`),
KEY `FK_TKVARMAP_CTXT` (`CONTEXTINSTANCE_`),
KEY `FK_TKVARMAP_TOKEN` (`TOKEN_`),
CONSTRAINT `FK_TKVARMAP_TOKEN` FOREIGN KEY (`TOKEN_`) REFERENCES `jbpm_token` (`ID_`),
CONSTRAINT `FK_TKVARMAP_CTXT` FOREIGN KEY (`CONTEXTINSTANCE_`) REFERENCES `jbpm_moduleinstance` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_tran
sition-- ----------------------------CREATE TABLE `jbpm_transition` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`NAME_` varchar(255) DEFAULT NULL,
`DESCRIPTION_` text,
`PROCESSDEFINITION_` bigint(20) DEFAULT NULL,
`FROM_` bigint(20) DEFAULT NULL,
`TO_` bigint(20) DEFAULT NULL,
`CONDITION_` varchar(255) DEFAULT NULL,
`FROMINDEX_` int(11) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_TRANSIT_TO` (`TO_`),
KEY `IDX_TRANSIT_FROM` (`FROM_`),
KEY `IDX_TRANS_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_TRANSITION_TO` (`TO_`),
KEY `FK_TRANS_PROCDEF` (`PROCESSDEFINITION_`),
KEY `FK_TRANSITION_FROM` (`FROM_`),
CONSTRAINT `FK_TRANSITION_FROM` FOREIGN KEY (`FROM_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_TRANSITION_TO` FOREIGN KEY (`TO_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_TRANS_PROCDEF` FOREIGN KEY (`PROCESSDEFINITION_`) REFERENCES `jbpm_processdefinition` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_variableaccess-- ----------------------------CREATE TABLE `jbpm_variableaccess` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`VARIABLENAME_` varchar(255) DEFAULT NULL,
`ACCESS_` varchar(255) DEFAULT NULL,
`MAPPEDNAME_` varchar(255) DEFAULT NULL,
`PROCESSSTATE_` bigint(20) DEFAULT NULL,
`TASKCONTROLLER_` bigint(20) DEFAULT NULL,
`INDEX_` int(11) DEFAULT NULL,
`SCRIPT_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `FK_VARACC_TSKCTRL` (`TASKCONTROLLER_`),
KEY `FK_VARACC_SCRIPT` (`SCRIPT_`),
KEY `FK_VARACC_PROCST` (`PROCESSSTATE_`),
CONSTRAINT `FK_VARACC_PROCST` FOREIGN KEY (`PROCESSSTATE_`) REFERENCES `jbpm_node` (`ID_`),
CONSTRAINT `FK_VARACC_SCRIPT` FOREIGN KEY (`SCRIPT_`) REFERENCES `jbpm_action` (`ID_`),
CONSTRAINT `FK_VARACC_TSKCTRL` FOREIGN KEY (`TASKCONTROLLER_`) REFERENCES `jbpm_taskcontroller` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for jbpm_variableinstance-- ----------------------------CREATE TABLE `jbpm_variableinstance` (
`ID_` bigint(20) NOT NULL AUTO_INCREMENT,
`CLASS_` char(1) NOT NULL,
`VERSION_` int(11) NOT NULL,
`NAME_` varchar(255) DEFAULT NULL,
`CONVERTER_` char(1) DEFAULT NULL,
`TOKEN_` bigint(20) DEFAULT NULL,
`TOKENVARIABLEMAP_` bigint(20) DEFAULT NULL,
`PROCESSINSTANCE_` bigint(20) DEFAULT NULL,
`BYTEARRAYVALUE_` bigint(20) DEFAULT NULL,
`DATEVALUE_` datetime DEFAULT NULL,
`DOUBLEVALUE_` double DEFAULT NULL,
`LONGIDCLASS_` varchar(255) DEFAULT NULL,
`LONGVALUE_` bigint(20) DEFAULT NULL,
`STRINGIDCLASS_` varchar(255) DEFAULT NULL,
`STRINGVALUE_` varchar(255) DEFAULT NULL,
`TASKINSTANCE_` bigint(20) DEFAULT NULL,
PRIMARY KEY (`ID_`),
KEY `IDX_VARINST_TKVARMP` (`TOKENVARIABLEMAP_`),
KEY `IDX_VARINST_PRCINS` (`PROCESSINSTANCE_`),
KEY `IDX_VARINST_TK` (`TOKEN_`),
KEY `FK_VARINST_TK` (`TOKEN_`),
KEY `FK_VARINST_TKVARMP` (`TOKENVARIABLEMAP_`),
KEY
`FK_VARINST_PRCINST` (`PROCESSINSTANCE_`),
KEY `FK_VAR_TSKINST` (`TASKINSTANCE_`),
KEY `FK_BYTEINST_ARRAY` (`BYTEARRAYVALUE_`),
CONSTRAINT `FK_BYTEINST_ARRAY` FOREIGN KEY (`BYTEARRAYVALUE_`) REFERENCES `jbpm_bytearray` (`ID_`),
CONSTRAINT `FK_VARINST_PRCINST` FOREIGN KEY (`PROCESSINSTANCE_`) REFERENCES `jbpm_processinstance` (`ID_`),
CONSTRAINT `FK_VARINST_TK` FOREIGN KEY (`TOKEN_`) REFERENCES `jbpm_token` (`ID_`),
CONSTRAINT `FK_VARINST_TKVARMP` FOREIGN KEY (`TOKENVARIABLEMAP_`) REFERENCES `jbpm_tokenvariablemap` (`ID_`),
CONSTRAINT `FK_VAR_TSKINST` FOREIGN KEY (`TASKINSTANCE_`) REFERENCES `jbpm_taskinstance` (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_acl-- ----------------------------CREATE TABLE `t_acl` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`principalType` varchar(255) NOT NULL,
`principalSn` int(11) NOT NULL,
`resourceSn` int(11) NOT NULL,
`aclState` int(11) NOT NULL,
`aclTriState` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=154 DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_approveinfo-- ----------------------------CREATE TABLE `t_approveinfo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`comment` varchar(255) DEFAULT NULL,
`approveTime` datetime DEFAULT NULL,
`document` int(11) DEFAULT NULL,
`approver` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKAB3596106DD984E3` (`document`),
KEY `FKAB3596103E8A93BD` (`approver`),
CONSTRAINT `FKAB3596103E8A93BD` FOREIGN KEY (`approver`) REFERENCES `t_user` (`id`),
CONSTRAINT `FKAB3596106DD984E3` FOREIGN KEY (`document`) REFERENCES `t_document` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_document-- ----------------------------CREATE TABLE `t_document` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`content` longblob,
`creator` int(11) DEFAULT NULL,
`createTime` datetime DEFAULT NULL,
`workflow` int(11) DEFAULT NULL,
`processInstanceId` bigint(20) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK64B584C63533AD24` (`creator`),
KEY `FK64B584C6B57922B` (`workflow`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_document_properties-- ----------------------------CREATE TABLE `t_document_properties` (
`documentId` int(11) NOT NULL,
`java_lang_String` varchar(255) DEFAULT NULL,
`java_lang_Integer` int(11) DEFAULT NULL,
`java_io_File` longblob,
`propertyName` varchar(255) NOT NULL,
PRIMARY KEY (`documentId`,`propertyName`),
KEY `FK1553A26C9E9B73E` (`documentId`),
CONSTRAINT `FK1553A26C9E9B73E` FOREIGN KEY (`documentId`) REFERENCES `t_document` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_documentproperties-- --
--------------------------CREATE TABLE `t_documentproperties` (
`documentId` int(11) NOT NULL,
`java_lang_String` varchar(255) DEFAULT NULL,
`java_util_Date` datetime DEFAULT NULL,
`java_lang_Integer` int(11) DEFAULT NULL,
`java_lang_Long` bigint(20) DEFAULT NULL,
`java_io_File` longblob,
`propertyName` varchar(255) NOT NULL,
PRIMARY KEY (`documentId`,`propertyName`),
KEY `FK1B222E999E9B73E` (`documentId`),
CONSTRAINT `FK1B222E999E9B73E` FOREIGN KEY (`documentId`) REFERENCES `t_document` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_fieldinput-- ----------------------------CREATE TABLE `t_fieldinput` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`template` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_fielditem-- ----------------------------CREATE TABLE `t_fielditem` (
`fieldId` int(11) NOT NULL,
`label` varchar(255) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
`itemIndex` int(11) NOT NULL,
PRIMARY KEY (`fieldId`,`itemIndex`),
KEY `FK452244E213FFC91E` (`fieldId`),
CONSTRAINT `FK452244E213FFC91E` FOREIGN KEY (`fieldId`) REFERENCES `t_formfield` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_fieldtype-- ----------------------------CREATE TABLE `t_fieldtype` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_flowform-- ----------------------------CREATE TABLE `t_flowform` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`workflow` int(11) DEFAULT NULL,
`template` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKAA49EEBDB57922B` (`workflow`),
CONSTRAINT `FKAA49EEBDB57922B` FOREIGN KEY (`workflow`) REFERENCES `t_workflow` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_formfield-- ----------------------------CREATE TABLE `t_formfield` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`fieldLabel` varchar(255) DEFAULT NULL,
`fieldName` varchar(255) DEFAULT NULL,
`fieldInput` int(11) DEFAULT NULL,
`fieldType` int(11) DEFAULT NULL,
`flowFormId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK6436C04B2C7816D` (`fieldInput`),
KEY `FK6436C04BB83AFD4C` (`flowFormId`),
KEY `FK6436C04B73BE2D7B` (`fieldType`),
CONSTRAINT `FK6436C04B73BE2D7B` FOREIGN KEY (`fieldType`) REFERENCES `t_fieldtype` (`id`),
CONSTRAINT `FK6436C04B2C7816D` FOREIGN KEY (`fieldInput`) REFERENCES `t_fieldinput` (`id`),
CONSTRAINT `FK6436C04BB83AFD4C` FOREIGN KEY (`flowFormId`) REFERENCES `t_flowform` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ T
able structure for t_meetingroom-- ----------------------------CREATE TABLE `t_meetingroom` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sn` varchar(255) DEFAULT NULL,
`position` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `sn` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_meetingroomapply-- ----------------------------CREATE TABLE `t_meetingroomapply` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`room` int(11) DEFAULT NULL,
`beginDate` datetime DEFAULT NULL,
`endDate` datetime DEFAULT NULL,
`applyReason` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK8D106403E318ACC4` (`room`),
CONSTRAINT `FK8D106403E318ACC4` FOREIGN KEY (`room`) REFERENCES `t_meetingroom` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_module-- ----------------------------CREATE TABLE `t_module` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`sn` varchar(255) NOT NULL,
`url` varchar(255) DEFAULT NULL,
`orderNo` int(11) DEFAULT NULL,
`parentId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
UNIQUE KEY `sn` (`sn`),
KEY `FK410348D7CB79E39E` (`parentId`),
CONSTRAINT `FK410348D7CB79E39E` FOREIGN KEY (`parentId`) REFERENCES `t_module` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_organization-- ----------------------------CREATE TABLE `t_organization` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`sn` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKEF75D35E202B62EB` (`pid`),
CONSTRAINT `FKEF75D35E202B62EB` FOREIGN KEY (`pid`) REFERENCES `t_organization` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_person-- ----------------------------CREATE TABLE `t_person` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`sex` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`duty` varchar(255) DEFAULT NULL,
`phone` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`org` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK459B3DC0202B6044` (`org`),
CONSTRAINT `FK459B3DC0202B6044` FOREIGN KEY (`org`) REFERENCES `t_organization` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_role-- ----------------------------CREATE TABLE `t_role` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312;-- ------------------------------ Tabl
e structure for t_user-- ----------------------------CREATE TABLE `t_user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL,
`password` varchar(255) NOT NULL,
`createTime` datetime DEFAULT NULL,
`expireTime` datetime DEFAULT NULL,
`person` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `person` (`person`),
KEY `FK94BA2CF64EE9E097` (`person`),
CONSTRAINT `FK94BA2CF64EE9E097` FOREIGN KEY (`person`) REFERENCES `t_person` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_usersroles-- ----------------------------CREATE TABLE `t_usersroles` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role` int(11) DEFAULT NULL,
`user` int(11) DEFAULT NULL,
`orderNo` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FKD19B0A80F81C18C3` (`user`),
KEY `FKD19B0A80F8194219` (`role`),
CONSTRAINT `FKD19B0A80F8194219` FOREIGN KEY (`role`) REFERENCES `t_role` (`id`),
CONSTRAINT `FKD19B0A80F81C18C3` FOREIGN KEY (`user`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gb2312;-- ------------------------------ Table structure for t_workflow-- ----------------------------CREATE TABLE `t_workflow` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`processDefinition` longblob,
`processImage` longblob,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;-- ------------------------------ Records -- ----------------------------INSERT INTO `t_acl` VALUES ('1', 'Role', '1', '1', '15', '0');INSERT INTO `t_acl` VALUES ('2', 'Role', '1', '2', '15', '0');INSERT INTO `t_acl` VALUES ('3', 'Role', '1', '3', '15', '0');INSERT INTO `t_acl` VALUES ('4', 'Role', '1', '4', '15', '0');INSERT INTO `t_acl` VALUES ('5', 'Role', '1', '5', '15', '0');INSERT INTO `t_acl` VALUES ('6', 'Role', '1', '6', '15', '0');INSERT INTO `t_acl` VALUES ('7', 'Role', '1', '7', '15', '0');INSERT INTO `t_acl` VALUES ('8', 'Role', '1', '8', '15', '0');INSERT INTO `t_acl` VALUES ('9', 'Role', '1', '9', '15', '0');INSERT INTO `t_acl` VALUES ('10', 'Role', '1', '10', '15', '0');INSERT INTO `t_acl` VALUES ('11', 'Role', '1', '11', '15', '0');INSERT INTO `t_acl` VALUES ('12', 'Role', '1', '12', '15', '0');INSERT INTO `t_acl` VALUES ('13', 'Role', '1', '13', '15', '0');INSERT INTO `t_acl` VALUES ('14', 'Role', '1', '14', '15', '0');INSERT INTO `t_acl` VALUES ('15', 'Role', '1', '15', '15', '0');INSERT INTO `t_acl` VALUES ('16', 'Role', '1', '16', '15', '0');INSERT INTO `t_acl` VALUES ('17', 'Role', '1', '17', '15', '0');INSERT INTO `t_acl` VALUES ('18', 'Role', '1', '18', '15', '0');INSERT INTO `t_acl` VALUES ('19', 'Role', '1', '19', '15', '0');INSERT INTO `t_acl` VALUES ('20', 'Role', '1', '20', '15', '0');INSERT INTO `t_acl` VALUES ('21', 'Role', '1', '21', '15', '0');INSERT INTO `t_acl` VALUES ('22', 'Role', '1', '22', '15', '0');INSER
T INTO `t_acl` VALUES ('23', 'Role', '1', '23', '15', '0');INSERT INTO `t_acl` VALUES ('24', 'Role', '1', '24', '15', '0');INSERT INTO `t_acl` VALUES ('25', 'Role', '1', '25', '15', '0');INSERT INTO `t_acl` VALUES ('26', 'Role', '1', '26', '15', '0');INSERT INTO `t_acl` VALUES ('27', 'Role', '1', '27', '15', '0');INSERT INTO `t_acl` VALUES ('28', 'Role', '1', '28', '15', '0');INSERT INTO `t_acl` VALUES ('29', 'Role', '1', '29', '15', '0');INSERT INTO `t_acl` VALUES ('30', 'Role', '1', '30', '15', '0');INSERT INTO `t_acl` VALUES ('31', 'Role', '1', '31', '15', '0');INSERT INTO `t_acl` VALUES ('32', 'Role', '1', '32', '15', '0');INSERT INTO `t_acl` VALUES ('33', 'Role', '1', '33', '15', '0');INSERT INTO `t_acl` VALUES ('34', 'Role', '1', '34', '15', '0');INSERT INTO `t_acl` VALUES ('35', 'Role', '1', '35', '15', '0');INSERT INTO `t_acl` VALUES ('36', 'Role', '1', '36', '15', '0');INSERT INTO `t_acl` VALUES ('37', 'Role', '1', '37', '15', '0');INSERT INTO `t_acl` VALUES ('38', 'Role', '1', '38', '15', '0');INSERT INTO `t_acl` VALUES ('39', 'Role', '1', '39', '15', '0');INSERT INTO `t_acl` VALUES ('40', 'Role', '1', '40', '15', '0');INSERT INTO `t_acl` VALUES ('41', 'Role', '2', '1', '15', '0');INSERT INTO `t_acl` VALUES ('42', 'Role', '2', '2', '15', '0');INSERT INTO `t_acl` VALUES ('43', 'Role', '2', '3', '15', '0');INSERT INTO `t_acl` VALUES ('44', 'Role', '2', '4', '15', '0');INSERT INTO `t_acl` VALUES ('45', 'Role', '2', '5', '15', '0');INSERT INTO `t_acl` VALUES ('46', 'Role', '2', '6', '15', '0');INSERT INTO `t_acl` VALUES ('47', 'Role', '2', '7', '15', '0');INSERT INTO `t_acl` VALUES ('48', 'Role', '2', '8', '15', '0');INSERT INTO `t_acl` VALUES ('49', 'Role', '2', '9', '15', '0');INSERT INTO `t_acl` VALUES ('50', 'Role', '2', '10', '15', '0');INSERT INTO `t_acl` VALUES ('51', 'Role', '2', '11', '15', '0');INSERT INTO `t_acl` VALUES ('52', 'Role', '2', '12', '15', '0');INSERT INTO `t_acl` VALUES ('53', 'Role', '2', '13', '15', '0');INSERT INTO `t_acl` VALUES ('54', 'Role', '2', '14', '15', '0');INSERT INTO `t_acl` VALUES ('55', 'Role', '2', '15', '15', '0');INSERT INTO `t_acl` VALUES ('56', 'Role', '2', '16', '15', '0');INSERT INTO `t_acl` VALUES ('57', 'Role', '2', '17', '15', '0');INSERT INTO `t_acl` VALUES ('58', 'Role', '2', '18', '15', '0');INSERT INTO `t_acl` VALUES ('59', 'Role', '2', '19', '15', '0');INSERT INTO `t_acl` VALUES ('60', 'Role', '2', '20', '15', '0');INSERT INTO `t_acl` VALUES ('61', 'Role', '2', '21', '15', '0');INSERT INTO `t_acl` VALUES ('62', 'Role', '3', '1', '15', '0');INSERT INTO `t_acl` VALUES ('63', 'Role', '3', '2', '15', '0');INSERT INTO `t_acl` VALUES ('64', 'Role', '3', '3', '15', '0');INSERT INTO `t_acl` VALUES ('65', 'Role', '3', '4', '15', '0');INSERT INTO `t_acl` VALUES ('66', 'Role', '3', '5', '15', '0');INSERT INTO `t_acl` VALUES ('67', 'Role', '3', '6', '15', '0');INSERT INTO `t_acl` VALUES ('68', 'Role', '3', '7', '15', '0');INSERT INTO `t_acl` VALUES ('69', 'Role', '3', '8', '15', '0');INSERT INTO `t
_acl` VALUES ('70', 'Role', '3', '9', '15', '0');INSERT INTO `t_acl` VALUES ('71', 'Role', '3', '10', '15', '0');INSERT INTO `t_acl` VALUES ('72', 'Role', '3', '11', '15', '0');INSERT INTO `t_acl` VALUES ('73', 'Role', '3', '12', '15', '0');INSERT INTO `t_acl` VALUES ('74', 'Role', '3', '13', '15', '0');INSERT INTO `t_acl` VALUES ('75', 'Role', '3', '14', '15', '0');INSERT INTO `t_acl` VALUES ('76', 'Role', '3', '15', '15', '0');INSERT INTO `t_acl` VALUES ('77', 'Role', '3', '16', '15', '0');INSERT INTO `t_acl` VALUES ('78', 'Role', '3', '17', '15', '0');INSERT INTO `t_acl` VALUES ('79', 'Role', '3', '18', '15', '0');INSERT INTO `t_acl` VALUES ('80', 'Role', '3', '19', '15', '0');INSERT INTO `t_acl` VALUES ('81', 'Role', '3', '20', '15', '0');INSERT INTO `t_acl` VALUES ('82', 'Role', '3', '21', '15', '0');INSERT INTO `t_acl` VALUES ('83', 'Role', '3', '22', '15', '0');INSERT INTO `t_acl` VALUES ('84', 'Role', '3', '23', '15', '0');INSERT INTO `t_acl` VALUES ('85', 'Role', '3', '24', '15', '0');INSERT INTO `t_acl` VALUES ('86', 'Role', '3', '25', '15', '0');INSERT INTO `t_acl` VALUES ('87', 'Role', '3', '26', '15', '0');INSERT INTO `t_acl` VALUES ('88', 'Role', '3', '27', '15', '0');INSERT INTO `t_acl` VALUES ('89', 'Role', '3', '28', '15', '0');INSERT INTO `t_acl` VALUES ('90', 'Role', '3', '29', '15', '0');INSERT INTO `t_acl` VALUES ('91', 'Role', '3', '30', '15', '0');INSERT INTO `t_acl` VALUES ('92', 'Role', '3', '31', '15', '0');INSERT INTO `t_acl` VALUES ('93', 'Role', '3', '32', '15', '0');INSERT INTO `t_acl` VALUES ('94', 'Role', '3', '33', '15', '0');INSERT INTO `t_acl` VALUES ('95', 'Role', '3', '34', '15', '0');INSERT INTO `t_acl` VALUES ('96', 'Role', '3', '35', '15', '0');INSERT INTO `t_acl` VALUES ('97', 'Role', '3', '36', '15', '0');INSERT INTO `t_acl` VALUES ('98', 'Role', '3', '37', '15', '0');INSERT INTO `t_acl` VALUES ('99', 'Role', '3', '38', '15', '0');INSERT INTO `t_acl` VALUES ('100', 'Role', '3', '39', '15', '0');INSERT INTO `t_acl` VALUES ('101', 'Role', '3', '40', '15', '0');INSERT INTO `t_acl` VALUES ('102', 'Role', '4', '1', '15', '0');INSERT INTO `t_acl` VALUES ('103', 'Role', '4', '2', '15', '0');INSERT INTO `t_acl` VALUES ('104', 'Role', '4', '3', '15', '0');INSERT INTO `t_acl` VALUES ('105', 'Role', '4', '4', '15', '0');INSERT INTO `t_acl` VALUES ('106', 'Role', '4', '5', '15', '0');INSERT INTO `t_acl` VALUES ('107', 'Role', '4', '6', '15', '0');INSERT INTO `t_acl` VALUES ('108', 'Role', '4', '7', '15', '0');INSERT INTO `t_acl` VALUES ('109', 'Role', '4', '8', '15', '0');INSERT INTO `t_acl` VALUES ('110', 'Role', '4', '9', '15', '0');INSERT INTO `t_acl` VALUES ('111', 'Role', '4', '10', '15', '0');INSERT INTO `t_acl` VALUES ('112', 'Role', '4', '11', '15', '0');INSERT INTO `t_acl` VALUES ('113', 'Role', '4', '12', '15', '0');INSERT INTO `t_acl` VALUES ('114', 'Role', '4', '13', '15', '0');INSERT INTO `t_acl` VALUES ('115', 'Role', '4', '14', '15', '0');INSERT INTO `t_acl` VALUES ('116', 'Role', '4', '15', '15', '0')
;INSERT INTO `t_acl` VALUES ('117', 'Role', '4', '16', '15', '0');INSERT INTO `t_acl` VALUES ('118', 'Role', '4', '17', '15', '0');INSERT INTO `t_acl` VALUES ('119', 'Role', '4', '18', '15', '0');INSERT INTO `t_acl` VALUES ('120', 'Role', '4', '19', '15', '0');INSERT INTO `t_acl` VALUES ('121', 'Role', '4', '20', '15', '0');INSERT INTO `t_acl` VALUES ('122', 'Role', '4', '21', '15', '0');INSERT INTO `t_acl` VALUES ('123', 'Role', '4', '22', '15', '0');INSERT INTO `t_acl` VALUES ('124', 'Role', '4', '23', '15', '0');INSERT INTO `t_acl` VALUES ('125', 'Role', '4', '24', '15', '0');INSERT INTO `t_acl` VALUES ('126', 'Role', '4', '25', '15', '0');INSERT INTO `t_acl` VALUES ('127', 'Role', '4', '26', '15', '0');INSERT INTO `t_acl` VALUES ('128', 'Role', '4', '27', '15', '0');INSERT INTO `t_acl` VALUES ('129', 'Role', '4', '28', '15', '0');INSERT INTO `t_acl` VALUES ('130', 'Role', '4', '29', '15', '0');INSERT INTO `t_acl` VALUES ('131', 'Role', '4', '30', '15', '0');INSERT INTO `t_acl` VALUES ('132', 'Role', '4', '31', '15', '0');INSERT INTO `t_acl` VALUES ('133', 'Role', '4', '32', '15', '0');INSERT INTO `t_acl` VALUES ('134', 'Role', '4', '33', '15', '0');INSERT INTO `t_acl` VALUES ('135', 'Role', '4', '34', '15', '0');INSERT INTO `t_acl` VALUES ('136', 'Role', '4', '35', '15', '0');INSERT INTO `t_acl` VALUES ('137', 'Role', '4', '36', '15', '0');INSERT INTO `t_acl` VALUES ('138', 'Role', '4', '37', '15', '0');INSERT INTO `t_acl` VALUES ('139', 'Role', '4', '38', '15', '0');INSERT INTO `t_acl` VALUES ('140', 'Role', '4', '39', '15', '0');INSERT INTO `t_acl` VALUES ('141', 'Role', '4', '40', '15', '0');INSERT INTO `t_acl` VALUES ('142', 'Role', '5', '1', '15', '0');INSERT INTO `t_acl` VALUES ('143', 'Role', '5', '2', '15', '0');INSERT INTO `t_acl` VALUES ('144', 'Role', '5', '3', '15', '0');INSERT INTO `t_acl` VALUES ('145', 'Role', '5', '4', '15', '0');INSERT INTO `t_acl` VALUES ('146', 'Role', '5', '5', '15', '0');INSERT INTO `t_acl` VALUES ('147', 'Role', '5', '6', '15', '0');INSERT INTO `t_acl` VALUES ('148', 'Role', '5', '8', '15', '0');INSERT INTO `t_acl` VALUES ('149', 'Role', '5', '17', '15', '0');INSERT INTO `t_acl` VALUES ('150', 'Role', '5', '18', '15', '0');INSERT INTO `t_acl` VALUES ('151', 'Role', '5', '19', '15', '0');INSERT INTO `t_acl` VALUES ('152', 'Role', '5', '20', '15', '0');INSERT INTO `t_acl` VALUES ('153', 'Role', '5', '21', '15', '0');INSERT INTO `t_fieldinput` VALUES ('1', '文本输入框', 'text.ftl');INSERT INTO `t_fieldinput` VALUES ('2', '复选框', 'checkbox.ftl');INSERT INTO `t_fieldinput` VALUES ('3', '单选框', 'radio.ftl');INSERT INTO `t_fieldinput` VALUES ('4', '下拉列表框', 'select.ftl');INSERT INTO `t_fieldinput` VALUES ('5', '文件输入框', 'file.ftl');INSERT INTO `t_fieldtype` VALUES ('1', '字符串', 'https://www.doczj.com/doc/e816497498.html,ng.String');INSERT INTO `t_fieldtype` VALUES ('2', '整数', 'https://www.doczj.com/doc/e816497498.html,ng.Integer');INSERT INTO `t_fieldtype` VALUES ('3', '文件', 'java.io.File');INSERT INTO `t_module` VALUES ('1', '个人
办公', 'personaloffice', '', '10', null);INSERT INTO `t_module` VALUES ('2', '我的办公桌', 'myworkbeach', 'task.do?method=doesTask', '1010', '1');INSERT INTO `t_module` VALUES ('3', '我的便签', 'notepad', 'notepad.do', '1020', '1');INSERT INTO `t_module` VALUES ('4', '我的任务', 'mytask', 'user.do?method=mpInput', '1030', '1');INSERT INTO `t_module` VALUES ('5', '通信录', 'addresslist', 'addresslist.do', '1040', '1');INSERT INTO `t_module` VALUES ('6', '公文管理', 'doc', '', '20', null);INSERT INTO `t_module` VALUES ('7', '公文维护', 'document', 'document.do', '2010', '6');INSERT INTO `t_module` VALUES ('8', '归档处理', 'arch', 'document.do?method=searchAllFinishedDocuments', '2020', '6');INSERT INTO `t_module` VALUES ('9', '公共信息', 'pubinfo', '', '30', null);INSERT INTO `t_module` VALUES ('10', '信息管理', 'infomgr', 'info.do', '3010', '9');INSERT INTO `t_module` VALUES ('11', '行政办公', 'puboffice', '', '40', null);INSERT INTO `t_module` VALUES ('12', '会议管理', 'meeting', 'meetingRoom.do', '4010', '11');INSERT INTO `t_module` VALUES ('13', '资产管理', 'asset', 'asset.do', '4020', '11');INSERT INTO `t_module` VALUES ('14', '用品管理', 'usething', 'usething.do', '4030', '11');INSERT INTO `t_module` VALUES ('15', '车辆管理', 'car', 'car.do', '4040', '11');INSERT INTO `t_module` VALUES ('16', '图书管理', 'book', 'book.do', '4050', '11');INSERT INTO `t_module` VALUES ('17', '消息管理', 'mail', '', '50', null);INSERT INTO `t_module` VALUES ('18', '收件箱', 'inbox', 'message.do?method=inbox', '5010', '17');INSERT INTO `t_module` VALUES ('19', '发件箱', 'outbox', 'message.do?method=outbox', '5020', '17');INSERT INTO `t_module` VALUES ('20', '垃圾箱', 'trash', 'message.do?method=trash', '5030', '17');INSERT INTO `t_module` VALUES ('21', '聊天记录', 'record', 'message.do?method=record', '5040', '17');INSERT INTO `t_module` VALUES ('22', '工作流程', 'workflow', '', '60', null);INSERT INTO `t_module` VALUES ('23', '流程管理', 'flow', 'workflow.do', '6010', '22');INSERT INTO `t_module` VALUES ('24', '表单定义', 'formdef', 'workflow.do?formdef=true', '6020', '22');INSERT INTO `t_module` VALUES ('25', '组织管理', 'orgmgr', '', '70', null);INSERT INTO `t_module` VALUES ('26', '机构管理', 'org', 'org.do', '7010', '25');INSERT INTO `t_module` VALUES ('27', '人员管理', 'person', 'person.do', '7020', '25');INSERT INTO `t_module` VALUES ('28', '权限管理', 'auth', '', '80', null);INSERT INTO `t_module` VALUES ('29', '模块管理', 'module', 'module.do', '8010', '28');INSERT INTO `t_module` VALUES ('30', '角色管理', 'role', 'role.do', '8020', '28');INSERT INTO `t_module` VALUES ('31', '用户管理', 'user', 'user.do', '8030', '28');INSERT INTO `t_module` VALUES ('32', '系统管理', 'sytemmgr', '', '90', null);INSERT INTO `t_module` VALUES ('33', '密码修改', 'chgpsw', 'user.do?method=chgpsw', '9010', '32');INSERT INTO `t_module` VALUES ('34', '
代码定义', 'codedef', 'codedef.do', '9020', '32');INSERT INTO `t_module` VALUES ('35', '系统初始化', 'systeminit', 'systeminit.do', '9030', '32');INSERT INTO `t_module` VALUES ('36', '人事档案', 'employee', '', '100', null);INSERT INTO `t_module` VALUES ('37', '人员履历', 'employee1', 'employee.do', '10010', '36');INSERT INTO `t_module` VALUES ('38', '转正申请', 'employee2', 'employee.do', '10020', '36');INSERT INTO `t_module` VALUES ('39', '离职申请', 'employee3', 'employee.do', '10030', '36');INSERT INTO `t_module` VALUES ('40', '员工考勤', 'employee4', 'employee.do', '10040', '36');INSERT INTO `t_organization` VALUES ('1', '总公司', '1', null, null);INSERT INTO `t_organization` VALUES ('2', '总裁办', '1_2', null, '1');INSERT INTO `t_organization` VALUES ('3', '行政部', '1_3', null, '1');INSERT INTO `t_organization` VALUES ('4', '财务部', '1_4', null, '1');INSERT INTO `t_organization` VALUES ('5', '北京分公司', '5', null, null);INSERT INTO `t_organization` VALUES ('6', '办公室', '5_6', null, '5');INSERT INTO `t_organization` VALUES ('7', '造价咨询部', '5_7', null, '5');INSERT INTO `t_organization` VALUES ('8', '财务部', '5_8', null, '5');INSERT INTO `t_organization` VALUES ('9', '招标代理部', '5_9', null, '5');INSERT INTO `t_organization` VALUES ('10', '软件开发部', '5_10', null, '5');INSERT INTO `t_organization` VALUES ('11', 'OA项目组', '5_10_11', null, '10');INSERT INTO `t_organization` VALUES ('12', 'CRM项目组', '5_10_12', null, '10');INSERT INTO `t_organization` VALUES ('13', '烟草行业项目组', '5_10_13', null, '10');INSERT INTO `t_organization` VALUES ('14', '市场部', '5_14', null, '5');INSERT INTO `t_organization` VALUES ('15', '技术服务部', '5_15', null, '5');INSERT INTO `t_organization` VALUES ('16', '上海分公司', '16', null, null);INSERT INTO `t_organization` VALUES ('17', '上海研发中心', '16_17', null, '16');INSERT INTO `t_organization` VALUES ('18', '销售部', '16_18', null, '16');INSERT INTO `t_organization` VALUES ('19', '广州分公司', '19', null, null);INSERT INTO `t_organization` VALUES ('20', '广州研发中心', '19_20', null, '19');INSERT INTO `t_person` VALUES ('1', '陈十', null, null, null, null, null, '5');INSERT INTO `t_person` VALUES ('2', '诸一一', null, null, null, null, null, '6');INSERT INTO `t_person` VALUES ('3', '王八', null, null, null, null, null, '6');INSERT INTO `t_person` VALUES ('4', '卫一二', null, null, null, null, null, '8');INSERT INTO `t_person` VALUES ('5', '冯九', null, null, null, null, null, '10');INSERT INTO `t_person` VALUES ('6', '钱二', null, null, null, null, null, '13');INSERT INTO `t_person` VALUES ('7', '孙三', null, null, null, null, null, '13');INSERT INTO `t_person` VALUES ('8', '李四', null, null, null, null, null, '13');INSERT INTO `t_person` VALUES ('9', '周五', null, null, null, null, null, '13');INSERT INTO `t_person` VALUES ('10', '吴六', null, null, null, nul