text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : 127.0.0.1
  Source Server Version : 50617
  Source Host           : localhost:3306
  Source Database       : ChildrenGardenLocate
  
  Target Server Type    : MYSQL
  Target Server Version : 50617
  File Encoding         : 65001
  
  Date: 2017-04-18 16:00:05
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for news_type
  -- ----------------------------
  DROP TABLE IF EXISTS `news_type`;
  CREATE TABLE `news_type` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `type` int(4) DEFAULT '1111' COMMENT '类型标识',
    `typename` varchar(255) DEFAULT NULL COMMENT '类型名称',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='新闻的类型';
  
  -- ----------------------------
  -- Records of news_type
  -- ----------------------------
  INSERT INTO `news_type` VALUES ('1', '1111', '社会新闻');
  INSERT INTO `news_type` VALUES ('2', '3654', '国际新闻');
  