ZenphotoCMS Forum
SQL database table names and table fields? - Printable Version

+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: SQL database table names and table fields? (/thread-7441.html)

SQL database table names and table fields? - Jole - 2010-08-07

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"



SQL database table names and table fields? - acrylian - 2010-08-07

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.



SQL database table names and table fields? - sbillard - 2010-08-07

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