ONLINE QURAN INSTITUTE

Management Staff Portal

Welcome to the Online Quran Institute back-office dashboard. Under strict data safety protocols, administrators can audit course admissions, message inquiries, and track incoming student logs.

Single-Slot Authorization Active: Only one administrative ledger can exist. This role acts as the exclusive custodian of school submissions.

Database Enforcement SQL

Execute this migration script in your Supabase SQL editor to enable single-slot security constraints on profiles.

-- ONLINE QURAN INSTITUTE - DATABASE CONFIGURATION
-- Run this in your Supabase SQL Editor to enforce single-slot admin:

-- Create profiles table linked to authentication schema
CREATE TABLE IF NOT EXISTS public.profiles (
    id UUID REFERENCES auth.users(id) ON DELETE CASCADE PRIMARY KEY,
    updated_at TIMESTAMP WITH TIME ZONE DEFAULT timezone('utc'::text, now()),
    email TEXT UNIQUE NOT NULL,
    is_admin BOOLEAN DEFAULT false NOT NULL
);

-- Enforce ONLY ONE row can have is_admin = true
CREATE UNIQUE INDEX IF NOT EXISTS single_admin_slot_enforcement 
ON public.profiles (is_admin) 
WHERE (is_admin = true);

Sign In Portal

Local Bypass Option is available for validation. Email: admin@website.com / Pass: admin