1  -- POSTGRES MOCK DATA
 2  
 3  -- Assumes the PEPPER is set to 'stR9qsYTeTavedZ9Kqo34e338apuJj47'
 4  
 5  INSERT INTO login_provider(name)
 6  VALUES ('local');
 7  -- Insert admin account with email: 'pelle.karlsson@test.com' and password: 'asdasd123123'
 8  INSERT INTO whitelist(email, login_provider)
 9  VALUES ('pelle.karlsson@test.com', 'local');
10  INSERT INTO account(id, first_name, last_name, authority)
11  VALUES (
12          'a87a5aa2-b4dd-484e-854f-9db54b119d87',
13          'Pelle',
14          'Karlsson',
15          'admin'
16      );
17  INSERT INTO login_details(
18          account_id,
19          email,
20          activated_at,
21          password,
22          password_nonces
23      )
24  VALUES (
25          'a87a5aa2-b4dd-484e-854f-9db54b119d87',
26          'pelle.karlsson@test.com',
27          '1990-01-01',
28          '354AF1C88A9BBBC6B6E1E2A9E67FB6F7B25739A9284A5C1861619151C62FFDA0B571DF34939C00D7C32E2D6FD5F753919A241914F08F23923F628FA71900BE1536DEBC4AB1E69D9F2EAF5A58983CC9087126A5DB7350DAF4BFA97A527716A1F658CC0655A8340954D2E74DBF210B62BFD4',
29          'DF69D5A22F0B0178D3561346'
30      );
31  -- Insert standard account with email: 'karl.larsson@pleasedontbeavaliddomain.com' and password 'password123'
32  INSERT INTO whitelist(email, login_provider)
33  VALUES (
34          'karl.larsson@pleasedontbeavaliddomain.com',
35          'local'
36      );
37  INSERT INTO account(id, first_name, last_name)
38  VALUES (
39          '4cbeabf3-725b-40af-8d04-2b61ca9534b4',
40          'Karl',
41          'Larsson'
42      );
43  INSERT INTO login_details(
44          account_id,
45          email,
46          activated_at,
47          password,
48          password_nonces
49      )
50  VALUES(
51          '4cbeabf3-725b-40af-8d04-2b61ca9534b4',
52          'karl.larsson@pleasedontbeavaliddomain.com',
53          '2022-08-08 10:49:10.48415+00',
54          '6B2BB4DC9D60E687E63787024A7DB306C3B0FFF7B0A938C4E19C4E79E4AE48A3A59462A12DEA5EC874F0205C71440EF229CFBEDA0C1480C13781FC7CD2F1C91014E888813B5C04006E65808481221CE70D08D89921FD99EC3E13D813AA1BC70920BD907576C7A7E6C2065313B313B9D838',
55          '8316690366BFA8B8CE670987'
56      );
57  
58  -- Insert oauth client with client_id: 'client_id' and client_secret: 'secret'
59  INSERT INTO oauth_client(id, client_id, client_secret, client_name, redirect_uri)
60  VALUES (
61      'a58b3dae-91d9-46a3-971b-a6cda3e8f3f5',
62      'client_id',
63      'secret',
64      'Mock client name',
65      'http://localhost:3001/auth/callback'
66  )