supabase/migrations/20240605214214_create_file_table.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

CREATE TABLE IF NOT EXISTS public."file" (
	id SERIAL PRIMARY KEY,
	user_id UUID NOT NULL,
	absolute_path VARCHAR(4096) NOT NULL,
	contents TEXT,
	timestamp TIMESTAMPTZ NOT NULL
);

ALTER TABLE public."file" ENABLE ROW LEVEL SECURITY;

CREATE POLICY "Restrict access to user files to their own files"
	ON public."file"
	FOR SELECT
	TO authenticated
	USING (user_id = auth.uid());