Read more about this resource...
-- --------------------------------------------------------
--
-- 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'
Read the rest of this update entry...
Read the rest of this update entry...
