export const userTableSchema = pgTable(
"user",
{
id: text("id")
.$defaultFn(() => createId())
.primaryKey()
.notNull(),
createdAt: timestamp("created_at", {
withTimezone: true,
mode: "date",
}).notNull(),
confirmedEmail: boolean("confirmed_email")
.notNull()
.$default(() => false),
confirmedPhone: boolean("confirmed_phone")
.notNull()
.$default(() => false),
name: varchar("name", { length: 255 }).notNull(),
email: varchar("email", { length: 255 }).notNull(),
},
(table) => {
return {
emailIdx: uniqueIndex("users_email_idx").on(table.email),
}
}
)
export const userTableSchema = pgTable(
"user",
{
id: text("id")
.$defaultFn(() => createId())
.primaryKey()
.notNull(),
createdAt: timestamp("created_at", {
withTimezone: true,
mode: "date",
}).notNull(),
confirmedEmail: boolean("confirmed_email")
.notNull()
.$default(() => false),
confirmedPhone: boolean("confirmed_phone")
.notNull()
.$default(() => false),
name: varchar("name", { length: 255 }).notNull(),
email: varchar("email", { length: 255 }).notNull(),
},
(table) => {
return {
emailIdx: uniqueIndex("users_email_idx").on(table.email),
}
}
)