User Tools

Site Tools


podoc:view_rating_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
Last revisionBoth sides next revision
podoc:view_rating_sql_view [2007/04/13 07:57] Luudpodoc:view_rating_sql_view [2007/10/19 19:50] Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create view view_rating as +<code sql> 
-    select rating.identifier, photo, users, date_of_creation, value, first_name, last_name +create view view_rating as 
-      from rating, users +  select rating.identifier, photo, users, date_of_creation, value, first_name, last_name, comment, version 
-     where rating.users=users.identifier;+    from rating, users 
 +   where rating.users=users.identifier; 
 +</code>
  
 === Related tables === === Related tables ===
  
   * [[rating sql table|rating]]   * [[rating sql table|rating]]
-  * [[users table|users]] +  * [[users sql table|users]]
- +
-=== Related indexes === +
- +
-=== Related functions === +
- +
-=== Related views ===+
  
 === History === === History ===
Line 41: Line 37:
 = Version 2.5 = = Version 2.5 =
  
 +<code sql>
   create view view_rating as   create view view_rating as
     select rating.identifier, photo, users, date_of_creation, value, first_name, last_name     select rating.identifier, photo, users, date_of_creation, value, first_name, last_name
       from rating, users       from rating, users
      where rating.users=users.identifier;      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>
  
podoc/view_rating_sql_view.txt · Last modified: 2007/10/19 19:50 by Luud