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
Last revision Both sides next revision
podoc:view_rating_sql_view [2007/04/13 09:04]
Luud
podoc:view_rating_sql_view [2007/10/19 19:50]
Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<code>+<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, comment+  select rating.identifier, photo, users, date_of_creation, value, first_name, last_name, comment, version
     from rating, users     from rating, users
    where rating.users=users.identifier;    where rating.users=users.identifier;
Line 22: Line 22:
   * [[rating sql table|rating]]   * [[rating sql table|rating]]
   * [[users sql table|users]]   * [[users sql table|users]]
- 
-=== Related indexes === 
- 
-=== Related functions === 
- 
-=== Related views === 
  
 === History === === History ===
Line 43: 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 = = Version 2.6 =
  
-<code>+<code sql>
 drop view view_rating; drop view view_rating;
  
Line 58: Line 54:
    where rating.users=users.identifier;    where rating.users=users.identifier;
 </code> </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