Changes between Version 6 and Version 7 of TracSqlAlchemy
- Timestamp:
- Feb 28, 2015, 10:01:50 AM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracSqlAlchemy
v6 v7 1 1 = Trac and SQLAlchemy 2 2 3 Trac works with the [http://www.sqlalchemy.org/ SQLAlchemy] database wrapper. 3 Trac works with the [http://www.sqlalchemy.org/ SQLAlchemy] database wrapper. Instructions for installing and using SQLAlchemy are listed at th:SqlAlchemyQueryMacro. 4 4 5 5 == List of things to do … … 8 8 1. trac/upgrades/db*.py files need upgrading to SQLAlchemy 9 9 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 11 11 12 12 == Tables … … 14 14 The current database schema has deficiencies. 15 15 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 identifier22 * '''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 33 33 34 34 == Known issues