HERAKLES Otomatik Avlı kalıcı sunucu. 19 Haziran'da açılıyor. Atius & Wizard güvencesiyle hemen kayıt ol, ön kayıt ödülleri aktif. HEMEN TIKLA!
Hi i have a problem .. when i want to run dis db.sql in navicat
https://forum.turkmmo.com/konu/3774449-official-item-shop-v3/
this is the error
[Err] 1067 - Invalid default value for 'date'
[Err] -- --------------------------------------------------------
--
-- Table structure for table `history`
--
CREATE TABLE `history` (
`id` int(11) NOT NULL,
`account` int(11) NOT NULL,
`date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`item` int(11) NOT NULL,
`taken` int(1) NOT NULL DEFAULT '1',
`pay_type` int(1) NOT NULL,
`coins` int(11) NOT NULL,
`type` int(1) NOT NULL DEFAULT '1',
`from_account` int(11) NOT NULL DEFAULT '0',
`to_player` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
https://pastebin.pl/view/57b68cd0
https://forum.turkmmo.com/konu/3774449-official-item-shop-v3/
this is the error
[Err] 1067 - Invalid default value for 'date'
[Err] -- --------------------------------------------------------
--
-- Table structure for table `history`
--
CREATE TABLE `history` (
`id` int(11) NOT NULL,
`account` int(11) NOT NULL,
`date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
`item` int(11) NOT NULL,
`taken` int(1) NOT NULL DEFAULT '1',
`pay_type` int(1) NOT NULL,
`coins` int(11) NOT NULL,
`type` int(1) NOT NULL DEFAULT '1',
`from_account` int(11) NOT NULL DEFAULT '0',
`to_player` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
https://pastebin.pl/view/57b68cd0
