all repos — stealth-developers @ 89e4c7ff2aa4e6d6e161f82ee270a6fb7662c00a

pkgs/db/src/schemas/automod.ts (view raw)

 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 
import * as s from "drizzle-orm/sqlite-core";

export const imageHashes = s.sqliteTable("image_hashes", {
	id: s
		.text()
		.primaryKey()
		.$default(() => crypto.randomUUID()),
	hash: s.text().notNull().unique(),

	firstSeen: s.integer("first_seen", { mode: "timestamp" }).$default(() => new Date()),
	lastSeen: s.integer("last_seen", { mode: "timestamp" }).$default(() => new Date()),
	seenTimes: s.integer("seen_times").default(1).notNull(),
});