INSERT INTO BOARD (ID, TITLE, CONTENT, SYS_INSERT_DTM, SYS_UPDATE_DTM)
VALUES
    (1, 'title 1', 'content 1', '2023-08-07 10:00:00', '2023-08-07 10:00:00'),
    (2, 'title 2', 'content 2', '2023-08-07 11:00:00', '2023-08-07 11:00:00'),
    (3, 'title 3', 'content 3', '2023-08-07 12:00:00', '2023-08-07 12:00:00'),
    (4, 'title 4', 'content 4', '2023-08-07 13:00:00', '2023-08-07 13:00:00'),
    (5, 'title 5', 'content 5', '2023-08-07 14:00:00', '2023-08-07 14:00:00'),
    (6, 'title 6', 'content 6', '2023-08-07 15:00:00', '2023-08-07 15:00:00'),
    (7, 'title 7', 'content 7', '2023-08-07 16:00:00', '2023-08-07 16:00:00'),
    (8, 'title 8', 'content 8', '2023-08-07 17:00:00', '2023-08-07 17:00:00'),
    (9, 'title 9', 'content 9', '2023-08-07 18:00:00', '2023-08-07 18:00:00'),
    (10, 'title 10', 'content 10', '2023-08-07 19:00:00', '2023-08-07 19:00:00'),
    (11, 'title 11', 'content 11', '2023-08-07 20:00:00', '2023-08-07 20:00:00'),
    (12, 'title 12', 'content 12', '2023-08-07 21:00:00', '2023-08-07 21:00:00'),
    (13, 'title 13', 'content 13', '2023-08-07 22:00:00', '2023-08-07 22:00:00');

-- 사용자 정보 테이블 데이터
INSERT INTO CHMM_USER_INFO (USER_ID, USER_EMAIL, USER_MOBILE, USER_NAME, USER_NICK, USER_PWD, USER_IMG, USER_MSG, USER_DESC, USER_STAT_CD, USER_SNSID, ACCOUNT_NON_LOCK, ACCOUNT_START_DT, ACCOUNT_END_DT, PASSWORD_EXPIRE_DT, USE_YN, SYS_INSERT_DTM, SYS_INSERT_USER_ID, SYS_UPDATE_DTM, SYS_UPDATE_USER_ID, PASSWORD_LOCK_CNT, EXCEPTION_SEND_YN, LOG_SEND_YN)
VALUES
    ('admin', 'admin@chamomile.net', '010-1234-5678', '어드민', '', '27d14effa31a772b2ee217b8c1b3a025fd9f888cb08fbf00dbc4970700b2dbe4ff501e29c7b853ab', '[NULL]', '', '', '', NULL, '1', '20000101', '21001231', '21001231', '1', NULL, NULL, NULL, NULL, 0, '1', '0');

-- 사용자 권한 매핑 테이블 데이터
INSERT INTO CHMM_USER_ROLE_MAP (USER_ID, ROLE_ID, USE_YN, SYS_INSERT_DTM)
VALUES
    ('admin', 'ROLE_ADMIN_ID', '1', NULL),
    ('admin', 'ROLE_DEFAULT_ID', '1', NULL);

-- 권한 상하 관계 테이블 데이터
INSERT INTO CHMM_MULTI_ROLE_GROUP_INFO (PARENT_ROLE_ID, CHILD_ROLE_ID)
VALUES
    ('ROLE_ADMIN_ID', 'ROLE_USER_ID');

-- 리소스 테이블 데이터
INSERT INTO CHMM_RESOURCE_INFO (RESOURCE_ID, RESOURCE_URI, RESOURCE_NAME, RESOURCE_DESC, SECURITY_ORDER, USE_YN, SYS_INSERT_DTM, SYS_INSERT_USER_ID, SYS_UPDATE_DTM, SYS_UPDATE_USER_ID)
VALUES
    ('RESOURCE_ADMIN_ID', '/admin/**', '어드민 리소스', '어드민 리소스 입니다.', 1000, '1', NULL, NULL, NULL, NULL),
    ('RESOURCE_DEFAULT_ID', '/**', '기본 리소스', '기본 리소스 입니다.', 99999, '1', NULL, NULL, NULL, NULL);

-- 권한 테이블 데이터
INSERT INTO CHMM_ROLE_INFO (ROLE_ID, ROLE_NAME, ROLE_DESC, ROLE_START_DT, ROLE_END_DT, USE_YN, SYS_INSERT_DTM, SYS_INSERT_USER_ID, SYS_UPDATE_DTM, SYS_UPDATE_USER_ID)
VALUES
    ('ROLE_ADMIN_ID', '어드민 권한', '어드민 권한 입니다.', '20180701', '21001231', '1', NULL, NULL, NULL, NULL),
    ('ROLE_USER_ID', '사용자 권한', '사용자 권한 입니다.', '20180701', '21001231', '1', NULL, NULL, NULL, NULL),
    ('ROLE_DEFAULT_ID', '기본 권한', '기본 권한 입니다.', '20180701', '21001231', '1', NULL, NULL, NULL, NULL);

-- 리소스 권한 매핑 테이블 데이터
INSERT INTO CHMM_RESOURCE_ROLE_MAP (RESOURCE_ID, ROLE_ID, USE_YN, SYS_INSERT_DTM)
VALUES
    ('RESOURCE_ADMIN_ID', 'ROLE_ADMIN_ID', '1', NULL),
    ('RESOURCE_DEFAULT_ID', 'ROLE_DEFAULT_ID', '1', NULL);
