insert into category (ID, NAME_CATEGORY) values (NEXTVAL('hibernate_sequence'), 'Fruta');
insert into category (ID, NAME_CATEGORY) values (NEXTVAL('hibernate_sequence'), 'Bebida');
insert into category (ID, NAME_CATEGORY) values (NEXTVAL('hibernate_sequence'), 'Legumbre');
insert into category (ID, NAME_CATEGORY) values (NEXTVAL('hibernate_sequence'), 'Pasta');
insert into category (ID, NAME_CATEGORY) values (NEXTVAL('hibernate_sequence'), 'Carne');
insert into category (ID, NAME_CATEGORY) values (NEXTVAL('hibernate_sequence'), 'Verdura');
insert into category (ID, NAME_CATEGORY) values (NEXTVAL('hibernate_sequence'), 'Pescado');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'bcurtois0@ycombinator.com', 'Maïwenn', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'qweqqeqe0@ycombinator.com', 'sdsda', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'qweqewqs0@ycombinator.com', 'sssddd', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'sseee@ycombinator.com', 'Paula', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'dsadasdasx0@ycombinator.com', 'Maria', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'eeeeerrc@ycombinator.com', 'Sara', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'fjhdsfdsjhfsdf0@ycombinator.com', 'Paco', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'exyta@ycombinator.com', 'Juan', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'perst0@ycombinator.com', 'Hola', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'mister@ycombinator.com', 'Hola', '1234', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('A', NEXTVAL('hibernate_sequence'), false, false, false, 'admin@admin.com', 'Hola', 'admin', '2019-03-29', '2019-04-28');
insert into user (DTYPE, ID, CREDENCIALES_CADUCADAS, CUENTA_BLOQUEADA, CUENTA_CADUCADA, EMAIL, NAME, PASSWORD, FECHA_NACIMIENTO, FECHA_ALTA) values ('C', NEXTVAL('hibernate_sequence'), false, false, false, 'usuario@usuario.com', 'Hola', '1234', '2019-03-29', '2019-04-28');
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-03-14', '25-05-2019_09-51-37_manzana.jpg', true, 'Manzana', 7, 1, 1);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-10-09', '25-05-2019_09-52-19_cEnergy.jpg', true, 'Coca-Cola Energy', 69, 2, 2);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-12-10', '25-05-2019_09-52-34_lenteja.jpg', false, 'Lentejas', 45, 3, 3);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-06-01', '25-05-2019_09-52-47_chicharo.jpg', false, 'Chicharos', 44, 4, 3);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-12-19', '25-05-2019_09-53-10_macarrones.jpg', false, 'Macarrones', 1, 5, 4);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-07-11', '25-05-2019_09-53-45_espaguetis.jpg', true, 'Espaguetis', 80, 6, 4);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-01-23', '25-05-2019_09-54-04_zumopina.jpg', false, 'Zumo de Piña', 46, 7, 2);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-05-04', '25-05-2019_09-54-20_ternera.jpg', false, 'Ternera', 44, 8, 5);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-06-05', '25-05-2019_09-55-37_lechuga.jpg', true, 'Lechuga', 50, 9, 6);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-12-12', '25-05-2019_09-55-52_pina.jpg', true, 'Piña', 62, 10, 1);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-02-10', '25-05-2019_09-56-23_garbanzos.jpg', false, 'Garbanzos', 25, 11, 3);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-03-31', '25-05-2019_09-56-31_batidochocolate.jpg', true, 'Batido de Chocolate', 99, 12, 2);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-04-12', '25-05-2019_09-56-43_melocoton.jpg', true, 'Melocotón', 94, 13, 1);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-10-04', '25-05-2019_09-56-53_fanta.jpg', true, 'Fanta', 54, 14, 2);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-02-01', '25-05-2019_09-57-06_filetescerdo.png', false, 'Filetes de Cerdo', 7, 15, 5);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-04-26', '25-05-2019_09-57-32_sevenup.jpg', false, '7Up', 19, 16, 2);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-02-26', '25-05-2019_09-57-42_coliflor.jpg', true, 'Coliflor', 30, 17, 6);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-03-16', '25-05-2019_09-57-57_coco.jpg', true, 'Coco', 94, 18, 1);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-04-06', '25-05-2019_09-58-08_pera.jpg', true, 'Pera', 74, 19, 1);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-02-23', '25-05-2019_09-58-19_frijoles.jpg', false, 'Frijoles', 12, 20, 3);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-09-17', '25-05-2019_09-58-33_platano.jpg', true, 'Plátano', 32, 21, 1);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-11-23', '25-05-2019_09-58-45_salmon.jpg', true, 'Salmón', 73, 22, 7);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-08-02', '25-05-2019_09-59-09_mero.jpg', false, 'Mero', 92, 23, 7);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-02-13', '25-05-2019_09-59-22_merluza.jpg', false, 'Merluza', 83, 24, 7);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-08-03', '25-05-2019_09-59-32_espinacas.jpg', false, 'Espinaca', 72, 25, 6);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-04-09', '25-05-2019_09-59-44_acelga.jpg', false, 'Acelga', 72, 26, 6);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2018-06-09', '25-05-2019_09-59-56_esparragos.jpg', true, 'Espárrago', 73, 27, 6);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-03-23', '25-05-2019_10-00-12_zanahoria.jpg', true, 'Zanahoria', 94, 28, 6);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-05-02', '25-05-2019_10-00-29_filetespollo.jpg', false, 'Filetes de Pollo', 59, 29, 5);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-04-07', '25-05-2019_10-00-40_alcachofa.jpg', true, 'Alcachofa', 93, 30, 6);
insert into product (ID, DATE_OF_EXPIRY, FILE_URL, IS_IN_OFFER, NAME, PRICE, UD, CATEGORY_ID) values (NEXTVAL('hibernate_sequence'), '2019-04-07', '27-05-2019_00-40-26_gulas.jpg', true, 'Gulas', 93, 30, 7);
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Sevilla', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '41017', 'Acanto');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Sevilla', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '41010', 'Triana');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Sevilla', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '41970', 'Santiponce');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Madrid', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '28006', 'Alcantara');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Madrid', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '28006', 'Grijalba');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Madrid', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '28006', 'Jose Ortega Y Gasset');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Barcelona', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '08012', 'Abdo Terradas');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Barcelona', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '08017', 'Actor Morano');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Barcelona', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '08014', 'Alcolea');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Barcelona', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '08023', 'Esteve Terradas');
insert into shop (ID, CITY, FILE_URL, NAME, POSTAL_CODE, STREET) values (NEXTVAL('hibernate_sequence'), 'Barcelona', '26-05-2019_19-05-49_market.jpg', 'SuperMercado Rubio', '04927', 'Santa Maria');
insert into recipe (ID, CATEGORY, DESCRIPTION, FILE_URL, HOUR_COOKED, INGREDIENTES, NAME, NVL_SKILL, CATEGORY_RECIPE_ID, USER_ID) values (NEXTVAL('hibernate_sequence'), null, 'Las lentejas de toda la vida, las de casa', '27-05-2019_00-15-47_recipelentejas.jpg', '1 hora y 15 min', 'Para 4 personas, Lentejas 250 g, Pimiento verde 100 g, Cebolla 80 g, Puerro 70 g, Zanahoria 100 g, Patata 250 g, Salsa de tomate casera 50 g, Aceite de oliva virgen extra , 6 cucharadas, Diente de ajo 1, Laurel, Sal, Pimentón dulce 1 cucharadita', 'Lentejas guisadas', 2, 3, null);
insert into recipe (ID, CATEGORY, DESCRIPTION, FILE_URL, HOUR_COOKED, INGREDIENTES, NAME, NVL_SKILL, CATEGORY_RECIPE_ID, USER_ID) values (NEXTVAL('hibernate_sequence'), null, 'Un plato de coliflor exquisito', '27-05-2019_00-11-28_recipecoliflor.jpg', '1 hora y 30 min', '50 gramos de harina, 8 claras de huevo, 4 yemas de huevo, 60 mililitros de aceite de oliva, medio litro de leche semidesnatada sin lactosa Kaiku, un sobre de queso emmental sin lactosa Kaiku, una coliflor y un brócoli (ambos pequeños), sal, pimienta y nuez moscada.', 'Suflé de coliflor', 3, 6, null);
insert into recipe (ID, CATEGORY, DESCRIPTION, FILE_URL, HOUR_COOKED, INGREDIENTES, NAME, NVL_SKILL, CATEGORY_RECIPE_ID, USER_ID) values (NEXTVAL('hibernate_sequence'), null, 'Empanada de aspecto zombie pero muy buena de sabor', '27-05-2019_00-11-58_recipeempanada.jpg', 'Hasta que esté dorada', '1 plancha de Hojaldre refrigerado, 400 g de atún en agua escurrido, media Cebolla, 3 cucharadas de Salsa de tomate, 1 Pimiento verde italiano, 50 g de Gulas (sucedáneo de angulas), 1 Dientes de ajo, 1 Yema de huevo', 'Empanada zombie con gusanos', 2, 7, null);
insert into recipe (ID, CATEGORY, DESCRIPTION, FILE_URL, HOUR_COOKED, INGREDIENTES, NAME, NVL_SKILL, CATEGORY_RECIPE_ID, USER_ID) values (NEXTVAL('hibernate_sequence'), null, 'Delicioso mero al horno', '27-05-2019_00-13-02_recipemero.jpg', '45 min', 'Para 2 personas, Cebolla 1, Patatas 2, Mero 600 g, Aceite de oliva virgen extra 10 ml, Perejil un ramillete', 'Mero al horno', 2, 7, null);
insert into recipe (ID, CATEGORY, DESCRIPTION, FILE_URL, HOUR_COOKED, INGREDIENTES, NAME, NVL_SKILL, CATEGORY_RECIPE_ID, USER_ID) values (NEXTVAL('hibernate_sequence'), null, 'Espaguetis picantes con langostinos, tomates cherry y whisky', '27-05-2019_00-12-24_recipeespagueti.jpg', '40 min', 'Ingredientes para 4 personas. 400 g de espaguetis, 3 cucharadas de aceite de oliva virgen extra ,200 g de langostinos, 2 dientes de ajo, 1 cayena, 200 g de tomates cherry, 2 cucharadas de whisky, 140 ml de nata líquida para cocinar, 1 limón (zumo), 30 g de queso parmesano.', 'Espaguetis picantes', 2, 5, null);
insert into recipe (ID, CATEGORY, DESCRIPTION, FILE_URL, HOUR_COOKED, INGREDIENTES, NAME, NVL_SKILL, CATEGORY_RECIPE_ID, USER_ID) values (NEXTVAL('hibernate_sequence'), null, 'El bizcocho de pera que estabas deseando', '27-05-2019_00-13-19_recipepera.jpg', '45 min', '200 g (1/2 lata peq.) de Leche condensada LA LECHERA, 125 ml de aceite de girasol, 100 ml de leche, 10 g de levadura en polvo, 550 g de peras conference limpias (3-4 unidades), 250 g de harina, 4 huevos', 'Bizcocho de leche condensada y peras', 2, 1, null);
insert into recipe (ID, CATEGORY, DESCRIPTION, FILE_URL, HOUR_COOKED, INGREDIENTES, NAME, NVL_SKILL, CATEGORY_RECIPE_ID, USER_ID) values (NEXTVAL('hibernate_sequence'), null, 'Batido de café y plátano a la canela', '27-05-2019_00-11-07_recipebatido.jpg', '5 min', '1 cápsula de NESCAFÉ Dolce Gusto Espresso Descafeinado,1 Yogur griego azucarado NESTLÉ, 40 g (2 cucharadas) de Leche condensada LA LECHERA, 1 plátano (160 g) congelado y cortado en trozos, 1 ramita de canela, canela en polvo, Hielo picado al gusto', 'Batido de café y plátano a la canela', 7, 2, null);