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 revision Previous revision
Next revision
Previous revision
podoc:view_rating_sql_view [2007/04/13 07:57]
Luud
podoc: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