quilling.dev
An ATproto social media client -- with an independent Appview.
1import {Kysely} from 'kysely'
2
3export async function up(db: Kysely<unknown>): Promise<void> {
4 await db.schema
5 .createTable('link')
6 .addColumn('id', 'varchar', col => col.primaryKey())
7 .addColumn('type', 'smallint', col => col.notNull()) // integer enum: 1->starterpack
8 .addColumn('path', 'varchar', col => col.notNull())
9 .addUniqueConstraint('link_path_unique', ['path'])
10 .execute()
11}
12
13export async function down(db: Kysely<unknown>): Promise<void> {
14 await db.schema.dropTable('link').execute()
15}