podoc:album_id_sequence_sql_sequence
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| podoc:album_id_sequence_sql_sequence [2007/04/18 10:50] – Luud | podoc:album_id_sequence_sql_sequence [2007/04/23 14:37] (current) – Luud | ||
|---|---|---|---|
| Line 7: | Line 7: | ||
| === Description === | === Description === | ||
| - | Sequence generator for the 'fieldname' | + | Sequence generator for the column |
| === Purpose === | === Purpose === | ||
| - | To facilitate the generation of unique values for the ' | + | To facilitate the generation of unique values for the primary key column |
| === Schema === | === Schema === | ||
| - | | + | <code sql> |
| + | create sequence album_id_sequence start 1; | ||
| + | </ | ||
| === Related tables === | === Related tables === | ||
| * [[album sql table|album]] | * [[album sql table|album]] | ||
| - | |||
| - | === Related indexes === | ||
| - | |||
| - | === Related functions === | ||
| - | |||
| - | === Related views === | ||
| === History === | === History === | ||
| Line 41: | Line 37: | ||
| = Version 2.5 = | = Version 2.5 = | ||
| - | | + | <code sql> |
| + | create sequence album_id_sequence start 1; | ||
| + | </ | ||
podoc/album_id_sequence_sql_sequence.txt · Last modified: 2007/04/23 14:37 by Luud