Mysql mariadb where is the error?

Question

MySQL

Good afternoon, please help me fix an error in a database query, mariadb is hosted, and it swears at a sql query from another system (rather normal mysql).

The request itself:

CREATE TABLE `towers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `bet` double(255,2) NOT NULL,
  `bombs` int(11) NOT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `field` json NOT NULL,
  `revealed` json NOT NULL,
  `coeff` double(255,2) NOT NULL DEFAULT '0.00',
  `status` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Mistake:

#1064 - У вас ошибка в запросе. Изучите документацию по используемой версии MariaDB на предмет корректного синтаксиса около 'json NOT NULL,
  `revealed` json NOT NULL,
  `coeff` double(255,2) NOT NULL DE' на строке 11

Answer 1

MariaDB 10.2 supported JSON. (Alpha version. Not recommended by Maria to production server. Only testing.)
MariaDB 10.1 do not support JSON
Check the version of mariadb on your hosting.

Answer 2

I don’t know about mariadb at all,
but varchar can have default 'something literal (in quotes)'
and int, double must still have values ​​of the corresponding types, not strings of characters