Generate add/drop foreign key migration statements

Also add the --fkeys-deferrable-mode option. General schemas generation
rework.

1 files changed, 8 insertions, 0 deletions

diff --git a/NEWS b/NEWS
index c6b2db3..899267c 100644
--- a/NEWS
+++ b/NEWS
@@ -4,6 +4,14 @@ Version 2.3.0
    queries. For more information, refer to Section 4.1, "ODB Query Language"
    in the ODB manual.
 
+ * New option, --fkeys-deferrable-mode, specifies the alternative deferrable
+   mode for foreign keys. By default, the ODB compiler generates deferred
+   foreign keys for databases that support them (SQLite, PostgreSQL, and
+   Oracle) and comments the foreign keys out for database that don't (MySQL
+   and SQL Server). This option can be used to override this behavior. Refer
+   to the ODB compiler command line interface documentation (man pages) for
+   details.
+
  * New SQLite-specific exception, odb::sqlite::forced_rollback, which is
    thrown if SQLite forces a transaction to roll back. For more information,
    refer to Section 16.5.6, "Forced Rollback".