#!/bin/bash
set -e

# Create persistent directories
mkdir -p /data/sites
mkdir -p /data/sessions
mkdir -p /data/logs
mkdir -p /data/db

# Fix ownership
chown -R www-data:www-data /data

# Make Apache listen on port 7860 (required by Hugging Face)
sed -i 's/^Listen 80$/Listen 7860/' /etc/apache2/ports.conf
sed -i 's/<VirtualHost \*:80>/<VirtualHost *:7860>/' /etc/apache2/sites-available/platform.conf

# Create SQLite database if it doesn't exist yet
DB=/data/db/platform.sqlite
if [ ! -f "$DB" ]; then
    sqlite3 "$DB" <<'SQL'
CREATE TABLE IF NOT EXISTS users (
    id         INTEGER PRIMARY KEY AUTOINCREMENT,
    username   TEXT    NOT NULL UNIQUE,
    created_at TEXT    NOT NULL DEFAULT (datetime('now'))
);
CREATE TABLE IF NOT EXISTS files (
    id         INTEGER PRIMARY KEY AUTOINCREMENT,
    username   TEXT NOT NULL,
    filepath   TEXT NOT NULL,
    updated_at TEXT NOT NULL DEFAULT (datetime('now')),
    UNIQUE(username, filepath)
);
SQL
    chown www-data:www-data "$DB"
fi

# Start Apache
exec apache2-foreground