text: -- MySQL dump 10.13  Distrib 5.7.9, for Win64 (x86_64)
  --
  -- Host: localhost    Database: activiti
  -- ------------------------------------------------------
  -- Server version	5.7.13-log
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!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 */;
  
  --
  -- Table structure for table `leaveapply`
  --
  
  DROP TABLE IF EXISTS `leaveapply`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `leaveapply` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `process_instance_id` varchar(45) DEFAULT NULL,
    `user_id` varchar(20) DEFAULT NULL,
    `start_time` varchar(45) DEFAULT NULL,
    `end_time` varchar(45) DEFAULT NULL,
    `leave_type` varchar(45) DEFAULT NULL,
    `reason` varchar(400) DEFAULT NULL,
    `apply_time` varchar(100) DEFAULT NULL,
    `reality_start_time` varchar(45) DEFAULT NULL,
    `reality_end_time` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `leaveapply`
  --
  
  LOCK TABLES `leaveapply` WRITE;
  /*!40000 ALTER TABLE `leaveapply` DISABLE KEYS */;
  /*!40000 ALTER TABLE `leaveapply` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `permission`
  --
  
  DROP TABLE IF EXISTS `permission`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `permission` (
    `pid` int(11) NOT NULL AUTO_INCREMENT,
    `permissionname` varchar(45) NOT NULL,
    PRIMARY KEY (`pid`),
    UNIQUE KEY `permissionname_UNIQUE` (`permissionname`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `permission`
  --
  
  LOCK TABLES `permission` WRITE;
  /*!40000 ALTER TABLE `permission` DISABLE KEYS */;
  INSERT INTO `permission` VALUES (2,'人事审批'),(9,'出纳付款'),(8,'总经理审批'),(3,'财务审批'),(1,'部门领导审批'),(15,'采购审批');
  /*!40000 ALTER TABLE `permission` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `purchase`
  --
  
  DROP TABLE IF EXISTS `purchase`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `purchase` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `itemlist` text NOT NULL,
    `total` float NOT NULL,
    `applytime` varchar(45) DEFAULT NULL,
    `applyer` varchar(45) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `purchase`
  --
  
  LOCK TABLES `purchase` WRITE;
  /*!40000 ALTER TABLE `purchase` DISABLE KEYS */;
  /*!40000 ALTER TABLE `purchase` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `role`
  --
  
  DROP TABLE IF EXISTS `role`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `role` (
    `rid` int(11) NOT NULL AUTO_INCREMENT,
    `rolename` varchar(45) NOT NULL,
    PRIMARY KEY (`rid`),
    UNIQUE KEY `rolename_UNIQUE` (`rolename`)
  ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `role`
  --
  
  LOCK TABLES `role` WRITE;
  /*!40000 ALTER TABLE `role` DISABLE KEYS */;
  INSERT INTO `role` VALUES (9,'人事'),(10,'出纳员'),(11,'总经理'),(16,'财务管理员'),(1,'部门经理'),(13,'采购经理');
  /*!40000 ALTER TABLE `role` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `role_permission`
  --
  
  DROP TABLE IF EXISTS `role_permission`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `role_permission` (
    `rpid` int(11) NOT NULL AUTO_INCREMENT,
    `roleid` int(11) NOT NULL,
    `permissionid` int(11) NOT NULL,
    PRIMARY KEY (`rpid`),
    KEY `a_idx` (`roleid`),
    KEY `b_idx` (`permissionid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `role_permission`
  --
  
  LOCK TABLES `role_permission` WRITE;
  /*!40000 ALTER TABLE `role_permission` DISABLE KEYS */;
  INSERT INTO `role_permission` VALUES (27,9,2),(28,10,9),(34,11,2),(35,11,8),(36,11,1),(37,13,15),(39,16,3),(42,1,3);
  /*!40000 ALTER TABLE `role_permission` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user`
  --
  
  DROP TABLE IF EXISTS `user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `user` (
    `uid` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(45) COLLATE utf8_bin NOT NULL,
    `password` varchar(45) COLLATE utf8_bin NOT NULL,
    `tel` varchar(45) COLLATE utf8_bin DEFAULT NULL,
    `age` int(11) DEFAULT NULL,
    PRIMARY KEY (`uid`),
    UNIQUE KEY `username_UNIQUE` (`username`)
  ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user`
  --
  
  LOCK TABLES `user` WRITE;
  /*!40000 ALTER TABLE `user` DISABLE KEYS */;
  INSERT INTO `user` VALUES (31,'xiaomi','1234','110',20),(33,'jon','1234','123',23),(34,'xiaocai','1234','111',32),(35,'WANG','1234','222',33);
  /*!40000 ALTER TABLE `user` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `user_role`
  --
  
  DROP TABLE IF EXISTS `user_role`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `user_role` (
    `urid` int(11) NOT NULL AUTO_INCREMENT,
    `userid` int(11) NOT NULL,
    `roleid` int(11) NOT NULL,
    PRIMARY KEY (`urid`)
  ) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `user_role`
  --
  
  LOCK TABLES `user_role` WRITE;
  /*!40000 ALTER TABLE `user_role` DISABLE KEYS */;
  INSERT INTO `user_role` VALUES (47,33,9),(48,33,1),(81,31,9),(82,31,10),(83,31,16),(84,31,1),(85,31,13),(86,35,11),(87,35,1),(92,34,1);
  /*!40000 ALTER TABLE `user_role` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2016-11-18 14:12:37
  