JHipster Default Data in SQL format

data-h2.sql

--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');