-- Create tasks tableCREATETABLEIF NOT EXISTS tasks ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), user_id UUID NOT NULLREFERENCESauth.users(id) ON DELETE CASCADE, title TEXTNOT NULL, description TEXT DEFAULT '', priority TEXTNOT NULLCHECK (priority IN ('Low', 'Medium', 'High')), due_date TIMESTAMPTZNOT NULL, status TEXTNOT NULL DEFAULT 'Pending'CHECK (status IN ('Pending', 'In Progress', 'Completed')), created_at TIMESTAMPTZ DEFAULT NOW(), updated_at TIMESTAMPTZ DEFAULT NOW() ); -- Create index for user_id lookupsCREATEINDEXIF NOT EXISTS idx_tasks_user_id ON tasks(user_id); -- Create index for filtering by statusCREATEINDEXIF NOT EXISTS idx_tasks_status ON tasks(status); -- Create index for sorting by due_dateCREATEINDEXIF NOT EXISTS idx_tasks_due_date ON tasks(due_date); -- Enable Row Level SecurityALTERTABLE tasks ENABLE ROW LEVEL SECURITY; -- Create policies-- Users can only see their own tasks CREATE POLICY "Users can view own tasks"ON tasks FOR SELECT USING (auth.uid() = user_id); -- Users can insert their own tasks CREATE POLICY "Users can insert own tasks"ON tasks FOR INSERT WITH CHECK (auth.uid() = user_id); -- Users can update their own tasks CREATE POLICY "Users can update own tasks"ON tasks FOR UPDATE USING (auth.uid() = user_id) WITH CHECK (auth.uid() = user_id); -- Users can delete their own tasks CREATE POLICY "Users can delete own tasks"ON tasks FOR DELETE USING (auth.uid() = user_id); -- Create function to update updated_at timestampCREATE OR REPLACEFUNCTIONupdate_updated_at_column() RETURNS TRIGGER AS $$ BEGINNEW.updated_at= NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; -- Create trigger to auto-update updated_atCREATETRIGGERupdate_tasks_updated_at BEFORE UPDATEON tasks FOR EACH ROW EXECUTE FUNCTION update_updated_at_column();