-- Migration: Add category column to event_subgroups
-- Run this script on existing databases to add subgroup categories.
-- New databases created from schema.sql already include this column.

ALTER TABLE event_subgroups
  ADD COLUMN category ENUM('organisation', 'numero') NOT NULL DEFAULT 'organisation' AFTER description;
