Differences

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

--- podoc:view_scanner_sql_view [2007/04/13 09:10] – Luud
+++ podoc:view_scanner_sql_view [2007/04/23 14:20] (current) – Luud
@@ Line 11: / Line 11: @@
 === Schema ===
-  create view view_scanner as
+<code sql>
-    select scanner.identifier, manufacturer.name, model, variation, scanner.serial_number, scanner.users, date_of_purchase, scanner.purchased_new, manufacturer.url, (access_type.value) as access_rights
+create view view_scanner as
-      from scanner_type, scanner, manufacturer, access_type
+  select scanner.identifier, manufacturer.name, model, variation, scanner.serial_number, scanner.users, date_of_purchase, scanner.purchased_new, manufacturer.url, (access_type.value) as access_rights
-     where scanner_type.manufacturer = manufacturer.identifier
+    from scanner_type, scanner, manufacturer, access_type
-       and scanner_type.identifier = scanner.type
+   where scanner_type.manufacturer = manufacturer.identifier
-       and scanner.access_rights = access_type.identifier
+     and scanner_type.identifier = scanner.type
-     order by manufacturer.name, model, variation;
+     and scanner.access_rights = access_type.identifier
+   order by manufacturer.name, model, variation;
+</code>
 === Related tables ===
@@ Line 25: / Line 27: @@
   * [[scanner_type sql table|scanner_type]]
   * [[manufacturer sql table|manufacturer]]
-=== Related indexes ===
-=== Related functions ===
-=== Related sequences ===
 === History ===
@@ Line 46: / Line 41: @@
 = Version 2.5 =
-  create view view_scanner as
+<code sql>
-    select scanner.identifier, manufacturer.name, model, variation, scanner.serial_number, scanner.users, date_of_purchase, scanner.purchased_new, manufacturer.url, (access_type.value) as access_rights
+create view view_scanner as
-      from scanner_type, scanner, manufacturer, access_type
+  select scanner.identifier, manufacturer.name, model, variation, scanner.serial_number, scanner.users, date_of_purchase, scanner.purchased_new, manufacturer.url, (access_type.value) as access_rights
-     where scanner_type.manufacturer = manufacturer.identifier
+    from scanner_type, scanner, manufacturer, access_type
-       and scanner_type.identifier = scanner.type
+   where scanner_type.manufacturer = manufacturer.identifier
-       and scanner.access_rights = access_type.identifier
+     and scanner_type.identifier = scanner.type
-     order by manufacturer.name, model, variation;
+     and scanner.access_rights = access_type.identifier
+   order by manufacturer.name, model, variation;
+</code>