User Tools

Site Tools


podoc:database_schemas

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:database_schemas [2007/10/19 15:01] Luudpodoc:database_schemas [2007/10/19 20:50] (current) Luud
Line 11: Line 11:
 === To Do === === 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.   * 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.   * 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 === === 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. <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.
 +
 +
  
 ===== Tables ===== ===== Tables =====
Line 54: Line 56:
   * <del>[[dcraw_options sql table|dcraw_options]]</del> removed in 2.34   * <del>[[dcraw_options sql table|dcraw_options]]</del> removed in 2.34
   * [[ev_comp sql table|ev_comp]]   * [[ev_comp sql table|ev_comp]]
 +  * [[files sql table|files]]
   * [[film sql table|film]]   * [[film sql table|film]]
   * [[film_format sql table|film_format]]   * [[film_format sql table|film_format]]
Line 103: Line 106:
   * [[support_type sql table|support_type]]   * [[support_type sql table|support_type]]
   * <del>[[system_preferences sql table|system_preferences]]</del> removed in 2.34   * <del>[[system_preferences sql table|system_preferences]]</del> removed in 2.34
 +  * [[user_preferences sql table|user_preferences]]
   * [[user_type sql table|user_type]]   * [[user_type sql table|user_type]]
   * [[users sql table|users]]   * [[users sql table|users]]
   * [[version sql table|version]]   * [[version sql table|version]]
 <del>Strike-through Text</del> <del>Strike-through Text</del>
 +
  
 ===== Views ===== ===== Views =====
Line 129: Line 134:
   * [[view_scanner sql view|view_scanner]]   * [[view_scanner sql view|view_scanner]]
   * [[view_scanner_type sql view|view_scanner_type]]   * [[view_scanner_type sql view|view_scanner_type]]
 +  * <del>[[view_shop_item_generator_rule sql view|view_shop_item_generator_rule]]</del> removed in 2.34
   * <del>[[view_submission sql view|view_submission]]</del> removed in 2.34   * <del>[[view_submission sql view|view_submission]]</del> removed in 2.34
   * [[view_support sql view|view_support]]   * [[view_support sql view|view_support]]
   * [[view_support_type sql view|view_support_type]]   * [[view_support_type sql view|view_support_type]]
   * [[view_users_subscribed_to sql view|view_users_subscribed_to]]   * [[view_users_subscribed_to sql view|view_users_subscribed_to]]
 +
 +
  
  
Line 158: Line 166:
   * [[folder_and_subfolders sql function|folder_and_subfolders]]   * [[folder_and_subfolders sql function|folder_and_subfolders]]
   * [[get_image_path sql function|get_image_path]]   * [[get_image_path sql function|get_image_path]]
-  * [[ sql function|]] +  * [[get_user_pref sql function|get_user_pref]]
-  * [[ sql function|]] +
-  * [[ sql function|]] +
-  * [[ sql function|]] +
-  * [[ sql function|]] +
-  * [[ sql function|]] +
-  * [[ sql function|]] +
-  * [[ sql function|]]+
   * [[number_of_camera_references sql function|number_of_camera_references]]   * [[number_of_camera_references sql function|number_of_camera_references]]
   * [[number_of_dupes sql function|number_of_dupes]]   * [[number_of_dupes sql function|number_of_dupes]]
Line 179: Line 180:
   * [[tokenized_ilike sql function|tokenized_ilike]]   * [[tokenized_ilike sql function|tokenized_ilike]]
   * [[tokenized_like sql function|tokenized_like]]   * [[tokenized_like sql function|tokenized_like]]
 +
 +
 +
 +
 +
 +
  
 ===== Sequences ===== ===== Sequences =====
Line 198: Line 205:
   * [[country_id_sequence sql sequence|country_id_sequence]]   * [[country_id_sequence sql sequence|country_id_sequence]]
   * <del>[[currency_id_sequence sql sequence|currency_id_sequence]]</del> removed in 2.34   * <del>[[currency_id_sequence sql sequence|currency_id_sequence]]</del> removed in 2.34
 +  * <del>[[dcraw_options_id_sequence sql sequence|dcraw_options_id_sequence]]</del> removed in 2.34
   * [[ev_comp_id_sequence sql sequence|ev_comp_id_sequence]]   * [[ev_comp_id_sequence sql sequence|ev_comp_id_sequence]]
   * <del>[[export_id_sequence sql sequence|export_id_sequence]]</del> removed in 2.31   * <del>[[export_id_sequence sql sequence|export_id_sequence]]</del> removed in 2.31
Line 212: Line 220:
   * [[files_id_sequence sql sequence|files_id_Sequence]]   * [[files_id_sequence sql sequence|files_id_Sequence]]
   * [[folder_id_sequence sql sequence|folder_id_sequence]]   * [[folder_id_sequence sql sequence|folder_id_sequence]]
 +  * <del>[[imagemagick_composite_options_id_sequence sql sequence|imagemagick_composite_options_id_sequence]]</del> 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]]   * [[label_id_sequence sql sequence|label_id_sequence]]
   * [[lens_id_sequence sql sequence|lens_id_sequence]]   * [[lens_id_sequence sql sequence|lens_id_sequence]]
Line 235: Line 245:
   * [[scanner_id_sequence sql sequence|scanner_id_sequence]]   * [[scanner_id_sequence sql sequence|scanner_id_sequence]]
   * [[scanner_type_id_sequence sql sequence|scanner_type_id_sequence]]   * [[scanner_type_id_sequence sql sequence|scanner_type_id_sequence]]
 +  * <del>[[shop_category_id_sequence sql sequence|shop_category_id_sequence]]</del> removed in 2.34
   * <del>[[shop_item_generator_rule_id_sequence sql sequence|shop_item_generator_rule_id_sequence]]</del> removed in 2.34   * <del>[[shop_item_generator_rule_id_sequence sql sequence|shop_item_generator_rule_id_sequence]]</del> removed in 2.34
   * <del>[[shop_order_id_sequence sql sequence|shop_order_id_sequence]]</del> removed in 2.34   * <del>[[shop_order_id_sequence sql sequence|shop_order_id_sequence]]</del> removed in 2.34
Line 247: Line 258:
   * [[user_type_id_sequence sql sequence|user_type_id_sequence]]   * [[user_type_id_sequence sql sequence|user_type_id_sequence]]
   * [[users_id_sequence sql sequence|users_id_sequence]]   * [[users_id_sequence sql sequence|users_id_sequence]]
 +
 +
 +
 +
  
  
Line 252: Line 267:
  
   * [[album_content_album_idx sql index|album_content_album_idx]]   * [[album_content_album_idx sql index|album_content_album_idx]]
-  * [[album_content_id_idx sql index|album_content_id_idx]]+  * <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_content_photo_idx sql index|album_content_photo_idx]]
-  * [[album_id_idx sql index|album_id_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]]   * [[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_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_idx sql index|camera_type_idx]]
   * [[camera_type_manufacturer_idx sql index|camera_type_manufacturer_idx]]   * [[camera_type_manufacturer_idx sql index|camera_type_manufacturer_idx]]
Line 262: Line 280:
   * [[client_id_idx sql index|client_id_idx]]   * [[client_id_idx sql index|client_id_idx]]
   * [[contact_info_idx sql index|contact_info_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_idx sql index|film_type_idx]]
   * [[film_type_manufacturer_idx sql index|film_type_manufacturer_idx]]   * [[film_type_manufacturer_idx sql index|film_type_manufacturer_idx]]
Line 271: Line 290:
   * [[flash_type_manufacturer_idx sql index|flash_type_manufacturer_idx]]   * [[flash_type_manufacturer_idx sql index|flash_type_manufacturer_idx]]
   * [[flash_users_idx sql index|flash_users_idx]]   * [[flash_users_idx sql index|flash_users_idx]]
-  * [[folder_id_idx sql index|folder_id_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]]   * [[folder_users_idx sql index|folder_users_idx]]
   * [[label_idx sql index|label_idx]]   * [[label_idx sql index|label_idx]]
Line 279: Line 300:
   * [[paper_idx sql index|paper_idx]]   * [[paper_idx sql index|paper_idx]]
   * [[photo_dupe_key sql index|photo_dupe_key]]   * [[photo_dupe_key sql index|photo_dupe_key]]
-  * [[photo_id_idx sql index|photo_id_idx]]+  * [[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]]   * [[photo_keywords_photo sql index|photo_keywords_photo]]
   * [[photo_location_idx sql index|photo_location_idx]]   * [[photo_location_idx sql index|photo_location_idx]]
Line 286: Line 309:
   * [[photo_users_idx sql index|photo_users_idx]]   * [[photo_users_idx sql index|photo_users_idx]]
   * [[photo_version_photo_idx sql index|photo_version_photo_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_client_idx sql index|client_client_idx sql index]]
   * [[client_users_idx sql index|client_users_idx]]   * [[client_users_idx sql index|client_users_idx]]
Line 291: Line 315:
   * [[rating_photo_idx sql index|rating_photo_idx]]   * [[rating_photo_idx sql index|rating_photo_idx]]
   * [[rating_users_idx sql index|rating_users_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_idx sql index|scanner_type_idx]]
   * [[scanner_type_manufacturer_idx sql index|scanner_type_manufacturer_idx]]   * [[scanner_type_manufacturer_idx sql index|scanner_type_manufacturer_idx]]
Line 297: Line 322:
   * [[support_type_manufacturer_idx sql index|support_type_manufacturer_idx]]   * [[support_type_manufacturer_idx sql index|support_type_manufacturer_idx]]
   * [[support_users_idx sql index|support_users_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]]
podoc/database_schemas.1192806072.txt.gz · Last modified: 2007/10/19 15:01 by Luud