CREATE DATABASE tripay_store;
USE tripay_store;

CREATE TABLE orders (
id INT AUTO_INCREMENT PRIMARY KEY,
merchant_ref VARCHAR(100),
customer_name VARCHAR(100),
amount INT,
payment_reference VARCHAR(100),
status VARCHAR(20),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
