import { migrate, Migrations, undo } from "https://esm.town/v/saolsen/sqlite_migrations";
const MIGRATIONS: Migrations = {
name: "test_migrations",
migrations: [
{
name: `example_user table`,
up: `create table example_user (
id integer primary key autoincrement,
username text not null
) strict`,
down: `drop table example_user`,
},
{
name: `example_user username index`,
up: `create unique index idx_example_user_username on example_user (username)`,
down: `drop index idx_example_user_username`,
},
],
};
await migrate(MIGRATIONS);