text: -- One admin user, named admin1 with passwor 4dm1n and authority admin
  INSERT INTO users(username,password,enabled) VALUES ('admin1','4dm1n',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (1,'admin1','admin');
  -- One owner user, named owner1 with passwor 0wn3r
  
  INSERT INTO users(username,password,enabled) VALUES ('owner1','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (2,'owner1','owner');
  INSERT INTO authorities(id,username,authority) VALUES (3,'owner1','client');
  
  INSERT INTO users(username,password,enabled) VALUES ('owner2','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (4,'owner2','owner');
  INSERT INTO authorities(id,username,authority) VALUES (5,'owner2','client');
  
  INSERT INTO users(username,password,enabled) VALUES ('owner3','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (6,'owner3','owner');
  INSERT INTO authorities(id,username,authority) VALUES (7,'owner3','client');
  
  INSERT INTO users(username,password,enabled) VALUES ('owner4','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (8,'owner4','owner');
  
  INSERT INTO users(username,password,enabled) VALUES ('owner5','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (9,'owner5','owner');
  
  INSERT INTO users(username,password,enabled) VALUES ('owner6','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (10,'owner6','owner');
  
  INSERT INTO users(username,password,enabled) VALUES ('owner7','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (11,'owner7','owner');
  
  INSERT INTO users(username,password,enabled) VALUES ('owner8','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (12,'owner8','owner');
  
  INSERT INTO users(username,password,enabled) VALUES ('owner9','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (13,'owner9','owner');
  
  INSERT INTO users(username,password,enabled) VALUES ('owner10','0wn3r',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (14,'owner10','owner');
  -- One vet user, named vet1 with passwor v3t
  INSERT INTO users(username,password,enabled) VALUES ('vet1','v3t',TRUE);
  INSERT INTO authorities(id,username,authority) VALUES (15,'vet1','veterinarian');
  
  
  INSERT INTO vets(id,first_name,last_name) VALUES (1, 'James', 'Carter');
  INSERT INTO vets(id,first_name,last_name) VALUES (2, 'Helen', 'Leary');
  INSERT INTO vets(id,first_name,last_name) VALUES (3, 'Linda', 'Douglas');
  INSERT INTO vets(id,first_name,last_name) VALUES (4, 'Rafael', 'Ortega');
  INSERT INTO vets(id,first_name,last_name) VALUES (5, 'Henry', 'Stevens');
  INSERT INTO vets(id,first_name,last_name) VALUES (6, 'Sharon', 'Jenkins');
  
  INSERT INTO specialties VALUES (1, 'radiology');
  INSERT INTO specialties VALUES (2, 'surgery');
  INSERT INTO specialties VALUES (3, 'dentistry');
  
  INSERT INTO vet_specialties VALUES (2, 1);
  INSERT INTO vet_specialties VALUES (3, 2);
  INSERT INTO vet_specialties VALUES (3, 3);
  INSERT INTO vet_specialties VALUES (4, 2);
  INSERT INTO vet_specialties VALUES (5, 1);
  
  INSERT INTO types VALUES (1, 'cat');
  INSERT INTO types VALUES (2, 'dog');
  INSERT INTO types VALUES (3, 'lizard');
  INSERT INTO types VALUES (4, 'snake');
  INSERT INTO types VALUES (5, 'bird');
  INSERT INTO types VALUES (6, 'hamster');
  
  
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username,es_cliente) VALUES (1, 'George', 'Franklin', '110 W. Liberty St.', 'Madison', '6085551023', 'owner1',TRUE);
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username,es_cliente) VALUES (2, 'Betty', 'Davis', '638 Cardinal Ave.', 'Sun Prairie', '6085551749', 'owner2',TRUE);
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username,es_cliente) VALUES (3, 'Eduardo', 'Rodriquez', '2693 Commerce St.', 'McFarland', '6085558763', 'owner3',TRUE);
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username) VALUES (4, 'Harold', 'Davis', '563 Friendly St.', 'Windsor', '6085553198', 'owner4');
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username) VALUES (5, 'Peter', 'McTavish', '2387 S. Fair Way', 'Madison', '6085552765', 'owner5');
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username) VALUES (6, 'Jean', 'Coleman', '105 N. Lake St.', 'Monona', '6085552654', 'owner6');
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username) VALUES (7, 'Jeff', 'Black', '1450 Oak Blvd.', 'Monona', '6085555387', 'owner7');
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username) VALUES (8, 'Maria', 'Escobito', '345 Maple St.', 'Madison', '6085557683', 'owner8');
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username) VALUES (9, 'David', 'Schroeder', '2749 Blackhawk Trail', 'Madison', '6085559435', 'owner9');
  INSERT INTO owners(id,first_name,last_name,address,city,telephone,username) VALUES (10, 'Carlos', 'Estaban', '2335 Independence La.', 'Waunakee', '6085555487', 'owner10');
  
  
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (1, 'Leo', '2010-09-07', 1, 1, false);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (2, 'Basil', '2012-08-06', 6, 2, false);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (3, 'Rosy', '2011-04-17', 2, 3, true);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (4, 'Jewel', '2010-03-07', 2, 3, false);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (5, 'Iggy', '2010-11-30', 3, 4, false);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (6, 'George', '2010-01-20', 4, 5, true);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (7, 'Samantha', '2012-09-04', 1, 6, false);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (8, 'Max', '2012-09-04', 1, 6, true);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (9, 'Lucky', '2011-08-06', 5, 7, false);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (10, 'Mulligan', '2007-02-24', 2, 8, true);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (11, 'Freddy', '2010-03-09', 5, 9, false);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (12, 'Lucky', '2010-06-24', 2, 10, false);
  INSERT INTO pets(id,name,birth_date,type_id,owner_id,en_adopcion) VALUES (13, 'Sly', '2012-06-08', 1, 10, true);
  
  INSERT INTO visits(id,pet_id,visit_date,description) VALUES (1, 7, '2013-01-01', 'rabies shot');
  INSERT INTO visits(id,pet_id,visit_date,description) VALUES (2, 8, '2013-01-02', 'rabies shot');
  INSERT INTO visits(id,pet_id,visit_date,description) VALUES (3, 8, '2013-01-03', 'neutered');
  INSERT INTO visits(id,pet_id,visit_date,description) VALUES (4, 7, '2013-01-04', 'spayed');
  
  INSERT INTO rooms(id) VALUES (1);
  INSERT INTO rooms(id) VALUES (2);
  INSERT INTO rooms(id) VALUES (3);
  INSERT INTO rooms(id) VALUES (4);
  INSERT INTO rooms(id) VALUES (5);
  INSERT INTO rooms(id) VALUES (6);
  INSERT INTO rooms(id) VALUES (7);
  INSERT INTO rooms(id) VALUES (8);
  
  INSERT INTO books(id,pet_id,room_id,checkin,checkout,details) VALUES (1, 1, 1, '2021-01-01', '2021-01-08', 'rabies shot');
  INSERT INTO books(id,pet_id,room_id,checkin,checkout,details) VALUES (2, 2, 2, '2021-01-02', '2021-01-09','rabies shot');
  INSERT INTO books(id,pet_id,room_id,checkin,checkout,details) VALUES (3, 8, 1, '2021-01-03', '2021-01-07','neutered');
  INSERT INTO books(id,pet_id,room_id,checkin,checkout,details) VALUES (4, 7, 3, '2021-01-04', '2021-01-10','spayed');
  INSERT INTO books(id,pet_id,room_id,checkin,checkout,details) VALUES (5, 1, 1, '2021-04-04', '2021-04-14','spayed');
  
  INSERT INTO causas(id,nombre,descripcion,objetivo_presupuestario,organizacion,acumulado) VALUES (1, 'Dar hogar a animales abandonados', 'Buscan y cuidan animales abandonados en la ciudad de Sevilla mientras se encuentra a una familia de adopción', 50000, 'Asociación de animales de Sevilla',12167);
  INSERT INTO causas(id,nombre,descripcion,objetivo_presupuestario,organizacion,acumulado) VALUES (2, 'Defensa Felina', 'Defensa y protección de los gatos callejeros en la ciudad de Sevilla', 20000, 'Defensa Felina',402.5);
  INSERT INTO causas(id,nombre,descripcion,objetivo_presupuestario,organizacion,acumulado) VALUES (3, 'Asesoramiento animal', 'Asesoramiento y acción de defensa de los animales', 10000, 'FAADA',12.75);
  INSERT INTO causas(id,nombre,descripcion,objetivo_presupuestario,organizacion,acumulado) VALUES (4, 'Dar hogar a animales abandonados', 'Buscan y cuidan animales abandonados en la ciudad de Sevilla mientras se encuentra a una familia de adopción', 70000, 'Asociación de animales de España',85);
  
  INSERT INTO donaciones(id,donante,causa_id,cantidad,fecha) VALUES (1,'owner1',1,104,'2021-01-08');
  INSERT INTO donaciones(id,donante,causa_id,cantidad,fecha) VALUES (2,'owner4',1,12063,'2021-03-14');
  INSERT INTO donaciones(id,donante,causa_id,cantidad,fecha) VALUES (3,'owner2',2,402.5,'2021-03-17');
  INSERT INTO donaciones(id,donante,causa_id,cantidad,fecha) VALUES (4,'owner6',3,12.75,'2021-04-09');
  INSERT INTO donaciones(id,donante,causa_id,cantidad,fecha) VALUES (5,'owner9',4,85,'2021-04-21');
  
  INSERT INTO propuestas(id,description,pet_id,owner_id) VALUES (1,'Tendrá todos los cuidados que una mascota deba tener',3,2);
  INSERT INTO propuestas(id,description,pet_id,owner_id) VALUES (2,'Tendrá todos los cuidados posibles',13,4);
  INSERT INTO propuestas(id,description,pet_id,owner_id) VALUES (3,'Lo cuidaré como a todas mis mascotas',6,1);
  INSERT INTO propuestas(id,description,pet_id,owner_id) VALUES (4,'Tendrá una comida diaria',10,10);
  INSERT INTO propuestas(id,description,pet_id,owner_id) VALUES (5,'Tendrá una comida diaria con opción a paseo si se porta bien',8,7);
  