User Tools

Site Tools


podoc:view_flash_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_flash_sql_view [2007/04/13 09:07] Luudpodoc:view_flash_sql_view [2007/04/20 15:44] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create view view_flash as +<code sql> 
-    select flash.identifier, manufacturer.name, model, variation, flash.serial_number, flash.users, date_of_purchase, flash.purchased_new, manufacturer.url, (access_type.value) as access_rights +create view view_flash as 
-      from flash_type, flash, manufacturer, access_type +  select flash.identifier, manufacturer.name, model, variation, flash.serial_number, flash.users, date_of_purchase, flash.purchased_new, manufacturer.url, (access_type.value) as access_rights 
-     where flash_type.manufacturer = manufacturer.identifier +    from flash_type, flash, manufacturer, access_type 
-       and flash_type.identifier = flash.type +   where flash_type.manufacturer = manufacturer.identifier 
-       and flash.access_rights = access_type.identifier +     and flash_type.identifier = flash.type 
-     order by manufacturer.name, model, variation;+     and flash.access_rights = access_type.identifier 
 +   order by manufacturer.name, model, variation; 
 +</code>
  
 === Related tables === === Related tables ===
Line 25: Line 27:
   * [[flash_type sql table|flash_type]]   * [[flash_type sql table|flash_type]]
   * [[manufacturer sql table|manufacturer]]   * [[manufacturer sql table|manufacturer]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related sequences === 
  
 === History === === History ===
Line 46: Line 42:
 = Version 2.5 = = Version 2.5 =
  
-  create view view_flash as +<code sql> 
-    select flash.identifier, manufacturer.name, model, variation, flash.serial_number, flash.users, date_of_purchase, flash.purchased_new, manufacturer.url, (access_type.value) as access_rights +create view view_flash as 
-      from flash_type, flash, manufacturer, access_type +  select flash.identifier, manufacturer.name, model, variation, flash.serial_number, flash.users, date_of_purchase, flash.purchased_new, manufacturer.url, (access_type.value) as access_rights 
-     where flash_type.manufacturer = manufacturer.identifier +    from flash_type, flash, manufacturer, access_type 
-       and flash_type.identifier = flash.type +   where flash_type.manufacturer = manufacturer.identifier 
-       and flash.access_rights = access_type.identifier +     and flash_type.identifier = flash.type 
-     order by manufacturer.name, model, variation;+     and flash.access_rights = access_type.identifier 
 +   order by manufacturer.name, model, variation; 
 +</code>
  
podoc/view_flash_sql_view.1176455227.txt.gz · Last modified: 2007/04/13 09:07 by Luud