mirror of
https://gitlab.com/soapbox-pub/ditto.git
synced 2025-12-06 11:29:46 +00:00
15 lines
595 B
TypeScript
15 lines
595 B
TypeScript
import { type Kysely, sql } from 'kysely';
|
|
|
|
export async function up(db: Kysely<unknown>): Promise<void> {
|
|
await db.schema
|
|
.createTable('domain_favicons')
|
|
.addColumn('domain', 'varchar(253)', (col) => col.primaryKey())
|
|
.addColumn('favicon', 'varchar(2048)', (col) => col.notNull())
|
|
.addColumn('last_updated_at', 'integer', (col) => col.notNull())
|
|
.addCheckConstraint('domain_favicons_https_chk', sql`favicon ~* '^https:\\/\\/'`)
|
|
.execute();
|
|
}
|
|
|
|
export async function down(db: Kysely<unknown>): Promise<void> {
|
|
await db.schema.dropTable('domain_favicons').execute();
|
|
}
|