-- Swift Attendance: Secure Setup CREATE TABLE students ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, name TEXT NOT NULL, enrollment_no TEXT UNIQUE NOT NULL, pu_mail TEXT, phone TEXT, collage TEXT, department TEXT, branch TEXT, face_descriptor JSONB NOT NULL, created_at TIMESTAMPTZ DEFAULT NOW() ); CREATE TABLE attendance ( id UUID DEFAULT gen_random_uuid() PRIMARY KEY, student_id UUID REFERENCES students(id) ON DELETE CASCADE, date DATE NOT NULL DEFAULT CURRENT_DATE, time_in TIME NOT NULL DEFAULT CURRENT_TIME, created_at TIMESTAMPTZ DEFAULT NOW(), UNIQUE(student_id, date) ); ALTER TABLE students ENABLE ROW LEVEL SECURITY; ALTER TABLE attendance ENABLE ROW LEVEL SECURITY; CREATE POLICY "Public: Read students" ON students FOR SELECT USING (true); CREATE POLICY "Admin: Manage students" ON students FOR ALL TO authenticated USING (true); CREATE POLICY "Public: Read attendance" ON attendance FOR SELECT USING (true); CREATE POLICY "Public: Insert attendance" ON attendance FOR INSERT WITH CHECK (true); CREATE POLICY "Admin: Manage attendance" ON attendance FOR ALL TO authenticated USING (true);