NHibernate: how to control Delete Rule and Update Rule in a foreign key when using SchemaExport

If in your project you let NHibernate generate the database from the information you provide with the schema mappings (a thing extremely useful, especially for testing cause you can build up the database in engines like SQLite), sometimes you m...