podoc:database_schemas
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:database_schemas [2007/10/19 15:01] – Luud | podoc: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: | ||
< | < | ||
+ | |||
+ | |||
===== Tables ===== | ===== Tables ===== | ||
Line 54: | Line 56: | ||
* < | * < | ||
* [[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]] | ||
* < | * < | ||
+ | * [[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]] | ||
< | < | ||
+ | |||
===== 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]] | ||
+ | * < | ||
* < | * < | ||
* [[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|]] | + | |
- | * [[ 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]] | ||
* < | * < | ||
+ | * < | ||
* [[ev_comp_id_sequence sql sequence|ev_comp_id_sequence]] | * [[ev_comp_id_sequence sql sequence|ev_comp_id_sequence]] | ||
* < | * < | ||
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]] | ||
+ | * < | ||
+ | * < | ||
* [[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]] | ||
+ | * < | ||
* < | * < | ||
* < | * < | ||
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]]</ |
* [[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]]</ | ||
* [[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]]</ | ||
+ | * [[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]]</ | ||
* [[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]]</ |
+ | * [[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