openDatabase(
path,
version: 3,
onCreate: (db, version) async {
await db.execute('''
CREATE TABLE notes (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
body TEXT NOT NULL,
created_at INTEGER NOT NULL
)
''');
await _v2Migration(db);
await _v3Migration(db);
},
onUpgrade: (db, oldVersion, newVersion) async {
if (oldVersion < 2) await _v2Migration(db);
if (oldVersion < 3) await _v3Migration(db);
},
);