CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
phone VARCHAR(20),
password VARCHAR(100),
role VARCHAR(20),
balance DOUBLE DEFAULT 0
);

CREATE TABLE transactions (
id INT AUTO_INCREMENT PRIMARY KEY,
sender VARCHAR(20),
receiver VARCHAR(20),
amount DOUBLE,
status VARCHAR(20),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);