
CREATE DATABASE premium_vtu;

USE premium_vtu;

CREATE TABLE users (
 id INT AUTO_INCREMENT PRIMARY KEY,
 name VARCHAR(100),
 email VARCHAR(100),
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE transactions (
 id INT AUTO_INCREMENT PRIMARY KEY,
 network VARCHAR(50),
 phone VARCHAR(20),
 amount DECIMAL(10,2),
 status VARCHAR(20),
 created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
