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 revision Previous revision
podoc:version_sql_table [2007/04/16 09:25]
Luud
podoc:version_sql_table [2007/04/20 10: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 update -- 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';​
Line 118: Line 132:
 = Version 2.13 = = Version 2.13 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 125: Line 139:
 = Version 2.14 = = Version 2.14 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 132: Line 146:
 = Version 2.15 = = Version 2.15 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 139: Line 153:
 = Version 2.16 = = Version 2.16 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 146: Line 160:
 = Version 2.17 = = Version 2.17 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 153: Line 167:
 = Version 2.18 = = Version 2.18 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 160: Line 174:
 = Version 2.19 = = Version 2.19 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 167: Line 181:
 = Version 2.20 = = Version 2.20 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 174: Line 188:
 = Version 2.21 = = Version 2.21 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 181: Line 195:
 = Version 2.22 = = Version 2.22 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 188: Line 202:
 = Version 2.23 = = Version 2.23 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 195: Line 209:
 = Version 2.24 = = Version 2.24 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 202: Line 216:
 = Version 2.25 = = Version 2.25 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 209: Line 223:
 = Version 2.26 = = Version 2.26 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 216: Line 230:
 = Version 2.27 = = Version 2.27 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 223: Line 237:
 = Version 2.28 = = Version 2.28 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
Line 230: Line 244:
 = Version 2.29 = = Version 2.29 =
  
-<​code>​+<​code ​sql>
 -- version update -- 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';​
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 update -- 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';​
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 10:50 by Luud