all repos — stealth-developers @ 124009fe8d16aefd3401cb00740df5e6d26d6a44

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(),
});