Database Setup Required
Please create the "mods" table in your Supabase database with the following SQL:
CREATE TABLE mods (
id SERIAL PRIMARY KEY,
title TEXT NOT NULL,
description TEXT NOT NULL,
screenshot TEXT,
download_url TEXT,
created_at TIMESTAMPTZ DEFAULT NOW()
);
Or run this SQL to fix the current table:
-- Allow NULL for screenshot
ALTER TABLE mods ALTER COLUMN screenshot DROP NOT NULL;
-- Add download_url if missing
ALTER TABLE mods ADD COLUMN IF NOT EXISTS download_url TEXT;
-- Update existing rows
UPDATE mods SET download_url = '#' WHERE download_url IS NULL;
-- Add created_at if missing
ALTER TABLE mods ADD COLUMN IF NOT EXISTS created_at TIMESTAMPTZ DEFAULT NOW();