User Tools

Site Tools


podoc:photo_spooler_sql_table

Differences

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

Link to this comparison view

Next revision
Previous revision
podoc:photo_spooler_sql_table [2007/04/16 08:19]
Luud created
podoc:photo_spooler_sql_table [2007/10/19 10:41]
Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-<​code>​ +<​code ​sql
-...+create table photo_spooler ( 
 +  identifier ​           integer not null primary key, 
 +  users                 ​integer references users(identifier),​ 
 +  photo                 ​integer references photo(identifier) 
 +);
 </​code>​ </​code>​
  
-=== Related ​tables ===+=== References ​tables === 
 + 
 +  * photo references [[photo sql table|photo]](identifier) 
 +  * users references [[users sql table|users]](identifier) 
 + 
 +=== Is referenced by tables === 
 + 
 +None.
  
 === Related sequences === === Related sequences ===
  
   * [[photo_spooler_id_sequence sql sequence|photo_spooler_id_sequence]]   * [[photo_spooler_id_sequence sql sequence|photo_spooler_id_sequence]]
 +  * [[print_id_sequence sql index|print_id_sequence]]
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 31: Line 49:
 == Used first == == Used first ==
  
-Version 2.x+Version 2.15
  
 == Used last == == Used last ==
  
-Still in use+Version 2.33
  
 == Schema change history == == Schema change history ==
  
-= Version 2.=+= Version 2.15 =
  
-<​code>​ +<​code ​sql
-...+alter table printer_spooler rename to photo_spooler;​ 
 +delete from photo_spooler;​
 </​code>​ </​code>​
  
-== Data change history ==+Version 2.34 =
  
-= Version 2.x = +<​code ​sql
- +-- Drop the old spooler 
-<​code>​ +drop table photo_spooler;​
-...+
 </​code>​ </​code>​
 +
 +
 +== Data change history ==
  
podoc/photo_spooler_sql_table.txt · Last modified: 2007/10/19 10:41 by Luud