/*
Navicat MySQL Data Transfer

Source Server         : 本地数据库
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : kshzj

Target Server Type    : MYSQL
Target Server Version : 50553
File Encoding         : 65001

Date: 2019-08-29 09:24:26
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin_account
-- ----------------------------
DROP TABLE IF EXISTS `admin_account`;
CREATE TABLE `admin_account` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(32) NOT NULL DEFAULT '',
  `real_name` varchar(64) NOT NULL DEFAULT '',
  `password` varchar(32) NOT NULL DEFAULT '',
  `status` tinyint(4) unsigned NOT NULL DEFAULT '1',
  `power_id` varchar(256) NOT NULL DEFAULT '' COMMENT '权限id,多个用逗号隔开',
  `power_bicycle_place_id` varchar(256) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_account
-- ----------------------------
INSERT INTO `admin_account` VALUES ('1', 'admin', '总管理员', '7d5a7daaadaab130d8a781be5aad0839', '1', '1', '');

-- ----------------------------
-- Table structure for admin_power
-- ----------------------------
DROP TABLE IF EXISTS `admin_power`;
CREATE TABLE `admin_power` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `power_name` varchar(255) NOT NULL DEFAULT '',
  `action_content` text NOT NULL COMMENT '包含的控制器方法的json集合',
  `menu_id` text NOT NULL COMMENT '可以显示的菜单id 多个用逗号隔开',
  `p_menu_id` varchar(256) DEFAULT '' COMMENT '手机后台可以显示的菜单ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_power
-- ----------------------------
INSERT INTO `admin_power` VALUES ('1', '总管理权限', '', '1,2,201,202,203,3,301,302,304,305,4,401,5,501,502,6,7,701,8,801,802,803,9', '1,2');

-- ----------------------------
-- Table structure for wx_users
-- ----------------------------
DROP TABLE IF EXISTS `wx_users`;
CREATE TABLE `wx_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `openid` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户openid',
  `nickname` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户昵称',
  `sex` tinyint(4) DEFAULT '0' COMMENT '性别',
  `headimgurl` text COLLATE utf8mb4_unicode_ci COMMENT '头像',
  `city` char(25) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '城市',
  `province` char(25) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '省份',
  `country` char(25) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '国家',
  `score` int(11) DEFAULT '0' COMMENT '积分',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `token` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'token',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of wx_users
-- ----------------------------
INSERT INTO `wx_users` VALUES ('1', '1', 'cody', '1', 'https://kshzj.oss-cn-hangzhou.aliyuncs.com/gonggao/201907/test/ym-gonggao201907test6115645648909351.png?x-oss-process=style/default', '苏州', '江苏', '', '10', '2019-07-31 10:02:01', null, '');