podoc:photo_spooler_id_sequence_sql_sequence
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
podoc:photo_spooler_id_sequence_sql_sequence [2007/04/16 15:07] – created Luud | podoc:photo_spooler_id_sequence_sql_sequence [2007/10/19 14:42] (current) – Luud | ||
---|---|---|---|
Line 6: | Line 6: | ||
=== Description === | === Description === | ||
+ | |||
+ | Sequence generator for the column ' | ||
=== Purpose === | === Purpose === | ||
+ | |||
+ | To facilitate the generation of unique values for the primary key column ' | ||
=== Schema === | === Schema === | ||
- | < | + | < |
create sequence photo_spooler_id_sequence start 1; | create sequence photo_spooler_id_sequence start 1; | ||
</ | </ | ||
Line 18: | Line 22: | ||
* [[photo_spooler sql table|photo_spooler]] | * [[photo_spooler sql table|photo_spooler]] | ||
- | |||
- | === Related indexes === | ||
- | |||
- | === Related functions === | ||
- | |||
- | === Related views === | ||
=== History === | === History === | ||
Line 33: | Line 31: | ||
== Used last == | == Used last == | ||
- | Still in use | + | Version 2.33 |
== Change history == | == Change history == | ||
Line 39: | Line 37: | ||
= Version 2.15 = | = Version 2.15 = | ||
- | < | + | < |
create sequence photo_spooler_id_sequence start 1; | create sequence photo_spooler_id_sequence start 1; | ||
+ | </ | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | -- Drop the old spooler | ||
+ | drop sequence photo_spooler_id_sequence; | ||
</ | </ | ||
podoc/photo_spooler_id_sequence_sql_sequence.1176736020.txt.gz · Last modified: 2007/04/16 15:07 by Luud