User Tools

Site Tools


podoc:version_sql_table

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

References tables

None.

Is referenced by tables

None.

None.

None.

None.

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';
podoc/version_sql_table.txt · Last modified: 2007/04/20 14:50 by Luud