CREATE TABLE users(id INT AUTO_INCREMENT PRIMARY KEY,name VARCHAR(255),phone VARCHAR(20),password VARCHAR(255));
CREATE TABLE restaurants(id INT AUTO_INCREMENT PRIMARY KEY,name VARCHAR(255),owner_id INT,subscription_status VARCHAR(50),expiry_date DATE,is_featured BOOLEAN,is_priority BOOLEAN);
CREATE TABLE menu_items(id INT AUTO_INCREMENT PRIMARY KEY,restaurant_id INT,name VARCHAR(255),price DECIMAL(10,2),image VARCHAR(255));
CREATE TABLE orders(id INT AUTO_INCREMENT PRIMARY KEY,user_id INT,restaurant_id INT,total DECIMAL(10,2),commission DECIMAL(10,2));
CREATE TABLE ratings(id INT AUTO_INCREMENT PRIMARY KEY,user_id INT,restaurant_id INT,rating INT,comment TEXT);
