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