Hallo,
would like to add two new fileds to monuments_all table
(
http://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments_2011/Monumen…):
article varchar(255) NOT NULL DEFAULT ''
and
registrant_url varchar(255) NOT NULL DEFAULT ''
article would contain wiki article title (in most cases the article
about the monument) extracted from the name field -- first wikilink in
the name field
article would be formatted same as page_title in
http://www.mediawiki.org/wiki/Manual:Page_table -- i.e. spaces
replaced with '_'.
registrant_url would contain registrant url of the monument, like
http://www.culture.gouv.fr/public/mistral/merimee_fr?ACTION=CHERCHER&FI…00088517,
http://register.muinas.ee/?menuID=monument&action=view&id=20875id=20875, etc
Any suggestions on those fields?
--
Raul