Photo Organizer

User Tools

Site Tools

Trace:
podoc:version_sql_table

Differences

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

Link to this comparison view

Next revision		Previous revision
podoc:version_sql_table [2007/04/12 12:02] – created Luudpodoc:version_sql_table [2007/04/20 14:50] (current) – Luud
Line 1: Line 1:
-===== Database Table Description =====+===== Database Table Description of "version" =====
  
 === Name === === Name ===
 +
 +version
  
 === Description === === Description ===
 +
 +Database table containing current version of the Photo Organizer database schema.
  
 === Purpose === === Purpose ===
 +
 +This table contains vital information for updating the database schema of Photo Organizer. Based on this information the installer knows which patches to apply to the database in order to migrate to a newer database schema.
  
 === Schema === === Schema ===
 +
 +<code sql>
 +create table version (
 +  identifier            integer not null primary key,
 +  description           varchar(300),
 +  major                 smallint,
 +  minor                 smallint,
 +  variation             varchar(1)
 +);
 +</code>
 +
 +=== References tables ===
 +
 +None.
 +
 +=== Is referenced by tables ===
 +
 +None.
  
 === Related sequences === === Related sequences ===
 +
 +None.
  
 === Related indexes === === Related indexes ===
 +
 +None.
 +
 +=== Related functions ===
 +
 +None.
 +
 +=== Related views ===
 +
 +None.
  
 === History === === History ===
Line 17: Line 53:
 == Used first == == Used first ==
  
-Verions 2.5+Version 2.5
  
 == Used last == == Used last ==
Line 23: Line 59:
 Still in use Still in use
  
-== Change history ==+== Schema change history ==
  
 = Version 2.5 = = Version 2.5 =
  
-  create table ... ( +<code sql> 
-    ...   +create table version ( 
-  );+  identifier            integer not null primary key, 
 +  description           varchar(300), 
 +  major                 smallint, 
 +  minor                 smallint, 
 +  variation             varchar(1) 
 +); 
 +</code> 
 + 
 +== Data change history == 
 + 
 += Version 2.5 = 
 + 
 +<code sql> 
 +insert into version values (2, 'second customer release', 2, 5, 'C' ); 
 +</code> 
 + 
 += Version 2.6 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.6 customer release', major=2, minor=6, variation='C'; 
 +</code> 
 + 
 += Version 2.7 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.7 customer release', major=2, minor=7, variation='C'; 
 +</code> 
 + 
 += Version 2.8 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.8 customer release', major=2, minor=8, variation='C'; 
 +</code> 
 + 
 += Version 2.9 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.9 customer release', major=2, minor=9, variation='C'; 
 +</code> 
 + 
 += Version 2.10 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.10 customer release', major=2, minor=10, variation='C'; 
 +</code> 
 + 
 += Version 2.11 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.11 customer release', major=2, minor=11, variation='C'; 
 +</code> 
 + 
 += Version 2.12 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.12 customer release', major=2, minor=12, variation='C'; 
 +</code> 
 + 
 += Version 2.13 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.13 customer release', major=2, minor=13, variation='C'; 
 +</code> 
 + 
 += Version 2.14 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.14 customer release', major=2, minor=14, variation='C'; 
 +</code> 
 + 
 += Version 2.15 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.15 customer release', major=2, minor=15, variation='C'; 
 +</code> 
 + 
 += Version 2.16 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.16 customer release', major=2, minor=16, variation='C'; 
 +</code> 
 + 
 += Version 2.17 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.17 customer release', major=2, minor=17, variation='C'; 
 +</code> 
 + 
 += Version 2.18 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.18 customer release', major=2, minor=18, variation='C'; 
 +</code> 
 + 
 += Version 2.19 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.19 customer release', major=2, minor=19, variation='C'; 
 +</code> 
 + 
 += Version 2.20 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.20 customer release', major=2, minor=20, variation='C'; 
 +</code> 
 + 
 += Version 2.21 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.21 customer release', major=2, minor=21, variation='C'; 
 +</code> 
 + 
 += Version 2.22 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.22 customer release', major=2, minor=22, variation='C'; 
 +</code> 
 + 
 += Version 2.23 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.23 customer release', major=2, minor=23, variation='C'; 
 +</code> 
 + 
 += Version 2.24 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.24 customer release', major=2, minor=24, variation='C'; 
 +</code> 
 + 
 += Version 2.25 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.25 customer release', major=2, minor=25, variation='C'; 
 +</code> 
 + 
 += Version 2.26 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.26 customer release', major=2, minor=26, variation='B'; 
 +</code> 
 + 
 += Version 2.27 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.27 customer release', major=2, minor=27, variation='B'; 
 +</code> 
 + 
 += Version 2.28 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.28 customer release', major=2, minor=28, variation='C'; 
 +</code> 
 + 
 += Version 2.29 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.29 customer release', major=2, minor=29, variation='B'; 
 +</code> 
 + 
 += Version 2.30 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.30 customer release', major=2, minor=30, variation='B'; 
 +</code> 
 + 
 += Version 2.31 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.31 customer release', major=2, minor=31, variation='A'; 
 +</code> 
 + 
 += Version 2.32 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.32 customer release', major=2, minor=32, variation='A'; 
 +</code> 
 + 
 += Version 2.33 = 
 + 
 +<code sql> 
 +-- version update 
 +update version set identifier=3, description='2.33 customer release', major=2, minor=33, variation='A'; 
 +</code> 
podoc/version_sql_table.1176379359.txt.gz · Last modified: 2007/04/12 12:02 by Luud