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 '_'. 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 Any suggestions on those fields? -- Raul _______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu
