Changes between Version 19 and Version 20 of SimpleMultiProjectPlugin

Timestamp:

Jun 14, 2012, 8:19:14 AM (12 years ago)

Author:

falkb

Comment:

technical approach explained in a few sentences

SimpleMultiProjectPlugin

@@ -16 +16 @@
 == Technical thoughts ==
 
-This plugin adds two new tables to the db:
+This plugin adds a new ressource 'project' implemented by database table:
  1. smp_project: a list of all defined projects
+Actually, most database tables of Trac core related to ressources would need a new column 'project_id'. This way tickets, components, milestones, versions or even wikis could attach to certain projects. Since a plugin just adds stuff but cannot change the core structure, it implements the new dimension 'project' not by adding a new column to each ressource table but rather by adding several mapping tables smp_[ressource]_project, each one mapping a certain ressource to projects:
  2. smp_milestone_project: the association of milestones to projects
+ 3. smp_version_project:   the association of versions to projects
+ 4. smp_component_project: the association of components to projects
 
 == Example ==