-- Users table

CREATE TABLE IF NOT EXISTS users (

  id INTEGER PRIMARY KEY AUTOINCREMENT,

  email TEXT UNIQUE NOT NULL,

  password TEXT NOT NULL,

  first_name TEXT NOT NULL,

  last_name TEXT NOT NULL,

  created_at DATETIME DEFAULT CURRENT_TIMESTAMP

);

-- Mood tracking table

CREATE TABLE IF NOT EXISTS mood (

  id INTEGER PRIMARY KEY AUTOINCREMENT,

  user_id INTEGER NOT NULL,

  stress_level INTEGER NOT NULL CHECK (stress_level BETWEEN 1 AND 5),

  anxiety_level INTEGER NOT NULL CHECK (anxiety_level BETWEEN 1 AND 5),

  title TEXT,

  description TEXT,

  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,

  FOREIGN KEY (user_id) REFERENCES users(id)

);

-- Index for faster mood queries by user

CREATE INDEX IF NOT EXISTS idx_mood_user_id ON mood(user_id);