Page MenuHomePhabricator

Setup proper daily harvesting of the "image" table in the monuments database
Open, LowPublic

Description

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

Details

Reference
bz53814