summaryrefslogtreecommitdiff
path: root/app/lib/db.server.ts
AgeCommit message (Collapse)AuthorLines
7 daysAdd lists feature (band recommendation lists with history)yyamashita-0/+150
New lists, list_entries, list_revisions tables; full CRUD routes under /lists; nav link in root. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
7 daysAdd band index page sorted by slug, show hiatus status onlyyyamashita-1/+1
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
7 daysSeparate current/former members with calculable period datesyyamashita-0/+80
- 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 <noreply@anthropic.com>
8 daysAdd members table with membership period and note supportyyamashita-68/+107
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 <noreply@anthropic.com>
8 daysAdd /api/export and /api/import endpoints for DB backup and syncyyamashita-0/+119
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
9 daysAdd band description/status fields and redesign index pageyyamashita-4/+21
- 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 <noreply@anthropic.com>
9 daysFix Docker startup: add package.json to app stage, respect DB_PATHyyamashita-1/+1
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 <noreply@anthropic.com>
9 daysImplement band/artist management with version historyyyamashita-20/+368
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 <noreply@anthropic.com>
9 daysInitial scaffold: React Router v7 + SQLite + Tailwind CSS v4yyamashita-0/+45