Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --USER TABLE
- INSERT INTO JHI_USER(ID, LOGIN, PASSWORD_HASH, FIRST_NAME, LAST_NAME, EMAIL, ACTIVATED, LANG_KEY, CREATED_BY, LAST_MODIFIED_BY, CREATED_DATE)
- VALUES(1, 'system', '$2a$10$mE.qmcV0mFU5NcKh73TZx.z4ueI/.bDWbj0T1BYyqP481kGGarKLG', 'System', 'System', 'system@localhost', true, 'EN', 'system', 'system', SYSDATE);
- INSERT INTO JHI_USER(ID, LOGIN, PASSWORD_HASH, FIRST_NAME, LAST_NAME, EMAIL, ACTIVATED, LANG_KEY, CREATED_BY, LAST_MODIFIED_BY, CREATED_DATE)
- VALUES(2, 'anonymoususer', '$2a$10$j8S5d7Sr7.8VTOYNviDPOeWX8KcYILUVJBsYV83Y5NtECayypx9lO', 'Anonymous', 'User', 'anonymous@localhost', true, 'EN', 'system', 'system', SYSDATE);
- INSERT INTO JHI_USER(ID, LOGIN, PASSWORD_HASH, FIRST_NAME, LAST_NAME, EMAIL, ACTIVATED, LANG_KEY, CREATED_BY, LAST_MODIFIED_BY, CREATED_DATE)
- VALUES(3, 'admin', '$2a$10$gSAhZrxMllrbgj/kkK9UceBPpChGWJA7SYIb1Mqo.n5aNLq1/oRrC', 'Administrator', 'Administrator', 'admin@localhost', true, 'EN', 'system', 'system', SYSDATE);
- INSERT INTO JHI_USER(ID, LOGIN, PASSWORD_HASH, FIRST_NAME, LAST_NAME, EMAIL, ACTIVATED, LANG_KEY, CREATED_BY, LAST_MODIFIED_BY, CREATED_DATE)
- VALUES(4, 'user', '$2a$10$VEjxo0jq2YG9Rbk2HmX9S.k1uZBGYUHdUcid3g/vfiEl7lwWgOH/K', 'User', 'User', 'user@localhost', true, 'EN', 'system', 'system', SYSDATE);
- --AUTHORITY TABLE--
- INSERT INTO JHI_AUTHORITY(name) VALUES ('ROLE_USER');
- INSERT INTO JHI_AUTHORITY(name) VALUES ('ROLE_ADMIN');
- --USER_AUTHORITY TABLE--
- INSERT INTO JHI_USER_AUTHORITY(USER_ID, AUTHORITY_NAME) VALUES(1, 'ROLE_ADMIN');
- INSERT INTO JHI_USER_AUTHORITY(USER_ID, AUTHORITY_NAME) VALUES(2, 'ROLE_USER');
- INSERT INTO JHI_USER_AUTHORITY(USER_ID, AUTHORITY_NAME) VALUES(3, 'ROLE_ADMIN');
- INSERT INTO JHI_USER_AUTHORITY(USER_ID, AUTHORITY_NAME) VALUES(3, 'ROLE_USER');
- INSERT INTO JHI_USER_AUTHORITY(USER_ID, AUTHORITY_NAME) VALUES(4, 'ROLE_USER');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement