The ALTER TABLE ADD COLUMN command will add the new column to the end of the table. If you need to change the position of a column within a table, you have to re-create the table. Here's what you'll need to do:

1. Create new table with correct column order.

2. INSERT into new table from old table.

3. Drop FK constraints from old table.

4. Drop old table

5. rename new table to old name

6. Recreate FKs.