Summerschool Aachen 2005/Challenges/verBOTen

From C4 Wiki
< Summerschool Aachen 2005‎ | Challenges
Revision as of 10:34, 21 October 2007 by Tobias (talk | contribs) (Reverted edits by 85.214.126.154 (Talk); changed back to last version by 134.130.240.196)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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`)
);