fix: Correct migration path for state table

[cjohnhanson]

This corrects the migrations for the new dedicated state table.

Closes #6790

[netlify]

✅ Deploy Preview for meltano canceled.

Name	Link
🔨 Latest commit	0db4473
🔍 Latest deploy log	https://app.netlify.com/sites/meltano/deploys/63321a13c6641f0008567b11

[codecov]

Codecov Report

Merging #6795 (0db4473) into main (3c51298) will decrease coverage by 0.00%.
The diff coverage is 100.00%.

@@            Coverage Diff             @@
##             main    #6795      +/-   ##
==========================================
- Coverage   88.68%   88.67%   -0.01%     
==========================================
  Files         283      283              
  Lines       20471    20471              
  Branches     2024     2024              
==========================================
- Hits        18154    18152       -2     
- Misses       1978     1979       +1     
- Partials      339      340       +1     

Impacted Files	Coverage Δ
src/meltano/core/job_state.py	93.93% <100.00%> (ø)
src/meltano/core/state_service.py	96.66% <100.00%> (ø)
src/meltano/core/state_store.py	85.48% <100.00%> (ø)
tests/meltano/core/test_state_store.py	100.00% <100.00%> (ø)
src/meltano/cli/state.py	88.59% <0.00%> (-1.35%)	⬇️

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[pandemicsyn]

lgtm.