gnucash maint: Bug 784623 - GNUCash does not work with sql backend, I can open...

[John Ralls]

Updated	 via  https://github.com/Gnucash/gnucash/commit/e88f31e0 (commit)
	from  https://github.com/Gnucash/gnucash/commit/0c433e02 (commit)



commit e88f31e05cd57ba6fcc07563d98fb55c5310d25d
Author: John Ralls <jralls at ceridwen.us>
Date:   Fri Jul 19 21:20:43 2019 -0700

    Bug 784623 - GNUCash does not work with sql backend, I can open...
    
    in read only mode
    
    Upgrade the splits table as well, an oversight from the original fix.

diff --git a/libgnucash/backend/sql/gnc-transaction-sql.cpp b/libgnucash/backend/sql/gnc-transaction-sql.cpp
index fce7f6c5c..47e4c615c 100644
--- a/libgnucash/backend/sql/gnc-transaction-sql.cpp
+++ b/libgnucash/backend/sql/gnc-transaction-sql.cpp
@@ -70,7 +70,7 @@ static QofLogModule log_module = G_LOG_DOMAIN;
 #define TRANSACTION_TABLE "transactions"
 #define TX_TABLE_VERSION 4
 #define SPLIT_TABLE "splits"
-#define SPLIT_TABLE_VERSION 4
+#define SPLIT_TABLE_VERSION 5
 
 struct split_info_t : public write_objects_t
 {
@@ -456,7 +456,9 @@ GncSqlSplitBackend::create_tables (GncSqlBackend* sql_be)
 
         /* Upgrade:
            1->2: 64 bit int handling
-           3->4: Split reconcile date can be NULL */
+           3->4: Split reconcile date can be NULL
+           4->5: Use DATETIME instead of TIMESTAMP in MySQL
+        */
         sql_be->upgrade_table(m_table_name.c_str(), split_col_table);
         if (!sql_be->create_index("splits_tx_guid_index",
                                    m_table_name.c_str(),



Summary of changes:
 libgnucash/backend/sql/gnc-transaction-sql.cpp | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)