10 lines
362 B
TypeScript
10 lines
362 B
TypeScript
import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'
|
|
|
|
export const todos = sqliteTable('todos', {
|
|
id: integer('id').primaryKey(),
|
|
userId: integer('user_id').notNull(), // GitHub Id
|
|
title: text('title').notNull(),
|
|
completed: integer('completed').notNull().default(0),
|
|
createdAt: integer('created_at', { mode: 'timestamp' }).notNull()
|
|
})
|