import { extractValInfo } from "https://esm.town/v/pomdtr/extractValInfo";
import { migrate, Migrations, undo } from "https://esm.town/v/saolsen/sqlite_migrations";
const { name } = extractValInfo(import.meta.url);
const MIGRATIONS: Migrations = {
name,
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);