The unified diff between revisions [8e272dc5..] and [3940066f..] is displayed below. It can also be downloaded as a raw diff.

This diff has been restricted to the following files: 'SQLTemplates.py'

#
#
# patch "SQLTemplates.py"
#  from [edba5829d9ce5a6327a26c29a0cf88933f3e362c]
#    to [819862410d7d14aea08e6d162e6d15c964556089]
#
============================================================
--- SQLTemplates.py	edba5829d9ce5a6327a26c29a0cf88933f3e362c
+++ SQLTemplates.py	819862410d7d14aea08e6d162e6d15c964556089
@@ -8,3 +8,9 @@ create_fourstar_db['LEDGER'] = "CREATE T
 create_fourstar_db['CHART'] = "CREATE TABLE CHART ( accountid integer primary key autoincrement, details text, debitbalance boolean, info text)"
 create_fourstar_db['JOURNAL'] = "CREATE TABLE JOURNAL ( journalid integer primary key autoincrement, date text explanation text, postref integer, accountid integer, debit float, credit float)"
 create_fourstar_db['LEDGER'] = "CREATE TABLE LEDGER ( postid integer primary key autoincrement, accountid integer, date text, explanation text, journalref integer, debit float, credit float, balancedebit float, balancecredit float)"
+
+
+chart_sql = {}
+
+chart_sql['newledger'] = "INSERT INTO CHART (details, debitbalance, info) VALUES (?, ?, ?)"
+