#  4/2/11 - Create initial empty accounts_tree and establishes triggers
#  based on https://lists.gnucash.org/pipermail/gnucash-user/2009-July/030590.html

DROP TABLE IF EXISTS accounts_tree;
CREATE TABLE accounts_tree 
	(guid CHAR(32),dummy TEXT(2048),level0 TEXT(2048), level1 TEXT(2048),level2 TEXT(2048),
	level3 TEXT(2048),level4 TEXT(2048),level5 TEXT(2048));

DROP TRIGGER IF EXISTS acct_tree_insert;
CREATE DEFINER = current_user TRIGGER acct_tree_insert AFTER INSERT ON accounts
	FOR EACH ROW call acct_tree();


DROP TRIGGER IF EXISTS acct_tree_update;
CREATE DEFINER = current_user TRIGGER acct_tree_update AFTER UPDATE ON accounts
	FOR EACH ROW call acct_tree();

DROP TRIGGER IF EXISTS acct_tree_delete;
CREATE DEFINER = current_user TRIGGER acct_tree_delete AFTER DELETE ON accounts
	FOR EACH ROW call acct_tree();