Demo: v2 to v3 sqlite3

v2tov3.sql

/* 更新数据表结构*/
CREATE TABLE IF NOT EXISTS "mapping_user_plan" (
  "id" integer PRIMARY KEY,
  "user_id" integer,
  "plan_id" integer,
  "created_at" text
);

/* 也可以更新数据 */
insert into mapping_user_plan(user_id, plan_id, created_at) select 1, id, created_at from plan;

/* 最后设置 user version */
PRAGMA user_version=3;