Insert manajemen role dan akun untuk marketing mataer kebutuhan data mahasiswa aktif

INSERT ignore INTO oauth_role SET id='S9999', name='TIM SUPPORT AKSES BACA SIAKAD 4.0', parent_id='0', is_supervisor=1;

INSERT into user ( ID, IDPRODI, NAMA, PASSWORD, LASTUPDATE, UPDATER, CSS, IDROLE, SETTINGTAMPILAN, STATUSLOGIN, LASTLOGIN, LASTAKSI, TOKEN, STATUS, FLAGPASSWORD, PENGINGATPASSWORD, PENGINGATBACKUP, LOGINWAKTU, JAM1, JAM2, SALT, D_CSL, D_JURDING, D_PBL, D_PRAKTIKUM, D_TEORI, EMAIL , JABATAN ) VALUES ( 'mataercivitas', '', 'mataercivitas', '3d16dc743402fbaf77bb9166a3d7c933f3272db78dcd599979bf9463ba5f8ebb', NOW(), 'kikicivitas', 'style.php', 'S9999', '', '0', '', '', '', '1', '4', '', '', '', '', '', '4znZc/DWuBlkONR9AUEeY9cDOKOPYy+M', '', '', '', '', '', 'test@gmail.com' , 'Tim Support Siakad 4.0');
replace INTO `oauth_role_scope` (`role_id`, `scope_id`) VALUES
('S9999', 'F3:B');

jika tidak ada field account_id

ALTER TABLE user ADD COLUMN ACCOUNT_ID varchar(50) COMMENT ''`;