Anyone know about the SQL database code for coppermine storage of photos?

In my "public_html/modules/coppermine/albums/" folder I have:

031114charity
03DinnerAtOutsider
03afs
040128cny
041005_SocialNight_CandyCam
041005socialnight
041111asianfoodfair
041111asianfoodfair2
041126gamesnight
04_LeonDinner
050208_CNYB_CandyCam
050208_CNYB_PeggyCam
050421_PInThePark_LucasCam
051015_AFF_LucasCam
051015_AFF_SimonCam
051015_AFF_WinnieCam
userpics

It's a bit messy. At first I started with the

(YYMMDD)(name) naming convention.

Now I prefer if all folders followed:

(YYMMDD)_(acronym for event)_(name of person's camera photos)

I guess I cannot change the folder names directly. I must also change the folder path names in the database aswell. Can someone direct me to the right coppermine tables? Even better is a SQL script of commands to change them all at once - with no mistakes... otherwise the gallery will fail.

Can an admin/mod change the topic of this thread to:

"changing folder path names"


as it's better than coppermine SQL database

The table you want to change is cms_cpg_pictures. This is the table that contains all of the individual picture information. If you browse that table, you will find a filepath column that contains the path to the picture, minus the filename. You will want to update those columns with a query for each album, like this:

PHP:

update cms_cpg_pictures set filepath = 'modules/coppermine/albums/new_album_name_goes_here/' where filepath = 'modules/coppermine/albums/old_album_name_goes_here/'

Of course, back your database up first. I would suggest running the query on one album first to test it. After the qurey, rename the folder in modules/coppermine/albums to your new_album_name_goes_here value.