SQLite format 3@ :6!:.;- L w  k b5Q: 9M'indexsqlite_autoindex_schedxactions_1schedxactions-##!tablerecurrencesrecurrencesCREATE TABLE recurrences(id integer PRIMARY KEY AUTOINCREMENT NOT NULL, obj_guid text(32) NOT NULL, recurrence_mult integer NOT NULL, recurrence_period_type text(2048) NOT NULL, recurrence_period_start text(8) NOT NULL, recurrence_weekend_adjust text(2048) NOT NULL)Q-mindexslots_guid_indexslotsCREATE INDEX slots_guid_index ON slots(obj_guid)U tableslotsslotsCREATE TABLE slots(id integer PRIMARY KEY AUTOINCREMENT NOT NULL, obj_guid text(32) NOT NULL, name text(4096) NOT NULL, slot_type integer NOT NULL, int64_val bigint, string_val text(4096), double_val float8, timespec_val text(19), guid_val text(32), numeric_val_num bigint, numeric_val_denom bigint, gdate_val text(8))j? indexsplits_account_guid_indexsplitsCREATE INDEX splits_account_guid_index ON splits(account_guid)Z5uindexsplits_tx_guid_indexsplitsCREATE INDEX splits_tx_guid_index ON splits(tx_guid)etablesplitssplitsCREATE TABLE splits(guid text(32) PRIMARY KEY NOT NULL, tx_guid text(32) NOT NULL, account_guid text(32) NOT NULL, memo text(2048) NOT NULL, action text(2048) NOT NULL, reconcile_state text(1) NOT NULL, reconcile_date text(19), value_num bigint NOT NULL, value_denom bigint NOT NULL, quantity_num bigint NOT NULL, quantity_denom bigint NOT NULL, lot_guid text(32))+?indexsqlite_autoindex_splits_1splitse1%indextx_post_date_indextransactionsCREATE INDEX tx_post_date_index ON transactions(post_date)]%%}tabletransactionstransactionsCREATE TABLE transactions(guid text(32) PRIMARY KEY NOT NULL, currency_guid text(32) NOT NULL, num text(2048) NOT NULL, post_date text(19), enter_date text(19), description text(2048))7K%indexsqlite_autoindex_transactions_1transactionsitablepricespricesCREATE TABLE prices(guid text(32) PRIMARY KEY NOT NULL, commodity_guid text(32) NOT NULL, currency_guid text(32) NOT NULL, date text(19) NOT NULL, source text(2048), type text(2048), value_num bigint NOT NULL, value_denom bigint NOT NULL)+?indexsqlite_autoindex_prices_1pricesP ++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) ))Mtablebudget_amountsbudget_amounts CREATE TABLE budget_amounts(id integer PRIMARY KEY AUTOINCREMENT NOT NULL, budget_guid text(32) NOT NULL, account_guid text(32) NOT NULL, period_num integer NOT NULL, amount_num bigint NOT NULL, amount_denom bigint NOT NULL)# tablebudgetsbudgets CREATE TABLE budgets(guid text(32) PRIMARY KEY NOT NULL, name text(2048) NOT NULL, description text(2048), num_periods integer NOT NULL)- Aindexsqlite_autoindex_budgets_1budgets Mmtableaccountsaccounts CREATE TABLE accounts(guid text(32) PRIMARY KEY NOT NULL, name text(2048) NOT NULL, account_type text(2048) NOT NULL, commodity_guid text(32), commodity_scu integer NOT NULL, non_std_scu integer NOT NULL, parent_guid text(32), code text(2048), description text(2048), hidden integer, placeholder integer)/ Cindexsqlite_autoindex_accounts_1accounts )##tablecommoditiescommoditiesCREATE TABLE commodities(guid text(32) PRIMARY KEY NOT NULL, namespace text(2048) NOT NULL, mnemonic text(2048) NOT NULL, fullname text(2048), cusip text(2048), fraction integer NOT NULL, quote_flag integer NOT NULL, quote_source text(2048), quote_tz text(2048))5I#indexsqlite_autoindex_commodities_1commoditiestablebooksbooksCREATE TABLE books(guid text(32) PRIMARY KEY NOT NULL, root_account_guid text(32) NOT NULL, root_template_guid text(32) NOT NULL))=indexsqlite_autoindex_books_1books|KtableversionsversionsCREATE TABLE versions(table_name text(50) PRIMARY KEY NOT NULL, table_version integer NOT NULL)/Cindexsqlite_autoindex_versions_1versionsQ{tablegnclockgnclockCREATE TABLE gnclock ( Hostname varchar(255),"  xlaP>4%  vendors-taxtable_entries taxtables  orders jobs invoices entries employees customers billtermslots ' schedxactions #recurrences slots splits %transactions prices) budget_amounts  budgets  accounts# commodities books)Gnucash-ResaveM Gnucash- 2$ @[Iku vendors-taxtable_entries taxtables ordersjobs invoices entries employees customers billtermslots'schedxactions #recurrences slots splits %transactions prices)budget_amounts budgets accounts#commodities books)Gnucash-Resave  Gnucash dMMM7d4ef4044fd30f41d08914a8174c2f5b00622dda21937b29e494179de5013f82f6c0cd00ec04169a44f170181882adab #M 7d4ef4044fd30f41d08914a8174c2f5b k-J M 1e5d65e2726a5d4595741cb204992991CURRENCYUSDUS Dollar840dcurrencyO M) d821d6776fde9f7c2d01b67876406fd3CURRENCYADFAndorran Franc950dcurrency< M  069410ffec45a41a218bba474093d466NASDAQFOOFoo Inc'K M!  5f586908098232e67edb1371408bfaa8CURRENCYAEDUAE Dirham784dcurrencyE M  346629655191dcf59a7e2c2a85b70f69CURRENCYEUREuro978dcurrency HHm$M1e5d65e2726a5d4595741cb204992991$Md821d6776fde9f7c2d01b67876406fd3$M069410ffec45a41a218bba474093d466$M5f586908098232e67edb1371408bfaa8#M 346629655191dcf59a7e2c2a85b70f69 FIV _ m u y t}F= M' f6c0cd00ec04169a44f170181882adabTemplate RootROOTx MMM 7894e9c3e955f5eaa9689d16ed775660EUR5TRADING346629655191dcf59a7e2c2a85b70f69de97809296efb670cff4f92138bd69ec8| MMM  e97809296efb670cff4f92138bd69ec8CURRENCYTRADING346629655191dcf59a7e2c2a85b70f69dbb43218d7d95b1fe062a731d1aa7e9e2x MMM 0ccab772d0d16a3e1eaf42cd53f891e5FOOTRADING069410ffec45a41a218bba474093d466'f2b78b76f6093ba04204d972a7ce42d6{ MMM  f2b78b76f6093ba04204d972a7ce42d6NASDAQTRADING069410ffec45a41a218bba474093d466'bb43218d7d95b1fe062a731d1aa7e9e2 M!MM  bb43218d7d95b1fe062a731d1aa7e9e2MouvementsTRADING069410ffec45a41a218bba474093d466'00622dda21937b29e494179de5013f82  M9MM 1305127e63737f8c39afb49b5bbeca7aOpening Balances - EUREQUITY346629655191dcf59a7e2c2a85b70f69d8056f425ecdc352cf6039e3a0d0d1e6cy MMM 8056f425ecdc352cf6039e3a0d0d1e6cEquityEQUITY346629655191dcf59a7e2c2a85b70f69d00622dda21937b29e494179de5013f82{ MMM af88d386d44b14acf244362b85ccaf4cExpenseEXPENSE346629655191dcf59a7e2c2a85b70f69d00622dda21937b29e494179de5013f82y MMM 6bbc8f20544452cac1637fb9a9b851bbIncomeINCOME346629655191dcf59a7e2c2a85b70f69d00622dda21937b29e494179de5013f82 MMM 96ed7a45459fb5fe570e48fcd46f05d0LiabilityLIABILITY346629655191dcf59a7e2c2a85b70f69d00622dda21937b29e494179de5013f82| MMM 1c089803052e85f5c6d8e786057dbaeeFoo stockSTOCK069410ffec45a41a218bba474093d466'01f6b1417935528fdc97ac2e130a150cx MMM  01f6b1417935528fdc97ac2e130a150cBrokerASSET5f586908098232e67edb1371408bfaa8dfcd795021c976ba75621ec39e75f6214w MMM a3dc764fea53b709af7fcead6470da43HouseASSET346629655191dcf59a7e2c2a85b70f69d5b5100d58bcc030d2f7828d897fda62ew MMM 5b5100d58bcc030d2f7828d897fda62eFixedASSET346629655191dcf59a7e2c2a85b70f69dfcd795021c976ba75621ec39e75f6214z MMM adc619f0ac7fa27d5768bfd73ecbc01eCheckingASSET346629655191dcf59a7e2c2a85b70f69d3bc319753945b6dba3e1928abed49e35y MMM a1dd9e8118bff87db289482bceebfea9SavingsASSET346629655191dcf59a7e2c2a85b70f69d3bc319753945b6dba3e1928abed49e35v MMM 93fc043c3062aaa1297b30e543d2cd0dCashASSET346629655191dcf59a7e2c2a85b70f69d3bc319753945b6dba3e1928abed49e35y MMM  3bc319753945b6dba3e1928abed49e35CurrentASSET346629655191dcf59a7e2c2a85b70f69dfcd795021c976ba75621ec39e75f6214w MMM  fcd795021c976ba75621ec39e75f6214AssetASSET346629655191dcf59a7e2c2a85b70f69d00622dda21937b29e494179de5013f82< M% 00622dda21937b29e494179de5013f82Root AccountROOT   g E  mjH# B $Mf6c0cd00ec04169a44f170181882adab$M7894e9c3e955f5eaa9689d16ed775660$Me97809296efb670cff4f92138bd69ec8$M0ccab772d0d16a3e1eaf42cd53f891e5$Mf2b78b76f6093ba04204d972a7ce42d6$Mbb43218d7d95b1fe062a731d1aa7e9e2$M1305127e63737f8c39afb49b5bbeca7a$M8056f425ecdc352cf6039e3a0d0d1e6c$Maf88d386d44b14acf244362b85ccaf4c $M6bbc8f20544452cac1637fb9a9b851bb $M96ed7a45459fb5fe570e48fcd46f05d0 $M1c089803052e85f5c6d8e786057dbaee $M01f6b1417935528fdc97ac2e130a150c $Ma3dc764fea53b709af7fcead6470da43$M5b5100d58bcc030d2f7828d897fda62e$Madc619f0ac7fa27d5768bfd73ecbc01e$Ma1dd9e8118bff87db289482bceebfea9$M93fc043c3062aaa1297b30e543d2cd0d$M3bc319753945b6dba3e1928abed49e35$Mfcd795021c976ba75621ec39e75f6214#M 00622dda21937b29e494179de5013f82     slots  g5  MMM3/ 831ce95a146243a0b66895151538990a5f586908098232e67edb1371408bfaa8346629655191dcf59a7e2c2a85b70f692017-05-08 16:00:00user:price-editorlast MMM3/86a98448a82e9012cad82ac677eb86df069410ffec45a41a218bba474093d4665f586908098232e67edb1371408bfaa82018-02-20 23:00:00user:price-editorunknown  MMM3/715ad31cb272437fc883d658f732a8eb1e5d65e2726a5d4595741cb204992991346629655191dcf59a7e2c2a85b70f692018-02-20 23:00:00user:price-editorunknown MMM3/c266e6ce9bdf8832bf88360df524669e346629655191dcf59a7e2c2a85b70f695f586908098232e67edb1371408bfaa82018-02-20 23:00:00user:price-editorunknown  MMM3/0d6684f44fb018e882de76094ed9c433d821d6776fde9f7c2d01b67876406fd35f586908098232e67edb1371408bfaa82018-02-20 23:00:00user:price-editorunknown HHm$M831ce95a146243a0b66895151538990a$M86a98448a82e9012cad82ac677eb86df$M715ad31cb272437fc883d658f732a8eb$Mc266e6ce9bdf8832bf88360df524669e#M 0d6684f44fb018e882de76094ed9c433   " ) 6 w MM 33!59d9b60221a4615e74f8e489dceff58b346629655191dcf59a7e2c2a85b70f692018-02-20 10:59:002018-02-20 21:14:36house loady MM 33%325537f4f0fadfd9ffb6aad3cd18e360346629655191dcf59a7e2c2a85b70f692014-12-24 10:59:002014-12-25 10:11:26loan paymentv MM 336294086c678a584e7ce184b523699f6c346629655191dcf59a7e2c2a85b70f692014-12-24 10:59:002014-12-25 10:08:08expense 1yMM 33%5be11c009a88b4198aa65ee878ddf99d346629655191dcf59a7e2c2a85b70f692014-12-24 10:59:002014-12-25 10:07:30initial load|MM 33+2d249b7d3fc8efe17865873b97748f50346629655191dcf59a7e2c2a85b70f692018-02-21 10:59:002018-02-21 07:25:53Opening BalancetMM 33a5924cd14525c307cc5862c97361b031346629655191dcf59a7e2c2a85b70f692018-02-21 10:59:002018-02-21 06:58:44buy foo|MM 33+7b3a2df3645b3e490121814c8ad7146d346629655191dcf59a7e2c2a85b70f692018-02-20 10:59:002018-02-20 21:13:50Opening Balance{MM 33)e774d4b1fbd3c8c853b2c45a1d74f5f9346629655191dcf59a7e2c2a85b70f692018-02-20 10:59:002018-02-20 21:13:30transfer intrauMM 33a5b50b770ee5e01361c49300aedb5e0f346629655191dcf59a7e2c2a85b70f692018-02-20 10:59:002018-02-20 21:13:01Purchase}MM 33-0fac88d8412f46d5e16beb87aee0fd22346629655191dcf59a7e2c2a85b70f692018-02-20 10:59:002018-02-20 21:12:49Transfer currentuMM 336c8876003c4a6026e38e3afb67d6f2b1346629655191dcf59a7e2c2a85b70f692014-12-24 10:59:002014-12-25 10:08:15income 1 jjH#m$M59d9b60221a4615e74f8e489dceff58b $M325537f4f0fadfd9ffb6aad3cd18e360 $M6294086c678a584e7ce184b523699f6c $M5be11c009a88b4198aa65ee878ddf99d$M2d249b7d3fc8efe17865873b97748f50$Ma5924cd14525c307cc5862c97361b031$M7b3a2df3645b3e490121814c8ad7146d$Me774d4b1fbd3c8c853b2c45a1d74f5f9$Ma5b50b770ee5e01361c49300aedb5e0f$M0fac88d8412f46d5e16beb87aee0fd22#M 6c8876003c4a6026e38e3afb67d6f2b1 A)qY32018-02-20 10:59:00 32014-12-24 10:59:00 32014-12-24 10:59:00 32014-12-24 10:59:0032018-02-21 10:59:0032018-02-21 10:59:0032018-02-20 10:59:0032018-02-20 10:59:0032018-02-20 10:59:0032018-02-20 10:59:003 2014-12-24 10:59:00  dlG"iD g B  d$Me774d4b1fbd3c8c853b2c45a1d74f5f9$Me774d4b1fbd3c8c853b2c45a1d74f5f9$Ma5b50b770ee5e01361c49300aedb5e0f$Ma5b50b770ee5e01361c49300aedb5e0f$Ma5924cd14525c307cc5862c97361b031$Ma5924cd14525c307cc5862c97361b031 $Ma5924cd14525c307cc5862c97361b031 $Ma5924cd14525c307cc5862c97361b031 $M7b3a2df3645b3e490121814c8ad7146d $M7b3a2df3645b3e490121814c8ad7146d $M6c8876003c4a6026e38e3afb67d6f2b1#M 6c8876003c4a6026e38e3afb67d6f2b1$M6294086c678a584e7ce184b523699f6c$M6294086c678a584e7ce184b523699f6c$M5be11c009a88b4198aa65ee878ddf99d$M5be11c009a88b4198aa65ee878ddf99d$M59d9b60221a4615e74f8e489dceff58b$M59d9b60221a4615e74f8e489dceff58b$M325537f4f0fadfd9ffb6aad3cd18e360$M325537f4f0fadfd9ffb6aad3cd18e360$M325537f4f0fadfd9ffb6aad3cd18e360$M2d249b7d3fc8efe17865873b97748f50$M2d249b7d3fc8efe17865873b97748f50$M0fac88d8412f46d5e16beb87aee0fd22$M0fac88d8412f46d5e16beb87aee0fd22  dlG"jE g B  d$Maf88d386d44b14acf244362b85ccaf4c$Maf88d386d44b14acf244362b85ccaf4c$Maf88d386d44b14acf244362b85ccaf4c$Madc619f0ac7fa27d5768bfd73ecbc01e$Madc619f0ac7fa27d5768bfd73ecbc01e$Madc619f0ac7fa27d5768bfd73ecbc01e$Madc619f0ac7fa27d5768bfd73ecbc01e$Madc619f0ac7fa27d5768bfd73ecbc01e$Ma3dc764fea53b709af7fcead6470da43$Ma1dd9e8118bff87db289482bceebfea9$Ma1dd9e8118bff87db289482bceebfea9 $Ma1dd9e8118bff87db289482bceebfea9 $Ma1dd9e8118bff87db289482bceebfea9$M96ed7a45459fb5fe570e48fcd46f05d0$M96ed7a45459fb5fe570e48fcd46f05d0$M96ed7a45459fb5fe570e48fcd46f05d0$M93fc043c3062aaa1297b30e543d2cd0d$M93fc043c3062aaa1297b30e543d2cd0d#M 93fc043c3062aaa1297b30e543d2cd0d$M7894e9c3e955f5eaa9689d16ed775660 $M6bbc8f20544452cac1637fb9a9b851bb$M1c089803052e85f5c6d8e786057dbaee $M1305127e63737f8c39afb49b5bbeca7a$M1305127e63737f8c39afb49b5bbeca7a $M0ccab772d0d16a3e1eaf42cd53f891e5 m d g B jE H#$M59d9b60221a4615e74f8e489dceff58b$M59d9b60221a4615e74f8e489dceff58b$M325537f4f0fadfd9ffb6aad3cd18e360$M325537f4f0fadfd9ffb6aad3cd18e360$M325537f4f0fadfd9ffb6aad3cd18e360$M6294086c678a584e7ce184b523699f6c$M6294086c678a584e7ce184b523699f6c$M5be11c009a88b4198aa65ee878ddf99d$M5be11c009a88b4198aa65ee878ddf99d$M2d249b7d3fc8efe17865873b97748f50$M2d249b7d3fc8efe17865873b97748f50$Ma5924cd14525c307cc5862c97361b031$Ma5924cd14525c307cc5862c97361b031 $Ma5924cd14525c307cc5862c97361b031 $Ma5924cd14525c307cc5862c97361b031 $M7b3a2df3645b3e490121814c8ad7146d $M7b3a2df3645b3e490121814c8ad7146d $Me774d4b1fbd3c8c853b2c45a1d74f5f9$Me774d4b1fbd3c8c853b2c45a1d74f5f9$Ma5b50b770ee5e01361c49300aedb5e0f$Ma5b50b770ee5e01361c49300aedb5e0f$M0fac88d8412f46d5e16beb87aee0fd22$M0fac88d8412f46d5e16beb87aee0fd22$M6c8876003c4a6026e38e3afb67d6f2b1#M 6c8876003c4a6026e38e3afb67d6f2b1# g d m  H B $M96ed7a45459fb5fe570e48fcd46f05d0$Ma3dc764fea53b709af7fcead6470da43$Madc619f0ac7fa27d5768bfd73ecbc01e$Maf88d386d44b14acf244362b85ccaf4c$M96ed7a45459fb5fe570e48fcd46f05d0$Madc619f0ac7fa27d5768bfd73ecbc01e$Maf88d386d44b14acf244362b85ccaf4c$M96ed7a45459fb5fe570e48fcd46f05d0$Madc619f0ac7fa27d5768bfd73ecbc01e$M1305127e63737f8c39afb49b5bbeca7a$Ma1dd9e8118bff87db289482bceebfea9$M0ccab772d0d16a3e1eaf42cd53f891e5$Ma1dd9e8118bff87db289482bceebfea9 $M7894e9c3e955f5eaa9689d16ed775660 $M1c089803052e85f5c6d8e786057dbaee $M1305127e63737f8c39afb49b5bbeca7a $Ma1dd9e8118bff87db289482bceebfea9 $Ma1dd9e8118bff87db289482bceebfea9$Madc619f0ac7fa27d5768bfd73ecbc01e$M93fc043c3062aaa1297b30e543d2cd0d$Maf88d386d44b14acf244362b85ccaf4c$Madc619f0ac7fa27d5768bfd73ecbc01e$M93fc043c3062aaa1297b30e543d2cd0d$M6bbc8f20544452cac1637fb9a9b851bb#M 93fc043c3062aaa1297b30e543d2cd0d  YL p I S  YT M#3 0fac88d8412f46d5e16beb87aee0fd22date-posted 1970-01-01 00:00:0020180220P M#3 e97809296efb670cff4f92138bd69ec8placeholdertrue1970-01-01 00:00:00P M#3 f2b78b76f6093ba04204d972a7ce42d6placeholdertrue1970-01-01 00:00:00P M#3 bb43218d7d95b1fe062a731d1aa7e9e2placeholdertrue1970-01-01 00:00:00P M#3 01f6b1417935528fdc97ac2e130a150cplaceholdertrue1970-01-01 00:00:00P M#3 3bc319753945b6dba3e1928abed49e35placeholdertrue1970-01-01 00:00:00P M#3 fcd795021c976ba75621ec39e75f6214placeholdertrue1970-01-01 00:00:00_ MA3 7d4ef4044fd30f41d08914a8174c2f5bremove-color-not-set-slotstrue1970-01-01 00:00:00r M/3M 7d2cff8435ce429589028eb6e9e6c748options/Budgeting 1970-01-01 00:00:005444db6205a04ce28483bd1e542f3b48g MW3 d2361151d5fa48aeacf66a9691926feeoptions/Accounts/Use Trading Accountst1970-01-01 00:00:00q M-3M 7d2cff8435ce429589028eb6e9e6c748options/Accounts 1970-01-01 00:00:00d2361151d5fa48aeacf66a9691926feeh M3M 7d4ef4044fd30f41d08914a8174c2f5boptions 1970-01-01 00:00:007d2cff8435ce429589028eb6e9e6c748\M C3 6c3d2900f3d74d67820df763258fb8affeatures/ISO-8601 formatted date strings in SQLite3 databases.Use ISO formatted date-time strings in SQLite3 databases (requires at least GnuCash 2.6.20)1970-01-01 00:00:00i M3M 7d4ef4044fd30f41d08914a8174c2f5bfeatures 1970-01-01 00:00:006c3d2900f3d74d67820df763258fb8af   m#jH E$M0fac88d8412f46d5e16beb87aee0fd22$Me97809296efb670cff4f92138bd69ec8 $Mf2b78b76f6093ba04204d972a7ce42d6 $Mbb43218d7d95b1fe062a731d1aa7e9e2 $M01f6b1417935528fdc97ac2e130a150c $M3bc319753945b6dba3e1928abed49e35 $Mfcd795021c976ba75621ec39e75f6214$M7d4ef4044fd30f41d08914a8174c2f5b$M7d2cff8435ce429589028eb6e9e6c748$Md2361151d5fa48aeacf66a9691926fee$M7d2cff8435ce429589028eb6e9e6c748$M7d4ef4044fd30f41d08914a8174c2f5b$M6c3d2900f3d74d67820df763258fb8af#M 7d4ef4044fd30f41d08914a8174c2f5b    t0 L w  k b: 9M'indexsqlite_autoindex_schedxactions_1schedxacM'indexsqlite_autoindex_schedxactions_1schedxactions##!tablerecurrencesrecurrencesCREATE TABLE recurrences(id integer PRIMARY KEY AUTOINCREMENT NOT NULL, obj_guid text(32) NOT NULL, recurrence_mult integer NOT NULL, recurrence_period_type text(2048) NOT NULL, recurrence_period_start text(8) NOT NULL, recurrence_weekend_adjust text(2048) NOT NULL)Q-mindexslots_guid_indexslotsCREATE INDEX slots_guid_index ON slots(obj_guid)U tableslotsslotsCREATE TABLE slots(id integer PRIMARY KEY AUTOINCREMENT NOT NULL, obj_guid text(32) NOT NULL, name text(4096) NOT NULL, slot_type integer NOT NULL, int64_val bigint, string_val text(4096), double_val float8, timespec_val text(19), guid_val text(32), numeric_val_num bigint, numeric_val_denom bigint, gdate_val text(8))}? indexsplits_account_guid_indexsplitsCREATE INDEX splits_account_guid_index ON splits(account_guid)5uindexsplits_tx_guid_indexsplitsCREATE INDEX splits_tx_guid_index ON splits(tx_guid)?indexsqlite_autoindex_splits_1splitsetablesplitssplitsCREATE TABLE splits(guid text(32) PRIMARY KEY NOT NULL, tx_guid text(32) NOT NULL, account_guid text(32) NOT NULL, memo text(2048) NOT NULL, action text(2048) NOT NULL, reconcile_state text(1) NOT NULL, reconcile_date text(19), value_num bigint NOT NULL, value_denom bigint NOT NULL, quantity_num bigint NOT NULL, quantity_denom bigint NOT NULL, lot_guid text(32))e1%indextx_post_date_indextransactionsCREATE INDEX tx_post_date_index ON transactions(post_date)]%%}tabletransactionstransactionsCREATE TABLE transactions(guid text(32) PRIMARY KEY NOT NULL, currency_guid text(32) NOT NULL, num text(2048) NOT NULL, post_date text(19), enter_date text(19), description text(2048))7K%indexsqlite_autoindex_transactions_1transactionsitablepricespricesCREATE TABLE prices(guid text(32) PRIMARY KEY NOT NULL, commodity_guid text(32) NOT NULL, currency_guid text(32) NOT NULL, date text(19) NOT NULL, source text(2048), type text(2048), value_num bigint NOT NULL, value_denom bigint NOT NULL)+?indexsqlite_autoindex_prices_1pricesP ++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) ))Mtablebudget_amountsbudget_amounts CREATE TABLE budget_amounts(id integer PRIMARY KEY AUTOINCREMENT NOT NULL, budget_guid text(32) NOT NULL, account_guid text(32) NOT NULL, period_num integer NOT NULL, amount_num bigint NOT NULL, amount_denom bigint NOT NULL)# tablebudgetsbudgets CREATE TABLE budgets(guid text(32) PRIMARY KEY NOT NULL, name text(2048) NOT NULL, description text(2048), num_periods integer NOT NULL)- Aindexsqlite_autoindex_budgets_1budgets Mmtableaccountsaccounts CREATE TABLE accounts(guid text(32) PRIMARY KEY NOT NULL, name text(2048) NOT NULL, account_type text(2048) NOT NULL, commodity_guid text(32), commodity_scu integer NOT NULL, non_std_scu integer NOT NULL, parent_guid text(32), code text(2048), description text(2048), hidden integer, placeholder integer)/ Cindexsqlite_autoindex_accounts_1accounts )##tablecommoditiescommoditiesCREATE TABLE commodities(guid text(32) PRIMARY KEY NOT NULL, namespace text(2048) NOT NULL, mnemonic text(2048) NOT NULL, fullname text(2048), cusip text(2048), fraction integer NOT NULL, quote_flag integer NOT NULL, quote_source text(2048), quote_tz text(2048))5I#indexsqlite_autoindex_commodities_1commoditiestablebooksbooksCREATE TABLE books(guid text(32) PRIMARY KEY NOT NULL, root_account_guid text(32) NOT NULL, root_template_guid text(32) NOT NULL))=indexsqlite_autoindex_books_1books|KtableversionsversionsCREATE TABLE versions(table_name text(50) PRIMARY KEY NOT NULL, table_version integer NOT NULL)/Cindexsqlite_autoindex_versions_1versionsQ{tablegnclockgnclockCREATE TABLE gnclock ( Hostname varchar(255), PID int ) = Z f/5\;indexsqlite_autoindex_jobs_1jobs,3/'Cindexsqlite_autoindex_invoices_1invoices*N&otableinvoicesinvoices)CREATE TABLE invoices(guid text(32) PRIMARY KEY NOT NULL, id text(2048) NOT NULL, date_opened text(19), date_posted text(19), notes text(2048) NOT NULL, active integer NOT NULL, currency text(32) NOT NULL, owner_type integer, owner_guid text(32), terms text(32), billing_id text(2048), post_txn text(32), post_lot text(32), post_acc text(32), billto_type integer, billto_guid text(32), charge_amt_num bigint, charge_amt_denom bigint)-%Aindexsqlite_autoindex_entries_1entries(D$_tableentriesentries'CREATE TABLE entries(guid text(32) PRIMARY KEY NOT NULL, date text(19) NOT NULL, date_entered text(19), description text(2048), action text(2048), notes text(2048), quantity_num bigint, quantity_denom bigint, i_acct text(32), i_price_num bigint, i_price_denom bigint, i_discount_num bigint, i_discount_denom bigint, invoice text(32), i_disc_type-##!tablerecurrencesrecurrencesCREATE TABLE recurrences(id integer PRIMARY KEY AUTOINCREMENT NOT NULL, obj_guid text(32) NOT NULL, recurrence_mult integer NOT NULL, recurrence_period_type text(2048) NOT NULL, recurrence_period_start text(8) NOT NULL, recurrence_weekend_adjust text(2048) NOT NULL)Q-mindexslots_guid_indexslotsCREATE INDEX slots_guid_index ON slots(obj_guid)4"7tableemployeesemployees%CREATE TABLE employees(guid text(32) PRIMARY KEY NOT NULL, username text(2048) NOT NULL, id text(2048) NOT NULL, language text(2048) NOT NULL, acl text(2048) NOT NULL, active integer NOT NULL, currency text(32) NOT NULL, ccard_guid text(32), workday_num bigint NOT NULL, workday_denom bigint NOT NULL, rate_num bigint NOT NULL, rate_denom bigint NOT NULL, addr_name text(1024), addr_addr1 text(1024), addr_addr2 text(1024), addr_addr3 text(1024), addr_addr4 text(1024), addr_phone text(128), addr_fax text(128), addr_email text(256))1!Eindexsqlite_autoindex_customers_1customers$/ -tablecustomerscustomers#CREATE TABLE customers(guid text(32) PRIMARY KEY NOT NULL, name text(2048) NOT NULL, id text(2048) NOT NULL, notes text(2048) NOT NULL, active integer NOT NULL, discount_num bigint NOT NULL, discount_denom bigint NOT NULL, credit_num bigint NOT NULL, credit_denom bigint NOT NULL, currency text(32) NOT NULL, tax_override integer NOT NULL, addr_name text(1024), addr_addr1 text(1024), addr_addr2 text(1024), addr_addr3 text(1024), addr_addr4 text(1024), addr_phone text(128), addr_fax text(128), addr_email text(256), shipaddr_name text(1024), shipaddr_addr1 text(1024), shipaddr_addr2 text(1024), shipaddr_addr3 text(1024), shipaddr_addr4 text(1024), shipaddr_phone text(128), shipaddr_fax text(128), shipaddr_email text(256), terms text(32), tax_included integer, taxtable text(32))1Eindexsqlite_autoindex_billterms_1billterms"Ytablebilltermsbillterms!CREATE TABLE billterms(guid text(32) PRIMARY KEY NOT NULL, name text(2048) NOT NULL, description text(2048) NOT NULL, refcount integer NOT NULL, invisible integer NOT NULL, parent text(32), type text(2048) NOT NULL, duedays integer, discountdays integer, discount_num bigint, discount_denom bigint, cutoff integer)';indexsqlite_autoindex_lots_1lots }]tablelotslotsCREATE TABLE lots(guid text(32) PRIMARY KEY NOT NULL, account_guid text(32), is_closed integer NOT NULL)9M'indexsqlite_autoindex_schedxactions_1schedxactions@''?tableschedxactionsschedxactionsCREATE TABLE schedxactions(guid text(32) PRIMARY KEY NOT NULL, name text(2048), enabled integer NOT NULL, start_date text(8), end_date text(8), last_occur text(8), num_occur integer NOT NULL, rem_occur integer NOT NULL, auto_create integer NOT NULL, auto_notify integer NOT NULL, adv_creation integer NOT NULL, adv_notify integer NOT NULL, instance_count integer NOT NULL, template_act_guid text(32) NOT NULL)               )   ` r-n^?1Cj4? indexsplits_account_guid_indexsplitsCREATE INDEX splits_account_guid_index ON splits(account_guid)Z35uindexsplits_tx_guid_indexsplitsCREATE INDEX splits_tx_guid_index ON splits(tx_guid)1itablesplitssplits5CREATE TABLE "splits"(guid text(32) PRIMARY KEY NOT NULL, tx_guid text(32) NOT NULL, account_guid text(32) NOT NULL, memo text(2048) NOT NULL, action text(2048) NOT NULL, reconcile_state text(1) NOT NULL, reconcile_date text(19), value_num bigint NOT NULL, value_denom bigint NOT NULL, quantity_num bigint NOT NULL, quantity_denom bigint NOT NULL, lot_guid text(32)) G!+2?indexsqlite_autoindex_splits_1splits6^/tablevendorsvendors3CREATE TABLE vendors(guid text(32) PRIMARY KEY NOT NULL, name text(2048) NOT NULL, id text(2048) NOT NULL, notes text(2048) NOT NULL, currency text(32) NOT NULL, active integer NOT NULL, tax_override integer NOT NULL, addr_name text(1024), addr_addr1 text(1024), addr_addr2 text(1024), addr_addr3 text(1024), addr_addr4 text(1024), addr_phone text(128), addr_fax text(128), addr_email text(256), terms text(32), tax_inc text(2048), tax_table text(32))-0Aindexsqlite_autoindex_vendors_1vendors4.--5tabletaxtable_entriestaxtable_entries2CREATE TABLE taxtable_entries(id integer PRIMARY KEY AUTOINCREMENT NOT NULL, taxtable text(32) NOT NULL, account text(32) NOT NULL, amount_num bigint NOT NULL, amount_denom bigint NOT NULL, type integer NOT NULL)8,?tabletaxtablestaxtables0CREATE TABLE taxtables(guid text(32) PRIMARY KEY NOT NULL, name text(50) NOT NULL, refcount bigint NOT NULL, invisible integer NOT NULL, parent text(32))1-Eindexsqlite_autoindex_taxtables_1taxtables14*Ctableordersorders.CREATE TABLE orders(guid text(32) PRIMARY KEY NOT NULL, id text(2048) NOT NULL, notes text(2048) NOT NULL, reference text(2048) NOT NULL, active integer NOT NULL, date_opened text(19) NOT NULL, date_closed text(19) NOT NULL, owner_type integer NOT NULL, owner_guid text(32) NOT NULL)++?indexsqlite_autoindex_orders_1orders/');indexsqlite_autoindex_jobs_1jobs,](tablejobsjobs+CREATE TABLE jobs(guid text(32) PRIMARY KEY NOT NULL, id text(2048) NOT NULL, name text(2048) NOT NULL, reference text(2048) NOT NULL, active integer NOT NULL, owner_type integer, owner_guid text(32))/'Cindexsqlite_autoindex_invoices_1invoices*N&otableinvoicesinvoices)CREATE TABLE invoices(guid text(32) PRIMARY KEY NOT NULL, id text(2048) NOT NULL, date_opened text(19), date_posted text(19), notes text(2048) NOT NULL, active integer NOT NULL, currency text(32) NOT NULL, owner_type integer, owner_guid text(32), terms text(32), billing_id text(2048), post_txn text(32), post_lot text(32), post_acc text(32), billto_type integer, billto_guid text(32), charge_amt_num bigint, charge_amt_denom bigint)-%Aindexsqlite_autoindex_entries_1entries(D$_tableentriesentries'CREATE TABLE entries(guid text(32) PRIMARY KEY NOT NULL, date text(19) NOT NULL, date_entered text(19), description text(2048), action text(2048), notes text(2048), quantity_num bigint, quantity_denom bigint, i_acct text(32), i_price_num bigint, i_price_denom bigint, i_discount_num bigint, i_discount_denom bigint, invoice text(32), i_disc_type text(2048), i_disc_how text(2048), i_taxable integer, i_taxincluded integer, i_taxtable text(32), b_acct text(32), b_price_num bigint, b_price_denom bigint, bill text(32), b_taxable integer, b_taxincluded integer, b_taxtable text(32), b_paytype integer, billable integer, billto_type integer, billto_guid text(32), order_guid text(32))1#Eindexsqlite_autoindex_employees_1employees&        Nvb N : $ fN6"fN  MMM 3c8eb859a307babbb2fdf66871cf4c0a859d9b60221a4615e74f8e489dceff58b96ed7a45459fb5fe570e48fcd46f05d0n1970-01-01 00:00:00{d{d  MMM 376cd1180d563db608495c710d2774c9a59d9b60221a4615e74f8e489dceff58ba3dc764fea53b709af7fcead6470da43n1970-01-01 00:00:00dd MMM+ 347c7fdca3bc04d6ad734eefc2794ddfe325537f4f0fadfd9ffb6aad3cd18e360adc619f0ac7fa27d5768bfd73ecbc01emonthly paymentn1970-01-01 00:00:008d8d MMM 33142f6ebed4469f9a692dfa69a0080f5325537f4f0fadfd9ffb6aad3cd18e360af88d386d44b14acf244362b85ccaf4cinterestn1970-01-01 00:00:00 d d MMM 36ca852f33ee5415d22dfc132f5c5ec09325537f4f0fadfd9ffb6aad3cd18e36096ed7a45459fb5fe570e48fcd46f05d0capitaln1970-01-01 00:00:00'd'd MMM 3d96c36fed7324332bfeff80e52cd98926294086c678a584e7ce184b523699f6cadc619f0ac7fa27d5768bfd73ecbc01en1970-01-01 00:00:00dd MMM 3b8387081c3d60310465a5d316fb6745a6294086c678a584e7ce184b523699f6caf88d386d44b14acf244362b85ccaf4cn1970-01-01 00:00:00N dN d  MMM 33a53ab1f73cb74d9882dd14b7d6a4a785be11c009a88b4198aa65ee878ddf99d96ed7a45459fb5fe570e48fcd46f05d0n1970-01-01 00:00:00y`dy`d  MMM 3714c69b235d450f11e4add7077b4cde75be11c009a88b4198aa65ee878ddf99dadc619f0ac7fa27d5768bfd73ecbc01en1970-01-01 00:00:00dd  MMM 3d240433d6812fc634c21200fb559d07f2d249b7d3fc8efe17865873b97748f501305127e63737f8c39afb49b5bbeca7an1970-01-01 00:00:00/pd/pd  MMM 3b3c4df045f2a19332e143cd83a7e013f2d249b7d3fc8efe17865873b97748f50a1dd9e8118bff87db289482bceebfea9n1970-01-01 00:00:00АdАd  MMM 385d451d09db85fb97cea6fe2e876d566a5924cd14525c307cc5862c97361b0310ccab772d0d16a3e1eaf42cd53f891e5n1970-01-01 00:00:00+@d)' MMM 3f5f1b767b38439eff788bed8fca8d1c2a5924cd14525c307cc5862c97361b031a1dd9e8118bff87db289482bceebfea9n1970-01-01 00:00:00+@d+@d MMM 3e055799a549308621a16c715c870e29aa5924cd14525c307cc5862c97361b0317894e9c3e955f5eaa9689d16ed775660n1970-01-01 00:00:00dd MMM 3e07539176a70222b16369bd246b174b9a5924cd14525c307cc5862c97361b0311c089803052e85f5c6d8e786057dbaeen1970-01-01 00:00:00d ' MMM 3afcba9bb98422e5ca64931a5efd860257b3a2df3645b3e490121814c8ad7146d1305127e63737f8c39afb49b5bbeca7an1970-01-01 00:00:00/pd/pd MMM 34f78ef3650c38115abf60365f9484b457b3a2df3645b3e490121814c8ad7146da1dd9e8118bff87db289482bceebfea9n1970-01-01 00:00:00АdАd MMM 3bae8bc3a2b29812691016e61c425fda5e774d4b1fbd3c8c853b2c45a1d74f5f9a1dd9e8118bff87db289482bceebfea9n1970-01-01 00:00:00XdXd MMM 3ea72c01205e1f619aa278930648b060ee774d4b1fbd3c8c853b2c45a1d74f5f9adc619f0ac7fa27d5768bfd73ecbc01en1970-01-01 00:00:00adad MMM 3f32095185808aff854fc020ee2eedb5da5b50b770ee5e01361c49300aedb5e0f93fc043c3062aaa1297b30e543d2cd0dn1970-01-01 00:00:00HdHd MMM 3eb832677cb2a013fcc4140316ccb3323a5b50b770ee5e01361c49300aedb5e0faf88d386d44b14acf244362b85ccaf4cn1970-01-01 00:00:00 d d MMM 3486341b68457b037ecd75dcdcbf64bc50fac88d8412f46d5e16beb87aee0fd22adc619f0ac7fa27d5768bfd73ecbc01en1970-01-01 00:00:00dd MMM 342336a5732d54b22fa080be3b50ff5b70fac88d8412f46d5e16beb87aee0fd2293fc043c3062aaa1297b30e543d2cd0dn1970-01-01 00:00:00'd'd MMM 31e612f650eb598d9e803902b6aca73e36c8876003c4a6026e38e3afb67d6f2b16bbc8f20544452cac1637fb9a9b851bbn1970-01-01 00:00:00hdhd MMM 3de832fe97e37811a7fff7e28b3a434256c8876003c4a6026e38e3afb67d6f2b193fc043c3062aaa1297b30e543d2cd0dn1970-01-01 00:00:00:d:d  dlG"iD f B  d$Mf5f1b767b38439eff788bed8fca8d1c2 $Mf32095185808aff854fc020ee2eedb5d$Meb832677cb2a013fcc4140316ccb3323$Mea72c01205e1f619aa278930648b060e$Me07539176a70222b16369bd246b174b9 $Me055799a549308621a16c715c870e29a #M de832fe97e37811a7fff7e28b3a43425$Md96c36fed7324332bfeff80e52cd9892$Md240433d6812fc634c21200fb559d07f$Mc8eb859a307babbb2fdf66871cf4c0a8$Mbae8bc3a2b29812691016e61c425fda5$Mb8387081c3d60310465a5d316fb6745a$Mb3c4df045f2a19332e143cd83a7e013f$Mafcba9bb98422e5ca64931a5efd86025 $M85d451d09db85fb97cea6fe2e876d566$M76cd1180d563db608495c710d2774c9a$M714c69b235d450f11e4add7077b4cde7$M6ca852f33ee5415d22dfc132f5c5ec09$M4f78ef3650c38115abf60365f9484b45 $M486341b68457b037ecd75dcdcbf64bc5$M47c7fdca3bc04d6ad734eefc2794ddfe$M42336a5732d54b22fa080be3b50ff5b7$M3a53ab1f73cb74d9882dd14b7d6a4a78$M3142f6ebed4469f9a692dfa69a0080f5$M1e612f650eb598d9e803902b6aca73e3