Split Reference.accession into accession and version
It's a bit annoying that the optional version number is included in the Reference.accession column. For one, it makes querying by just accession (without version) hard.
Plan of action for migration:
-
Add Reference.versioncolumn. #400 -
Update codebase to write versions to Reference.version(in addition toReference.accession). #400 -
Release. -
Populate Reference.versionusingReference.accession. #401 -
Add unique index on Reference.accessionandReference.version. #401 -
Drop unique index on Reference.accession. #401 -
Update codebase to read from Reference.versionand ignore potential versions inReference.accession. #401 -
Update codebase to not write versions to Reference.accession. -
Release. -
Remove versions from Reference.accession. -
Update codebase to remove ignoring potential versions in Reference.accession.