ALTER TABLE member DROP COLUMN id;
ALTER TABLE member ADD id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST;
<update id="deleteId">
ALTER TABLE member DROP COLUMN id;
</update>
<update id="addId">
ALTER TABLE member ADD id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT FIRST;
</update>