No steps yet.
Click + Add Step to build your workflow.
-- Run in Supabase SQL Editor to enable custom modules (once per environment).
-- Same DDL as supabase/migrations/2026-11-05-custom-modules.sql.
-- Idempotent: CREATE TABLE IF NOT EXISTS, DROP POLICY IF EXISTS.
CREATE TABLE IF NOT EXISTS public.custom_modules (
id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
org_id UUID,
name TEXT NOT NULL,
icon TEXT DEFAULT 'π',
description TEXT,
access_level TEXT DEFAULT 'all',
config JSONB DEFAULT '{}',
created_by UUID,
created_at TIMESTAMPTZ DEFAULT NOW(),
is_active BOOLEAN DEFAULT TRUE
);
CREATE INDEX IF NOT EXISTS idx_custom_modules_org
ON public.custom_modules (org_id, created_at DESC);
ALTER TABLE public.custom_modules ENABLE ROW LEVEL SECURITY;
DROP POLICY IF EXISTS "custom_modules_org" ON public.custom_modules;
CREATE POLICY "custom_modules_org"
ON public.custom_modules
FOR ALL
USING (org_id = public.get_my_org_id())
WITH CHECK (org_id = public.get_my_org_id());
revoke all on public.custom_modules from anon;
grant select, insert, update, delete on public.custom_modules to authenticated;
grant select, insert, update, delete on public.custom_modules to service_role;