 -- phpMyAdmin SQL Dump
--- version 3.4.3.2
--- http://www.phpmyadmin.net
---
--- 主机: 127.0.0.1
--- 生成日期: 2017 年 04 月 25 日 09:53
--- 服务器版本: 5.5.15
--- PHP 版本: 5.3.8
-
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
+-- version 4.7.0
+-- https://www.phpmyadmin.net/
+--
+-- Host: localhost
+-- Generation Time: 2017-04-27 08:59:02
+-- 服务器版本： 5.7.18-log
+-- PHP Version: 5.6.30
+
+SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
+SET AUTOCOMMIT = 0;
+START TRANSACTION;
 SET time_zone = "+00:00";
 
 
 /*!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 */;
-
---
--- 数据库: `crm`
+/*!40101 SET NAMES utf8mb4 */;
+
+--
+-- Database: `crm`
 --
 
 -- --------------------------------------------------------

-- 表的结构 `menu`
--

CREATE TABLE IF NOT EXISTS `menu` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` char(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` char(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `power` tinyint(4) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='菜单' AUTO_INCREMENT=18 ;

--
-- 转存表中的数据 `menu`

-- 表的结构 `doctors`
--

CREATE TABLE `doctors` (
  `id` int(11) NOT NULL,
  `name` char(20) NOT NULL,
  `introduction` text COMMENT '介绍',
  `state` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='专家';

--
-- 转存表中的数据 `doctors`
