alter table android add column service_type varchar(255) not null default 'fcm'; insert into android (user_id, ts, regid, service_type) select user_id, ts, url regid, 'mpns' from winphone; insert into android (user_id, ts, regid, service_type) select user_id, ts, token regid, 'apns' from ios;