2023/04/28 4:42

--
--  `post`
--

CREATE TABLE `post` (
  `id` bigint(20) NOT NULL,
  `title` text NOT NULL DEFAULT current_timestamp(),
  `content` longtext NOT NULL,
  `slug` varchar(64) NOT NULL,
  `time_created` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `time_modified` timestamp NULL DEFAULT NULL,
  `status` varchar(16) NOT NULL DEFAULT 'draft'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Error

#1067 – Invalid default value for ‘title’

Solution

SET SQL_MODE=’ALLOW_INVALID_DATES’;

If it doesn’t work, set your default date field as NULL.