-- Create the `drivers` table
CREATE TABLE `drivers` (
`id_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`full_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`date_of_birth` date DEFAULT NULL,
`contact_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`emergency_contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`years_of_experience` int(11) DEFAULT NULL,
`vehicle_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`vehicle_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`license_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`license_expiry` date DEFAULT NULL,
`vehicle_insurance_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`insurance_expiry` date DEFAULT NULL,
`police_clearance_certificate` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`medical_fitness_certificate` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`background_verification_report` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`road_safety_training_certificate` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`past_traffic_violations` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`remarks` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id_number`),
UNIQUE KEY `contact_number` (`contact_number`),
UNIQUE KEY `vehicle_number` (`vehicle_number`),
UNIQUE KEY `license_number` (`license_number`),
UNIQUE KEY `vehicle_insurance_number` (`vehicle_insurance_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- Insert data into `drivers` table
INSERT INTO `drivers` (`id_number`, `full_name`, `date_of_birth`, `contact_number`, `address`, `emergency_contact`, `years_of_experience`, `vehicle_type`, `vehicle_number`, `license_number`, `license_expiry`, `vehicle_insurance_number`, `insurance_expiry`, `police_clearance_certificate`, `medical_fitness_certificate`, `background_verification_report`, `road_safety_training_certificate`, `past_traffic_violations`, `remarks`) VALUES
('1', 'Rahul Irkar', '1999-12-04', '09370398032', 'Akurdi\r\nNear Akurdi', '9370398032', 5, 'Car', 'MH 14 AW 8055', '4121999404', '2033-10-07', '4121999404', '2033-10-07', '1', '1', '1', '1', 'Not any Till now', '-'),
('2', 'Rahul Gajanan Irkar', '1999-12-04', '4121999404', '656565', '', 0, 'Bus', '', '3653132213', '1313-12-31', '2132161361', '1313-03-31', '0', '0', '0', '0', '', ''),
('1564654', '64654465464', '0000-00-00', '6546514561456', '6465416541', '6546464', 6465465, 'Car', '6546464654654', '6464654654', '4646-05-06', '65464654654', '0000-00-00', '1', '1', '1', '1', '65056', '6506506'),
('116432', 'Rahul Irkar.', '1999-12-04', '9370398032', 'Akurdi\r\nNear Akurdi', '9370398032', 5, 'Car', '.', '.', '2121-02-18', '.', '0000-00-00', '1', '1', '1', '1', '', '');
-- Create the `users` table
CREATE TABLE `users` (
`id` int(11) NOT NULL,
`user_id` varchar(50) NOT NULL,
`password` varchar(255) NOT NULL,
`type` tinyint(4) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
-- Insert data into `users` table
INSERT INTO `users` (`id`, `user_id`, `password`, `type`) VALUES
(1, 'admin', 'password123', 1),
(2, '2', '$2y$10$jBdF2768C4U25B4CtCKXieXMhY2pIFi536.mkrB1sWxsFD/lsPQXG', 0),
(3, '1', '$2y$10$Sk0x.K.qtZ0.0MJnl/.iNeCNWmtq7YSqDO7vsHM5P5puPqOX52pVO', 2),
(4, '1564654', '$2y$10$KUodHkLLmxU4gcOxEeM6c.H4Dde6IfH06gY98E1rOTepdPUaLB8Ka', 2),
(5, '116432', '$2y$10$n.BENIcLXvhI40sFjoAFjubDPshCzOUUYlkNA3bhz.6ANyVN7HXGm', 0);
-- Set AUTO_INCREMENT for `users` table
ALTER TABLE `users`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;