This is an old revision of the document!
Database Table Description of "version"
Name
version
Description
Database table containing current version of the Photo Organizer database schema.
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
create table version ( identifier integer not null primary key, description varchar(300), major smallint, minor smallint, variation varchar(1) );
Related sequences
None.
Related indexes
None.
Related functions
None.
Related views
None.
History
Used first
Version 2.5
Used last
Still in use
Schema change history
= Version 2.5 =
create table version ( identifier integer not null primary key, description varchar(300), major smallint, minor smallint, variation varchar(1) );
Data change history
= Version 2.5 =
insert into version values (2, 'second customer release', 2, 5, 'C' );
= Version 2.6 =
-- version update update version set identifier=3, description='2.6 customer release', major=2, minor=6, variation='C';
= Version 2.7 =
-- version update update version set identifier=3, description='2.7 customer release', major=2, minor=7, variation='C';
= Version 2.8 =
-- version update update version set identifier=3, description='2.8 customer release', major=2, minor=8, variation='C';
= Version 2.9 =
-- version update update version set identifier=3, description='2.9 customer release', major=2, minor=9, variation='C';
= Version 2.10 =
-- version update update version set identifier=3, description='2.10 customer release', major=2, minor=10, variation='C';
= Version 2.11 =
-- version update update version set identifier=3, description='2.11 customer release', major=2, minor=11, variation='C';
= Version 2.12 =
-- version update update version set identifier=3, description='2.12 customer release', major=2, minor=12, variation='C';
= Version 2.13 =
-- version update update version set identifier=3, description='2.13 customer release', major=2, minor=13, variation='C';
= Version 2.14 =
-- version update update version set identifier=3, description='2.14 customer release', major=2, minor=14, variation='C';
= Version 2.15 =
-- version update update version set identifier=3, description='2.15 customer release', major=2, minor=15, variation='C';
= Version 2.16 =
-- version update update version set identifier=3, description='2.16 customer release', major=2, minor=16, variation='C';
= Version 2.17 =
-- version update update version set identifier=3, description='2.17 customer release', major=2, minor=17, variation='C';
= Version 2.18 =
-- version update update version set identifier=3, description='2.18 customer release', major=2, minor=18, variation='C';
= Version 2.19 =
-- version update update version set identifier=3, description='2.19 customer release', major=2, minor=19, variation='C';
= Version 2.20 =
-- version update update version set identifier=3, description='2.20 customer release', major=2, minor=20, variation='C';
= Version 2.21 =
-- version update update version set identifier=3, description='2.21 customer release', major=2, minor=21, variation='C';
= Version 2.22 =
-- version update update version set identifier=3, description='2.22 customer release', major=2, minor=22, variation='C';
= Version 2.23 =
-- version update update version set identifier=3, description='2.23 customer release', major=2, minor=23, variation='C';
= Version 2.24 =
-- version update update version set identifier=3, description='2.24 customer release', major=2, minor=24, variation='C';
= Version 2.25 =
-- version update update version set identifier=3, description='2.25 customer release', major=2, minor=25, variation='C';
= Version 2.26 =
-- version update update version set identifier=3, description='2.26 customer release', major=2, minor=26, variation='B';
= Version 2.27 =
-- version update update version set identifier=3, description='2.27 customer release', major=2, minor=27, variation='B';
= Version 2.28 =
-- version update update version set identifier=3, description='2.28 customer release', major=2, minor=28, variation='C';
= Version 2.29 =
-- version update update version set identifier=3, description='2.29 customer release', major=2, minor=29, variation='B';
= Version 2.30 =
-- version update update version set identifier=3, description='2.30 customer release', major=2, minor=30, variation='B';
= Version 2.31 =
-- version update update version set identifier=3, description='2.31 customer release', major=2, minor=31, variation='A';
= Version 2.32 =
-- version update update version set identifier=3, description='2.32 customer release', major=2, minor=32, variation='A';
= Version 2.33 =
-- version update update version set identifier=3, description='2.33 customer release', major=2, minor=33, variation='A';