import { BaseSchema } from '@adonisjs/lucid/schema';
export default class extends BaseSchema {
    tableName = 'scammer_guards';
    async up() {
        this.schema.alterTable(this.tableName, (table) => {
            table.timestamp('expires_at').nullable().after('last_seen_at');
            table.integer('threshold').notNullable().defaultTo(0).after('expires_at').comment('0 = disabled, >0 = auto-blacklist after N keyword hits');
            table.text('notes').nullable().after('threshold');
        });
    }
    async down() {
        this.schema.alterTable(this.tableName, (table) => {
            table.dropColumn('expires_at');
            table.dropColumn('threshold');
            table.dropColumn('notes');
        });
    }
}
