[sqlite] Feature request: compile-time foreign keys setting (patch attached)

[WClark]

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