cmackenzie1

CREATE TABLE users (
  id BIGINT GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  email TEXT NOT NULL UNIQUE,
  name TEXT,
  password_hash TEXT,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  activated_at TIMESTAMPTZ,
  email_verified_at TIMESTAMPTZ
);

cmackenzie1

# Install dependencies
sudo apt update
sudo apt install -y xz-utils

# Create factorio user
sudo useradd -m -r -s /bin/bash factorio

# Download and extract Factorio headless server
cd /opt
sudo curl -L -o factorio-headless.tar.xz "https://factorio.com/get-download/stable/headless/linux64"