File size: 1,029 Bytes
536f592 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | -- Supabase schema for شَمْl / Diac save flow
-- Run in Supabase SQL Editor
-- 1) Storage bucket (create via Dashboard or API if not exists)
-- Name: audio-recordings
-- Public: optional (public URL used in audio_url column)
-- 2) Database table
create table if not exists public.diacritization_records (
id uuid primary key default gen_random_uuid(),
audio_path text not null,
audio_url text not null,
extracted_text text not null,
edited_text text not null,
diacritized_text text not null,
created_at timestamptz not null default now()
);
-- Optional: index for recent records
create index if not exists diacritization_records_created_at_idx
on public.diacritization_records (created_at desc);
-- 3) RLS (recommended for production)
-- Service role bypasses RLS; enable if you add client-side reads later.
alter table public.diacritization_records enable row level security;
-- Allow service role full access (default with service key)
-- No public policies needed when only backend uses service role.
|