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
podoc:view_rating_sql_view [2007/04/13 09:03] Luudpodoc:view_rating_sql_view [2007/10/19 19:50] (current) 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 21: Line 21:
  
   * [[rating sql table|rating]]   * [[rating sql table|rating]]
-  * [[users 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.1176455039.txt.gz · Last modified: 2007/04/13 09:03 by Luud