redesign comma separated photo_id_list
@feanor12
Submitted by Michael Pusterhofer Link to original bug (#783213)
Description
I think the TagTable should be redesigned as queries are more complex and the performance may also increase when avoiding comma separated lists of ids. Instead use a second table which links the tags with the photo_id.
TagTable id|name|time_created
TagPhotoRelationTable tag_id|photo_id
Here are some reasons why lists should be avoided: http://www.schemamania.org/sql/#lists
Version: 0.26.x