If you combine the ALTER TABLE statements for adding the new column and dropping the old index, implementation will be much easier