Tukxi Ride

CREATE TABLE `ridedoot_mine`.`driver_rider_otp_verification` (
`iOtpVerifyId` INT NOT NULL AUTO_INCREMENT COMMENT ' ',
`vUserType` ENUM NULL,
`vVerificationId` VARCHAR NULL,
`vDeviceId` VARCHAR NULL,
`dCreatedAt` DATETIME NOT NULL DEFAULT now(),
PRIMARY KEY (`iOtpVerifyId`));

ALTER TABLE `ridedoot_mine`.`driver_rider_otp_verification`
CHANGE COLUMN `iOtpVerifyId` `iVerifyId` INT NOT NULL AUTO_INCREMENT COMMENT ' ' ;

Please ignore previous Query for Create

CREATE TABLE `device_otp_verification` (
`iVerifyId` int NOT NULL AUTO_INCREMENT COMMENT ' ',
`vUserType` enum('rider','passanger') DEFAULT NULL,
`vOtpVerificationId` varchar(100) DEFAULT NULL,
`vDeviceId` varchar(50) DEFAULT NULL,
`dCreatedAt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`iVerifyId`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

1, When the user logged in with one device,the same user logged in with the another device the previously logged device is not expiring(session out)
ER:when the user user logged in with the another device the previously logged device should session out
AR:Previously logged device is not getting expired.

2,In otp page, when we click on verify for the first time it will not redirected,only on the second click it navigates to the next page.
ER:It should navigate to the next page while clicking verify for the first time
AR:It is not navigated to the corresponding page. -Fixed

for Developer : change include 'assets/plugins/ckfinder/core/connector/php/vendor/autoload.php'; on common.php

Revamp signup process with enhanced security measures. failed in falcon

Case Sometimes OTP is not received Failed