Function setSchemaVersion

packages/core/src/schema/migrations.ts:38–47

(db: DatabaseAdapter, version: number)

 * 设置数据库的 schema 版本
 */
export function setSchemaVersion(db: DatabaseAdapter, version: number): void {
  const tableInfo = db.pragma('table_info(meta)') as Array<{ name: string }>
  const hasVersionColumn = tableInfo.some((col) => col.name === 'schema_version')

  if (!hasVersionColumn) {
    db.exec('ALTER TABLE meta ADD COLUMN schema_version INTEGER DEFAULT 0')
  }

  db.prepare('UPDATE meta SET schema_version = ?').run(version)
}

/**
 * 检查数据库是否需要迁移