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 admins (
 id INT AUTO_INCREMENT PRIMARY KEY,
 username VARCHAR(100),
 password VARCHAR(255)
);

INSERT INTO admins(username,password)
VALUES('admin','admin123');

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
);