Sample database cannot be imported

[RCheesley]

Hi folks!

php_version: 7.3
webserver_type: apache-fpm
mariadb_version: 10.2, using utf8mb4_general_ci

Checked out the default branch locally and attempting to set up the sample database in portal/database as instructed in the readme, by importing the provided file portal/database/installation/volunteers.joomla.org.sql.

I am encountering some errors during the import, thought it would be helpful to raise this as an issue in case someone has the time to address it :)

4 errors were found during analysis.

Unexpected character. (near "\" at position 683)
A comma or a closing bracket was expected. (near "''" at position 131)
Unexpected beginning of statement. (near "11" at position 153)
Unrecognized statement type. (near "NOT NULL" at position 190)
SQL query: Copy

CREATE TABLE `vol_assets` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '' PRIMARY KEY'', `parent_id` INT(11) NOT NULL DEFAULT ''0'' COMMENT ''Nested SET parent.'', `lft` INT(11) NOT NULL DEFAULT ''0'' COMMENT ''Nested SET lft.'', `rgt` INT(11) NOT NULL DEFAULT ''0'' COMMENT ''Nested SET rgt.'', `level` INT(10) UNSIGNED NOT NULL COMMENT '' The cached LEVEL IN the nested tree.'', `name` VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '' The UNIQUE NAME FOR the asset.\n'', `title` VARCHAR(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '' The descriptive title FOR the asset.'', `rules` VARCHAR(5120) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '' JSON encoded access control.'', PRIMARY KEY (`id`), UNIQUE KEY `idx_asset_name` (`name`), KEY `idx_lft_rgt` (`lft`, `rgt`), KEY `idx_parent_id` (`parent_id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''',
  `parent_id` INT(11)                                  NOT NULL DEFAULT '...' at line 3