r18432 - gnucash/trunk/src/backend/sql - Transaction post date also needs to allow NULL values.

[Phil Longstaff]

Author: plongstaff
Date: 2009-11-21 14:53:00 -0500 (Sat, 21 Nov 2009)
New Revision: 18432
Trac: http://svn.gnucash.org/trac/changeset/18432

Modified:
   gnucash/trunk/src/backend/sql/gnc-transaction-sql.c
Log:
Transaction post date also needs to allow NULL values.


Modified: gnucash/trunk/src/backend/sql/gnc-transaction-sql.c
===================================================================
--- gnucash/trunk/src/backend/sql/gnc-transaction-sql.c	2009-11-21 04:32:26 UTC (rev 18431)
+++ gnucash/trunk/src/backend/sql/gnc-transaction-sql.c	2009-11-21 19:53:00 UTC (rev 18432)
@@ -59,7 +59,7 @@
 /*@ unused @*/ static QofLogModule log_module = G_LOG_DOMAIN;
 
 #define TRANSACTION_TABLE "transactions"
-#define TX_TABLE_VERSION 2
+#define TX_TABLE_VERSION 3
 #define SPLIT_TABLE "splits"
 #define SPLIT_TABLE_VERSION 4
 
@@ -80,9 +80,9 @@
 			(QofAccessFunc)xaccTransGetCurrency, (QofSetterFunc)xaccTransSetCurrency },
     { "num",           CT_STRING,         TX_MAX_NUM_LEN,         COL_NNUL,          NULL, NULL,
 			(QofAccessFunc)xaccTransGetNum, (QofSetterFunc)xaccTransSetNum },
-    { "post_date",     CT_TIMESPEC,       0,                      COL_NNUL,          NULL, NULL,
+    { "post_date",     CT_TIMESPEC,       0,                      0,                 NULL, NULL,
 			(QofAccessFunc)xaccTransRetDatePostedTS, (QofSetterFunc)gnc_transaction_set_date_posted },
-    { "enter_date",    CT_TIMESPEC,       0,                      COL_NNUL,          NULL, NULL,
+    { "enter_date",    CT_TIMESPEC,       0,                      0,                 NULL, NULL,
 			(QofAccessFunc)xaccTransRetDateEnteredTS, (QofSetterFunc)gnc_transaction_set_date_entered },
     { "description",   CT_STRING,         TX_MAX_DESCRIPTION_LEN, 0,                 NULL, NULL,
             (QofAccessFunc)xaccTransGetDescription, (QofSetterFunc)xaccTransSetDescription },
@@ -472,8 +472,11 @@
 	version = gnc_sql_get_table_version( be, TRANSACTION_TABLE );
     if( version == 0 ) {
         (void)gnc_sql_create_table( be, TRANSACTION_TABLE, TX_TABLE_VERSION, tx_col_table );
-    } else if( version == 1 ) {
-		/* Upgrade 64 bit int handling */
+    } else if( version < TX_TABLE_VERSION ) {
+		/* Upgrade:
+		    1->2: 64 bit int handling
+			2->3: allow dates to be NULL
+		*/
 		gnc_sql_upgrade_table( be, TRANSACTION_TABLE, tx_col_table );
 		(void)gnc_sql_set_table_version( be, TRANSACTION_TABLE, TX_TABLE_VERSION );
     }