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 15:44] – 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 (' | ||
- | orderby | ||
description | description | ||
parent_album | parent_album | ||
password | password | ||
- | date_changed | + | date_changed |
+ | event | ||
); | ); | ||
</ | </ | ||
Line 34: | Line 33: | ||
* access_rights references [[access_type sql table|access_type]](identifier) | * access_rights references [[access_type sql table|access_type]](identifier) | ||
+ | * event references [[calendar sql table|calendar]](identifier) | ||
* parent_album references [[album sql table|album]](identifier) // **self reference** // | * parent_album references [[album sql table|album]](identifier) // **self reference** // | ||
* users references [[users sql table|users]](identifier) | * users references [[users sql table|users]](identifier) | ||
Line 48: | Line 48: | ||
=== Related indexes === | === Related indexes === | ||
- | * [[album_id_idx sql index|album_id_idx]] | + | * [[album_event_idx sql index|album_event_idx]] |
+ | * <del>[[album_id_idx sql index|album_id_idx]]</ | ||
* [[album_users_idx sql index|album_users_idx]] | * [[album_users_idx sql index|album_users_idx]] | ||
Line 113: | Line 114: | ||
= Version 2.34 = | = Version 2.34 = | ||
- | <code> sql> | + | <code sql> |
-- Add password support to albums | -- Add password support to albums | ||
alter table album add password text; | alter table album add password text; | ||
Line 120: | Line 121: | ||
<code sql> | <code sql> | ||
alter table album add date_changed timestamp without time zone; | alter table album add date_changed timestamp without time zone; | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | -- Drop ' | ||
+ | alter table album drop orderby; | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | -- Associate events with albums | ||
+ | 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.1192808648.txt.gz · Last modified: 2007/10/19 15:44 by Luud