https://bugzilla.wikimedia.org/show_bug.cgi?id=53817
Web browser: ---
Bug ID: 53817
Summary: Setup proper daily harvesting of the "commonscat"
table in the monuments database
Product: Wiki Loves Monuments
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 53807
Classification: Unclassified
Mobile Platform: ---
Hacked up some harvesting a time ago:
mysql> SELECT COUNT(*) FROM commonscat;
+----------+
| COUNT(*) |
+----------+
| 12015 |
+----------+
1 row in set (0.00 sec)
CREATE TABLE `commonscat` (
`site`
enum('be-x-old','ca','da','de','en','es','et','fr','gl','lb','nl','no','pl','pt','ro','sv')
NOT NULL,
`title` varchar(255) NOT NULL DEFAULT '',
`commonscat` varchar(255) DEFAULT NULL,
`changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (`site`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
Should set up daily harvesting so this can be used by other tools.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
