Task Management System Round Two

ALTER TABLE TaskFlowUser ALTER COLUMN Email NVARCHAR(50);
ALTER TABLE TaskFlowUser ALTER COLUMN ContactNo NVARCHAR(10);


-- Migration Script: Update TaskFlowPlan Priority column to use codes L/M/H
-- Execute this script in your database to update the Priority column

-- Step 1: Update existing data from text to codes
UPDATE TaskFlowPlan 
SET Priority = CASE 
    WHEN LTRIM(RTRIM(Priority)) = 'Low' THEN 'L'
    WHEN LTRIM(RTRIM(Priority)) = 'Medium' THEN 'M' 
    WHEN LTRIM(RTRIM(Priority)) = 'High' THEN 'H'
    ELSE 'M' -- Default to Medium for any unexpected values
END
WHERE Priority IS NOT NULL;

-- Step 2: Alter column to NVARCHAR(1)
ALTER TABLE TaskFlowPlan 
ALTER COLUMN Priority NVARCHAR(1);


INSERT INTO DeleteInfo 
(mastercolumn,tablename,internalcolumn)
VALUES
('TaskUserId','TaskFlowPlan','AssignedTo'),
('TaskUserId','TaskFlowPlan','CreatedBy'),
('TaskTypeCode','TaskFlowPlan','TaskTypeCode'),
('PartyId','TaskFlowPlan','PartyId'),
('RmItemId','TaskFlowPlan','ItemId'),
('FgItemId','TaskFlowPlan','ItemId');