-- DATABASE SETUP
-- Run this once on the external MySQL server.

CREATE DATABASE IF NOT EXISTS worker_tracker;
USE worker_tracker;

CREATE TABLE IF NOT EXISTS time_entries (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  username VARCHAR(100) NOT NULL,
  role VARCHAR(20) NOT NULL,
  clock_in DATETIME NOT NULL,
  clock_out DATETIME NULL,
  duration_minutes INT NULL,
  notes VARCHAR(500) NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  INDEX idx_user (username),
  INDEX idx_clock_in (clock_in)
);

-- IMPORTANT:
-- This file is named index.html only because the requested project
-- contains exactly three files. The actual webpage is served directly
-- from server.js. Run the SQL above using your MySQL client.