ichat_import_users.1.2.8.sql 369 B

1234
  1. insert into doctors(id, name, sex, birthdate, avatar, level, locked) select code, name, sex, birthday, photo, level, 0 from wlyy.wlyy_doctor;
  2. insert into patients(id, name, sex, birthdate, avatar) select distinct code, name, sex, birthday, photo from wlyy.wlyy_patient;
  3. insert into sync_log(event, last_sync_time, succeed, message) values('user_sync', now(), 1, 'ok');