all repos — stealth-developers @ 09081644ff2bf482c3c68319af758a28e1626a15

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