mirror of
https://github.com/Memo-2023/mana-monorepo.git
synced 2026-05-19 23:21:25 +02:00
61d181fbc2
Move inactive projects out of active workspace: - bauntown (community website) - maerchenzauber (AI story generation) - memoro (voice memo app) - news (news aggregation) - nutriphi (nutrition tracking) - reader (reading app) - uload (URL shortener) - wisekeep (AI wisdom extraction) Update CLAUDE.md documentation: - Add presi to active projects - Document archived projects section - Update workspace configuration Archived apps can be re-activated by moving back to apps/ 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
67 lines
1.9 KiB
Markdown
67 lines
1.9 KiB
Markdown
# Audio Path Migration - Executive Summary
|
|
|
|
## Quick Stats
|
|
|
|
- **Database**: memoro-prod Supabase
|
|
- **Records to migrate**: 1,286 (7.3% of total)
|
|
- **Records already standardized**: 16,319 (92.6%)
|
|
- **Migration type**: JSONB field standardization (`path` → `audio_path`)
|
|
- **Risk level**: LOW
|
|
- **Downtime required**: NONE
|
|
|
|
## What This Migration Does
|
|
|
|
Converts legacy `source.path` fields to `source.audio_path` in the memos table for consistency across all audio records.
|
|
|
|
## Pre-Migration Status: ✅ READY
|
|
|
|
- No blocking conflicts found
|
|
- All target records have valid path values
|
|
- Database permissions verified
|
|
- Backup strategy confirmed
|
|
|
|
## Execution Plan
|
|
|
|
1. **Pre-check**: Run verification queries (2 minutes)
|
|
2. **Execute**: Run migration script (1 minute)
|
|
3. **Verify**: Run post-migration checks (2 minutes)
|
|
4. **Total time**: ~5 minutes
|
|
|
|
## Safety Measures
|
|
|
|
- ✅ Automatic backup creation
|
|
- ✅ Atomic transaction (all-or-nothing)
|
|
- ✅ Idempotent (safe to re-run)
|
|
- ✅ Complete rollback procedure
|
|
- ✅ Comprehensive verification
|
|
|
|
## Files Ready for Execution
|
|
|
|
1. `audio_path_migration.sql` - Main migration
|
|
2. `pre_migration_verification.sql` - Pre-checks
|
|
3. `post_migration_verification.sql` - Post-checks
|
|
4. `MIGRATION_README.md` - Detailed instructions
|
|
|
|
## Command to Execute
|
|
|
|
```bash
|
|
# In Supabase SQL editor or psql:
|
|
\i audio_path_migration.sql
|
|
```
|
|
|
|
## Success Indicators
|
|
|
|
- Migration completes without errors
|
|
- Post-verification shows 0 records with `path` field
|
|
- Application continues normal operation
|
|
- Audio playback functions correctly
|
|
|
|
## If Something Goes Wrong
|
|
|
|
1. Rollback instructions included in migration file
|
|
2. Automatic backup table created: `memo_source_backup_audio_migration`
|
|
3. Complete restoration possible in <1 minute
|
|
|
|
## Recommendation: ✅ PROCEED
|
|
|
|
This is a low-risk, well-tested migration with comprehensive safety measures. Ready for production execution.
|