
DELETE FROM moviment;
DELETE FROM compte;
DELETE FROM oficina;

INSERT INTO `oficina` VALUES 
	(1,'Una','Avda. Montilivi',1,30.00),
	(2,'Dues','Pl. Catalunya',2,450.00),
	(3,'Tres','C. Amunt',0,0.00);

INSERT INTO `compte` VALUES 
	(1,1,1,2,30.00),
	(2,1,3,3,250.00),
	(2,2,2,1,200.00);

INSERT INTO `moviment` VALUES 
	(1,1,1,200.00,CURRENT_DATE() - INTERVAL 12 DAY,'Ingrés'),
	(1,1,2,-70.00,CURRENT_DATE() - INTERVAL 7 DAY,'Reintegre'),
	(1,1,3,-100.00,CURRENT_DATE() - INTERVAL 1 DAY,'Traspas a 1234 0002 15 0000000001'),
	(2,1,1,100.00,CURRENT_DATE() - INTERVAL 13 DAY,'Ingrés'),
	(2,1,2,350.00,CURRENT_DATE() - INTERVAL 8 DAY,'Ingrés'),
	(2,1,3,-50.00,CURRENT_DATE() - INTERVAL 6 DAY,'Reintegre'),
	(2,1,4,-125.00,CURRENT_DATE() - INTERVAL 5 DAY,'Reintegre'),
	(2,1,5,100.00,CURRENT_DATE() - INTERVAL 1 DAY,'Traspas de 1234 0001 75 0000000001'),
	(2,1,6,-125.00,CURRENT_DATE(),'Traspas a 1234 0002 11 0000000002'),
	(2,2,1,90.00,CURRENT_DATE() - INTERVAL 8 DAY,'Ingrés'),
	(2,2,2,-15.00,CURRENT_DATE() - INTERVAL 1 DAY,'Reintegre'),
	(2,2,3,125.00,CURRENT_DATE(),'Traspas de 1234 0002 15 0000000001');


