Skip to content

member테이블 기본 유저 추가 #54

@shmin7777

Description

@shmin7777
insert into topinerd.member (nickname, member_name, email, password, phone_number, profile_url, self_introduction, gender, role, login_type, level, member_status, created_ymdt, updated_ymdt, notice_ad_yn, notice_update_tp_yn, notice_tp_yn, notice_lk_yn, notice_fw_yn)
values  ('일반유저1', '일반유저1', 'normal-user@gmail.com', 'nomal', '01011111111', 'https://lh3.googleusercontent.com/a/ACg8ocJrMZEgZ-XsAHZqz9JyI5KWBedJ5E7K6UNnMTINsKSd2UbU=s96-c', '안녕하세요.', null, 'ROLE_USER', 'GOOGLE', 1, 'ACTIVE', '2024-12-15 13:03:38', '2024-12-15 13:03:38', 'N', 'N', 'N', 'N', 'N'),
        ('사업자 유저1', '사업자 유저1', 'business-user@gmail.com', 'business', '01022222222', 'https://lh3.googleusercontent.com/a/ACg8ocJrMZEgZ-XsAHZqz9JyI5KWBedJ5E7K6UNnMTINsKSd2UbU=s96-c', '안녕하세요.', null, 'ROLE_BUSINESS_USER', 'GOOGLE', 1, 'ACTIVE', '2024-12-15 13:03:41', '2024-12-15 13:03:41', 'N', 'N', 'N', 'N', 'N'),
        ('어드민 유저1', '어드민 유저1', 'admin-user@gmail.com', 'admin', '01033333333', 'https://lh3.googleusercontent.com/a/ACg8ocJrMZEgZ-XsAHZqz9JyI5KWBedJ5E7K6UNnMTINsKSd2UbU=s96-c', '안녕하세요.', null, 'ROLE_ADMIN', 'GOOGLE', 1, 'ACTIVE', '2024-12-15 13:03:43', '2024-12-15 13:03:43', 'N', 'N', 'N', 'N', 'N');

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions