10 lines
2.2 KiB
SQL
10 lines
2.2 KiB
SQL
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U001','admin','admin123','D001','行政部','P001','系统管理员','admin@company.com','13800138001','2024-01-01');
|
|
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U002','zhang_s','prod123','D002','生产部','P002','生产经理','zhang_s@company.com','13900139002','2024-01-05');
|
|
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U003','li_j','equip123','D002','生产部','P003','设备工程师','li_j@company.com','13700137003','2024-01-10');
|
|
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U004','wang_q','qual123','D003','质检部','P004','质检员','wang_q@company.com','13600136004','2024-01-15');
|
|
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U005','zhao_l','purc123','D004','采购部','P005','采购员','zhao_l@company.com','13500135005','2024-01-20');
|
|
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U006','liu_g','ware123','D005','物流部','P006','仓库管理员','liu_g@company.com','13400134006','2024-01-25');
|
|
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U007','sun_m','tech123','D006','技术部','P007','研发工程师','sun_m@company.com','13300133007','2024-02-01');
|
|
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U008','zhou_h','hum123','D007','人事部','P008','人事专员','zhou_h@company.com','13200132008','2024-02-05');
|
|
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U009','wu_f','fin123','D008','财务部','P009','财务会计','wu_f@company.com','13100131009','2024-02-10');
|
|
INSERT INTO `crpm_e5a3ec_5755bf` (`yh_i_d`,`yhm`,`mm`,`bm_i_d`,`bmmc`,`zw_i_d`,`zwmc`,`yx`,`sjh`,`rzrq`) VALUES ('U010','zheng_w','safe123','D009','安环部','P010','安全主管','zheng_w@company.com','13000130010','2024-02-15'); |