MySQL - photo comments, votes, keywords, ++, in single table?
===

I would like to move my photo management system from XML to MySQL and extend functionality of my current system.

Basically, I have few things in MySQL and few in xml files. The situation right now looks like this:<br />

 - "**news.xml**" - single file: <br /> there are stored all news on my site (new uploads, votes and coments) and the structure of xml is:<br />
&nbsp;
`<all_news>`<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`<photos>`<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`<image image_name="photo1.jpg" path="my_photos/" date="12.12.12" info="just Uploaded!" />`<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`</photos>`<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`<comments>`<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`<image image_name="photo1.jpg" path="my_photos/" date="12.12.12" info="just Commented!" />`<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`</comments>`<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`<votes>`<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`<image image_name="photo1.jpg" path="my_photos/" date="12.12.12" info="just Voted!" />`<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;`</votes>`<br />
`</all_news>`

 -  "**photo1.xml**", "**photo2.xml**", "**photo3.xml**" ... - multiple files: <br />These files are created dynamically if someone leaves comment on my photo. For example if someone comment my photo, php script automatically create "**photo_name.xml**" file in format:<br />`<comments><comment sender='John' text='nice photo!' who='user' date='22.12.12' /></comments>
`

 - "**Votes**" - MySQL table: <br /> there are stored all votes, and the structure of the table:<br />`id: "photo1.jpg"`<br />`vote: 5`<br />`uid: "IP voting person"`


Now I would like to merge all these things into a single mySQL database table, so each time when photo is loaded - pull these photo informations from single DB table (instead of loading few xml's and DB in same time)... 

So my question is:<br />What table structure is the best in this situation for easiest working on (pull data, move, delete, edit, add, sort...)? <br />Should I keep all things for single file in single row using **unique id = "photo.jpg"** and multidimensional arrays? Eg:

    uid:            photo_name.jpg
    path:           my_photos/
    isNewPhoto:     array[true, array[info:"just uploaded!"][date:"12.12.12"]] (multi-dimensional array ??)
    isNewComment:   array[true, array[info:"just commented!"][date:"12.12.12"]] (multi-dimensional array ??)
    isNewVote:      array[true, array[info:"just Voted!"][date:"12.12.12"]] (multi-dimensional array ??)
    votes:          1,5,3,2
    votesIP:        123123123,123123123,123123123
    comments:       array[array[sender][comment][date][who]]] (multi-dimensional array ??)

Thanks for any help!

Regards, Artur.