DTQuiz - Online Quiz Flutter App | Trivia Quiz | Quiz Game | Android | iOS | Admin Panel 2 September 2023

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

--
-- Table structure for table `tbl_one_to_one_leaderboard`
--

CREATE TABLE `tbl_one_to_one_leaderboard` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `room_id` varchar(255) NOT NULL,
  `winning_amount` varchar(255) NOT NULL DEFAULT '0',
  `w_user_id` int(11) NOT NULL,
  `l_user_id` int(11) NOT NULL,
  `status` int(11) NOT NULL COMMENT '0- Draw , 1- Completed , 2- Not Completed',
  `date` date NOT NULL DEFAULT current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

MySQL return：error
#1067 - Invalid default value for 'date'