User Tools

Site Tools


podoc:view_camera_type_sql_view

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:view_camera_type_sql_view [2007/04/13 09:07] Luudpodoc:view_camera_type_sql_view [2007/04/20 15:39] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create view view_camera_type as +<code sql> 
-    select camera_type.identifier, manufacturer.name, model, variation, manufacturer.url +create view view_camera_type as 
-      from camera_type, manufacturer +  select camera_type.identifier, manufacturer.name, model, variation, 
-     where camera_type.manufacturer = manufacturer.identifier +    manufacturer.url, raw_icc_profile 
-     order by manufacturer.name, model, variation;+    from camera_type, manufacturer 
 +   where camera_type.manufacturer = manufacturer.identifier 
 +   order by manufacturer.name, model, variation; 
 +</code>
  
 === Related tables === === Related tables ===
Line 21: Line 24:
   * [[camera_type sql table|camera_type]]   * [[camera_type sql table|camera_type]]
   * [[manufacturer sql table|manufacturer]]   * [[manufacturer sql table|manufacturer]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related sequences === 
  
 === History === === History ===
Line 42: Line 39:
 = Version 2.5 = = Version 2.5 =
  
-  create view view_camera_type as +<code sql> 
-    select camera_type.identifier, manufacturer.name, model, variation, manufacturer.url +create view view_camera_type as 
-      from camera_type, manufacturer +  select camera_type.identifier, manufacturer.name, model, variation, manufacturer.url 
-     where camera_type.manufacturer = manufacturer.identifier +    from camera_type, manufacturer 
-     order by manufacturer.name, model, variation;+   where camera_type.manufacturer = manufacturer.identifier 
 +   order by manufacturer.name, model, variation; 
 +</code> 
 + 
 += Version 2.29 = 
 + 
 +<code sql> 
 +drop view view_camera_type; 
 +create view view_camera_type as 
 +  select camera_type.identifier, manufacturer.name, model, variation, 
 +    manufacturer.url, raw_icc_profile 
 +    from camera_type, manufacturer 
 +   where camera_type.manufacturer = manufacturer.identifier 
 +   order by manufacturer.name, model, variation; 
 +</code>
  
podoc/view_camera_type_sql_view.1176455276.txt.gz · Last modified: 2007/04/13 09:07 by Luud