-- Migration: Add user_id column to tasks table
-- This migration adds the user_id column to the tasks table for personal workspace isolation

-- Add user_id column to tasks table (nullable initially for existing tasks)
ALTER TABLE `tasks` ADD COLUMN `user_id` varchar(36) NOT NULL DEFAULT '' AFTER `id`;

-- Create index on user_id for optimization
CREATE INDEX `idx_tasks_user_id` ON `tasks` (`user_id`);
