Version 4 (modified by 16 years ago) ( diff ) | ,
---|
Trac and SQLAlchemy
List of things to do
- trac/db/*backend.py files should ultimately be collapsed into one backend.py file
- trac/upgrades/db*.py files need upgrading to SQLAlchemy
- database schema needs a review, see MySQL fault later on the page
Tables
The current database schema has deficiencies.
- system table
- permission table
- auth_cookie table
- session table
- session_attribute table
- attachment table
- id is text, for ticket type it is a number, for wiki it is an unique text identifier
- wiki table
- revision table
- node_change table
- ticket table
- ticket_change table
- ticket_custom table
- enum table
- component table
- milestone table
- version table
- report table
Current problems:
MySQL initialization fails with:
OperationalError: (OperationalError) (1170, "BLOB/TEXT column 'rev' used in key specification without a key length") 'CREATE TABLE node_change (rev TEXT NOT NULL, path TEXT NOT NULL, node_type VARCHAR(1), change_type VARCHAR(1) NOT NULL, base_path TEXT, base_rev TEXT, PRIMARY KEY (rev, path, change_type))' {}
Note:
See TracWiki
for help on using the wiki.