مشروع تطبيقي: تطبيق مهام كامل

// Add task categories
CREATE TABLE categories (
  id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  name TEXT NOT NULL,
  color TEXT DEFAULT '#3B82F6',
  user_id UUID REFERENCES auth.users(id) ON DELETE CASCADE,
  created_at TIMESTAMPTZ DEFAULT NOW()
);
ALTER TABLE categories ENABLE ROW LEVEL SECURITY;
CREATE POLICY "Users manage own categories" ON categories
  FOR ALL USING (auth.uid() = user_id);

// Add priority column
ALTER TABLE tasks ADD COLUMN priority TEXT
  DEFAULT 'medium'
  CHECK (priority IN ('low', 'medium', 'high', 'urgent'));