-- MySQL dump 10.13  Distrib 5.1.73, for redhat-linux-gnu (x86_64)
--
-- Host: localhost    Database: salon
-- ------------------------------------------------------
-- Server version	5.1.73

/*!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 `artificer_daily`
--

DROP TABLE IF EXISTS `artificer_daily`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `artificer_daily` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '技师id',
  `work_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '类型（1-业绩；2-OTC现金；3-OTC POS；4-OTC支付宝；5-OTC销卡；6-护理充值；7-护理销卡；8-护理；9-其他）',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '金额(workType=8时，是护理次数）',
  `work_date` varchar(10) DEFAULT '' COMMENT '日期',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建日期',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新日期',
  `create_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建者',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `store_id` int(11) DEFAULT '0' COMMENT '门店',
  PRIMARY KEY (`id`),
  KEY `IDX_employee_id` (`employee_id`),
  KEY `IDX_work_date` (`work_date`),
  KEY `IDX_work_type` (`work_type`),
  KEY `IDX_store_id` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='技师每日数据';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `artificer_daily`
--

LOCK TABLES `artificer_daily` WRITE;
/*!40000 ALTER TABLE `artificer_daily` DISABLE KEYS */;
/*!40000 ALTER TABLE `artificer_daily` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attendance_info`
--

DROP TABLE IF EXISTS `attendance_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `attendance_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '员工',
  `affair_date` varchar(10) DEFAULT NULL COMMENT '事情日期',
  `duration_hour` int(11) NOT NULL DEFAULT '0' COMMENT '时间（单位：小时）',
  `affair_type` tinyint(4) DEFAULT '0' COMMENT '事件类型（1-休息；2-半天；3-事假；4-病假；5-旷工；6-加班；7-培训）',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `create_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建者',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `store_id` int(11) DEFAULT '0' COMMENT '门店',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `IDX_employee_id` (`employee_id`),
  KEY `IDX_affair_date` (`affair_date`),
  KEY `IDX_affair_type` (`affair_type`),
  KEY `IDX_store_id` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='考勤记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attendance_info`
--

LOCK TABLES `attendance_info` WRITE;
/*!40000 ALTER TABLE `attendance_info` DISABLE KEYS */;
INSERT INTO `attendance_info` VALUES (1,26,'2016-10-03',8,1,1475402013,1475402092,11,1,1,''),(2,25,'2016-10-03',8,1,1475402077,1475402077,11,1,1,'');
/*!40000 ALTER TABLE `attendance_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `employee_info`
--

DROP TABLE IF EXISTS `employee_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `employee_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_name` varchar(50) NOT NULL COMMENT '员工名称',
  `employee_code` varchar(50) DEFAULT NULL COMMENT '编号',
  `employee_type` tinyint(4) DEFAULT '0' COMMENT '类型（1-发型师；2-技师；3-助理）',
  `entry_date` varchar(10) NOT NULL DEFAULT '' COMMENT '入职日期',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建日期',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新日期',
  `create_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建者',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `pic` varchar(200) DEFAULT NULL COMMENT '图片',
  `store_id` int(11) NOT NULL DEFAULT '0' COMMENT '门店id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='员工信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `employee_info`
--

LOCK TABLES `employee_info` WRITE;
/*!40000 ALTER TABLE `employee_info` DISABLE KEYS */;
INSERT INTO `employee_info` VALUES (8,'谢明亮','6',1,'2016-01-01',1475381838,1475381838,11,1,NULL,1),(9,'刘岗峰','8',1,'2016-01-01',1475381867,1475381867,11,1,NULL,1),(10,'曹伟','41',1,'2016-01-01',1475381880,1475381880,11,1,NULL,1),(11,'刘会恒','1',1,'2016-01-01',1475381898,1475381898,11,1,NULL,1),(12,'李文','9',1,'2016-01-01',1475381911,1475381911,11,1,NULL,1),(13,'Sam','87',2,'2016-10-01',1475383660,1475383660,11,1,NULL,1),(14,'Eric','81',2,'2016-10-01',1475383678,1475383678,11,1,NULL,1),(15,'小雨','31',1,'2012-09-02',1475384441,1475384441,11,1,NULL,1),(16,'mark','42',1,'2015-09-20',1475384481,1475384481,11,1,NULL,1),(17,'Ella','21',1,'2015-10-02',1475384520,1475384520,11,1,NULL,1),(18,'艾德','16',2,'2016-10-02',1475384556,1475384556,11,1,NULL,1),(19,'卡尔','61',2,'2016-10-02',1475384581,1475384581,11,1,NULL,1),(20,'毛毛','70',3,'2016-10-02',1475384602,1475384602,11,1,NULL,1),(21,'西西','89',2,'2016-10-02',1475384628,1475384628,11,1,NULL,1),(22,'橙子','90',2,'2016-10-02',1475384647,1475384647,11,1,NULL,1),(23,'Eleven','91',2,'2016-10-02',1475384678,1475384678,11,1,NULL,1),(24,'艾文','86',3,'2016-10-02',1475384700,1475384700,11,1,NULL,1),(25,'Andy','88',1,'2016-10-02',1475384752,1475384752,11,1,NULL,1),(26,'妮可','85',2,'2016-10-02',1475384788,1475384788,11,1,NULL,1),(29,'SAM','87',1,'2016-10-01',1477017364,1477017364,11,1,NULL,1);
/*!40000 ALTER TABLE `employee_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses_daily`
--

DROP TABLE IF EXISTS `expenses_daily`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `expenses_daily` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `expenses_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '开支方式（1-房租；2-水电；3-工资；4-杂项；5-产品）',
  `expenses_desc` varchar(100) DEFAULT NULL COMMENT '开支明细',
  `expenses_date` varchar(10) DEFAULT NULL COMMENT '开支日期',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '金额（单位：分）',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建日期',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新日期',
  `create_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建者',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `store_id` int(11) DEFAULT '0' COMMENT '门店',
  PRIMARY KEY (`id`),
  KEY `IDX_expenses_type` (`expenses_type`),
  KEY `IDX_expenses_date` (`expenses_date`),
  KEY `IDX_store_id` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='开支明细表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses_daily`
--

LOCK TABLES `expenses_daily` WRITE;
/*!40000 ALTER TABLE `expenses_daily` DISABLE KEYS */;
INSERT INTO `expenses_daily` VALUES (1,5,'','2016-10-01',10000,1475384130,1475384130,11,1,1),(2,4,'','2016-10-01',5100,1475384140,1475384140,11,1,1);
/*!40000 ALTER TABLE `expenses_daily` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hair_daily`
--

DROP TABLE IF EXISTS `hair_daily`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hair_daily` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employee_id` int(11) NOT NULL DEFAULT '0' COMMENT '发型师',
  `pay_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '付款方式（1-现金；2-POS；3-销卡；4-现金充值；5-POS充值；6-闪惠充值；7-团购；8-闪惠；9-OTC现金；10-OTC POS；11-OTC销卡；12-OTC闪惠；13-老卡；14-水洗；15-其他）',
  `amount` int(11) NOT NULL DEFAULT '0' COMMENT '金额（单位：分）',
  `pay_date` varchar(10) DEFAULT NULL COMMENT '付款日期',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建日期',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新日期',
  `create_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建者',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `store_id` int(11) DEFAULT '0' COMMENT '门店',
  `group_purchase_star` tinyint(4) DEFAULT '0' COMMENT '团购评价等级（1-一星；2-二星；3-三星；4-四星；5-五星）',
  `group_purchase_evaluate` varchar(1000) DEFAULT NULL COMMENT '团购评价内容',
  PRIMARY KEY (`id`),
  KEY `IDX_employee_id` (`employee_id`),
  KEY `IDX_pay_type` (`pay_type`),
  KEY `IDX_pay_date` (`pay_date`),
  KEY `IDX_group_purchase_star` (`group_purchase_star`),
  KEY `IDX_store_id` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8 COMMENT='发型师每日数据';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hair_daily`
--

LOCK TABLES `hair_daily` WRITE;
/*!40000 ALTER TABLE `hair_daily` DISABLE KEYS */;
INSERT INTO `hair_daily` VALUES (9,8,1,100,'2016-10-01',1475382260,1475382260,11,2,1,1,''),(10,8,1,100,'2016-10-01',1475382541,1475382541,11,2,1,5,''),(11,8,1,100,'2016-10-01',1475382622,1475382622,11,2,1,3,''),(12,8,8,500,'2016-10-02',1475383160,1475383160,11,2,1,4,''),(13,8,8,300,'2016-10-03',1475383458,1475383458,11,2,1,4,''),(15,15,7,662,'2016-10-01',1475395517,1475395517,11,1,1,5,''),(16,8,3,100,'2016-10-01',1475395543,1475395543,11,1,1,5,''),(17,25,3,20,'2016-10-01',1475395591,1475395591,11,1,1,5,''),(18,12,3,56,'2016-10-01',1475395695,1475395695,11,1,1,5,''),(19,9,3,670,'2016-10-01',1475395725,1475395725,11,1,1,5,''),(20,15,3,340,'2016-10-01',1475395742,1475395742,11,1,1,5,''),(21,9,3,120,'2016-10-01',1475395763,1475395763,11,1,1,5,''),(22,10,3,120,'2016-10-01',1475395798,1475395798,11,1,1,5,''),(23,9,3,60,'2016-10-01',1475395826,1475395826,11,1,1,5,''),(24,16,2,266,'2016-10-01',1475396171,1475396171,11,1,1,5,''),(25,8,3,400,'2016-10-01',1475396216,1475396216,11,1,1,5,''),(26,25,3,65,'2016-10-01',1475396261,1475396261,11,1,1,5,''),(27,15,3,90,'2016-10-01',1475396308,1475396308,11,1,1,5,''),(28,16,3,60,'2016-10-01',1475396384,1475396384,11,1,1,5,''),(29,10,3,220,'2016-10-01',1475396849,1475396849,11,1,1,5,''),(30,9,3,100,'2016-10-01',1475396876,1475396876,11,1,1,5,''),(31,17,3,40,'2016-10-01',1475396903,1475396903,11,1,1,5,''),(33,8,3,882,'2016-10-01',1475397002,1475397002,11,1,1,5,''),(34,8,11,150,'2016-10-01',1475397017,1475397017,11,1,1,5,''),(35,8,2,150,'2016-10-01',1475397041,1475397041,11,1,1,5,''),(36,12,3,90,'2016-10-01',1475397064,1475397064,11,1,1,5,''),(37,25,3,792,'2016-10-01',1475397086,1475397086,11,1,1,5,''),(38,9,3,60,'2016-10-01',1475397110,1475397110,11,1,1,5,''),(39,17,2,100,'2016-10-01',1475397129,1475397129,11,1,1,5,''),(40,16,2,30,'2016-10-01',1475397176,1475397176,11,1,1,5,''),(41,17,2,38,'2016-10-01',1475397344,1475397344,11,1,1,5,''),(42,16,2,38,'2016-10-01',1475397365,1475397365,11,1,1,5,''),(43,16,2,38,'2016-10-01',1475397393,1475397393,11,1,1,5,''),(44,12,2,60,'2016-10-01',1475397483,1475397483,11,1,1,5,''),(45,15,11,150,'2016-10-01',1475397513,1475397513,11,1,1,5,''),(46,15,3,1560,'2016-10-01',1475397534,1475397534,11,1,1,5,''),(47,15,5,600,'2016-10-01',1475397564,1475397564,11,1,1,5,''),(48,10,5,580,'2016-10-01',1475397591,1475397591,11,1,1,5,''),(49,10,3,1080,'2016-10-01',1475397627,1475397627,11,1,1,5,''),(50,17,7,396,'2016-10-01',1475397800,1475397800,11,1,1,5,''),(51,25,7,964,'2016-10-01',1475397828,1475397828,11,1,1,5,''),(52,25,3,557,'2016-10-01',1475397852,1475397852,11,1,1,5,''),(53,25,5,1500,'2016-10-01',1475397872,1475397872,11,1,1,5,''),(54,9,7,98,'2016-10-01',1475397897,1475397897,11,1,1,5,''),(55,9,3,1240,'2016-10-01',1475397924,1475397924,11,1,1,5,''),(56,9,5,1500,'2016-10-01',1475397953,1475397953,11,1,1,5,''),(57,15,7,116,'2016-10-01',1475397997,1475397997,11,1,1,5,''),(58,15,3,380,'2016-10-01',1475398802,1475465088,11,1,1,3,''),(59,15,2,50,'2016-10-01',1475398819,1475405166,11,1,1,2,''),(60,15,4,500,'2016-10-01',1475398858,1475398858,11,1,1,5,''),(61,16,3,1045,'2016-10-01',1475398883,1475398883,11,1,1,5,''),(62,16,1,100,'2016-10-01',1475398906,1475398906,11,1,1,5,''),(63,16,5,500,'2016-10-01',1475398924,1475398935,11,1,1,2,''),(64,12,1,78,'2016-10-01',1475398965,1475398965,11,1,1,5,''),(65,12,3,1841,'2016-10-01',1475399023,1475399023,11,1,1,5,''),(66,12,4,770,'2016-10-01',1475399041,1475399049,11,1,1,1,''),(67,12,5,2500,'2016-10-01',1475399073,1475399073,11,1,1,5,''),(68,10,5,3000,'2016-10-01',1475399119,1475399119,11,1,1,5,''),(69,10,3,1870,'2016-10-01',1475399146,1475399146,11,1,1,5,''),(70,8,5,5002,'2016-10-01',1475399200,1475399200,11,1,1,5,''),(71,8,3,2822,'2016-10-01',1475399263,1475405153,11,1,1,3,''),(72,10,3,100,'2016-10-01',1475399303,1475399303,11,1,1,5,''),(78,8,3,2592,'2016-10-20',1477017230,1477017230,11,1,1,0,NULL),(79,8,5,3690,'2016-10-20',1477017230,1477017230,11,1,1,0,NULL),(80,8,3,150,'2016-10-20',1477017230,1477017230,11,2,1,0,NULL),(81,12,3,1651,'2016-10-20',1477017303,1477017303,11,1,1,0,NULL),(82,12,7,58,'2016-10-20',1477017303,1477017303,11,1,1,0,NULL),(83,12,5,2000,'2016-10-20',1477017303,1477018084,11,1,1,NULL,NULL),(84,29,1,25,'2016-10-20',1477017383,1477017383,11,1,1,0,NULL),(85,15,3,660,'2016-10-20',1477017564,1477017564,11,1,1,0,NULL),(86,15,7,116,'2016-10-20',1477017564,1477017564,11,1,1,0,NULL),(87,15,1,110,'2016-10-20',1477017564,1477017564,11,1,1,0,NULL),(88,15,5,2000,'2016-10-20',1477017564,1477017564,11,1,1,0,NULL),(89,15,16,50,'2016-10-20',1477017564,1477017564,11,1,1,0,NULL),(90,10,1,100,'2016-10-20',1477017642,1477017642,11,1,1,0,NULL),(91,10,3,1180,'2016-10-20',1477017642,1477017642,11,1,1,0,NULL),(92,10,7,58,'2016-10-20',1477017642,1477017642,11,1,1,0,NULL),(93,10,5,500,'2016-10-20',1477017642,1477017642,11,1,1,0,NULL),(94,16,1,85,'2016-10-20',1477017750,1477017750,11,1,1,0,NULL),(95,16,2,25,'2016-10-20',1477017750,1477017750,11,1,1,0,NULL),(96,16,3,85,'2016-10-20',1477017750,1477017750,11,1,1,0,NULL),(97,25,1,165,'2016-10-20',1477017858,1477017858,11,1,1,0,NULL),(98,25,2,85,'2016-10-20',1477017858,1477017858,11,1,1,0,NULL),(99,25,7,590,'2016-10-20',1477017858,1477017858,11,1,1,0,NULL),(100,25,3,95,'2016-10-20',1477017858,1477017858,11,1,1,0,NULL),(101,25,11,280,'2016-10-20',1477017858,1477017858,11,1,1,0,NULL),(102,8,11,150,'2016-10-20',1477017970,1477017970,11,1,1,0,NULL);
/*!40000 ALTER TABLE `hair_daily` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `store_info`
--

DROP TABLE IF EXISTS `store_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `store_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store_name` varchar(100) NOT NULL COMMENT '门店名称',
  `store_addr` varchar(200) DEFAULT NULL COMMENT '门店地址',
  `telephone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `create_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建者',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `open_date` varchar(10) DEFAULT NULL COMMENT '开店日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='门店';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store_info`
--

LOCK TABLES `store_info` WRITE;
/*!40000 ALTER TABLE `store_info` DISABLE KEYS */;
INSERT INTO `store_info` VALUES (1,'恒沙廊1','凤凰店','025-83206405',1,1473094847,1475379877,1,'2016-09-08'),(2,'门店2','门店2方法','111',1,1473096365,1473096365,1,'2016-08-30');
/*!40000 ALTER TABLE `store_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_menu`
--

DROP TABLE IF EXISTS `sys_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_menu` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menu_name` varchar(100) NOT NULL COMMENT '菜单名称',
  `menu_url` varchar(200) DEFAULT NULL COMMENT '菜单地址',
  `parent_menu_id` int(11) DEFAULT NULL COMMENT '父菜单ID',
  `sort_number` int(11) DEFAULT NULL COMMENT '排序号',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态',
  `menu_type` tinyint(4) DEFAULT '0' COMMENT '菜单类型（1-根节点；2-子结点；3-按钮）',
  `button_id` varchar(50) DEFAULT NULL COMMENT '按钮的ID名称',
  `icon_name` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `target` varchar(50) DEFAULT NULL COMMENT '菜单指向',
  `extra_url` varchar(200) DEFAULT NULL COMMENT '额外参数',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `create_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建者',
  PRIMARY KEY (`menu_id`),
  UNIQUE KEY `menu_id` (`menu_id`)
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=utf8 COMMENT='系统菜单表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_menu`
--

LOCK TABLES `sys_menu` WRITE;
/*!40000 ALTER TABLE `sys_menu` DISABLE KEYS */;
INSERT INTO `sys_menu` VALUES (1,'系统管理',NULL,0,2,1,1,NULL,NULL,NULL,NULL,0,0,0),(2,'用户管理','/jsp/sysManage/sysUser/sysUserList.jsp',1,1,1,2,'','',NULL,'',0,1473785365,0),(3,'角色管理','/jsp/sysManage/sysRole/sysRoleList.jsp',1,2,1,2,NULL,NULL,NULL,NULL,0,0,0),(4,'菜单管理','/jsp/sysManage/sysMenu/sysMenuList.jsp',1,3,1,2,NULL,NULL,NULL,NULL,0,0,0),(5,'查询角色列表','',3,1,1,3,'','',NULL,'sysRoleList.jsp,sysRoleSearch.jsp,queryAllSysRole.do',0,1473870231,0),(6,'新增角色','',3,2,1,3,'addSysRoleBtn','',NULL,'sysRoleEdit.jsp',0,1473870264,0),(7,'数据录入',NULL,0,3,1,1,NULL,NULL,NULL,NULL,0,0,0),(9,'修改角色','',3,3,1,3,'editSysRoleBtn','',NULL,'sysRoleEdit.jsp',0,1473783724,0),(10,'保存角色','',3,4,1,3,'saveSysRoleBtn','',NULL,'saveSysRole.do',0,1473443318,0),(11,'删除角色','',3,5,1,3,'delSysRoleBtn','',NULL,'deleteSysRole.do',0,1473443347,0),(12,'查询角色权限','',3,6,1,3,'viewRoleMenuBtn','',NULL,'sysRoleMenuEdit.jsp,queryAllSysMenu.do,querySysMenuByRoleId.do',0,1473608555,0),(13,'保存角色权限','',3,7,1,3,'saveRoleMenuBtn','',NULL,'saveSysRoleMenu.do',0,1473608585,0),(14,'查询用户列表','',2,1,1,3,'','',NULL,'sysUserList.jsp,sysUserSearch.jsp,queryAllSysUser.do,queryAllStoreInfo.do',0,1473787183,0),(15,'新增用户','',2,2,1,3,'addSysUserBtn','',NULL,'sysUserEdit.jsp,queryAllStoreInfo.do,queryAllSysRole.do,selectByUserId.do',0,1473784520,0),(16,'修改用户','',2,3,1,3,'editSysUserBtn','',NULL,'sysUserEdit.jsp,queryAllStoreInfo.do,queryAllSysRole.do,selectByUserId.do',0,1473442993,0),(17,'保存用户','',2,4,1,3,'saveSysUserBtn','',NULL,'saveSysUser.do',0,1473917939,0),(18,'删除用户','',2,5,1,3,'delSysUserBtn','',NULL,'deleteSysUser.do',0,1473917951,0),(43,'修改密码','/jsp/sysManage/pwdManage/modifyPwd.jsp',1,5,1,2,'','',NULL,'modifyPwd.jsp,pwdPanel.jsp,modifyPwd.do',0,1474784508,0),(44,'地区管理','/jsp/sysManage/sysRegion/regionList.jsp',1,4,2,2,NULL,'',NULL,'queryAllRegion.do,regionRight.jsp,deleteSysregion.do,saveSysRegion.do',0,0,0),(46,'用户组管理','/jsp/sysManage/sysUserGroup/userGroupList.jsp',1,6,2,2,NULL,NULL,NULL,'queryAllSysUserGroup.do',0,0,0),(47,'查询',NULL,46,1,1,3,NULL,NULL,NULL,'queryAllSysUserGroup.do',0,0,0),(48,'新增',NULL,46,2,1,3,'addUserGroupBtn',NULL,NULL,'userGroupEdit.jsp',0,0,0),(49,'修改',NULL,46,3,1,3,'editUserGroupBtn',NULL,NULL,'userGroupEdit.jsp',0,0,0),(50,'删除',NULL,46,4,1,3,'delUserGroupBtn',NULL,NULL,'deleteSysUserGroup.do',0,0,0),(51,'保存',NULL,46,5,1,3,'saveUserGroupBtn',NULL,NULL,'saveSysUserGroup.do',0,0,0),(52,'配置用户组用户','',46,6,1,3,'configUserGroupUserBtn','',NULL,'userGroupUser.jsp,queryForSelectUserByGroupId.do,querySysUserGroupByGroupId.do',0,0,0),(53,'保存配置用户组用户','',46,7,1,3,'saveConfigUserGroupUserBtn','',NULL,'addSysUserGroupUser.do',0,0,0),(54,'查看用户详情','',2,6,1,3,'viewSysUserBtn','',NULL,'sysUserEdit.jsp,queryAllStoreInfo.do,queryAllSysRole.do,selectByUserId.do',0,1473785237,0),(55,'查看角色详情','',3,8,1,3,'viewSysRoleBtn','',NULL,'sysRoleEdit.jsp',0,1473911016,0),(56,'详情','',46,8,1,3,'detailUserGroupBtn','',NULL,'userGroupEdit.jsp',0,0,0),(57,'技师每日数据维护','/jsp/daily/artificerDaily/artificerDailyList.jsp',7,2,1,2,'','22',NULL,'sad',0,0,0),(58,'员工管理','/jsp/sysManage/employeeInfo/employeeInfoList.jsp',1,7,1,2,NULL,NULL,NULL,NULL,0,0,0),(59,'发型师每日数据维护','/jsp/daily/hairDaily/hairDailyList.jsp',7,1,1,2,NULL,NULL,NULL,NULL,0,0,0),(60,'开支数据维护','/jsp/daily/expensesDaily/expensesDailyList.jsp',7,3,1,2,NULL,NULL,NULL,NULL,0,0,0),(61,'考勤数据维护','/jsp/daily/attendanceInfo/attendanceInfoList.jsp',7,4,1,2,NULL,NULL,NULL,NULL,0,0,0),(62,'门店维护','/jsp/sysManage/storeInfo/storeInfoList.jsp',1,7,1,2,NULL,NULL,NULL,NULL,0,0,0),(63,'查看员工列表','',58,1,1,3,'','',NULL,'employeeInfoList.jsp,employeeInfoSearch.jsp,queryAllEmployeeInfo.do',1473783433,1473870828,1),(64,'新增员工','',58,2,1,3,'addEmployeeInfoBtn','',NULL,'employeeInfoEdit.jsp,queryAllStoreInfo.do',1473783588,1473783588,1),(65,'修改员工','',58,3,1,3,'editEmployeeInfoBtn','',NULL,'employeeInfoEdit.jsp,queryAllStoreInfo.do',1473871007,1473871007,1),(66,'保存员工','',58,4,1,3,'saveEmployeeInfoBtn','',NULL,'saveEmployeeInfo.do',1473871044,1473871044,1),(67,'删除员工','',58,5,1,3,'delEmployeeInfoBtn','',NULL,'deleteEmployeeInfo.do',1473871080,1473871080,1),(68,'查看员工详情','',58,6,1,3,'viewEmployeeInfoBtn','',NULL,'employeeInfoEdit.jsp,queryAllStoreInfo.do',1473871137,1473871145,1),(69,'查看门店列表','',62,1,1,3,'','',NULL,'storeInfoList.jsp,storeInfoSearch.jsp,queryAllStoreInfo.do',1473871235,1473871235,1),(70,'新增门店','',62,2,1,3,'addStoreInfoBtn','',NULL,'storeInfoEdit.jsp',1473871289,1473871289,1),(71,'修改门店','',62,3,1,3,'editStoreInfoBtn','',NULL,'storeInfoEdit.jsp',1473871405,1473871405,1),(72,'保存门店','',62,4,1,3,'saveStoreInfoBtn','',NULL,'saveStoreInfo.do',1473871491,1473871491,1),(73,'删除门店','',62,5,1,3,'delStoreInfoBtn','',NULL,'deleteStoreInfo.do',1473871538,1473871538,1),(74,'查看门店详情','',62,5,1,3,'viewStoreInfoBtn','',NULL,'employeeInfoEdit.jsp',1473871579,1473871579,1),(75,'查看发型师每日数据列表','',59,1,1,3,'','',NULL,'hairDailyList.jsp,hairDailySearch.jsp,queryAllEmployeeInfo.do,queryAllHairDaily.do',1473908807,1473908807,1),(76,'新增发型师每日数据','',59,2,1,3,'addHairDailyBtn','',NULL,'hairDailyEdit.jsp,queryAllEmployeeInfo.do',1473909017,1473909017,1),(77,'修改发型师每日数据','',59,3,1,3,'editHairDailyBtn','',NULL,'hairDailyEdit.jsp,queryAllEmployeeInfo.do',1473910870,1473911145,1),(78,'保存发型师每日数据','',59,4,1,3,'saveHairDailyBtn','',NULL,'saveHairDaily.do',1473910932,1473910932,1),(79,'删除发型师每日数据','',59,5,1,3,'delHairDailyBtn','',NULL,'deleteHairDaily.do',1473911130,1473911130,1),(80,'查看发型师每日数据详情','',59,6,1,3,'viewHairDailyBtn','',NULL,'hairDailyEdit.jsp,queryAllEmployeeInfo.do',1473911202,1473911227,1),(81,'查看技师每日数据','',57,1,1,3,'','',NULL,'artificerDailyList.jsp,artificerDailySearch.jsp,queryAllEmployeeInfo.do,queryAllArtificerDaily.do',1473922663,1473922663,1),(82,'新增技师每日数据','',57,2,1,3,'addArtificerDailyBtn','',NULL,'artificerDailyEdit.jsp,queryAllEmployeeInfo.do',1473923002,1473923002,1),(83,'修改技师每日数据','',57,3,1,3,'editArtificerDailyBtn','',NULL,'artificerDailyEdit.jsp,queryAllEmployeeInfo.do',1473923124,1473923124,1),(84,'保存技师每日数据','',57,4,1,3,'saveArtificerDailyBtn','',NULL,'saveArtificerDaily.do',1473923199,1473923199,1),(85,'删除技师每日数据','',57,5,1,3,'delArtificerDailyBtn','',NULL,'deleteArtificerDaily.do',1473923245,1473923245,1),(86,'查看技师每日数据详情','',57,6,1,3,'viewArtificerDailyBtn','',NULL,'artificerDailyEdit.jsp,queryAllEmployeeInfo.do',1473924548,1473924548,1),(87,'查看开支数据','',60,1,1,3,'','',NULL,'expensesDailyList.jsp,expensesDailySearch.jsp,queryAllExpensesDaily.do',1473924681,1473924681,1),(88,'新增开支数据','',60,2,1,3,'addExpensesDailyBtn','',NULL,'expensesDailyEdit.jsp,queryAllStoreInfo.do',1473924745,1475510625,1),(89,'修改开支数据','',60,3,1,3,'editExpensesDailyBtn','',NULL,'expensesDailyEdit.jsp,queryAllStoreInfo.do',1473924824,1475510631,1),(90,'保存开支数据','',60,4,1,3,'saveExpensesDailyBtn','',NULL,'saveExpensesDaily.do',1473924877,1473924877,1),(91,'删除开支数据','',60,5,1,3,'delExpensesDailyBtn','',NULL,'deleteExpensesDaily.do',1473924920,1473924920,1),(92,'查看开支数据详情','',60,6,1,3,'viewExpensesDailyBtn','',NULL,'expensesDailyEdit.jsp',1473924947,1473924947,1),(93,'查看考勤数据','',61,1,1,3,'','',NULL,'attendanceInfoList.jsp,attendanceInfoSearch.jsp,queryAllEmployeeInfo.do,queryAllAttendanceInfo.do',1473925138,1473925138,1),(94,'新增考勤数据','',61,2,1,3,'addAttendanceInfoBtn','',NULL,'attendanceInfoEdit.jsp,queryAllEmployeeInfo.do',1473925433,1473925433,1),(95,'修改考勤数据','',61,3,1,3,'editAttendanceInfoBtn','',NULL,'attendanceInfoEdit.jsp,queryAllEmployeeInfo.do',1473925523,1473925523,1),(96,'保存考勤数据','',61,4,1,3,'saveAttendanceInfoBtn','',NULL,'saveAttendanceInfo.do',1473925579,1473925579,1),(97,'删除考勤数据','',61,5,1,3,'delAttendanceInfoBtn','',NULL,'deleteAttendanceInfo.do',1473925636,1473925636,1),(98,'查看考勤数据详情','',61,6,1,3,'viewAttendanceInfoBtn','',NULL,'attendanceInfoEdit.jsp,queryAllEmployeeInfo.do',1473925673,1473925673,1),(99,'数据统计','',0,3,1,1,'','',NULL,'',1474128441,1474128441,1),(100,'发型师数据统计','/jsp/statistics/hairDaily/hairDailyStatisticsList.jsp',99,1,1,2,'','',NULL,'hairDailyStatisticsSearch.jsp,queryAllEmployeeInfo.do,queryHairDailyStatistics.do',1474128510,1474128510,1),(101,'技师数据统计','/jsp/statistics/artificerDaily/artificerDailyStatisticsList.jsp',99,3,1,2,'','',NULL,'artificerDailyStatisticsSearch.jsp,queryAllEmployeeInfo.do,queryArtificerDailyStatistics.do',1474301165,1475338664,1),(102,'卡金余额数据统计','/jsp/statistics/remainStatistics/remainStatisticsList.jsp',99,4,1,2,'','',NULL,'remainStatisticsList.jsp,remainStatisticsSearch.jsp,queryRemainStatisticsList.do,queryAllStoreInfo.do',1474473255,1475338669,1),(103,'营业额统计','/jsp/statistics/monthBusinessStatistics/monthBusinessStatisticsList.jsp',99,5,1,2,'','',NULL,'monthBusinessStatisticsList.jsp,monthBusinessStatisticsSearch.jsp,queryMonthBusinessStatisticsList.do,queryAllStoreInfo.do,selectMonthBusinessStatisticsChart.do',1474561287,1475338824,1),(104,'年度营业开支','/jsp/statistics/yearBusinessStatistics/yearBusinessStatisticsList.jsp',99,6,1,2,'','',NULL,'yearBusinessStatisticsList.jsp,yearBusinessStatisticsSearch.jsp,queryYearBusinessStatisticsList.do,queryAllStoreInfo.do',1474740178,1475338678,1),(105,'发型师业绩统计','/jsp/statistics/hairAchievementStatistics/hairAchievementStatisticsList.jsp',99,2,1,2,'','',NULL,'hairAchievementStatisticsList.jsp,hairAchievementStatisticsSearch.jsp,queryMonthBusinessStatisticsList.do,queryAllEmployeeInfo.do,selectMonthBusinessStatisticsChart',1475338805,1475339010,1);
/*!40000 ALTER TABLE `sys_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_pwd_history`
--

DROP TABLE IF EXISTS `sys_pwd_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_pwd_history` (
  `pwd_his_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '历史密码ID',
  `login_pwd` varchar(200) NOT NULL COMMENT '历史密码',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `pwd_create_date` timestamp NOT NULL DEFAULT '1989-12-31 16:00:01' COMMENT '密码创建日期',
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
  PRIMARY KEY (`pwd_his_id`),
  UNIQUE KEY `pwd_his_id` (`pwd_his_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户历史密码';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_pwd_history`
--

LOCK TABLES `sys_pwd_history` WRITE;
/*!40000 ALTER TABLE `sys_pwd_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_pwd_history` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_region`
--

DROP TABLE IF EXISTS `sys_region`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_region` (
  `region_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '地区ID',
  `region_name` varchar(100) NOT NULL COMMENT '地区名称',
  `region_code` varchar(100) DEFAULT NULL COMMENT '地区编号',
  `region_type` varchar(50) DEFAULT NULL COMMENT '地区类型',
  `parent_region_id` int(11) DEFAULT NULL COMMENT '父节点ID',
  `sort_number` int(11) DEFAULT NULL COMMENT '地区排序',
  PRIMARY KEY (`region_id`),
  UNIQUE KEY `region_id` (`region_id`)
) ENGINE=InnoDB AUTO_INCREMENT=364 DEFAULT CHARSET=utf8 COMMENT='地区表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_region`
--

LOCK TABLES `sys_region` WRITE;
/*!40000 ALTER TABLE `sys_region` DISABLE KEYS */;
INSERT INTO `sys_region` VALUES (1,'安徽','551','PROVINCE',0,NULL),(2,'北京','100','PROVINCE',0,NULL),(3,'福建','591','PROVINCE',0,NULL),(4,'甘肃','931','PROVINCE',0,NULL),(5,'广东','200','PROVINCE',0,NULL),(6,'广西','771','PROVINCE',0,NULL),(7,'贵州','851','PROVINCE',0,NULL),(8,'海南','898','PROVINCE',0,NULL),(9,'河北','311','PROVINCE',0,NULL),(10,'河南','371','PROVINCE',0,NULL),(11,'黑龙江','451','PROVINCE',0,NULL),(12,'湖北','270','PROVINCE',0,NULL),(13,'湖南','731','PROVINCE',0,NULL),(14,'吉林','431','PROVINCE',0,NULL),(15,'江苏','250','PROVINCE',0,NULL),(16,'江西','791','PROVINCE',0,NULL),(17,'辽宁','240','PROVINCE',0,NULL),(18,'内蒙古','471','PROVINCE',0,NULL),(19,'宁夏','951','PROVINCE',0,NULL),(20,'青海','971','PROVINCE',0,NULL),(21,'山东','531','PROVINCE',0,NULL),(22,'山西','351','PROVINCE',0,NULL),(23,'陕西','290','PROVINCE',0,NULL),(24,'上海','210','PROVINCE',0,NULL),(25,'四川','280','PROVINCE',0,NULL),(26,'天津','220','PROVINCE',0,NULL),(27,'西藏','891','PROVINCE',0,NULL),(28,'新疆','991','PROVINCE',0,NULL),(29,'云南','871','PROVINCE',0,NULL),(30,'浙江','571','PROVINCE',0,NULL),(31,'重庆','023','PROVINCE',0,NULL),(32,'凉山','0834','CITY',25,NULL),(33,'眉山','0833','CITY',25,NULL),(34,'绵阳','0816','CITY',25,NULL),(35,'南充','0817','CITY',25,NULL),(36,'内江','0832','CITY',25,NULL),(37,'攀枝花','0812','CITY',25,NULL),(38,'遂宁','0825','CITY',25,NULL),(39,'雅安','0835','CITY',25,NULL),(40,'宜宾','0831','CITY',25,NULL),(41,'资阳','0832','CITY',25,NULL),(42,'自贡','0813','CITY',25,NULL),(43,'泸州','0830','CITY',25,NULL),(44,'天津','022','CITY',26,NULL),(45,'阿里','0897','CITY',27,NULL),(46,'昌都','0895','CITY',27,NULL),(47,'拉萨','0891','CITY',27,NULL),(48,'林芝','0894','CITY',27,NULL),(49,'那曲','0896','CITY',27,NULL),(50,'日喀则','0892','CITY',27,NULL),(51,'山南','0893','CITY',27,NULL),(52,'阿克苏','0997','CITY',28,NULL),(53,'阿勒泰','0906','CITY',28,NULL),(54,'博乐','0909','CITY',28,NULL),(55,'昌吉','0994','CITY',28,NULL),(56,'哈密','0902','CITY',28,NULL),(57,'和田','0903','CITY',28,NULL),(58,'喀什','0998','CITY',28,NULL),(59,'克拉玛依','0990','CITY',28,NULL),(60,'克州','0908','CITY',28,NULL),(61,'库尔勒','0996','CITY',28,NULL),(62,'奎屯','0992','CITY',28,NULL),(63,'石河子','0993','CITY',28,NULL),(64,'塔城','0901','CITY',28,NULL),(65,'吐鲁番','0995','CITY',28,NULL),(66,'乌鲁木齐','0991','CITY',28,NULL),(67,'伊犁','0999','CITY',28,NULL),(68,'版纳','0691','CITY',29,NULL),(69,'保山','0875','CITY',29,NULL),(70,'楚雄','0878','CITY',29,NULL),(71,'大理','0872','CITY',29,NULL),(72,'德宏','0692','CITY',29,NULL),(73,'迪庆','0887','CITY',29,NULL),(74,'红河','0873','CITY',29,NULL),(75,'昆明','0871','CITY',29,NULL),(76,'丽江','0888','CITY',29,NULL),(77,'临沧','0883','CITY',29,NULL),(78,'怒江','0886','CITY',29,NULL),(79,'曲靖','0874','CITY',29,NULL),(80,'思茅','0879','CITY',29,NULL),(81,'文山','0876','CITY',29,NULL),(82,'玉溪','0877','CITY',29,NULL),(83,'昭通','0870','CITY',29,NULL),(84,'杭州','0571','CITY',30,NULL),(85,'湖州','0572','CITY',30,NULL),(86,'嘉兴','0573','CITY',30,NULL),(87,'金华','0579','CITY',30,NULL),(88,'丽水','0578','CITY',30,NULL),(89,'宁波','0574','CITY',30,NULL),(90,'绍兴','0575','CITY',30,NULL),(91,'台州','0576','CITY',30,NULL),(92,'温州','0577','CITY',30,NULL),(93,'舟山','0580','CITY',30,NULL),(94,'衢州','0570','CITY',30,NULL),(95,'涪陵','023','CITY',31,NULL),(96,'黔江','023','CITY',31,NULL),(97,'万州','023','CITY',31,NULL),(98,'赣州','0797','CITY',16,NULL),(99,'萍乡','0799','CITY',16,NULL),(100,'鹰潭','0701','CITY',16,NULL),(101,'抚顺','0413','CITY',17,NULL),(102,'辽阳','0419','CITY',17,NULL),(103,'巴彦浩特','0483','CITY',18,NULL),(104,'呼和浩特','0471','CITY',18,NULL),(105,'锡林浩特','0479','CITY',18,NULL),(106,'德令哈','0977','CITY',20,NULL),(107,'黄南','0973','CITY',20,NULL),(108,'东营','0546','CITY',21,NULL),(109,'青岛','0532','CITY',21,NULL),(110,'烟台','0535','CITY',21,NULL),(111,'晋城','0356','CITY',22,NULL),(112,'太原','0351','CITY',22,NULL),(113,'汉中','0916','CITY',23,NULL),(114,'咸阳','029','CITY',23,NULL),(115,'巴中','0827','CITY',25,NULL),(116,'广安','0826','CITY',25,NULL),(117,'吴忠','0953','CITY',19,NULL),(118,'共和','0974','CITY',20,NULL),(119,'西宁','0971','CITY',20,NULL),(120,'菏泽','0530','CITY',21,NULL),(121,'临沂','0539','CITY',21,NULL),(122,'潍坊','0536','CITY',21,NULL),(123,'大同','0352','CITY',22,NULL),(124,'朔州','0349','CITY',22,NULL),(125,'安康','0915','CITY',23,NULL),(126,'渭南','0913','CITY',23,NULL),(127,'上海','021','CITY',24,NULL),(128,'德阳','0838','CITY',25,NULL),(129,'安庆','0556','CITY',1,NULL),(130,'蚌埠','0552','CITY',1,NULL),(131,'巢湖','0565','CITY',1,NULL),(132,'池州','0566','CITY',1,NULL),(133,'滁州','0550','CITY',1,NULL),(134,'阜阳','0558','CITY',1,NULL),(135,'合肥','0551','CITY',1,NULL),(136,'淮北','0561','CITY',1,NULL),(137,'淮南','0554','CITY',1,NULL),(138,'黄山','0559','CITY',1,NULL),(139,'六安','0564','CITY',1,NULL),(140,'马鞍山','0555','CITY',1,NULL),(141,'宿州','0557','CITY',1,NULL),(142,'铜陵','0562','CITY',1,NULL),(143,'芜湖','0553','CITY',1,NULL),(144,'宣城','0563','CITY',1,NULL),(145,'北京','010','CITY',2,NULL),(146,'福州','0591','CITY',3,NULL),(147,'龙岩','0597','CITY',3,NULL),(148,'南平','0599','CITY',3,NULL),(149,'宁德','0593','CITY',3,NULL),(150,'莆田','0594','CITY',3,NULL),(151,'泉州','0595','CITY',3,NULL),(152,'三明','0598','CITY',3,NULL),(153,'厦门','0592','CITY',3,NULL),(154,'漳州','0596','CITY',3,NULL),(155,'白银','0943','CITY',4,NULL),(156,'定西','0932','CITY',4,NULL),(157,'甘南','0941','CITY',4,NULL),(158,'金昌武威','0935','CITY',4,NULL),(159,'酒泉嘉峪关','0937','CITY',4,NULL),(160,'兰州','0931','CITY',4,NULL),(161,'临夏','0930','CITY',4,NULL),(162,'陇南','0939','CITY',4,NULL),(163,'平凉','0933','CITY',4,NULL),(164,'庆阳','0934','CITY',4,NULL),(165,'天水','0938','CITY',4,NULL),(166,'张掖','0936','CITY',4,NULL),(167,'潮州','0768','CITY',5,NULL),(168,'东莞','0769','CITY',5,NULL),(169,'佛山','0757','CITY',5,NULL),(170,'广州','020','CITY',5,NULL),(171,'河源','0762','CITY',5,NULL),(172,'惠州','0752','CITY',5,NULL),(173,'江门','0750','CITY',5,NULL),(174,'揭阳','0663','CITY',5,NULL),(175,'茂名','0668','CITY',5,NULL),(176,'梅州','0753','CITY',5,NULL),(177,'清远','0763','CITY',5,NULL),(178,'汕头','0754','CITY',5,NULL),(179,'汕尾','0660','CITY',5,NULL),(180,'韶关','0751','CITY',5,NULL),(181,'深圳','0755','CITY',5,NULL),(182,'阳江','0662','CITY',5,NULL),(183,'云浮','0766','CITY',5,NULL),(184,'湛江','0759','CITY',5,NULL),(185,'肇庆','0758','CITY',5,NULL),(186,'中山','0760','CITY',5,NULL),(187,'珠海','0756','CITY',5,NULL),(188,'百色','0776','CITY',6,NULL),(189,'北海','0779','CITY',6,NULL),(190,'防城港','0770','CITY',6,NULL),(191,'桂林','0773','CITY',6,NULL),(192,'河池','0778','CITY',6,NULL),(193,'柳州','0772','CITY',6,NULL),(194,'南宁','0771','CITY',6,NULL),(195,'钦州','0777','CITY',6,NULL),(196,'梧州','0774','CITY',6,NULL),(197,'玉林','0775','CITY',6,NULL),(198,'安顺','0853','CITY',7,NULL),(199,'毕节','0857','CITY',7,NULL),(200,'都匀','0854','CITY',7,NULL),(201,'贵阳','0851','CITY',7,NULL),(202,'凯里','0855','CITY',7,NULL),(203,'六盘水','0858','CITY',7,NULL),(204,'铜仁','0856','CITY',7,NULL),(205,'兴义','0859','CITY',7,NULL),(206,'遵义','0852','CITY',7,NULL),(207,'海口','0898','CITY',8,NULL),(208,'保定','0312','CITY',9,NULL),(209,'沧州','0317','CITY',9,NULL),(210,'承德','0314','CITY',9,NULL),(211,'邯郸','0310','CITY',9,NULL),(212,'衡水','0318','CITY',9,NULL),(213,'廊坊','0316','CITY',9,NULL),(214,'石家庄','0311','CITY',9,NULL),(215,'邢台','0319','CITY',9,NULL),(216,'张家口','0313','CITY',9,NULL),(217,'安阳','0372','CITY',10,NULL),(218,'鹤壁','0392','CITY',10,NULL),(219,'焦作','0391','CITY',10,NULL),(220,'开封','0378','CITY',10,NULL),(221,'洛阳','0379','CITY',10,NULL),(222,'南阳','0377','CITY',10,NULL),(223,'平顶山','0375','CITY',10,NULL),(224,'三门峡','0398','CITY',10,NULL),(225,'商丘','0370','CITY',10,NULL),(226,'新乡','0373','CITY',10,NULL),(227,'信阳','0376','CITY',10,NULL),(228,'许昌','0374','CITY',10,NULL),(229,'郑州','0371','CITY',10,NULL),(230,'周口','0394','CITY',10,NULL),(231,'驻马店','0396','CITY',10,NULL),(232,'潢川','0376','CITY',10,NULL),(233,'漯河','0395','CITY',10,NULL),(234,'濮阳','0393','CITY',10,NULL),(235,'大庆','0459','CITY',11,NULL),(236,'大兴安岭','0456','CITY',11,NULL),(237,'哈尔滨','0451','CITY',11,NULL),(238,'鹤岗','0454','CITY',11,NULL),(239,'黑河','0456','CITY',11,NULL),(240,'鸡西','0453','CITY',11,NULL),(241,'佳木斯','0454','CITY',11,NULL),(242,'牡丹江','0453','CITY',11,NULL),(243,'七台河','0453','CITY',11,NULL),(244,'齐齐哈尔','0452','CITY',11,NULL),(245,'双鸭山','0454','CITY',11,NULL),(246,'绥化','0458','CITY',11,NULL),(247,'伊春','0458','CITY',11,NULL),(248,'鄂州','0711','CITY',12,NULL),(249,'恩施','0718','CITY',12,NULL),(250,'黄冈','0713','CITY',12,NULL),(251,'黄石','0714','CITY',12,NULL),(252,'江汉','0728','CITY',12,NULL),(253,'荆门','0724','CITY',12,NULL),(254,'荆州','0716','CITY',12,NULL),(255,'十堰','0719','CITY',12,NULL),(256,'随州','0722','CITY',12,NULL),(257,'武汉','027','CITY',12,NULL),(258,'咸宁','0715','CITY',12,NULL),(259,'襄樊','0710','CITY',12,NULL),(260,'孝感','0712','CITY',12,NULL),(261,'宜昌','0717','CITY',12,NULL),(262,'常德','0736','CITY',13,NULL),(263,'长沙','0731','CITY',13,NULL),(264,'郴州','0735','CITY',13,NULL),(265,'衡阳','0734','CITY',13,NULL),(266,'怀化','0745','CITY',13,NULL),(267,'吉首','0743','CITY',13,NULL),(268,'娄底','0738','CITY',13,NULL),(269,'邵阳','0739','CITY',13,NULL),(270,'湘潭','0732','CITY',13,NULL),(271,'益阳','0737','CITY',13,NULL),(272,'永州','0746','CITY',13,NULL),(273,'岳阳','0730','CITY',13,NULL),(274,'张家界','0744','CITY',13,NULL),(275,'株洲','0733','CITY',13,NULL),(276,'白城','0436','CITY',14,NULL),(277,'白山','0439','CITY',14,NULL),(278,'长春','0431','CITY',14,NULL),(279,'吉林','0432','CITY',14,NULL),(280,'辽源','0437','CITY',14,NULL),(281,'梅河口','0435','CITY',14,NULL),(282,'四平','0434','CITY',14,NULL),(283,'松原','0438','CITY',14,NULL),(284,'通化','0435','CITY',14,NULL),(285,'延吉','0433','CITY',14,NULL),(286,'珲春','0433','CITY',14,NULL),(287,'常州','0519','CITY',15,NULL),(288,'淮安','0517','CITY',15,NULL),(289,'连云港','0518','CITY',15,NULL),(290,'南京','025','CITY',15,NULL),(291,'南通','0513','CITY',15,NULL),(292,'苏州','0512','CITY',15,NULL),(293,'宿迁','0527','CITY',15,NULL),(294,'泰州','0523','CITY',15,NULL),(295,'无锡','0510','CITY',15,NULL),(296,'徐州','0516','CITY',15,NULL),(297,'盐城','0515','CITY',15,NULL),(298,'扬州','0514','CITY',15,NULL),(299,'镇江','0511','CITY',15,NULL),(300,'抚州','0794','CITY',16,NULL),(301,'吉安','0796','CITY',16,NULL),(302,'景德镇','0798','CITY',16,NULL),(303,'九江','0792','CITY',16,NULL),(304,'南昌','0791','CITY',16,NULL),(305,'上饶','0793','CITY',16,NULL),(306,'新余','0790','CITY',16,NULL),(307,'宜春','0795','CITY',16,NULL),(308,'鞍山','0412','CITY',17,NULL),(309,'朝阳','0421','CITY',17,NULL),(310,'大连','0411','CITY',17,NULL),(311,'阜新','0418','CITY',17,NULL),(312,'葫芦岛','0429','CITY',17,NULL),(313,'锦州','0416','CITY',17,NULL),(314,'盘锦','0427','CITY',17,NULL),(315,'沈阳','024','CITY',17,NULL),(316,'铁岭','0410','CITY',17,NULL),(317,'营口','0417','CITY',17,NULL),(318,'包头','0472','CITY',18,NULL),(319,'赤峰','0476','CITY',18,NULL),(320,'鄂尔多斯','0477','CITY',18,NULL),(321,'海拉尔','0470','CITY',18,NULL),(322,'集宁','0474','CITY',18,NULL),(323,'临河','0478','CITY',18,NULL),(324,'通辽','0475','CITY',18,NULL),(325,'乌兰浩特','0482','CITY',18,NULL),(326,'固原','0954','CITY',19,NULL),(327,'石嘴山','0952','CITY',19,NULL),(328,'银川','0951','CITY',19,NULL),(329,'中卫','0955','CITY',19,NULL),(330,'格尔木','0979','CITY',20,NULL),(331,'果洛','0975','CITY',20,NULL),(332,'海东','0972','CITY',20,NULL),(333,'海晏','0970','CITY',20,NULL),(334,'玉树','0976','CITY',20,NULL),(335,'滨州','0543','CITY',21,NULL),(336,'德州','0534','CITY',21,NULL),(337,'济南','0531','CITY',21,NULL),(338,'济宁','0537','CITY',21,NULL),(339,'莱芜','0634','CITY',21,NULL),(340,'聊城','0635','CITY',21,NULL),(341,'日照','0633','CITY',21,NULL),(342,'泰安','0538','CITY',21,NULL),(343,'威海','0631','CITY',21,NULL),(344,'枣庄','0632','CITY',21,NULL),(345,'淄博','0533','CITY',21,NULL),(346,'长治','0355','CITY',22,NULL),(347,'晋中','0354','CITY',22,NULL),(348,'临汾','0357','CITY',22,NULL),(349,'吕梁','0358','CITY',22,NULL),(350,'忻州','0350','CITY',22,NULL),(351,'阳泉','0353','CITY',22,NULL),(352,'运城','0359','CITY',22,NULL),(353,'宝鸡','0917','CITY',23,NULL),(354,'商洛','0914','CITY',23,NULL),(355,'铜川','0919','CITY',23,NULL),(356,'西安','029','CITY',23,NULL),(357,'延安','0911','CITY',23,NULL),(358,'榆林','0912','CITY',23,NULL),(359,'阿坝','0837','CITY',25,NULL),(360,'成都','028','CITY',25,NULL),(361,'达州','0818','CITY',25,NULL),(362,'甘孜','0836','CITY',25,NULL),(363,'广元','0839','CITY',25,NULL);
/*!40000 ALTER TABLE `sys_region` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `role_name` varchar(50) NOT NULL COMMENT '角色名称',
  `role_info` varchar(400) DEFAULT NULL COMMENT '角色描述',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '角色状态',
  `create_user_id` int(11) DEFAULT '0' COMMENT '创建者ID',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建日期',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`role_id`),
  UNIQUE KEY `role_id` (`role_id`),
  UNIQUE KEY `role_name` (`role_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='系统角色表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` VALUES (1,'店长','',1,1,0,1475379938),(2,'前台','前台',1,2,0,1475379967),(3,'财务','',1,1,1475379977,1475379977);
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_menu`
--

DROP TABLE IF EXISTS `sys_role_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role_menu` (
  `role_id` int(11) NOT NULL COMMENT '角色ID',
  `menu_id` int(11) NOT NULL COMMENT '菜单ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统角色菜单关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_menu`
--

LOCK TABLES `sys_role_menu` WRITE;
/*!40000 ALTER TABLE `sys_role_menu` DISABLE KEYS */;
INSERT INTO `sys_role_menu` VALUES (2,43),(2,75),(2,76),(2,77),(2,78),(2,79),(2,80),(2,81),(2,82),(2,83),(2,84),(2,85),(2,86),(2,87),(2,88),(2,89),(2,90),(2,91),(2,92),(2,93),(2,94),(2,95),(2,96),(2,97),(2,98),(2,100),(2,105),(2,101),(2,102),(2,103),(2,104),(1,14),(1,15),(1,16),(1,17),(1,18),(1,5),(1,6),(1,9),(1,10),(1,11),(1,12),(1,13),(1,43),(1,63),(1,64),(1,65),(1,66),(1,67),(1,69),(1,70),(1,71),(1,72),(1,73),(1,75),(1,76),(1,77),(1,78),(1,79),(1,80),(1,81),(1,82),(1,83),(1,84),(1,85),(1,86),(1,87),(1,88),(1,89),(1,90),(1,91),(1,92),(1,93),(1,94),(1,95),(1,96),(1,97),(1,98),(1,100),(1,105),(1,101),(1,102),(1,103),(1,104),(3,14),(3,15),(3,16),(3,17),(3,18),(3,5),(3,6),(3,9),(3,10),(3,11),(3,12),(3,13),(3,43),(3,63),(3,64),(3,65),(3,66),(3,67),(3,69),(3,70),(3,71),(3,72),(3,73),(3,75),(3,76),(3,77),(3,78),(3,79),(3,80),(3,81),(3,82),(3,83),(3,84),(3,85),(3,86),(3,87),(3,88),(3,89),(3,90),(3,91),(3,92),(3,93),(3,94),(3,95),(3,96),(3,97),(3,98),(3,100),(3,105),(3,101),(3,102),(3,103),(3,104);
/*!40000 ALTER TABLE `sys_role_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `user_name` varchar(100) NOT NULL COMMENT '用户名',
  `login_name` varchar(50) NOT NULL COMMENT '登录名',
  `login_pwd` varchar(100) NOT NULL COMMENT '登录密码',
  `mobile` varchar(20) DEFAULT '' COMMENT '手机号码',
  `phone_number` varchar(20) DEFAULT '' COMMENT '固定电话',
  `address` varchar(200) DEFAULT '' COMMENT '用户地址',
  `email` varchar(100) DEFAULT '' COMMENT 'email',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '用户状态（1-正常；2-已删除；3-无效）',
  `create_user_id` int(11) NOT NULL DEFAULT '0' COMMENT '创建者ID',
  `last_login_time` int(11) DEFAULT '0' COMMENT '最后一次登录时间',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `store_id` int(11) DEFAULT '0' COMMENT '所属门店',
  `identity` tinyint(4) NOT NULL DEFAULT '0' COMMENT '用户身份（1-超级管理员；2-店长；3-店员）',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `login_name` (`login_name`),
  UNIQUE KEY `user_name` (`user_name`),
  UNIQUE KEY `user_name_2` (`user_name`),
  UNIQUE KEY `login_name_2` (`login_name`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='系统用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` VALUES (1,'艾德敏','admin','21232f297a57a5a743894a0e4a801fc3','','','','',1,0,1477135478,0,1475924531,0,1),(10,'前台妮可','qiantai','362524','15951924092','','','',1,1,NULL,1475380431,1475380431,1,3),(11,'店长谢明亮','dianzhang1','e06f1e64ef4d6b6958ade918e1a20bec','13645184113','','','',1,1,1477017102,1475381432,1475381432,1,2),(14,'财务1','caiwu','e06f1e64ef4d6b6958ade918e1a20bec','13601468984','','','530627340@qq.com',1,11,NULL,1475393009,1475393009,1,1);
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_action_log`
--

DROP TABLE IF EXISTS `sys_user_action_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_action_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `log_info` longtext COMMENT '日志信息',
  `log_type` tinyint(4) NOT NULL COMMENT '日志类型（1-登录；2-查询；3-新增；4-修改；5-删除）',
  `user_ip` varchar(100) DEFAULT NULL COMMENT '用户IP',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建日期',
  `log_class` varchar(500) DEFAULT NULL COMMENT '日志的操作CLASS类名',
  PRIMARY KEY (`log_id`),
  UNIQUE KEY `log_id` (`log_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统操作日志表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_action_log`
--

LOCK TABLES `sys_user_action_log` WRITE;
/*!40000 ALTER TABLE `sys_user_action_log` DISABLE KEYS */;
INSERT INTO `sys_user_action_log` VALUES (1,0,'1',2,'11',0,NULL);
/*!40000 ALTER TABLE `sys_user_action_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_group`
--

DROP TABLE IF EXISTS `sys_user_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_group` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户组ID',
  `group_name` varchar(50) NOT NULL COMMENT '用户组名称',
  `group_info` varchar(500) DEFAULT NULL COMMENT '用户组描述',
  `create_user_id` int(11) NOT NULL COMMENT '创建者ID',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建日期',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
  `update_time` int(11) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`group_id`),
  UNIQUE KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_group`
--

LOCK TABLES `sys_user_group` WRITE;
/*!40000 ALTER TABLE `sys_user_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `sys_user_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_group_user`
--

DROP TABLE IF EXISTS `sys_user_group_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_group_user` (
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `group_id` int(11) NOT NULL COMMENT '用户组ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_group_user`
--

LOCK TABLES `sys_user_group_user` WRITE;
/*!40000 ALTER TABLE `sys_user_group_user` DISABLE KEYS */;
INSERT INTO `sys_user_group_user` VALUES (15,6);
/*!40000 ALTER TABLE `sys_user_group_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_region`
--

DROP TABLE IF EXISTS `sys_user_region`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_region` (
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `region_id` int(11) NOT NULL COMMENT '地区ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统用户与地区关联表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_region`
--

LOCK TABLES `sys_user_region` WRITE;
/*!40000 ALTER TABLE `sys_user_region` DISABLE KEYS */;
INSERT INTO `sys_user_region` VALUES (10,129),(10,130),(10,131),(10,132),(10,133),(10,134),(10,135),(10,136),(10,137),(10,138),(10,139),(10,140),(10,141),(10,142),(10,143),(10,144),(9,167),(9,168),(9,169),(9,170),(9,171),(9,172),(9,173),(9,174),(9,175),(9,176),(9,177),(9,178),(9,179),(9,180),(9,181),(9,182),(9,183),(9,184),(9,185),(9,186),(9,187),(11,188),(11,189),(11,190),(11,191),(11,192),(11,193),(11,194),(11,195),(11,196),(11,197),(2,287),(2,288),(2,289),(2,290),(2,291),(2,292),(2,293),(2,294),(2,295),(2,296),(2,297),(2,298),(2,299),(12,289),(12,291),(13,287),(13,293),(14,288),(15,289);
/*!40000 ALTER TABLE `sys_user_region` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_role`
--

DROP TABLE IF EXISTS `sys_user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_role` (
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户id',
  `role_id` int(11) NOT NULL DEFAULT '0' COMMENT '角色id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_role`
--

LOCK TABLES `sys_user_role` WRITE;
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
INSERT INTO `sys_user_role` VALUES (10,2),(11,1),(14,3);
/*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'salon'
--
/*!50003 DROP FUNCTION IF EXISTS `getChildUserById` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = '' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `getChildUserById`(rootId VARCHAR(100)) RETURNS varchar(1000) CHARSET utf8
    COMMENT '递归查询所有子用户'
BEGIN

    DECLARE sTemp VARCHAR(1000);

    DECLARE sTempChd VARCHAR(1000);

    SET sTemp = '$';

    SET sTempChd =cast(rootId as CHAR);

      WHILE sTempChd is not null DO

        SET sTemp = concat(sTemp,',',sTempChd);

        SELECT group_concat(user_id) INTO sTempChd FROM sys_user where FIND_IN_SET(create_user_id,sTempChd)>0;

      END WHILE;

    RETURN sTemp;

  END */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 DROP FUNCTION IF EXISTS `getParentsMenuIdByMenuId` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = '' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `getParentsMenuIdByMenuId`(rootId VARCHAR(5000)) RETURNS varchar(5000) CHARSET utf8
    COMMENT '向上递归查询所有父菜单节点'
BEGIN

    DECLARE sTemp VARCHAR(5000);

    DECLARE sTempChd VARCHAR(5000);

    SET sTemp = '$';

    SET sTempChd =cast(rootId as CHAR);

      WHILE sTempChd is not null DO

        SET sTemp = concat(sTemp,',',sTempChd);

        SELECT group_concat(parent_menu_id) INTO sTempChd FROM sys_menu where FIND_IN_SET(menu_id,sTempChd)>0;

      END WHILE;

    RETURN sTemp;

  END */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!50003 DROP FUNCTION IF EXISTS `getParentsRegionIdByRegionId` */;
/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
/*!50003 SET @saved_col_connection = @@collation_connection */ ;
/*!50003 SET character_set_client  = utf8 */ ;
/*!50003 SET character_set_results = utf8 */ ;
/*!50003 SET collation_connection  = utf8_general_ci */ ;
/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
/*!50003 SET sql_mode              = '' */ ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50020 DEFINER=`root`@`localhost`*/ /*!50003 FUNCTION `getParentsRegionIdByRegionId`(rootId VARCHAR(100)) RETURNS varchar(1000) CHARSET utf8
    COMMENT '向上递归查询地区'
BEGIN

    DECLARE sTemp VARCHAR(1000);

    DECLARE sTempChd VARCHAR(1000);

    SET sTemp = '$';

    SET sTempChd =cast(rootId as CHAR);

      WHILE sTempChd is not null DO

        SET sTemp = concat(sTemp,',',sTempChd);

        SELECT group_concat(parent_region_id) INTO sTempChd FROM sys_region where FIND_IN_SET(region_id,sTempChd)>0;

      END WHILE;

    RETURN sTemp;

  END */;;
DELIMITER ;
/*!50003 SET sql_mode              = @saved_sql_mode */ ;
/*!50003 SET character_set_client  = @saved_cs_client */ ;
/*!50003 SET character_set_results = @saved_cs_results */ ;
/*!50003 SET collation_connection  = @saved_col_connection */ ;
/*!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-12-11  0:17:38