Backward compatibility database json type

[nick322]

What is the issue?

I found file in "database/migrations/create_settings_table.php.stub"
Line 17

$table->json('payload');

when I run

php artisan vendor:publish --provider="Spatie\LaravelSettings\LaravelSettingsServiceProvider" --tag="migrations"
php artisan migrate

then after show Error

In Connection.php line 712:
--
762 |  
763 | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
764 | n your SQL syntax; check the manual that corresponds to your MySQL server v
765 | ersion for the right syntax to use near 'json not null, `created_at` timest
766 | amp null, `updated_at` timestamp null) default' at line 1 (SQL: create tabl
767 | e `settings` (`id` bigint unsigned not null auto_increment primary key, `gr
768 | oup` varchar(191) not null, `name` varchar(191) not null, `locked` tinyint(
769 | 1) not null, `payload` json not null, `created_at` timestamp null, `updated
770 | _at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode
771 | _ci')
772 |  
773 |  
774 | In Connection.php line 495:
775 |  
776 | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
777 | n your SQL syntax; check the manual that corresponds to your MySQL server v
778 | ersion for the right syntax to use near 'json not null, `created_at` timest
779 | amp null, `updated_at` timestamp null) default' at line 1

because mysql version is 5.6 ...
it not support json type.
So I plan to add version checking. #124

[rubenvanassche]

For future users finding this issue, @nick322's solution is to replace for MySQL 5.6 installations in the settings migration the following line

$table->json('payload');

with:

$table->longText('payload');