o-ing-backend/oing.sql at develop · o-ing/o-ing-backend · GitHub

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
46
47
48
49
50
51
52
53
54
# id - root
# pw - 1234

CREATE DATABASE oing CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

drop table oing;

use oing;

select * from member;
select * from club;
select * from post;
select * from subscription;

UPDATE member
SET member_role = 'ROLE_ADMIN'
WHERE member_id = 1;

UPDATE member
SET member_role = 'ROLE_ADMIN'
WHERE member_email = '[email protected]';

show tables;

select * from subscription;
select * from club;
select * from board;
select * from post;
select * from comment;

UPDATE member
SET club_id = 1
WHERE member_id = 1;

select * from club;
delete from club where club_id = 1;

show tables;

drop table member;
drop table board;
drop table crew;
drop table crew_member;
drop table member;
drop table authority;
drop table member_authority;
drop table notice;

select * from authority;
select * from member_authority;

INSERT INTO AUTHORITY (AUTHORITY_NAME) values ('ROLE_USER');
INSERT INTO AUTHORITY (AUTHORITY_NAME) values ('ROLE_MIDDLE_ADMIN');
INSERT INTO AUTHORITY (AUTHORITY_NAME) values ('ROLE_ADMIN');