Differences

This shows you the differences between two versions of the page.

--- podoc:database_schemas [2007/10/19 18:57] – Luud
+++ podoc:database_schemas [2007/10/19 20:50] (current) – Luud
@@ Line 11: / Line 11: @@
 === To Do ===
-  * Verify final schema with schema as reported by SQL dump of 2.33c.
+  * Verify final schema with schema as reported by SQL dump of 2.34.
+  * A few cross references between tables, views, sequences, indexes and functions may be missing.
   * Follow up on [[print_id_sequence sql sequence|print_id_sequence]] and [[export_id_sequence sql sequence|export_id_sequence]] as the documentation on these is probably wrong.
@@ Line 22: / Line 24: @@
   * Create a coherent picture of how photos are handled. Make a link between database and the physical reality.
-  * Update schema documentation for the upcoming 2.34 release.
 === Retrieving the current schema of your PO installation ===
@@ Line 34: / Line 34: @@
 <del>Another way to inspect your PO database is by using [[http://www.pgaccess.org/|pgAccess]].</del> -> Not available for current versions of PostgreSQL it seems.
@@ Line 55: / Line 56: @@
   * <del>[[dcraw_options sql table|dcraw_options]]</del> removed in 2.34
   * [[ev_comp sql table|ev_comp]]
+  * [[files sql table|files]]
   * [[film sql table|film]]
   * [[film_format sql table|film_format]]
@@ Line 178: / Line 180: @@
   * [[tokenized_ilike sql function|tokenized_ilike]]
   * [[tokenized_like sql function|tokenized_like]]
@@ Line 216: / Line 220: @@
   * [[files_id_sequence sql sequence|files_id_Sequence]]
   * [[folder_id_sequence sql sequence|folder_id_sequence]]
-  * <del>[[imagemagick_composite_options_id_sequence sql sequence|imagemagick_composite_options_id_sequence]] removed in 2.34
+  * <del>[[imagemagick_composite_options_id_sequence sql sequence|imagemagick_composite_options_id_sequence]]</del> removed in 2.34
-  * <del>[[imagemagick_options_id_sequence sequence|imagemagick_options_id_sequence]] removed in 2.34
+  * <del>[[imagemagick_options_id_sequence sql sequence|imagemagick_options_id_sequence]]</del> removed in 2.34
   * [[label_id_sequence sql sequence|label_id_sequence]]
   * [[lens_id_sequence sql sequence|lens_id_sequence]]
@@ Line 254: / Line 258: @@
   * [[user_type_id_sequence sql sequence|user_type_id_sequence]]
   * [[users_id_sequence sql sequence|users_id_sequence]]
@@ Line 263: / Line 269: @@
   * <del>[[album_content_id_idx sql index|album_content_id_idx]]</del> removed in 2.34
   * [[album_content_photo_idx sql index|album_content_photo_idx]]
+  * [[album_event_idx sql index|album_event_idx]]
   * <del>[[album_id_idx sql index|album_id_idx]]</del> removed in 2.34
   * [[album_users_idx sql index|album_users_idx]]
+  * [[calendar_client_idx sql index|calendar_client_idx]]
   * [[calendar_id_idx sql index|calendar_id_idx]]
+  * [[calendar_user_idx sql index|calendar_user_idx]]
   * [[camera_type_idx sql index|camera_type_idx]]
   * [[camera_type_manufacturer_idx sql index|camera_type_manufacturer_idx]]
@@ Line 271: / Line 280: @@
   * [[client_id_idx sql index|client_id_idx]]
   * [[contact_info_idx sql index|contact_info_idx]]
+  * [[files_version_idx sql index|files_version_idx]]
   * [[film_type_idx sql index|film_type_idx]]
   * [[film_type_manufacturer_idx sql index|film_type_manufacturer_idx]]
@@ Line 280: / Line 290: @@
   * [[flash_type_manufacturer_idx sql index|flash_type_manufacturer_idx]]
   * [[flash_users_idx sql index|flash_users_idx]]
+  * [[folder_event_idx sql index|folder_event_idx]]
   * <del>[[folder_id_idx sql index|folder_id_idx]]</del> removed in 2.34
+  * [[folder_parent_idx sql index|folder_parent_idx]]
   * [[folder_users_idx sql index|folder_users_idx]]
   * [[label_idx sql index|label_idx]]
@@ Line 288: / Line 300: @@
   * [[paper_idx sql index|paper_idx]]
   * [[photo_dupe_key sql index|photo_dupe_key]]
+  * [[photo_dupe_version_idx sql index|photo_dupe_version_idx]]
+  * [[photo_folder sql index|photo_folder]]
   * <del>[[photo_id_idx sql index|photo_id_idx]]</del> removed in 2.34
   * [[photo_keywords_photo sql index|photo_keywords_photo]]
@@ Line 295: / Line 309: @@
   * [[photo_users_idx sql index|photo_users_idx]]
   * [[photo_version_photo_idx sql index|photo_version_photo_idx]]
+  * [[photo_version_photo sql index|photo_version_photo]]
   * [[client_client_idx sql index|client_client_idx sql index]]
   * [[client_users_idx sql index|client_users_idx]]
@@ Line 300: / Line 315: @@
   * [[rating_photo_idx sql index|rating_photo_idx]]
   * [[rating_users_idx sql index|rating_users_idx]]
+  * [[rating_version_idx sql index|rating_version_idx]]
   * [[scanner_type_idx sql index|scanner_type_idx]]
   * [[scanner_type_manufacturer_idx sql index|scanner_type_manufacturer_idx]]
@@ Line 306: / Line 322: @@
   * [[support_type_manufacturer_idx sql index|support_type_manufacturer_idx]]
   * [[support_users_idx sql index|support_users_idx]]
-  * [[users_idx sql index|users_idx]]
+  * <del>[[users_idx sql index|users_idx]]</del> removed in 2.34
   * [[user_preferences_owner_idx sql index|user_preferences_owner_idx]]