On Friday, December 11, 2015 at 12:48:12 PM UTC-8, Ahmed M. wrote: > > I am using MySQL database 5.7.9 with trac 1.0.9. When I created an > environment using trac-admin the database is created and everything seems > to be working just fine. > However, when I looked at the database using MySQL workbench (6.3.5 build > 201 CE - 64bit) I don't see any foreign keys in the entire database. > I didn't notice in abnormal functionality, however this doesn't look right > to me. >
There are no foreign keys in the database. Here are some resources discussing the issue: * http://trac.edgewall.org/ticket/826 * http://trac.edgewall.org/wiki/TracDev/DatabaseSchema#DatabaseSchemaTrac0.12 * http://trac.edgewall.org/browser/trunk/trac/db_default.py The Trac data model could benefit from some improvements, but that's in the realm of future aims such as: http://trac.edgewall.org/wiki/GenericTrac/Brainstorm - Ryan -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/trac-users. For more options, visit https://groups.google.com/d/optout.
