Changes between Version 5 and Version 6 of TracSqlAlchemy
- Timestamp:
- Feb 22, 2015, 3:51:44 PM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracSqlAlchemy
v5 v6 1 = Trac and SQLAlchemy =1 = Trac and SQLAlchemy 2 2 3 == List of things to do == 3 Trac works with the [http://www.sqlalchemy.org/ SQLAlchemy] database wrapper. 4 5 == List of things to do 4 6 5 7 1. trac/db/*backend.py files should ultimately be collapsed into one backend.py file … … 8 10 1. database schema needs relations setup and especially separating out a 'user' table (helps with user provider architecture, e.g. LDAP) 9 11 10 == Tables ==12 == Tables 11 13 12 The current [source:sandbox/sqlalchemy-ng/trac/db/schema.py database schema]has deficiencies.14 The current database schema has deficiencies. 13 15 14 16 * '''system table''' … … 17 19 * '''session table''' 18 20 * '''session_attribute table''' 19 * '''attachment table''' 20 * id is text, for ticket type it is a number, for wiki it is an unique text identifier 21 * '''attachment table''': id is text, for ticket type it is a number, for wiki it is an unique text identifier 21 22 * '''wiki table''' 22 23 * '''revision table''' … … 31 32 * '''report table''' 32 33 33 Current problems: 34 == Known issues 34 35 35 MySQLinitialization fails with:36 When Trac is installed with MySQL, the initialization fails with: 36 37 {{{ 37 38 OperationalError: (OperationalError) (1170, "BLOB/TEXT column 'rev' used in key