version
Database table containing current version of the Photo Organizer database schema.
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.
CREATE TABLE version ( identifier INTEGER NOT NULL PRIMARY KEY, description VARCHAR(300), major SMALLINT, minor SMALLINT, variation VARCHAR(1) );
None.
None.
None.
None.
None.
None.
Version 2.5
Still in use
= Version 2.5 =
CREATE TABLE version ( identifier INTEGER NOT NULL PRIMARY KEY, description VARCHAR(300), major SMALLINT, minor SMALLINT, variation VARCHAR(1) );
= 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';