ITSpecial — 딜 관리

CREATE TABLE IF NOT EXISTS click_logs (
  id           BIGSERIAL PRIMARY KEY,
  deal_id      INTEGER,
  deal_name    TEXT,
  category     TEXT,
  store        TEXT,
  sale_price   INTEGER,
  is_affiliate BOOLEAN DEFAULT FALSE,
  clicked_at   TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE click_logs ENABLE ROW LEVEL SECURITY;
-- 누구나 INSERT 가능 (방문자 클릭 기록용)
CREATE POLICY "anon_insert" ON click_logs FOR INSERT TO anon WITH CHECK (true);
-- 누구나 SELECT 가능 (어드민 통계 조회용 — anon key 사용)
CREATE POLICY "anon_select" ON click_logs FOR SELECT TO anon USING (true);

-- deal_reports 테이블에 컬럼 추가 (이미 있으면 무시됨)
ALTER TABLE deal_reports
  ADD COLUMN IF NOT EXISTS auto_score  INTEGER DEFAULT 0,
  ADD COLUMN IF NOT EXISTS status      TEXT    DEFAULT 'pending',
  ADD COLUMN IF NOT EXISTS submitted_at TIMESTAMPTZ DEFAULT NOW();

-- 없으면 테이블 새로 생성
CREATE TABLE IF NOT EXISTS deal_reports (
  id             BIGSERIAL PRIMARY KEY,
  url            TEXT NOT NULL,
  name           TEXT NOT NULL,
  sale_price     INTEGER,
  original_price INTEGER,
  note           TEXT,
  auto_score     INTEGER DEFAULT 0,
  status         TEXT DEFAULT 'pending',
  submitted_at   TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE deal_reports ENABLE ROW LEVEL SECURITY;
CREATE POLICY "anon_insert" ON deal_reports FOR INSERT TO anon WITH CHECK (true);
CREATE POLICY "anon_select" ON deal_reports FOR SELECT TO anon USING (true);
CREATE POLICY "anon_update" ON deal_reports FOR UPDATE TO anon USING (true) WITH CHECK (true);