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.

.gitlab-ci.yml

@@ -87,9 +87,10 @@ unittests-mysql-5:
       command: ["--default-authentication-plugin=mysql_native_password"]
 
   script:
-    # remove autotap because the checks of (autogenerated) names of constraints
-    # and the checks of column default values don't work with mysql
-    - rm tests/test_autotap.sql
+    # remove some lines from autotap because the checks of column default
+    # values don't work with mysql-5
+    - sed -i "/col_default_is.*NULL/d" tests/test_autotap.sql
+    - sed -i "/col_default_is.*INACTIVE/d" tests/test_autotap.sql
     - make pipeline-test SQL_HOST=mysql
 
 ######## Deploy ########