schema.ts
For the full content of this gist, refer to https://gist.github.com/CodingAbdullah/c1635b4005578e31b1a99fd1d556dec0
McMaster. Software Engineer with a keen interest in blockchain and web3.
import { pgTable, serial, timestamp, varchar } from 'drizzle-orm/pg-core';
// User Table Schema setup complete
export const users = pgTable('users', {
id: serial('id').primaryKey(),
name: varchar('name', { length: 255 }).notNull(),
email: varchar('email', { length: 255 }).notNull().unique(),
createdAt: timestamp('created_at').defaultNow().notNull(),
updatedAt: timestamp('updated_at').defaultNow().notNull()
});
export type User = typeof users.$inferSelect;
export type NewUser = typeof users.$inferInsert;