SQL database table names and table fields?

Jole

I wish to edit some album informations from SQL database, from phpMyadmin in control panel.

What are the names of SQL tables and table fields for:

1. Table name and table field where Zenphoto keeps "Album Title:" information?
2. Table name and table field where Zenphoto keeps "Album Description:" information?
3. Table name and table field where Zenphoto keeps "Location:" (also for album) information?
4. Table name and table field where Zenphoto keeps "Custom data:" (also for album) information?
5. Table name and table field where Zenphoto keeps album name (real folder name on disk)?

----------------------------------------------------------------------------------
I believe I found it, please confirm?

1. Table name and table field where Zenphoto keeps "Album Title:" information?
Table: "zp_albums"
Field: "title"

2. Table name and table field where Zenphoto keeps "Album Description:" information?
Table: "zp_albums"
Field: "desc"

3. Table name and table field where Zenphoto keeps "Location:" (also for album) information?
Table: "zp_albums"
Field: "location"

4. Table name and table field where Zenphoto keeps "Custom data:" (also for album) information?
Table: "zp_albums"
Field: "custom_data"

5. Table name and table field where Zenphoto keeps album name (real folder name on disk)?
Table: "zp_albums"
Field: "folder"

acrylian

Yes, indeed, it's pretty straightforward named (there is also a database reference PDF included in the package's /doc_files folder btw).

Remember that the folder name includes the toplevel album names as well.

sbillard

BUT, the folder name is relative to the "albums" folder. So it is not the full disk path.