-- Schema mínimo para a camada PHP de teste (admin + settings).
-- Observação: o dashboard usa dados mock em storage/mock_crm.json.

CREATE TABLE IF NOT EXISTS admin_users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(64) NOT NULL UNIQUE,
  password_hash VARCHAR(255) NOT NULL,
  role VARCHAR(32) NOT NULL DEFAULT 'admin',
  created_at DATETIME NOT NULL
);


CREATE TABLE IF NOT EXISTS app_settings (
  id INT PRIMARY KEY,
  app_name VARCHAR(128) NOT NULL,
  language VARCHAR(16) NOT NULL,
  created_at DATETIME NOT NULL,
  updated_at DATETIME NOT NULL
);

