podoc:album_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:album_sql_table [2007/10/19 20:39] – Luud | podoc:album_sql_table [2007/10/19 20:45] (current) – Luud | ||
---|---|---|---|
Line 22: | Line 22: | ||
date_of_creation | date_of_creation | ||
access_rights | access_rights | ||
- | type char(1) check (type in (' | ||
description | description | ||
parent_album | parent_album | ||
Line 124: | Line 123: | ||
</ | </ | ||
- | < | + | < |
-- Drop ' | -- Drop ' | ||
alter table album drop orderby; | alter table album drop orderby; | ||
Line 132: | Line 131: | ||
-- Associate events with albums | -- Associate events with albums | ||
alter table album add column event integer references calendar(identifier); | alter table album add column event integer references calendar(identifier); | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | -- this is obselete | ||
+ | alter table album drop column type; | ||
</ | </ | ||
podoc/album_sql_table.txt · Last modified: 2007/10/19 20:45 by Luud