Photo Organizer

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';