CREATE TABLE `phone_verification` (
  `pv_id` int(11) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `otp` varchar(10) DEFAULT NULL,
  `is_verified` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `phone_verification`
  ADD PRIMARY KEY (`pv_id`);

ALTER TABLE `phone_verification`
  MODIFY `pv_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;