Set image title to albumname

[grrrrr]

Is there an easy way to set the "image title" attribute in my database to the "albumname"?
either by hand, everytime i add new picturesvia an sql-script, or automatically for now and ever?

[grrrrr]

by hand:

Code Select Expand


UPDATE coppermine_pictures cp
JOIN coppermine_albums ca ON ( cp.aid = ca.aid )

SET cp.title = ca.title