Add sort_order and group columns to _emdash_collections

[ahliweb]

Problem

Collections in the admin sidebar are sorted alphabetically by slug. There is no way to group collections (e.g., "Blog", "Products", "Team") -- everything is a flat list in the "Content" group.

Proposed Solution

Add sort_order (INTEGER, nullable) and group (TEXT, nullable) columns to _emdash_collections.

Migration

ALTER TABLE _emdash_collections ADD COLUMN sort_order INTEGER;
ALTER TABLE _emdash_collections ADD COLUMN group TEXT;

Changes

• Update Collection interface in packages/core/src/schema/types.ts
• Update CollectionConfig seed type to accept sortOrder and group
• Update listCollectionsWithFields() to order by sort_order ASC, slug ASC
• Seed apply/create handles sortOrder and group
• Export-seed includes these fields

Acceptance Criteria

• Migration created with up/down
• Collection type includes sortOrder?: number and group?: string
• listCollectionsWithFields() orders by sort_order ASC, slug ASC
• Seed apply/create handles both fields
• Backward compatible: existing collections get NULL

Notes

• This is the data layer only -- sidebar rendering is a separate issue (Render collection groups and sort_order in admin sidebar #2)
• Upstream PR feat(core): add group and sortOrder to collections for admin UI organization emdash-cms/emdash#292 attempted this but stalled due to merge conflicts
• sort_order already exists on _emdash_fields -- follow the same pattern

Depends on: none (foundational)
Blocks: #2

[ahliweb]

Completed

Changes Made

Migration: 038_collection_grouping.ts

• Added sort_order (INTEGER, default 0) column
• Added group (TEXT, nullable) column

Type updates:

• CollectionTable in database/types.ts -- added columns
• Collection interface in schema/types.ts -- added sortOrder: number and group?: string
• CreateCollectionInput -- added sortOrder? and group?
• UpdateCollectionInput -- added sortOrder? and group?
• SeedCollection in seed/types.ts -- added sortOrder? and group?
• ManifestCollection in astro/types.ts -- added sortOrder: number and group?: string

Registry updates:

• listCollections() and listCollectionsWithFields() now order by sort_order ASC, slug ASC
• createCollection() accepts and stores sortOrder and group
• updateCollection() accepts and updates sortOrder and group
• mapCollectionRow() maps both new fields
• registerOrphanedTable() includes new columns

Manifest build:

• _buildManifest() includes sortOrder and group per collection

Seed:

• apply.ts passes sortOrder and group on create/update
• export-seed.ts exports both fields

Tests:

• All 3257 tests pass
• Migration test updated to include new migration in trailing list

[ahliweb]

✅ Implemented

• Migration 038 created with up/down (idempotent with columnExists guard)
• Collection type includes sortOrder and group fields
• listCollectionsWithFields() orders by sort_order ASC, slug ASC
• Seed apply/create handles both fields
• Export-seed includes these fields
• Backward compatible: existing collections get default sort_order=0

Files changed:

• packages/core/src/database/migrations/038_collection_grouping.ts
• packages/core/src/schema/types.ts
• packages/core/src/schema/registry.ts