[anjuta] symbol-db: support for libgda 4.1.x.

[Massimo Cora' <mcora src gnome org>]

commit 739c9b29598d2ce441bb210e2b0168e9b9077d6c
Author: Massimo Corà <mcora src gnome org>
Date:   Thu Dec 17 00:32:11 2009 +0100

    symbol-db: support for libgda 4.1.x.
    
    Foreign key are disabled by default. The right thing to do is to manage them instead.
    Maybe in a future they'll be enforced.

 plugins/symbol-db/symbol-db-engine-core.c |    1 +
 plugins/symbol-db/tables.sql              |    4 +++-
 2 files changed, 4 insertions(+), 1 deletions(-)
---
diff --git a/plugins/symbol-db/symbol-db-engine-core.c b/plugins/symbol-db/symbol-db-engine-core.c
index c3e6fc4..8915532 100644
--- a/plugins/symbol-db/symbol-db-engine-core.c
+++ b/plugins/symbol-db/symbol-db-engine-core.c
@@ -2784,6 +2784,7 @@ sdb_engine_set_defaults_db_parameters (SymbolDBEngine * dbe)
 	sdb_engine_execute_unknown_sql (dbe, "PRAGMA temp_store = MEMORY");	
 	sdb_engine_execute_unknown_sql (dbe, "PRAGMA journal_mode = OFF");
 	sdb_engine_execute_unknown_sql (dbe, "PRAGMA read_uncommitted = 1");
+	sdb_engine_execute_unknown_sql (dbe, "PRAGMA foreign_keys = OFF");
 	symbol_db_engine_set_db_case_sensitive (dbe, TRUE);
 }
 
diff --git a/plugins/symbol-db/tables.sql b/plugins/symbol-db/tables.sql
index 999a9c7..9540083 100644
--- a/plugins/symbol-db/tables.sql
+++ b/plugins/symbol-db/tables.sql
@@ -1,5 +1,6 @@
 
--- FOREIGN keys are not supported. http://www.sqlite.org/omitted.html
+-- FIXME: FOREIGN keys are now supported. schema should enforces them.
+-- Right now the support here is disabled.
 
 CREATE TABLE workspace (workspace_id integer PRIMARY KEY AUTOINCREMENT,
                         workspace_name varchar (50) not null unique,
@@ -151,3 +152,4 @@ PRAGMA temp_store = MEMORY;
 PRAGMA case_sensitive_like = 1;
 PRAGMA journal_mode = OFF;
 PRAGMA read_uncommitted = 1;
+PRAGMA foreign_keys = OFF;