-- Database schema for Demo Trader Pro
-- Create table to store virtual cash balances for users

CREATE TABLE IF NOT EXISTS `users` (
  `userid` VARCHAR(50) NOT NULL,
  `cash` DECIMAL(15, 2) NOT NULL DEFAULT 1000.00,
  `last_sync` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;