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 revision Previous revision
podoc:view_photo_sql_view [2007/04/13 06:05]
Luud
podoc:view_photo_sql_view [2007/04/20 12: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.txt · Last modified: 2007/04/20 12:17 by Luud