Another option is to take a look at the file that actually defines the db schema:
http://trac.edgewall.org/browser/branches/0.12-stable/trac/db_default.py Tables, columns, keys and indexes come pretty well out of their object definitions. Ciao, Roberto 2012/3/22 Peter Suter <[email protected]> > On 22.03.2012 19:52, Marissa G wrote: > >> Awesome! How can I get a list of tables, fields ... db schema? (pardon >> my ignorance, I am VERY new to Trac!) >> >> > There some documentation at: > http://trac.edgewall.org/wiki/**TracDev/DatabaseSchema<http://trac.edgewall.org/wiki/TracDev/DatabaseSchema> > > If your Trac installation is running on SQLite you could also create a > report that lists the known table names and the SQL statements that were > used to create them (where you can see the fields): > > SELECT name, sql > FROM sqlite_master > WHERE type='table' > > > -- > You received this message because you are subscribed to the Google Groups > "Trac Users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to trac-users+unsubscribe@** > googlegroups.com <trac-users%[email protected]>. > For more options, visit this group at http://groups.google.com/** > group/trac-users?hl=en <http://groups.google.com/group/trac-users?hl=en>. > > -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
