podoc:shop_order_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:shop_order_sql_table [2007/04/16 16:00] – Luud | podoc:shop_order_sql_table [2007/10/19 15:52] (current) – Luud | ||
---|---|---|---|
Line 11: | Line 11: | ||
=== Schema === | === Schema === | ||
- | < | + | < |
create table shop_order ( | create table shop_order ( | ||
identifier | identifier | ||
Line 25: | Line 25: | ||
</ | </ | ||
- | === Related | + | === References |
+ | |||
+ | * client references [[users sql table|users]](identifier) | ||
+ | * item references [[photo_item sql table|photo_item]](identifier) | ||
+ | * transaction references [[shop_transaction sql table|shop_transaction]](identifier) | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | None. | ||
=== Related sequences === | === Related sequences === | ||
Line 32: | Line 40: | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | None. | ||
=== Related functions === | === Related functions === | ||
+ | |||
+ | * [[photo_shop_transaction_references sql function|photo_shop_transaction_references]] | ||
=== Related views === | === Related views === | ||
+ | |||
+ | None. | ||
=== History === | === History === | ||
Line 45: | Line 59: | ||
== Used last == | == Used last == | ||
- | Still in use | + | Version 2.33 |
== Schema change history == | == Schema change history == | ||
Line 51: | Line 65: | ||
= Version 2.8 = | = Version 2.8 = | ||
- | < | + | < |
create table shop_order ( | create table shop_order ( | ||
identifier | identifier | ||
Line 65: | Line 79: | ||
= Version 2.19 = | = Version 2.19 = | ||
- | < | + | < |
alter table shop_order add column download_counter integer; | alter table shop_order add column download_counter integer; | ||
alter table shop_order add column download_expiry_date date; | alter table shop_order add column download_expiry_date date; | ||
+ | </ | ||
+ | |||
+ | = Version 2.34 = | ||
+ | |||
+ | <code sql> | ||
+ | drop table shop_order; | ||
</ | </ | ||
Line 74: | Line 94: | ||
= Version 2.19 = | = Version 2.19 = | ||
- | < | + | < |
update shop_order set download_counter = 0; | update shop_order set download_counter = 0; | ||
update shop_order set download_expiry_date = now(); | update shop_order set download_expiry_date = now(); | ||
</ | </ | ||
podoc/shop_order_sql_table.1176739246.txt.gz · Last modified: 2007/04/16 16:00 by Luud