Add Account

mail@pastecode.io avatar
unknown
sql
a year ago
670 B
3
Indexable
INSERT INTO M_USERS (USER_ID, ACCOUNT_EXPIRED, ACCOUNT_LOCKED, CREDENTIALS_EXPIRED, ACCOUNT_ENABLED, NIP, PASSWORD, REAL_NAME, USER_NAME, VERSION, BRANCH_ID, CREATED_BY, CREATED_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, KODE_DIVISI,USER_EMAIL, IS_ACCEPT_EMAIL, TYPE)
VALUES(3000, 0, 0, 0, 1, '3000', '3000', 'Mega Nurhayani', '3000', 414, 100, '3005', '2023-01-05-07.54.47.250000', '3005', '2023-01-05-07.54.47.250000', 716, 'mega.nurhayani@asuransijasindo.co.id', 0, 0)
INSERT INTO USER_ROLE (USER_ID, ROLE_ID)
VALUES(3000, 1256677650) -- ALL_MENU
INSERT INTO USER_ROLE (USER_ID, ROLE_ID)
VALUES(3000, 1)
INSERT INTO USER_ROLE (USER_ID, ROLE_ID)
VALUES(3000, 10)