HomeAboutMeBlogGuest
© 2025 Sejin Cha. All rights reserved.
Built with Next.js, deployed on Vercel
🧚
[1기]최종 프로젝트 데브코스/
🍒
[팀10] CherryBoys❤️/
⌨️
백엔드/김선호/
dbdbd

dbdbd

 
/********************permissions**********************************/
INSERT INTO permissions(id,name)
VALUES (1, 'ROLE_USER');
INSERT INTO permissions(id,name)
VALUES (2, 'ROLE_ADMIN');

INSERT INTO groupings(id,name)
VALUES (1, 'USER_GROUP');
INSERT INTO groupings(id,name)
VALUES (2, 'ADMIN_GROUP');

INSERT INTO grouping_permissions(id,grouping_id,permission_id)
VALUES (1, 1, 1);
INSERT INTO grouping_permissions(id,grouping_id,permission_id)
VALUES (2, 2, 1);
INSERT INTO grouping_permissions(id,grouping_id,permission_id)
VALUES (3, 2, 2);


INSERT INTO sports (id,name)
VALUES (1, '축구');
INSERT INTO sports (id,name)
VALUES (2, '풋살');

INSERT INTO cities (id,name)
VALUES (1, '서울특별시');
INSERT INTO cities (id,name)
VALUES (2, '경기도');

INSERT INTO regions (id,city_id,name)
VALUES (1, 1, '강남구');
INSERT INTO regions (id,city_id,name)
VALUES (2, 1, '영등포구');
INSERT INTO regions (id,city_id,name)
VALUES (3, 2, '남양주시');
INSERT INTO regions (id,city_id,name)
VALUES (4, 2, '성남시');

INSERT INTO grounds (id,region_id,name)
VALUES (1, 1, '대륭축구장');
INSERT INTO grounds (id,region_id,name)
VALUES (2, 1, '대륭풋살장');
INSERT INTO grounds (id,region_id,name)
VALUES (3, 1, '머쓱축구장');
INSERT INTO grounds (id,region_id,name)
VALUES (4, 1, '머쓱풋살장');
INSERT INTO grounds (id,region_id,name)
VALUES (5, 2, '쭝축구장');
INSERT INTO grounds (id,region_id,name)
VALUES (6, 2, '쭝풋살장');
INSERT INTO grounds (id,region_id,name)
VALUES (7, 2, '시즈축구장');
INSERT INTO grounds (id,region_id,name)
VALUES (8, 2, '시즈풋살장');
INSERT INTO grounds (id,region_id,name)
VALUES (9, 3, '체리축구장');
INSERT INTO grounds (id,region_id,name)
VALUES (10, 3, '체리풋살장');
INSERT INTO grounds (id,region_id,name)
VALUES (11, 3, '용스톤축구장');
INSERT INTO grounds (id,region_id,name)
VALUES (12, 3, '용스톤풋살장');
INSERT INTO grounds (id,region_id,name)
VALUES (13, 4, '호세축구장');
INSERT INTO grounds (id,region_id,name)
VALUES (14, 4, '호세풋살장');
INSERT INTO grounds (id,region_id,name)
VALUES (15, 4, '쌈축구장');
INSERT INTO grounds (id,region_id,name)
VALUES (16, 4, '쌈풋살장');


/*******************user**********************************/
INSERT INTO users (id,sport_id,email,name,password,nickname,gender,bio,age_group,
manner_temperature,grouping_id,is_disaffiliated,created_date,modified_date)
VALUES (1, 1, 'cpfl1@naver.com', '체리1',
        '$2a$10$V49VkeuUVRLT2ky0h/jG6uCnper8.51LjQ9d9fBnDESwGMF8Dvyzm', '체리1', 'WOMEN', NULL,
        'FIFTIES', 36.5, 1, 0, '2021-12-16 15:01:40', '2021-12-16 15:01:40'),
       (2, 1, 'cpfl2@naver.com', '체리2',
        '$2a$10$V49VkeuUVRLT2ky0h/jG6uCnper8.51LjQ9d9fBnDESwGMF8Dvyzm', '체리2', 'WOMEN', NULL,
        'FIFTIES', 36.5, 1, 0, '2021-12-16 15:01:40', '2021-12-16 15:01:40'),
       (3, 1, 'cpfl3@naver.com', '체리3',
        '$2a$10$oXsJbTja1aR2xTVIeTAC3.npXWIgZDF2z419/i3s8WK2.6.oxYQBO', '체리3', 'MAN', NULL,
        'THIRTIES', 36.5, 1, 0, '2021-12-16 15:03:37', '2021-12-16 15:03:37'),
       (4, 1, 'cpfl4@naver.com', '체리4',
        '$2a$10$ItP8aXKCxX9MgiH7H63kNu2aElj5K5F5roFWRo.F0oSuDhCmpLLq6', '체리4', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:31:16', '2021-12-16 15:31:16'),
       (5, 1, 'cpfl5@naver.com', '체리5',
        '$2a$10$D.WjKGnQG/Bdz/j2TmCEVOgfI/wwUCNYc2XWpQz/p2iCDb2gmg6Dy', '체리5', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:35:53', '2021-12-16 15:35:53'),
       (6, 1, 'cpfl6@naver.com', '체리6',
        '$2a$10$Xg7j.Hs6uQSFP638zA6f9efpbUsSqh.SSvZvMpfUevaPz7SY984J6', '체리6', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:36:11', '2021-12-16 15:36:11'),
       (7, 1, 'tlwm1@naver.com', '시즈1',
        '$2a$10$7K9fSnuOW6E36HwsFNu4ZuEC1m95SYh3dn6mrawLs75fl4Ak77Lqq', '시즈1', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:36:31', '2021-12-16 15:36:31'),
       (8, 1, 'tlwm2@naver.com', '시즈1',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '시즈2', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (9, 1, 'tlwm3@naver.com', '시즈1',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '시즈3', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (10, 1, 'tlwm4@naver.com', '시즈1',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '시즈4', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (11, 1, 'tlwm5@naver.com', '시즈1',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '시즈5', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (12, 1, 'tlwm6@naver.com', '시즈1',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '시즈6', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (13, 1, 'tmxhs1@naver.com', '스톤',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '스톤1', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (14, 1, 'tmxhs2@naver.com', '스톤',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '스톤2', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (15, 1, 'tmxhs3@naver.com', '스톤',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '스톤3', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (16, 1, 'tmxhs4@naver.com', '스톤',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '스톤4', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (17, 1, 'tmxhs5@naver.com', '스톤',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '스톤5', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (18, 1, 'tmxhs6@naver.com', '스톤',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '스톤6', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (19, 1, 'wwnd1@naver.com', '쭝',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '쭝1', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (20, 1, 'wwnd2@naver.com', '쭝',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '쭝2', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (21, 1, 'wwnd3@naver.com', '쭝',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '쭝3', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (22, 1, 'wwnd4@naver.com', '쭝',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '쭝4', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (23, 1, 'wwnd5@naver.com', '쭝',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '쭝5', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (24, 1, 'wwnd6@naver.com', '쭝',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '쭝6', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (25, 1, 'ghtp1@naver.com', '호세',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '호세1', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03'),
       (26, 1, 'tkandpf1@naver.com', '사무엘',
        '$2a$10$DEMwRiv0mbIoezv0BU5eI.bJCZhUESMNxth7GJyPWsGnuexH/g732', '사무엘1', 'MAN', NULL,
        'SIXTIES', 36.5, 1, 0, '2021-12-16 15:37:03', '2021-12-16 15:37:03');


/********************team**********************************/
INSERT INTO teams (id,sport_id,name,bio,logo,age_group,manner_temperature,is_deleted,
created_date,modified_date)
VALUES (1, 1, '시즈팀', '팀소개1', '팀로고', 'TWENTIES', 36.5, false, '2021-12-07T12:32:22',
        '2021-12-07T12:32:22'),
       (2, 1, '체리팀', '팀소개1', '팀로고', 'TWENTIES', 36.5, false, '2021-12-07T12:32:22',
        '2021-12-07T12:32:22'),
       (3, 1, '쭝팀', '팀소개1', '팀로고', 'TWENTIES', 36.5, false, '2021-12-07T12:32:22',
        '2021-12-07T12:32:22'),
       (4, 1, '스톤팀', '팀소개1', '팀로고', 'TWENTIES', 36.5, false, '2021-12-07T12:32:22',
        '2021-12-07T12:32:22'),
       (5, 2, '호세팀', '팀소개1', '팀로고', 'TWENTIES', 36.5, false, '2021-12-07T12:32:22',
        '2021-12-07T12:32:22'),
       (6, 2, '사무엘팀', '팀소개1', '팀로고', 'TWENTIES', 36.5, false, '2021-12-07T12:32:22',
        '2021-12-07T12:32:22');


/********************team_users**********************************/
INSERT INTO team_users (id,team_id,user_id,grade,is_disaffiliated)
VALUES (1, 1, 7, 'CAPTAIN', false),
       (2, 1, 8, 'SUB_CAPTAIN', false),
       (3, 1, 9, 'GENERAL', false),
       (4, 2, 10, 'GENERAL', false),
       (5, 2, 11, 'GENERAL', false),
       (6, 2, 12, 'GENERAL', false),
       (7, 3, 25, 'HIRED', false),
       (8, 3, 26, 'HIRED', false),
       (9, 2, 1, 'CAPTAIN', false),
       (10, 2, 2, 'GENERAL', false),
       (11, 2, 3, 'GENERAL', false),
       (13, 2, 4, 'GENERAL', false),
       (14, 2, 5, 'GENERAL', false),
       (15, 2, 6, 'GENERAL', false),
       (16, 3, 19, 'CAPTAIN', false),
       (17, 3, 20, 'GENERAL', false),
       (18, 3, 21, 'GENERAL', false),
       (19, 3, 22, 'GENERAL', false),
       (20, 3, 23, 'GENERAL', false),
       (21, 3, 24, 'GENERAL', false),
       (22, 3, 1, 'HIRED', false),
       (23, 4, 13, 'CAPTAIN', false),
       (24, 4, 14, 'GENERAL', false),
       (25, 4, 15, 'GENERAL', false),
       (26, 4, 16, 'GENERAL', false),
       (27, 4, 17, 'GENERAL', false),
       (28, 4, 18, 'GENERAL', false),
       (29, 4, 1, 'GENERAL', false),
       (30, 5, 25, 'CAPTAIN', false),
       (31, 6, 26, 'CAPTAIN', false);


INSERT INTO hire_posts (id,team_id,position,city_id,region_id,ground_id,date,
start_time,
end_time,
age_group,detail,hire_player_number,is_deleted,created_date,
modified_date)
VALUES (1, 1, '윙백', 1, 1, 1, '2021-12-31', '12:32:22', '12:32:22',
        'TEENAGER',
        '세부내용', 3, false, '2021-12-06T12:32:22', '2021-12-06T12:32:22'),
       (2, 5, '윙백', 1, 2, 2, '2021-12-30', '12:32:22', '12:32:22',
        'TEENAGER',
        '세부내용', 3, false, '2021-12-06T12:32:22', '2021-12-06T12:32:22'),
       (3, 6, '윙백', 1, 2, 3, '2021-12-29', '12:32:22', '12:32:22',
        'TEENAGER',
        '세부내용', 3, false, '2021-12-06T12:32:22', '2021-12-06T12:32:22');

INSERT INTO team_invitations (id,team_id,user_id)
VALUES (1, 5, 1);
INSERT INTO team_invitations (id,team_id,user_id)
VALUES (2, 6, 1);


/*********************************************Match  ******************************************/

INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (1, 2, null, 2, 1, 1, 1, '2021-12-23', '12:32:22', '12:40:22', 'TEENAGER', 1000, '안녕하세요',
        false, false, false, 'WAITING', '2021-12-06T12:32:22', '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (2, 2, null, 2, 1, 1, 1, '2021-12-23', '12:32:22', '12:40:22',
        'TEENAGER', 1000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (3, 3, null, 1, 1, 1, 1, '2021-12-25', '12:32:22', '12:40:22',
        'FORTIES', 1000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (4, 3, null, 1, 1, 1, 1, '2021-12-25', '12:32:22', '12:40:22',
        'FORTIES', 5000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (5, 4, null, 1, 1, 1, 1, '2021-12-25', '12:32:22', '12:40:22',
        'FORTIES', 5000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (6, 4, null, 1, 1, 1, 1, '2021-12-25', '12:32:22', '12:40:22',
        'SIXTIES', 5000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (7, 1, null, 1, 1, 1, 1, '2021-12-25', '12:32:22', '12:40:22',
        'SIXTIES', 5000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (8, 1, null, 1, 2, 1, 1, '2021-12-26', '12:32:22', '12:40:22',
        'TEENAGER', 1000000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (9, 4, null, 1, 2, 1, 1, '2021-12-26', '12:32:22', '12:40:22',
        'TEENAGER', 1000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (10, 1, null, 2, 2, 1, 2, '2021-12-26', '12:32:22', '12:40:22',
        'TEENAGER', 1000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (11, 1, null, 2, 2, 1, 2, '2021-12-28', '12:32:22', '12:40:22',
        'TEENAGER', 1000, '안녕하세요', false, false, false, 'WAITING', '2021-12-06T12:32:22',
        '2021-12-06T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (12, 2, 3, 1, 1, 1, 3, '2021-12-28', '12:40:00', '14:40:00',
        'TWENTIES', 50000, '안녕하세요', false, false, false, 'COMPLETION', '2021-12-16T12:32:22',
        '2021-12-16T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (13, 2, 4, 1, 1, 1, 3, '2021-12-28', '12:40:00', '14:40:00',
        'TWENTIES', 50000, '안녕하세요', false, false, false, 'COMPLETION', '2021-12-16T12:32:22',
        '2021-12-16T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (14, 2, 4, 1, 1, 1, 3, '2021-12-28', '12:40:00', '14:40:00',
        'TWENTIES', 50000, '안녕하세요', false, false, false, 'COMPLETION', '2021-12-16T12:32:22',
        '2021-12-16T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (15, 3, 1, 1, 1, 1, 3, '2021-12-28', '12:40:00', '14:40:00',
        'TWENTIES', 50000, '안녕하세요', true, true, false, 'REVIEWED', '2021-12-16T12:32:22',
        '2021-12-16T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (16, 4, 1, 1, 1, 1, 3, '2021-12-28', '12:40:00', '14:40:00',
        'TWENTIES', 50000, '안녕하세요', true, true, false, 'REVIEWED', '2021-12-16T12:32:22',
        '2021-12-16T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (17, 1, 2, 1, 1, 1, 3, '2021-12-28', '12:40:00', '14:40:00',
        'TWENTIES', 50000, '안녕하세요', false, true, false, 'COMPLETION', '2021-12-16T12:32:22',
        '2021-12-16T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (18, 1, 4, 1, 1, 1, 3, '2021-12-28', '12:40:00', '14:40:00',
        'TWENTIES', 50000, '안녕하세요', true, false, false, 'COMPLETION', '2021-12-16T12:32:22',
        '2021-12-16T12:32:22');
INSERT INTO matches (id,register_team_id,apply_team_id,sport_id,city_id,region_id,ground_id,
date,
start_time,
end_time,
age_group,cost,detail,is_register_team_reviewed,is_apply_team_reviewed,
is_cancelled,status,created_date,
modified_date)
VALUES (19, 1, 3, 1, 1, 1, 3, '2021-12-28', '12:40:00', '14:40:00',
        'TWENTIES', 50000, '안녕하세요', false, false, false, 'COMPLETION', '2021-12-16T12:32:22',
        '2021-12-16T12:32:22');


/*****************************************team_waitings********************************************/
INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (1, 1, 1, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (2, 1, 2, 'WAITING');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (3, 2, 2, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (25, 2, 3, 'SELECTED');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (4, 3, 3, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (5, 4, 4, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (6, 4, 5, 'WAITING');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (7, 5, 5, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (8, 5, 6, 'SELECTED');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (10, 5, 9, 'WAITING');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (11, 6, 6, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (12, 6, 7, 'SELECTED');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (13, 7, 7, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (14, 7, 8, 'SELECTED');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (15, 8, 1, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (16, 8, 5, 'SELECTED');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (17, 9, 2, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (18, 9, 6, 'SELECTED');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (19, 10, 3, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (20, 10, 7, 'SELECTED');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (23, 11, 4, 'REGISTER');

INSERT INTO team_waitings (id,match_id,team_id,type)
VALUES (24, 11, 1, 'WAITING');


/********************member_waitings**********************************/
INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (1, 1, 1);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (2, 2, 1);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (3, 3, 2);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (4, 4, 2);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (5, 3, 3);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (6, 4, 3);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (46, 5, 4);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (47, 6, 4);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (7, 7, 5);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (8, 8, 5);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (9, 5, 6);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (10, 1, 6);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (11, 2, 7);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (12, 3, 7);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (13, 4, 8);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (14, 5, 8);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (15, 6, 9);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (16, 7, 9);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (17, 8, 10);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (18, 9, 10);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (19, 1, 11);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (20, 2, 11);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (21, 3, 12);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (22, 4, 12);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (23, 5, 13);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (24, 6, 13);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (25, 7, 14);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (26, 8, 14);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (27, 9, 15);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (28, 1, 15);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (29, 2, 16);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (30, 3, 16);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (31, 4, 17);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (32, 5, 17);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (33, 6, 18);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (34, 7, 18);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (35, 8, 19);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (36, 9, 19);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (37, 1, 20);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (38, 2, 20);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (39, 3, 21);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (40, 4, 21);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (41, 5, 22);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (42, 6, 23);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (43, 7, 23);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (44, 8, 24);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (45, 9, 24);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (48, 2, 25);

INSERT INTO member_waitings (id,user_id,team_waiting_id)
VALUES (49, 3, 25);

/**********************user_match_histories*************************/
INSERT INTO user_match_histories (id,user_id,match_id)
VALUES (1, 11, 2);

INSERT INTO user_match_histories (id,user_id,match_id)
VALUES (2, 11, 9);

INSERT INTO user_match_histories (id,user_id,match_id)
VALUES (3, 11, 10);

INSERT INTO team_invitations (id,team_id,user_id)
VALUES (1, 1, 6);
INSERT INTO team_invitations (id,team_id,user_id)
VALUES (2, 1, 4);
INSERT INTO team_invitations (id,team_id,user_id)
VALUES (3, 1, 11);
INSERT INTO team_invitations (id,team_id,user_id)
VALUES (4, 2, 11);
INSERT INTO team_invitations (id,team_id,user_id)
VALUES (5, 3, 11);

INSERT INTO hire_applications (id,hire_post_id,user_id)
VALUES (1, 1, 11);
INSERT INTO hire_applications (id,hire_post_id,user_id)
VALUES (2, 2, 11);
INSERT INTO hire_applications (id,hire_post_id,user_id)
VALUES (3, 3, 11);