jk-Maven-Wabapp项目相关文档

/* SQLyog Job Agent Version 8.2 Copyright(c) Webyog Softworks Pvt. Ltd. All Rights Reserved. MySQL - 5.0.87-community-nt : Database - jkdb ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`jkdb` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `jkdb`; /*Table structure for table `access_log_p` */ DROP TABLE IF EXISTS `access_log_p`; CREATE TABLE `access_log_p` ( `ACCESS_LOG_ID` varchar(40) NOT NULL, `DEPT_NAME` varchar(100) default NULL, `USER_NAME` varchar(40) default NULL, `MODULE_NAME` varchar(200) default NULL, `CURL` varchar(400) default NULL, `CREATE_BY` varchar(40) default NULL, `CREATE_TIME` datetime default NULL, PRIMARY KEY (`ACCESS_LOG_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*Data for the table `access_log_p` */ /*Table structure for table `act_evt_log` */ DROP TABLE IF EXISTS `act_evt_log`; CREATE TABLE `act_evt_log` ( `LOG_NR_` bigint(20) NOT NULL auto_increment, `TYPE_` varchar(64) collate utf8_bin default NULL, `PROC_DEF_ID_` varchar(64) collate utf8_bin default NULL, `PROC_INST_ID_` varchar(64) collate utf8_bin default NULL, `EXECUTION_ID_` varchar(64) collate utf8_bin default NULL, `TASK_ID_` varchar(64) collate utf8_bin default NULL, `TIME_STAMP_` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `USER_ID_` varchar(255) collate utf8_bin default NULL, `DATA_` longblob, `LOCK_OWNER_` varchar(255) collate utf8_bin default NULL, `LOCK_TIME_` timestamp NULL default NULL, `IS_PROCESSED_` tinyint(4) default '0', PRIMARY KEY (`LOG_NR_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `act_evt_log` */ /*Table structure for table `act_ge_bytearray` */ DROP TABLE IF EXISTS `act_ge_bytearray`; CREATE TABLE `act_ge_bytearray` ( `ID_` varchar(64) collate utf8_bin NOT NULL default '', `REV_` int(11) default NULL, `NAME_` varchar(255) collate utf8_bin default NULL, `DEPLOYMENT_ID_` varchar(64) collate utf8_bin default NULL, `BYTES_` longblob, `GENERATED_` tinyint(4) default NULL, PRIMARY KEY (`ID_`), KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`), CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*Data for the table `act_ge_bytearray` */ insert into `act_ge_bytearray` values ('45002',1,'cargo.bpmn','45001','<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<definitions xmlns=\"http://www.omg.org/spec/BPMN/20100524/MODEL\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:activiti=\"http://activiti.org/bpmn\" xmlns:bpmndi=\"http://www.omg.org/spec/BPMN/20100524/DI\" xmlns:omgdc=\"http://www.omg.org/spec/DD/20100524/DC\" xmlns:omgdi=\"http://www.omg.org/spec/DD/20100524/DI\" typeLanguage=\"http://www.w3.org/2001/XMLSchema\" expressionLanguage=\"http://www.w3.org/1999/XPath\" targetNamespace=\"http://www.activiti.org/test\">\n <process id=\"cargo\" name=\"cargo\" isExecutable=\"true\">\n <startEvent id=\"startevent1\" name=\"Start\"></startEvent>\n <userTask id=\"usertask1\" name=\"购销合同\" activiti:assignee=\"${userId}\" activiti:formKey=\"/cargo/contract\"></userTask>\n <sequenceFlow id=\"flow1\" sourceRef=\"startevent1\" targetRef=\"usertask1\"></sequenceFlow>\n <userTask id=\"usertask2\" name=\"出口报运\" activiti:assignee=\"${userId}\" activiti:formKey=\"/cargo/export\"></userTask>\n <sequenceFlow id=\"flow2\" name=\"申请\" sourceRef=\"usertask1\" targetRef=\"usertask2\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'申请\'}]]></conditionExpression>\n </sequenceFlow>\n <userTask id=\"usertask3\" name=\"装箱\" activiti:assignee=\"${userId}\" activiti:formKey=\"/cargo/packinglist\"></userTask>\n <sequenceFlow id=\"flow3\" name=\"批准\" sourceRef=\"usertask2\" targetRef=\"usertask3\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'批准\'}]]></conditionExpression>\n </sequenceFlow>\n <userTask id=\"usertask4\" name=\"委托\" activiti:assignee=\"${userId}\"></userTask>\n <sequenceFlow id=\"flow4\" name=\"批准\" sourceRef=\"usertask3\" targetRef=\"usertask4\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'批准\'}]]></conditionExpression>\n </sequenceFlow>\n <userTask id=\"usertask5\" name=\"发票\" activiti:assignee=\"${userId}\"></userTask>\n <sequenceFlow id=\"flow5\" name=\"批准\" sourceRef=\"usertask4\" targetRef=\"usertask5\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'批准\'}]]></conditionExpression>\n </sequenceFlow>\n <userTask id=\"usertask6\" name=\"财务\" activiti:assignee=\"${userId}\"></userTask>\n <sequenceFlow id=\"flow6\" name=\"批准\" sourceRef=\"usertask5\" targetRef=\"usertask6\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'批准\'}]]></conditionExpression>\n </sequenceFlow>\n <endEvent id=\"endevent1\" name=\"End\"></endEvent>\n <sequenceFlow id=\"flow7\" sourceRef=\"usertask6\" targetRef=\"endevent1\"></sequenceFlow>\n <sequenceFlow id=\"flow8\" name=\"驳回\" sourceRef=\"usertask2\" targetRef=\"usertask1\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'驳回\'}]]></conditionExpression>\n </sequenceFlow>\n <sequenceFlow id=\"flow9\" name=\"驳回\" sourceRef=\"usertask3\" targetRef=\"usertask2\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'驳回\'}]]></conditionExpression>\n </sequenceFlow>\n <sequenceFlow id=\"flow10\" name=\"驳回\" sourceRef=\"usertask4\" targetRef=\"usertask3\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'驳回\'}]]></conditionExpression>\n </sequenceFlow>\n <sequenceFlow id=\"flow11\" name=\"驳回\" sourceRef=\"usertask5\" targetRef=\"usertask4\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'驳回\'}]]></conditionExpression>\n </sequenceFlow>\n <sequenceFlow id=\"flow12\" name=\"驳回\" sourceRef=\"usertask6\" targetRef=\"usertask5\">\n <conditionExpression xsi:type=\"tFormalExpression\"><![CDATA[${outcome==\'驳回\'}]]></conditionExpression>\n </sequenceFlow>\n </process>\n <bpmndi:BPMNDiagram id=\"BPMNDiagram_cargo\">\n <bpmndi:BPMNPlane bpmnElement=\"cargo\" id=\"BPMNPlane_cargo\">\n <bpmndi:BPMNShape bpmnElement=\"startevent1\" id=\"BPMNShape_startevent1\">\n <omgdc:Bounds height=\"35.0\" width=\"35.0\" x=\"405.0\" y=\"17.0\"></omgdc:Bounds>\n </bpmndi:BPMNShape>\n <bpmndi:BPMNShape bpmnElement=\"usertask1\" id=\"BPMNShape_usertask1\">\n <omgdc:Bounds height=\"55.0\" width=\"105.0\" x=\"370.0\" y=\"90.0\"></omgdc:Bounds>\n </bpmndi:BPMNShape>\n <bpmndi:BPMNShape bpmnElement=\"usertask2\" id=\"BPMNShape_usertask2\">\n <omgdc:Bounds height=\"55.0\" width=\"105.0\" x=\"370.0\" y=\"180.0\"></omgdc:Bounds>\n </bpmndi:BPMNShape>\n <bpmndi:BPMNShape bpmnElement=\"usertask3\" id=\"BPMNShape_usertask3\">\n <omgdc:Bounds height=\"55.0\" width=\"105.0\" x=\"370.0\" y=\"271.0\"></omgdc:Bounds>\n </bpmndi:BPMNShape>\n <bpmndi:BPMNShape bpmnElement=\"usertask4\" id=\"BPMNShape_usertask4\">\n <omgdc:Bounds height=\"55.0\" width=\"105.0\" x=\"370.0\" y=\"361.0\"></omgdc:Bounds>\n </bpmndi:BPMNShape>\n <bpmndi: