Differences

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

--- podoc:view_client_sql_view [2007/04/13 09:08] – Luud
+++ podoc:view_client_sql_view [2007/04/20 15:39] (current) – Luud
@@ Line 11: / Line 11: @@
 === Schema ===
-  create view view_client as
+<code sql>
-    select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status, users.type
+create view view_client as
-      from client, users, client_status
+  select client.identifier, client.users, client.client, users.last_name,
-     where client.client = users.identifier
+         users.first_name, date_of_creation, client_status.value, client.status, users.type,
-       and client.status = client_status.identifier
+         client.trusted
-     order by users.last_name, users.first_name;
+    from client, users, client_status
+   where client.client = users.identifier
+     and client.status = client_status.identifier
+   order by users.last_name, users.first_name;
+</code>
 === Related tables ===
@@ Line 23: / Line 27: @@
   * [[client_status sql table|client_status]]
   * [[users sql table|users]]
-=== Related indexes ===
-=== Related functions ===
-=== Related sequences ===
 === History ===
@@ Line 44: / Line 42: @@
 = Version 2.5 =
-  create view view_client as
+<code sql>
-    select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status, users.type
+create view view_client as
-      from client, users, client_status
+  select client.identifier, client.users, client.client, users.last_name, users.first_name, date_of_creation, client_status.value, client.status, users.type
-     where client.client = users.identifier
+    from client, users, client_status
-       and client.status = client_status.identifier
+   where client.client = users.identifier
-     order by users.last_name, users.first_name;
+     and client.status = client_status.identifier
+   order by users.last_name, users.first_name;
+</code>
+= Version 2.19 =
+<code sql>
+drop view view_client;
+create view view_client as
+  select client.identifier, client.users, client.client, users.last_name,
+         users.first_name, date_of_creation, client_status.value, client.status, users.type,
+         client.trusted
+    from client, users, client_status
+   where client.client = users.identifier
+     and client.status = client_status.identifier
+   order by users.last_name, users.first_name;
+</code>