podoc:photo_item_sql_table
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
podoc:photo_item_sql_table [2007/04/16 11:31] – created Luud | podoc:photo_item_sql_table [2007/10/19 15:51] (current) – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | < | + | < |
create table photo_item ( | create table photo_item ( | ||
identifier | identifier | ||
photo | photo | ||
- | | + | |
price | price | ||
currency | currency | ||
Line 21: | Line 21: | ||
date_of_creation | date_of_creation | ||
date_of_last_edit | date_of_last_edit | ||
+ | deleted | ||
); | ); | ||
</ | </ | ||
- | === Related | + | === References |
- | * [[photo sql table|photo]] | + | * currency references [[currency sql table|currency]](identifier) |
+ | * photo references | ||
+ | * shop_item references [[shop_item sql table|shop_item]](identifier) | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[shop_order sql table|shop_order]](item) references identifier | ||
=== Related sequences === | === Related sequences === | ||
Line 33: | Line 40: | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | None. | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | * [[is_photo_for_sale sql function|is_photo_for_sale]] | ||
+ | * [[photo_shop_transaction_references sql function|photo_shop_transaction_references]] | ||
=== Related views === | === Related views === | ||
+ | |||
+ | None. | ||
=== History === | === History === | ||
Line 46: | Line 60: | ||
== Used last == | == Used last == | ||
- | Still in use | + | Version 2.33 |
== Schema change history == | == Schema change history == | ||
Line 52: | Line 66: | ||
= Version 2.8 = | = Version 2.8 = | ||
- | < | + | < |
create table photo_item ( | create table photo_item ( | ||
identifier | identifier | ||
Line 63: | Line 77: | ||
date_of_last_edit | date_of_last_edit | ||
); | ); | ||
+ | </ | ||
+ | |||
+ | = Version 2.19 = | ||
+ | |||
+ | <code sql> | ||
+ | alter table photo_item rename column format to shop_item; | ||
+ | </ | ||
+ | |||
+ | = Version 2.29 = | ||
+ | |||
+ | <code sql> | ||
+ | alter table photo_item add deleted char(1) check (deleted in (' | ||
+ | </ | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | drop table photo_item; | ||
</ | </ | ||
== Data change history == | == Data change history == | ||
- | = Version 2.8 = | + | = Version 2.29 = |
+ | |||
+ | <code sql> | ||
+ | update photo_item set deleted=' | ||
+ | </ | ||
- | None. | ||
podoc/photo_item_sql_table.1176723100.txt.gz · Last modified: 2007/04/16 11:31 by Luud