-- Growfi MySQL schema and seed data
CREATE DATABASE IF NOT EXISTS growfi_production;
USE growfi_production;

CREATE TABLE wallets (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT NOT NULL,
  balance DECIMAL(18,6) DEFAULT 0,
  staking DECIMAL(18,6) DEFAULT 0,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

-- Note: After import, update the password_hash fields to real hashes using PHP's password_hash() or run the included helper script.
