DROP PROCEDURE FARKAF_sch.reservation_registered_init;
DROP PROCEDURE FARKAF_sch.reservation_guest_init;
DROP PROCEDURE FARKAF_sch.reservation_add;
DROP PROCEDURE FARKAF_sch.reservation_del;
DROP PROCEDURE FARKAF_sch.reservation_registered_final;
DROP PROCEDURE FARKAF_sch.reservation_guest_final;

DROP TRIGGER FARKAF_sch.trg_guest
DROP TRIGGER FARKAF_sch.trg_reservation_history;

DROP TABLE FARKAF_sch.reservation_history;
DROP TABLE FARKAF_sch.apartmen_reservation;
DROP TABLE FARKAF_sch.reservation;
DROP TABLE FARKAF_sch.registered;
DROP TABLE FARKAF_sch.apartment;
DROP TABLE FARKAF_sch.price;
DROP TABLE FARKAF_sch.category;