μΉκ΅¬λ€μ΄ λΌμλ‘ κ°μ λ±λ§μ΄ 컀μ§λλ€ β μλ μ§κ³
β μ€μκ° κ³΅μ μΌκΈ°: μλ SQLμ Supabase SQL Editorμ λΆμ¬λ£κ³ Run. (μ νλ©΄ μ΄ κΈ°κΈ° μμμλ§ μλνλ μ°μ΅ λͺ¨λ)
create table if not exists korean_words (
id uuid primary key default gen_random_uuid(),
created_at timestamptz not null default now(),
room text not null default 'demo',
name text,
word text not null
);
create index if not exists korean_words_room_idx
on korean_words(room, created_at desc);
alter table korean_words enable row level security;
drop policy if exists "anon insert words" on korean_words;
create policy "anon insert words" on korean_words
for insert to anon
with check ( char_length(room) between 1 and 40
and char_length(word) between 1 and 40 );
drop policy if exists "anon read words" on korean_words;
create policy "anon read words" on korean_words
for select to anon using ( true );
β‘ μ§λ¬Έ λ°κΎΈκΈ°: μ£Όμ λ€μ ?q=λ΄ νλ©΄ λ μ€λ₯΄λ λ±λ§μ? Β· λ° κ΅¬λΆμ ?room=3-2 (μ¬λ¬ κ°λ &λ‘ μ°κ²°).
β’ λ°μ΄ν° μ§μ°κΈ°: SQL Editorμμ delete from korean_words;