User Tools

Site Tools


podoc:shop_order_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:shop_order_sql_table [2007/04/16 16:00] Luudpodoc:shop_order_sql_table [2007/10/19 15:52] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<code>+<code sql>
 create table shop_order ( create table shop_order (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 25: Line 25:
 </code> </code>
  
-=== Related tables ===+=== References tables === 
 + 
 +  * 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 =
  
-<code>+<code sql>
 create table shop_order ( create table shop_order (
   identifier            integer not null primary key,   identifier            integer not null primary key,
Line 65: Line 79:
 = Version 2.19 = = Version 2.19 =
  
-<code>+<code sql>
 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;
 +</code>
 +
 += Version 2.34 =
 +
 +<code sql>
 +drop table shop_order;
 </code> </code>
  
Line 74: Line 94:
 = Version 2.19 = = Version 2.19 =
  
-<code>+<code sql>
 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();
 </code> </code>
  
podoc/shop_order_sql_table.1176739246.txt.gz · Last modified: 2007/04/16 16:00 by Luud