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 12:47] 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 upldate+-- 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';
 </code> </code>
Line 83: Line 97:
 = Version 2.8 = = Version 2.8 =
  
-<code> +<code sql
--- version upldate+-- 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';
 </code> </code>
Line 90: Line 104:
 = Version 2.9 = = Version 2.9 =
  
-<code> +<code sql
--- version upldate+-- 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';
 +</code>
 +
 += Version 2.10 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.10 customer release', major=2, minor=10, variation='C';
 +</code>
 +
 += Version 2.11 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.11 customer release', major=2, minor=11, variation='C';
 +</code>
 +
 += Version 2.12 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.12 customer release', major=2, minor=12, variation='C';
 +</code>
 +
 += Version 2.13 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.13 customer release', major=2, minor=13, variation='C';
 +</code>
 +
 += Version 2.14 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.14 customer release', major=2, minor=14, variation='C';
 +</code>
 +
 += Version 2.15 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.15 customer release', major=2, minor=15, variation='C';
 +</code>
 +
 += Version 2.16 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.16 customer release', major=2, minor=16, variation='C';
 +</code>
 +
 += Version 2.17 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.17 customer release', major=2, minor=17, variation='C';
 +</code>
 +
 += Version 2.18 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.18 customer release', major=2, minor=18, variation='C';
 +</code>
 +
 += Version 2.19 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.19 customer release', major=2, minor=19, variation='C';
 +</code>
 +
 += Version 2.20 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.20 customer release', major=2, minor=20, variation='C';
 +</code>
 +
 += Version 2.21 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.21 customer release', major=2, minor=21, variation='C';
 +</code>
 +
 += Version 2.22 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.22 customer release', major=2, minor=22, variation='C';
 +</code>
 +
 += Version 2.23 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.23 customer release', major=2, minor=23, variation='C';
 +</code>
 +
 += Version 2.24 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.24 customer release', major=2, minor=24, variation='C';
 +</code>
 +
 += Version 2.25 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.25 customer release', major=2, minor=25, variation='C';
 +</code>
 +
 += Version 2.26 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.26 customer release', major=2, minor=26, variation='B';
 +</code>
 +
 += Version 2.27 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.27 customer release', major=2, minor=27, variation='B';
 +</code>
 +
 += Version 2.28 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.28 customer release', major=2, minor=28, variation='C';
 +</code>
 +
 += Version 2.29 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.29 customer release', major=2, minor=29, variation='B';
 +</code>
 +
 += Version 2.30 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.30 customer release', major=2, minor=30, variation='B';
 +</code>
 +
 += Version 2.31 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.31 customer release', major=2, minor=31, variation='A';
 +</code>
 +
 += Version 2.32 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.32 customer release', major=2, minor=32, variation='A';
 +</code>
 +
 += Version 2.33 =
 +
 +<code sql>
 +-- version update
 +update version set identifier=3, description='2.33 customer release', major=2, minor=33, variation='A';
 </code> </code>
  
podoc/version_sql_table.1176727656.txt.gz · Last modified: 2007/04/16 12:47 by Luud