Test

CREATE TABLE IF NOT EXISTS public.events ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), title VARCHAR(255) NOT NULL, slug VARCHAR(255) UNIQUE NOT NULL, event_date DATE NOT NULL, time_start VARCHAR(50) NOT NULL, time_end VARCHAR(50) NOT NULL, event_type VARCHAR(100) NOT NULL, -- e.g., 'Webinar', 'Masterclass', 'Virtual Fair' description TEXT, speaker VARCHAR(255), agenda JSONB DEFAULT '[]'::jsonb, status VARCHAR(50) DEFAULT 'DRAFT', -- 'DRAFT', 'PUBLISHED' created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Optional: Enable Row Level Security (RLS) if you haven't already disabled it globally ALTER TABLE public.events ENABLE ROW LEVEL SECURITY; -- Optional: Create basic policies so anyone can read PUBLISHED events, but only admins can do all CREATE POLICY "Public can view published events" ON public.events FOR SELECT USING (status = 'PUBLISHED'); CREATE POLICY "Admins can manage all events" ON public.events USING (true) WITH CHECK (true);CREATE TABLE IF NOT EXISTS public.events ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), title VARCHAR(255) NOT NULL, slug VARCHAR(255) UNIQUE NOT NULL, event_date DATE NOT NULL, time_start VARCHAR(50) NOT NULL, time_end VARCHAR(50) NOT NULL, event_type VARCHAR(100) NOT NULL, -- e.g., 'Webinar', 'Masterclass', 'Virtual Fair' description TEXT, speaker VARCHAR(255), agenda JSONB DEFAULT '[]'::jsonb, status VARCHAR(50) DEFAULT 'DRAFT', -- 'DRAFT', 'PUBLISHED' created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Optional: Enable Row Level Security (RLS) if you haven't already disabled it globally ALTER TABLE public.events ENABLE ROW LEVEL SECURITY; -- Optional: Create basic policies so anyone can read PUBLISHED events, but only admins can do all CREATE POLICY "Public can view published events" ON public.events FOR SELECT USING (status = 'PUBLISHED'); CREATE POLICY "Admins can manage all events" ON public.events USING (true) WITH CHECK (true);CREATE TABLE IF NOT EXISTS public.events ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), title VARCHAR(255) NOT NULL, slug VARCHAR(255) UNIQUE NOT NULL, event_date DATE NOT NULL, time_start VARCHAR(50) NOT NULL, time_end VARCHAR(50) NOT NULL, event_type VARCHAR(100) NOT NULL, -- e.g., 'Webinar', 'Masterclass', 'Virtual Fair' description TEXT, speaker VARCHAR(255), agenda JSONB DEFAULT '[]'::jsonb, status VARCHAR(50) DEFAULT 'DRAFT', -- 'DRAFT', 'PUBLISHED' created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Optional: Enable Row Level Security (RLS) if you haven't already disabled it globally ALTER TABLE public.events ENABLE ROW LEVEL SECURITY; -- Optional: Create basic policies so anyone can read PUBLISHED events, but only admins can do all CREATE POLICY "Public can view published events" ON public.events FOR SELECT USING (status = 'PUBLISHED'); CREATE POLICY "Admins can manage all events" ON public.events USING (true) WITH CHECK (true);CREATE TABLE IF NOT EXISTS public.events ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), title VARCHAR(255) NOT NULL, slug VARCHAR(255) UNIQUE NOT NULL, event_date DATE NOT NULL, time_start VARCHAR(50) NOT NULL, time_end VARCHAR(50) NOT NULL, event_type VARCHAR(100) NOT NULL, -- e.g., 'Webinar', 'Masterclass', 'Virtual Fair' description TEXT, speaker VARCHAR(255), agenda JSONB DEFAULT '[]'::jsonb, status VARCHAR(50) DEFAULT 'DRAFT', -- 'DRAFT', 'PUBLISHED' created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(), updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() ); -- Optional: Enable Row Level Security (RLS) if you haven't already disabled it globally ALTER TABLE public.events ENABLE ROW LEVEL SECURITY; -- Optional: Create basic policies so anyone can read PUBLISHED events, but only admins can do all CREATE POLICY "Public can view published events" ON public.events FOR SELECT USING (status = 'PUBLISHED'); CREATE POLICY "Admins can manage all events" ON public.events USING (true) WITH CHECK (true);