Create a new table, add triggers from old table to new table (with new column(s)), copy data, once everything is copied, switch the tables
Create a new table, add triggers from old table to new table (with new column(s)), copy data, once everything is copied, switch the tables