2017-11-18 12:06:29 CST LOG:  database system was shut down at 2017-11-18 11:52:53 CST
2017-11-18 12:06:30 CST LOG:  MultiXact member wraparound protections are now enabled
2017-11-18 12:06:30 CST LOG:  database system is ready to accept connections
2017-11-18 12:07:55 CST FATAL:  database "mycash" does not exist
2017-11-18 12:07:55 CST LOG:  statement: set client_encoding to 'UNICODE'
2017-11-18 12:07:55 CST LOG:  statement: CREATE DATABASE mycash WITH TEMPLATE template0 ENCODING 'UTF8'
2017-11-18 12:08:09 CST LOG:  statement: ALTER DATABASE mycash SET standard_conforming_strings TO on
2017-11-18 12:08:10 CST LOG:  statement: set client_encoding to 'UNICODE'
2017-11-18 12:08:10 CST LOG:  statement: CREATE TEMPORARY TABLE numtest ( test_int BIGINT, test_unsigned BIGINT, test_double FLOAT8 )
2017-11-18 12:08:10 CST LOG:  statement: INSERT INTO numtest VALUES (-9223372036854775807, 9223372036854775807, 1.7976921348623158e+307)
2017-11-18 12:08:10 CST LOG:  statement: SELECT * FROM numtest
2017-11-18 12:08:10 CST LOG:  statement: BEGIN
2017-11-18 12:08:10 CST 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 = 'mycash') ORDER BY relname
2017-11-18 12:08:10 CST LOG:  statement: CREATE TABLE gnclock ( Hostname varchar(255), PID int )
2017-11-18 12:08:10 CST LOG:  statement: SELECT * FROM gnclock
2017-11-18 12:08:10 CST LOG:  statement: INSERT INTO gnclock VALUES ('Wesker', '3796')
2017-11-18 12:08:10 CST LOG:  statement: COMMIT
2017-11-18 12:08:10 CST 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 = 'mycash') ORDER BY relname
2017-11-18 12:08:10 CST LOG:  statement: BEGIN
2017-11-18 12:08:10 CST LOG:  statement: SELECT relname FROM pg_class WHERE relname !~ '^pg_' AND relkind = 'r' AND relowner = (SELECT datdba FROM pg_database WHERE datname = 'mycash') ORDER BY relname
2017-11-18 12:08:10 CST LOG:  statement: ALTER TABLE numtest RENAME TO numtest_back
2017-11-18 12:08:10 CST 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-18 12:08:10 CST LOG:  statement: CREATE TABLE versions (table_name varchar(50) PRIMARY KEY NOT NULL, table_version integer NOT NULL)
2017-11-18 12:08:10 CST LOG:  statement: INSERT INTO versions VALUES('Gnucash',2061800)
2017-11-18 12:08:10 CST LOG:  statement: INSERT INTO versions VALUES('Gnucash-Resave',19920)
2017-11-18 12:08:10 CST 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-18 12:08:10 CST LOG:  statement: INSERT INTO versions VALUES('accounts',1)
2017-11-18 12:08:10 CST 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-18 12:08:10 CST LOG:  statement: INSERT INTO versions VALUES('books',1)
2017-11-18 12:08:10 CST 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-18 12:08:10 CST LOG:  statement: INSERT INTO versions VALUES('budgets',1)
2017-11-18 12:08:10 CST 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-18 12:08:10 CST LOG:  statement: INSERT INTO versions VALUES('budget_amounts',1)
2017-11-18 12:08:10 CST 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-18 12:08:10 CST LOG:  statement: INSERT INTO versions VALUES('commodities',1)
2017-11-18 12:08:11 CST LOG:  statement: CREATE TABLE lots (guid varchar(32) PRIMARY KEY NOT NULL, account_guid varchar(32), is_closed integer NOT NULL)
2017-11-18 12:08:11 CST LOG:  statement: INSERT INTO versions VALUES('lots',2)
2017-11-18 12:08:11 CST 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-18 12:08:11 CST LOG:  statement: INSERT INTO versions VALUES('prices',2)
2017-11-18 12:08:11 CST 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-18 12:08:11 CST LOG:  statement: INSERT INTO versions VALUES('schedxactions',1)
2017-11-18 12:08:11 CST 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-18 12:08:11 CST LOG:  statement: INSERT INTO versions VALUES('transactions',3)
2017-11-18 12:08:11 CST LOG:  statement: CREATE INDEX tx_post_date_index ON transactions (post_date)
2017-11-18 12:08:11 CST 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-18 12:08:11 CST LOG:  statement: INSERT INTO versions VALUES('splits',4)
2017-11-18 12:08:11 CST LOG:  statement: CREATE INDEX splits_tx_guid_index ON splits (tx_guid)
2017-11-18 12:08:11 CST LOG:  statement: CREATE INDEX splits_account_guid_index ON splits (account_guid)
2017-11-18 12:08:11 CST 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-18 12:08:11 CST LOG:  statement: INSERT INTO versions VALUES('billterms',2)
2017-11-18 12:08:11 CST 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-18 12:08:11 CST LOG:  statement: INSERT INTO versions VALUES('customers',2)
2017-11-18 12:08:11 CST 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-18 12:08:11 CST LOG:  statement: INSERT INTO versions VALUES('employees',2)
2017-11-18 12:08:11 CST 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-18 12:08:11 CST LOG:  statement: INSERT INTO versions VALUES('entries',3)
2017-11-18 12:08:11 CST 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-18 12:08:12 CST LOG:  statement: INSERT INTO versions VALUES('invoices',3)
2017-11-18 12:08:12 CST 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-18 12:08:12 CST LOG:  statement: INSERT INTO versions VALUES('jobs',1)
2017-11-18 12:08:12 CST 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-18 12:08:12 CST LOG:  statement: INSERT INTO versions VALUES('orders',1)
2017-11-18 12:08:12 CST 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-18 12:08:12 CST LOG:  statement: INSERT INTO versions VALUES('taxtables',2)
2017-11-18 12:08:12 CST 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-18 12:08:12 CST LOG:  statement: INSERT INTO versions VALUES('taxtable_entries',3)
2017-11-18 12:08:12 CST 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-18 12:08:12 CST LOG:  statement: INSERT INTO versions VALUES('vendors',1)
2017-11-18 12:08:12 CST 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-18 12:08:12 CST LOG:  statement: INSERT INTO versions VALUES('recurrences',2)
2017-11-18 12:08:12 CST 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-18 12:08:12 CST LOG:  statement: INSERT INTO versions VALUES('slots',3)
2017-11-18 12:08:12 CST LOG:  statement: CREATE INDEX slots_guid_index ON slots (obj_guid)
2017-11-18 12:08:13 CST LOG:  statement: SAVEPOINT savepoint_1
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO books(guid,root_account_guid,root_template_guid) VALUES('67a86baaf5fd90bf790e524f2d50a686','301a7db028ad8f3481b412592640c52e','ede34b1ff1ea1c7f57ab0bb2c18400f4')
2017-11-18 12:08:13 CST 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('67a86baaf5fd90bf790e524f2d50a686','options',9,0,NULL,0,'19700101 000000','a6e90627bbe1e7b5c2a8008833edf382',0,1,NULL)
2017-11-18 12:08:13 CST 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('a6e90627bbe1e7b5c2a8008833edf382','options/Budgeting',9,0,NULL,0,'19700101 000000','7c8dc8628d97f9c79b9fec72f9b041a2',0,1,NULL)
2017-11-18 12:08:13 CST 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('67a86baaf5fd90bf790e524f2d50a686','counter_formats',9,0,NULL,0,'19700101 000000','4d74e4f477592324994b1736f0050628',0,1,NULL)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO commodities(guid,namespace,mnemonic,fullname,cusip,fraction,quote_flag,quote_source,quote_tz) VALUES('ad79a647fcda3c22874077cad6e5d25f','CURRENCY','NIO','Cordoba Oro','558',100,1,'currency','')
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('301a7db028ad8f3481b412592640c52e','Root Account','ROOT','ad79a647fcda3c22874077cad6e5d25f',100,0,NULL,'','',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('1d72ff1d8477f261400d218e174a7892','Activo','ASSET','ad79a647fcda3c22874077cad6e5d25f',100,0,'301a7db028ad8f3481b412592640c52e','','Activo',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('7a897d059a231eec14262d65cfb62411','Activo circulante','ASSET','ad79a647fcda3c22874077cad6e5d25f',100,0,'1d72ff1d8477f261400d218e174a7892','','Activo circulante',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('1c17ea3a8129d612abf637f189b1852e','Cuenta corriente','BANK','ad79a647fcda3c22874077cad6e5d25f',100,0,'7a897d059a231eec14262d65cfb62411','','Cuenta corriente',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('c08cfb7b932921c449cbf3ea2b19298b','Cuenta de ahorros','BANK','ad79a647fcda3c22874077cad6e5d25f',100,0,'7a897d059a231eec14262d65cfb62411','','Cuenta de ahorros',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('1739c885fc2a17a6af73ca62ea9c0189','Metálico','CASH','ad79a647fcda3c22874077cad6e5d25f',100,0,'7a897d059a231eec14262d65cfb62411','','Metálico',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('5b3bbe8329680f0327aadf16485b0f1e','Pasivo','LIABILITY','ad79a647fcda3c22874077cad6e5d25f',100,0,'301a7db028ad8f3481b412592640c52e','','Pasivo',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('cc69bdf112b61d8182fb3ac4e4d793a2','Cuentas por pagar','LIABILITY','ad79a647fcda3c22874077cad6e5d25f',100,0,'5b3bbe8329680f0327aadf16485b0f1e','','Cuentas por pagar',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('40a3f08c8176a1859df3fe004b9cdbad','Tarjeta de crédito','CREDIT','ad79a647fcda3c22874077cad6e5d25f',100,0,'cc69bdf112b61d8182fb3ac4e4d793a2','','Tarjeta de crédito',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('0fbae8dfcd57706a6e75e1e2e6db44d5','Ingresos','INCOME','ad79a647fcda3c22874077cad6e5d25f',100,0,'301a7db028ad8f3481b412592640c52e','','Ingresos',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('f2c29b0bbbc271400f2be05fbeb1495a','Pagas extra','INCOME','ad79a647fcda3c22874077cad6e5d25f',100,0,'0fbae8dfcd57706a6e75e1e2e6db44d5','','Pagas extra',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('01462ff85bbc525e73d583c5a721c77a','Regalos recibidos','INCOME','ad79a647fcda3c22874077cad6e5d25f',100,0,'0fbae8dfcd57706a6e75e1e2e6db44d5','','Regalos recibidos',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('f3a787eba2df74151d917565a0b3b901','Ingresos por intereses','INCOME','ad79a647fcda3c22874077cad6e5d25f',100,0,'0fbae8dfcd57706a6e75e1e2e6db44d5','','Ingresos por intereses',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('9999a7eb2626d5ed293f2ea16309016a','Intereses de cuenta corriente','INCOME','ad79a647fcda3c22874077cad6e5d25f',100,0,'f3a787eba2df74151d917565a0b3b901','','Intereses de cuenta corriente',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('618914474f490530e2bd76898b8596ac','Otros intereses','INCOME','ad79a647fcda3c22874077cad6e5d25f',100,0,'f3a787eba2df74151d917565a0b3b901','','Otros intereses',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('99d0345f318fef476acdf2a1dedcb67c','Intereses cuenta de ahorros','INCOME','ad79a647fcda3c22874077cad6e5d25f',100,0,'f3a787eba2df74151d917565a0b3b901','','Intereses cuenta de ahorros',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('85fb21f25a159a81738b8dc98190bb27','Otros ingresos','INCOME','ad79a647fcda3c22874077cad6e5d25f',100,0,'0fbae8dfcd57706a6e75e1e2e6db44d5','','Otros ingresos',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('bcb7643926a9040a1bb0c69f3717281a','Sueldo','INCOME','ad79a647fcda3c22874077cad6e5d25f',100,0,'0fbae8dfcd57706a6e75e1e2e6db44d5','','Sueldo',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('70682af4713f2c426e32ef9a915674c9','Gastos','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'301a7db028ad8f3481b412592640c52e','','Gastos',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('69e17bcc47db2062da43afa2ad9ec808','Ajustes','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Ajustes',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('50c7179977053faaf664ef5f7fead416','Automóvil','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Automóvil',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('deb2e4e9d566e016a53571a09f9cfd37','Cuotas','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'50c7179977053faaf664ef5f7fead416','','Cuotas',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('766e34a86e0466a7e831626898e70994','Gas','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'50c7179977053faaf664ef5f7fead416','','Gas',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('e9a55f9e26a9f0e2ef8ba51c3d940bf8','Aparcamiento','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'50c7179977053faaf664ef5f7fead416','','Aparcamiento',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('7545bc26b4e2c09a5519c191e3c2c3ae','Reparación y mantenimiento','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'50c7179977053faaf664ef5f7fead416','','Reparación y mantenimiento',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('e29a40dd62a9317a950a4ba763210c42','Cargo de servicio bancario','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Cargo de servicio bancario',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('bade2ea50d5bbeee315db110ea6b24b0','Libros','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Libros',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('b0f7c2e84aa95b9d3ec325b4b6718684','TV Cable','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','TV Cable',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('1b53d7adae1a0cea1f60a60df561c359','Obras benéficas','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Obras benéficas',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('2faf04c397f54a54354c6f16475b85c9','Ropa','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Ropa',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('88d29da9470017151cfe6007cbeee695','Informática','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Informática',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('95aae49bdb0a645b77062112b57e7feb','Restaurantes','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Restaurantes',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('b421ce2c65ff87beb7d73a7a32f413f6','Educación','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Educación',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('f3cb5438121c0e3a8baeaa77e02309d3','Ocio','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Ocio',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('201501b64bc6dc82fc8f996b80aa00ef','Música/Películas','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'f3cb5438121c0e3a8baeaa77e02309d3','','Música/Películas',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('0a168375f1ef67bad434a202113de842','Recreación','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'f3cb5438121c0e3a8baeaa77e02309d3','','Recreación',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('d20af11bef46a367d445a50716bee014','Viajes','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'f3cb5438121c0e3a8baeaa77e02309d3','','Viajes',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('662dc4927bbd972aacb590a66c5c7ad3','Regalos','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Regalos',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('1feb336ec30afefa7c8f0ede15e76d72','Comestibles','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Comestibles',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('acc3265b25d899753708ac248b10d5e3','Hobbies','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Hobbies',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('e41c00d24de7698cc8fc2ea4673c462a','Seguros','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Seguros',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('86420e90e791ef43c4a26099df5c45ab','Seguro de automóvil','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'e41c00d24de7698cc8fc2ea4673c462a','','Seguro de automóvil',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('adf0a0ee4068b0e25b37a686895f73ff','Seguro sanitario','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'e41c00d24de7698cc8fc2ea4673c462a','','Seguro sanitario',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('670b538770aaee714254fbf10bea6c87','Seguro de vida','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'e41c00d24de7698cc8fc2ea4673c462a','','Seguro de vida',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('0f47ab055e4a9f1f5659295c1ff750cd','Lavandería','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Lavandería',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('c05ddab4c481a1f0d688ef28a2b7b186','Gastos médicos','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Gastos médicos',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('ae8dee4e24e1b36107bddae10aa01f4d','Otros gastos','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Otros gastos',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('bed05d37afa6ad99e849c1af08242201','Servicios Internet','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Servicios Internet',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('a89c48d15fe305a13b1561faed9ea6b4','Teléfono','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Teléfono',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('f96053e9a6fcf5a8defb8b87eabf1cb1','Transporte público','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Transporte público',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('a2cfd533f9fff03a49b8ba7da4af666e','Suscripciones','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Suscripciones',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('79ff83ccafebbf55cd4e425ceddf543f','Material de oficina','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Material de oficina',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('88b09e853e55d5ef8e9ae1a8d09fe78f','Impuestos','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Impuestos',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('9530909ca0ed64e13a168ea572057976','IRPF','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'88b09e853e55d5ef8e9ae1a8d09fe78f','','IRPF',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('17d3f3922458e3905b8788aa84b70aca','Retenciones','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'88b09e853e55d5ef8e9ae1a8d09fe78f','','Retenciones',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('9079aa1a9007d7b7ed479fdfc924fcee','Otros impuestos','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'88b09e853e55d5ef8e9ae1a8d09fe78f','','Otros impuestos',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('51247191aff0133bca6819c6c769aa4d','Seguridad Social','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'88b09e853e55d5ef8e9ae1a8d09fe78f','','Seguridad Social',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('9221caa0a631014ce841068c33340e3a','Municipales','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'88b09e853e55d5ef8e9ae1a8d09fe78f','','Municipales',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('77fa4a1f2b99b141634b271c4b22607a','Servicios','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'70682af4713f2c426e32ef9a915674c9','','Servicios',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('44cc06a4f1498cc19e3c95b1aaf7fe7f','Electricidad','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'77fa4a1f2b99b141634b271c4b22607a','','Electricidad',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('250455fb275950e704016d1f08b243eb','Recogida de basura','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'77fa4a1f2b99b141634b271c4b22607a','','Recogida de basura',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('83fbf200ddd124042ce8bf2983be3832','Gas','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'77fa4a1f2b99b141634b271c4b22607a','','Gas',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('05ce6ff4cdba4bc357601c1f8a7cee5a','Agua','EXPENSE','ad79a647fcda3c22874077cad6e5d25f',100,0,'77fa4a1f2b99b141634b271c4b22607a','','Agua',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('50255e4c18bc1931d8949ed554ec6e30','Resultado','EQUITY','ad79a647fcda3c22874077cad6e5d25f',100,0,'301a7db028ad8f3481b412592640c52e','','Resultado',0,0)
2017-11-18 12:08:13 CST LOG:  statement: SELECT guid FROM commodities WHERE guid = 'ad79a647fcda3c22874077cad6e5d25f'
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('0cedff7c08a4ed4ba3c20d329b3f5261','Balances de apertura','EQUITY','ad79a647fcda3c22874077cad6e5d25f',100,0,'50255e4c18bc1931d8949ed554ec6e30','','Balances de apertura',0,0)
2017-11-18 12:08:13 CST LOG:  statement: INSERT INTO accounts(guid,name,account_type,commodity_guid,commodity_scu,non_std_scu,parent_guid,code,description,hidden,placeholder) VALUES('ede34b1ff1ea1c7f57ab0bb2c18400f4','Template Root','ROOT',NULL,0,0,NULL,'','',0,0)
2017-11-18 12:08:13 CST LOG:  statement: RELEASE SAVEPOINT savepoint_1
2017-11-18 12:08:13 CST LOG:  statement: DROP TABLE numtest_back
2017-11-18 12:08:13 CST LOG:  statement: COMMIT
