[nhibernate-issues] [NHJIRA] Closed: (NH-2200) SchemaExport: include foreign keys in CREATE TABLE (for SQLite)

[Fabio M. (JIRA) <nh...@gm...>]

     [ http://216.121.112.228/browse/NH-2200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fabio Maulo closed NH-2200.
---------------------------

    Resolution: Obsolete

Fixed in revision 5543 by Patrick

> SchemaExport: include foreign keys in CREATE TABLE (for SQLite)
> ---------------------------------------------------------------
>
>                 Key: NH-2200
>                 URL: http://216.121.112.228/browse/NH-2200
>             Project:  NHibernate
>          Issue Type: Improvement
>          Components: DataProviders / Dialects
>    Affects Versions: 2.1.2.GA
>            Reporter: Matthew Gabeler-Lee
>
> Since newer versions of SQLite support foreign key enforcement, it would be nice if the schema export functionality in NHibernate could generate foreign key clauses when working with the SQLite dialect.
> Right now what's stopping this from being a trivial change to the SQLiteDialect class is that NHibernate only creates foreign keys with an ALTER TABLE statement, and SQLite doesn't support that.  If NHibernate supported including the foreign keys in the CREATE TABLE statement, then SQLite's foreign key support could be used.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira