import { Kysely } from 'kysely'

export async function up(db: Kysely<unknown>): Promise<void> {
  await db.schema
    .createTable('thread_gate')
    .addColumn('uri', 'varchar', (col) => col.primaryKey())
    .addColumn('cid', 'varchar', (col) => col.notNull())
    .addColumn('creator', 'varchar', (col) => col.notNull())
    .addColumn('postUri', 'varchar', (col) => col.notNull().unique())
    .addColumn('createdAt', 'varchar', (col) => col.notNull())
    .addColumn('indexedAt', 'varchar', (col) => col.notNull())
    .execute()
  await db.schema
    .alterTable('post')
    .addColumn('invalidReplyRoot', 'boolean')
    .execute()
  await db.schema
    .alterTable('post')
    .addColumn('violatesThreadGate', 'boolean')
    .execute()
}

export async function down(db: Kysely<unknown>): Promise<void> {
  await db.schema.dropTable('thread_gate').execute()
  await db.schema.alterTable('post').dropColumn('invalidReplyRoot').execute()
  await db.schema.alterTable('post').dropColumn('violatesThreadGate').execute()
}