server/migrations/2024-05-09-173338_initial_db_setup/down.sql

15 lines
403 B
SQL

ALTER TABLE meal_images DROP CONSTRAINT image_id_constraint;
ALTER TABLE meal_images DROP CONSTRAINT meal_id_constraint;
DROP TABLE meals;
DROP TABLE restaurant_ratings;
DROP TABLE restaurants;
DROP TABLE nodes;
DROP TABLE users;
DROP TABLE images;
DROP TABLE meal_images;
DROP TYPE node_type;
DROP FUNCTION check_node_type();
DROP FUNCTION check_linked_restaurants();
DROP EXTENSION postgis CASCADE;