-- Add can_import and can_change_owner columns to role_permissions table
ALTER TABLE role_permissions 
ADD COLUMN can_import BOOLEAN DEFAULT FALSE AFTER can_export,
ADD COLUMN can_change_owner BOOLEAN DEFAULT FALSE AFTER can_import;

-- Update Admin role to have these permissions for all modules
UPDATE role_permissions SET can_import = 1, can_change_owner = 1 WHERE role_id = 1;
