redesign comma separated photo_id_list
Submitted by Michael Pusterhofer
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.
Here are some reasons why lists should be avoided: http://www.schemamania.org/sql/#lists