Changes between Version 10 and Version 11 of GenericTrac

Timestamp:

Sep 4, 2009, 7:57:33 AM (15 years ago)

Author:

Christian Boos

Comment:

the #CompleteModel puts short text in _string tables and keep long text in the same tables as the other models

GenericTrac

@@ -74 +74 @@
 (if we use one mega table for all resources)
 
+Note by the way that newer "resources", like `repository` in MultiRepos already have this `(id,name/value)` form.
+
 We could also keep the metadata associated to the properties in the database,
-instead of being hard-coded and present in the TracIni file.
+instead of being hard-coded and present in the TracIni file, permitting an
+unification of the representation for fixed fields and custom fields.
 
 '''resource_schema'''
@@ -90 +93 @@
 || ticket || need_review || default || 0 ||
 
+Note: the existence of a schema describing the fields doesn't mean that modules
+can't interpret fields as being special. Quite the opposite, as modules are what
+provides the real "behavior" of resources.
 
 As a possible refining, it could be possible to have specialized tables, 
@@ -253 +259 @@
 === Intermediate Model ===
  - surrogate keys for all resources
- - text and int fields (same as Complete Model, without `*_text` tables)
-
-The minimal model above is handy for showing the essence of the new model,
+ - text and int fields (same as [#CompleteModel Complete Model], without the `*_string` tables)
+
+The [#MinimalModel minimal model] above is handy for showing the essence of the new model,
 but it's too simple in practice.
 
-I think we need at the very least to support 'integer' type columns, useful for storing dates efficiently, boolean values, and relations to other resources (as the surrogate id will be an integer).
+I think we need at the very least to support 'integer' type columns, useful for storing dates efficiently, boolean values, and relations to other resources (as the surrogate ''id''s will be integers).
 
 
@@ -279 +285 @@
 '''resource_prop'''
 || ''id'' || ''name'' || ''value'' ||
+||  int   ||   string ||    text   ||
+
+'''resource_revprop'''
+|| ''changeid'' || ''name'' || ''value'' ||
+||      int     ||   string ||    text   ||
+
+'''resource_change'''
+|| ''id'' || ''changeid'' || ''name'' || ''value'' ||
+||   int  ||      int     ||   string ||    text   ||
+
+
+'''resource_prop_string'''
+|| ''id'' || ''name'' || ''value'' ||
 ||  int   ||   string ||   string  ||
 
-'''resource_revprop'''
+'''resource_revprop_string'''
 || ''changeid'' || ''name'' || ''value'' ||
 ||      int     ||   string ||   string  ||
 
-'''resource_change'''
+'''resource_change_string'''
 || ''id'' || ''changeid'' || ''name'' || ''value'' ||
 ||   int  ||      int     ||   string ||   string  ||
-
-
-'''resource_prop_text'''
-|| ''id'' || ''name'' || ''value'' ||
-||  int   ||   string ||   text    ||
-
-'''resource_revprop_text'''
-|| ''changeid'' || ''name'' || ''value'' ||
-||      int     ||   string ||   text    ||
-
-'''resource_change_text'''
-|| ''id'' || ''changeid'' || ''name'' || ''value'' ||
-||   int  ||      int     ||   string ||   text    ||
 
 
@@ -331 +337 @@
 '''resource_prop'''
 || ''id'' || ''name''  || ''value'' ||
-||      0 || reporter  ||   joe     ||
-
-'''resource_revprop'''
-|| ''changeid'' || ''name'' || ''value'' ||
-||          1   ||  author  ||    joe    ||
-||          2   ||  author  ||    joe    ||
-||          3   ||  author  ||   cboos   ||
-
-'''resource_change'''
-|| ''id'' || ''changeid'' || ''name''  || ''value'' ||
-||      0 ||          1   ||  reporter ||joe||
-
-----
-
-'''resource_prop_text'''
-|| ''id'' || ''name''  || ''value'' ||
 ||      0 || summary   ||Multiple Project Support||
 ||      0 ||description||One day... ||
 
-'''resource_revprop_text'''
+'''resource_revprop'''
 || ''changeid'' || ''name'' || ''value'' ||
 ||          2   || comment  || come on...||
 ||          3   || comment  || sure...   ||
 
-'''resource_change_text'''
+'''resource_change'''
 || ''id'' || ''changeid'' || ''name''  || ''value'' ||
 ||      0 ||          1   ||  summary  ||Multiple Project Support||
@@ -364 +354 @@
 ----
 
+'''resource_prop_string'''
+|| ''id'' || ''name''  || ''value'' ||
+||      0 || reporter  ||   joe     ||
+
+'''resource_revprop_string'''
+|| ''changeid'' || ''name'' || ''value'' ||
+||          1   ||  author  ||    joe    ||
+||          2   ||  author  ||    joe    ||
+||          3   ||  author  ||   cboos   ||
+
+'''resource_change_string'''
+|| ''id'' || ''changeid'' || ''name''  || ''value'' ||
+||      0 ||          1   ||  reporter ||joe||
+
+----
+
 '''resource_prop_int'''
 || ''id'' || ''name''  || ''value'' ||
@@ -386 +392 @@
 
 === Milestone First ===
- - modify the Milestone module so that it uses the new proposed datamodel. See [#TheMilestoneExample].
+ - modify the Milestone module so that it uses the new proposed datamodel.
  - experiment new tabbed view for the milestone (''View'', ''Discussion'', ''History''). See TracProject/UiGuidelines.
  - milestone should be able to have attachments, too (#3068)