podoc:view_photo_sql_view
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:view_photo_sql_view [2007/04/13 10:03] – Luud | podoc:view_photo_sql_view [2007/04/20 16:17] (current) – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | < | + | < |
create view view_photo as | create view view_photo as | ||
select photo.identifier, | select photo.identifier, | ||
Line 23: | Line 23: | ||
order by photo.identifier; | order by photo.identifier; | ||
</ | </ | ||
- | |||
=== Related tables === | === Related tables === | ||
Line 30: | Line 29: | ||
* [[photo sql table|photo]] | * [[photo sql table|photo]] | ||
* [[photo_dupe sql table|photo_dupe]] | * [[photo_dupe sql table|photo_dupe]] | ||
- | + | * [[photo_version sql table|photo_version]] | |
- | === Related indexes === | + | |
- | + | ||
- | === Related functions === | + | |
- | + | ||
- | === Related sequences === | + | |
=== History === | === History === | ||
Line 51: | Line 45: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | select photo.identifier, | + | create view view_photo as |
- | | + | select photo.identifier, |
- | | + | |
- | from photo, photo_dupe, access_type | + | |
- | | + | from photo, photo_dupe, access_type |
- | | + | |
- | | + | |
+ | | ||
+ | </ | ||
= Version 2.7 == | = Version 2.7 == | ||
- | < | + | < |
drop view view_photo; | drop view view_photo; | ||
podoc/view_photo_sql_view.1176458633.txt.gz · Last modified: 2007/04/13 10:03 by Luud