podoc:album_content_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:album_content_sql_table [2007/04/18 12:41] – description. pizza | podoc:album_content_sql_table [2007/10/19 20:55] (current) – Luud | ||
---|---|---|---|
Line 15: | Line 15: | ||
=== Schema === | === Schema === | ||
- | | + | <code sql> |
- | identifier | + | create table album_content ( |
- | photo | + | identifier |
- | album | + | photo |
- | ); | + | album |
+ | | ||
+ | date_changed | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | * album references [[album sql table|album]](identifier) | ||
+ | * photo references [[photo sql table|photo]](identifier) | ||
+ | * version references [[photo_version sql table|photo_version]](identifier) | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | None. | ||
=== Related sequences === | === Related sequences === | ||
Line 28: | Line 42: | ||
* [[album_content_album_idx sql index|album_content_album_idx]] | * [[album_content_album_idx sql index|album_content_album_idx]] | ||
- | * [[album_content_id_idx sql index|album_content_id_idx]] | + | * <del>[[album_content_id_idx sql index|album_content_id_idx]]</ |
* [[album_content_photo_idx sql index|album_content_photo_idx]] | * [[album_content_photo_idx sql index|album_content_photo_idx]] | ||
+ | * [[album_content_version_idx sql index|album_content_version_idx]] | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | * [[count_photos_by_album sql function|count_photos_by_album]] | ||
+ | * [[count_photos_by_user sql function|count_photos_by_user]] | ||
=== Related views === | === Related views === | ||
+ | |||
+ | None. | ||
=== History === | === History === | ||
Line 45: | Line 65: | ||
Still in use | Still in use | ||
- | == Change | + | == Schema change |
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table album_content ( |
- | photo | + | identifier |
- | album | + | photo |
- | ); | + | album |
+ | ); | ||
+ | </ | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | -- Add ' | ||
+ | ALTER TABLE album_content | ||
+ | | ||
+ | </ | ||
+ | |||
+ | <code sql> | ||
+ | ALTER TABLE album_content ALTER version SET NOT NULL; | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | alter table album_content add date_added timestamp without time zone; | ||
+ | </ | ||
+ | |||
+ | == Data change history = | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | UPDATE album_content set version = | ||
+ | | ||
+ | WHERE album_content.photo = v.photo AND v.master = ' | ||
+ | </ | ||
podoc/album_content_sql_table.1176900062.txt.gz · Last modified: 2007/04/18 12:41 by pizza