import { sql } from "drizzle-orm";
import { integer, sqliteTable, text } from "drizzle-orm/sqlite-core";

export const userPreferences = sqliteTable("user_preferences", {
	userId: text("user_id").primaryKey(),
	uwuifyMessages: text("uwuify_messages", { enum: ["enabled", "disabled"] })
		.default("disabled")
		.notNull(),
});

export const uwuifyRateLimit = sqliteTable("uwuify_rate_limit", {
	userId: text("user_id").primaryKey(),
	count: integer("count").default(0).notNull(),
	resetAt: integer("reset_at", { mode: "timestamp" }).notNull(),
});

export type UserPreference = typeof userPreferences.$inferSelect;
export type UwuifyRateLimit = typeof uwuifyRateLimit.$inferSelect;