diff options
Diffstat (limited to 'packages/web/src/server/db')
| -rw-r--r-- | packages/web/src/server/db/schema.ts | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/packages/web/src/server/db/schema.ts b/packages/web/src/server/db/schema.ts index aae0ace..6b3965a 100644 --- a/packages/web/src/server/db/schema.ts +++ b/packages/web/src/server/db/schema.ts @@ -9,15 +9,17 @@ import { index, pgTableCreator } from "drizzle-orm/pg-core"; export const createTable = pgTableCreator((name) => `web_${name}`); export const posts = createTable( "post", - (d) => ({ - id: d.integer().primaryKey().generatedByDefaultAsIdentity(), - name: d.varchar({ length: 256 }), - createdById: d.varchar({ length: 255 }).notNull(), - createdAt: d + (columnBuilder) => ({ + id: columnBuilder.integer().primaryKey().generatedByDefaultAsIdentity(), + name: columnBuilder.varchar({ length: 256 }), + createdById: columnBuilder.varchar({ length: 255 }).notNull(), + createdAt: columnBuilder .timestamp({ withTimezone: true }) .$defaultFn(() => new Date()) .notNull(), - updatedAt: d.timestamp({ withTimezone: true }).$onUpdate(() => new Date()), + updatedAt: columnBuilder + .timestamp({ withTimezone: true }) + .$onUpdate(() => new Date()), }), (t) => [ index("created_by_idx").on(t.createdById), |