[Milestone] 25-Q3 - Misc.

[kuzdogan]

Here are the task that are not as large as a milestone but we are also committing for 2025 Q3

• Sync verified contracts from VerA to Sourcify #2168
• Pull historic data from VerA #2209
• Clarify date of downloaded parquet export files #2212
  - [ ] Test out Solidity with subassemblies output #1859
• Test importing the parquet export #2038
• Server crashes when a compiled contract does not have metadata in the output #2207
• VyperCompilation expecting settings to be required #2197
• Check why the bytecode lengths are changing in the "extra_file_input" bug tests #1947
• Add schema migrations verifier-alliance/database-specs#31
• Contract's onchain creation bytecode is equal to onchain runtime bytecode #1990
• Chain tests fail because of long running binary search #2163
• Unexpected storage layout slot value #2191
• Remix plugin: Use Sourcify API v2 #2157
• "Duplicate key value violates unique constraint" error during verification #2208