text: INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (1, 'juanjoalvacampa', 'juanjoalvacampa@alum.us.es', 'juanjo1', '1990-10-01', TRUE);
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (2, 'mangoncac','mangoncac@alum.us.es', 'manu2', '2000-03-12', TRUE);
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (3, 'marinaramirofde','marinaramirofde@alum.us.es', 'marina3','2010-10-21', TRUE);
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (4, 'lausalbra', 'lausalbra@alum.us.es' ,'laura4', '2010-11-21', TRUE);
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (5, 'nicsanmen', 'nicsanmen@alum.us.es' ,'nico5','1995-02-16', TRUE);
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (6, 'rubsuadav', 'rubsuadav@alum.us.es' ,'ruben6','1995-02-16', TRUE);
  
  -- USUARIOS EXTRA PARA COMPROBACIONES DE LAS VISTAS
  
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (7, 'admin1', 'hola@us.es', '4dm1n', '1990-01-01', TRUE);
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (8, 'user1', 'user1@us.es' ,'user1','2009-06-29', TRUE);
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (9, 'user2', 'user2@us.es' ,'user2','1888-08-13', TRUE);
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (10, 'user3', 'user3@us.es' ,'user3','2002-12-31', TRUE);  
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (11, 'user4', 'user4@us.es' ,'user4','2002-12-31', TRUE);  
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (12, 'user5', 'user5@us.es' ,'user5','2002-12-31', TRUE);  
  INSERT INTO users(id, username,email,password,birth_date, enabled) VALUES (13, 'user6', 'user6@us.es' ,'user6','2002-12-31', TRUE);  
  
  -- AUTORIZACIONES
  
  INSERT INTO authorities(id,username, authority) VALUES (1, 'admin1', 'admin');
  INSERT INTO authorities(id,username, authority) VALUES (2, 'juanjoalvacampa', 'admin');
  INSERT INTO authorities(id,username, authority) VALUES (3, 'mangoncac', 'admin');
  INSERT INTO authorities(id,username, authority) VALUES (4, 'marinaramirofde', 'admin');
  INSERT INTO authorities(id,username, authority) VALUES (5, 'lausalbra', 'admin');
  INSERT INTO authorities(id,username, authority) VALUES (6, 'nicsanmen', 'admin');
  INSERT INTO authorities(id,username, authority) VALUES (7, 'rubsuadav', 'admin');
  INSERT INTO authorities(id,username, authority) VALUES (8, 'user1', 'player');
  INSERT INTO authorities(id,username, authority) VALUES (9, 'user2', 'player');
  INSERT INTO authorities(id,username, authority) VALUES (10, 'user3', 'player');
  INSERT INTO authorities(id,username, authority) VALUES (11, 'user4', 'player');
  INSERT INTO authorities(id,username, authority) VALUES (12, 'user5', 'player'); 
  INSERT INTO authorities(id,username, authority) VALUES (13, 'user6', 'player'); 
  
  ------------------------------------------------------ RESTO TABLAS ------------------------------------
  
  INSERT INTO achievements(id,name, description, goal) VALUES (1, 'Play 1 game', 'Obtained for playing one game', 1);
  INSERT INTO achievements(id,name, description, goal) VALUES (2, 'Play 1 card', 'Obtained for playing a card', 1);
  
  INSERT INTO earned_achievements(id, user_id, achievement_id) VALUES (1, 3, 1);
  INSERT INTO earned_achievements(id, user_id, achievement_id) VALUES (2, 3, 2);
  
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (1, 1, 0, '00:00:00', 1);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (2, 2, 0, '00:00:00', 50);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (3, 3, 0, '00:00:00', 43);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (4, 4, 0, '00:00:00', 23);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (5, 5, 0, '00:00:00', 12);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (6, 6, 0, '00:00:00', 0);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (7, 7, 0, '00:00:00', 0);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (8, 8, 0, '00:00:00', 0);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (9, 9, 0, '00:00:00', 0);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (10, 10, 0, '00:00:00', 0);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (11, 11, 0, '00:00:00', 0);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (12, 12, 0, '00:00:00', 0);
  INSERT INTO stadistics(id, user_id, num_games, total_duration, total_score) VALUES (13, 13, 0, '00:00:00', 0);
  
  INSERT INTO game_lobbies(id, creation_time, started) VALUES (1, '02:10:12', false);
  INSERT INTO game_lobbies(id, creation_time, started) VALUES (2, '02:10:12', false);
  
  INSERT INTO ready_users(id, ready, game_lobby_id, user_id) VALUES (1, TRUE, 1, 8);
  INSERT INTO ready_users(id, ready, game_lobby_id, user_id) VALUES (2, TRUE, 1, 9);
  INSERT INTO ready_users(id, ready, game_lobby_id, user_id) VALUES (3, TRUE, 1, 10);
  INSERT INTO ready_users(id, ready, game_lobby_id, user_id) VALUES (5, FALSE, 2, 11);
  INSERT INTO ready_users(id, ready, game_lobby_id, user_id) VALUES (6, FALSE, 2, 12);
  INSERT INTO ready_users(id, ready, game_lobby_id, user_id) VALUES (7, FALSE, 2, 13);
  
  INSERT INTO cards(id, name, cost, type) VALUES (1, 'Templo', 1, 1);
  INSERT INTO cards(id, name, cost, type) VALUES (2, 'Iglesia', 2, 1);
  INSERT INTO cards(id, name, cost, type) VALUES (3, 'Monasterio', 3, 1);
  INSERT INTO cards(id, name, cost, type) VALUES (4, 'Catedral', 5, 1);
  INSERT INTO cards(id, name, cost, type) VALUES (5, 'Castillo', 4, 0);
  INSERT INTO cards(id, name, cost, type) VALUES (6, 'Palacio', 5, 0);
  INSERT INTO cards(id, name, cost, type) VALUES (7, 'Señorío', 3, 0);
  INSERT INTO cards(id, name, cost, type) VALUES (8, 'Mercado', 2, 2);
  INSERT INTO cards(id, name, cost, type) VALUES (9, 'Puerto', 4, 2);
  INSERT INTO cards(id, name, cost, type) VALUES (10, 'Almacenes', 3, 2);
  INSERT INTO cards(id, name, cost, type) VALUES (11, 'Ayuntamiento', 5, 2);
  INSERT INTO cards(id, name, cost, type) VALUES (12, 'Taberna', 1, 2);
  INSERT INTO cards(id, name, cost, type) VALUES (13, 'Tienda', 2, 2);
  INSERT INTO cards(id, name, cost, type) VALUES (14, 'Fortaleza', 5, 3);
  INSERT INTO cards(id, name, cost, type) VALUES (15, 'Cuartel', 3, 3);
  INSERT INTO cards(id, name, cost, type) VALUES (16, 'Atalaya', 1, 3);
  INSERT INTO cards(id, name, cost, type) VALUES (17, 'Prisión', 2, 3);
  INSERT INTO cards(id, name, cost, type) VALUES (18, 'Biblioteca', 6, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (19, 'Cementerio', 5, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (20, 'Escuela de magia', 6, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (21, 'Fábrica', 6, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (22, 'Gran Muralla', 6, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (23, 'Laboratorio', 5, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (24, 'Patio de los milagros', 2, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (25, 'Puerta del Dragón', 6, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (26, 'Sala de mapas', 5, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (27, 'Tesoro imperial', 4, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (28, 'Torreón', 3, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (29, 'Universidad', 6, 4);
  INSERT INTO cards(id, name, cost, type) VALUES (30, 'Observatorio', 4, 4);
  
  INSERT INTO characters VALUES (1, 'Assassin');
  INSERT INTO characters VALUES (2, 'Thief');
  INSERT INTO characters VALUES (3, 'Mage');
  INSERT INTO characters VALUES (4, 'King');
  INSERT INTO characters VALUES (5, 'Bishop');
  INSERT INTO characters VALUES (6, 'Merchant');
  INSERT INTO characters VALUES (7, 'Architect');
  INSERT INTO characters VALUES (8, 'Warlord');
  
  INSERT INTO friendship VALUES (1, 1, 4);
  INSERT INTO friendship VALUES (2, 1, 3);
  INSERT INTO friendship VALUES (3, 1, 5);
  INSERT INTO friendship VALUES (4, 1, 1);
  INSERT INTO friendship VALUES (5, 1, 6);
  INSERT INTO friendship VALUES (6, 1, 2);