Schema update 97

Created by: tgrego

Requirements

• Filling out the template is required. Any pull request that does not include enough information to be reviewed in a timely manner may be closed at the maintainers' discretion;
• Review the contributing guidelines for this repository; remember in particular:
  • do not modify code without testing for regression
  • provide simple unit tests to test the changes
  • if you change the schema you must patch the test databases as well, see Updating the schema
  • the PR must not fail unit testing

Description

Using one or more sentences, describe in detail the proposed changes. This updates the schema and the api versions to 97.

Latest ontology db patch (patch_95_96_b.sql from https://github.com/Ensembl/ensembl/pull/347) was missing the patch identifier and updated fixtures data and thus erring on test db patching. This has now been fixed and updated to schema 97.

Tests dbs have been patched.

Use case

Describe the problem. Please provide an example representing the motivation behind the need for having these changes in place. Branching for release/96 has happened, so master can move on to 97.

Benefits

If applicable, describe the advantages the changes will have. Allows development and database patches for version 97.

Possible Drawbacks

If applicable, describe any possible undesirable consequence of the changes.

Testing

Have you added/modified unit tests to test the changes? no

If so, do the tests pass/fail?

Have you run the entire test suite and no regression was detected? yes

misc-scripts/ontology/sql/patch_95_96_b.sql

@@ -40,4 +40,8 @@ CREATE INDEX ix_closure_ontology_id ON closure (`ontology_id`);
 
 CREATE INDEX `ix_relation_parent_term_id` ON relation (`parent_term_id`);
 CREATE INDEX `ix_relation_relation_type_id` ON relation (`relation_type_id`);
-CREATE INDEX `ix_relation_ontology_id` ON relation (`ontology_id`);
\ No newline at end of file
+CREATE INDEX `ix_relation_ontology_id` ON relation (`ontology_id`);
+
+-- Patch identifier
+INSERT INTO meta (meta_key, meta_value)
+  VALUES ('patch', 'patch_95_96_b.sql|term_ontology_update');