malucooo/otxserver-new problem with schema.sql

[Tehaceria Ots]

Hello someone meybe use
malucooo/otxserver-new (https://github.com/malucooo/otxserver-new)
I have problem with schema.sql

Błąd
Zapytanie SQL:




-- --------------------------------------------------------

--
-- Estrutura da tabela `account_character_sale_history`
--

CREATE TABLE `account_character_sale_history` (
  `id` int(11) NOT NULL,
  `id_old_account` int(11) DEFAULT NULL,
  `id_player` int(11) DEFAULT NULL,
  `id_new_account` int(11) DEFAULT NULL,
  `price_type` tinyint(1) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `char_id` int(11) DEFAULT NULL,
  `dta_insert` datetime NOT NULL DEFAULT current_timestamp(),
  `dta_sale` datetime DEFAULT NULL,
  `extornada` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
MySQL zwrócił komunikat: Dokumentacja

#1067 - Invalid default value for 'dta_insert'

 

[Evil Puncker]

try changing:

`dta_insert` datetime NOT NULL DEFAULT current_timestamp(),

to:
`dta_insert` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

 

[Tehaceria Ots]

try changing:

`dta_insert` datetime NOT NULL DEFAULT current_timestamp(),

to:
`dta_insert` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

still the same ;/