Photo Organizer

User Tools

Site Tools

Trace:
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 09:03] – Luudpodoc: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 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.txt · Last modified: 2007/10/19 19:50 by Luud