diff options
Diffstat (limited to 'src/lib/server/db/schema.ts')
| -rw-r--r-- | src/lib/server/db/schema.ts | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/src/lib/server/db/schema.ts b/src/lib/server/db/schema.ts index 403ef51..1d5fd9e 100644 --- a/src/lib/server/db/schema.ts +++ b/src/lib/server/db/schema.ts @@ -1,8 +1,14 @@ import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'; +export const categories = sqliteTable('categories', { + id: integer('id').primaryKey({ autoIncrement: true }), + name: text('name').notNull().unique(), +}); + export const groceries = sqliteTable('groceries', { id: integer('id').primaryKey({ autoIncrement: true }), name: text('name').notNull().unique(), checked: integer('checked', { mode: 'boolean' }).notNull().default(false), createdAt: text('created_at').notNull(), + categoryId: integer('category_id').references(() => categories.id), }); |