Photo Organizer

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;

• rating
• users

Version 2.5

Still in use

= Version 2.5 =

create view view_rating as
  select rating.identifier, photo, users, date_of_creation, value, first_name, last_name
    from rating, users
   where rating.users=users.identifier;

= Version 2.6 =

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;