Hacked up some harvesting a time ago:
mysql> SELECT COUNT(*) FROM image;
+----------+
COUNT(*) |
+----------+
1263653 |
+----------+
1 row in set (0.00 sec)
CREATE TABLE image (
`country` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `id` varchar(25) NOT NULL DEFAULT '0', `img_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`country`,`id`,`img_name`), KEY `country_id` (`country`,`id`), KEY `img_name` (`img_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
Should set up daily harvesting so this can be used by other tools.
Version: unspecified
Severity: normal