podoc:version_sql_table
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
podoc:version_sql_table [2007/04/16 13:25] – Luud | podoc:version_sql_table [2007/04/20 14:50] (current) – Luud | ||
---|---|---|---|
Line 15: | Line 15: | ||
=== 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 === | ||
Line 53: | Line 63: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | identifier | + | create table version ( |
- | description | + | identifier |
- | major | + | description |
- | minor | + | major |
- | variation | + | minor |
- | ); | + | variation |
+ | ); | ||
+ | </ | ||
== Data change history == | == Data change history == | ||
Line 65: | Line 77: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
+ | insert into version values (2, ' | ||
+ | </ | ||
= Version 2.6 = | = Version 2.6 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 76: | Line 90: | ||
= Version 2.7 = | = Version 2.7 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 83: | Line 97: | ||
= Version 2.8 = | = Version 2.8 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 90: | Line 104: | ||
= Version 2.9 = | = Version 2.9 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 97: | Line 111: | ||
= Version 2.10 = | = Version 2.10 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 104: | Line 118: | ||
= Version 2.11 = | = Version 2.11 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 111: | Line 125: | ||
= Version 2.12 = | = Version 2.12 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 118: | Line 132: | ||
= Version 2.13 = | = Version 2.13 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 125: | Line 139: | ||
= Version 2.14 = | = Version 2.14 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 132: | Line 146: | ||
= Version 2.15 = | = Version 2.15 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 139: | Line 153: | ||
= Version 2.16 = | = Version 2.16 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 146: | Line 160: | ||
= Version 2.17 = | = Version 2.17 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 153: | Line 167: | ||
= Version 2.18 = | = Version 2.18 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 160: | Line 174: | ||
= Version 2.19 = | = Version 2.19 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 167: | Line 181: | ||
= Version 2.20 = | = Version 2.20 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 174: | Line 188: | ||
= Version 2.21 = | = Version 2.21 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 181: | Line 195: | ||
= Version 2.22 = | = Version 2.22 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 188: | Line 202: | ||
= Version 2.23 = | = Version 2.23 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 195: | Line 209: | ||
= Version 2.24 = | = Version 2.24 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 202: | Line 216: | ||
= Version 2.25 = | = Version 2.25 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 209: | Line 223: | ||
= Version 2.26 = | = Version 2.26 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 216: | Line 230: | ||
= Version 2.27 = | = Version 2.27 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 223: | Line 237: | ||
= Version 2.28 = | = Version 2.28 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 230: | Line 244: | ||
= Version 2.29 = | = Version 2.29 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 237: | Line 251: | ||
= Version 2.30 = | = Version 2.30 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 244: | Line 258: | ||
= Version 2.31 = | = Version 2.31 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 251: | Line 265: | ||
= Version 2.32 = | = Version 2.32 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
Line 258: | Line 272: | ||
= Version 2.33 = | = Version 2.33 = | ||
- | < | + | < |
-- version update | -- version update | ||
update version set identifier=3, | update version set identifier=3, | ||
</ | </ | ||
podoc/version_sql_table.txt · Last modified: 2007/04/20 14:50 by Luud