import { sql, relations } from "drizzle-orm";
import {
index,
pgTableCreator,
serial,
text,
timestamp,
varchar,
uuid,
pgEnum,
bigint,
pgTable,
pgSchema,
numeric,
jsonb,
} from "drizzle-orm/pg-core";
export const createTable = pgTableCreator((name) => `${name}`);
export const user = createTable(
"user",
{
id: uuid("id").primaryKey().defaultRandom(),
name: varchar("name", { length: 256 }),
nonce: text("nonce").notNull(),
createdAt: timestamp("created_at")
.default(sql`CURRENT_TIMESTAMP`)
.notNull(),
updatedAt: timestamp("updated_at")
.notNull()
.$onUpdate(() => new Date()),
},
(example) => ({
nameIndex: index("name_idx").on(example.name),
}),
);
import { sql, relations } from "drizzle-orm";
import {
index,
pgTableCreator,
serial,
text,
timestamp,
varchar,
uuid,
pgEnum,
bigint,
pgTable,
pgSchema,
numeric,
jsonb,
} from "drizzle-orm/pg-core";
export const createTable = pgTableCreator((name) => `${name}`);
export const user = createTable(
"user",
{
id: uuid("id").primaryKey().defaultRandom(),
name: varchar("name", { length: 256 }),
nonce: text("nonce").notNull(),
createdAt: timestamp("created_at")
.default(sql`CURRENT_TIMESTAMP`)
.notNull(),
updatedAt: timestamp("updated_at")
.notNull()
.$onUpdate(() => new Date()),
},
(example) => ({
nameIndex: index("name_idx").on(example.name),
}),
);