alter table flights add column flight_id int not null auto_increment, add primary key (flight_id), lock=shared;