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/23 14:20]
Luud
podoc:view_rating_sql_view [2007/10/19 19:50] (current)
Luud
Line 13: Line 13:
 <code sql> <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 51: Line 51:
 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
 +    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     from rating, users
    where rating.users=users.identifier;    where rating.users=users.identifier;
 </code> </code>
  
podoc/view_rating_sql_view.1177338014.txt.gz ยท Last modified: 2007/04/23 14:20 by Luud