r18252 - gnucash/trunk/src/backend/sql - Fix bug 591614: Saving to postgresql causes zombie scheduled transactions.

[Phil Longstaff]

Author: plongstaff
Date: 2009-08-15 17:09:47 -0400 (Sat, 15 Aug 2009)
New Revision: 18252
Trac: http://svn.gnucash.org/trac/changeset/18252

Modified:
   gnucash/trunk/src/backend/sql/gnc-schedxaction-sql.c
Log:
Fix bug 591614: Saving to postgresql causes zombie scheduled transactions.

SX end date was not being stored.  It is now stored.

NOTE: This is a change in the db table schema.  You need to save your data to XML, then resave
to the database.


Modified: gnucash/trunk/src/backend/sql/gnc-schedxaction-sql.c
===================================================================
--- gnucash/trunk/src/backend/sql/gnc-schedxaction-sql.c	2009-08-15 21:08:39 UTC (rev 18251)
+++ gnucash/trunk/src/backend/sql/gnc-schedxaction-sql.c	2009-08-15 21:09:47 UTC (rev 18252)
@@ -71,6 +71,8 @@
 	{ "enabled",           CT_BOOLEAN, 0,               COL_NNUL,          NULL, NULL,
 			(QofAccessFunc)xaccSchedXactionGetEnabled, (QofSetterFunc)xaccSchedXactionSetEnabled },
     { "start_date",        CT_GDATE,   0,               COL_NNUL,          NULL, GNC_SX_START_DATE },
+    { "end_date",          CT_GDATE,   0,               0,                 NULL, NULL,
+			(QofAccessFunc)xaccSchedXactionGetEndDate, (QofSetterFunc)xaccSchedXactionSetEndDate },
     { "last_occur",        CT_GDATE,   0,               0,                 NULL, GNC_SX_LAST_DATE },
     { "num_occur",         CT_INT,     0,               COL_NNUL,          NULL, GNC_SX_NUM_OCCUR },
     { "rem_occur",         CT_INT,     0,               COL_NNUL,          NULL, GNC_SX_REM_OCCUR },