On 10/02/12 11:54, Raul Kern wrote: > Hallo, > > would like to add two new fileds to monuments_all table > (http://commons.wikimedia.org/wiki/Commons:Wiki_Loves_Monuments_2011/Monuments_database): > > > 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 '_'.
Whay about calling it monument article? I'm concerned about confusing its meaning with the article holding the list (source field) > registrant_url would contain registrant url of the monument, like > http://www.culture.gouv.fr/public/mistral/merimee_fr?ACTION=CHERCHER&FIELD_1=REF&VALUE_1=PA00088517, > http://register.muinas.ee/?menuID=monument&action=view&id=20875, etc Adding it to the local table, sure. I'm not so convinced about monuments_all. Also note that in some cases there may be several entities able to give 'monument status', and listing the same monument. _______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu
