View Issue Details

IDProjectCategoryView StatusLast Update
0006949mantisbtfeaturepublic2006-04-18 10:17
Reporterlauploix Assigned To 
Status acknowledgedResolutionopen 
Product Version1.0.2 
Summary0006949: Add "id" column in tables that are mainly "n*n relation" tables but also have values (ie : project_user_list)

I would like to be able to map the tables with SQLObject, which is a python object/relational database mapping tool.

I have (talking about the 0.19 version of the database schema that I have)

  • No Pb with "value" tables (user, bug, project, ...)
  • No pb with relations tables (bug_monitor, ...)
  • But.... pb with tables that are relations AND contain value (project_user_list, custom_field_project)

The pb is : SQLObject needs to have and ID column (or equivalent) in any table that has a "value" (and not only external keys).

If it where possible to add an 'ID' column to tables that are mainly relations, but also have values, that would be :

  • Useless for Mantis itself
  • ...but sooooo useful for object-relational mappings

otherwise, we need to use plain SQL.

TagsNo tags attached.




2006-04-18 10:17

manager   ~0012610

It makes sense to add an id field to all our tables that don't have ones. Gradually it may make sense to use some of these ids in Mantis code as well.