 
 INSERT INTO periodicities VALUES (1,"daily"),(2,"monthly");
 
-INSERT INTO magazines VALUES (1,"La Busa",2,4),(2,"La Befusa",2,1);
+INSERT INTO magazines VALUES (1,"La Busa",2,4),(2,"rivista2",2,1);
 
 INSERT INTO magRelases VALUES (1,1,53,"2016-04-01","April number",2,50),(2,1,54,"2016-05-01","May april",2,50);
 


CREATE PROCEDURE allMagazines()
BEGIN
	
END $$

DELIMITER ;

GRANT EXECUTE ON PROCEDURE DISTRIBUTOR.workerPhoneNumbers TO 'guest'@'%';
GRANT EXECUTE ON PROCEDURE DISTRIBUTOR.allWorkers TO 'guest'@'%';
GRANT EXECUTE ON PROCEDURE DISTRIBUTOR.workersPhoneNumber TO 'guest'@'%';
GRANT EXECUTE ON PROCEDURE DISTRIBUTOR.allMagazines TO 'guest'@'%';

GRANT EXECUTE ON FUNCTION DISTRIBUTOR.insertLocation TO 'guest'@'%';
GRANT EXECUTE ON FUNCTION DISTRIBUTOR.insertPhoneNumber TO 'guest'@'%';
