CREATE DATABASE revolut_clone;
USE revolut_clone;

CREATE TABLE users(
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50),
password VARCHAR(255)
);

CREATE TABLE admins(
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50),
password VARCHAR(255)
);

CREATE TABLE wallets(
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
currency VARCHAR(10),
balance DECIMAL(18,2)
);

CREATE TABLE transactions(
id INT AUTO_INCREMENT PRIMARY KEY,
sender_id INT,
receiver_id INT,
amount DECIMAL(18,2),
currency VARCHAR(10),
status VARCHAR(20)
);