🔔 Notifications & Email Reminders
Recent Notifications Sent
🎬 Video Lessons Manager
⚙️ One-time SQL setup: Run in Supabase SQL Editor:
ALTER TABLE topic_videos ADD COLUMN IF NOT EXISTS video_url text DEFAULT '';
INSERT INTO storage.buckets (id,name,public) VALUES ('topic-videos','topic-videos',true) ON CONFLICT DO NOTHING;
INSERT INTO storage.buckets (id,name,public) VALUES ('summary-notes','summary-notes',true) ON CONFLICT DO NOTHING;
CREATE POLICY IF NOT EXISTS "pub_read_vids" ON storage.objects FOR SELECT USING (bucket_id='topic-videos');
CREATE POLICY IF NOT EXISTS "pub_ins_vids" ON storage.objects FOR INSERT WITH CHECK (bucket_id='topic-videos');
CREATE POLICY IF NOT EXISTS "pub_read_notes" ON storage.objects FOR SELECT USING (bucket_id='summary-notes');
CREATE POLICY IF NOT EXISTS "pub_ins_notes" ON storage.objects FOR INSERT WITH CHECK (bucket_id='summary-notes');
✍️ Essay Questions Manager
⚙️ Supabase Setup Required
Run this SQL in your Supabase SQL Editor before using this section:
CREATE TABLE IF NOT EXISTS essay_questions (
id uuid DEFAULT gen_random_uuid() PRIMARY KEY,
subject text NOT NULL,
year integer NOT NULL,
question_type text DEFAULT 'essay',
question_text text NOT NULL,
parts text DEFAULT '',
marking_guide text DEFAULT '',
total_marks integer DEFAULT 20,
difficulty text DEFAULT 'Medium',
image_url text DEFAULT '',
created_at timestamptz DEFAULT now()
);
ALTER TABLE essay_questions DISABLE ROW LEVEL SECURITY;
-- If table already exists, run this to add the column:
ALTER TABLE essay_questions ADD COLUMN IF NOT EXISTS image_url text DEFAULT '';
| Subject | Year | Type | Preview | Marks | Actions |
|---|
| No essay questions yet. |
