podoc:photo_item_sql_table
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
podoc:photo_item_sql_table [2007/04/19 08:50] 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 | ||
| - | shop_item | + | shop_item |
| price | price | ||
| currency | currency | ||
| Line 25: | Line 25: | ||
| </ | </ | ||
| - | === 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 54: | Line 60: | ||
| == Used last == | == Used last == | ||
| - | Still in use | + | Version 2.33 |
| == Schema change history == | == Schema change history == | ||
| Line 60: | Line 66: | ||
| = Version 2.8 = | = Version 2.8 = | ||
| - | < | + | < |
| create table photo_item ( | create table photo_item ( | ||
| identifier | identifier | ||
| Line 75: | Line 81: | ||
| = Version 2.19 = | = Version 2.19 = | ||
| - | < | + | < |
| alter table photo_item rename column format to shop_item; | alter table photo_item rename column format to shop_item; | ||
| </ | </ | ||
| Line 81: | Line 87: | ||
| = Version 2.29 = | = Version 2.29 = | ||
| - | < | + | < |
| alter table photo_item add deleted char(1) check (deleted in (' | alter table photo_item add deleted char(1) check (deleted in (' | ||
| + | </ | ||
| + | |||
| + | = Version 2.34 = | ||
| + | |||
| + | <code sql> | ||
| + | drop table photo_item; | ||
| </ | </ | ||
| Line 89: | Line 101: | ||
| = Version 2.29 = | = Version 2.29 = | ||
| - | < | + | < |
| update photo_item set deleted=' | update photo_item set deleted=' | ||
| </ | </ | ||
podoc/photo_item_sql_table.1176972610.txt.gz · Last modified: 2007/04/19 08:50 by Luud
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
