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

);

CREATE TABLE IF NOT EXISTS mood (

  id INTEGER PRIMARY KEY AUTOINCREMENT,

  user_id INTEGER NOT NULL,

  stress_level INTEGER NOT NULL,

  anxiety_level INTEGER NOT NULL,

  title TEXT,

  description TEXT,

  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,

  FOREIGN KEY (user_id) REFERENCES users(id)

);