mysql新闻数据库

Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50624
Source Host : localhost:3306
Source Database : news

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

Date: 2016-08-07 11:11:18
*/

SET FOREIGN_KEY_CHECKS=0;

---

– Table structure for comments

---

DROP TABLE IF EXISTS comments;
CREATE TABLE comments (
CID int(11) DEFAULT NULL,
CNID int(11) DEFAULT NULL,
CCONTENT varchar(255) DEFAULT NULL,
CDATE timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
CIP varchar(100) DEFAULT NULL,
CAUTHOR varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of comments

---

INSERT INTO comments VALUES (‘4’, ‘73’, ‘无聊！！’, ‘2010-08-10 13:43:53’, ‘127.0.0.1’, ‘这家伙很懒什么也没留下’);
INSERT INTO comments VALUES (‘5’, ‘108’, ‘很饱啊’, ‘2010-08-10 15:49:52’, ‘127.0.0.1’, ‘那只虫子’);
INSERT INTO comments VALUES (‘11’, ‘82’, ‘评论一下 我是admin’, ‘2009-11-23 03:57:58’, ‘127.0.0.1’, ‘admin’);
INSERT INTO comments VALUES (‘13’, ‘81’, ‘低碳生活’, ‘2010-03-30 03:00:55’, ‘10.0.0.35’, ‘这家伙很懒什么也没留下’);
INSERT INTO comments VALUES (‘14’, ‘86’, ‘隔岸观火吃鸡腿~！’, ‘2010-09-30 01:55:38’, ‘127.0.0.1’, ‘admin’);
INSERT INTO comments VALUES (‘15’, ‘73’, ‘无聊！！’, ‘2010-10-08 13:43:53’, ‘127.0.0.1’, ‘这家伙很懒什么也没留下’);
INSERT INTO comments VALUES (‘16’, ‘108’, ‘很饱啊’, ‘2010-08-10 15:49:52’, ‘127.0.0.1’, ‘那只虫子’);
INSERT INTO comments VALUES (‘17’, ‘108’, ‘我郁闷啊！！’, ‘2010-10-13 14:24:02’, ‘127.0.0.1’, ‘那只蛇’);
INSERT INTO comments VALUES (‘19’, ‘108’, ‘别回来了，都吃完了’, ‘2010-10-13 14:35:42’, ‘127.0.0.1’, ‘妈妈’);
INSERT INTO comments VALUES (‘21’, ‘108’, ‘虫子，你妈妈叫你回家吃饭’, ‘2010-10-13 14:26:58’, ‘127.0.0.1’, ‘打酱油的’);
INSERT INTO comments VALUES (‘23’, ‘165’, ‘abc’, ‘2013-05-30 15:11:35’, ‘127.0.0.1’, ‘这家伙很懒什么也没留下’);
INSERT INTO comments VALUES (‘32’, ‘170’, ‘好惨呀！’, ‘20