-- 사용자 생성
CREATE USER IF NOT EXISTS write_user PASSWORD 'write_password';
CREATE USER IF NOT EXISTS read_user PASSWORD 'read_password';
GRANT ALL ON SCHEMA PUBLIC TO write_user;
GRANT SELECT ON SCHEMA PUBLIC TO read_user;

-- 권한 레벨
INSERT INTO authority_level (level_code, description, created_by, updated_by) VALUES
('SUPER_ADMIN', '최고 관리자', 'SYSTEM', 'SYSTEM'),
('MID_ADMIN', '중간 관리자', 'SYSTEM', 'SYSTEM'),
('USER', '일반 사용자', 'SYSTEM', 'SYSTEM');

-- 권한 그룹
INSERT INTO authority_group (id, level_code, name, description, created_by, updated_by) VALUES
('authority_group_uuid1', 'SUPER_ADMIN', '최고관리자 그룹', '모든 메뉴 접근 가능', 'SYSTEM', 'SYSTEM'),
('authority_group_uuid2', 'MID_ADMIN', '중간관리자A', '메뉴1, 메뉴2 접근 가능', 'SYSTEM', 'SYSTEM'),
('authority_group_uuid3', 'MID_ADMIN', '중간관리자B', '메뉴3, 메뉴4 접근 가능', 'SYSTEM', 'SYSTEM'),
('authority_group_uuid4', 'USER', '일반사용자 그룹', '기본 메뉴만 접근 가능', 'SYSTEM', 'SYSTEM');

-- 메뉴
INSERT INTO menu (id, menu_name, path, sort_order, created_by, updated_by) VALUES
('menu_uuid1', '대시보드', '/dashboard', 1, 'SYSTEM', 'SYSTEM'),
('menu_uuid2', '회원관리', '/members', 2, 'SYSTEM', 'SYSTEM'),
('menu_uuid3', '권한관리', '/authorities', 3, 'SYSTEM', 'SYSTEM'),
('menu_uuid4', '메뉴관리', '/menus', 4, 'SYSTEM', 'SYSTEM');

-- 권한 그룹 메뉴 매핑
-- 최고관리자: 모든 메뉴
INSERT INTO authority_group_menu (id, group_id, menu_id, created_by, updated_by) VALUES
('authority_group_menu_uuid1', 'authority_group_uuid1', 'menu_uuid1', 'SYSTEM', 'SYSTEM'),
('authority_group_menu_uuid2', 'authority_group_uuid1', 'menu_uuid2', 'SYSTEM', 'SYSTEM'),
('authority_group_menu_uuid3', 'authority_group_uuid1', 'menu_uuid3', 'SYSTEM', 'SYSTEM'),
('authority_group_menu_uuid4', 'authority_group_uuid1', 'menu_uuid4', 'SYSTEM', 'SYSTEM');

-- 중간관리자A: 대시보드 + 회원관리
INSERT INTO authority_group_menu (id, group_id, menu_id, created_by, updated_by) VALUES
('authority_group_menu_uuid5', 'authority_group_uuid2', 'menu_uuid1', 'SYSTEM', 'SYSTEM'),
('authority_group_menu_uuid6', 'authority_group_uuid2', 'menu_uuid2', 'SYSTEM', 'SYSTEM');

-- 중간관리자B: 권한관리 + 메뉴관리
INSERT INTO authority_group_menu (id, group_id, menu_id, created_by, updated_by) VALUES
('authority_group_menu_uuid7', 'authority_group_uuid3', 'menu_uuid3', 'SYSTEM', 'SYSTEM'),
('authority_group_menu_uuid8', 'authority_group_uuid3', 'menu_uuid4', 'SYSTEM', 'SYSTEM');

-- 일반사용자: 대시보드만
INSERT INTO authority_group_menu (id, group_id, menu_id, created_by, updated_by) VALUES
('authority_group_menu_uuid9', 'authority_group_uuid4', 'menu_uuid1', 'SYSTEM', 'SYSTEM');

-- 관리자 계정
INSERT INTO admin (id, login_id, password, name, phone_number, email, authority_group_id, approval_status, created_by, updated_by) VALUES
('admin_uuid1', 'ymkmoon43', '$2a$10$tuLXB3HaKF9B6IkKQLkER.uBZkbP9qkcgIqUpXoXGrYDy1Ac3GiE2', '유명기', '01029320134', '[email protected]', 'authority_group_uuid1', 'ACTIVE', 'SYSTEM', 'SYSTEM');