text: /*
   Navicat Premium Data Transfer
  
   Source Server         : Localhost
   Source Server Type    : MySQL
   Source Server Version : 50717
   Source Host           : localhost
   Source Database       : cAuth
  
   Target Server Type    : MySQL
   Target Server Version : 50717
   File Encoding         : utf-8
  
   Date: 08/10/2017 22:22:52 PM
  */
  
  SET NAMES utf8;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  --  Table structure for `cSessionInfo`
  -- ----------------------------
  DROP TABLE IF EXISTS `cSessionInfo`;
  CREATE TABLE `cSessionInfo` (
    `open_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `uuid` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `skey` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_visit_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `session_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_info` varchar(2048) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`open_id`),
    KEY `openid` (`open_id`) USING BTREE,
    KEY `skey` (`skey`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='会话管理用户信息';
  
  DROP TABLE IF EXISTS `addInfo`;
  DROP TABLE IF EXISTS `mapInfo`;
  CREATE TABLE `mapInfo` (
    `nickName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `accuracy` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `altitude` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `dateTime` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `errMsg` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `horizontalAccuracy` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `latitude` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `longitude` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `speed` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `verticalAccuracy` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`nickName`),
    KEY `openid` (`nickName`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户地址信息';
  SET FOREIGN_KEY_CHECKS = 1;
  
  DROP TABLE IF EXISTS `todoInfo`;
  CREATE TABLE `todoInfo` (
    `id` int NOT NULL AUTO_INCREMENT,
    `nickName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `todoName` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `updateTime` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `finishFlag` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    KEY `openid` (`id`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='待办列表信息';
  SET FOREIGN_KEY_CHECKS = 1;