data.sql
1.06 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
MERGE INTO authority m
USING (
SELECT
'ROLE_ADMIN' as authority_name
) s
ON
m.authority_name = s.authority_name
WHEN NOT MATCHED THEN
INSERT (authority_name) VALUES (s.authority_name);
MERGE INTO authority m
USING (
SELECT
'ROLE_USER' as authority_name
) s
ON
m.authority_name = s.authority_name
WHEN NOT MATCHED THEN
INSERT (authority_name) VALUES (s.authority_name);
MERGE INTO users m
USING (
SELECT
1 as user_id,
true as activated,
'sangkiham' as nickname,
'$2a$10$nyHQj.Nj2tID4UzIkd1/SuMeYwlKaaHT8Gi3Wgg2x/h9K9qLQciLO' as password,
'sangkiham' as username
) s
ON
m.user_id = s.user_id
WHEN NOT MATCHED THEN
INSERT (user_id, activated, nickname, password, username) VALUES (s.user_id, s.activated, s.nickname, s.password, s.username);
MERGE INTO user_authority m
USING (
SELECT
1 as user_id,
'ROLE_ADMIN' as authority_name
) s
ON
m.user_id = s.user_id
and m.authority_name = s.authority_name
WHEN NOT MATCHED THEN
INSERT (user_id, authority_name) VALUES (s.user_id, s.authority_name);