CREATE TABLE users(id INT AUTO_INCREMENT PRIMARY KEY, fullname VARCHAR(100), email VARCHAR(100), status VARCHAR(20));
CREATE TABLE transactions(id INT AUTO_INCREMENT PRIMARY KEY,user_id INT,amount DECIMAL(15,2),method VARCHAR(20),otp VARCHAR(10),status VARCHAR(20));
CREATE TABLE currencies(id INT AUTO_INCREMENT PRIMARY KEY,name VARCHAR(10),rate DECIMAL(10,2));
CREATE TABLE smtp_settings(id INT AUTO_INCREMENT PRIMARY KEY,host VARCHAR(100),username VARCHAR(100),password VARCHAR(100));
INSERT INTO smtp_settings(id,host,username,password) VALUES(1,'smtp.example.com','user','pass');
CREATE TABLE loans(id INT AUTO_INCREMENT PRIMARY KEY,user_id INT,amount DECIMAL(15,2),status VARCHAR(20));
CREATE TABLE cards(id INT AUTO_INCREMENT PRIMARY KEY,user_id INT,type VARCHAR(20),status VARCHAR(20));