driver.sql 6.91 KB

Edit Raw Blame History

INSERT INTO `driver` (`id`, `name`, `identity_card`, `company_id`, `professional_qualification_begin_date`, `professional_qualification_end_date`, `driving_licence_begin_date`, `driving_licence_end_date`, `safety_training_date`, `safety_training_content`, `remark`, `driving_licence`, `professional_qualification`, `safety_training`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `photograph_one`, `photograph_two`, `phoneNo`) VALUES (1, '吴梦浩', '1', 3, '2023-11-15', '2023-12-01', '2023-11-07', '2023-11-03', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `driver` (`id`, `name`, `identity_card`, `company_id`, `professional_qualification_begin_date`, `professional_qualification_end_date`, `driving_licence_begin_date`, `driving_licence_end_date`, `safety_training_date`, `safety_training_content`, `remark`, `driving_licence`, `professional_qualification`, `safety_training`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `photograph_one`, `photograph_two`, `phoneNo`) VALUES (2, '钟超', '1', 3, '2023-10-31', '2023-12-02', '2023-10-30', '2023-12-01', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `driver` (`id`, `name`, `identity_card`, `company_id`, `professional_qualification_begin_date`, `professional_qualification_end_date`, `driving_licence_begin_date`, `driving_licence_end_date`, `safety_training_date`, `safety_training_content`, `remark`, `driving_licence`, `professional_qualification`, `safety_training`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `photograph_one`, `photograph_two`, `phoneNo`) VALUES (3, '鼠标', '2', 3, '2023-11-13', '2023-12-10', '2023-11-02', '2023-12-08', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `driver` (`id`, `name`, `identity_card`, `company_id`, `professional_qualification_begin_date`, `professional_qualification_end_date`, `driving_licence_begin_date`, `driving_licence_end_date`, `safety_training_date`, `safety_training_content`, `remark`, `driving_licence`, `professional_qualification`, `safety_training`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `photograph_one`, `photograph_two`, `phoneNo`) VALUES (4, '萨芬', '123', 4, '2023-11-08', '2023-12-02', '2023-11-02', '2023-12-02', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `driver` (`id`, `name`, `identity_card`, `company_id`, `professional_qualification_begin_date`, `professional_qualification_end_date`, `driving_licence_begin_date`, `driving_licence_end_date`, `safety_training_date`, `safety_training_content`, `remark`, `driving_licence`, `professional_qualification`, `safety_training`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `photograph_one`, `photograph_two`, `phoneNo`) VALUES (5, '前往', '23', 4, '2023-11-01', '2023-12-01', '2023-11-01', '2023-12-09', '2023-11-15', 'fasdfasdfasdfasdf', 'fasdfasdfa sdfasdfasdasdfasdfasdfasdfasd', '/profile/upload/1701066190881/烦烦烦.pdf', '/profile/upload/1701066190884/3.doc', '/profile/upload/1701066190885/亚索灵魂莲华.jpg', NULL, NULL, NULL, '2023-11-27 14:23:11', 'abc', '/profile/upload/1701066190889/微信图片_20230612163108.png', '/profile/upload/1701066190891/雪山.jpeg', NULL);
INSERT INTO `driver` (`id`, `name`, `identity_card`, `company_id`, `professional_qualification_begin_date`, `professional_qualification_end_date`, `driving_licence_begin_date`, `driving_licence_end_date`, `safety_training_date`, `safety_training_content`, `remark`, `driving_licence`, `professional_qualification`, `safety_training`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `photograph_one`, `photograph_two`, `phoneNo`) VALUES (6, '兔兔兔兔', '123123123123123', 3, '2023-11-10', '2023-11-24', '2023-11-01', '2023-11-27', '2023-11-23', '213123发射点发射点', '反对发射点发射点', '/profile/upload/1701064417806/4.doc', '/profile/upload/1701064417811/2.doc', '/profile/upload/1701064417815/雪山.jpeg', 0, '2023-11-27 13:53:38', 'abc', '2023-11-27 14:07:08', 'abc', '/profile/upload/1701064417819/亚索灵魂莲华.jpg', '/profile/upload/1701064417912/微信图片_20230612163108.png', '18977778888');
INSERT INTO `driver` (`id`, `name`, `identity_card`, `company_id`, `professional_qualification_begin_date`, `professional_qualification_end_date`, `driving_licence_begin_date`, `driving_licence_end_date`, `safety_training_date`, `safety_training_content`, `remark`, `driving_licence`, `professional_qualification`, `safety_training`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `photograph_one`, `photograph_two`, `phoneNo`) VALUES (7, '测试', '撒旦发射点发', 7, '2023-11-27', '2023-11-27', '2023-11-27', '2023-11-27', '2023-11-27', '12312发射点发射点', '撒旦发射点发射点发射点', '/profile/upload/1701075167796/4.doc', '/profile/upload/1701075167798/雪山.jpeg', '/profile/upload/1701075167800/冰川.jpg', 0, '2023-11-27 16:52:48', 'abc', NULL, NULL, '/profile/upload/1701075167803/亚索灵魂莲华.jpg', '/profile/upload/1701075167805/冰川.jpg', NULL);
INSERT INTO `driver` (`id`, `name`, `identity_card`, `company_id`, `professional_qualification_begin_date`, `professional_qualification_end_date`, `driving_licence_begin_date`, `driving_licence_end_date`, `safety_training_date`, `safety_training_content`, `remark`, `driving_licence`, `professional_qualification`, `safety_training`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `photograph_one`, `photograph_two`, `phoneNo`) VALUES (8, 'fsdafasd', '12312312', 7, '2023-11-21', '2023-11-29', '2023-11-14', '2023-11-09', '2023-11-21', '12312', 'sadfasdfasdf', '/profile/upload/1701221196934/烦烦烦.pdf', '/profile/upload/1701221196936/4.doc', '/profile/upload/1701221196938/烦烦烦.pdf;/profile/upload/1701221196940/山.jpeg;/profile/upload/1701221196943/微信图片_20230612163108.png', 0, '2023-11-29 09:26:36', 'abc', NULL, NULL, '/profile/upload/1701221196945/4.doc', '/profile/upload/1701221196947/山.jpeg', NULL);
INSERT INTO `driver` (`id`, `name`, `identity_card`, `company_id`, `professional_qualification_begin_date`, `professional_qualification_end_date`, `driving_licence_begin_date`, `driving_licence_end_date`, `safety_training_date`, `safety_training_content`, `remark`, `driving_licence`, `professional_qualification`, `safety_training`, `status`, `create_time`, `create_by`, `update_time`, `update_by`, `photograph_one`, `photograph_two`, `phoneNo`) VALUES (9, '驾驶员1', '12312312312', 3, '2023-12-08', '2023-12-13', '2023-12-15', '2023-12-05', '2023-12-06', '1231231', '2312312', '/profile/upload/1701411713062/雪山.jpeg', '/profile/upload/1701411713066/山.jpeg', '/profile/upload/1701411713070/3.doc', 0, '2023-12-01 14:21:53', 'abc', NULL, NULL, '/profile/upload/1701411713072/亚索灵魂莲华.jpg', '/profile/upload/1701411713076/亚索灵魂莲华.jpg', '13111111111');