Edgewall Software

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


Ignore:
Timestamp:
Feb 9, 2017, 11:29:41 PM (3 years ago)
Author:
Peter Suter
Comment:

Added auto-increment primary key and indices #3676

Legend:

Unmodified
Added
Removed
Modified
  • TracDev/DatabaseSchema/VersionControl

    v1 v2  
    2828== Table `revision`
    2929||'''Table'''||'''Key'''||
    30 ||''revision''||''repos'', ''rev'' (20)||
     30||''revision''||''repos'', ''rev'' (40)||
    3131
    3232||'''Columns'''||'''Type'''||'''Notes'''||
     
    4646== Table `node_change`
    4747||'''Table'''||'''Key'''||
    48 ||''node_change''||''repos'', ''rev'' (20), ''path'' (255), ''change_type'' (2)||
     48||''node_change''||''id''||
    4949
    5050||'''Columns'''||'''Type'''||'''Notes'''||
     51||''id''||`auto_increment`|| Added in Trac 1.1.4 (see #3676) ||
    5152||''repos''||`int`||Repository id that this revision belongs to||
    52 ||''rev''|| ||Revision number that this change belongs to||
    53 ||''path''|| ||Path of the affected file or directory||
     53||''rev''||key_size=40||Revision number that this change belongs to||
     54||''path''||key_size=255||Path of the affected file or directory||
    5455||''node_type''||size=1||'F' for files, 'D' for directories||
    5556||''change_type''||size=1||'A' for added, 'D' for deleted', 'M' for moved, 'C' for copied', 'E' for edited||
     
    5859
    5960||'''Index'''||
    60 ||''repos'', ''rev''||
     61||''repos'', ''rev'', ''path''||
     62||''repos'', ''path'', ''rev''||
    6163
    6264Part 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.