SQLeditor_/create_user_programs_table.sql at main · syntax-error002/SQLeditor_ · GitHub

40 lines (34 loc) · 1.25 KB

-- Create the user_programs table

CREATE TABLE IF NOT EXISTS user_programs (

id UUID PRIMARY KEY DEFAULT gen_random_uuid(),

user_id UUID NOT NULL REFERENCES auth.users(id) ON DELETE CASCADE,

name TEXT NOT NULL,

sql TEXT NOT NULL,

created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),

updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()

);

-- Create index for faster queries

CREATE INDEX IF NOT EXISTS user_programs_user_id_idx ON user_programs(user_id);

-- Set up Row Level Security (RLS)

ALTER TABLE user_programs ENABLE ROW LEVEL SECURITY;

-- Create policies

-- Policy to allow users to select only their own programs

CREATE POLICY "Users can view their own programs"

ON user_programs

FOR SELECT

USING (auth.uid() = user_id);

-- Policy to allow users to insert their own programs

CREATE POLICY "Users can insert their own programs"

ON user_programs

FOR INSERT

WITH CHECK (auth.uid() = user_id);

-- Policy to allow users to update only their own programs

CREATE POLICY "Users can update their own programs"

ON user_programs

FOR UPDATE

USING (auth.uid() = user_id);

-- Policy to allow users to delete only their own programs

CREATE POLICY "Users can delete their own programs"

ON user_programs

FOR DELETE

USING (auth.uid() = user_id);

Expand file tree