tars / shared /models /auth.ts
surekim's picture
Upload 109 files
390536f verified
Raw History Blame Contribute Delete
1.02 kB
import { sql } from "drizzle-orm";
import { index, integer, jsonb, pgTable, timestamp, varchar } from "drizzle-orm/pg-core";
export const sessions = pgTable(
"sessions",
{
sid: varchar("sid").primaryKey(),
sess: jsonb("sess").notNull(),
expire: timestamp("expire").notNull(),
},
(table) => [index("IDX_session_expire").on(table.expire)]
);
export const users = pgTable("users", {
id: varchar("id").primaryKey().default(sql`gen_random_uuid()`),
email: varchar("email").unique(),
firstName: varchar("first_name"),
lastName: varchar("last_name"),
profileImageUrl: varchar("profile_image_url"),
credits: integer("credits").default(0).notNull(),
freeUsesRemaining: integer("free_uses_remaining").default(3).notNull(),
totalAnalyses: integer("total_analyses").default(0).notNull(),
createdAt: timestamp("created_at").defaultNow(),
updatedAt: timestamp("updated_at").defaultNow(),
});
export type UpsertUser = typeof users.$inferInsert;
export type User = typeof users.$inferSelect;