bskylink/src/db/migrations/001-init.ts


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

import {Kysely} from 'kysely'

export async function up(db: Kysely<unknown>): Promise<void> {
  await db.schema
    .createTable('link')
    .addColumn('id', 'varchar', col => col.primaryKey())
    .addColumn('type', 'smallint', col => col.notNull()) // integer enum: 1->starterpack
    .addColumn('path', 'varchar', col => col.notNull())
    .addUniqueConstraint('link_path_unique', ['path'])
    .execute()
}

export async function down(db: Kysely<unknown>): Promise<void> {
  await db.schema.dropTable('link').execute()
}