/*
Navicat MySQL Data Transfer

Source Server         : mysql5.7
Source Server Version : 50703
Source Host           : localhost:3306
Source Database       : news

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

Date: 2019-12-29 23:03:00
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `news`
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `content_url` varchar(255) DEFAULT NULL,
  `pic_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES ('1', '“胖五”归来！', '长征五号运载火箭成功发射实践二十号卫星', '2019-12-27 21:45:14', 'http://www.xinhuanet.com/politics/2019-12/27/c_1125397145.htm', 'https://ae01.alicdn.com/kf/U10b7214ce3ed44e68fb2564a07925ffbl.jpg');
INSERT INTO `news` VALUES ('2', '年度报告', '2019年，全球变暖正悄悄改变地球的模样', '2019-12-28 07:42:59', 'http://www.xinhuanet.com/tech/2019-12/28/c_1125397434.htm', 'https://ae01.alicdn.com/kf/U0b041ebb7fdd4b1284be7dd9e1dd8505o.jpg');
INSERT INTO `news` VALUES ('3', '央视快评', '永远与人民同呼吸共命运心连心', '2019-12-29 12:06:20', 'https://m.guancha.cn/politics/2019_12_29_529869.shtml', 'https://ae01.alicdn.com/kf/Uc1e513347a944f2fb53d3003a50085112.jpg');
INSERT INTO `news` VALUES ('4', '“嗷嗷暖”', '开往“中国北极”的“雪国列车”', '2019-12-28 17:44:21', 'http://www.xinhuanet.com/local/2019-12/28/c_1125399092.htm', 'https://ae01.alicdn.com/kf/Uf765893eb73e4c448e0d7e8d9baadaa6T.jpg');
INSERT INTO `news` VALUES ('5', '朋友圈', '一个内陆大省的开放朋友圈', '2019-12-29 12:51:03', 'http://www.xinhuanet.com/politics/2019-12/29/c_1125400775.htm', 'https://ae01.alicdn.com/kf/Uc6352346885d44adb9c2c7421b989e9ce.jpg');
