2017-11-24 12:11:59.116 CST [14224] LOG:  database system was shut down at 2017-11-24 12:11:58 CST
2017-11-24 12:11:59.268 CST [3392] LOG:  database system is ready to accept connections
2017-11-24 12:13:08.716 CST [6516] FATAL:  database "test" does not exist
2017-11-24 12:13:08.737 CST [5052] LOG:  statement: set client_encoding to 'UNICODE'
2017-11-24 12:13:08.737 CST [5052] LOG:  statement: CREATE DATABASE test WITH TEMPLATE template0 ENCODING 'UTF8'
2017-11-24 12:13:21.573 CST [5052] LOG:  statement: ALTER DATABASE test SET standard_conforming_strings TO on
2017-11-24 12:13:21.627 CST [4560] LOG:  statement: set client_encoding to 'UNICODE'
2017-11-24 12:13:21.627 CST [4560] LOG:  statement: CREATE TEMPORARY TABLE numtest ( test_int BIGINT, test_unsigned BIGINT, test_double FLOAT8 )
2017-11-24 12:13:21.634 CST [4560] LOG:  statement: INSERT INTO numtest VALUES (-9223372036854775807, 9223372036854775807, 1.7976921348623158e+307)
2017-11-24 12:13:21.636 CST [4560] LOG:  statement: SELECT * FROM numtest
2017-11-24 12:13:21.640 CST [4560] LOG:  statement: BEGIN
2017-11-24 12:13:21.640 CST [4560] LOG:  statement: SELECT relname FROM pg_class WHERE relname !~ '^pg_' AND relname LIKE 'gnclock' AND relkind = 'r' AND relowner = (SELECT datdba FROM pg_database WHERE datname = 'test') ORDER BY relname
2017-11-24 12:13:21.644 CST [4560] LOG:  statement: CREATE TABLE gnclock ( Hostname varchar(255), PID int )
2017-11-24 12:13:21.645 CST [4560] LOG:  statement: SELECT * FROM gnclock
2017-11-24 12:13:21.646 CST [4560] LOG:  statement: INSERT INTO gnclock VALUES ('DESKTOP-V6FHSRS', '11988')
2017-11-24 12:13:21.646 CST [4560] LOG:  statement: COMMIT
2017-11-24 12:13:21.648 CST [4560] LOG:  statement: SELECT relname FROM pg_class WHERE relname !~ '^pg_' AND relname LIKE '%back' AND relkind = 'r' AND relowner = (SELECT datdba FROM pg_database WHERE datname = 'test') ORDER BY relname
2017-11-24 12:13:21.675 CST [4560] LOG:  statement: BEGIN
2017-11-24 12:13:21.675 CST [4560] LOG:  statement: SELECT relname FROM pg_class WHERE relname !~ '^pg_' AND relkind = 'r' AND relowner = (SELECT datdba FROM pg_database WHERE datname = 'test') ORDER BY relname
2017-11-24 12:13:21.676 CST [4560] LOG:  statement: ALTER TABLE numtest RENAME TO numtest_back
2017-11-24 12:13:21.678 CST [4560] LOG:  statement: SELECT relname FROM pg_class AS a INNER JOIN pg_index AS b ON (b.indexrelid = a.oid) INNER JOIN pg_namespace AS c ON (a.relnamespace = c.oid) WHERE reltype = '0' AND indisprimary = 'f' AND nspname = 'public'
2017-11-24 12:13:21.682 CST [4560] LOG:  statement: CREATE TABLE versions (table_name varchar(50) PRIMARY KEY NOT NULL, table_version integer NOT NULL)
2017-11-24 12:13:21.810 CST [4560] LOG:  statement: INSERT INTO versions VALUES('Gnucash',2061800)
2017-11-24 12:13:21.811 CST [4560] LOG:  statement: INSERT INTO versions VALUES('Gnucash-Resave',19920)
2017-11-24 12:13:21.816 CST [4560] LOG:  statement: CREATE TABLE accounts (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, account_type varchar(2048) NOT NULL, commodity_guid varchar(32), commodity_scu integer NOT NULL, non_std_scu integer NOT NULL, parent_guid varchar(32), code varchar(2048), description varchar(2048), hidden integer, placeholder integer)
2017-11-24 12:13:22.151 CST [4560] LOG:  statement: INSERT INTO versions VALUES('accounts',1)
2017-11-24 12:13:22.157 CST [4560] LOG:  statement: CREATE TABLE books (guid varchar(32) PRIMARY KEY NOT NULL, root_account_guid varchar(32) NOT NULL, root_template_guid varchar(32) NOT NULL)
2017-11-24 12:13:22.260 CST [4560] LOG:  statement: INSERT INTO versions VALUES('books',1)
2017-11-24 12:13:22.264 CST [4560] LOG:  statement: CREATE TABLE budgets (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, description varchar(2048), num_periods integer NOT NULL)
2017-11-24 12:13:22.640 CST [4560] LOG:  statement: INSERT INTO versions VALUES('budgets',1)
2017-11-24 12:13:22.641 CST [4560] LOG:  statement: CREATE TABLE budget_amounts (id serial PRIMARY KEY NOT NULL, budget_guid varchar(32) NOT NULL, account_guid varchar(32) NOT NULL, period_num integer NOT NULL, amount_num int8 NOT NULL, amount_denom int8 NOT NULL)
2017-11-24 12:13:22.759 CST [4560] LOG:  statement: INSERT INTO versions VALUES('budget_amounts',1)
2017-11-24 12:13:22.762 CST [4560] LOG:  statement: CREATE TABLE commodities (guid varchar(32) PRIMARY KEY NOT NULL, namespace varchar(2048) NOT NULL, mnemonic varchar(2048) NOT NULL, fullname varchar(2048), cusip varchar(2048), fraction integer NOT NULL, quote_flag integer NOT NULL, quote_source varchar(2048), quote_tz varchar(2048))
2017-11-24 12:13:22.861 CST [4560] LOG:  statement: INSERT INTO versions VALUES('commodities',1)
2017-11-24 12:13:22.867 CST [4560] LOG:  statement: CREATE TABLE lots (guid varchar(32) PRIMARY KEY NOT NULL, account_guid varchar(32), is_closed integer NOT NULL)
2017-11-24 12:13:22.940 CST [4560] LOG:  statement: INSERT INTO versions VALUES('lots',2)
2017-11-24 12:13:22.946 CST [4560] LOG:  statement: CREATE TABLE prices (guid varchar(32) PRIMARY KEY NOT NULL, commodity_guid varchar(32) NOT NULL, currency_guid varchar(32) NOT NULL, date timestamp without time zone NOT NULL, source varchar(2048), type varchar(2048), value_num int8 NOT NULL, value_denom int8 NOT NULL)
2017-11-24 12:13:23.104 CST [4560] LOG:  statement: INSERT INTO versions VALUES('prices',2)
2017-11-24 12:13:23.110 CST [4560] LOG:  statement: CREATE TABLE schedxactions (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048), enabled integer NOT NULL, start_date date, end_date date, last_occur date, 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 varchar(32) NOT NULL)
2017-11-24 12:13:23.438 CST [4560] LOG:  statement: INSERT INTO versions VALUES('schedxactions',1)
2017-11-24 12:13:23.441 CST [4560] LOG:  statement: CREATE TABLE transactions (guid varchar(32) PRIMARY KEY NOT NULL, currency_guid varchar(32) NOT NULL, num varchar(2048) NOT NULL, post_date timestamp without time zone, enter_date timestamp without time zone, description varchar(2048))
2017-11-24 12:13:23.659 CST [4560] LOG:  statement: INSERT INTO versions VALUES('transactions',3)
2017-11-24 12:13:23.659 CST [4560] LOG:  statement: CREATE INDEX tx_post_date_index ON transactions (post_date)
2017-11-24 12:13:23.742 CST [4560] LOG:  statement: CREATE TABLE splits (guid varchar(32) PRIMARY KEY NOT NULL, tx_guid varchar(32) NOT NULL, account_guid varchar(32) NOT NULL, memo varchar(2048) NOT NULL, action varchar(2048) NOT NULL, reconcile_state varchar(1) NOT NULL, reconcile_date timestamp without time zone, value_num int8 NOT NULL, value_denom int8 NOT NULL, quantity_num int8 NOT NULL, quantity_denom int8 NOT NULL, lot_guid varchar(32))
2017-11-24 12:13:23.846 CST [4560] LOG:  statement: INSERT INTO versions VALUES('splits',4)
2017-11-24 12:13:23.846 CST [4560] LOG:  statement: CREATE INDEX splits_tx_guid_index ON splits (tx_guid)
2017-11-24 12:13:23.870 CST [4560] LOG:  statement: CREATE INDEX splits_account_guid_index ON splits (account_guid)
2017-11-24 12:13:23.957 CST [4560] LOG:  statement: CREATE TABLE billterms (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, description varchar(2048) NOT NULL, refcount integer NOT NULL, invisible integer NOT NULL, parent varchar(32), type varchar(2048) NOT NULL, duedays integer, discountdays integer, discount_num int8, discount_denom int8, cutoff integer)
2017-11-24 12:13:24.179 CST [4560] LOG:  statement: INSERT INTO versions VALUES('billterms',2)
2017-11-24 12:13:24.186 CST [4560] LOG:  statement: CREATE TABLE customers (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, id varchar(2048) NOT NULL, notes varchar(2048) NOT NULL, active integer NOT NULL, discount_num int8 NOT NULL, discount_denom int8 NOT NULL, credit_num int8 NOT NULL, credit_denom int8 NOT NULL, currency varchar(32) NOT NULL, tax_override integer NOT NULL, addr_name varchar(1024), addr_addr1 varchar(1024), addr_addr2 varchar(1024), addr_addr3 varchar(1024), addr_addr4 varchar(1024), addr_phone varchar(128), addr_fax varchar(128), addr_email varchar(256), shipaddr_name varchar(1024), shipaddr_addr1 varchar(1024), shipaddr_addr2 varchar(1024), shipaddr_addr3 varchar(1024), shipaddr_addr4 varchar(1024), shipaddr_phone varchar(128), shipaddr_fax varchar(128), shipaddr_email varchar(256), terms varchar(32), tax_included integer, taxtable varchar(32))
2017-11-24 12:13:24.245 CST [4560] LOG:  statement: INSERT INTO versions VALUES('customers',2)
2017-11-24 12:13:24.251 CST [4560] LOG:  statement: CREATE TABLE employees (guid varchar(32) PRIMARY KEY NOT NULL, username varchar(2048) NOT NULL, id varchar(2048) NOT NULL, language varchar(2048) NOT NULL, acl varchar(2048) NOT NULL, active integer NOT NULL, currency varchar(32) NOT NULL, ccard_guid varchar(32), workday_num int8 NOT NULL, workday_denom int8 NOT NULL, rate_num int8 NOT NULL, rate_denom int8 NOT NULL, addr_name varchar(1024), addr_addr1 varchar(1024), addr_addr2 varchar(1024), addr_addr3 varchar(1024), addr_addr4 varchar(1024), addr_phone varchar(128), addr_fax varchar(128), addr_email varchar(256))
2017-11-24 12:13:24.328 CST [4560] LOG:  statement: INSERT INTO versions VALUES('employees',2)
2017-11-24 12:13:24.335 CST [4560] LOG:  statement: CREATE TABLE entries (guid varchar(32) PRIMARY KEY NOT NULL, date timestamp without time zone NOT NULL, date_entered timestamp without time zone, description varchar(2048), action varchar(2048), notes varchar(2048), quantity_num int8, quantity_denom int8, i_acct varchar(32), i_price_num int8, i_price_denom int8, i_discount_num int8, i_discount_denom int8, invoice varchar(32), i_disc_type varchar(2048), i_disc_how varchar(2048), i_taxable integer, i_taxincluded integer, i_taxtable varchar(32), b_acct varchar(32), b_price_num int8, b_price_denom int8, bill varchar(32), b_taxable integer, b_taxincluded integer, b_taxtable varchar(32), b_paytype integer, billable integer, billto_type integer, billto_guid varchar(32), order_guid varchar(32))
2017-11-24 12:13:24.593 CST [4560] LOG:  statement: INSERT INTO versions VALUES('entries',3)
2017-11-24 12:13:24.600 CST [4560] LOG:  statement: CREATE TABLE invoices (guid varchar(32) PRIMARY KEY NOT NULL, id varchar(2048) NOT NULL, date_opened timestamp without time zone, date_posted timestamp without time zone, notes varchar(2048) NOT NULL, active integer NOT NULL, currency varchar(32) NOT NULL, owner_type integer, owner_guid varchar(32), terms varchar(32), billing_id varchar(2048), post_txn varchar(32), post_lot varchar(32), post_acc varchar(32), billto_type integer, billto_guid varchar(32), charge_amt_num int8, charge_amt_denom int8)
2017-11-24 12:13:24.830 CST [4560] LOG:  statement: INSERT INTO versions VALUES('invoices',3)
2017-11-24 12:13:24.834 CST [4560] LOG:  statement: CREATE TABLE jobs (guid varchar(32) PRIMARY KEY NOT NULL, id varchar(2048) NOT NULL, name varchar(2048) NOT NULL, reference varchar(2048) NOT NULL, active integer NOT NULL, owner_type integer, owner_guid varchar(32))
2017-11-24 12:13:25.078 CST [4560] LOG:  statement: INSERT INTO versions VALUES('jobs',1)
2017-11-24 12:13:25.084 CST [4560] LOG:  statement: CREATE TABLE orders (guid varchar(32) PRIMARY KEY NOT NULL, id varchar(2048) NOT NULL, notes varchar(2048) NOT NULL, reference varchar(2048) NOT NULL, active integer NOT NULL, date_opened timestamp without time zone NOT NULL, date_closed timestamp without time zone NOT NULL, owner_type integer NOT NULL, owner_guid varchar(32) NOT NULL)
2017-11-24 12:13:25.186 CST [4560] LOG:  statement: INSERT INTO versions VALUES('orders',1)
2017-11-24 12:13:25.192 CST [4560] LOG:  statement: CREATE TABLE taxtables (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(50) NOT NULL, refcount int8 NOT NULL, invisible integer NOT NULL, parent varchar(32))
2017-11-24 12:13:25.228 CST [4560] LOG:  statement: INSERT INTO versions VALUES('taxtables',2)
2017-11-24 12:13:25.229 CST [4560] LOG:  statement: CREATE TABLE taxtable_entries (id serial PRIMARY KEY NOT NULL, taxtable varchar(32) NOT NULL, account varchar(32) NOT NULL, amount_num int8 NOT NULL, amount_denom int8 NOT NULL, type integer NOT NULL)
2017-11-24 12:13:25.278 CST [4560] LOG:  statement: INSERT INTO versions VALUES('taxtable_entries',3)
2017-11-24 12:13:25.285 CST [4560] LOG:  statement: CREATE TABLE vendors (guid varchar(32) PRIMARY KEY NOT NULL, name varchar(2048) NOT NULL, id varchar(2048) NOT NULL, notes varchar(2048) NOT NULL, currency varchar(32) NOT NULL, active integer NOT NULL, tax_override integer NOT NULL, addr_name varchar(1024), addr_addr1 varchar(1024), addr_addr2 varchar(1024), addr_addr3 varchar(1024), addr_addr4 varchar(1024), addr_phone varchar(128), addr_fax varchar(128), addr_email varchar(256), terms varchar(32), tax_inc varchar(2048), tax_table varchar(32))
2017-11-24 12:13:25.480 CST [4560] LOG:  statement: INSERT INTO versions VALUES('vendors',1)
2017-11-24 12:13:25.486 CST [4560] LOG:  statement: CREATE TABLE recurrences (id serial PRIMARY KEY NOT NULL, obj_guid varchar(32) NOT NULL, recurrence_mult integer NOT NULL, recurrence_period_type varchar(2048) NOT NULL, recurrence_period_start date NOT NULL, recurrence_weekend_adjust varchar(2048) NOT NULL)
2017-11-24 12:13:25.695 CST [4560] LOG:  statement: INSERT INTO versions VALUES('recurrences',2)
2017-11-24 12:13:25.701 CST [4560] LOG:  statement: CREATE TABLE slots (id serial PRIMARY KEY NOT NULL, obj_guid varchar(32) NOT NULL, name varchar(4096) NOT NULL, slot_type integer NOT NULL, int64_val int8, string_val varchar(4096), double_val double precision, timespec_val timestamp without time zone, guid_val varchar(32), numeric_val_num int8, numeric_val_denom int8, gdate_val date)
2017-11-24 12:13:25.828 CST [4560] LOG:  statement: INSERT INTO versions VALUES('slots',3)
2017-11-24 12:13:25.828 CST [4560] LOG:  statement: CREATE INDEX slots_guid_index ON slots (obj_guid)
2017-11-24 12:13:25.870 CST [4560] LOG:  statement: SAVEPOINT savepoint_1
2017-11-24 12:13:25.871 CST [4560] LOG:  statement: INSERT INTO books(guid,root_account_guid,root_template_guid) VALUES('3c8c9ca5410d4f61868874fdb2680b54','6a2aabe15a4b48496279f04798b43ede','a9e25d76672da889fabb4f2cc878a683')
2017-11-24 12:13:25.873 CST [4560] LOG:  statement: INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('3c8c9ca5410d4f61868874fdb2680b54','options',9,0,NULL,0,'19700101 000000','9153278158df2c07d9329ceadb23b3e1',0,1,NULL)
2017-11-24 12:13:25.876 CST [4560] LOG:  statement: INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('9153278158df2c07d9329ceadb23b3e1','options/Budgeting',9,0,NULL,0,'19700101 000000','2e3f4db5c98c70d6b84d1741ae31e0f7',0,1,NULL)
2017-11-24 12:13:25.877 CST [4560] LOG:  statement: INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('3c8c9ca5410d4f61868874fdb2680b54','counter_formats',9,0,NULL,0,'19700101 000000','bb832df9e792644c2180286dfc428124',0,1,NULL)
2017-11-24 12:13:25.883 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.891 CST [4560] LOG:  statement: INSERT INTO commodities(guid,namespace,mnemonic,fullname,cusip,fraction,quote_flag,quote_source,quote_tz) VALUES('5daacb2fdf11aedac7970f153f497105','CURRENCY','NIO','Cordoba Oro','558',100,1,'currency','')
2017-11-24 12:13:25.893 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('6a2aabe15a4b48496279f04798b43ede','Root Account','ROOT','5daacb2fdf11aedac7970f153f497105',100,0,NULL,'','',0,0)
2017-11-24 12:13:25.894 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.898 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('b7917dd490d59c5a0151e029f8c62676','Assets','ASSET','5daacb2fdf11aedac7970f153f497105',100,0,'6a2aabe15a4b48496279f04798b43ede','','Assets',0,1)
2017-11-24 12:13:25.899 CST [4560] LOG:  statement: INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('b7917dd490d59c5a0151e029f8c62676','placeholder',4,0,'true',0,'19700101 000000',NULL,0,1,NULL)
2017-11-24 12:13:25.899 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.903 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('ec2e0d98e93ede527b390e82d841877f','Current Assets','ASSET','5daacb2fdf11aedac7970f153f497105',100,0,'b7917dd490d59c5a0151e029f8c62676','','Current Assets',0,1)
2017-11-24 12:13:25.904 CST [4560] LOG:  statement: INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('ec2e0d98e93ede527b390e82d841877f','placeholder',4,0,'true',0,'19700101 000000',NULL,0,1,NULL)
2017-11-24 12:13:25.905 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.908 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('95c72ca5a879e61bd5a3eb26d1c69566','Checking Account','BANK','5daacb2fdf11aedac7970f153f497105',100,0,'ec2e0d98e93ede527b390e82d841877f','','Checking Account',0,0)
2017-11-24 12:13:25.909 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.913 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('f3b515b535e2f957dcd350768068ce8b','Savings Account','BANK','5daacb2fdf11aedac7970f153f497105',100,0,'ec2e0d98e93ede527b390e82d841877f','','Savings Account',0,0)
2017-11-24 12:13:25.913 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.917 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('50d21a77aca7e1ce36efe269c0515c44','Cash in Wallet','CASH','5daacb2fdf11aedac7970f153f497105',100,0,'ec2e0d98e93ede527b390e82d841877f','','Cash in Wallet',0,0)
2017-11-24 12:13:25.918 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.922 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('7c474f03f5c0a14e94dee01d6b1e8268','Liabilities','LIABILITY','5daacb2fdf11aedac7970f153f497105',100,0,'6a2aabe15a4b48496279f04798b43ede','','Liabilities',0,1)
2017-11-24 12:13:25.922 CST [4560] LOG:  statement: INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('7c474f03f5c0a14e94dee01d6b1e8268','placeholder',4,0,'true',0,'19700101 000000',NULL,0,1,NULL)
2017-11-24 12:13:25.923 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.927 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('ca031c9fb549f989fe18b845ed8ba83e','Credit Card','CREDIT','5daacb2fdf11aedac7970f153f497105',100,0,'7c474f03f5c0a14e94dee01d6b1e8268','','Credit Card',0,0)
2017-11-24 12:13:25.927 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.931 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('7090fb2ab15fff56b7182f5d29bea26e','Income','INCOME','5daacb2fdf11aedac7970f153f497105',100,0,'6a2aabe15a4b48496279f04798b43ede','','Income',0,1)
2017-11-24 12:13:25.932 CST [4560] LOG:  statement: INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('7090fb2ab15fff56b7182f5d29bea26e','placeholder',4,0,'true',0,'19700101 000000',NULL,0,1,NULL)
2017-11-24 12:13:25.932 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.936 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('cf3031998cdc4d9c1057538492a488d3','Bonus','INCOME','5daacb2fdf11aedac7970f153f497105',100,0,'7090fb2ab15fff56b7182f5d29bea26e','','Bonus',0,0)
2017-11-24 12:13:25.936 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.940 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('92eb9e645a1e98e743fc344b767ede52','Gifts Received','INCOME','5daacb2fdf11aedac7970f153f497105',100,0,'7090fb2ab15fff56b7182f5d29bea26e','','Gifts Received',0,0)
2017-11-24 12:13:25.941 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.944 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('38f4f7377e0f0c8ac8632d1df39f24ae','Interest Income','INCOME','5daacb2fdf11aedac7970f153f497105',100,0,'7090fb2ab15fff56b7182f5d29bea26e','','Interest Income',0,0)
2017-11-24 12:13:25.945 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.949 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('9eeffc3d9171b6416de1defe5addafd1','Checking Interest','INCOME','5daacb2fdf11aedac7970f153f497105',100,0,'38f4f7377e0f0c8ac8632d1df39f24ae','','Checking Interest',0,0)
2017-11-24 12:13:25.949 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.953 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('6e3b64adcf72c75e3f30c4c5f365a4f4','Other Interest','INCOME','5daacb2fdf11aedac7970f153f497105',100,0,'38f4f7377e0f0c8ac8632d1df39f24ae','','Other Interest',0,0)
2017-11-24 12:13:25.953 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.957 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('0cffdfb4a551114ddd12b498a0800cf6','Savings Interest','INCOME','5daacb2fdf11aedac7970f153f497105',100,0,'38f4f7377e0f0c8ac8632d1df39f24ae','','Savings Interest',0,0)
2017-11-24 12:13:25.957 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.961 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('4d159f9b4a19b393e000488282e87abf','Other Income','INCOME','5daacb2fdf11aedac7970f153f497105',100,0,'7090fb2ab15fff56b7182f5d29bea26e','','Other Income',0,0)
2017-11-24 12:13:25.961 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.965 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('851650996b495fd8a43f7dc2d4b5db74','Salary','INCOME','5daacb2fdf11aedac7970f153f497105',100,0,'7090fb2ab15fff56b7182f5d29bea26e','','Salary',0,0)
2017-11-24 12:13:25.965 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.969 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('4421cbe44b4e43b5021f362835de0aef','Expenses','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'6a2aabe15a4b48496279f04798b43ede','','Expenses',0,1)
2017-11-24 12:13:25.969 CST [4560] LOG:  statement: INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('4421cbe44b4e43b5021f362835de0aef','placeholder',4,0,'true',0,'19700101 000000',NULL,0,1,NULL)
2017-11-24 12:13:25.970 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.973 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('425db7f5e9c5069a87aced02e0ca930a','Adjustment','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Adjustment',0,0)
2017-11-24 12:13:25.974 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.977 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('87b95d7e063bcb200d0a64a1610b746c','Auto','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Auto',0,0)
2017-11-24 12:13:25.978 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.981 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('1a68d6f2e2d97df28516634657d9b0bb','Fees','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'87b95d7e063bcb200d0a64a1610b746c','','Fees',0,0)
2017-11-24 12:13:25.982 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.986 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('e7aff722df9d92884aacb47b1565ebda','Gas','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'87b95d7e063bcb200d0a64a1610b746c','','Gas',0,0)
2017-11-24 12:13:25.986 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.990 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('35234b08a6bdcfb25f4df95b2209c039','Parking','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'87b95d7e063bcb200d0a64a1610b746c','','Parking',0,0)
2017-11-24 12:13:25.991 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.995 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('76ce1957a1e50b43c4f68c8fb6b880c4','Repair and Maintenance','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'87b95d7e063bcb200d0a64a1610b746c','','Repair and Maintenance',0,0)
2017-11-24 12:13:25.995 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:25.999 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('d7ed05661ac6f8e431358d8adf826ab3','Bank Service Charge','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Bank Service Charge',0,0)
2017-11-24 12:13:26.000 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.004 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('6da15aaf4df31e11a1ba82660dd24f22','Books','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Books',0,0)
2017-11-24 12:13:26.004 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.008 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('462b4943bc185fec398fb5a35f6f22f6','Cable','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Cable',0,0)
2017-11-24 12:13:26.009 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.012 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('f7919a43a5b49d95e75cb52593527ffd','Charity','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Charity',0,0)
2017-11-24 12:13:26.013 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.017 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('681edcac2813090744e3dac59917a05f','Clothes','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Clothes',0,0)
2017-11-24 12:13:26.017 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.021 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('336bceed5b8268bae091fc3e1af21ef2','Computer','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Computer',0,0)
2017-11-24 12:13:26.022 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.025 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('e2325be535434674a5f66bd7ebb58a34','Dining','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Dining',0,0)
2017-11-24 12:13:26.026 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.029 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('8acd9ab592681caf40a5ed1428f83211','Education','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Education',0,0)
2017-11-24 12:13:26.030 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.034 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('6378ba723136245378df3b64ac213225','Entertainment','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Entertainment',0,0)
2017-11-24 12:13:26.034 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.038 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('c7f099e2b65b411e135645f1277194f2','Music/Movies','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'6378ba723136245378df3b64ac213225','','Music/Movies',0,0)
2017-11-24 12:13:26.038 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.042 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('7053819f50e3c63fec545200018567b4','Recreation','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'6378ba723136245378df3b64ac213225','','Recreation',0,0)
2017-11-24 12:13:26.043 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.046 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('20e9dd3c5b3e9b75804bd74c6113f2e8','Travel','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'6378ba723136245378df3b64ac213225','','Travel',0,0)
2017-11-24 12:13:26.047 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.051 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('f98902d90a6cf9f4972a98f27a139acb','Gifts','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Gifts',0,0)
2017-11-24 12:13:26.051 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.055 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('3c8731f719d3b6df04e59377f0678aac','Groceries','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Groceries',0,0)
2017-11-24 12:13:26.055 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.059 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('2abae12701ddb75a3897940ae3772f39','Hobbies','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Hobbies',0,0)
2017-11-24 12:13:26.059 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.063 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('ed14ca9094c52410d72fedbea2c0f492','Insurance','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Insurance',0,0)
2017-11-24 12:13:26.063 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.067 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('00f56fca32c11971b1aba28fe64c032f','Auto Insurance','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'ed14ca9094c52410d72fedbea2c0f492','','Auto Insurance',0,0)
2017-11-24 12:13:26.068 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.071 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('d9bca4bbb127fa8a0aab7c799ae78af7','Health Insurance','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'ed14ca9094c52410d72fedbea2c0f492','','Health Insurance',0,0)
2017-11-24 12:13:26.072 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.075 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('95328579e35fd4419b42d88bac0d12a7','Life Insurance','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'ed14ca9094c52410d72fedbea2c0f492','','Life Insurance',0,0)
2017-11-24 12:13:26.076 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.079 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('65ecb71e9c55bff8336f1ad0034483ca','Laundry/Dry Cleaning','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Laundry/Dry Cleaning',0,0)
2017-11-24 12:13:26.079 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.083 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('060a8c02abe580b6273195edf0282d26','Medical Expenses','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Medical Expenses',0,0)
2017-11-24 12:13:26.083 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.087 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('afab4a6186f1b3729e3b38180c69c18d','Miscellaneous','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Miscellaneous',0,0)
2017-11-24 12:13:26.088 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.092 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('e20bd497d3e3b6a2e7f83f70559da496','Online Services','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Online Services',0,0)
2017-11-24 12:13:26.092 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.096 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('a8e73481372f21a5aa65f37ca8d4bf44','Phone','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Phone',0,0)
2017-11-24 12:13:26.096 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.100 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('d4b1c7eaa7e5f9a05df4bd77f48a5f5f','Public Transportation','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Public Transportation',0,0)
2017-11-24 12:13:26.101 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.104 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('36951d586ebb19dda83c64c37dbfcaee','Subscriptions','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Subscriptions',0,0)
2017-11-24 12:13:26.105 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.108 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('ab459683fe5da7b79d0ea9cba403ff47','Supplies','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Supplies',0,0)
2017-11-24 12:13:26.109 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.112 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('d17aaa5d70a2cd0540020f85e1080b96','Taxes','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Taxes',0,0)
2017-11-24 12:13:26.113 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.116 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('85b1990fc49794149234c4d6df729b8a','Federal','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'d17aaa5d70a2cd0540020f85e1080b96','','Federal',0,0)
2017-11-24 12:13:26.117 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.120 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('0975abb2c635a4c3e1794b8532af0010','Medicare','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'d17aaa5d70a2cd0540020f85e1080b96','','Medicare',0,0)
2017-11-24 12:13:26.120 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.124 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('4178e11bc7dc90e2dea22eb4d7757561','Other Tax','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'d17aaa5d70a2cd0540020f85e1080b96','','Other Tax',0,0)
2017-11-24 12:13:26.124 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.128 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('4c70ca45983892ea77afcb7afdc7e773','Social Security','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'d17aaa5d70a2cd0540020f85e1080b96','','Social Security',0,0)
2017-11-24 12:13:26.128 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.132 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('6f96bb57f4b8b0931e10dedbdd3c1b13','State/Province','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'d17aaa5d70a2cd0540020f85e1080b96','','State/Province',0,0)
2017-11-24 12:13:26.132 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.136 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('7da4ddd5fd27baab681c974f635a4877','Utilities','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'4421cbe44b4e43b5021f362835de0aef','','Utilities',0,0)
2017-11-24 12:13:26.136 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.139 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('7039f1971406c60ca48d22518beb5520','Electric','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'7da4ddd5fd27baab681c974f635a4877','','Electric',0,0)
2017-11-24 12:13:26.140 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.143 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('c835bacf339748e845b9e7c5d06bf06e','Garbage collection','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'7da4ddd5fd27baab681c974f635a4877','','Garbage collection',0,0)
2017-11-24 12:13:26.144 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.147 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('2f3df5f463d6ef4f118c78ab863ef7e0','Gas','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'7da4ddd5fd27baab681c974f635a4877','','Gas',0,0)
2017-11-24 12:13:26.148 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.151 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('5abf1981d57e6dbfeb3c86a631de61da','Water','EXPENSE','5daacb2fdf11aedac7970f153f497105',100,0,'7da4ddd5fd27baab681c974f635a4877','','Water',0,0)
2017-11-24 12:13:26.152 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.155 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('fb8e5ac9d47fa9ca835476aa491d2007','Equity','EQUITY','5daacb2fdf11aedac7970f153f497105',100,0,'6a2aabe15a4b48496279f04798b43ede','','Equity',0,1)
2017-11-24 12:13:26.156 CST [4560] LOG:  statement: INSERT INTO slots(obj_guid,name,slot_type,int64_val,string_val,double_val,timespec_val,guid_val,numeric_val_num,numeric_val_denom,gdate_val) VALUES('fb8e5ac9d47fa9ca835476aa491d2007','placeholder',4,0,'true',0,'19700101 000000',NULL,0,1,NULL)
2017-11-24 12:13:26.156 CST [4560] LOG:  statement: SELECT guid FROM commodities WHERE guid = '5daacb2fdf11aedac7970f153f497105'
2017-11-24 12:13:26.160 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('4cf999279b645411b32ce1e7b08c86eb','Opening Balances','EQUITY','5daacb2fdf11aedac7970f153f497105',100,0,'fb8e5ac9d47fa9ca835476aa491d2007','','Opening Balances',0,0)
2017-11-24 12:13:26.166 CST [4560] LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('a9e25d76672da889fabb4f2cc878a683','Template Root','ROOT',NULL,0,0,NULL,'','',0,0)
2017-11-24 12:13:26.209 CST [4560] LOG:  statement: RELEASE SAVEPOINT savepoint_1
2017-11-24 12:13:26.218 CST [4560] LOG:  statement: DROP TABLE numtest_back
2017-11-24 12:13:26.220 CST [4560] LOG:  statement: COMMIT
