Add new SQL validation functions in the VerA definition to DBs

[kuzdogan]

Add the changes done in verifier-alliance/database-specs#24 as well as the upcoming changes with verifier-alliance/database-specs#25 to DBs.

Do this for:

• feat(compiled_contracts): add database constraints for compilation_artifacts.sources verifier-alliance/database-specs#24
• Adding artifacts, transformations and values constraints verifier-alliance/database-specs#25

First:

• Update the git submodule within the Sourcify repo

Then deploy the database definition schema sql on:

• Sourcify staging
• Sourcify production
• VerA staging
• VerA production

and pray there won't be any conflicts.

Also upate all databases above for the data type change of the chain id:

• Update contract_deployments.chain_id type to bigint verifier-alliance/database-specs#29

[kuzdogan]

I think Rim has incorporated the new definition to VerA DB, so maybe double check before that.

We still need to add these new validations and the change of chain_id from numeric to int8 to Sourcify DB ourselves.