INSERT INTO
  users(email, name, password)
VALUES
  ('john@mail.com', 'John', '$2b$10$Qy8lqrTqHdzwLZwsqvO09eMwehA.vti.AGwPVj/pZYL94Ni6zozT2'),
  ('lisa@mail.com', 'Lisa', '$2b$10$Qy8lqrTqHdzwLZwsqvO09eMwehA.vti.AGwPVj/pZYL94Ni6zozT2');

INSERT INTO
  incomes(user_id, date, amount)
VALUES
  (1, '2020-01-01', 1500),
  (2, '2020-01-01', 2000);

INSERT INTO
  categories(name, color)
VALUES
  ('Habitation', '#aa0000'),
  ('Alimentation', '#00aa00'),
  ('Animaux', '#0000aa');

INSERT INTO
  payments(user_id, name, cost, date, frequency, category_id)
VALUES
  (1, 'Loyer', 600, '2021-01-02', 'Monthly', 1),
  (1, 'Loyer', 600, '2021-01-01', 'Punctual', 1),
  (2, 'Loyer', 600, '2020-02-01', 'Punctual', 1),
  (2, 'Loyer', 600, '2020-03-01', 'Punctual', 1),
  (2, 'Loyer', 600, '2020-04-01', 'Punctual', 1),
  (2, 'Loyer', 600, '2020-05-01', 'Punctual', 1),
  (2, 'Loyer', 600, '2020-06-01', 'Punctual', 1),
  (1, 'Loyer', 600, '2020-07-01', 'Punctual', 1),
  (1, 'Loyer', 600, '2020-08-01', 'Punctual', 1),
  (2, 'Loyer', 600, '2020-09-01', 'Punctual', 1),
  (2, 'Loyer', 600, '2020-10-01', 'Punctual', 1),
  (2, 'Loyer', 600, '2020-11-01', 'Punctual', 1),
  (1, 'Loyer', 600, '2020-12-01', 'Punctual', 1),
  (1, 'Loyer', 600, '2020-01-01', 'Punctual', 1),
  (1, 'Marché', 55, '2021-01-02', 'Punctual', 2),
  (2, 'Restaurant', 60, '2020-12-10', 'Punctual', 2),
  (1, 'Vétérinaire', 105, '2020-11-18', 'Punctual', 3),
  (1, 'Magasin', 150, '2020-10-29', 'Punctual', 2);

INSERT INTO
  jobs(name)
VALUES
  ('MonthlyPayment');
