-- generated sql
import { pgTable, serial, text, varchar, timestamp, uuid } from "drizzle-orm/pg-core";
export const userTable = pgTable("user", {
id: text("id").primaryKey(),
username: varchar("username").notNull().unique(),
email: varchar("email").notNull().unique(),
password: varchar("password").notNull(),
});
export const sessionTable = pgTable("session", {
id: text("id").primaryKey(),
userId: text("user_id")
.notNull()
.references(() => userTable.id),
expiresAt: timestamp("expires_at", {
withTimezone: true,
mode: "date"
}).notNull()
});
-- generated sql
import { pgTable, serial, text, varchar, timestamp, uuid } from "drizzle-orm/pg-core";
export const userTable = pgTable("user", {
id: text("id").primaryKey(),
username: varchar("username").notNull().unique(),
email: varchar("email").notNull().unique(),
password: varchar("password").notNull(),
});
export const sessionTable = pgTable("session", {
id: text("id").primaryKey(),
userId: text("user_id")
.notNull()
.references(() => userTable.id),
expiresAt: timestamp("expires_at", {
withTimezone: true,
mode: "date"
}).notNull()
});