CREATE DATABASE neko_vtu;
USE neko_vtu;

CREATE TABLE users(

id INT AUTO_INCREMENT PRIMARY KEY,

fullname VARCHAR(100),

email VARCHAR(100) UNIQUE,

password VARCHAR(255),

wallet DECIMAL(12,2) DEFAULT 0,

pin VARCHAR(255),

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

CREATE TABLE wallet_transactions(

id INT AUTO_INCREMENT PRIMARY KEY,

user_id INT,

amount DECIMAL(12,2),

reference VARCHAR(100),

status VARCHAR(20),

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);

CREATE TABLE orders(

id INT AUTO_INCREMENT PRIMARY KEY,

user_id INT,

service VARCHAR(50),

network VARCHAR(50),

phone VARCHAR(20),

amount DECIMAL(12,2),

status VARCHAR(20),

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

);