Edgewall Software

Changes between Version 6 and Version 7 of TracSqlAlchemy


Ignore:
Timestamp:
Feb 28, 2015, 10:01:50 AM (9 years ago)
Author:
figaro
Comment:

Added trac-hacks link

Legend:

Unmodified
Added
Removed
Modified
  • TracSqlAlchemy

    v6 v7  
    11= Trac and SQLAlchemy
    22
    3 Trac works with the [http://www.sqlalchemy.org/ SQLAlchemy] database wrapper.
     3Trac works with the [http://www.sqlalchemy.org/ SQLAlchemy] database wrapper. Instructions for installing and using SQLAlchemy are listed at th:SqlAlchemyQueryMacro.
    44
    55== List of things to do
     
    88 1. trac/upgrades/db*.py files need upgrading to SQLAlchemy
    99 1. database schema needs a review, see MySQL fault later on the page
    10  1. database schema needs relations setup and especially separating out a 'user' table (helps with user provider architecture, e.g. LDAP)
     10 1. database schema needs relations setup and especially separating out a 'user' table, helps with user provider architecture, eg LDAP
    1111
    1212== Tables
     
    1414The current database schema has deficiencies.
    1515
    16  * '''system table'''
    17  * '''permission table'''
    18  * '''auth_cookie table'''
    19  * '''session table'''
    20  * '''session_attribute table'''
    21  * '''attachment table''': id is text, for ticket type it is a number, for wiki it is an unique text identifier
    22  * '''wiki table'''
    23  * '''revision table'''
    24  * '''node_change table'''
    25  * '''ticket table'''
    26  * '''ticket_change table'''
    27  * '''ticket_custom table'''
    28  * '''enum table'''
    29  * '''component table'''
    30  * '''milestone table'''
    31  * '''version table'''
    32  * '''report table'''
     16 * system table
     17 * permission table
     18 * auth_cookie table
     19 * session table
     20 * session_attribute table
     21 * attachment table: id is text, for ticket type it is a number, for wiki it is an unique text identifier
     22 * wiki table
     23 * revision table
     24 * node_change table
     25 * ticket table
     26 * ticket_change table
     27 * ticket_custom table
     28 * enum table
     29 * component table
     30 * milestone table
     31 * version table
     32 * report table
    3333
    3434== Known issues