Cardano Updates

- Remove schema and table existence checks
- Always restore when SNAPSHOT_RESTORE_ENABLED=true
- Clean up old snapshots before downloading new one
- Clean up downloaded snapshots after successful restore
- Simpler flow: download -> validate -> restore -> cleanup

- Remove SNAPSHOT_DIR from workflow (container handles paths)
- Change docker-compose to docker compose (modern syntax)
- Remove cleanup-and-summary job (container does everything)
- Remove unset SNAPSHOT_DIR hack (no longer needed)
- Simplified to 3 jobs: detect-network, check-sync, create-snapshot
- All snapshot logic stays in container where it belongs

- Workflow-level SNAPSHOT_DIR was overriding container environment
- Container needs SNAPSHOT_DIR=/snapshots (from env file)
- Workflow needs SNAPSHOT_DIR=/opt/... (for host cleanup)
- Unset before docker-compose so container uses correct path

- Change all jobs to use runs-on: [snapshot-build]
- Preprod runner: snapshot-build, preprod-server-colo2
- Mainnet runner: snapshot-build, snapshot-server-colo2
- Workflow automatically runs on correct server based on detected network
- Single workflow file works for both preprod and mainnet

- Move snapshot storage from git repo to /opt/cardano-rosetta-java-snapshots
- Update docker-compose volume mount to use /opt path
- Update workflow SNAPSHOT_DIR to /opt path
- Remove SNAPSHOT_PATH from env file (use docker-compose default)
- Better separation: code in /home, data in /opt

- Fix SNAPSHOT_DIR in .env.docker-compose-preprod to /snapshots (container path)
- Fix SNAPSHOT_DIR in workflow to actual host path
- Ensures snapshots are written to mounted volume and persist on host

- Add detect-network job to auto-detect network from Docker networks
- Dynamically select env file based on network (mainnet vs others)
- Update all jobs to use detected network configuration
- Workflow now works for mainnet, preprod, preview automatically
- Renamed workflow to "Cardano Snapshot Creation"

- Simplified create-snapshot.sh to query DB for block number
- Script now generates checksum and metadata inside container
- Removed sync check and pause/resume from script (now in workflow)
- Simplified workflow from 5 jobs to 3 jobs
- Use docker-compose command instead of complex docker run
- Cleaner separation: workflow orchestrates, container executes