Differences

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

--- podoc:view_rating_sql_view [2007/04/12 12:24] – created Luud
+++ podoc:view_rating_sql_view [2007/10/19 19:50] – Luud
@@ Line 1: / Line 1: @@
-===== Database View Description =====
+===== Database View Description of "view_rating" =====
 === Name ===
+view_rating
 === Description ===
@@ Line 9: / Line 11: @@
 === Schema ===
-=== Related tables===
+<code sql>
+create view view_rating as
+  select rating.identifier, photo, users, date_of_creation, value, first_name, last_name, comment, version
+    from rating, users
+   where rating.users=users.identifier;
+</code>
-=== Related sequences ===
+=== Related tables ===
-=== Related indexes ===
+  * [[rating sql table|rating]]
+  * [[users sql table|users]]
-=== Related functions ===
 === History ===
@@ Line 31: / Line 37: @@
 = Version 2.5 =
-  create view ... (
+<code sql>
-    ...
+  create view view_rating as
-  );
+    select rating.identifier, photo, users, date_of_creation, value, first_name, last_name
+      from rating, users
+     where rating.users=users.identifier;
+</code>
+= Version 2.6 =
+<code sql>
+drop view view_rating;
+create view view_rating as
+  select rating.identifier, photo, users, date_of_creation, value, first_name, last_name, comment
+    from rating, users
+   where rating.users=users.identifier;
+</code>
+= Version 2.34 =
+<code sql>
+DROP VIEW view_rating;
+create view view_rating as
+  select rating.identifier, photo, users, date_of_creation, value, first_name, last_name, comment, version
+    from rating, users
+   where rating.users=users.identifier;
+</code>