관리자 로그인

⚙️ 회원 데이터 수집 설정 필요

Supabase SQL Editor에서 아래 쿼리를 한 번만 실행하면 이후 자동으로 쌓입니다.

CREATE TABLE IF NOT EXISTS user_profiles (
  id UUID REFERENCES auth.users(id) ON DELETE CASCADE PRIMARY KEY,
  email TEXT,
  created_at TIMESTAMPTZ DEFAULT NOW(),
  last_sign_in_at TIMESTAMPTZ
);
ALTER TABLE user_profiles ENABLE ROW LEVEL SECURITY;
CREATE POLICY "admin_read" ON user_profiles FOR SELECT USING (true);
CREATE POLICY "service_insert" ON user_profiles FOR INSERT WITH CHECK (true);
CREATE POLICY "service_update" ON user_profiles FOR UPDATE USING (true);
CREATE OR REPLACE FUNCTION sync_user_profile()
RETURNS TRIGGER LANGUAGE plpgsql SECURITY DEFINER AS $$
BEGIN
  INSERT INTO user_profiles (id, email, created_at, last_sign_in_at)
  VALUES (NEW.id, NEW.email, NEW.created_at, NEW.last_sign_in_at)
  ON CONFLICT (id) DO UPDATE SET
    last_sign_in_at = NEW.last_sign_in_at,
    email = NEW.email;
  RETURN NEW;
END;
$$;
DROP TRIGGER IF EXISTS on_auth_user_change ON auth.users;
CREATE TRIGGER on_auth_user_change
  AFTER INSERT OR UPDATE ON auth.users
  FOR EACH ROW EXECUTE FUNCTION sync_user_profile();

※ 위 SQL 실행 후, 아래 기존 회원 동기화 SQL도 함께 실행하세요.

📥 기존 회원 동기화 SQL (한 번만 실행)

INSERT INTO user_profiles (id, email, created_at, last_sign_in_at)
SELECT id, email, created_at, last_sign_in_at FROM auth.users
ON CONFLICT (id) DO UPDATE SET
  email = EXCLUDED.email,
  created_at = EXCLUDED.created_at,
  last_sign_in_at = EXCLUDED.last_sign_in_at;