DELETE FROM `operations`;
INSERT INTO `operations` (`id`, `deadline_date`, `name`, `budget_id`, `payment_id`, `amount`, `credit_card_state`, `user_id`) VALUES
(2, '2018-09-01', 'solde', 1, 3, '-124.96', 0, 5),
(3, '2018-09-01', 'solde', 2, 3, '-74.08', 0, 5),
(4, '2018-09-01', 'solde', 3, 3, '-139.25', 0, 5),
(5, '2018-09-01', 'solde', 4, 3, '-200.00', 0, 5),
(6, '2018-09-01', 'solde', NULL, 2, '1579.89', 0, 5),
(7, '2018-10-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(8, '2018-09-24', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(9, '2018-10-01', 'Dutty free', 4, 1, '-116.45', 0, 5),
(10, '2018-10-01', 'GALP', 4, 1, '-82.40', 0, 5),
(11, '2018-09-17', 'Spar', 4, 3, '-16.00', 0, 5),
(12, '2018-09-16', 'Leclerc', 2, 3, '-14.08', 0, 5),
(13, '2018-09-15', 'Leclerc', 1, 3, '-22.37', 0, 5),
(15, '2018-09-16', 'Spar', 4, 3, '-16.00', 0, 5),
(16, '2018-09-01', 'solde', NULL, 2, '-275.30', 0, 5),
(17, '2018-10-01', 'Le centifolia ', NULL, 1, '-31.00', 0, 5),
(18, '2018-10-01', 'Mozart et la pizza', 3, 1, '-22.00', 0, 5),
(37, '2018-10-04', 'Virement Maxime', NULL, 2, '120.00', 0, 5),
(21, '2018-10-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(22, '2018-10-15', 'Bouygues Telecom', NULL, 5, '-37.90', 0, 5),
(23, '2018-10-01', 'Salaire', NULL, 2, '2681.48', 0, 5),
(24, '2018-10-23', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(36, '2018-09-24', 'Virement Maxime', NULL, 2, '-120.00', 0, 5),
(86, '2018-10-18', 'Vers livret', NULL, 2, '-27.00', 0, 5),
(27, '2018-10-01', 'Netflix', NULL, 1, '-10.99', 0, 5),
(28, '2018-10-13', 'Suez', NULL, 5, '-19.00', 0, 5),
(29, '2018-11-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(30, '2018-10-21', 'EDF', NULL, 5, '-55.70', 0, 5),
(31, '2018-10-04', 'Yamaha assurance', NULL, 5, '-53.00', 0, 5),
(33, '2018-10-04', 'Crédit Foncier', NULL, 5, '-20.82', 0, 5),
(34, '2018-10-13', 'Sosh', NULL, 5, '-24.99', 0, 5),
(35, '2018-10-09', 'Salaire Softease', NULL, 2, '400.00', 0, 5),
(38, '2018-10-01', 'Sale Chaos', NULL, 4, '-160.00', 0, 5),
(39, '2018-09-24', 'Depuis Livret', NULL, 2, '280.00', 0, 5),
(48, '2018-10-01', 'Retrait ', 3, 3, '-60.00', 0, 5),
(42, '2018-10-01', 'Wikipedia ', NULL, 1, '-3.00', 0, 5),
(43, '2018-10-01', 'Leclerc', 1, 1, '-11.08', 0, 5),
(44, '2018-10-01', 'Leclerc ', 2, 1, '-30.00', 0, 5),
(45, '2018-10-01', 'Leclerc ', 1, 1, '-54.33', 0, 5),
(47, '2018-10-01', 'Bluebox ', 6, 1, '-150.21', 0, 5),
(49, '2018-10-01', 'Histoire d\'or ', 6, 1, '-399.00', 0, 5),
(50, '2018-10-01', 'Le grenier ', 6, 1, '-114.99', 0, 5),
(51, '2018-10-01', 'Mc donald\'s ', 3, 1, '-13.70', 0, 5),
(52, '2018-10-03', 'Le centifolia', NULL, 1, '-31.00', 0, 5),
(53, '2018-10-05', 'Leclerc ', 1, 1, '-18.80', 0, 5),
(54, '2018-10-04', 'Impôt ', NULL, 2, '24.00', 0, 5),
(55, '2018-10-04', 'Vers livret', NULL, 2, '-1000.00', 0, 5),
(56, '2018-10-09', 'Coiffeur ', NULL, 1, '-21.00', 0, 5),
(57, '2018-10-07', 'Leclerc ', 1, 1, '-48.88', 0, 5),
(58, '2018-10-07', 'Assurance habitation ', NULL, 5, '-17.50', 0, 5),
(63, '2018-10-14', 'Opalus', 3, 1, '-60.00', 0, 5),
(60, '2018-10-10', 'Leclerc ', 1, 1, '-18.58', 0, 5),
(61, '2018-10-10', 'Le centifolia', NULL, 1, '-31.00', 0, 5),
(62, '2018-10-09', 'Garage ', 2, 2, '-100.00', 0, 5),
(64, '2018-10-14', 'Carrefour contact ', 2, 1, '-31.52', 0, 5),
(65, '2018-10-14', 'Leclerc ', 1, 1, '-33.87', 0, 5),
(66, '2018-10-14', 'Spar', 4, 1, '-84.05', 0, 5),
(67, '2018-10-19', 'Leclerc', 1, 1, '-10.61', 0, 5),
(68, '2018-10-18', 'Frais Softease', NULL, 2, '224.29', 0, 5),
(69, '2018-11-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(70, '2018-11-01', 'Salaire', NULL, 2, '2593.89', 0, 5),
(71, '2018-11-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(72, '2018-11-15', 'Bouygues Telecom', NULL, 5, '-37.90', 0, 5),
(87, '2018-10-21', 'Leclerc ', 1, 1, '-56.00', 0, 5),
(88, '2018-10-21', 'Mozart et la pizza', 3, 1, '-18.00', 0, 5),
(75, '2018-11-02', 'Netflix', NULL, 1, '-10.99', 0, 5),
(105, '2018-11-01', 'Péage ', 2, 1, '-6.00', 0, 5),
(77, '2018-12-02', 'Spotify', NULL, 1, '-9.99', 0, 5),
(78, '2018-11-19', 'EDF', NULL, 5, '-55.70', 0, 5),
(79, '2018-11-04', 'Yamaha assurance', NULL, 5, '-53.00', 0, 5),
(85, '2018-10-18', 'Médecin ', NULL, 3, '-40.00', 0, 5),
(81, '2018-11-04', 'Assurance habitation', NULL, 5, '-19.45', 0, 5),
(82, '2018-11-15', 'Sosh', NULL, 5, '-24.99', 0, 5),
(83, '2018-11-05', 'Salaire Softease', NULL, 2, '400.00', 0, 5),
(84, '2018-11-25', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(89, '2018-10-21', 'Spar', 4, 1, '-80.00', 0, 5),
(90, '2018-10-21', 'Casino ', NULL, 1, '-20.00', 0, 5),
(91, '2018-10-19', 'Mc donald\'s', NULL, 1, '-13.60', 0, 5),
(92, '2018-10-21', 'Péage ', 2, 1, '-6.00', 0, 5),
(93, '2018-10-21', 'Parking ', 2, 1, '-7.20', 0, 5),
(94, '2018-11-01', 'wine bar ', 3, 1, '-16.00', 0, 5),
(95, '2018-10-21', 'Leclerc ', 2, 1, '-50.60', 0, 5),
(96, '2018-11-01', 'Spar', 4, 1, '-16.00', 0, 5),
(97, '2018-11-01', 'Pharmacie', NULL, 1, '-48.90', 0, 5),
(98, '2018-11-01', 'wine bar ', 3, 1, '-18.00', 0, 5),
(99, '2018-11-01', 'Le havane ', 4, 1, '-16.00', 0, 5),
(100, '2018-11-01', 'Carrefour marker', 1, 1, '-3.55', 0, 5),
(101, '2018-11-01', 'Spar', 4, 1, '-18.05', 0, 5),
(102, '2018-11-01', 'Coiffeur ', NULL, 1, '-21.00', 0, 5),
(103, '2018-11-01', 'Leclerc ', 1, 1, '-56.92', 0, 5),
(104, '2018-11-01', 'Parking ', 2, 1, '-7.20', 0, 5),
(106, '2018-10-28', 'Eca', NULL, 2, '7.50', 0, 5),
(107, '2018-11-01', 'Spar ', 4, 1, '-82.10', 0, 5),
(108, '2018-11-01', 'Nespresso ', NULL, 1, '-30.24', 0, 5),
(109, '2018-11-02', 'Le carré ', 3, 1, '-30.00', 0, 5),
(110, '2018-11-04', 'La poste ', NULL, 1, '-5.70', 0, 5),
(111, '2018-11-02', 'Leclerc ', 2, 1, '-70.00', 0, 5),
(112, '2018-11-01', 'Prêt ', NULL, 5, '-250.00', 0, 5),
(113, '2018-11-01', 'Retrait ', 3, 3, '-40.00', 0, 5),
(114, '2018-11-01', 'Vers livret', NULL, 2, '-500.00', 0, 5),
(115, '2018-11-04', 'Leclerc ', 1, 1, '-9.46', 0, 5),
(116, '2018-11-02', 'Mozart et la pizza', 3, 1, '-13.00', 0, 5),
(117, '2018-11-04', 'Leclerc ', 1, 1, '-64.06', 0, 5),
(118, '2018-11-05', 'Spar', 4, 1, '-82.50', 0, 5),
(119, '2018-11-04', 'assurance prêt', NULL, 5, '-20.82', 0, 5),
(120, '2018-11-05', 'Prêt ', NULL, 5, '-4.46', 0, 5),
(126, '2018-11-11', 'Notaire ', NULL, 2, '1500.00', 0, 5),
(122, '2018-11-11', 'Le comptoir ', 3, 1, '-78.00', 0, 5),
(123, '2018-11-11', 'Coiffeur ', NULL, 1, '-21.00', 0, 5),
(124, '2018-11-13', 'Le crystal ', 3, 1, '-15.50', 0, 5),
(125, '2018-11-11', 'Leclerc ', 1, 1, '-49.24', 0, 5),
(127, '2018-11-11', 'Vers livret', NULL, 2, '-1500.00', 0, 5),
(128, '2018-11-11', 'Mozart et la pizza', 3, 1, '-13.00', 0, 5),
(129, '2018-11-13', 'Spar', 4, 1, '-82.50', 0, 5),
(130, '2018-11-13', 'Mc donald\'s', 3, 1, '-18.40', 0, 5),
(131, '2018-12-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(132, '2018-12-01', 'Salaire', NULL, 2, '2828.14', 0, 5),
(133, '2018-12-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(134, '2018-12-15', 'Bouygues Telecom', NULL, 5, '-37.90', 0, 5),
(147, '2018-11-13', 'My beers ', 3, 1, '-25.50', 0, 5),
(148, '2018-11-17', 'Leclerc ', 1, 1, '-7.92', 0, 5),
(137, '2018-12-02', 'Netflix', NULL, 1, '-10.99', 0, 5),
(138, '2018-12-15', 'Suez', NULL, 5, '-22.00', 0, 5),
(139, '2019-01-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(140, '2018-12-19', 'EDF', NULL, 5, '-55.70', 0, 5),
(141, '2018-12-04', 'Yamaha assurance', NULL, 5, '-53.00', 0, 5),
(142, '2018-12-05', 'Prêt crédit mutuel', NULL, 5, '-38.19', 0, 5),
(143, '2018-12-05', 'Assurance habitation', NULL, 5, '-18.73', 0, 5),
(251, '2019-01-07', 'Décathlon ', NULL, 1, '-10.00', 0, 5),
(145, '2018-12-02', 'Salaire Softease', NULL, 2, '400.00', 0, 5),
(146, '2018-12-26', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(149, '2018-11-13', 'Suez', NULL, 5, '-22.00', 0, 5),
(150, '2018-11-18', 'Spar', 4, 1, '-78.70', 0, 5),
(151, '2018-11-18', 'Tree bo', 3, 1, '-20.00', 0, 5),
(152, '2018-11-18', 'Le saloon ', 3, 1, '-14.00', 0, 5),
(153, '2018-11-18', 'Mozart et la pizza', 3, 1, '-6.50', 0, 5),
(154, '2018-11-18', 'Leclerc ', 1, 1, '-45.62', 0, 5),
(155, '2018-11-19', 'Kfc', 3, 1, '-31.40', 0, 5),
(156, '2018-11-19', 'Leclerc ', 2, 1, '-63.39', 0, 5),
(157, '2018-11-19', 'Jules', NULL, 1, '-121.97', 0, 5),
(161, '2018-12-01', 'Mozart et la pizza', 3, 1, '-6.50', 0, 5),
(159, '2018-11-19', 'Remboursement frais', NULL, 2, '321.68', 0, 5),
(160, '2018-11-18', 'Péage ', 2, 1, '-13.30', 0, 5),
(162, '2018-12-01', 'Le centifolia', NULL, 1, '-31.00', 0, 5),
(163, '2018-12-01', 'Spar ', 4, 1, '-87.45', 0, 5),
(164, '2018-12-01', 'Leclerc ', 1, 1, '-58.91', 0, 5),
(165, '2018-11-27', 'Retrait ', NULL, 3, '-100.00', 0, 5),
(166, '2018-12-01', 'Nespresso ', NULL, 1, '-16.20', 0, 5),
(167, '2018-12-01', 'péage', 2, 1, '-6.00', 0, 5),
(168, '2018-12-01', 'La piazza ', 3, 1, '-39.40', 0, 5),
(169, '2018-12-01', 'Moto GP', NULL, 1, '-1.00', 0, 5),
(170, '2018-12-02', 'Spar ', 4, 1, '-82.50', 0, 5),
(171, '2018-12-02', 'Leclerc ', 1, 1, '-29.52', 0, 5),
(172, '2018-12-03', 'La foire fouille', NULL, 1, '-11.99', 0, 5),
(173, '2018-12-02', 'Leclerc ', 1, 1, '-46.51', 0, 5),
(174, '2018-12-02', 'Nike store ', NULL, 1, '-55.00', 0, 5),
(175, '2018-12-03', 'Jules', NULL, 1, '-99.98', 0, 5),
(176, '2018-12-02', 'Nike factory ', NULL, 1, '-30.00', 0, 5),
(177, '2018-12-02', 'Vers livret', NULL, 2, '-700.00', 0, 5),
(178, '2018-12-02', 'Total', 2, 1, '-71.26', 0, 5),
(179, '2018-12-02', 'Nespresso ', NULL, 1, '-29.00', 0, 5),
(180, '2018-12-06', 'Crédit foncier', NULL, 2, '641.26', 0, 5),
(181, '2018-12-04', 'cbp', NULL, 5, '-20.82', 0, 5),
(182, '2018-12-09', 'spar', 4, 1, '-82.50', 0, 5),
(183, '2018-12-09', 'Kisame', 3, 1, '-30.00', 0, 5),
(184, '2018-12-06', 'Le grenier ', NULL, 1, '-16.99', 0, 5),
(186, '2018-12-09', 'Leclerc ', 1, 1, '-52.09', 0, 5),
(187, '2018-12-12', 'Nike store ', NULL, 1, '-160.00', 0, 5),
(188, '2018-12-10', 'Rétrocession ', NULL, 2, '18.67', 0, 5),
(189, '2018-12-12', 'Frais Softease', NULL, 2, '419.58', 0, 5),
(190, '2018-12-12', 'Mozart et la pizza', 3, 1, '-6.50', 0, 5),
(191, '2018-12-12', 'Paul', 3, 1, '-5.00', 0, 5),
(192, '2018-12-10', 'Strada ', 3, 1, '-8.50', 0, 5),
(193, '2018-12-12', 'Rétrocession ', NULL, 5, '-18.67', 0, 5),
(194, '2018-12-13', 'Spar', 4, 1, '-82.50', 0, 5),
(195, '2018-12-13', 'Auchan', NULL, 1, '-112.70', 0, 5),
(196, '2018-12-16', 'Leclerc ', 1, 1, '-72.47', 0, 5),
(197, '2018-12-16', 'Mozart et la pizza', 3, 1, '-10.00', 0, 5),
(198, '2018-12-16', 'Vers livret', NULL, 2, '-137.00', 0, 5),
(199, '2018-12-18', 'Mozart', 3, 2, '-16.50', 0, 5),
(200, '2018-12-20', 'Spar', 4, 1, '-82.50', 0, 5),
(201, '2019-01-01', 'Leclerc ', 2, 1, '-63.99', 0, 5),
(202, '2019-01-01', 'Leclerc ', 1, 1, '-55.36', 0, 5),
(203, '2019-01-01', 'Orchestra ', NULL, 1, '-68.91', 0, 5),
(204, '2019-01-01', 'Leclerc ', 2, 1, '-6.00', 0, 5),
(205, '2018-12-23', 'Retrait ', 3, 3, '-100.00', 0, 5),
(206, '2019-01-01', 'Radisson', 3, 1, '-119.00', 0, 5),
(207, '2019-01-01', 'Parking ', 2, 1, '-15.50', 0, 5),
(208, '2019-01-01', 'Esso', 2, 1, '-13.66', 0, 5),
(209, '2019-01-01', 'Marché St Anne', NULL, 1, '-30.99', 0, 5),
(210, '2019-01-01', 'Spar', 4, 1, '-83.62', 0, 5),
(211, '2019-01-01', 'Sephora', NULL, 1, '-10.99', 0, 5),
(212, '2019-01-01', 'Haagen Dazs', 3, 1, '-14.70', 0, 5),
(213, '2019-01-01', 'parking', 2, 1, '-3.00', 0, 5),
(214, '2019-01-01', 'strada', 3, 1, '-22.20', 0, 5),
(215, '2019-01-01', 'L\'ardoise', 3, 1, '-30.25', 0, 5),
(216, '2019-01-01', 'Péage', 2, 1, '-5.60', 0, 5),
(217, '2019-01-01', 'Spar', 4, 1, '-17.67', 0, 5),
(218, '2019-01-01', 'Leclerc ', 1, 1, '-12.77', 0, 5),
(219, '2019-01-01', 'Leclerc ', 1, 1, '-86.09', 0, 5),
(220, '2019-01-01', 'Spar', 4, 1, '-88.76', 0, 5),
(221, '2019-01-01', 'Bubble café ', 3, 1, '-32.80', 0, 5),
(222, '2019-01-01', 'Leclerc ', 2, 1, '-62.32', 0, 5),
(223, '2019-01-01', 'Orezza ', 3, 1, '-10.60', 0, 5),
(224, '2019-01-01', 'Salaire', NULL, 2, '2673.98', 0, 5),
(225, '2019-01-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(226, '2019-01-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(227, '2019-01-06', 'Assurance habitation', NULL, 5, '-18.73', 0, 5),
(228, '2019-01-06', 'Yamaha assurance', NULL, 5, '-53.00', 0, 5),
(229, '2019-01-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(230, '2019-01-04', 'Prêt crédit mutuel', NULL, 5, '-38.19', 0, 5),
(231, '2019-01-06', 'cbp', NULL, 5, '-20.82', 0, 5),
(232, '2019-01-01', 'Nespresso', NULL, 1, '-29.00', 0, 5),
(233, '2019-01-06', 'Salaire Softease', NULL, 2, '700.00', 0, 5),
(234, '2019-01-14', 'Sosh', NULL, 5, '-24.99', 0, 5),
(250, '2019-01-08', 'Décathlon ', NULL, 1, '-10.00', 0, 5),
(236, '2019-01-09', 'EDF', NULL, 5, '-52.95', 0, 5),
(237, '2019-02-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(238, '2019-01-14', 'Suez', NULL, 5, '-22.00', 0, 5),
(239, '2019-01-01', 'Netflix', NULL, 1, '-10.99', 0, 5),
(240, '2019-01-15', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(252, '2019-01-08', 'Antargaz', NULL, 1, '-18.65', 0, 5),
(242, '2019-01-15', 'Bouygues Telecom', NULL, 5, '-37.90', 0, 5),
(243, '2019-01-24', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(244, '2019-01-01', 'Retrait ', 3, 3, '-30.00', 0, 5),
(245, '2019-01-01', 'Burger King ', 3, 1, '-10.80', 0, 5),
(246, '2019-01-01', 'Péage ', 2, 1, '-4.30', 0, 5),
(247, '2019-01-01', 'Mc donald\'s', 3, 1, '-3.20', 0, 5),
(248, '2019-01-01', 'Steak n shake', 3, 1, '-27.85', 0, 5),
(249, '2019-01-01', 'Best drive', NULL, 1, '-176.47', 0, 5),
(253, '2019-01-08', 'Lagrange ', NULL, 1, '-11.00', 0, 5),
(254, '2019-01-08', 'Siècle d\'or ', 3, 1, '-43.60', 0, 5),
(255, '2019-01-06', 'Remboursement da', NULL, 2, '176.47', 0, 5),
(256, '2019-01-08', 'Spar', 4, 1, '-84.50', 0, 5),
(257, '2019-01-08', 'Galeries Lafayette', NULL, 1, '-22.50', 0, 5),
(258, '2019-01-08', 'Segafredo', 3, 1, '-6.80', 0, 5),
(259, '2019-01-08', 'Undiz', NULL, 1, '-29.85', 0, 5),
(260, '2019-01-06', 'Pno BV', NULL, 5, '-20.57', 0, 5),
(261, '2019-01-07', 'péage', 2, 1, '-6.00', 0, 5),
(262, '2019-01-09', 'cuisine', NULL, 2, '-127.00', 0, 5),
(277, '2019-01-14', 'Bluebox', NULL, 1, '-27.47', 0, 5),
(264, '2019-01-10', 'Steak n shake', 3, 1, '-24.80', 0, 5),
(265, '2019-01-14', 'MyProtein', NULL, 1, '-84.78', 0, 5),
(266, '2019-01-14', 'Leclerc', 1, 1, '-101.30', 0, 5),
(267, '2019-01-15', 'Devred', NULL, 1, '-62.98', 0, 5),
(268, '2019-01-14', 'Lavage', 2, 1, '-8.00', 0, 5),
(269, '2019-01-14', 'Gifi', NULL, 1, '-14.00', 0, 5),
(270, '2019-01-14', 'Coiffeur ', NULL, 1, '-21.00', 0, 5),
(271, '2019-01-14', 'Pharmacie', NULL, 1, '-7.95', 0, 5),
(272, '2019-01-14', 'Musée ', NULL, 1, '-22.00', 0, 5),
(273, '2019-01-14', 'La tavernetta ', NULL, 1, '-50.60', 0, 5),
(274, '2019-01-15', 'Retrait ', 3, 3, '-20.00', 0, 5),
(275, '2019-01-14', 4, 4, 1, '-16.40', 0, 5),
(280, '2019-01-15', 'Casino ', NULL, 1, '-15.28', 0, 5),
(278, '2019-01-14', 'péage', 2, 1, '-6.90', 0, 5),
(279, '2019-01-14', 'Leclerc', 2, 1, '-61.21', 0, 5),
(281, '2019-01-18', 'Spar ', 4, 1, '-82.00', 0, 5),
(282, '2019-01-20', 'Frais Softease', NULL, 2, '279.72', 0, 5),
(283, '2019-01-24', 'Snc cogedim ', NULL, 5, '-377.51', 0, 5),
(284, '2019-02-01', 'Briconautes ', NULL, 1, '-53.80', 0, 5),
(285, '2019-01-20', 'Leclerc ', 1, 1, '-31.89', 0, 5),
(286, '2019-01-20', 'Café terrasse ', 3, 1, '-48.10', 0, 5),
(287, '2019-01-19', 'Ski', NULL, 2, '-100.00', 0, 5),
(288, '2019-02-01', 'Le duplex ', NULL, 1, '-76.00', 0, 5),
(289, '2019-01-19', 'Depuis livret ', NULL, 2, '122.79', 0, 5),
(316, '2019-02-10', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(310, '2019-02-01', 'Salaire', NULL, 2, '3242.89', 0, 5),
(311, '2019-02-02', 'Garage', NULL, 2, '-100.00', 0, 5),
(312, '2019-02-02', 'Loyer', NULL, 2, '-700.00', 0, 5),
(313, '2019-02-05', 'Assurance habitation', NULL, 5, '-18.73', 0, 5),
(314, '2019-02-04', 'Yamaha assurance', NULL, 5, '-53.00', 0, 5),
(315, '2019-02-05', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(323, '2019-03-04', 'Spotify', NULL, 1, '-9.99', 0, 5),
(322, '2019-02-19', 'EDF', NULL, 5, '-55.70', 0, 5),
(321, '2019-02-14', 'Sosh', NULL, 5, '-24.99', 0, 5),
(320, '2019-02-03', 'Salaire Softease', NULL, 2, '618.00', 0, 5),
(319, '2019-02-01', 'Nespresso', NULL, 1, '-29.00', 0, 5),
(318, '2019-02-04', 'cbp', NULL, 5, '-20.82', 0, 5),
(317, '2019-02-05', 'Prêt crédit mutuel', NULL, 5, '-45.80', 0, 5),
(324, '2019-02-14', 'Suez', NULL, 5, '-22.00', 0, 5),
(325, '2019-02-04', 'Netflix', NULL, 1, '-10.99', 0, 5),
(326, '2019-02-17', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(335, '2019-02-01', 'Spar', 4, 1, '-84.50', 0, 5),
(328, '2019-02-17', 'Bouygues Telecom', NULL, 5, '-37.90', 0, 5),
(329, '2019-02-21', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(425, '2019-03-01', 'Le bo m', NULL, 1, '-126.00', 0, 5),
(331, '2019-01-20', 'EDF', NULL, 5, '-55.70', 0, 5),
(332, '2019-02-01', 'Leclerc ', 1, 1, '-49.97', 0, 5),
(333, '2019-02-01', 'Spar', 4, 1, '-24.60', 0, 5),
(334, '2019-01-23', 'EDF', NULL, 5, '-13.54', 0, 5),
(336, '2019-02-01', 'Fleurs ', 2, 1, '-23.60', 0, 5),
(337, '2019-02-01', 'Briconautes ', NULL, 1, '-7.80', 0, 5),
(338, '2019-02-01', 'Casino ', 1, 1, '-12.10', 0, 5),
(339, '2019-01-27', 'Retrait ', NULL, 3, '-150.00', 0, 5),
(340, '2019-02-01', 'Siècle d\'or ', NULL, 1, '-41.60', 0, 5),
(343, '2019-02-01', 'Carrefour contact ', 2, 1, '-14.61', 0, 5),
(342, '2019-01-27', 'Forfait ski', NULL, 2, '110.00', 0, 5),
(344, '2019-02-01', 'Le centifolia', NULL, 1, '-28.50', 0, 5),
(345, '2019-02-01', 'Spar', 4, 1, '-25.64', 0, 5),
(346, '2019-02-01', 'Le comptoir ', 3, 1, '-65.50', 0, 5),
(347, '2019-02-01', 'Nespresso ', NULL, 1, '-26.00', 0, 5),
(348, '2019-02-04', 'Spar', 4, 1, '-84.50', 0, 5),
(349, '2019-02-01', 'Vers livret ', NULL, 2, '-1000.00', 0, 5),
(350, '2019-02-04', 'Leclerc ', NULL, 1, '-100.34', 0, 5),
(351, '2019-02-02', 'Remboursement ski', NULL, 2, '48.00', 0, 5),
(352, '2019-02-05', 'Florineige', 1, 1, '-13.94', 0, 5),
(353, '2019-02-05', 'Le Bretagne ', 3, 1, '-22.00', 0, 5),
(354, '2019-02-05', 'Snow shop', 2, 1, '-56.00', 0, 5),
(355, '2019-02-05', 'Assurance ', NULL, 1, '-6.00', 0, 5),
(356, '2019-02-04', 'Assurance ', NULL, 1, '-6.00', 0, 5),
(357, '2019-02-05', 'Snow shop', 2, 1, '-35.00', 0, 5),
(358, '2019-02-05', 'Leclerc ', 2, 1, '-65.92', 0, 5),
(359, '2019-02-03', 'remboursement ski', NULL, 2, '50.00', 0, 5),
(360, '2019-02-05', 'Leclerc ', 1, 1, '-34.56', 0, 5),
(361, '2019-02-03', 'Gp', NULL, 2, '-264.00', 0, 5),
(362, '2019-02-05', 'Selecta', NULL, 1, '-2.50', 0, 5),
(363, '2019-02-05', 'Brut butcher', 3, 1, '-6.80', 0, 5),
(527, '2019-04-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(528, '2019-04-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(525, '2019-04-01', 'Salaire', NULL, 2, '1209.55', 0, 6),
(526, '2019-04-01', 'CAF', NULL, 2, '150.00', 0, 6),
(529, '2019-04-08', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(396, '2019-02-07', 'Gwendoline', NULL, 2, '250.00', 0, 5),
(397, '2019-02-10', 'comptoir', 3, 1, '-68.50', 0, 5),
(398, '2019-02-10', 'Spar', 4, 1, '-84.50', 0, 5),
(399, '2019-02-07', 'Cuisiniste', 1, 2, '-127.00', 0, 5),
(405, '2019-02-14', 'Histoire d\'or ', NULL, 1, '-59.00', 0, 5),
(401, '2019-02-10', 'Nicolas ', 1, 1, '-14.40', 0, 5),
(402, '2019-02-11', 'Boulangerie ', NULL, 1, '-4.40', 0, 5),
(403, '2019-02-11', 'Astoux et brun', NULL, 1, '-70.20', 0, 5),
(404, '2019-02-11', 'Parking ', 2, 1, '-6.60', 0, 5),
(406, '2019-02-17', 'Le centifolia', NULL, 1, '-11.50', 0, 5),
(407, '2019-02-17', 'Spar', 4, 1, '-16.40', 0, 5),
(408, '2019-02-14', 'retrait', 3, 3, '-40.00', 0, 5),
(409, '2019-02-17', 'Frais Softease', NULL, 2, '530.95', 0, 5),
(410, '2019-02-17', 'Le centifolia', NULL, 1, '-28.50', 0, 5),
(411, '2019-02-17', 'Bluebox', NULL, 1, '-39.98', 0, 5),
(412, '2019-02-17', 'Parking ', 2, 1, '-6.50', 0, 5),
(413, '2019-02-17', 'Leclerc ', 1, 1, '-40.23', 0, 5),
(414, '2019-02-18', 'Spar', 4, 1, '-82.00', 0, 5),
(415, '2019-03-01', 'Coiffeur ', NULL, 1, '-21.00', 0, 5),
(416, '2019-03-01', 'Fleurs ', NULL, 1, '-29.50', 0, 5),
(417, '2019-03-01', 'Leclerc ', 1, 1, '-49.82', 0, 5),
(418, '2019-03-01', 'Leclerc ', 1, 1, '-10.02', 0, 5),
(421, '2019-02-24', 'Depuis livret ', NULL, 2, '600.00', 0, 5),
(420, '2019-03-01', 'Leclerc ', 2, 1, '-66.54', 0, 5),
(422, '2019-02-24', 'Maxime', NULL, 2, '-50.00', 0, 5),
(423, '2019-02-24', 'Loyer', NULL, 2, '339.55', 0, 5),
(424, '2019-02-26', 'Marc Langasque', NULL, 3, '-70.00', 0, 5),
(426, '2019-03-01', 'Éléphant bleu', 2, 1, '-20.00', 0, 5),
(427, '2019-03-01', 'Péage ', 2, 1, '-6.20', 0, 5),
(428, '2019-03-01', 'Opodo', NULL, 1, '-548.95', 0, 5),
(429, '2019-03-01', 'Nespresso', NULL, 1, '-1.00', 0, 5),
(522, '2019-04-13', 'Canal', NULL, 1, '-19.90', 0, 5),
(430, '2019-02-27', 'Maxime', NULL, 2, '275.00', 0, 5),
(431, '2019-03-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(432, '2019-03-01', 'Salaire', NULL, 2, '2274.91', 0, 5),
(433, '2019-03-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(434, '2019-03-04', 'Assurance habitation', NULL, 5, '-18.73', 0, 5),
(435, '2019-03-17', 'Bouygues Telecom', NULL, 5, '-37.90', 0, 5),
(436, '2019-03-04', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(437, '2019-03-10', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(438, '2019-03-05', 'Prêt crédit mutuel', NULL, 5, '-95.19', 0, 5),
(439, '2019-03-04', 'cbp', NULL, 5, '-20.82', 0, 5),
(440, '2019-03-01', 'Nespresso', NULL, 1, '-29.00', 0, 5),
(441, '2019-03-03', 'Salaire', NULL, 2, '618.00', 0, 5),
(442, '2019-03-17', 'Sosh', NULL, 5, '-24.99', 0, 5),
(443, '2019-03-04', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(444, '2019-03-20', 'EDF', NULL, 5, '-55.70', 0, 5),
(445, '2019-04-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(446, '2019-03-15', 'Suez', NULL, 5, '-22.00', 0, 5),
(447, '2019-03-04', 'Netflix', NULL, 1, '-10.99', 0, 5),
(448, '2019-03-17', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(449, '2019-03-21', 'Loyer', NULL, 2, '479.00', 0, 5),
(450, '2019-03-25', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(451, '2019-03-01', 'Gemo', NULL, 1, '-49.98', 0, 5),
(452, '2019-03-04', 'Mozart et la pizza', 3, 1, '-13.50', 0, 5),
(453, '2019-03-04', 'Leclerc ', 1, 1, '-13.07', 0, 5),
(454, '2019-03-05', 4, 4, 1, '-114.00', 0, 5),
(455, '2019-03-05', 'Restaurant ', 3, 1, '-43.47', 0, 5),
(456, '2019-03-04', 'Bubble café ', 3, 1, '-21.00', 0, 5),
(457, '2019-03-04', 'Botanic ', 1, 1, '-62.29', 0, 5),
(458, '2019-03-05', 'Leclerc ', 1, 1, '-21.62', 0, 5),
(459, '2019-03-05', 'Amsterdam', NULL, 2, '-273.00', 0, 5),
(460, '2019-03-10', 'Leclerc ', 1, 1, '-20.80', 0, 5),
(461, '2019-03-08', 'Moto gp', NULL, 1, '-125.99', 0, 5),
(462, '2019-03-12', 'Briconautes ', NULL, 1, '-24.90', 0, 5),
(463, '2019-03-10', 'Mozart et la pizza ', 3, 1, '-3.50', 0, 5),
(464, '2019-03-13', 'La poste', NULL, 1, '-8.80', 0, 5),
(465, '2019-03-15', 'carrefour contact', 2, 1, '-20.01', 0, 5),
(466, '2019-03-15', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(467, '2019-03-15', 'Leclerc ', 1, 1, '-18.69', 0, 5),
(468, '2019-03-17', 'Leclerc ', 1, 1, '-34.40', 0, 5),
(469, '2019-03-17', 'Leclerc ', 2, 1, '-66.08', 0, 5),
(470, '2019-03-18', 'Grand vert', 1, 1, '-41.60', 1, 4),
(471, '2019-03-20', 'Retrait ', 4, 3, '-50.00', 0, 5),
(472, '2019-03-18', 'Frais Softease', NULL, 2, '419.06', 0, 5),
(473, '2019-03-18', 'Maxime', NULL, 2, '-170.00', 0, 5),
(474, '2019-03-18', 'Frais NPAI', NULL, 5, '-7.00', 0, 5),
(475, '2019-04-01', 'Leclerc ', NULL, 1, '-67.00', 0, 5),
(476, '2019-04-01', 'Spar ', 4, 1, '-88.00', 0, 5),
(477, '2019-04-01', 'Siècle d\'or ', 3, 1, '-61.60', 0, 5),
(478, '2019-03-25', 'PayPal', NULL, 5, '-14.39', 0, 5),
(479, '2019-04-01', 'Leclerc ', 2, 1, '-17.01', 0, 5),
(480, '2019-03-26', 'Vers livret ', NULL, 2, '-300.00', 0, 5),
(481, '2019-04-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(482, '2019-04-01', 'Salaire', NULL, 2, '2244.91', 0, 5),
(483, '2019-04-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(484, '2019-04-04', 'Assurance habitation', NULL, 5, '-18.73', 0, 5),
(485, '2019-04-15', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(486, '2019-04-04', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(487, '2019-04-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(488, '2019-04-06', 'Prêt crédit mutuel', NULL, 5, '-120.34', 0, 5),
(489, '2019-04-04', 'cbp', NULL, 5, '-20.82', 0, 5),
(490, '2019-04-01', 'Nespresso', NULL, 1, '-29.00', 0, 5),
(491, '2019-04-02', 'Salaire', NULL, 2, '618.00', 0, 5),
(492, '2019-04-14', 'Sosh', NULL, 5, '-24.99', 0, 5),
(493, '2019-04-04', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(494, '2019-04-28', 'EDF', NULL, 5, '-54.28', 0, 5),
(495, '2019-06-03', 'Spotify', NULL, 1, '-9.99', 0, 5),
(496, '2019-04-14', 'Suez', NULL, 5, '-22.00', 0, 5),
(497, '2019-04-02', 'Netflix', NULL, 1, '-10.99', 0, 5),
(498, '2019-04-15', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(499, '2019-04-22', 'Loyer', NULL, 2, '539.00', 0, 5),
(500, '2019-04-25', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(501, '2019-04-01', 'Yamaha ', NULL, 1, '-100.00', 0, 5),
(502, '2019-03-27', 'Bébé', NULL, 2, '300.00', 0, 5),
(503, '2019-04-01', 'Leclerc ', 2, 1, '-45.59', 0, 5),
(504, '2019-04-07', 'Yamaha', NULL, 1, '-531.90', 0, 5),
(505, '2019-04-15', 'Frais Softease', NULL, 2, '564.62', 0, 5),
(506, '2019-04-03', 'Leclerc', NULL, 1, '-40.00', 0, 5),
(507, '2019-04-03', '1Spar', 2, 1, '-17.60', 0, 5),
(508, '2019-04-07', 'La rôtisserie', 3, 1, '-27.26', 0, 5),
(509, '2019-04-07', 'Spar ', 4, 1, '-88.00', 0, 5),
(510, '2019-04-04', 'Retrait ', NULL, 3, '-200.00', 0, 5),
(511, '2019-04-06', 'Prêt crédit mutuel', NULL, 5, '-4.93', 0, 5),
(512, '2019-04-07', 'Bus', 3, 1, '-10.00', 0, 5),
(513, '2019-04-08', 'Bus', 3, 1, '-10.00', 0, 5),
(514, '2019-04-08', 'AmstTabac', 2, 1, '-31.50', 0, 5),
(515, '2019-04-08', 'Retrait ', NULL, 3, '-100.00', 0, 5),
(516, '2019-04-08', 'Bus', 3, 1, '-10.00', 0, 5),
(577, '2019-05-01', 'Spar ', 4, 1, '-8.80', 0, 5),
(517, '2019-04-23', 'Snc cogedim', NULL, 5, '-310.71', 0, 5),
(518, '2019-04-07', 'Relay', 4, 1, '-20.10', 0, 5),
(519, '2019-04-09', 'Kfc', 3, 1, '-45.30', 0, 5),
(520, '2019-04-13', 'Leclerc ', 2, 1, '-21.57', 0, 5),
(521, '2019-04-10', 'Cotisation', NULL, 5, '-18.67', 0, 5),
(523, '2019-04-13', 'Nespresso', NULL, 1, '-5.00', 0, 5),
(524, '2019-04-15', 'Leclerc ', 2, 1, '-66.60', 0, 5),
(530, '2019-04-10', 'itunes', NULL, 5, '-12.99', 0, 6),
(532, '2019-04-17', 'Spar', 4, 1, '-17.60', 0, 5),
(576, '2019-05-01', 'Cinéma ', NULL, 1, '-17.00', 0, 5),
(533, '2019-04-19', 'Spar ', 4, 1, '-17.60', 0, 5),
(534, '2019-04-22', 'Spar', 4, 1, '-15.23', 0, 5),
(535, '2019-04-18', 'Depuis livret ', NULL, 2, '2530.00', 0, 5),
(536, '2019-04-18', 'Garage ', NULL, 3, '-1000.00', 0, 5),
(537, '2019-05-01', 'Garage ', NULL, 4, '-1037.31', 0, 5),
(538, '2019-04-18', 'Vers livret ', NULL, 2, '-630.00', 0, 5),
(539, '2019-04-22', 'Spar ', 4, 1, '-8.80', 0, 5),
(540, '2019-05-01', 'Leclerc ', 2, 1, '-18.62', 0, 5),
(541, '2019-05-01', 'Spar ', NULL, 1, '-25.83', 0, 5),
(542, '2019-05-01', 'Spar', 4, 1, '-17.60', 0, 5),
(543, '2019-04-22', 'Péage', 2, 1, '-2.80', 0, 5),
(544, '2019-04-22', 'Charges', NULL, 2, '178.06', 0, 5),
(545, '2019-05-01', 'Leclerc ', NULL, 1, '-13.12', 0, 5),
(546, '2019-05-01', 'Spar', 4, 1, '-17.60', 0, 5),
(547, '2019-05-01', 'Rôtisserie ', NULL, 1, '-18.50', 0, 5),
(548, '2019-05-01', 'Fleuriste ', NULL, 1, '-24.00', 0, 5),
(549, '2019-05-01', 'Spar ', 4, 1, '-17.60', 0, 5),
(550, '2019-05-01', 'Spar ', 4, 1, '-17.60', 0, 5),
(551, '2019-05-01', 'Spar ', 4, 1, '-17.60', 0, 5),
(552, '2019-05-01', 'Celio', NULL, 1, '-155.00', 0, 5),
(553, '2019-05-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(554, '2019-05-01', 'Salaire', NULL, 2, '2252.89', 0, 5),
(555, '2019-05-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(556, '2019-05-05', 'Assurance habitation', NULL, 5, '-18.73', 0, 5),
(557, '2019-05-15', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(558, '2019-05-05', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(559, '2019-05-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(560, '2019-05-03', 'Prêt crédit mutuel', NULL, 5, '-138.09', 0, 5),
(561, '2019-05-05', 'cbp', NULL, 5, '-20.82', 0, 5),
(562, '2019-05-01', 'Nespresso', NULL, 1, '-30.00', 0, 5),
(563, '2019-04-29', 'Salaire', NULL, 2, '618.00', 0, 5),
(564, '2019-05-16', 'Sosh', NULL, 5, '-24.99', 0, 5),
(565, '2019-05-05', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(566, '2019-05-18', 'EDF', NULL, 5, '-60.83', 0, 5),
(567, '2019-05-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(568, '2019-05-14', 'Suez', NULL, 5, '-22.00', 0, 5),
(569, '2019-05-01', 'Netflix', NULL, 1, '-10.99', 0, 5),
(570, '2019-05-15', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(571, '2019-05-22', 'Loyer', NULL, 2, '539.00', 0, 5),
(572, '2019-05-28', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(573, '2019-05-01', 'Retrait ', NULL, 3, '-20.00', 0, 5),
(574, '2019-05-01', 'Éléphant bleu ', 2, 1, '-20.00', 0, 5),
(575, '2019-05-01', 'Spar ', 4, 1, '-17.60', 0, 5),
(578, '2019-05-05', 'Spar ', 4, 1, '-88.00', 0, 5),
(579, '2019-05-02', 'Leclerc ', 2, 1, '-66.66', 0, 5),
(580, '2019-05-01', 'Vers livret ', NULL, 2, '-500.00', 0, 5),
(582, '2019-05-15', 'CAF', NULL, 2, '506.24', 0, 6),
(583, '2019-05-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(584, '2019-05-03', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(586, '2019-05-15', 'itunes', NULL, 5, '-12.99', 0, 6),
(587, '2019-05-03', 'spar', 4, 1, '-17.60', 0, 6),
(588, '2019-05-03', 'Spar', 4, 1, '-17.60', 0, 6),
(589, '2019-05-03', 'Leclerc', 1, 1, '-50.20', 0, 6),
(590, '2019-05-03', 'Le siécle d\'or', 3, 1, '-41.60', 0, 6),
(591, '2019-05-03', 'Leclerc', 1, 1, '-63.76', 0, 6),
(592, '2019-05-03', 'La strada', 3, 1, '-8.40', 0, 6),
(593, '2019-05-03', 'Spar', NULL, 1, '-17.60', 0, 6),
(594, '2019-05-03', 'Le bar des chënes', NULL, 1, '-17.60', 0, 6),
(595, '2019-05-03', 'Solde', NULL, 5, '-1355.20', 0, 6),
(597, '2019-05-08', 'Décathlon ', NULL, 1, '-27.00', 0, 6),
(598, '2019-05-08', 'Carrefour ', 2, 1, '-61.15', 0, 6),
(599, '2019-05-04', 'Vers livret ', NULL, 2, '-200.00', 0, 6),
(600, '2019-05-07', 'Devred', NULL, 1, '-349.95', 0, 5),
(601, '2019-05-07', 'Retrait ', 3, 3, '-40.00', 0, 5),
(602, '2019-05-07', 'Restaurant ', 3, 1, '-52.90', 0, 5),
(603, '2019-05-05', 'Parking ', 2, 1, '-8.50', 0, 5),
(604, '2019-05-08', 'Docteur ', NULL, 1, '-7.50', 0, 5),
(605, '2019-05-10', 'Undiz', NULL, 1, '-51.80', 0, 6),
(606, '2019-05-09', 'Sephora', NULL, 1, '-22.48', 0, 6),
(607, '2019-05-09', 'Kiko', NULL, 1, '-5.99', 0, 6),
(608, '2019-05-09', 'Kebab', 3, 1, '-14.50', 0, 6),
(609, '2019-05-09', 'Calzedonia', NULL, 1, '-11.25', 0, 6),
(610, '2019-05-09', 'Leclerc', 1, 1, '-5.11', 0, 6),
(611, '2019-05-09', 'Spar', 4, 1, '-35.20', 0, 6),
(612, '2019-05-10', 'Diamantor', NULL, 1, '-24.95', 0, 6),
(613, '2019-05-10', 4, 4, 1, '-17.60', 0, 6),
(614, '2019-05-10', 'Allianz', NULL, 2, '50.00', 0, 6),
(615, '2019-05-09', 'Leclerc', 1, 1, '-65.47', 0, 6),
(616, '2019-05-10', 'Spar ', 4, 1, '-55.80', 0, 5),
(617, '2019-05-10', 'Burger king', 3, 1, '-21.20', 0, 5),
(618, '2019-05-14', 'Leclerc ', 2, 1, '-23.00', 0, 5),
(619, '2019-05-11', 'Retrait ', 2, 3, '-20.00', 0, 5),
(620, '2019-05-14', 'Coiffeur ', NULL, 1, '-24.00', 0, 5),
(621, '2019-05-13', 'Spar ', 4, 1, '-88.00', 0, 5),
(622, '2019-05-13', 'Canal ', NULL, 1, '-19.90', 0, 5),
(623, '2019-05-14', 'Cotisation', NULL, 5, '-18.67', 0, 5),
(624, '2019-05-14', 'Frais Softease', NULL, 2, '549.60', 0, 5),
(625, '2019-05-14', 'Maxime', NULL, 2, '-170.00', 0, 5),
(626, '2019-05-14', 'Leclerc', 2, 1, '-46.42', 0, 5),
(627, '2019-05-20', 'Comptoir ', 3, 1, '-80.00', 0, 5),
(628, '2019-05-20', 'Péage ', 2, 1, '-7.60', 0, 5),
(629, '2019-06-01', 'Leclerc ', NULL, 1, '-7.76', 0, 5),
(630, '2019-06-01', 'Leclerc ', 2, 1, '-30.00', 0, 5),
(631, '2019-06-01', 'Antargaz', NULL, 1, '-18.65', 0, 5),
(632, '2019-06-01', 'Spar ', 4, 1, '-17.60', 0, 5),
(633, '2019-06-01', 'Rôtisserie ', NULL, 1, '-16.00', 0, 5),
(634, '2019-06-01', 'Spar ', 4, 1, '-26.40', 0, 5),
(635, '2019-06-01', 'Le grenier ', NULL, 1, '-65.00', 0, 5),
(636, '2019-06-01', 'Tabac ', 4, 1, '-26.40', 0, 5),
(637, '2019-06-01', 'Mozart et la pizza ', 3, 1, '-47.00', 0, 5),
(638, '2019-06-02', 'spar', 4, 1, '-17.60', 0, 5),
(639, '2019-06-02', 'BP', 2, 1, '-27.87', 0, 5),
(640, '2019-06-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(641, '2019-05-30', 'Salaire', NULL, 2, '2248.89', 0, 5),
(642, '2019-06-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(643, '2019-06-04', 'Salaire', NULL, 2, '618.00', 0, 5),
(644, '2019-06-04', 'Assurance habitation', NULL, 5, '-18.73', 0, 5),
(718, '2019-06-13', 'Vers livret ', NULL, 2, '-480.00', 0, 5),
(646, '2019-06-04', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(647, '2019-06-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(648, '2019-06-05', 'Prêt crédit mutuel', NULL, 5, '-146.74', 0, 5),
(649, '2019-06-04', 'cbp', NULL, 5, '-20.82', 0, 5),
(650, '2019-06-03', 'Nespresso', NULL, 1, '-29.00', 0, 5),
(651, '2019-06-16', 'Sosh', NULL, 5, '-24.99', 0, 5),
(652, '2019-06-04', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(653, '2019-06-19', 'EDF', NULL, 5, '-60.83', 0, 5),
(654, '2019-07-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(655, '2019-06-16', 'Suez', NULL, 5, '-22.00', 0, 5),
(656, '2019-06-03', 'Netflix', NULL, 1, '-10.99', 0, 5),
(657, '2019-06-17', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(658, '2019-06-22', 'Loyer', NULL, 2, '535.00', 0, 5),
(659, '2019-06-24', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(660, '2019-06-02', 'Leclerc ', 3, 1, '-45.66', 0, 5),
(661, '2019-06-03', 'Spar', 4, 1, '-26.40', 0, 5),
(662, '2019-06-03', 'Restaurant ', 3, 1, '-24.40', 0, 5),
(663, '2019-06-03', 'Péage ', 2, 1, '-19.50', 0, 5),
(664, '2019-06-03', 'Spar ', 4, 1, '-17.60', 0, 5),
(665, '2019-06-03', 'Péage ', 2, 1, '-1.50', 0, 5),
(666, '2019-06-03', 'Péage ', 2, 1, '-7.20', 0, 5),
(667, '2019-06-03', 'Leclerc ', 2, 1, '-46.70', 0, 5),
(668, '2019-06-03', 'Retrait ', NULL, 3, '-100.00', 0, 5),
(710, '2019-06-09', 'Printemps ', NULL, 1, '-149.00', 0, 5),
(670, '2019-06-03', 'Péage ', 2, 1, '-22.50', 0, 5),
(671, '2019-06-07', 'Péage ', 2, 1, '-19.50', 0, 5),
(672, '2019-06-03', 4, 4, 1, '-98.80', 0, 5),
(673, '2019-05-27', 'Salaire', NULL, 2, '1209.55', 0, 6),
(706, '2019-06-03', 'Spar', 4, 1, '-17.60', 0, 6),
(675, '2019-06-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(676, '2019-06-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(677, '2019-06-08', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(678, '2019-06-20', 'itunes', NULL, 5, '-12.99', 0, 6),
(679, '2019-06-05', 'lavage', 2, 1, '-6.00', 0, 5),
(680, '2019-06-05', 'Mc donald\'s', 3, 1, '-37.60', 0, 5),
(681, '2019-06-03', 'Atol', NULL, 1, '-50.00', 0, 5),
(682, '2019-06-05', 'Leclerc', 2, 1, '-68.23', 0, 5),
(683, '2019-06-03', 'Vetements', NULL, 1, '-116.95', 0, 5),
(684, '2019-06-05', 'Maxime', NULL, 2, '-170.00', 0, 5),
(703, '2019-06-01', 'vers livret', NULL, 2, '-200.00', 0, 6),
(686, '2019-04-01', 'CAF', NULL, 2, '150.00', 0, 6),
(687, '2019-04-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(688, '2019-04-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(689, '2019-04-08', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(690, '2019-04-10', 'itunes', NULL, 5, '-12.99', 0, 6),
(712, '2019-06-11', 'Parking ', 2, 1, '-1.80', 0, 5),
(713, '2019-06-11', 'Canal', NULL, 1, '-19.90', 0, 5),
(705, '2019-06-03', 'Leclerc', 1, 1, '-16.71', 0, 6),
(695, '2019-05-08', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(696, '2019-05-10', 'itunes', NULL, 5, '-12.99', 0, 6),
(704, '2019-06-03', 'Retrait', 3, 3, '-100.00', 0, 6),
(698, '2019-06-06', 'CAF', NULL, 2, '157.53', 0, 6),
(711, '2019-06-09', 'Nespresso', NULL, 1, '-1.00', 0, 5),
(708, '2019-06-01', 'Solde', NULL, 2, '261.58', 0, 6),
(709, '2019-06-08', 'OSCARO', 4, 1, '-97.48', 0, 6),
(707, '2019-06-03', 'Autogrill', 4, 1, '-110.49', 0, 6),
(714, '2019-06-11', 'Péage ', 2, 1, '-6.20', 0, 5),
(715, '2019-06-10', 'Siècle d\'or ', 3, 1, '-51.50', 0, 6),
(716, '2019-06-10', 'Leclerc ', 2, 1, '-82.89', 0, 6),
(717, '2019-06-13', 'Frais Softease', NULL, 2, '608.13', 0, 5),
(719, '2019-06-17', 'Spar ', 4, 1, '-26.40', 0, 5),
(720, '2019-06-17', 'Leclerc ', NULL, 1, '-33.76', 0, 5),
(721, '2019-06-17', 'Intermarché ', NULL, 1, '-26.77', 0, 5),
(722, '2019-06-15', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(723, '2019-06-16', 'Bouygues', NULL, 5, '-37.31', 0, 5),
(724, '2019-06-19', 'Leclerc ', 2, 1, '-45.11', 0, 5),
(766, '2019-07-01', 'Docteur ', NULL, 1, '-15.00', 0, 5),
(725, '2019-06-17', 'Leclerc ', NULL, 1, '-30.29', 0, 5),
(726, '2019-07-01', 'Leclerc ', 2, 1, '-16.05', 0, 5),
(727, '2019-06-19', 'Spar', 4, 1, '-17.60', 0, 5),
(728, '2019-07-01', 'Coiffeur ', NULL, 1, '-16.00', 0, 5),
(729, '2019-07-01', 'Spar ', 4, 1, '-26.40', 0, 5),
(730, '2019-07-01', 'Leclerc ', 2, 1, '-25.44', 0, 5),
(731, '2019-07-01', 'Spar ', 4, 1, '-26.40', 0, 5),
(732, '2019-07-01', 'Bluebox', NULL, 1, '-100.00', 0, 5),
(733, '2019-07-01', 'Kiabi', NULL, 1, '-25.00', 0, 5),
(734, '2019-07-01', 'Maxi zoo', NULL, 1, '-17.48', 0, 5),
(735, '2019-07-01', 'Devred', NULL, 1, '-59.98', 0, 5),
(736, '2019-07-01', 'Leclerc ', 2, 1, '-25.19', 0, 5),
(737, '2019-07-01', 'Péage', 2, 1, '-3.10', 0, 5),
(738, '2019-07-01', 'Spar', 4, 1, '-26.40', 0, 5),
(739, '2019-07-01', 'Spar', 4, 1, '-26.40', 0, 5),
(740, '2019-07-01', 'Pharmacie', NULL, 1, '-9.75', 0, 5),
(741, '2019-07-01', 'Carrossier', NULL, 1, '-250.00', 0, 5),
(742, '2019-06-28', 'Salaire', NULL, 2, '3611.27', 0, 5),
(743, '2019-07-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(744, '2019-07-01', 'Salaire', NULL, 2, '618.00', 0, 5),
(745, '2019-07-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(746, '2019-07-05', 'Assurance habitation', NULL, 5, '-25.22', 0, 5),
(747, '2019-07-14', 'Maxime', NULL, 2, '-170.00', 0, 5),
(748, '2019-07-14', 'Suez', NULL, 5, '-22.00', 0, 5),
(749, '2019-08-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(750, '2019-07-20', 'EDF', NULL, 5, '-60.83', 0, 5),
(751, '2019-07-05', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(752, '2019-07-02', 'Netflix', NULL, 1, '-10.99', 0, 5),
(753, '2019-07-14', 'Sosh', NULL, 5, '-24.99', 0, 5),
(754, '2019-07-15', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(755, '2019-07-02', 'Nespresso', NULL, 1, '-30.00', 0, 5),
(756, '2019-07-05', 'cbp', NULL, 5, '-20.82', 0, 5),
(757, '2019-07-05', 'Prêt crédit mutuel', NULL, 5, '-194.50', 0, 5),
(758, '2019-07-10', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(759, '2019-07-05', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(760, '2019-07-15', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(761, '2019-07-30', 'Loyer', NULL, 2, '550.52', 0, 5),
(762, '2019-07-25', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(763, '2019-07-01', 'Spar', 4, 1, '-26.40', 0, 5),
(764, '2019-06-28', 'Remboursement maxime', NULL, 2, '30.00', 0, 5),
(765, '2019-07-02', 'Essence Max', NULL, 1, '-29.99', 0, 5),
(767, '2019-07-01', 'Péage ', 2, 1, '-2.80', 0, 5),
(768, '2019-07-01', 'Bodeguita ', 3, 1, '-33.00', 0, 5),
(769, '2019-07-01', 'Mc donald\'s ', NULL, 1, '-4.50', 0, 5),
(770, '2019-07-01', 'La grande récré', NULL, 1, '-34.99', 0, 5),
(771, '2019-07-02', 'Spar', 4, 1, '-26.40', 0, 5),
(772, '2019-07-01', 'Ideafete', NULL, 1, '-7.50', 0, 5),
(773, '2019-07-01', 'Vers livret', NULL, 2, '-1150.00', 0, 5),
(774, '2019-07-03', 'Spar', 4, 1, '-26.40', 0, 5),
(775, '2019-07-01', 'Salaire', NULL, 2, '1297.12', 0, 6),
(776, '2019-07-05', 'CAF', NULL, 2, '157.53', 0, 6),
(777, '2019-07-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(778, '2019-07-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(779, '2019-07-08', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(780, '2019-07-10', 'itunes', NULL, 5, '-12.99', 0, 6),
(781, '2019-06-08', 'Leclerc', 1, 1, '-17.09', 0, 6),
(782, '2019-06-08', 'Grand frais', 1, 1, '-24.49', 0, 6),
(783, '2019-06-08', 'Leclerc', 1, 1, '-81.90', 0, 6),
(784, '2019-06-08', 'Leclerc', 2, 1, '-30.00', 0, 6),
(785, '2019-06-08', 'Leclerc', 2, 1, '-66.54', 0, 6),
(786, '2019-06-08', 'Dekra', NULL, 1, '-73.00', 0, 6),
(787, '2019-06-08', 'Leclerc', 1, 1, '-18.87', 0, 6),
(788, '2019-06-26', 'BP', 2, 1, '-20.00', 0, 6),
(789, '2019-06-27', 'Spar', 4, 1, '-17.60', 0, 6),
(790, '2019-06-27', 'Rotisserie', 1, 1, '-16.00', 0, 6),
(791, '2019-06-28', 4, 4, 1, '-26.40', 0, 6),
(792, '2019-07-01', 'Spar', 4, 1, '-17.60', 0, 6),
(793, '2019-07-01', 'Chaussea', NULL, 1, '-44.96', 0, 6),
(794, '2019-06-30', 'Leclerc', 1, 1, '-191.04', 0, 6),
(795, '2019-07-02', 'Auchan', 1, 1, '-23.96', 0, 6),
(796, '2019-07-02', 'Péage', 2, 1, '-2.80', 0, 6),
(797, '2019-07-02', 'Carrefour', 1, 1, '-34.70', 0, 6),
(798, '2019-07-03', 'Spar', 4, 1, '-17.60', 0, 6),
(799, '2019-07-02', 'Solde', NULL, 2, '12.89', 0, 6),
(800, '2019-07-05', 'Épargne ', NULL, 2, '-200.00', 0, 6),
(826, '2019-07-17', 'Décathlon', NULL, 1, '-36.50', 0, 5),
(802, '2019-07-05', 'Spar ', 4, 1, '-33.90', 0, 5),
(803, '2019-07-08', 'Carrefour', 2, 1, '-25.00', 0, 5),
(804, '2019-07-08', 4, 4, 1, '-26.40', 0, 5),
(805, '2019-07-08', 'Leclerc ', 2, 1, '-62.49', 0, 5),
(806, '2019-07-08', 'Boulanger', NULL, 1, '-649.00', 0, 5),
(807, '2019-07-08', 'Bluebox', NULL, 1, '-27.99', 0, 5),
(808, '2019-07-10', 'spar', 4, 1, '-26.40', 0, 5),
(809, '2019-07-10', 'Leclerc', 2, 1, '-27.47', 0, 5),
(810, '2019-07-10', 'Cotisation', NULL, 5, '-18.67', 0, 5),
(811, '2019-07-05', 'Allianz ', NULL, 2, '7.50', 0, 6),
(827, '2019-07-17', 'carrefour contact', 2, 1, '-18.68', 0, 5),
(813, '2019-07-08', 'Leclerc ', 1, 1, '-41.00', 0, 6),
(814, '2019-07-08', 'Siècle d\'or ', 3, 1, '-61.40', 0, 6),
(815, '2019-07-08', 'Spar ', 4, 1, '-26.40', 0, 6),
(816, '2019-07-08', 'Jennifer ', NULL, 1, '-42.97', 0, 6),
(817, '2019-07-11', 'Spar ', 4, 1, '17.60', 0, 6),
(818, '2019-07-11', 'Le duplex', 3, 1, '-50.50', 0, 6),
(819, '2019-07-11', 'Fleuriste ', NULL, 1, '-3.50', 0, 6),
(820, '2019-07-11', 4, 4, 1, '-52.80', 0, 6),
(821, '2019-07-14', 'Vétérinaire ', NULL, 1, '-280.00', 0, 5),
(822, '2019-07-13', 'Canal', NULL, 1, '-19.90', 0, 5),
(823, '2019-07-15', 'Frais Softease', NULL, 2, '705.52', 0, 5),
(824, '2019-07-14', 'restaurant', 3, 1, '-69.00', 0, 5),
(828, '2019-07-22', 'Spar', 4, 1, '-26.40', 0, 5),
(829, '2019-07-15', 'Spar ', 4, 1, '-17.60', 0, 6),
(830, '2019-07-15', 'Leclerc ', 1, 1, '-55.35', 0, 6),
(831, '2019-07-15', 'Leclerc ', 1, 1, '-58.69', 0, 6),
(832, '2019-07-16', 'Spar ', 4, 1, '-26.40', 0, 6),
(833, '2019-07-16', 'Leclerc ', 1, 1, '-68.48', 0, 6),
(834, '2019-07-17', 'Leclerc ', 1, 1, '-43.39', 0, 6),
(835, '2019-07-18', 'Centifolia ', 3, 1, '-28.50', 0, 6),
(836, '2019-07-22', 'Vétérinaire ', NULL, 1, '-115.60', 0, 5),
(837, '2019-07-22', 'Spar ', 4, 1, '-31.35', 0, 5),
(838, '2019-07-22', 'Eurovap ', NULL, 1, '-8.50', 0, 5),
(839, '2019-07-22', 'Eurovap ', NULL, 1, '-5.50', 0, 5),
(840, '2019-07-22', 'Gifi', NULL, 1, '-40.74', 0, 5),
(1007, '2019-08-29', 'Docteur ', NULL, 2, '7.50', 0, 6),
(841, '2019-07-23', 'Impôts', NULL, 2, '3360.00', 0, 5),
(842, '2019-07-23', 'Vers livret', NULL, 2, '-2850.00', 0, 5),
(843, '2019-08-01', 'Spar ', 4, 1, '-31.45', 0, 5),
(844, '2019-08-01', 'Chaussea ', NULL, 1, '-54.99', 0, 5),
(845, '2019-08-01', 'Bp', 2, 1, '-24.29', 0, 5),
(846, '2019-08-01', 'La rôtisserie', 3, 1, '-15.49', 0, 5),
(847, '2019-08-01', 'Coiffeur ', NULL, 1, '-24.00', 0, 5),
(848, '2019-08-01', 'Devred', NULL, 1, '-49.98', 0, 5),
(849, '2019-08-01', ' Celio', NULL, 1, '-26.00', 0, 5),
(851, '2019-08-01', 'Basika', NULL, 1, '-35.00', 0, 5),
(852, '2019-08-01', 'Memphis', 3, 1, '-49.85', 0, 5),
(853, '2019-08-01', 'Spar ', 4, 1, '-26.40', 0, 5),
(883, '2019-07-22', 'Spar ', 4, 1, '-26.40', 0, 6),
(854, '2019-07-28', 'Retrait ', 3, 3, '-80.00', 0, 5),
(1008, '2019-08-30', 'Leclerc ', 1, 1, '-29.78', 0, 6),
(856, '2019-08-01', 'Leclerc ', 2, 1, '-68.07', 0, 5),
(857, '2019-08-01', 'Bershka', NULL, 1, '-9.99', 0, 5),
(858, '2019-08-01', 'Justbio', NULL, 1, '-12.00', 0, 5),
(859, '2019-08-01', 'Jd sport ', NULL, 1, '-55.00', 0, 5);
INSERT INTO `operations` (`id`, `deadline_date`, `name`, `budget_id`, `payment_id`, `amount`, `credit_card_state`, `user_id`) VALUES
(860, '2019-08-01', 'Lacoste ', NULL, 1, '-123.00', 0, 5),
(861, '2019-07-31', 'Salaire', NULL, 2, '2472.29', 0, 5),
(862, '2019-08-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(863, '2019-07-31', 'Salaire', NULL, 2, '882.86', 0, 5),
(864, '2019-08-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(865, '2019-08-04', 'Assurance habitation', NULL, 5, '-19.31', 0, 5),
(866, '2019-08-05', 'Maxime', NULL, 2, '-170.00', 0, 5),
(867, '2019-08-15', 'Suez', NULL, 5, '-22.00', 0, 5),
(1017, '2019-09-04', 'Spar ', 4, 1, '-17.60', 0, 5),
(869, '2019-08-19', 'EDF', NULL, 5, '-60.83', 0, 5),
(870, '2019-08-04', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(871, '2019-08-01', 'Netflix', NULL, 1, '-10.99', 0, 5),
(872, '2019-08-15', 'Sosh', NULL, 5, '-24.99', 0, 5),
(873, '2019-08-17', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(874, '2019-08-01', 'Nespresso', NULL, 1, '-29.00', 0, 5),
(875, '2019-08-04', 'cbp', NULL, 5, '-24.27', 0, 5),
(876, '2019-08-05', 'Prêt crédit mutuel', NULL, 5, '-221.34', 0, 5),
(877, '2019-08-11', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(878, '2019-08-04', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(879, '2019-08-17', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(880, '2019-08-26', 'Loyer', NULL, 2, '542.76', 0, 5),
(881, '2019-08-26', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(882, '2019-08-01', 'Portugal ', NULL, 1, '-665.97', 0, 5),
(884, '2019-07-22', 'Spar ', 4, 1, '-17.60', 0, 6),
(885, '2019-07-22', 'Jennyfer', NULL, 1, '27.98', 0, 6),
(886, '2019-07-22', 'Leclerc ', 1, 1, '-95.36', 0, 6),
(887, '2019-07-23', 'Spar ', 4, 1, '-19.60', 0, 6),
(888, '2019-07-30', 'Salaire', NULL, 2, '1297.12', 0, 6),
(889, '2019-08-01', 'CAF', NULL, 2, '149.64', 0, 6),
(890, '2019-08-04', 'Axa', NULL, 5, '-60.93', 0, 6),
(891, '2019-08-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(892, '2019-08-08', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(893, '2019-08-12', 'itunes', NULL, 5, '-12.99', 0, 6),
(894, '2019-07-29', 'Leclerc ', 1, 1, '-29.95', 0, 6),
(895, '2019-07-29', 'Anniversaire Léa ', NULL, 1, '-60.00', 0, 6),
(896, '2019-07-29', 'Pro coiffure ', 3, 1, '-11.00', 0, 6),
(897, '2019-07-30', 'Vers livret ', NULL, 2, '-200.00', 0, 6),
(898, '2019-07-30', 'Kiko', NULL, 1, '-28.48', 0, 6),
(899, '2019-07-30', 'Undiz', NULL, 1, '-55.75', 0, 6),
(900, '2019-07-30', 'Primark', NULL, 1, '-11.00', 0, 6),
(901, '2019-07-30', 'Spar', 4, 1, '-17.60', 0, 6),
(902, '2019-07-30', 'Tigella', 3, 1, '-13.40', 0, 6),
(903, '2019-07-30', 'Parking', 2, 1, '-4.20', 0, 6),
(904, '2019-07-30', 'Leclerc ', 2, 1, '-104.88', 0, 6),
(905, '2019-07-30', 'Tabac des chênes ', 4, 1, '-17.60', 0, 6),
(906, '2019-07-31', 'Gwen', NULL, 2, '350.00', 0, 5),
(907, '2019-08-01', 'Calvin Klein ', NULL, 1, '-68.50', 0, 5),
(910, '2019-08-01', 'Upper', 3, 1, '-37.00', 0, 5),
(911, '2019-08-01', 'Nespresso', NULL, 1, '-1.00', 0, 5),
(912, '2019-08-01', 'Spar ', 4, 1, '-26.40', 0, 5),
(913, '2019-08-04', 'Spar ', 4, 1, '-26.40', 0, 5),
(914, '2019-08-04', 'Spar ', 4, 1, '-17.60', 0, 5),
(915, '2019-07-31', 'Mac do', 3, 1, '-31.00', 0, 6),
(916, '2019-07-31', 'Frais de déplacement ', NULL, 2, '39.81', 0, 6),
(917, '2019-08-01', 'Spar ', 4, 1, '-17.60', 0, 6),
(918, '2019-08-07', 'Parking ', 2, 1, '-3.00', 0, 5),
(919, '2019-08-07', 'Spar ', 4, 1, '-17.60', 0, 5),
(920, '2019-08-07', 'La strada', 3, 1, '-12.50', 0, 5),
(921, '2019-08-04', 'Cinéma ', 3, 1, '-75.50', 0, 6),
(922, '2019-08-04', 'Spar', 4, 1, '-35.20', 0, 6),
(923, '2019-08-04', 'Leclerc ', 1, 1, '-102.92', 0, 6),
(924, '2019-08-08', 'Spar ', 4, 1, '-26.40', 0, 6),
(925, '2019-08-12', 'Spar ', 4, 1, '-38.20', 0, 5),
(926, '2019-08-12', 'Spar ', 4, 1, '-26.40', 0, 5),
(927, '2019-08-11', 'Spar ', 4, 1, '-26.40', 0, 5),
(928, '2019-08-12', 'Pharmacie', NULL, 1, '-9.99', 0, 5),
(1009, '2019-08-30', 'Spar ', 4, 1, '-17.60', 0, 6),
(930, '2019-08-08', 'Leclerc ', 1, 1, '-62.45', 0, 6),
(931, '2019-08-12', 'Canal', NULL, 1, '-19.90', 0, 5),
(932, '2019-08-12', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(933, '2019-08-13', 'Leclerc', NULL, 1, '-2.28', 0, 5),
(934, '2019-08-13', 'Spar', 4, 1, '-17.60', 0, 5),
(935, '2019-08-15', 'Spar', 4, 1, '-20.10', 0, 5),
(936, '2019-08-15', 'Veterinaire ', NULL, 1, '-21.40', 0, 5),
(937, '2019-08-13', 'Max', 4, 2, '-100.00', 0, 5),
(938, '2019-08-15', 'Spar ', 4, 2, '-50.00', 0, 6),
(939, '2019-08-13', 'Shopping ', 3, 1, '-32.00', 0, 6),
(940, '2019-08-13', 'Shopping ', 3, 1, '-42.80', 0, 6),
(941, '2019-08-13', 'Spar ', 4, 1, '-17.60', 0, 6),
(942, '2019-08-12', 'Siècle d\'or ', 3, 1, '-61.50', 0, 6),
(943, '2019-08-12', 'Leclerc ', 2, 1, '-75.75', 0, 6),
(944, '2019-08-12', 'Pro coiffure ', 3, 1, '-12.00', 0, 6),
(945, '2019-08-12', 'Spar', 4, 1, '-17.60', 0, 6),
(949, '2019-08-15', 'Gwen', 4, 2, '50.00', 0, 5),
(950, '2019-08-17', 'Casino', 3, 1, '-28.49', 0, 5),
(951, '2019-08-19', 'Leclerc ', 2, 1, '-41.90', 0, 5),
(952, '2019-08-19', 'Comptoir ', 3, 1, '-80.50', 0, 5),
(953, '2019-08-19', 'Leclerc ', 2, 1, '-25.40', 0, 5),
(954, '2019-08-21', 'Leclerc ', 2, 1, '-6.00', 0, 5),
(955, '2019-08-21', 'Retrait ', 3, 3, '-80.00', 0, 5),
(956, '2019-08-19', 'Parking ', 2, 1, '-9.00', 0, 5),
(957, '2019-08-19', 'Péage ', 2, 1, '-2.80', 0, 5),
(958, '2019-08-21', 'EasyJet ', NULL, 1, '-90.74', 0, 5),
(960, '2019-09-01', 'Europcar', 3, 1, '-72.39', 0, 5),
(961, '2019-08-16', 'Voyage ', 3, 2, '-85.00', 0, 6),
(962, '2019-08-16', 'Leclerc ', 1, 1, '-50.70', 0, 6),
(963, '2019-08-18', 'Gwen', NULL, 2, '85.00', 0, 5),
(964, '2019-08-19', 'Frais Softease', NULL, 2, '385.39', 0, 5),
(965, '2019-08-30', 'Salaire', NULL, 2, '2253.12', 0, 5),
(966, '2019-09-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(967, '2019-09-01', 'Salaire', NULL, 2, '882.86', 0, 5),
(968, '2019-09-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(969, '2019-09-04', 'Assurance habitation', NULL, 5, '-19.32', 0, 5),
(970, '2019-09-01', 'Maxime', NULL, 2, '-170.00', 0, 5),
(971, '2019-09-15', 'Suez', NULL, 5, '-22.00', 0, 5),
(972, '2019-10-03', 'Spotify', NULL, 1, '-9.99', 0, 5),
(973, '2019-09-19', 'EDF', NULL, 5, '-60.83', 0, 5),
(974, '2019-09-04', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(975, '2019-09-02', 'Netflix', NULL, 1, '-10.99', 0, 5),
(976, '2019-09-15', 'Sosh', NULL, 5, '-24.99', 0, 5),
(977, '2019-09-19', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(978, '2019-09-02', 'Nespresso', NULL, 1, '-29.00', 0, 5),
(979, '2019-09-04', 'cbp', NULL, 5, '-24.27', 0, 5),
(980, '2019-09-05', 'Prêt crédit mutuel', NULL, 5, '-221.34', 0, 5),
(981, '2019-09-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(982, '2019-09-04', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(983, '2019-09-15', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(984, '2019-09-24', 'Loyer', NULL, 2, '542.76', 0, 5),
(985, '2019-09-24', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(986, '2019-09-01', 'Leclerc ', NULL, 1, '-77.10', 0, 5),
(987, '2019-09-01', 'Spar ', 4, 1, '-26.40', 0, 5),
(988, '2019-09-01', 'Le havane', 4, 1, '-26.40', 0, 5),
(989, '2019-09-01', 'Spar ', 4, 1, '-17.60', 0, 5),
(990, '2019-09-01', 'Leclerc ', NULL, 1, '-14.19', 0, 5),
(991, '2019-09-01', 'Lidl', NULL, 1, '-42.73', 0, 5),
(992, '2019-09-01', 'Aqualand', 3, 1, '-61.00', 0, 5),
(993, '2019-09-01', 'Bmw', NULL, 1, '-1.00', 0, 5),
(994, '2019-08-22', 'Docteur ', NULL, 1, '-15.00', 0, 6),
(995, '2019-08-23', 'Leclerc ', 1, 1, '-77.96', 0, 6),
(996, '2019-08-27', 'Spar ', 4, 1, '-26.40', 0, 6),
(997, '2019-08-28', 'Salaire', NULL, 2, '1297.12', 0, 6),
(998, '2019-08-28', 'Épargne ', NULL, 2, '-200.00', 0, 6),
(1005, '2019-09-01', 'Spar', 4, 1, '-26.40', 0, 5),
(1000, '2019-09-05', 'CAF', NULL, 2, '149.64', 0, 6),
(1001, '2019-09-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(1002, '2019-09-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1003, '2019-09-08', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(1004, '2019-09-10', 'itunes', NULL, 5, '-12.99', 0, 6),
(1006, '2019-09-01', 'Spar', 4, 1, '-31.35', 0, 5),
(1011, '2019-09-02', 'Vacances ', 3, 1, '-360.00', 0, 6),
(1012, '2019-09-02', 'Leclerc ', 1, 1, '-50.34', 0, 6),
(1013, '2019-09-01', 'Vers livret ', NULL, 2, '-1000.00', 0, 5),
(1014, '2019-09-02', 'Spar ', 4, 1, '-17.60', 0, 6),
(1015, '2019-09-02', 'Amazon', NULL, 1, '-29.99', 0, 5),
(1016, '2019-09-02', 'Spar ', 4, 1, '-17.60', 0, 5),
(1083, '2019-10-01', 'Fdj', NULL, 1, '-25.00', 0, 5),
(1018, '2019-09-04', 'Décathlon', NULL, 1, '-11.30', 0, 5),
(1019, '2019-09-04', 'Spar ', 4, 1, '-26.40', 0, 5),
(1020, '2019-09-04', 'Nespresso', NULL, 1, '-1.00', 0, 5),
(1021, '2019-09-03', 'Diamantor ', NULL, 1, '-34.90', 0, 6),
(1022, '2019-09-03', 'Leclerc ', 1, 1, '-17.32', 0, 6),
(1023, '2019-09-03', 'Centreakor ', NULL, 1, '-27.12', 0, 6),
(1024, '2019-09-04', 'Spar ', 4, 1, '-8.80', 0, 6),
(1025, '2019-09-05', 'Leclerc ', 2, 1, '-20.62', 0, 6),
(1026, '2019-09-05', 'Boulangerie ', 1, 1, '-8.10', 0, 6),
(1027, '2019-09-05', 'Péage', 2, 1, '-3.10', 0, 5),
(1028, '2019-09-08', 4, 4, 1, '-51.00', 0, 5),
(1029, '2019-09-08', 4, 4, 1, '-153.00', 0, 5),
(1056, '2019-10-01', 'Docteur ', NULL, 1, '-7.50', 0, 5),
(1031, '2019-09-11', 'Maxime', NULL, 2, '50.00', 0, 5),
(1032, '2019-09-07', 'Cigarette ', 4, 1, '-153.00', 0, 6),
(1033, '2019-09-14', 'Briconautes ', NULL, 1, '-10.90', 0, 5),
(1034, '2019-09-12', 'Diamantor', NULL, 1, '-49.90', 0, 5),
(1035, '2019-09-11', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1036, '2019-09-11', 'Canal', NULL, 1, '-19.90', 0, 5),
(1037, '2019-09-11', 'Péage ', 2, 1, '-3.10', 0, 5),
(1038, '2019-09-11', 'Leclerc ', 1, 1, '-55.49', 0, 6),
(1039, '2019-09-12', 'Europcar', NULL, 1, '-184.50', 0, 5),
(1040, '2019-09-12', 'Parking ', 2, 1, '-5.20', 0, 5),
(1041, '2019-09-17', 'Gifi', NULL, 1, '-48.19', 0, 5),
(1042, '2019-09-17', 'Coiffeur ', NULL, 1, '-21.00', 0, 5),
(1043, '2019-10-01', 'La cabane', 3, 1, '-85.00', 0, 5),
(1044, '2019-09-13', 'Péage ', 2, 1, '-5.20', 0, 6),
(1045, '2019-09-13', 'Cadeau ', NULL, 1, '-54.95', 0, 6),
(1046, '2019-10-25', 'Taxe foncière ', NULL, 5, '-342.00', 0, 5),
(1047, '2019-09-15', 'Depuis livret', NULL, 2, '800.00', 0, 5),
(1048, '2019-09-16', 'Parking', 2, 1, '-3.10', 0, 6),
(1049, '2019-09-16', 'Leclerc ', 1, 1, '-63.28', 0, 6),
(1050, '2019-09-16', 'Parking', 2, 1, '-12.00', 0, 6),
(1051, '2019-09-19', 'PayPal', NULL, 5, '-3.35', 0, 5),
(1052, '2019-09-19', 'Fdj', NULL, 1, '-20.00', 0, 5),
(1053, '2019-09-19', 'Pharmacie', NULL, 1, '-19.40', 0, 5),
(1054, '2019-09-19', 'Péage ', 2, 1, '-3.10', 0, 5),
(1055, '2019-10-01', 'Myprotein', NULL, 1, '-51.00', 0, 5),
(1236, '2019-10-28', 'Salaire', NULL, 2, '1297.12', 0, 6),
(1057, '2019-10-01', 'Pharmacie', NULL, 1, '-6.45', 0, 5),
(1058, '2019-10-01', 'Leclerc', NULL, 1, '-10.47', 0, 5),
(1059, '2019-09-24', 'Vers livret ', NULL, 2, '-300.00', 0, 5),
(1060, '2019-09-23', 'Leclerc ', 1, 1, '-72.79', 0, 6),
(1061, '2019-09-27', 'Salaire', NULL, 2, '1297.12', 0, 6),
(1062, '2019-09-27', 'Épargne ', NULL, 2, '-200.00', 0, 6),
(1063, '2019-09-30', 'Salaire', NULL, 2, '4856.83', 0, 5),
(1064, '2019-10-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(1065, '2019-10-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(1066, '2019-10-01', 'Salaire', NULL, 2, '882.86', 0, 5),
(1067, '2019-10-07', 'Maxime', NULL, 2, '-180.00', 0, 5),
(1068, '2019-10-06', 'Assurance habitation', NULL, 5, '-19.31', 0, 5),
(1069, '2019-10-15', 'Sosh', NULL, 5, '-27.99', 0, 5),
(1070, '2019-10-06', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(1071, '2019-10-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(1072, '2019-10-04', 'Prêt crédit mutuel', NULL, 5, '-221.34', 0, 5),
(1073, '2019-10-06', 'cbp', NULL, 5, '-24.27', 0, 5),
(1074, '2019-10-04', 'Nespresso', NULL, 1, '-30.00', 0, 5),
(1075, '2019-10-06', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(1076, '2019-10-20', 'EDF', NULL, 5, '-60.83', 0, 5),
(1077, '2019-10-15', 'Suez', NULL, 5, '-22.00', 0, 5),
(1078, '2019-10-04', 'Netflix', NULL, 1, '-11.99', 0, 5),
(1079, '2019-10-15', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(1080, '2019-10-15', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(1255, '2019-11-04', 'Maxime', 4, 2, '-57.00', 0, 5),
(1082, '2019-10-24', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(1084, '2019-10-01', 'Europcar', 3, 1, '-13.70', 0, 5),
(1085, '2019-09-30', 'Vers livret ', NULL, 2, '-2500.00', 0, 5),
(1086, '2019-09-30', 'Leclerc ', 1, 1, '-100.40', 0, 6),
(1093, '2019-10-01', 'Leclerc ', 2, 1, '-70.00', 0, 6),
(1088, '2019-10-04', 'CAF', NULL, 2, '149.64', 0, 6),
(1090, '2019-10-04', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1091, '2019-10-10', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(1092, '2019-10-01', 'itunes', NULL, 5, '-12.99', 0, 6),
(1094, '2019-10-03', 'Deco', NULL, 1, '-13.99', 0, 6),
(1095, '2019-10-04', 'Mac do', 3, 1, '-29.70', 0, 6),
(1096, '2019-10-04', 'Ticket ', NULL, 1, '-846.00', 0, 5),
(1097, '2019-10-04', 'Spar', 4, 1, '-26.40', 0, 5),
(1098, '2019-10-04', 'Leclerc ', 2, 1, '-14.82', 0, 5),
(1099, '2019-10-05', 'Stan smith ', 3, 1, '-69.90', 0, 6),
(1100, '2019-10-05', 'Go sport ', 3, 1, '-24.99', 0, 6),
(1101, '2019-10-05', 'Sephora ', 3, 1, '-30.97', 0, 6),
(1102, '2019-10-05', 'H&m', 4, 1, '-39.99', 0, 6),
(1103, '2019-10-05', 'Leclerc ', 1, 1, '-93.10', 0, 6),
(1104, '2019-10-05', 'Bershka ', 4, 1, '-62.97', 0, 6),
(1105, '2019-10-07', 'Galerie ', NULL, 1, '-65.00', 0, 5),
(1106, '2019-10-07', 'Undiz', NULL, 1, '-12.95', 0, 5),
(1107, '2019-10-07', 'Leclerc ', NULL, 1, '-45.27', 0, 5),
(1108, '2019-10-07', 'Lacoste ', NULL, 1, '-190.00', 0, 5),
(1109, '2019-10-06', 'Nicky', 4, 1, '-72.80', 0, 6),
(1110, '2019-10-07', 'Maxime', NULL, 2, '25.00', 0, 5),
(1111, '2019-10-07', 'Le petit vapoteur', 4, 1, '-43.10', 0, 5),
(1112, '2019-10-07', 'Péage', 2, 1, '-4.10', 0, 5),
(1113, '2019-10-07', 'Parking', 2, 1, '-1.20', 0, 6),
(1114, '2019-10-07', 'Éléphant bleu', 2, 1, '-20.00', 0, 6),
(1115, '2019-10-07', 'Péage ', 2, 1, '-3.10', 0, 6),
(1118, '2019-10-17', 'Spar ', 4, 1, '-17.60', 0, 5),
(1119, '2019-10-12', 4, 4, 1, '-17.60', 0, 5),
(1120, '2019-10-12', 'Spar ', 4, 1, '-17.60', 0, 5),
(1121, '2019-10-15', 'Spar ', 4, 1, '-22.55', 0, 5),
(1122, '2019-10-12', 'Canal', NULL, 1, '-19.90', 0, 5),
(1123, '2019-10-09', 'Danse', NULL, 4, '-100.00', 0, 6),
(1158, '2019-10-24', 'Leclerc ', 1, 1, '-85.19', 0, 6),
(1125, '2019-10-10', 'Pharmacie ', NULL, 1, '-11.90', 0, 6),
(1126, '2019-10-15', 'Leclerc ', 1, 1, '-91.81', 0, 6),
(1127, '2019-10-15', 'Mac do', 3, 1, '-20.10', 0, 6),
(1128, '2019-10-15', 'Vente privée ', 3, 1, '-16.99', 0, 6),
(1129, '2019-10-17', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1130, '2019-10-19', 'Retrait ', 3, 3, '-40.00', 0, 6),
(1131, '2019-10-20', 'Depuis livret', NULL, 2, '600.00', 0, 5),
(1132, '2019-11-01', 'L\'amandier', 3, 1, '-140.00', 0, 5),
(1133, '2019-11-01', 'Amazon', NULL, 1, '-33.99', 0, 5),
(1134, '2019-10-30', 'Salaire', NULL, 2, '1942.30', 0, 5),
(1135, '2019-11-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(1136, '2019-11-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(1137, '2019-11-04', 'Assurance habitation', NULL, 5, '-19.32', 0, 5),
(1159, '2019-11-01', 'Holà bar', NULL, 1, '-72.00', 0, 5),
(1139, '2019-11-03', 'Netflix', NULL, 1, '-11.99', 0, 5),
(1140, '2019-11-15', 'Suez', NULL, 5, '-36.00', 0, 5),
(1141, '2019-11-19', 'EDF', NULL, 5, '-88.50', 0, 5),
(1142, '2019-11-04', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(1143, '2019-11-17', 'Taxe d\'habitation', NULL, 5, '-68.00', 0, 5),
(1144, '2019-11-17', 'Sosh', NULL, 5, '-24.99', 0, 5),
(1145, '2019-11-03', 'Nespresso', NULL, 1, '-42.00', 0, 5),
(1146, '2019-11-04', 'cbp', NULL, 5, '-24.27', 0, 5),
(1147, '2019-11-05', 'Prêt crédit mutuel', NULL, 5, '-221.82', 0, 5),
(1148, '2019-11-10', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(1149, '2019-11-04', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(1150, '2019-11-17', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(1151, '2019-11-21', 'Loyer', NULL, 2, '510.77', 0, 5),
(1152, '2019-11-24', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(1153, '2019-10-23', 'Coiffure ', NULL, 1, '-100.00', 0, 6),
(1154, '2019-11-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(1155, '2019-10-23', 'Essence ', 2, 1, '-30.24', 0, 6),
(1156, '2019-10-21', 'Siècle d\'or ', NULL, 1, '-30.00', 0, 6),
(1157, '2019-10-21', 'Leclerc ', 1, 1, '-98.29', 0, 6),
(1160, '2019-10-27', 'Maxime ', NULL, 2, '30.00', 0, 5),
(1274, '2019-11-11', 'Canal', NULL, 1, '-19.90', 0, 5),
(1296, '2019-11-18', 'Ikea', 4, 1, '-64.06', 0, 6),
(1293, '2019-11-15', 'Radio ', NULL, 1, '-40.98', 0, 6),
(1295, '2019-11-18', 'Leclerc ', 1, 1, '-109.39', 0, 6),
(1235, '2019-10-29', 'Leclerc ', 1, 1, '-68.99', 0, 6),
(1237, '2019-11-05', 'CAF', NULL, 2, '139.30', 0, 6),
(1286, '2019-11-13', 'Docteur ', NULL, 1, '-7.50', 0, 6),
(1239, '2019-11-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1240, '2019-11-07', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(1242, '2019-10-31', 'itunes', NULL, 5, '-12.99', 0, 6),
(1243, '2019-10-31', 'Épargne ', NULL, 2, '-200.00', 0, 6),
(1244, '2019-11-01', 'Tabac ', 4, 1, '-26.40', 0, 5),
(1246, '2019-11-03', 'Conforama ', NULL, 1, '-899.50', 0, 5),
(1247, '2019-11-03', 'Canapé ', NULL, 2, '900.00', 0, 5),
(1248, '2019-11-01', 'Mac do', 3, 1, '-23.70', 0, 6),
(1249, '2019-11-01', 'Cultura', NULL, 1, '-26.14', 0, 6),
(1250, '2019-11-02', 'Leclerc ', 1, 1, '-79.29', 0, 6),
(1251, '2019-11-01', 'Leclerc ', 1, 1, '-58.00', 0, 6),
(1252, '2019-11-01', 'Jennyfer', 3, 1, '-67.96', 0, 6),
(1253, '2019-11-02', 'Conforma ', 3, 1, '-60.95', 0, 6),
(1427, '2019-12-29', 'Vers livret ', NULL, 2, '-150.00', 0, 5),
(1352, '2019-12-01', 'Spar', 4, 1, '-18.60', 0, 5),
(1386, '2019-12-10', 'Virement ', NULL, 2, '400.00', 0, 6),
(1362, '2019-12-02', 'Boulanger ', 3, 1, '-59.98', 0, 6),
(1260, '2019-12-08', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(1261, '2019-12-02', 'itunes', NULL, 5, '-12.99', 0, 6),
(1353, '2019-12-01', 'Antargaz', NULL, 1, '-18.65', 0, 5),
(1387, '2019-12-10', 'Leclerc ', 1, 1, '-90.04', 0, 6),
(1265, '2019-12-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1266, '2019-12-02', 'My little box', NULL, 5, '-17.90', 0, 6),
(1363, '2019-12-02', 'Khaan', 3, 1, '-50.98', 0, 6),
(1364, '2019-12-02', 'Victoria secret ', 4, 1, '-56.80', 0, 6),
(1269, '2019-11-06', 'My little box', NULL, 5, '-14.30', 0, 6),
(1270, '2019-11-07', 'Leclerc ', 2, 1, '-70.00', 0, 6),
(1275, '2019-11-11', 'Gifi', NULL, 1, '-37.89', 0, 5),
(1276, '2019-11-11', 'Rôtisserie', 3, 1, '-25.12', 0, 5),
(1297, '2019-11-19', 'Spar', 4, 1, '-27.90', 0, 5),
(1282, '2019-11-11', 'Leclerc ', 1, 1, '-136.18', 0, 6),
(1283, '2019-11-11', 'Pharmacie ', NULL, 1, '-30.35', 0, 6),
(1284, '2019-11-11', 'Centifolia ', 3, 1, '-23.50', 0, 6),
(1285, '2019-11-11', 'Docteur ', NULL, 1, '-25.00', 0, 6),
(1287, '2019-11-15', 'Maxime', 4, 2, '-19.20', 0, 5),
(1288, '2019-11-15', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1289, '2019-11-15', 'Veterinaire ', 4, 1, '-48.00', 0, 5),
(1290, '2019-11-16', 'Maxime', 4, 2, '-9.60', 0, 5),
(1355, '2019-12-03', 'Acquisto', 4, 1, '-280.00', 0, 5),
(1298, '2019-11-19', 'Mozart', 3, 1, '-25.50', 0, 5),
(1299, '2019-11-19', 'Bonne question', 2, 1, '-4.80', 0, 5),
(1300, '2019-11-19', 'Péage ', 4, 1, '-23.00', 0, 6),
(1301, '2019-11-19', 'Mac do', 4, 1, '-29.60', 0, 6),
(1302, '2019-11-19', 'Remboursement ', NULL, 2, '12.50', 0, 6),
(1303, '2019-11-19', 'Remboursement ', NULL, 2, '12.50', 0, 6),
(1305, '2019-11-21', 'Depuis livret', NULL, 2, '800.00', 0, 5),
(1306, '2019-11-20', 'Remboursement ', NULL, 2, '29.42', 0, 6),
(1307, '2019-11-21', 'Leclerc ', 1, 1, '-89.70', 0, 6),
(1308, '2019-11-23', 'Leclerc ', 1, 1, '-138.42', 0, 6),
(1309, '2019-11-23', 'Virement gwen', NULL, 2, '100.00', 0, 6),
(1310, '2019-12-01', 'Spar', 4, 1, '-18.60', 0, 5),
(1311, '2019-12-01', 'Mc donald\'s ', 3, 1, '-23.60', 0, 5),
(1312, '2019-12-01', 'Spar ', 4, 1, '-18.60', 0, 5),
(1313, '2019-12-01', 4, 4, 1, '-27.90', 0, 5),
(1360, '2019-12-01', 'Péage', 2, 1, '-7.20', 0, 5),
(1315, '2019-12-01', 'Loyer', NULL, 2, '-953.00', 0, 5),
(1316, '2019-12-01', 'Salaire', NULL, 2, '1981.98', 0, 5),
(1317, '2019-12-01', 'Garage', NULL, 2, '-100.00', 0, 5),
(1318, '2019-12-01', 'Spotify', NULL, 1, '-9.99', 0, 5),
(1319, '2019-12-04', 'Assurance habitation', NULL, 5, '-19.31', 0, 5),
(1320, '2019-12-15', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(1321, '2019-12-04', 'Pno BV', NULL, 5, '-10.87', 0, 5),
(1322, '2019-12-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(1323, '2019-12-05', 'Prêt crédit mutuel', NULL, 5, '-221.82', 0, 5),
(1324, '2019-12-04', 'cbp', NULL, 5, '-24.27', 0, 5),
(1327, '2019-12-04', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(1328, '2019-12-19', 'EDF', NULL, 5, '-88.50', 0, 5),
(1329, '2019-12-15', 'Suez', NULL, 5, '-36.00', 0, 5),
(1330, '2019-12-01', 'Netflix', NULL, 1, '-11.99', 0, 5),
(1331, '2019-12-17', 'Taxe d\'habitation', NULL, 5, '-72.00', 0, 5),
(1332, '2019-12-19', 'Loyer', NULL, 2, '542.76', 0, 5),
(1333, '2019-12-26', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(1334, '2019-12-01', 'Leclerc ', 2, 1, '-2.98', 0, 5),
(1351, '2019-12-01', 4, 4, 1, '-27.90', 0, 5),
(1336, '2019-12-04', 'CAF', NULL, 2, '139.30', 0, 6),
(1361, '2019-12-02', 'Pimkie ', 3, 1, '-39.19', 0, 6),
(1356, '2019-12-01', 'Mozart', 3, 1, '-25.50', 0, 5),
(1357, '2019-12-03', 'Diamantor', NULL, 1, '-85.03', 0, 5),
(1380, '2019-12-09', 'Jules', NULL, 1, '-49.99', 0, 5),
(1342, '2019-11-29', 'Carte grise ', NULL, 1, '-185.76', 0, 6),
(1354, '2019-12-01', 'Maxime', NULL, 2, '57.00', 0, 5),
(1343, '2019-11-25', 'Remboursement ', NULL, 2, '20.98', 0, 6),
(1350, '2019-11-28', 'Salaire', NULL, 2, '1297.12', 0, 6),
(1365, '2019-12-02', 'Cultura', 4, 1, '-49.90', 0, 6),
(1366, '2019-12-02', 'Monoprix ', 1, 1, '-5.19', 0, 6),
(1367, '2019-12-03', 'Épargne ', NULL, 2, '-250.00', 0, 6),
(1368, '2019-12-04', 'Péage ', 2, 1, '-2.50', 0, 5),
(1369, '2019-12-03', 'Mac do', 3, 1, '-12.10', 0, 6),
(1370, '2019-12-03', 'Autoroute ', NULL, 1, '-2.50', 0, 6),
(1371, '2019-12-03', 'Boulangerie ', 1, 1, '-4.15', 0, 6),
(1372, '2019-12-03', 'Leclerc ', 1, 1, '-117.88', 0, 6),
(1373, '2019-12-03', 'Autoroute ', NULL, 1, '-7.20', 0, 6),
(1374, '2019-12-04', 'Essence ', 2, 1, '-66.84', 0, 6),
(1375, '2019-12-04', 'Maxi bazar ', NULL, 1, '-21.16', 0, 6),
(1376, '2019-12-05', 'Remboursement ', NULL, 2, '30.96', 0, 6),
(1377, '2019-12-09', 'Kiko', 4, 1, '-28.96', 0, 6),
(1378, '2019-12-06', 'Gifi', 4, 1, '-19.90', 0, 6),
(1379, '2019-12-06', 'Gifi', NULL, 1, '-9.80', 0, 6),
(1381, '2019-12-09', 'Primark', NULL, 1, '-51.10', 0, 5),
(1382, '2019-12-09', 'Péage ', 2, 1, '-6.90', 0, 5),
(1384, '2019-12-13', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1385, '2019-12-13', 'Depuis livret', NULL, 2, '450.00', 0, 5),
(1388, '2019-12-11', 'Cadeau Stan ', NULL, 1, '-340.00', 0, 6),
(1389, '2019-12-12', 'Fruits as ', NULL, 1, '-19.50', 0, 6),
(1390, '2019-12-12', 'Resto ', NULL, 1, '-42.50', 0, 6),
(1391, '2019-12-13', 'Cadeau élodie ', NULL, 1, '-25.00', 0, 6),
(1392, '2019-12-18', 'Espèce ', NULL, 3, '250.00', 0, 5),
(1393, '2019-12-17', 'Retrait ', 3, 3, '-50.00', 0, 5),
(1394, '2019-12-19', 'Parking', 2, 1, '-7.60', 0, 5),
(1395, '2019-12-16', 'Jennyfer', NULL, 1, '-19.99', 0, 6),
(1396, '2019-12-17', 'Leclerc ', 1, 1, '-82.59', 0, 6),
(1397, '2019-12-18', 'Casino St Jacques ', 1, 1, '-12.38', 0, 6),
(1398, '2019-12-23', 'Pharmacie ', NULL, 1, '-2.18', 0, 6),
(1399, '2019-12-23', 'Devred ', NULL, 1, '-50.00', 0, 6),
(1400, '2019-12-24', 'Marché de noël Monaco ', NULL, 1, '-14.30', 0, 6),
(1401, '2019-12-24', 'Mac do', 3, 1, '-23.90', 0, 6),
(1402, '2019-12-24', 'Leclerc ', 1, 1, '-54.30', 0, 6),
(1403, '2019-12-24', 'Jennyfer', NULL, 1, '-50.00', 0, 6),
(1404, '2020-01-01', 'Kiabi', NULL, 1, '-30.00', 0, 5),
(1405, '2020-01-01', 'Leclerc ', 2, 1, '-10.00', 0, 5),
(1406, '2019-12-26', 'Maison du monde ', NULL, 1, '-15.00', 0, 6),
(1407, '2019-12-26', 'Jules ', NULL, 1, '-9.99', 0, 6),
(1408, '2019-12-26', 'Leclerc ', 1, 1, '-53.03', 0, 6),
(1409, '2019-12-27', 'Chaussea ', NULL, 1, '-7.99', 0, 6),
(1410, '2019-12-29', 'Salaire', NULL, 2, '1311.66', 0, 6),
(1411, '2019-12-30', 'Épargne ', NULL, 2, '-300.00', 0, 6),
(1412, '2020-01-01', 'Loyer', NULL, 2, '-700.00', 0, 5),
(1413, '2019-12-31', 'Salaire', NULL, 2, '1896.67', 0, 5),
(1414, '2020-01-05', 'Assurance habitation', NULL, 5, '-19.32', 0, 5),
(1415, '2020-01-17', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(1416, '2020-01-17', 'Taxe d\'habitation', NULL, 5, '-82.00', 0, 5),
(1417, '2020-01-03', 'Netflix', NULL, 1, '-11.99', 0, 5),
(1418, '2020-01-14', 'Suez', NULL, 5, '-36.00', 0, 5),
(1419, '2020-01-19', 'EDF', NULL, 5, '-88.50', 0, 5),
(1420, '2020-01-05', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(1421, '2020-01-05', 'cbp', NULL, 5, '-24.27', 0, 5),
(1422, '2020-01-03', 'Prêt crédit mutuel', NULL, 5, '-221.82', 0, 5),
(1423, '2020-01-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(1424, '2020-01-05', 'Pno BV', NULL, 5, '-17.32', 0, 5),
(1425, '2020-01-21', 'Loyer', NULL, 2, '542.76', 0, 5),
(1426, '2020-01-25', 'Fitlane', NULL, 5, '-49.00', 0, 5),
(1428, '2020-01-03', 'Spar ', 4, 1, '-31.90', 0, 5),
(1429, '2020-01-07', 'L\'artabac', 4, 1, '-27.90', 0, 5),
(1430, '2020-01-09', 'Le 33', 3, 1, '-15.50', 0, 5),
(1438, '2020-01-02', 'Burger King ', 3, 1, '-19.85', 0, 6),
(1432, '2020-01-06', 'CAF', NULL, 2, '139.30', 0, 6),
(1463, '2020-01-15', 'Vers livret ', NULL, 2, '-2000.00', 0, 5),
(1434, '2020-01-03', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1435, '2020-01-03', 'My little box', NULL, 5, '-17.90', 0, 6),
(1462, '2020-01-14', 'Impôts', NULL, 2, '2016.00', 0, 5),
(1437, '2019-12-31', 'itunes', NULL, 5, '-12.99', 0, 6),
(1439, '2019-12-31', 'Diamantor ', NULL, 1, '-29.95', 0, 6),
(1440, '2019-12-30', 'Leclerc ', 1, 1, '-80.87', 0, 6),
(1441, '2020-01-05', 'Maxime', 4, 2, '-30.00', 0, 5),
(1442, '2020-01-06', 'Remboursement ', NULL, 2, '19.50', 0, 6),
(1443, '2020-01-06', 'Atelier d\'Amaya', 3, 1, '-50.00', 0, 6),
(1444, '2020-01-06', 'Essence ', 2, 1, '-69.64', 0, 6),
(1445, '2020-01-06', 'Boulangerie ', 3, 1, '-4.70', 0, 6),
(1446, '2020-01-06', 'Leclerc ', 1, 1, '-101.88', 0, 6),
(1447, '2020-01-06', 'Duplex ', 3, 1, '-31.10', 0, 6),
(1448, '2020-01-08', 'Veterinaire ', NULL, 1, '-77.60', 0, 5),
(1449, '2020-01-09', 'Buffalo', 3, 1, '-54.20', 0, 5),
(1450, '2020-01-08', 'Pharmacie', NULL, 1, '-17.31', 0, 5),
(1451, '2020-01-08', 'Don', NULL, 5, '-5.00', 0, 5),
(1452, '2020-01-09', 'Parking ', 2, 1, '-6.00', 0, 5),
(1453, '2020-01-13', 4, 4, 1, '-191.15', 0, 5),
(1454, '2020-01-13', 'Mozart et la pizza ', 3, 1, '-24.00', 0, 5),
(1455, '2020-01-13', 'Depuis livret', NULL, 2, '1200.00', 0, 5),
(1456, '2020-01-08', 'Infirmière ', NULL, 4, '-21.92', 0, 6),
(1457, '2020-01-13', 'Vers livret ', NULL, 2, '-1000.00', 0, 5),
(1458, '2020-01-09', 'Pin up secret', 3, 1, '-37.74', 0, 6),
(1459, '2020-01-13', 'Mac do', 3, 1, '-23.70', 0, 6),
(1460, '2020-01-13', 'Leclerc ', 1, 1, '-119.72', 0, 6),
(1461, '2020-01-13', 'Danse', NULL, 4, '-100.00', 0, 6),
(1464, '2020-01-17', 'Taxe foncière ', NULL, 5, '-34.00', 0, 5),
(1465, '2020-01-17', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1466, '2020-01-19', 'Veterinaire ', NULL, 1, '-163.40', 0, 5),
(1467, '2020-01-18', 'Depuis livret', NULL, 2, '234.89', 0, 5),
(1468, '2020-01-19', 'Gifi', NULL, 1, '-75.84', 0, 5),
(1469, '2020-01-17', 'Mac do', 3, 1, '-3.00', 0, 6),
(1470, '2020-01-20', 'Leclerc ', 1, 1, '-116.86', 0, 6),
(1471, '2020-01-14', 'Frais banques ', NULL, 1, '-3.05', 0, 6),
(1472, '2020-01-21', 'Depuis livret', NULL, 2, '1000.00', 0, 5),
(1473, '2020-02-01', 'Mobbistox', NULL, 1, '-939.93', 0, 5),
(1474, '2020-02-01', 'Pharmacie', NULL, 1, '-12.52', 0, 5),
(1475, '2020-02-02', 'Loyer', NULL, 2, '-700.00', 0, 5),
(1476, '2020-01-31', 'Salaire', NULL, 2, '2018.41', 0, 5),
(1477, '2020-02-04', 'Assurance habitation', NULL, 5, '-19.31', 0, 5),
(1478, '2020-02-17', 'Taxe foncière ', NULL, 5, '-34.00', 0, 5),
(1479, '2020-02-11', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1480, '2020-02-16', 'Bouygues Telecom', NULL, 5, '-39.90', 0, 5),
(1481, '2020-02-04', 'Pno BV', NULL, 5, '-11.42', 0, 5),
(1482, '2020-02-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(1483, '2020-02-05', 'Prêt crédit mutuel', NULL, 5, '-249.08', 0, 5),
(1484, '2020-02-04', 'cbp', NULL, 5, '-24.27', 0, 5),
(1485, '2020-02-04', 'Yamaha assurance', NULL, 5, '-51.60', 0, 5),
(1486, '2020-02-19', 'EDF', NULL, 5, '-88.50', 0, 5),
(1487, '2020-02-16', 'Suez', NULL, 5, '-36.00', 0, 5),
(1488, '2020-02-03', 'Netflix', NULL, 1, '-11.99', 0, 5),
(1489, '2020-02-17', 'Taxe d\'habitation', NULL, 5, '-82.00', 0, 5),
(1490, '2020-02-22', 'Loyer', NULL, 2, '378.33', 0, 5),
(1491, '2020-02-06', 'Fitlane', NULL, 5, '-34.95', 0, 5),
(1492, '2020-02-01', 'Lidl', NULL, 1, '-44.99', 0, 5),
(1493, '2020-02-01', 'Vétérinaire ', NULL, 1, '-180.30', 0, 5),
(1494, '2020-02-01', 'Bp', NULL, 1, '-20.03', 0, 5),
(1495, '2020-02-01', 'Laverie', NULL, 1, '-12.00', 0, 5),
(1496, '2020-02-01', 'Leclerc ', 3, 1, '-8.32', 0, 5),
(1497, '2020-02-01', 'Pharmacie', NULL, 1, '-3.95', 0, 5),
(1498, '2020-02-01', 'Vétérinaire ', NULL, 1, '-589.00', 0, 5),
(1499, '2020-01-27', 'KFC ', 3, 1, '-15.90', 0, 6),
(1500, '2020-01-27', 'Leclerc ', 1, 1, '-104.64', 0, 6),
(1501, '2020-01-27', 'Pharmacie ', NULL, 1, '-23.91', 0, 6),
(1502, '2020-01-27', 'Mac do', 3, 1, '-4.10', 0, 6),
(1503, '2020-01-27', 'Salaire', NULL, 2, '1295.78', 0, 6),
(1518, '2020-01-27', 'Épargne ', NULL, 2, '-300.00', 0, 6),
(1505, '2020-02-05', 'CAF', NULL, 2, '137.48', 0, 6),
(1555, '2020-02-12', 'Pharmacie', NULL, 1, '-17.77', 0, 5),
(1507, '2020-02-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1508, '2020-02-06', 'My little box', NULL, 5, '-17.90', 0, 6),
(1509, '2020-02-06', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(1510, '2020-01-30', 'itunes', NULL, 5, '-12.99', 0, 6),
(1512, '2020-03-05', 'CAF', NULL, 2, '137.48', 0, 6),
(1513, '2020-03-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(1514, '2020-03-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1625, '2020-03-02', 'Leclerc ', 1, 1, '-103.53', 0, 6),
(1516, '2020-03-10', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(1517, '2020-03-02', 'itunes', NULL, 5, '-12.99', 0, 6),
(1519, '2020-02-01', 'Vétérinaire', NULL, 1, '-506.00', 0, 5),
(1520, '2020-01-31', 'Scp', NULL, 2, '387.01', 0, 5),
(1521, '2020-02-01', 'Pharmacie', NULL, 1, '-5.54', 0, 5),
(1522, '2020-01-28', 'Carrefour ', 1, 1, '-15.32', 0, 6),
(1523, '2020-02-01', 'Vétérinaire ', NULL, 1, '-10.40', 0, 5),
(1524, '2020-02-11', 'Dora ', NULL, 1, '-1207.20', 0, 5),
(1525, '2020-01-30', 'Mac do', 3, 1, '-5.70', 0, 6),
(1526, '2020-01-31', 'Leclerc ', 1, 1, '-27.20', 0, 6),
(1527, '2020-02-02', 'Pour cuisine', NULL, 2, '2031.00', 0, 5),
(1528, '2020-02-06', 'ixina', NULL, 4, '-2030.00', 0, 5),
(1529, '2020-02-03', 'Stan', NULL, 2, '-400.00', 0, 6),
(1530, '2020-02-03', 'Gwen', NULL, 2, '800.00', 0, 5),
(1531, '2020-04-20', 'ixina', NULL, 4, '-3970.00', 0, 5),
(1532, '2020-02-03', 'Café ', 3, 1, '-7.00', 0, 6),
(1533, '2020-02-03', 'Leclerc ', 1, 1, '-86.69', 0, 6),
(1534, '2020-02-03', 'Pizza ', 1, 1, '-32.00', 0, 6),
(1535, '2020-02-03', 'Burger King ', 3, 1, '-16.80', 0, 6),
(1536, '2020-02-03', 'Remboursement ', NULL, 2, '7.50', 0, 6),
(1537, '2020-02-10', 'Depuis livret', NULL, 2, '1500.00', 0, 5),
(1538, '2020-02-06', 'Spar', 4, 1, '-30.40', 0, 5),
(1539, '2020-02-06', 'carrefour contact', 2, 1, '-4.31', 0, 5),
(1540, '2020-02-04', 'Amazon ', NULL, 1, '-18.99', 0, 6),
(1541, '2020-02-05', 'Pharmacie ', NULL, 1, '-8.67', 0, 6),
(1542, '2020-02-06', 'Leclerc ', 1, 1, '-15.50', 0, 6),
(1543, '2020-02-07', 'Mac do', 3, 1, '-21.20', 0, 6),
(1544, '2020-02-10', 4, 4, 1, '-171.69', 0, 5),
(1545, '2020-02-11', 'Ikea', 3, 1, '-28.35', 0, 5),
(1546, '2020-02-10', 'L\'artabac', 4, 1, '-18.60', 0, 5),
(1547, '2020-02-10', 'Pizza ', 3, 1, '-35.50', 0, 6),
(1549, '2020-02-10', 'Leclerc ', 1, 1, '-94.82', 0, 6),
(1550, '2020-02-10', 'Euro drink ', 1, 1, '-22.25', 0, 6),
(1551, '2020-02-11', 'Leclerc', 4, 1, '-9.16', 0, 5),
(1552, '2020-02-11', 'Carrefour ', 4, 1, '-4.31', 0, 5),
(1553, '2020-02-12', 'Mac do', 3, 1, '-6.70', 0, 6),
(1554, '2020-02-12', 'Ikea', 3, 1, '-95.92', 0, 6),
(1606, '2020-02-28', 'Vers livret', NULL, 2, '-1000.00', 0, 5),
(1556, '2020-02-17', 'Leclerc', 2, 1, '-6.00', 0, 5),
(1557, '2020-02-17', 'Leclerc', 3, 1, '-31.45', 0, 5),
(1558, '2020-02-17', 'Histoire d\'or ', NULL, 1, '-59.00', 0, 5),
(1559, '2020-02-13', 'Pret', NULL, 5, '1925.00', 0, 5),
(1560, '2020-02-13', 'Vers livret ', NULL, 2, '-1531.00', 0, 5),
(1561, '2020-02-14', 'Casino St Jacques ', 1, 1, '-13.34', 0, 6),
(1562, '2020-02-14', 'Leclerc ', 2, 1, '-60.07', 0, 6),
(1563, '2020-02-15', 'Leclerc ', 1, 1, '-73.82', 0, 6),
(1565, '2020-02-18', 'La foire fouille', NULL, 3, '-30.00', 0, 5),
(1566, '2020-02-19', 'Briconautes', NULL, 1, '-17.77', 0, 5),
(1567, '2020-02-19', 'Leclerc', NULL, 1, '-17.92', 0, 5),
(1568, '2020-02-19', 'Carrefour ', 2, 1, '-29.59', 0, 5),
(1569, '2020-03-01', 'Briconautes', NULL, 1, '-4.60', 0, 5),
(1570, '2020-02-22', 'Leclerc', NULL, 1, '-84.34', 0, 5),
(1571, '2020-02-19', 'Laverie', NULL, 1, '-16.00', 0, 5),
(1572, '2020-02-22', 'Maxime', 4, 2, '-40.00', 0, 5),
(1573, '2020-02-22', 'Maxime', 4, 2, '-59.00', 0, 5),
(1574, '2020-03-01', 'Mozart et la pizza', 3, 1, '-14.50', 0, 5),
(1575, '2020-03-01', 'Le centifolia', NULL, 1, '-25.50', 0, 5),
(1576, '2020-03-01', 'Laverie', NULL, 1, '-11.00', 0, 5),
(1577, '2020-04-10', 'Poseur', NULL, 3, '-200.00', 0, 5),
(1578, '2020-03-01', 'Carrefour ', 2, 1, '-15.00', 0, 5),
(1579, '2020-02-27', 'Salaire', NULL, 2, '2018.41', 0, 5),
(1580, '2020-03-09', 'Assurance habitation', NULL, 5, '-38.12', 0, 5),
(1581, '2020-03-17', 'Taxe foncière ', NULL, 5, '-34.00', 0, 5),
(1582, '2020-03-12', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1583, '2020-03-06', 'Free', NULL, 5, '-63.99', 0, 5),
(1584, '2020-03-17', 'Taxe d\'habitation', NULL, 5, '-82.00', 0, 5),
(1585, '2020-03-01', 'Netflix', NULL, 1, '-11.99', 0, 5),
(1651, '2020-03-23', 'Casino St Jacques ', 1, 1, '-54.17', 0, 6),
(1636, '2020-03-10', 'Leclerc ', 1, 1, '-106.27', 0, 6),
(1588, '2020-03-04', 'Yamaha assurance', NULL, 5, '-46.20', 0, 5),
(1589, '2020-03-04', 'cbp', NULL, 5, '-24.27', 0, 5),
(1590, '2020-03-05', 'Prêt crédit mutuel', NULL, 5, '-263.06', 0, 5),
(1591, '2020-03-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(1592, '2020-03-05', 'Pno BV', NULL, 5, '-11.42', 0, 5),
(1593, '2020-03-23', 'Loyer', NULL, 2, '400.00', 0, 5),
(1594, '2020-03-08', 'Fitlane', NULL, 5, '-34.95', 0, 5),
(1595, '2020-03-05', 'Ptz', NULL, 5, '-5.11', 0, 5),
(1596, '2020-03-08', 'EDF', NULL, 5, '-150.11', 0, 5),
(1597, '2020-03-04', 'EDF', NULL, 5, '-35.07', 0, 5),
(1598, '2020-02-24', 'Mac do', 3, 1, '-24.70', 0, 6),
(1599, '2020-03-01', 'La poste', NULL, 1, '-33.50', 0, 5),
(1600, '2020-02-27', 'Prime', NULL, 2, '500.00', 0, 5),
(1601, '2020-02-26', 'Salaire', NULL, 2, '1295.78', 0, 6),
(1609, '2020-02-29', 'Agence', NULL, 4, '-445.90', 0, 6),
(1605, '2020-02-27', 'Bouygues Télécom', NULL, 2, '49.00', 0, 5),
(1604, '2020-02-24', 'Épargne ', NULL, 2, '-400.00', 0, 6),
(1607, '2020-02-25', 'Leclerc ', 1, 1, '-92.48', 0, 6),
(1627, '2020-03-06', 'Briconautes', NULL, 1, '-49.99', 0, 5),
(1612, '2020-03-02', 'Laverie', NULL, 1, '-14.00', 0, 5),
(1613, '2020-03-01', 'Castorama', NULL, 1, '-636.83', 0, 5),
(1614, '2020-03-01', 'Mc donald\'s', 3, 1, '-30.10', 0, 5),
(1615, '2020-03-01', 'Mozart et la pizza', 3, 1, '-22.00', 0, 5),
(1616, '2020-03-01', 'Gifi', NULL, 1, '-19.00', 0, 5),
(1681, '2020-04-03', 'Leclerc ', 1, 1, '-132.14', 0, 6),
(1617, '2020-03-01', 'Livré ', NULL, 2, '300.00', 0, 6),
(1618, '2020-03-04', 'Azurvet', NULL, 1, '-140.00', 0, 5),
(1619, '2020-03-02', 'Vétérinaire', NULL, 1, '-30.80', 0, 5),
(1626, '2020-03-02', 'Gifi ', NULL, 1, '-57.17', 0, 6),
(1621, '2020-03-06', 'Plombier', NULL, 3, '-250.00', 0, 5),
(1624, '2020-03-02', 'Essence ', 2, 1, '-50.00', 0, 6),
(1623, '2020-03-01', 'Laverie', NULL, 1, '-16.00', 0, 5),
(1628, '2020-03-05', 'Leclerc ', 1, 1, '-24.95', 0, 6),
(1629, '2020-03-06', 'Suez', NULL, 2, '4.74', 0, 5),
(1630, '2020-03-03', 'Amazon ', NULL, 1, '-79.98', 0, 6),
(1631, '2020-03-03', 'My little box', NULL, 5, '-17.90', 0, 6),
(1632, '2020-03-08', 4, 4, 1, '-100.00', 0, 5),
(1633, '2020-03-11', 'Briconautes', NULL, 1, '-129.00', 0, 5),
(1634, '2020-03-07', 'Depuis livret', NULL, 2, '1200.00', 0, 5),
(1635, '2020-03-08', 'Coiffeur ', NULL, 1, '-36.00', 0, 5),
(1637, '2020-03-10', 'Pro coiffure ', 3, 1, '-3.80', 0, 6),
(1638, '2020-03-10', 'Devred ', NULL, 1, '-20.00', 0, 6),
(1639, '2020-03-09', 'Café ', 3, 1, '-3.20', 0, 6),
(1640, '2020-03-11', 'Bouygues Télécom', NULL, 2, '24.77', 0, 5),
(1641, '2020-03-12', 'Vétérinaire', NULL, 1, '-186.00', 0, 5),
(1642, '2020-03-12', 'Leclerc', 3, 1, '-26.29', 0, 5),
(1643, '2020-03-18', 'Gifi', NULL, 1, '-37.28', 0, 5),
(1644, '2020-03-17', 'Intermarche', 2, 1, '-52.79', 0, 6),
(1645, '2020-03-18', 'Spar', 4, 1, '-500.00', 0, 5),
(1646, '2020-03-18', 'Antargaz', NULL, 1, '-18.55', 0, 5),
(1647, '2020-03-18', 'Leclerc ', 1, 1, '-57.42', 0, 6),
(1648, '2020-03-18', 'Edf', NULL, 5, '-4.79', 0, 5),
(1649, '2020-03-18', 'Depuis livret', NULL, 2, '500.00', 0, 5),
(1650, '2020-03-18', 'Rockstar', NULL, 1, '-19.48', 0, 5),
(1652, '2020-03-27', 'Salaire', NULL, 2, '1295.78', 0, 6),
(1653, '2020-04-01', 'CAF', NULL, 2, '137.48', 0, 6),
(1654, '2020-04-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(1655, '2020-04-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1656, '2020-04-15', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(1657, '2020-03-31', 'itunes', NULL, 5, '-12.99', 0, 6),
(1658, '2020-03-26', 'Leclerc ', 1, 1, '-198.16', 0, 6),
(1659, '2020-03-26', 'Arrêt ', NULL, 1, '7.50', 0, 6),
(1660, '2020-03-28', 'Épargne ', NULL, 2, '-250.00', 0, 6),
(1661, '2020-03-30', 'Salaire', NULL, 2, '2018.41', 0, 5),
(1662, '2020-04-13', 'Assurance habitation', NULL, 5, '-28.42', 0, 5),
(1663, '2020-04-03', 'Ptz', NULL, 5, '-5.11', 0, 5),
(1664, '2020-04-15', 'Taxe foncière ', NULL, 5, '-34.00', 0, 5),
(1665, '2020-04-17', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1666, '2020-04-05', 'Free', NULL, 5, '-14.99', 0, 5),
(1667, '2020-04-06', 'Pno BV', NULL, 5, '-11.42', 0, 5),
(1668, '2020-04-13', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(1669, '2020-04-15', 'Prêt crédit mutuel', NULL, 5, '-269.63', 0, 5),
(1670, '2020-04-05', 'cbp', NULL, 5, '-24.27', 0, 5),
(1671, '2020-04-05', 'Yamaha assurance', NULL, 5, '-46.20', 0, 5),
(1672, '2020-04-15', 'EDF', NULL, 5, '-100.00', 0, 5),
(1693, '2020-04-20', 'Pépinière ', 3, 1, '-77.90', 0, 6),
(1674, '2020-04-02', 'Netflix', NULL, 1, '-11.99', 0, 5),
(1675, '2020-04-15', 'Taxe d\'habitation', NULL, 5, '-82.00', 0, 5),
(1676, '2020-04-22', 'Loyer', NULL, 2, '400.00', 0, 5),
(1677, '2020-04-05', 'Fitlane', NULL, 5, '-34.95', 0, 5),
(1678, '2020-04-01', 'Nespresso', NULL, 1, '-36.00', 0, 5),
(1680, '2020-04-15', 'Charges', NULL, 5, '-356.81', 0, 5),
(1682, '2020-04-07', 'Canal', NULL, 1, '-20.90', 0, 5),
(1683, '2020-04-09', 'Depuis livret', NULL, 2, '4000.00', 0, 5),
(1684, '2020-04-10', 'Leclerc ', 1, 1, '-152.94', 0, 6),
(1685, '2020-04-11', 'Basika', NULL, 1, '-309.00', 0, 6),
(1686, '2020-04-13', 'À koi ta pizza ', 3, 1, '-22.00', 0, 6),
(1687, '2020-04-10', 'Pharmacie', NULL, 1, '-5.18', 0, 5),
(1688, '2020-04-18', 'Leclerc', 3, 1, '-197.87', 0, 5),
(1689, '2020-04-18', 'Castorama', 4, 1, '-257.80', 0, 5),
(1729, '2020-05-01', 'Nespresso', NULL, 1, '-40.50', 0, 5),
(1690, '2020-04-15', 'Messaoud ', 1, 1, '-32.83', 0, 6),
(1691, '2020-04-18', 'Canal', NULL, 1, '-8.77', 0, 5),
(1692, '2020-05-01', 'Nhp', NULL, 1, '-16.93', 0, 5),
(1694, '2020-05-01', 'Avosdim', NULL, 1, '-224.60', 0, 5),
(1695, '2020-05-01', 4, 4, 1, '-100.00', 0, 5),
(1733, '2020-05-03', 'Mr bricolage', 3, 1, '-32.10', 0, 5),
(1697, '2020-04-29', 'Salaire', NULL, 2, '2286.95', 0, 5),
(1698, '2020-05-10', 'Assurance habitation', NULL, 5, '-28.42', 0, 5),
(1699, '2020-05-05', 'Ptz', NULL, 5, '-5.11', 0, 5),
(1700, '2020-05-06', 'Canal', NULL, 1, '-20.90', 0, 5),
(1701, '2020-05-18', 'Taxe foncière ', NULL, 5, '-34.00', 0, 5),
(1702, '2020-05-13', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1703, '2020-05-06', 'Free', NULL, 5, '-14.99', 0, 5),
(1704, '2020-05-05', 'Pno BV', NULL, 5, '-11.42', 0, 5),
(1705, '2020-05-10', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(1764, '2020-05-25', 'Messaoud ', 1, 1, '-5.50', 0, 6),
(1707, '2020-05-04', 'cbp', NULL, 5, '-24.27', 0, 5),
(1708, '2020-05-04', 'Yamaha assurance', NULL, 5, '-46.20', 0, 5),
(1709, '2020-05-15', 'EDF', NULL, 5, '-100.00', 0, 5),
(1710, '2020-05-03', 'Netflix', NULL, 1, '-11.99', 0, 5),
(1711, '2020-05-15', 'Taxe d\'habitation', NULL, 5, '-82.00', 0, 5),
(1712, '2020-05-22', 'Loyer', NULL, 2, '400.00', 0, 5),
(1713, '2020-05-10', 'Fitlane', NULL, 5, '-29.95', 0, 5),
(1714, '2020-05-01', 'Le centifolia', 3, 1, '-13.00', 0, 5),
(1715, '2020-04-27', 'Pépinière ', 3, 1, '-64.15', 0, 6),
(1716, '2020-04-27', 'Leclerc ', 1, 1, '-125.05', 0, 6),
(1717, '2020-04-28', 'Virement gwen', NULL, 2, '100.00', 0, 6),
(1718, '2020-04-28', 'Vétérinaire ', NULL, 1, '-90.00', 0, 6),
(1719, '2020-04-28', 'Messaoud ', 1, 1, '-37.49', 0, 6),
(1720, '2020-04-28', 'Nicky', 1, 1, '-72.30', 0, 6),
(1721, '2020-04-29', 'Salaire', NULL, 2, '1185.40', 0, 6),
(1728, '2020-04-29', 'Épargne ', NULL, 2, '-200.00', 0, 6),
(1723, '2020-05-05', 'CAF', NULL, 2, '140.07', 0, 6),
(1724, '2020-05-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(1725, '2020-05-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1726, '2020-05-14', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(1727, '2020-05-04', 'itunes', NULL, 5, '-12.99', 0, 6),
(1730, '2020-05-01', 'Lidl', 2, 1, '-55.96', 0, 5),
(1731, '2020-05-01', 'Pépinière', NULL, 1, '-140.75', 0, 5),
(1732, '2020-05-03', 'Tabac 4 chemins', 4, 1, '-100.00', 0, 5),
(1734, '2020-05-06', 'Le centifolia', 3, 1, '-13.50', 0, 5),
(1735, '2020-05-02', 'Sofiane', NULL, 3, '-20.00', 0, 5),
(1736, '2020-05-04', 'Amazon', NULL, 1, '-59.00', 0, 5),
(1737, '2020-05-04', 'Amazon', NULL, 1, '-99.99', 0, 5),
(1738, '2020-05-04', 'Pépinière ', 3, 1, '-35.85', 0, 6),
(1739, '2020-05-05', 'Leclerc ', 1, 1, '-54.39', 0, 6),
(1740, '2020-05-05', 'Lidl ', 1, 1, '-72.57', 0, 6),
(1741, '2020-05-05', 'Botanic', NULL, 1, '-72.72', 0, 6),
(1742, '2020-05-13', 'Spar', 4, 1, '-100.00', 0, 5),
(1743, '2020-05-15', 'KFC', 3, 1, '-32.90', 0, 5),
(1744, '2020-05-18', 'Amazon', NULL, 1, '-121.74', 0, 5),
(1745, '2020-05-15', 'Gifi', 3, 1, '-12.89', 0, 6),
(1746, '2020-05-14', 'Kiabi ', 3, 1, '-16.00', 0, 6),
(1747, '2020-05-14', 'Leclerc ', 1, 1, '-86.96', 0, 6),
(1748, '2020-05-14', 'Pin up secret', 3, 1, '-37.74', 0, 6),
(1749, '2020-05-14', 'Aurelie création ', 3, 1, '-23.50', 0, 6),
(1750, '2020-05-11', 'Leclerc ', 1, 1, '-90.22', 0, 6),
(1751, '2020-05-18', 'Maison du monde ', 3, 1, '-44.93', 0, 6),
(1752, '2020-05-18', 'Leclerc ', 1, 1, '-91.35', 0, 6),
(1753, '2020-05-18', 'Virement ', NULL, 2, '150.00', 0, 6),
(1754, '2020-05-18', 'Bp', 2, 1, '-8.00', 0, 5),
(1755, '2020-05-20', 'Leclerc ', 1, 1, '-86.93', 0, 6),
(1756, '2020-05-20', 4, 4, 1, '-100.00', 0, 5),
(1757, '2020-05-20', 'Briconautes', NULL, 1, '-11.90', 0, 5),
(1758, '2020-06-01', 'Pharmacie', NULL, 1, '-9.74', 0, 5),
(1759, '2020-06-01', 'Coiffeur', NULL, 1, '-22.00', 0, 5),
(1760, '2020-06-01', 'Médecin', NULL, 1, '-7.50', 0, 5),
(1761, '2020-05-22', 'Bolas ', NULL, 1, '-25.50', 0, 6),
(1803, '2020-05-28', 'Langignier ', NULL, 1, '-7.50', 0, 6),
(1762, '2020-06-01', 'Castorama', NULL, 1, '-111.20', 0, 5),
(1763, '2020-05-25', 'Bébé', NULL, 2, '350.00', 0, 5),
(1765, '2020-05-25', 'Leclerc ', 1, 1, '-71.47', 0, 6),
(1766, '2020-05-25', 'Pépinière ', 3, 1, '-13.55', 0, 6),
(1767, '2020-05-25', 'Scanner ', NULL, 1, '-60.00', 0, 6),
(1768, '2020-05-25', 'Centreakor ', NULL, 1, '-57.98', 0, 6),
(1769, '2020-05-18', 'Pro coiffure ', NULL, 1, '-11.00', 0, 6),
(1770, '2020-05-22', 'McDonald\'s ', NULL, 1, '-10.40', 0, 6),
(1771, '2020-05-25', 'Cils', NULL, 3, '-50.00', 0, 6),
(1772, '2020-05-29', 'Frais banques ', NULL, 5, '-4.00', 0, 6),
(1800, '2020-05-27', 'Épargne ', NULL, 2, '-250.00', 0, 6),
(1774, '2020-06-05', 'CAF', NULL, 2, '140.07', 0, 6),
(1775, '2020-06-05', 'Axa', NULL, 5, '-60.93', 0, 6),
(1776, '2020-06-05', 'Prêt echéancier', NULL, 5, '-65.40', 0, 6),
(1777, '2020-06-11', 'Cotisation', NULL, 5, '-3.05', 0, 6),
(1778, '2020-06-01', 'itunes', NULL, 5, '-12.99', 0, 6),
(1779, '2020-06-01', 'Décathlon', NULL, 1, '-60.00', 0, 5),
(1780, '2020-06-01', 'Leclerc', 2, 1, '-6.00', 0, 5),
(1781, '2020-05-25', 'Prêt crédit mutuel ', NULL, 5, '-269.63', 0, 5),
(1782, '2020-06-01', 'Salaire', NULL, 2, '2645.15', 0, 5),
(1783, '2020-06-09', 'Assurance habitation', NULL, 5, '-28.42', 0, 5),
(1784, '2020-06-05', 'Ptz', NULL, 5, '-5.11', 0, 5),
(1785, '2020-06-10', 'Canal', NULL, 1, '-20.90', 0, 5),
(1786, '2020-06-12', 'Taxe foncière ', NULL, 5, '-34.00', 0, 5),
(1787, '2020-06-09', 'Cotisation ', NULL, 5, '-18.67', 0, 5),
(1788, '2020-06-04', 'Free', NULL, 5, '-14.99', 0, 5),
(1789, '2020-06-05', 'Pno BV', NULL, 5, '-11.42', 0, 5),
(1790, '2020-06-09', 'Prêt crédit foncier ', NULL, 5, '-769.23', 0, 5),
(1791, '2020-06-05', 'Prêt crédit mutuel', NULL, 5, '-269.63', 0, 5),
(1792, '2020-06-04', 'cbp', NULL, 5, '-24.27', 0, 5),
(1793, '2020-06-04', 'Yamaha assurance', NULL, 5, '-46.20', 0, 5),
(1794, '2020-06-15', 'EDF', NULL, 5, '-100.00', 0, 5),
(1795, '2020-06-01', 'Netflix', NULL, 1, '-11.99', 0, 5);
INSERT INTO `operations` (`id`, `deadline_date`, `name`, `budget_id`, `payment_id`, `amount`, `credit_card_state`, `user_id`) VALUES
(1796, '2020-06-15', 'Taxe d\'habitation', NULL, 5, '-82.00', 0, 5),
(1797, '2020-06-23', 'Loyer', NULL, 2, '540.00', 0, 5),
(1798, '2020-06-25', 'Fitlane', NULL, 5, '-30.00', 0, 5),
(1799, '2020-05-27', 'Salaire', NULL, 2, '1237.23', 0, 6),
(1802, '2020-06-01', 'Spar', 4, 1, '-100.00', 0, 5),
(1804, '2020-06-01', 'Asia', 3, 1, '-34.75', 0, 5),
(1805, '2020-06-01', 'Vente privée ', 3, 1, '-32.49', 0, 6),
(1806, '2020-06-01', 'Leclerc ', 1, 1, '-103.91', 0, 6),
(1807, '2020-06-01', 'Essence ', 2, 1, '-53.88', 0, 6),
(1808, '2020-06-01', 'Gastro ', NULL, 1, '-75.00', 0, 6),
(1809, '2020-06-01', 'Parking', 2, 1, '-3.20', 0, 6),
(1810, '2020-06-01', 'Vers livret', NULL, 2, '-1000.00', 0, 5),
(1811, '2020-06-02', 'Boohoo', NULL, 1, '-50.49', 0, 6),
(1812, '2020-06-02', 'Spar', 4, 1, '-100.00', 0, 5),
(1814, '2020-06-03', 'Lavage voiture ', 2, 1, '-8.00', 0, 6),
(1815, '2020-06-07', 'Blue box', 3, 1, '-39.99', 0, 6),
(1816, '2020-06-07', 'Leclerc ', 1, 1, '-113.29', 0, 6),
(1817, '2020-06-07', 'La foir fouille ', 3, 1, '-30.47', 0, 6),
(1818, '2020-06-07', 'Café ', 3, 1, '-3.40', 0, 6),
(1823, '2020-06-11', 'Presse ', 4, 1, '-100.00', 0, 5),
(1820, '2020-06-08', 'Virement ', NULL, 2, '7.50', 0, 6),
(1821, '2020-06-10', 'Pépinière', NULL, 1, '-20.20', 0, 5),
(1822, '2020-06-08', 'Remboursement ', NULL, 2, '40.00', 0, 6);

--
-- Index pour les tables déchargées
--

--
--