bootstrap_data.sql
1007 Bytes
INSERT INTO Role (id, name) VALUES(1, "Adminrolle");
INSERT INTO Role_rights (Role_id, rights) VALUES(1, "ADMIN");
INSERT INTO Profile (id, role_id, username, mailaddress, hashAlgorithm, passwordHash, salt) VALUES (2, 1, "admin", "chuck.norris@roundhouse.kick", "SHA512", "JeuPx1++vnOSp/rdDwjnPwNIldN49UhtJEwUcKr3ksTvu/3s6nmnWbh+mkjfsw41w1LE8VJJAukn+LpfnUybzg==", "wwUVuetAfN1dtaXk0zWOMmb1nIw=");
INSERT INTO User (id, profile_id, firstname, lastname) VALUES (3, 2, "Chuck", "Norris");
INSERT INTO Role (id, name) VALUES(4, "Benutzerrolle");
INSERT INTO Role_rights (Role_id, rights) VALUES(4, "USER");
INSERT INTO Profile (id, role_id, username, mailaddress, hashAlgorithm, passwordHash, salt) VALUES (5, 4, "user", "bruce.lee@chacha.cha", "SHA512", "iXFejEGFcJJ50cQKEZNUqHtZc50eXyyJgU6iB2SsDRVAWhNltuT+r3VIJuqsk++Zd49X3LSOpAbxnDMF7Olgrg==", "FrG5XPKM89c1e5DXH+z1VnS/1OE=");
INSERT INTO User (id, profile_id, firstname, lastname) VALUES (6, 5, "Bruce", "Lee");
UPDATE hibernate_sequence SET next_val = 7;