create or replace PROCEDURE updateBike(ID_BICYCLE INTEGER, AVAILABLE Char)
AS
BEGIN
    UPDATE Bicycle
    SET bicycle.available = AVAILABLE
    WHERE Bicycle.ID_BICYCLE = ID_BICYCLE;
END updateBike;
/

create or replace PROCEDURE updateEletric(ID_BICYCLE INTEGER, TENSION Float,BATTERY_CAPACITY Float,BATTERY_REMAINING Float,MOTOR_POWER Float)
AS
BEGIN
    UPDATE EBicycle
    SET EBicycle.TENSION = TENSION,
        EBicycle.BATTERY_CAPACITY=BATTERY_CAPACITY,
        EBicycle.BATTERY_REMAINING=BATTERY_REMAINING,
        EBicycle.MOTOR_POWER=MOTOR_POWER
    WHERE EBicycle.ID_BICYCLE = ID_BICYCLE;
END updateEletric;
/

create or replace PROCEDURE updateJourney( email Varchar,  INITIAL_DATE Timestamp,  FINAL_DATE Timestamp,  ID_BICYCLE integer,  ID_ORIGIN_PARK Integer,  ID_DESTINATION_PARK Integer)
AS
BEGIN
    UPDATE IndividualHistory
    SET individualhistory.final_date=FINAL_DATE,
        individualhistory.id_destination_park=ID_DESTINATION_PARK
    WHERE IndividualHistory.email = email and IndividualHistory.INITIAL_DATE=INITIAL_DATE;
END updateJourney;
/