-- Create Accounts
insert into account (id_,name_,balance_,type_) values 
	(1,'Projects', 0.0, 'M'),
	(2,'100 Street Building', 0.0, 'M'),
	(3,'Management', 0.0, 'M'),
	(4,'Logistic', 0.0, 'M'),
	(5,'Income', 50.0, 'D'),
	(6,'Expenses', -25.0, 'D'),
	(7,'Income', 45.0, 'D'),
	(8,'Expenses', -60.0, 'D'),
	(9,'Dubai Building', 0.0, 'M'),
	(10,'Management', 0.0, 'M'),
	(11,'Logistic', 0.0, 'M'),
	(12,'Income', 150.0, 'D'),
	(13,'Expenses', -125.0, 'D'),
	(14,'Income', 145.0, 'D'),
	(15,'Expenses', -160.0, 'D');

-- Create the tree structure
insert into account_struct (left_,right_,account_id_) values
	('1','1Z',1),
	('1.1', '1.1Z', 2),
	('1.1.1', '1.1.1Z', 3),
	('1.1.1.05', '1.1.1.05Z', 5),
	('1.1.1.10', '1.1.1.10Z', 6),
	('1.1.2', '1.1.2Z', 4),
	('1.1.2.05', '1.1.2.05Z', 7),
	('1.1.2.10', '1.1.2.10Z', 8),
	('1.2', '1.2Z', 9),
	('1.2.1', '1.2.1Z', 10),
	('1.2.1.05', '1.2.1.05Z', 12),
	('1.2.1.10', '1.2.1.10Z', 13),
	('1.2.2', '1.2.2Z', 11),
	('1.2.2.05', '1.2.2.05Z', 14),
	('1.2.2.10', '1.2.2.10Z', 15);