-- Owen Sullivan
-- C34243277
-- CPSC 4620 S24

USE Pizzeria;

-- Drop tables in reverse order from their creation to ensure no conflicts
DROP TABLE pizza_discount;
DROP TABLE order_discount;
DROP TABLE discount;
DROP TABLE customization;
DROP TABLE topping;
DROP TABLE pizza;
DROP TABLE base_price;
DROP TABLE delivery_order;
DROP TABLE pickup_order;
DROP TABLE dine_in_order;
DROP TABLE `order`;
DROP TABLE customer;

-- Drop the schema
DROP SCHEMA Pizzeria;