Sprint Planner

1. Create a Supabase project

Sign up at supabase.com and create a new project.

2. Set up environment variables

Update your .env.local file with the Supabase URL and anon key:

NEXT_PUBLIC_SUPABASE_URL=your-project-url
NEXT_PUBLIC_SUPABASE_ANON_KEY=your-anon-key

3. Create the required tables

Run the following SQL in the Supabase SQL editor:

-- Create user_stories table
CREATE TABLE user_stories (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  title TEXT NOT NULL,
  description TEXT NOT NULL,
  stakeholder TEXT NOT NULL CHECK (stakeholder IN ('teacher', 'admin', 'student')),
  milestone TEXT NOT NULL CHECK (milestone IN ('May', 'June', 'July', 'August')),
  effort DECIMAL NOT NULL,
  status TEXT NOT NULL DEFAULT 'backlog' CHECK (status IN ('backlog', 'todo', 'in-progress', 'review', 'done')),
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

-- Create audit_logs table
CREATE TABLE audit_logs (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  story_id UUID REFERENCES user_stories(id),
  action TEXT NOT NULL CHECK (action IN ('created', 'updated', 'moved')),
  from_milestone TEXT CHECK (from_milestone IN ('May', 'June', 'July', 'August')),
  to_milestone TEXT CHECK (to_milestone IN ('May', 'June', 'July', 'August')),
  from_status TEXT,
  to_status TEXT,
  timestamp TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  user_id TEXT NOT NULL
);

-- Create row level security policies
ALTER TABLE user_stories ENABLE ROW LEVEL SECURITY;
ALTER TABLE audit_logs ENABLE ROW LEVEL SECURITY;

-- Create policies that allow all operations for now (you can restrict these later)
CREATE POLICY "Allow all operations on user_stories" 
  ON user_stories FOR ALL 
  USING (true) 
  WITH CHECK (true);

CREATE POLICY "Allow all operations on audit_logs" 
  ON audit_logs FOR ALL 
  USING (true) 
  WITH CHECK (true);

4. Enable realtime updates (optional)

For realtime updates, enable the Realtime feature in the Supabase dashboard and add the following to the Replication settings:

database:
  tables:
    user_stories:
      - INSERT
      - UPDATE
      - DELETE
    audit_logs:
      - INSERT

5. Import sample data

To populate your sprint planner with sample user stories based on this project's milestones, use the Import Data tool.