Hello,

SysCache seems to have broken my taxonmy tables, I am getting exceptions when trying to modify taxonomies or a query using taxonomy field as filter.

As I have already dozens of contents created using taxonomies, I will try to repair the database where seems that a record is missing.

New to Orchard, I am not used to NHibernate but fluent on SLQ Server.

Before diving into the code, I would appreciate some indications on the place where I could find the information used by NHibernate to create tables and links between these tables.

From a first look, I see that NHibernate does not generate external keys to link tables ? 

Is there any naming convention in the column names which could also help in relating tables ?

Thanks for help.

CS

That information, including instructions to create foreign keys, can be found in Migrations.cs files.

Finally I found a small bug in Taxonomies' TermPart.cs and reported it.