r17503 - gnucash/trunk/src/backend/sql - Remove constraint that lot.account_guid must not be null. Unfortunately,

[Phil Longstaff]

Author: plongstaff
Date: 2008-09-12 22:05:09 -0400 (Fri, 12 Sep 2008)
New Revision: 17503
Trac: http://svn.gnucash.org/trac/changeset/17503

Modified:
   gnucash/trunk/src/backend/sql/gnc-lots-sql.c
Log:
Remove constraint that lot.account_guid must not be null.  Unfortunately,
sqlite doesn't support ALTER TABLE which modifies column constraints, so
existing databases can't be modified programmatically.



Modified: gnucash/trunk/src/backend/sql/gnc-lots-sql.c
===================================================================
--- gnucash/trunk/src/backend/sql/gnc-lots-sql.c	2008-09-11 06:58:23 UTC (rev 17502)
+++ gnucash/trunk/src/backend/sql/gnc-lots-sql.c	2008-09-13 02:05:09 UTC (rev 17503)
@@ -50,7 +50,7 @@
 static const GncSqlColumnTableEntry col_table[] =
 {
     { "guid",         CT_GUID,    0, COL_NNUL|COL_PKEY, "guid" },
-    { "account_guid", CT_GUID,    0, COL_NNUL,          NULL, NULL, get_lot_account,   set_lot_account },
+    { "account_guid", CT_GUID,    0, 0,                 NULL, NULL, get_lot_account,   set_lot_account },
     { "is_closed",    CT_BOOLEAN, 0, COL_NNUL,          NULL, NULL,
 		(QofAccessFunc)gnc_lot_is_closed, (QofSetterFunc)set_lot_is_closed },
     { NULL }