select @maxId1 := (select COALESCE(max(ID),0)+1 from SMP_REV_INFO);
set @qry1 = concat('alter table SMP_REV_INFO auto_increment=',@maxId1);
prepare stmt1 from @qry1; execute stmt1; deallocate prepare stmt1;

select @maxId2 := (select COALESCE(max(ID),0)+1 from SMP_SERVICE_GROUP);
set @qry2 = concat('alter table SMP_SERVICE_GROUP auto_increment=',@maxId2);
prepare stmt2 from @qry2; execute stmt2; deallocate prepare stmt2;

select @maxId3 := (select COALESCE(max(ID),0)+1 from SMP_SERVICE_GROUP_DOMAIN);
set @qry3 = concat('alter table SMP_SERVICE_GROUP_DOMAIN auto_increment=',@maxId3);
prepare stmt3 from @qry3; execute stmt3; deallocate prepare stmt3;

select @maxId4 := (select COALESCE(max(ID),0)+1 from SMP_SERVICE_METADATA);
set @qry4 = concat('alter table SMP_SERVICE_METADATA auto_increment=',@maxId4);
prepare stmt4 from @qry4; execute stmt4; deallocate prepare stmt4;

select @maxId5 := (select COALESCE(max(ID),0)+1 from SMP_USER);
set @qry5 = concat('alter table SMP_USER auto_increment=',@maxId5);
prepare stmt5 from @qry5; execute stmt5; deallocate prepare stmt5;

SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE SMP_DOMAIN MODIFY COLUMN ID bigint not null auto_increment;
select @maxId6 := (select COALESCE(max(ID),0)+1 from SMP_DOMAIN);
set @qry6 = concat('alter table SMP_DOMAIN auto_increment=',@maxId6);
prepare stmt6 from @qry6; execute stmt6; deallocate prepare stmt6;
SET FOREIGN_KEY_CHECKS = 1; 
commit;