Changes between Version 7 and Version 8 of GenericTrac

Timestamp:

Sep 3, 2009, 6:14:32 PM (15 years ago)

Author:

Christian Boos

Comment:

summary of the model + example

GenericTrac

@@ -146 +146 @@
 
 The property changes themselves are stored in other tables.
+We only need the changed properties here, no need to store the old/new values
+for each change, as this can be deduced from the past changes.
+Deletions of fields should be represented by setting a field to the NULL value.
 
 Several possibilities here:
-'''ticket_change''
-|| ''id'' || ''changeid'' || ''name'' || ''value'' ||
-'''milestone_change''
-|| ''id'' || ''changeid'' || ''name'' || ''value'' ||
+
+'''ticket_change'''
+|| ''id'' || ''changeid'' || ''name'' || ''value'' ||
+
+'''milestone_change'''
+|| ''id'' || ''changeid'' || ''name'' || ''value'' ||
+
 or:
-'''resource_change''
+
+'''resource_change'''
 || ''id'' || ''changeid'' || ''name'' || ''value'' ||
 (surrogate key approach)
@@ -166 +173 @@
 
 See also ticket:6466#comment:10 and follow-ups for a discussion about how ticket changes and in particular ticket change edits, could be handled using this approach.
+
+== The Model ==
+
+To summarize the above discussion, here's what could be the new model.
+
+=== Minimal Model ===
+ - surrogate keys for all resources
+ - only text fields
+
+
+{{{
+#!div style="width: 30%; float: left"
+
+==== Schema ====
+
+'''resource_schema'''
+|| ''realm'' || ''prop'' || ''name'' || ''value'' ||
+
+'''resource_prop'''
+|| ''id'' || ''name'' || ''value'' ||
+
+'''resource_revprop'''
+|| ''changeid'' || ''name'' || ''value'' ||
+
+'''resource_change'''
+|| ''id'' || ''changeid'' || ''name'' || ''value'' ||
+}}}
+{{{
+#!div style="width: 60%; border: 2px dotted #ddd; padding: 0 0 1em 3em ; float: left;"
+
+==== Example Dataset ====
+
+'''resource_schema'''
+|| ''realm'' || ''prop''    || ''name'' || ''value'' ||
+|| ticket    || summary     || type     || text ||
+|| ticket    || description || type     || wiki||
+|| ticket    || reporter    || type     || text ||
+
+'''resource_prop'''
+|| ''id'' || ''name''  || ''value'' ||
+||      0 ||   id      ||   130     ||
+||      0 || summary   ||Multiple Project Support||
+||      0 ||description||One day... ||
+||      0 || reporter  ||   joe     ||
+
+'''resource_revprop'''
+|| ''changeid'' || ''name'' || ''value'' ||
+||          1   ||  author  ||    joe    ||
+||          1   ||   date   ||5 years ago||
+||          2   ||  author  ||    joe    ||
+||          2   ||   date   ||2 years ago||
+||          2   || comment  || come on...||
+||          3   ||  author  ||   cboos   ||
+||          3   ||   date   ||1 year ago ||
+||          3   || comment  || sure...   ||
+
+'''resource_change'''
+|| ''id'' || ''changeid'' || ''name''  || ''value'' ||
+||      0 ||          1   ||    id     ||130||
+||      0 ||          1   ||  summary  ||Multiple Project Support||
+||      0 ||          1   ||description||Should be easy...||
+||      0 ||          1   ||  reporter ||joe||
+||      0 ||          2   ||description||Should be easy... Redmine has it!||
+||      0 ||          3   ||description||One day...||
+}}}
+
+[[html(<br style="clear: both" />)]]