User Tools

Site Tools


podoc:version_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:version_sql_table [2007/04/12 12:50] Luudpodoc:version_sql_table [2007/04/20 14:50] (current) Luud
Line 6: Line 6:
  
 === 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 ===
  
-  create table version ( +<code sql> 
-    identifier            integer not null primary key, +create table version ( 
-    description           varchar(300), +  identifier            integer not null primary key, 
-    major                 smallint, +  description           varchar(300), 
-    minor                 smallint, +  major                 smallint, 
-    variation             varchar(1) +  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 === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 37: Line 59:
 Still in use Still in use
  
-== Change history ==+== Schema change history ==
  
 = Version 2.5 = = Version 2.5 =
  
-  create table version ( +<code sql> 
-    identifier            integer not null primary key, +create table version ( 
-    description           varchar(300), +  identifier            integer not null primary key, 
-    major                 smallint, +  description           varchar(300), 
-    minor                 smallint, +  major                 smallint, 
-    variation             varchar(1) +  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.1176382241.txt.gz · Last modified: 2007/04/12 12:50 by Luud