--insertar usuarios
CALL Insertar_user('Borja','Merchán', 'Cachinero', 'bmcx12', '28849427k', 'bmcx12@gmail.com', 'manuel12', 'Doctor Delgado Roig n10 2a', 'Sevilla', 41008, 616674480, 'foto','payment', 1);
CALL Insertar_user('Carlos','Sánchez', 'Guajardo-Fajardo', 'cajora', '24896574f', 'cajoragmail.com', 'cajora12', 'San Jacinto 58 2a', 'Sevilla', 41010, 617895410, 'foto','payment', 1);
CALL Insertar_user('Antonio','Jimenez', 'Casado', 'antonji', '28842227k', 'antonji@gmail.com', 'antonji12', 'Amate 2a', 'Sevilla', 41007, 617774480, 'foto','payment', 0);
CALL Insertar_user('Paco','González', 'Rivera', 'pacori', '28349427k', 'pacori@gmail.com', 'pacori12', 'Arroyo n10 2a', 'Sevilla', 41308, 613374480, 'foto','payment', 0);
CALL Insertar_user('Juan','Ruiz', 'Gamero', 'juangar', '28843327z', 'juangar@gmail.com', 'juangar12', 'Doctor Fedriani 3 2a', 'Sevilla', 41008, 616652480, 'foto','payment', 0);

SELECT * FROM userapp;

--insertar ItemModel
CALL Insertar_ItemModel('Condoms','Natural preservatives easy to put','picture');
CALL Insertar_ItemModel('Dildos','Sexual device resembling a penis in shape, size, and overall appearance.','picture');
CALL Insertar_ItemModel('Vibrators','devices for the body and skin, to stimulate the nerves for a relaxing and pleasurable feeling','picture');

SELECT * FROM itemmodel;


--insertar DELIVERY
--CONDONES
CALL Insertar_Delivery(1,'Durex Topsafe','TopSafe Durex condoms are slightly thicker and lubricated, thus providing additional security against the risk of unwanted pregnancy and sexually transmitted diseases.',3,12.70,'Clear, plain, lubricated, with reservoir. Made of natural latex. Anatomical shape. Nominal width: 54mm. Box of 12 condoms','picture');
CALL Insertar_Delivery(1,'Durex Condoms Tuttifruti Party','Durex Condoms Tuttifruti Party, with its colors and flavors of strawberry, banana, mint, orange add a touch of fun to your sex. Dermatologically tested. Plain colors and flavors, lubricated with a selection of flavors.',3,7.30,'With deposit. Made of natural latex. 100% electronically tested. Box of 6 condoms','picture');
CALL Insertar_Delivery(2,'Durex Fetherlite','Fheterlite Durex condoms, are known for their comfort, are thinner to get an extra sensitivity Dermatologically tested. Clear, smooth, thin, with reservoir, lubricated without spermicide.',3,14.50,'Made of natural latex. Nominal width: 54mm. Box of 12 condoms.','picture');
---DILDOS
CALL Insertar_Delivery(2,'Red Boy 7 inch Dong','Red Boy 7 inch Dong is a penis made ??of premium vinyl, the prestigious collection of Red Boy.',3,5.50,'Dimensions: 18 cm x 3.5 cm','picture');
CALL Insertar_Delivery(1,'Feelztoys Rombee Dildo','Rombee FEELZTOYS VIBRATOR dildo is a very functional quality. This comforter so nice, modern and ergonomic design is made from 100% medical silicone. Furthermore, this comforter is also very suitable for anal use. .',3,18.20,'The material is odorless, tasteless, non-porous, hypoallergenic, has no plasticizers and is easily cleaned with warm water and mild soap. . Size: 13 cm x 3 cm.','picture');
CALL Insertar_Delivery(2,'Stubs Whirly Dildo Turquoise','It stimulates his brazen nose and dives into the important parts of the body. Surrender to the pleasure they produce their business fins. Length: 10 cm.Hot or cold, always provide a stimulus varied both on land and at sea.',3,24.50,'Use with harness. - 100% silicone. In each package STUBS do you find the instructions and, as a sample of our lubricant TOYFLUID.','picture');
--vibrator
CALL Insertar_Delivery(2,'Vibrator with Clitoral Stimulator','BOY BLUE BEACH SEABREEZE is a vibrator with clitoral stimulator gelatin incorporated with very soft. The route of the vibrator is textured to cause further sensations. It is waterproof, which you can use it in the shower. ',3,9.10,'It has two motors, one located at the top of the vibrator and the other in the clitoral stimulator.  Size: 15 cm x 3.5 cm. Uses 3 LR03/AAA you can find in the Battery section.','picture');
CALL Insertar_Delivery(1,'White Feel Vibrador','This vibrator has five different vibration functions and is very easy to use. The material is odorless, tasteless, non-porous, hypoallergenic.',3,36.30,'All products carry certification CE.Medidas: 20 cm x 3.5 cm. Works with 2 x R6/AA you can find in the Battery section.','picture');

--nuevo delivery sin item model creado.
CALL insertar_delivery(4,'Massage oil set', 'kit consists of 4 aromatic massage oils smooth as silk with vitamin E, a delight for the body and senses. Its active ingredients keep your skin soft and supple.',3,9.10,' The kit includes: - Ylang Ylang-MASSAGE OIL MASSAGE OIL LAVENDER OIL JASMINE-MASSAGE-MASSAGE OIL Eucalyptus .4 Use Only 50 ml bottles.','picture');

SELECT * FROM delivery;

--insertar checky
CALL insertar_checky(1,1,0,'This product likes me.');
CALL insertar_checky(2,1,1,'The price is too cheap.');
CALL insertar_checky(3,1,1,'The price is too expensive.');

CALL insertar_checky(4,1,2,'The product is perfect.');
CALL insertar_checky(5,1,2,'The price is too expensive.');
CALL insertar_checky(6,1,2,'This product likes me.');

CALL insertar_checky(7,1,3,'The price is too expensive.');
CALL insertar_checky(8,1,3,'The price is too expensive.');

CALL insertar_checky(9,1,0,'This product is new on the system, I like so much.');