Difference between revisions of "Summerschool Aachen 2005/Challenges/verBOTen"

From C4 Wiki
Jump to: navigation, search
m (Reverted edits by 85.214.126.154 (Talk); changed back to last version by 134.130.240.196)
 
Line 1: Line 1:
bocrollico
 
 
verBOTen is a dictionary of robots.txt contents. We use a simple database structure:
 
verBOTen is a dictionary of robots.txt contents. We use a simple database structure:
 
   
 
   

Latest revision as of 10:34, 21 October 2007

verBOTen is a dictionary of robots.txt contents. We use a simple database structure:

CREATE TABLE `archive_hosts` (
 `id` int(11) NOT NULL auto_increment,
 `host` varchar(255) default NULL,
 `ip` bigint(11) unsigned default NULL,
 `port` int(5) unsigned default '80',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `host` (`host`,`port`)
);
CREATE TABLE `archive_robots_disallows` (
 `id` int(11) NOT NULL auto_increment,
 `archive_host_id` int(11) default NULL,
 `path` text,
 PRIMARY KEY  (`id`)
);