Last modified: 2014-02-28 16:21:16 UTC
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.