Set Up Database and Seed Data

This will:

  1. Create tables in the public schema
  2. Set up Row Level Security (RLS) policies
  3. Seed employee data for Monirul and Mansoor
  4. Add attendance records for March 1-4, 2025

Warning

This will delete any existing data in the employees and attendance tables. Only proceed if you want to reset your database to a clean state.

Data to be added:

Employee Name: Monirul

Daily Wage: INR 650

Attendance: Present from March 1st to 4th, 2025

Employee Name: Mansoor

Daily Wage: INR 500

Attendance: Present on March 1st, 2nd, 3rd, 2025. Absent on March 4th, 2025