/
example_db.sql
44 lines (37 loc) · 1.32 KB
/
example_db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
/*CREATE DATABASE `crawldb`*/
CREATE TABLE `tblDomains` (
`iDomainID` int(11) NOT NULL AUTO_INCREMENT,
`strDomain` varchar(128) DEFAULT NULL,
`dtLastAccessed` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`iDomainID`),
UNIQUE KEY `strDomain_UNIQUE` (`strDomain`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `tblLinks` (
`iLinkID` int(11) NOT NULL AUTO_INCREMENT,
`fkParentID` int(11) NOT NULL,
`fkQueryID` int(11) NOT NULL,
`fkChildID` int(11) NOT NULL,
`iNumberTimes` int(11) NOT NULL,
`iLevel` int(11) NOT NULL,
`bolExclude` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`iLinkID`),
KEY `fkParentID` (`fkParentID`),
KEY `fkChildID` (`fkChildID`),
KEY `Joint` (`fkParentID`,`fkChildID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
CREATE TABLE `tblPages` (
`iPageID` int(11) NOT NULL AUTO_INCREMENT,
`strURL` varchar(255) NOT NULL,
`strDomain` varchar(255) DEFAULT NULL,
`strCleanURL` varchar(255) DEFAULT NULL,
`iLevel` int(11) NOT NULL,
`fkDomainID` int(11) NOT NULL,
`fkQueryID` int(11) DEFAULT NULL,
`strHTML` longtext,
`strHeader` text,
`dtDays` int(11) DEFAULT NULL,
`bolProcessed` tinyint(1) NOT NULL DEFAULT '0',
`bolHarvested` tinyint(1) NOT NULL DEFAULT '0',
`bolExclude` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`iPageID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8