
CREATE DATABASE business_order;
USE business_order;

CREATE TABLE orders (
 id INT AUTO_INCREMENT PRIMARY KEY,
 nama VARCHAR(100),
 whatsapp VARCHAR(20),
 telp VARCHAR(20),
 pickup TEXT,
 dropoff TEXT,
 kursi VARCHAR(50),
 penumpang INT,
 harga DECIMAL(10,2),
 status ENUM('Pending','Paid','Done','Cancelled') DEFAULT 'Pending',
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
