text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : link
  Source Server Version : 50553
  Source Host           : localhost:3306
  Source Database       : tp5
  
  Target Server Type    : MYSQL
  Target Server Version : 50553
  File Encoding         : 65001
  
  Date: 2017-11-18 17:51:46
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for `admin`
  -- ----------------------------
  DROP TABLE IF EXISTS `admin`;
  CREATE TABLE `admin` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(20) NOT NULL DEFAULT '',
    `password` char(32) NOT NULL DEFAULT '',
    `salt` char(6) NOT NULL DEFAULT '',
    `login_num` int(11) NOT NULL DEFAULT '0',
    `login_time` int(11) NOT NULL DEFAULT '0',
    `login_ip` varchar(20) NOT NULL DEFAULT '',
    `create_time` int(11) NOT NULL DEFAULT '0',
    `update_time` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of admin
  -- ----------------------------
  INSERT INTO `admin` VALUES ('1', 'admin', '63d17cf3505375a85d9da7e64a94ef2f', 'h85mj2', '4', '1510997180', '127.0.0.1', '1510984477', '0');
  
  -- ----------------------------
  -- Table structure for `news_cate`
  -- ----------------------------
  DROP TABLE IF EXISTS `news_cate`;
  CREATE TABLE `news_cate` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(60) NOT NULL DEFAULT '',
    `sort` int(11) NOT NULL DEFAULT '0',
    `pid` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of news_cate
  -- ----------------------------
  INSERT INTO `news_cate` VALUES ('1', '分类111', '0', '0');
  INSERT INTO `news_cate` VALUES ('2', '分类233', '0', '0');
  INSERT INTO `news_cate` VALUES ('3', '分类666', '0', '0');
  
  -- ----------------------------
  -- Table structure for `user`
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(20) NOT NULL,
    `password` char(32) NOT NULL,
    `salt` char(6) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of user
  -- ----------------------------
  INSERT INTO `user` VALUES ('1', 'renjie', '9dffd97e39d93f836f8b5a5fb9576c30', 'yhegIu');
  