podoc:version_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
podoc:version_sql_table [2007/04/12 12:50] – Luud | podoc: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 === | ||
- | | + | <code sql> |
- | identifier | + | create table version ( |
- | description | + | identifier |
- | major | + | description |
- | minor | + | major |
- | variation | + | minor |
- | ); | + | variation |
+ | ); | ||
+ | </ | ||
+ | |||
+ | === 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 | + | == Schema change |
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table version ( |
- | description | + | identifier |
- | major | + | description |
- | minor | + | major |
- | variation | + | minor |
- | ); | + | variation |
+ | ); | ||
+ | </ | ||
+ | |||
+ | == Data change history == | ||
+ | |||
+ | = Version 2.5 = | ||
+ | |||
+ | <code sql> | ||
+ | insert into version values (2, ' | ||
+ | </ | ||
+ | |||
+ | = Version 2.6 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.7 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.8 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.9 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.10 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.11 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.12 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.13 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.14 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.15 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.16 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.17 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.18 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.19 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.20 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.21 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.22 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.23 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.24 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.25 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.26 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.27 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.28 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.29 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.30 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.31 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.32 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ | ||
+ | |||
+ | = Version 2.33 = | ||
+ | |||
+ | <code sql> | ||
+ | -- version update | ||
+ | update version set identifier=3, | ||
+ | </ |
podoc/version_sql_table.1176382241.txt.gz · Last modified: 2007/04/12 12:50 by Luud