Yeah, this is like an altertable, you can't run it more than once without causing troubles.
The errors you show now are because you already ran it. We still don't know what the real error was when you ran it the first time.
If you need to run it on a db that you already ran it on, you could try commenting out the two queries which alter the tables... the update part of the script should do the trick.