MariaDB: column defaults
The gnusocial is using the implicit defaults for timestamps. This should be changed as MariaDB 10.2+ has the option "explicit_defaults_for_timestamp". So these columns should be defined explicitely as gnusocial is using a default.
modified timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'date this record was modified',