Trac and SQLAlchemy

The current database schema has deficiencies.

Tables

• 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