User Tools

Site Tools


podoc:version_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:version_sql_table [2007/04/16 13:24] Luudpodoc:version_sql_table [2007/04/20 14:50] (current) Luud
Line 15: Line 15:
 === Schema === === Schema ===
  
-  create table version ( +<code sql> 
-    identifier            integer not null primary key, +create table version ( 
-    description           varchar(300), +  identifier            integer not null primary key, 
-    major                 smallint, +  description           varchar(300), 
-    minor                 smallint, +  major                 smallint, 
-    variation             varchar(1) +  minor                 smallint, 
-  );+  variation             varchar(1) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +None.
  
 === Related sequences === === Related sequences ===
Line 53: Line 63:
 = Version 2.5 = = Version 2.5 =
  
-  create table version ( +<code sql> 
-    identifier            integer not null primary key, +create table version ( 
-    description           varchar(300), +  identifier            integer not null primary key, 
-    major                 smallint, +  description           varchar(300), 
-    minor                 smallint, +  major                 smallint, 
-    variation             varchar(1) +  minor                 smallint, 
-  );+  variation             varchar(1) 
 +); 
 +</code>
  
 == Data change history == == Data change history ==
Line 65: Line 77:
 = Version 2.5 = = Version 2.5 =
  
-  insert into version values (2, 'second customer release', 2, 5, 'C' );+<code sql> 
 +insert into version values (2, 'second customer release', 2, 5, 'C' ); 
 +</code>
  
 = Version 2.6 = = Version 2.6 =
  
-<code>+<code sql>
 -- version update -- version update
 update version set identifier=3, description='2.6 customer release', major=2, minor=6, variation='C'; update version set identifier=3, description='2.6 customer release', major=2, minor=6, variation='C';
Line 76: Line 90:
 = Version 2.7 = = Version 2.7 =
  
-<code>+<code sql>
 -- version update -- version update
 update version set identifier=3, description='2.7 customer release', major=2, minor=7, variation='C'; update version set identifier=3, description='2.7 customer release', major=2, minor=7, variation='C';
Line 83: Line 97:
 = Version 2.8 = = Version 2.8 =
  
-<code>+<code sql>
 -- version update -- version update
 update version set identifier=3, description='2.8 customer release', major=2, minor=8, variation='C'; update version set identifier=3, description='2.8 customer release', major=2, minor=8, variation='C';
Line 90: Line 104:
 = Version 2.9 = = Version 2.9 =
  
-<code>+<code sql>
 -- version update -- version update
 update version set identifier=3, description='2.9 customer release', major=2, minor=9, variation='C'; update version set identifier=3, description='2.9 customer release', major=2, minor=9, variation='C';
Line 97: Line 111:
 = Version 2.10 = = Version 2.10 =
  
-<code>+<code sql>
 -- version update -- version update
 update version set identifier=3, description='2.10 customer release', major=2, minor=10, variation='C'; update version set identifier=3, description='2.10 customer release', major=2, minor=10, variation='C';
Line 104: Line 118:
 = Version 2.11 = = Version 2.11 =
  
-<code>+<code sql>
 -- version update -- version update
 update version set identifier=3, description='2.11 customer release', major=2, minor=11, variation='C'; update version set identifier=3, description='2.11 customer release', major=2, minor=11, variation='C';
Line 111: Line 125:
 = Version 2.12 = = Version 2.12 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.12 customer release', major=2, minor=12, variation='C'; update version set identifier=3, description='2.12 customer release', major=2, minor=12, variation='C';
 </code> </code>
Line 118: Line 132:
 = Version 2.13 = = Version 2.13 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.13 customer release', major=2, minor=13, variation='C'; update version set identifier=3, description='2.13 customer release', major=2, minor=13, variation='C';
 </code> </code>
Line 125: Line 139:
 = Version 2.14 = = Version 2.14 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.14 customer release', major=2, minor=14, variation='C'; update version set identifier=3, description='2.14 customer release', major=2, minor=14, variation='C';
 </code> </code>
Line 132: Line 146:
 = Version 2.15 = = Version 2.15 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.15 customer release', major=2, minor=15, variation='C'; update version set identifier=3, description='2.15 customer release', major=2, minor=15, variation='C';
 </code> </code>
Line 139: Line 153:
 = Version 2.16 = = Version 2.16 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.16 customer release', major=2, minor=16, variation='C'; update version set identifier=3, description='2.16 customer release', major=2, minor=16, variation='C';
 </code> </code>
Line 146: Line 160:
 = Version 2.17 = = Version 2.17 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.17 customer release', major=2, minor=17, variation='C'; update version set identifier=3, description='2.17 customer release', major=2, minor=17, variation='C';
 </code> </code>
Line 153: Line 167:
 = Version 2.18 = = Version 2.18 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.18 customer release', major=2, minor=18, variation='C'; update version set identifier=3, description='2.18 customer release', major=2, minor=18, variation='C';
 </code> </code>
Line 160: Line 174:
 = Version 2.19 = = Version 2.19 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.19 customer release', major=2, minor=19, variation='C'; update version set identifier=3, description='2.19 customer release', major=2, minor=19, variation='C';
 </code> </code>
Line 167: Line 181:
 = Version 2.20 = = Version 2.20 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.20 customer release', major=2, minor=20, variation='C'; update version set identifier=3, description='2.20 customer release', major=2, minor=20, variation='C';
 </code> </code>
Line 174: Line 188:
 = Version 2.21 = = Version 2.21 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.21 customer release', major=2, minor=21, variation='C'; update version set identifier=3, description='2.21 customer release', major=2, minor=21, variation='C';
 </code> </code>
Line 181: Line 195:
 = Version 2.22 = = Version 2.22 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.22 customer release', major=2, minor=22, variation='C'; update version set identifier=3, description='2.22 customer release', major=2, minor=22, variation='C';
 </code> </code>
Line 188: Line 202:
 = Version 2.23 = = Version 2.23 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.23 customer release', major=2, minor=23, variation='C'; update version set identifier=3, description='2.23 customer release', major=2, minor=23, variation='C';
 </code> </code>
Line 195: Line 209:
 = Version 2.24 = = Version 2.24 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.24 customer release', major=2, minor=24, variation='C'; update version set identifier=3, description='2.24 customer release', major=2, minor=24, variation='C';
 </code> </code>
Line 202: Line 216:
 = Version 2.25 = = Version 2.25 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.25 customer release', major=2, minor=25, variation='C'; update version set identifier=3, description='2.25 customer release', major=2, minor=25, variation='C';
 </code> </code>
Line 209: Line 223:
 = Version 2.26 = = Version 2.26 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.26 customer release', major=2, minor=26, variation='B'; update version set identifier=3, description='2.26 customer release', major=2, minor=26, variation='B';
 </code> </code>
Line 216: Line 230:
 = Version 2.27 = = Version 2.27 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.27 customer release', major=2, minor=27, variation='B'; update version set identifier=3, description='2.27 customer release', major=2, minor=27, variation='B';
 </code> </code>
Line 223: Line 237:
 = Version 2.28 = = Version 2.28 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.28 customer release', major=2, minor=28, variation='C'; update version set identifier=3, description='2.28 customer release', major=2, minor=28, variation='C';
 </code> </code>
Line 230: Line 244:
 = Version 2.29 = = Version 2.29 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.29 customer release', major=2, minor=29, variation='B'; update version set identifier=3, description='2.29 customer release', major=2, minor=29, variation='B';
 </code> </code>
Line 237: Line 251:
 = Version 2.30 = = Version 2.30 =
  
-<code>+<code sql>
 -- version update -- version update
 update version set identifier=3, description='2.30 customer release', major=2, minor=30, variation='B'; update version set identifier=3, description='2.30 customer release', major=2, minor=30, variation='B';
Line 244: Line 258:
 = Version 2.31 = = Version 2.31 =
  
-<code> +<code sql
--- version upldate+-- version update
 update version set identifier=3, description='2.31 customer release', major=2, minor=31, variation='A'; update version set identifier=3, description='2.31 customer release', major=2, minor=31, variation='A';
 </code> </code>
Line 251: Line 265:
 = Version 2.32 = = Version 2.32 =
  
-<code>+<code sql>
 -- version update -- version update
 update version set identifier=3, description='2.32 customer release', major=2, minor=32, variation='A'; update version set identifier=3, description='2.32 customer release', major=2, minor=32, variation='A';
Line 258: Line 272:
 = Version 2.33 = = Version 2.33 =
  
-<code>+<code sql>
 -- version update -- version update
 update version set identifier=3, description='2.33 customer release', major=2, minor=33, variation='A'; update version set identifier=3, description='2.33 customer release', major=2, minor=33, variation='A';
 </code> </code>
  
podoc/version_sql_table.txt · Last modified: 2007/04/20 14:50 by Luud