-- Add RTL Continuity Columns
-- Menambahkan kolom tipe tindakan dan link ke standar

-- Add 'type' column (correction vs improvement)
ALTER TABLE rtm_action_items
ADD COLUMN type ENUM('correction', 'improvement') NOT NULL DEFAULT 'correction' AFTER status;

-- Add 'related_standard_id' column (link to standard for improvement)
ALTER TABLE rtm_action_items
ADD COLUMN related_standard_id VARCHAR(255) NULL AFTER type;

-- Optional: Add index for performance
CREATE INDEX idx_rtm_action_items_related_std ON rtm_action_items(related_standard_id);