
CREATE DATABASE investment_db;
USE investment_db;
CREATE TABLE plans(id INT AUTO_INCREMENT PRIMARY KEY,name VARCHAR(100),description TEXT,duration INT);
CREATE TABLE wallets(id INT AUTO_INCREMENT PRIMARY KEY,currency VARCHAR(20),address VARCHAR(255),active TINYINT DEFAULT 1);
CREATE TABLE payments(id INT AUTO_INCREMENT PRIMARY KEY,user_id INT,wallet TEXT,txid TEXT,status VARCHAR(20));
