EHN: Add new base schema (db_5_0.sql) for installation

Summary

#32 (closed)

The Schema had once (until 2016 A.D.) a table named "groups" which is a keyword since MySQL 8. It is not part of the currenty schema (v5.0.0) anymore, but it has been created (as part of schema (v.2.0.1) and then been removed again in a patch from 2016-04. This is why the installation fails on MySQL 8 (and will likely fail on future MariaDB versions).

This MR adds a new schema installer (on the basis of our schema v5.0.0, without the groups table) and removes tables and functions which turned out to be unused during the review of the new db_5_0.sql file.

Focus

Obviously, there is not much really changing here. The new db_5_0.sql which replaces db_2_0.sql is just a dump of fresh installation with the old installer. A few tweaks had to be made (order of table creation and some tweaks to set some INT UNSINGED AUTOINCREMENT values to zero).

Just note that

• the function retrieveGroup was referencing the (deleted) groups table.
• the table logging is an unused remnant of a never-finished logging persistence functionality (We use a proper logging framework now, which has its own persistence functionality).

Test Environment

No manual testing required. Just make sure that the complete pipeline succeeds (mysqlbackend, deploy, pyinttests)

Check List for the Author

Please, prepare your MR for a review. Be sure to write a summary and a focus and create gitlab comments for the reviewer. They should guide the reviewer through the changes, explain your changes and also point out open questions. For further good practices have a look at our review guidelines

• All automated tests pass
• Reference related Issues
• Up-to-date CHANGELOG.md
• Annotations in code (Gitlab comments)
  • Intent of new code
  • Problems with old code
  • Why this implementation?

Check List for the Reviewer

• I understand the intent of this MR
• All automated tests pass
• Up-to-date CHANGELOG.md
• The test environment setup works and the intended behavior is reproducible in the test environment
• In-code documentation and comments are up-to-date.
• Check: Are there specifications? Are they satisfied?

For further good practices have a look at our review guidelines.

tests/test_autotap.sql

@@ -2691,13 +2691,6 @@ SELECT tap.procedure_is_deterministic('_caosdb_schema_unit_tests','retrieveEntit
 SELECT tap.procedure_security_type_is('_caosdb_schema_unit_tests','retrieveEntityParents','DEFINER','');
 SELECT tap.procedure_sql_data_access_is('_caosdb_schema_unit_tests','retrieveEntityParents','CONTAINS SQL','');
 
--- PROCEDURES _caosdb_schema_unit_tests.retrieveGroup
-
-SELECT tap.has_procedure('_caosdb_schema_unit_tests','retrieveGroup','');
-SELECT tap.procedure_is_deterministic('_caosdb_schema_unit_tests','retrieveGroup','NO','');
-SELECT tap.procedure_security_type_is('_caosdb_schema_unit_tests','retrieveGroup','DEFINER','');
-SELECT tap.procedure_sql_data_access_is('_caosdb_schema_unit_tests','retrieveGroup','CONTAINS SQL','');
-
 -- PROCEDURES _caosdb_schema_unit_tests.setPassword
 
 SELECT tap.has_procedure('_caosdb_schema_unit_tests','setPassword','');