User Tools

Site Tools


podoc:view_photo_sql_view

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
podoc:view_photo_sql_view [2007/04/13 10:05] Luudpodoc:view_photo_sql_view [2007/04/20 16:17] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create view view_photo as create view view_photo as
   select photo.identifier, caption, users, date_of_exposure, photo_dupe.date_of_creation,   select photo.identifier, caption, users, date_of_exposure, photo_dupe.date_of_creation,
Line 23: Line 23:
    order by photo.identifier;    order by photo.identifier;
 </code> </code>
- 
  
 === Related tables === === Related tables ===
Line 31: Line 30:
   * [[photo_dupe sql table|photo_dupe]]   * [[photo_dupe sql table|photo_dupe]]
   * [[photo_version sql table|photo_version]]   * [[photo_version sql table|photo_version]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related sequences === 
  
 === History === === History ===
Line 52: Line 45:
 = Version 2.5 = = Version 2.5 =
  
-  create view view_photo as +<code sql> 
-    select photo.identifier, caption, users, date_of_exposure, date_of_creation, +create view view_photo as 
-           storage_location, storage_index, small_image_path, medium_image_path, +  select photo.identifier, caption, users, date_of_exposure, date_of_creation, 
-           large_image_path, folder, (access_type.value) as access_rights +         storage_location, storage_index, small_image_path, medium_image_path, 
-      from photo, photo_dupe, access_type +         large_image_path, folder, (access_type.value) as access_rights 
-     where photo.identifier = photo_dupe.photo +    from photo, photo_dupe, access_type 
-       and photo.access_rights = access_type.identifier +   where photo.identifier = photo_dupe.photo 
-     order by photo.identifier;+     and photo.access_rights = access_type.identifier 
 +   order by photo.identifier; 
 +</code>
  
 = Version 2.7 == = Version 2.7 ==
  
-<code>+<code sql>
 drop view view_photo; drop view view_photo;
  
podoc/view_photo_sql_view.1176458728.txt.gz · Last modified: 2007/04/13 10:05 by Luud