ALTER TABLE helicopter_files ADD COLUMN position INT NOT NULL DEFAULT 1 AFTER section, ADD KEY idx_helicopter_files_position (position); UPDATE helicopter_files SET position = 1 WHERE position IS NULL OR position <= 0;