podoc:view_camera_type_sql_view
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:view_camera_type_sql_view [2007/04/13 07:33] – Luud | podoc:view_camera_type_sql_view [2007/04/20 15:39] (current) – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | select camera_type.identifier, | + | create view view_camera_type as |
- | from camera_type, | + | select camera_type.identifier, |
- | | + | |
- | | + | from camera_type, |
+ | | ||
+ | | ||
+ | </ | ||
=== Related tables === | === Related tables === | ||
Line 21: | Line 24: | ||
* [[camera_type sql table|camera_type]] | * [[camera_type sql table|camera_type]] | ||
* [[manufacturer sql table|manufacturer]] | * [[manufacturer sql table|manufacturer]] | ||
- | |||
- | === Related indexes === | ||
- | |||
- | === Related functions === | ||
- | |||
- | === Related views === | ||
=== History === | === History === | ||
Line 42: | Line 39: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | select camera_type.identifier, | + | create view view_camera_type as |
- | from camera_type, | + | select camera_type.identifier, |
- | | + | |
- | | + | where camera_type.manufacturer = manufacturer.identifier |
+ | order by manufacturer.name, | ||
+ | </ | ||
+ | |||
+ | = Version 2.29 = | ||
+ | |||
+ | <code sql> | ||
+ | drop view view_camera_type; | ||
+ | create view view_camera_type as | ||
+ | | ||
+ | | ||
+ | from camera_type, | ||
+ | | ||
+ | | ||
+ | </ | ||
podoc/view_camera_type_sql_view.1176449596.txt.gz · Last modified: 2007/04/13 07:33 by Luud