import { Kysely, sql } from 'kysely' export async function up(db: Kysely): Promise { await db.schema .createTable('labeler') .addColumn('uri', 'varchar', (col) => col.primaryKey()) .addColumn('cid', 'varchar', (col) => col.notNull()) .addColumn('creator', 'varchar', (col) => col.notNull()) .addColumn('createdAt', 'varchar', (col) => col.notNull()) .addColumn('indexedAt', 'varchar', (col) => col.notNull()) .addColumn('sortAt', 'varchar', (col) => col .generatedAlwaysAs(sql`least("createdAt", "indexedAt")`) .stored() .notNull(), ) .execute() await db.schema .createIndex('labeler_order_by_idx') .on('labeler') .columns(['sortAt', 'cid']) .execute() } export async function down(db: Kysely): Promise { await db.schema.dropTable('labeler').execute() }