Changes between Version 1 and Version 2 of TracDev/DatabaseSchema/VersionControl

Timestamp:

Feb 9, 2017, 11:29:41 PM (7 years ago)

Author:

Peter Suter

Comment:

Added auto-increment primary key and indices #3676

TracDev/DatabaseSchema/VersionControl

@@ -28 +28 @@
 == Table `revision`
 ||'''Table'''||'''Key'''||
-||''revision''||''repos'', ''rev'' (20)||
+||''revision''||''repos'', ''rev'' (40)||
 
 ||'''Columns'''||'''Type'''||'''Notes'''||
@@ -46 +46 @@
 == Table `node_change`
 ||'''Table'''||'''Key'''||
-||''node_change''||''repos'', ''rev'' (20), ''path'' (255), ''change_type'' (2)||
+||''node_change''||''id''||
 
 ||'''Columns'''||'''Type'''||'''Notes'''||
+||''id''||`auto_increment`|| Added in Trac 1.1.4 (see #3676) ||
 ||''repos''||`int`||Repository id that this revision belongs to||
-||''rev''|| ||Revision number that this change belongs to||
-||''path''|| ||Path of the affected file or directory||
+||''rev''||key_size=40||Revision number that this change belongs to||
+||''path''||key_size=255||Path of the affected file or directory||
 ||''node_type''||size=1||'F' for files, 'D' for directories||
 ||''change_type''||size=1||'A' for added, 'D' for deleted', 'M' for moved, 'C' for copied', 'E' for edited||
@@ -58 +59 @@
 
 ||'''Index'''||
-||''repos'', ''rev''||
+||''repos'', ''rev'', ''path''||
+||''repos'', ''path'', ''rev''||
 
 Part of the version control cache. Stores cached ''node changes'' of a revisions. A ''node change'' is a added, deleted, moved, copied or edited directory or file.