(Great changes skipped) On 17/03/12 18:34, Maarten Dammers wrote: > I'm thinking about creating a table monument_templates with the fields: > lang, country and template. This would be a really small table based on > https://fisheye.toolserver.org/browse/erfgoed/erfgoedbot/monuments_config.py?hb=true > with (lang, country) as primary key. Good idea. But take into account that some of them contain several parameters (eg. they can point to several monument dbs).
> The second table would be monument_images with the fields: template, id, > image. This would be a much bigger table containing all the images > tagged with a tracker template. Not really sure what keys to set here > for performance. Any thoughts? I'd include all the data from the image. The keys should be based on the queries to perform. Something like template_id, upload_time perhaps. _______________________________________________ Wiki Loves Monuments mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.eu
