网站信息采集系统数据库结构设计及sql代码

<script type="text/javascript"><!--google_ad_client = "pub-1654710028568330";/* 728x15, 创建于 08-5-19 */google_ad_slot = "1395130186";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script><script type="text/javascript"><!--google_ad_client = "pub-1654710028568330";/* 728x90, 创建于 08-5-19 */google_ad_slot = "5790075209";google_ad_width = 728;google_ad_height = 90;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>

先做一个简易版的吧 唉 there is no time！

 

 

create database caiji2;



create table task
(
Mid char(10) primary key,
Mane varchar(30),
Mweb varchar(150),
Mnote text,
language char(10),
taskType char(2)
)

create table urlRule
(
ruleID char(10) primary key,
listDepth char(2) ,
varStart char(2),
sourceUrl varchar(200),
articleUrlNeed varchar(200),
articleUrlForbid varchar(200),
articleUrlAreaBegin varchar(200),
articleUrlAreaEnd varchar(200),
moreArticleUrl text,
tag1Begin varchar(200),
tag1End varchar(200),
tag2Begin varchar(200),
tag2End varchar(200),
tag3Begin varchar(200),
tag3End varchar(200),
Foreign key(ruleID) references task(Mid)
)

create table urls
(
urlID char(10) primary key,
url varchar(150),
mid char(10),
isdown char(2) not null default '0',
foreign key(mid) references task(Mid)
)

create table content1
(
cid char(10) primary key ,
mid char(10) ,
ispost char(2),
pageUrl varchar(200),
title varchar(100),
author char(8),
content text,
date datetime,
foreign key(mid) references task(Mid)
)

create table content2
(
cid char(10) primary key,
mid char(10),
date datetime,
foreign key(mid) references task(Mid),
email text
)

 

 

<script type="text/javascript"><!--google_ad_client = "pub-1654710028568330";/* 728x90, 创建于 08-5-19 */google_ad_slot = "5790075209";google_ad_width = 728;google_ad_height = 90;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script><script type="text/javascript"><!--google_ad_client = "pub-1654710028568330";/* 728x15, 创建于 08-5-19 */google_ad_slot = "1395130186";google_ad_width = 728;google_ad_height = 15;//--></script><script type="text/javascript"src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>