import type { Kysely } from 'kysely';
import { sql } from 'kysely';
export async function up(db: Kysely<unknown>): Promise<void> {
await sql`
CREATE TABLE task_updates (
id TEXT PRIMARY KEY,
task_id TEXT NOT NULL,
content TEXT NOT NULL,
created_at TEXT NOT NULL,
FOREIGN KEY (task_id) REFERENCES tasks(id) ON DELETE CASCADE
)
`.execute(db);
await sql`CREATE INDEX idx_task_updates_task_id ON task_updates(task_id)`.execute(db);
}
export async function down(db: Kysely<unknown>): Promise<void> {
await sql`DROP INDEX IF EXISTS idx_task_updates_task_id`.execute(db);
await sql`DROP TABLE IF EXISTS task_updates`.execute(db);
}
