podoc:photo_dupe_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:photo_dupe_sql_table [2007/10/19 19:34] – Luud | podoc:photo_dupe_sql_table [2007/10/31 15:38] (current) – Luud | ||
---|---|---|---|
Line 19: | Line 19: | ||
storage_location | storage_location | ||
storage_index | storage_index | ||
- | remark | + | remark |
+ | version | ||
); | ); | ||
</ | </ | ||
Line 26: | Line 27: | ||
* photo references [[photo sql table|photo]](identifier) | * photo references [[photo sql table|photo]](identifier) | ||
+ | * version references [[photo_version sql table|photo_version]](identifier) | ||
=== Is referenced by other tables === | === Is referenced by other tables === | ||
- | * [[submission sql table|submission]](photo_dupe) references identifier | + | * <del>[[submission sql table|submission]](photo_dupe) references identifier</ |
=== Related sequences === | === Related sequences === | ||
Line 46: | Line 48: | ||
* [[view_photo sql view|view_photo]] | * [[view_photo sql view|view_photo]] | ||
- | * [[view_submission sql view|view_submission]] | + | * <del>[[view_submission sql view|view_submission]]</ |
=== History === | === History === | ||
Line 58: | Line 60: | ||
Still in use | Still in use | ||
- | == Change | + | == Schema change |
= Version 2.5 = | = Version 2.5 = | ||
<code sql> | <code sql> | ||
- | | + | create table photo_dupe ( |
- | identifier | + | identifier |
- | key | + | key |
- | photo | + | photo |
- | date_of_creation | + | date_of_creation |
- | storage_location | + | storage_location |
- | storage_index | + | storage_index |
- | remark | + | remark |
- | ); | + | ); |
+ | </ | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | -- Add ' | ||
+ | |||
+ | |||
+ | ALTER TABLE photo_dupe | ||
+ | | ||
+ | |||
+ | |||
+ | ALTER TABLE photo_dupe ALTER version SET NOT NULL; | ||
+ | </ | ||
+ | |||
+ | == Data change history = | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | UPDATE photo_dupe set version = | ||
+ | | ||
+ | WHERE photo_dupe.photo = v.photo AND v.master = ' | ||
</ | </ | ||
podoc/photo_dupe_sql_table.1192822484.txt.gz · Last modified: 2007/10/19 19:34 by Luud