Scratch space for learning atproto app development
cduck.me
1import type { Kysely, Migration, MigrationProvider } from 'kysely'
2
3const migrations: Record<string, Migration> = {}
4
5export const migrationProvider: MigrationProvider = {
6 async getMigrations() {
7 return migrations
8 },
9}
10
11migrations['001'] = {
12 async up(db: Kysely<unknown>) {
13 await db.schema
14 .createTable('post')
15 .addColumn('uri', 'varchar', (col) => col.primaryKey())
16 .addColumn('text', 'varchar', (col) => col.notNull())
17 .addColumn('indexedAt', 'varchar', (col) => col.notNull())
18 .execute()
19 },
20 async down(db: Kysely<unknown>) {
21 await db.schema.dropTable('post').execute()
22 },
23}