Schema for the trac database

I used sage to pull this out of the SQL database.

• system
  • name text
  • value text
  • sqlite_autoindex_system_1 (index info)
• permission
  • username text
  • action text
  • sqlite_autoindex_permission_1 (index info)
• auth_cookie
  • cookie text
  • name text
  • ipnr text
  • time integer
  • sqlite_autoindex_auth_cookie_1 (index info)
• session
  • sid text
  • authenticated integer
  • last_visit integer
  • session_authenticated_idx (index info)
  • session_last_visit_idx (index info)
  • sqlite_autoindex_session_1 (index info)
• session_attribute
  • sid text
  • authenticated integer
  • name text
  • value text
  • sqlite_autoindex_session_attribute_1 (index info)
• attachment
  • type text
  • id text
  • filename text
  • size integer
  • time integer
  • description text
  • author text
  • ipnr text
  • sqlite_autoindex_attachment_1 (index info)
• wiki
  • name text
  • version integer
  • time integer
  • author text
  • ipnr text
  • text text
  • comment text
  • readonly integer
  • wiki_time_idx (index info)
  • sqlite_autoindex_wiki_1 (index info)
• revision
  • repos integer
  • rev text
  • time integer
  • author text
  • message text
  • revision_time_idx (index info)
  • revision_pk (index info)
• node_change
  • rev text
  • path text
  • node_type text
  • change_type text
  • base_path text
  • base_rev text
  • node_change_rev_idx (index info)
  • sqlite_autoindex_node_change_1 (index info)
• ticket
  • id integer
  • type text
  • time integer
  • changetime integer
  • component text
  • severity text
  • priority text
  • owner text
  • reporter text
  • cc text
  • version text
  • milestone text
  • status text
  • resolution text
  • summary text
  • description text
  • keywords text
  • ticket_status_idx (index info)
  • ticket_time_idx (index info)
• ticket_change
  • ticket integer
  • time integer
  • author text
  • field text
  • oldvalue text
  • newvalue text
  • ticket_change_time_idx (index info)
  • ticket_change_ticket_idx (index info)
  • sqlite_autoindex_ticket_change_1 (index info)
• ticket_custom
  • ticket integer
  • name text
  • value text
  • sqlite_autoindex_ticket_custom_1 (index info)
• enum
  • type text
  • name text
  • value text
  • sqlite_autoindex_enum_1 (index info)
• component
  • name text
  • owner text
  • description text
  • sqlite_autoindex_component_1 (index info)
• milestone
  • name text
  • due integer
  • completed integer
  • description text
  • sqlite_autoindex_milestone_1 (index info)
• version
  • name text
  • time integer
  • description text
  • sqlite_autoindex_version_1 (index info)
• report
  • id integer
  • author text
  • title text
  • query text
  • description text