whois-band/app/lib/db.server.ts, branch master

Add lists feature (band recommendation lists with history)

2026-05-10T15:06:52+00:00

New lists, list_entries, list_revisions tables; full CRUD routes under /lists; nav link in root.

Co-Authored-By: Claude Sonnet 4.6

Add band index page sorted by slug, show hiatus status only

2026-05-10T13:56:42+00:00

Co-Authored-By: Claude Sonnet 4.6

Separate current/former members with calculable period dates

2026-05-10T13:46:59+00:00

- Add MemberGroup/BandGroup types and groupBandMembers/groupArtistMembers helpers
- Calculate membership duration in months from YYYY-MM since/until values
- Band view splits members into 在籍中 / 元メンバー sections with duration label
- Artist view splits bands into 在籍中 / 元在籍 sections with duration label
- Change since/until inputs to type="month" for structured data entry

Co-Authored-By: Claude Sonnet 4.6

Add members table with membership period and note support

2026-05-09T15:21:04+00:00

Replace band_artists + member_periods with a single members table
(id, band_id, artist_id, role, since, until, note, order_index).
Each row represents one membership period, so rejoining artists
get multiple rows. Existing band_artists data is auto-migrated on
startup. Export format bumped to version 3.

Co-Authored-By: Claude Sonnet 4.6

Add /api/export and /api/import endpoints for DB backup and sync

2026-05-09T05:36:28+00:00

Co-Authored-By: Claude Sonnet 4.6

Add band description/status fields and redesign index page

2026-05-08T15:46:32+00:00

- bands table: add description (TEXT) and status (TEXT DEFAULT 'active')
  via ALTER TABLE migrations (active / hiatus / disbanded)
- Home page: minimal monochrome index listing name, area, status
- Band detail: show description below title, status alongside area
- Band new/edit forms: textarea for description, select for status

Co-Authored-By: Claude Sonnet 4.6

Fix Docker startup: add package.json to app stage, respect DB_PATH

2026-05-08T15:38:42+00:00

npm start requires package.json in the working directory. Also wire
up the DB_PATH env var so the DB is created inside the mounted volume.

Co-Authored-By: Claude Sonnet 4.6

Implement band/artist management with version history

2026-05-08T15:27:19+00:00

Full CRUD for bands and artists: UUID + slug URLs, dynamic link
editor, band-artist associations with roles, per-edit revision
snapshots (message + IP). Add README and CLAUDE.md.

Co-Authored-By: Claude Sonnet 4.6

Initial scaffold: React Router v7 + SQLite + Tailwind CSS v4

2026-05-08T14:37:51+00:00