<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><script type="text/javascript">
</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
)
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"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>