Changes between Initial Version and Version 1 of GenericTrac

Timestamp:

Nov 30, 2006, 12:32:50 PM (17 years ago)

Author:

Christian Boos

Comment:

Experimental generic data model for Trac

GenericTrac

@@ +1 @@
+= GenericTrac Data Model = 
+
+This is an experimental branch for trying out the various ideas exposed in the recent proposals:
+ - TracDev/Proposals/DataModel
+ - TracDev/Proposals/Journaling
+
+See also [googlegroups:trac-dev:8cf3f5fe0e476ce5 this mail].
+
+
+== Current Status ==
+
+=== TODO ===
+ - modify the Milestone module so that it uses the new proposed datamodel. See [#TheMilestoneExample].
+ - experiment new tabbed view for the milestone (''View'', ''Discussion'', ''History''). See TracProject/UiGuidelines.
+ - milestone should be able to have attachments, too (#3068)
+ - adapt the Roadmap module to the new model
+ - adapt the Milestone admin component to the new model
+
+Once this is complete, validate the genericity by promoting the components to be first class resources as well (#1233).
+
+
+Working on the generic aspect of Trac should also make it possible to implement various ''generic'' operations on Trac resources as plugins, mainly being able to (re-)implement TracCrossReferences as a plugin.
+
+
+=== DONE ===
+ - ''Not yet started''
+
+== The Milestone Example ==
+
+The proposed data model would be:
+{{{
+#!sql
+-- record Milestone current properties
+-- 
+create table milestone_prop (
+ id    text,
+ name  text,
+ value text
+);
+
+create index milestone_idx on milestone_prop (id, name);
+
+-- record Milestone change metadata
+--
+create table milestone_journal (
+ tid            int primary key,
+ date           int,
+ authname       text,
+ author         text,
+ ip             text,
+ authenticated  int
+);
+
+create index milestone_date_idx on milestone_journal ( date );
+create index milestone_authname_idx on milestone_journal ( authname, authenticated );
+
+-- record Milestone changed properties
+--
+create table milestone_history (
+ tid   int,
+ id    text,
+ name  text,
+ value text,
+ unique (tid, id)
+);
+}}}
+
+The existing `milestone` table can be kept, it will simply not be used anymore.
+This will allow to test the branch within existing environments.