-- SQL for BRICS FundShield
CREATE DATABASE IF NOT EXISTS brics_db;
USE brics_db;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100),
phone VARCHAR(20),
password VARCHAR(255),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE investments (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT,
plan VARCHAR(50),
amount DECIMAL(10,2),
status VARCHAR(20),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);