From cfe3ce7b78095ada79a45ef3f4ee603b410c5497 Mon Sep 17 00:00:00 2001 From: Baitinq Date: Sun, 18 Aug 2024 21:35:14 +0200 Subject: Migrations: Add new restored_file table migration --- .../20240818192021_create_restored_file_table.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 supabase/migrations/20240818192021_create_restored_file_table.sql (limited to 'supabase') diff --git a/supabase/migrations/20240818192021_create_restored_file_table.sql b/supabase/migrations/20240818192021_create_restored_file_table.sql new file mode 100644 index 0000000..5654b33 --- /dev/null +++ b/supabase/migrations/20240818192021_create_restored_file_table.sql @@ -0,0 +1,21 @@ +CREATE TABLE IF NOT EXISTS public."restored_file" ( + id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), + user_id UUID NOT NULL, + absolute_path VARCHAR(4096) NOT NULL, + contents TEXT, + original_timestamp TIMESTAMPTZ NOT NULL +); + +ALTER TABLE public."restored_file" ENABLE ROW LEVEL SECURITY; + +CREATE POLICY "Restrict access to user files to their own files" + ON public."restored_file" + FOR SELECT + TO authenticated + USING (user_id = auth.uid()); + +CREATE POLICY "Users can create a profile." + ON public."restored_file" + FOR INSERT + TO authenticated + WITH CHECK (auth.uid() = user_id); -- cgit 1.4.1