Edgewall Software
Home
Trac
Trac Hacks
Genshi
Babel
Bitten
Home
Download
Documentation
Mailing Lists
License
FAQ
Search:
Login
Preferences
Help/Guide
About Trac
Wiki
Timeline
Roadmap
Browse Source
View Tickets
New Ticket
Search
Context Navigation
+1
Start Page
Index
History
Editing TracSqlAlchemy
Adjust edit area height:
8
12
16
20
24
28
32
36
40
Edit side-by-side
= Trac and SQLAlchemy = == List of things to do == 1. trac/db/*backend.py files should ultimately be collapsed into one backend.py file 1. trac/upgrades/db*.py files need upgrading to SQLAlchemy 1. database schema needs a review, see MySQL fault later on the page == Tables == The current [source:sandbox/sqlalchemy-ng/trac/db/schema.py 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
WikiFormatting
and
TracWiki
for help on editing wiki content.
Change information
Your email or username:
E-mail address and name can be saved in the
Preferences
Comment about this change (optional):
Note:
See
TracWiki
for help on using the wiki.