mysql.sql

来自「网页采集系统 ================= 安装配置 -------」· SQL 代码 · 共 26 行

/*
MySQL Data Transfer
Source Host: localhost
Source Database: test
Target Host: localhost
Target Database: test
Date: 2009-2-5 10:39:29
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for lzzsearch
-- ----------------------------
CREATE TABLE `lzzsearch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(200) NOT NULL,
  `author` varchar(50) DEFAULT NULL,
  `title` varchar(200) NOT NULL,
  `datetimeCreate` varchar(30) DEFAULT NULL,
  `body` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------