Hi,
I hope I'm not duplicating a request already made by someone, but it'd be
great if the foreign keys flag can be set as a compile option (like the
recursive triggers flag).
As a simple patch that I hope can be merged into the next release (made
against the sources for 3.6.21)...
diff U3 main.c main.c
--- main.c Fri Dec 11 10:51:37 2009
+++ main.c Fri Dec 11 10:44:06 2009
@@ -1603,6 +1603,9 @@
#if SQLITE_DEFAULT_RECURSIVE_TRIGGERS
| SQLITE_RecTriggers
#endif
+#if SQLITE_DEFAULT_FOREIGN_KEYS
+ | SQLITE_ForeignKeys
+#endif
;
sqlite3HashInit(&db->aCollSeq);
#ifndef SQLITE_OMIT_VIRTUALTABLE
diff U3 sqliteInt.h sqliteInt.h
--- sqliteInt.h Fri Dec 11 10:51:37 2009
+++ sqliteInt.h Fri Dec 11 10:44:09 2009
@@ -357,6 +357,10 @@
# define SQLITE_DEFAULT_RECURSIVE_TRIGGERS 0
#endif
+#ifndef SQLITE_DEFAULT_FOREIGN_KEYS
+# define SQLITE_DEFAULT_FOREIGN_KEYS 0
+#endif
+
/*
** Provide a default value for SQLITE_TEMP_STORE in case it is not
specified
** on the command-line
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
