podoc:view_rating_sql_view
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
podoc:view_rating_sql_view [2007/04/13 07:57] – Luud | podoc:view_rating_sql_view [2007/10/19 19:50] – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | select rating.identifier, | + | create view view_rating as |
- | from rating, users | + | select rating.identifier, |
- | | + | from rating, users |
+ | | ||
+ | </ | ||
=== Related tables === | === Related tables === | ||
* [[rating sql table|rating]] | * [[rating sql table|rating]] | ||
- | * [[users table|users]] | + | * [[users |
- | + | ||
- | === Related indexes === | + | |
- | + | ||
- | === Related functions === | + | |
- | + | ||
- | === Related views === | + | |
=== History === | === History === | ||
Line 41: | Line 37: | ||
= Version 2.5 = | = Version 2.5 = | ||
+ | <code sql> | ||
create view view_rating as | create view view_rating as | ||
select rating.identifier, | select rating.identifier, | ||
from rating, users | from rating, users | ||
where rating.users=users.identifier; | where rating.users=users.identifier; | ||
+ | </ | ||
+ | |||
+ | = Version 2.6 = | ||
+ | |||
+ | <code sql> | ||
+ | drop view view_rating; | ||
+ | |||
+ | create view view_rating as | ||
+ | select rating.identifier, | ||
+ | from rating, users | ||
+ | where rating.users=users.identifier; | ||
+ | </ | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | DROP VIEW view_rating; | ||
+ | |||
+ | |||
+ | create view view_rating as | ||
+ | select rating.identifier, | ||
+ | from rating, users | ||
+ | where rating.users=users.identifier; | ||
+ | </ | ||
podoc/view_rating_sql_view.txt · Last modified: 2007/10/19 19:50 by Luud