[GNC] Gnucash 3.1 and fedora 28
maniek
settlerk at gmail.com
Sun May 27 12:56:09 EDT 2018
OK, I turned on query logs.
when my 2018 DB (a problematic one):
Tcp port: 0 Unix socket: /var/lib/mysql/mysql.sock
Time Id Command Argument
180527 18:51:29 8 Connect root at localhost as anonymous on gnucash_2018
8 Query SET NAMES 'utf8'
8 Query SELECT @@sql_mode
8 Query CREATE TEMPORARY TABLE numtest ( test_int BIGINT,
test_unsigned BIGINT, test_double FLOAT8 )
8 Query INSERT INTO numtest VALUES (-9223372036854775807,
9223372036854775807, 1.79769213486e+307)
8 Query SELECT * FROM numtest
8 Query DROP TABLE numtest
8 Query BEGIN
8 Query SHOW TABLES FROM `gnucash_2018` LIKE 'gnclock'
8 Query SELECT * FROM gnclock
8 Query INSERT INTO gnclock VALUES ('mario-lap', '24018')
8 Query COMMIT
8 Query SHOW TABLES FROM `gnucash_2018` LIKE '%back'
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE accounts
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE billterms
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE books
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE budget_amounts
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE budgets
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE commodities
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE customers
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE employees
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE entries
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE invoices
180527 18:51:30 8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE jobs
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE lots
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE orders
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE prices
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE recurrences
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE schedxactions
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE slots
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE splits
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE taxtable_entries
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE taxtables
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE transactions
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE vendors
8 Query SHOW TABLES FROM `gnucash_2018`
8 Query DROP TABLE versions
8 Query SHOW TABLES FROM `gnucash_2018` LIKE 'versions'
8 Query CREATE TABLE versions(table_name varchar(50) CHARACTER SET
utf8 PRIMARY KEY NOT NULL, table_version integer NOT NULL)
8 Query INSERT INTO versions VALUES('Gnucash',3000001)
8 Query INSERT INTO versions VALUES('Gnucash-Resave',19920)
8 Query CREATE TABLE books(guid varchar(32) PRIMARY KEY NOT NULL,
root_account_guid varchar(32) NOT NULL, root_template_guid varchar(32) NOT
NULL)
8 Query INSERT INTO versions VALUES('books',1)
8 Query CREATE TABLE commodities(guid varchar(32) PRIMARY KEY NOT
NULL, namespace varchar(2048) CHARACTER SET utf8 NOT NULL, mnemonic
varchar(2048) CHARACTER SET utf8 NOT NULL, fullname varchar(2048) CHARACTER
SET utf8, cusip varchar(2048) CHARACTER SET utf8, fraction integer NOT NULL,
quote_flag integer NOT NULL, quote_source varchar(2048) CHARACTER SET utf8,
quote_tz varchar(2048) CHARACTER SET utf8)
8 Query INSERT INTO versions VALUES('commodities',1)
8 Query CREATE TABLE accounts(guid varchar(32) PRIMARY KEY NOT NULL,
name varchar(2048) CHARACTER SET utf8 NOT NULL, account_type varchar(2048)
CHARACTER SET utf8 NOT NULL, commodity_guid varchar(32), commodity_scu
integer NOT NULL, non_std_scu integer NOT NULL, parent_guid varchar(32),
code varchar(2048) CHARACTER SET utf8, description varchar(2048) CHARACTER
SET utf8, hidden integer, placeholder integer)
8 Query INSERT INTO versions VALUES('accounts',1)
8 Query CREATE TABLE budgets(guid varchar(32) PRIMARY KEY NOT NULL,
name varchar(2048) CHARACTER SET utf8 NOT NULL, description varchar(2048)
CHARACTER SET utf8, num_periods integer NOT NULL)
8 Query INSERT INTO versions VALUES('budgets',1)
8 Query CREATE TABLE budget_amounts(id integer PRIMARY KEY
AUTO_INCREMENT NOT NULL, budget_guid varchar(32) NOT NULL, account_guid
varchar(32) NOT NULL, period_num integer NOT NULL, amount_num bigint NOT
NULL, amount_denom bigint NOT NULL)
8 Query INSERT INTO versions VALUES('budget_amounts',1)
8 Query CREATE TABLE prices(guid varchar(32) PRIMARY KEY NOT NULL,
commodity_guid varchar(32) NOT NULL, currency_guid varchar(32) NOT NULL,
date DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL, source
varchar(2048) CHARACTER SET utf8, type varchar(2048) CHARACTER SET utf8,
value_num bigint NOT NULL, value_denom bigint NOT NULL)
8 Query INSERT INTO versions VALUES('prices',3)
8 Query CREATE TABLE transactions(guid varchar(32) PRIMARY KEY NOT
NULL, currency_guid varchar(32) NOT NULL, num varchar(2048) CHARACTER SET
utf8 NOT NULL, post_date DATETIME NULL DEFAULT '1970-01-01 00:00:00',
enter_date DATETIME NULL DEFAULT '1970-01-01 00:00:00', description
varchar(2048) CHARACTER SET utf8)
8 Query INSERT INTO versions VALUES('transactions',4)
8 Query CREATE INDEX tx_post_date_index ON transactions(post_date)
8 Query 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) CHARACTER SET utf8 NOT NULL, action varchar(2048) CHARACTER
SET utf8 NOT NULL, reconcile_state varchar(1) CHARACTER SET utf8 NOT NULL,
reconcile_date DATETIME NULL DEFAULT '1970-01-01 00:00:00', value_num bigint
NOT NULL, value_denom bigint NOT NULL, quantity_num bigint NOT NULL,
quantity_denom bigint NOT NULL, lot_guid varchar(32))
8 Query INSERT INTO versions VALUES('splits',4)
8 Query CREATE INDEX splits_tx_guid_index ON splits(tx_guid)
8 Query CREATE INDEX splits_account_guid_index ON splits(account_guid)
8 Query CREATE TABLE slots(id integer PRIMARY KEY AUTO_INCREMENT NOT
NULL, obj_guid varchar(32) NOT NULL, name varchar(4096) CHARACTER SET utf8
NOT NULL, slot_type integer NOT NULL, int64_val bigint, string_val
varchar(4096) CHARACTER SET utf8, double_val double, timespec_val DATETIME
NULL DEFAULT '1970-01-01 00:00:00', guid_val varchar(32), numeric_val_num
bigint, numeric_val_denom bigint, gdate_val date)
8 Query INSERT INTO versions VALUES('slots',4)
8 Query CREATE INDEX slots_guid_index ON slots(obj_guid)
8 Query CREATE TABLE recurrences(id integer PRIMARY KEY AUTO_INCREMENT
NOT NULL, obj_guid varchar(32) NOT NULL, recurrence_mult integer NOT NULL,
recurrence_period_type varchar(2048) CHARACTER SET utf8 NOT NULL,
recurrence_period_start date NOT NULL, recurrence_weekend_adjust
varchar(2048) CHARACTER SET utf8 NOT NULL)
8 Query INSERT INTO versions VALUES('recurrences',2)
8 Query CREATE TABLE schedxactions(guid varchar(32) PRIMARY KEY NOT
NULL, name varchar(2048) CHARACTER SET utf8, 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)
8 Query INSERT INTO versions VALUES('schedxactions',1)
8 Query CREATE TABLE lots(guid varchar(32) PRIMARY KEY NOT NULL,
account_guid varchar(32), is_closed integer NOT NULL)
8 Query INSERT INTO versions VALUES('lots',2)
8 Query CREATE TABLE billterms(guid varchar(32) PRIMARY KEY NOT NULL,
name varchar(2048) CHARACTER SET utf8 NOT NULL, description varchar(2048)
CHARACTER SET utf8 NOT NULL, refcount integer NOT NULL, invisible integer
NOT NULL, parent varchar(32), type varchar(2048) CHARACTER SET utf8 NOT
NULL, duedays integer, discountdays integer, discount_num bigint,
discount_denom bigint, cutoff integer)
8 Query INSERT INTO versions VALUES('billterms',2)
8 Query CREATE TABLE customers(guid varchar(32) PRIMARY KEY NOT NULL,
name varchar(2048) CHARACTER SET utf8 NOT NULL, id varchar(2048) CHARACTER
SET utf8 NOT NULL, notes varchar(2048) CHARACTER SET utf8 NOT NULL, active
integer NOT NULL, discount_num bigint NOT NULL, discount_denom bigint NOT
NULL, credit_num bigint NOT NULL, credit_denom bigint NOT NULL, currency
varchar(32) NOT NULL, tax_override integer NOT NULL, addr_name varchar(1024)
CHARACTER SET utf8, addr_addr1 varchar(1024) CHARACTER SET utf8, addr_addr2
varchar(1024) CHARACTER SET utf8, addr_addr3 varchar(1024) CHARACTER SET
utf8, addr_addr4 varchar(1024) CHARACTER SET utf8, addr_phone varchar(128)
CHARACTER SET utf8, addr_fax varchar(128) CHARACTER SET utf8, addr_email
varchar(256) CHARACTER SET utf8, shipaddr_name varchar(1024) CHARACTER SET
utf8, shipaddr_addr1 varchar(1024) CHARACTER SET utf8, shipaddr_addr2
varchar(1024) CHARACTER SET utf8, shipaddr_addr3 varchar(1024) CHARACTER SET
utf8, shipaddr_addr4 varchar(1024) CHARACTER SET utf8, shipaddr_phone
varchar(128) CHARACTER SET utf8, shipaddr_fax varchar(128) CHARACTER SET
utf8, shipaddr_email varchar(256) CHARACTER SET utf8, terms varchar(32),
tax_included integer, taxtable varchar(32))
8 Query INSERT INTO versions VALUES('customers',2)
8 Query CREATE TABLE employees(guid varchar(32) PRIMARY KEY NOT NULL,
username varchar(2048) CHARACTER SET utf8 NOT NULL, id varchar(2048)
CHARACTER SET utf8 NOT NULL, language varchar(2048) CHARACTER SET utf8 NOT
NULL, acl varchar(2048) CHARACTER SET utf8 NOT NULL, active integer NOT
NULL, currency varchar(32) NOT NULL, ccard_guid varchar(32), workday_num
bigint NOT NULL, workday_denom bigint NOT NULL, rate_num bigint NOT NULL,
rate_denom bigint NOT NULL, addr_name varchar(1024) CHARACTER SET utf8,
addr_addr1 varchar(1024) CHARACTER SET utf8, addr_addr2 varchar(1024)
CHARACTER SET utf8, addr_addr3 varchar(1024) CHARACTER SET utf8, addr_addr4
varchar(1024) CHARACTER SET utf8, addr_phone varchar(128) CHARACTER SET
utf8, addr_fax varchar(128) CHARACTER SET utf8, addr_email varchar(256)
CHARACTER SET utf8)
8 Query INSERT INTO versions VALUES('employees',2)
8 Query CREATE TABLE entries(guid varchar(32) PRIMARY KEY NOT NULL,
date DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL, date_entered
DATETIME NULL DEFAULT '1970-01-01 00:00:00', description varchar(2048)
CHARACTER SET utf8, action varchar(2048) CHARACTER SET utf8, notes
varchar(2048) CHARACTER SET utf8, quantity_num bigint, quantity_denom
bigint, i_acct varchar(32), i_price_num bigint, i_price_denom bigint,
i_discount_num bigint, i_discount_denom bigint, invoice varchar(32),
i_disc_type varchar(2048) CHARACTER SET utf8, i_disc_how varchar(2048)
CHARACTER SET utf8, i_taxable integer, i_taxincluded integer, i_taxtable
varchar(32), b_acct varchar(32), b_price_num bigint, b_price_denom bigint,
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))
8 Query INSERT INTO versions VALUES('entries',4)
8 Query CREATE TABLE invoices(guid varchar(32) PRIMARY KEY NOT NULL,
id varchar(2048) CHARACTER SET utf8 NOT NULL, date_opened DATETIME NULL
DEFAULT '1970-01-01 00:00:00', date_posted DATETIME NULL DEFAULT '1970-01-01
00:00:00', notes varchar(2048) CHARACTER SET utf8 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) CHARACTER SET utf8,
post_txn varchar(32), post_lot varchar(32), post_acc varchar(32),
billto_type integer, billto_guid varchar(32), charge_amt_num bigint,
charge_amt_denom bigint)
8 Query INSERT INTO versions VALUES('invoices',4)
8 Query CREATE TABLE jobs(guid varchar(32) PRIMARY KEY NOT NULL, id
varchar(2048) CHARACTER SET utf8 NOT NULL, name varchar(2048) CHARACTER SET
utf8 NOT NULL, reference varchar(2048) CHARACTER SET utf8 NOT NULL, active
integer NOT NULL, owner_type integer, owner_guid varchar(32))
8 Query INSERT INTO versions VALUES('jobs',1)
8 Query CREATE TABLE orders(guid varchar(32) PRIMARY KEY NOT NULL, id
varchar(2048) CHARACTER SET utf8 NOT NULL, notes varchar(2048) CHARACTER SET
utf8 NOT NULL, reference varchar(2048) CHARACTER SET utf8 NOT NULL, active
integer NOT NULL, date_opened DATETIME NULL DEFAULT '1970-01-01 00:00:00'
NOT NULL, date_closed DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL,
owner_type integer NOT NULL, owner_guid varchar(32) NOT NULL)
8 Query INSERT INTO versions VALUES('orders',1)
8 Query CREATE TABLE taxtables(guid varchar(32) PRIMARY KEY NOT NULL,
name varchar(50) CHARACTER SET utf8 NOT NULL, refcount bigint NOT NULL,
invisible integer NOT NULL, parent varchar(32))
8 Query INSERT INTO versions VALUES('taxtables',2)
8 Query CREATE TABLE taxtable_entries(id integer PRIMARY KEY
AUTO_INCREMENT NOT NULL, taxtable varchar(32) NOT NULL, account varchar(32)
NOT NULL, amount_num bigint NOT NULL, amount_denom bigint NOT NULL, type
integer NOT NULL)
8 Query INSERT INTO versions VALUES('taxtable_entries',3)
8 Query CREATE TABLE vendors(guid varchar(32) PRIMARY KEY NOT NULL,
name varchar(2048) CHARACTER SET utf8 NOT NULL, id varchar(2048) CHARACTER
SET utf8 NOT NULL, notes varchar(2048) CHARACTER SET utf8 NOT NULL, currency
varchar(32) NOT NULL, active integer NOT NULL, tax_override integer NOT
NULL, addr_name varchar(1024) CHARACTER SET utf8, addr_addr1 varchar(1024)
CHARACTER SET utf8, addr_addr2 varchar(1024) CHARACTER SET utf8, addr_addr3
varchar(1024) CHARACTER SET utf8, addr_addr4 varchar(1024) CHARACTER SET
utf8, addr_phone varchar(128) CHARACTER SET utf8, addr_fax varchar(128)
CHARACTER SET utf8, addr_email varchar(256) CHARACTER SET utf8, terms
varchar(32), tax_inc varchar(2048) CHARACTER SET utf8, tax_table
varchar(32))
8 Query INSERT INTO versions VALUES('vendors',1)
8 Query SELECT * FROM books
8 Query BEGIN
8 Query INSERT INTO
accounts(guid,name,account_type,commodity_scu,non_std_scu,code,description,hidden,placeholder)
VALUES('0cf23c9744504403a37de61c3d048e05','Root
Account','ROOT',0,0,'','',0,0)
8 Query COMMIT
8 Query INSERT INTO books(guid,root_account_guid,root_template_guid)
VALUES('4a9c32f6dba34c0e8e7741fc5f2c5f4f','0cf23c9744504403a37de61c3d048e05','b5140e7165964efc96137f92701bba4c')
8 Query SELECT * FROM commodities
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM commodities)
8 Query SELECT * FROM accounts
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM accounts)
8 Query SELECT * FROM lots
8 Query SELECT * FROM billterms
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM billterms)
8 Query SELECT * FROM taxtables
8 Query SELECT * FROM invoices
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM invoices)
8 Query SELECT * FROM budgets
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM budgets)
8 Query SELECT * FROM prices
8 Query SELECT * FROM transactions
8 Query SELECT * FROM schedxactions
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM schedxactions)
8 Query SELECT * FROM customers
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM customers)
8 Query SELECT * FROM employees
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM employees)
8 Query SELECT * FROM entries
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM entries)
8 Query SELECT * FROM jobs
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM jobs)
8 Query SELECT * FROM orders
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM orders)
8 Query SELECT * FROM vendors
8 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM vendors)
*and when e.g. 2016:*
180527 18:52:44 9 Connect root at localhost as anonymous on gnucash_2016
9 Query SET NAMES 'utf8'
9 Query SELECT @@sql_mode
9 Query CREATE TEMPORARY TABLE numtest ( test_int BIGINT,
test_unsigned BIGINT, test_double FLOAT8 )
9 Query INSERT INTO numtest VALUES (-9223372036854775807,
9223372036854775807, 1.79769213486e+307)
9 Query SELECT * FROM numtest
9 Query DROP TABLE numtest
9 Query BEGIN
9 Query SHOW TABLES FROM `gnucash_2016` LIKE 'gnclock'
9 Query SELECT * FROM gnclock
9 Query INSERT INTO gnclock VALUES ('mario-lap', '24234')
9 Query COMMIT
9 Query SHOW TABLES FROM `gnucash_2016` LIKE '%back'
9 Query SHOW TABLES FROM `gnucash_2016` LIKE 'versions'
9 Query SELECT * FROM versions
9 Query CREATE TABLE prices_new(guid varchar(32) PRIMARY KEY NOT NULL,
commodity_guid varchar(32) NOT NULL, currency_guid varchar(32) NOT NULL,
date DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL, source
varchar(2048) CHARACTER SET utf8, type varchar(2048) CHARACTER SET utf8,
value_num bigint NOT NULL, value_denom bigint NOT NULL)
9 Query INSERT INTO prices_new SELECT * FROM prices
9 Query DROP TABLE prices
9 Query ALTER TABLE prices_new RENAME TO prices
9 Query UPDATE versions SET table_version=3 WHERE table_name='prices'
9 Query CREATE TABLE transactions_new(guid varchar(32) PRIMARY KEY NOT
NULL, currency_guid varchar(32) NOT NULL, num varchar(2048) CHARACTER SET
utf8 NOT NULL, post_date DATETIME NULL DEFAULT '1970-01-01 00:00:00',
enter_date DATETIME NULL DEFAULT '1970-01-01 00:00:00', description
varchar(2048) CHARACTER SET utf8)
9 Query INSERT INTO transactions_new SELECT * FROM transactions
9 Query DROP TABLE transactions
9 Query ALTER TABLE transactions_new RENAME TO transactions
9 Query UPDATE versions SET table_version=4 WHERE
table_name='transactions'
9 Query CREATE TABLE slots_new(id integer PRIMARY KEY AUTO_INCREMENT
NOT NULL, obj_guid varchar(32) NOT NULL, name varchar(4096) CHARACTER SET
utf8 NOT NULL, slot_type integer NOT NULL, int64_val bigint, string_val
varchar(4096) CHARACTER SET utf8, double_val double, timespec_val DATETIME
NULL DEFAULT '1970-01-01 00:00:00', guid_val varchar(32), numeric_val_num
bigint, numeric_val_denom bigint, gdate_val date)
9 Query INSERT INTO slots_new SELECT * FROM slots
9 Query DROP TABLE slots
9 Query ALTER TABLE slots_new RENAME TO slots
9 Query UPDATE versions SET table_version=4 WHERE table_name='slots'
9 Query CREATE TABLE entries_new(guid varchar(32) PRIMARY KEY NOT
NULL, date DATETIME NULL DEFAULT '1970-01-01 00:00:00' NOT NULL,
date_entered DATETIME NULL DEFAULT '1970-01-01 00:00:00', description
varchar(2048) CHARACTER SET utf8, action varchar(2048) CHARACTER SET utf8,
notes varchar(2048) CHARACTER SET utf8, quantity_num bigint, quantity_denom
bigint, i_acct varchar(32), i_price_num bigint, i_price_denom bigint,
i_discount_num bigint, i_discount_denom bigint, invoice varchar(32),
i_disc_type varchar(2048) CHARACTER SET utf8, i_disc_how varchar(2048)
CHARACTER SET utf8, i_taxable integer, i_taxincluded integer, i_taxtable
varchar(32), b_acct varchar(32), b_price_num bigint, b_price_denom bigint,
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))
9 Query INSERT INTO entries_new SELECT * FROM entries
9 Query DROP TABLE entries
9 Query ALTER TABLE entries_new RENAME TO entries
9 Query UPDATE versions SET table_version=4 WHERE table_name='entries'
9 Query CREATE TABLE invoices_new(guid varchar(32) PRIMARY KEY NOT
NULL, id varchar(2048) CHARACTER SET utf8 NOT NULL, date_opened DATETIME
NULL DEFAULT '1970-01-01 00:00:00', date_posted DATETIME NULL DEFAULT
'1970-01-01 00:00:00', notes varchar(2048) CHARACTER SET utf8 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)
CHARACTER SET utf8, post_txn varchar(32), post_lot varchar(32), post_acc
varchar(32), billto_type integer, billto_guid varchar(32), charge_amt_num
bigint, charge_amt_denom bigint)
9 Query INSERT INTO invoices_new SELECT * FROM invoices
9 Query DROP TABLE invoices
9 Query ALTER TABLE invoices_new RENAME TO invoices
9 Query UPDATE versions SET table_version=4 WHERE
table_name='invoices'
9 Query SELECT * FROM books
9 Query SELECT * FROM slots WHERE
obj_guid='f134ba8056ca034125c4e4c86a85499b'
9 Query SELECT * FROM slots WHERE
obj_guid='2a93fde012c659bdde998ee58afd0415'
9 Query SELECT * FROM slots WHERE
obj_guid='0305b99ae444bd02f902d8249c310fde'
9 Query SELECT * FROM slots WHERE
obj_guid='b69b55cadc6abfcfa1016ce329a8ca29'
9 Query SELECT * FROM commodities
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM commodities)
9 Query SELECT * FROM accounts
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM accounts)
9 Query SELECT * FROM lots
9 Query SELECT * FROM billterms
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM billterms)
9 Query SELECT * FROM taxtables
9 Query SELECT * FROM invoices
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM invoices)
9 Query SELECT * FROM budgets
9 Query SELECT * FROM budget_amounts WHERE
budget_guid='7034ba95454a629484693deab3b83ee4'
9 Query SELECT * FROM recurrences WHERE
obj_guid='7034ba95454a629484693deab3b83ee4'
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM budgets)
9 Query SELECT * FROM slots WHERE
obj_guid='2be2ffea3bc34bde408aebdee9899f3c'
9 Query SELECT * FROM prices
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM prices)
9 Query SELECT * FROM transactions
9 Query SELECT splits.* FROM splits INNER JOIN transactions ON
splits.tx_guid = transactions.guid
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM splits WHERE tx_guid IN (SELECT DISTINCT guid FROM transactions))
9 Query SELECT * FROM slots WHERE obj_guid IN ((SELECT DISTINCT guid
FROM transactions))
180527 18:52:45 9 Query SELECT * FROM schedxactions
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM schedxactions)
9 Query SELECT * FROM customers
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM customers)
9 Query SELECT * FROM employees
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM employees)
9 Query SELECT * FROM entries
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM entries)
9 Query SELECT * FROM jobs
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM jobs)
9 Query SELECT * FROM orders
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM orders)
9 Query SELECT * FROM vendors
9 Query SELECT * FROM slots WHERE obj_guid IN (SELECT DISTINCT guid
FROM vendors)
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
More information about the gnucash-user
mailing list