diff options
Diffstat (limited to 'src/lib/server/db/schema.ts')
| -rw-r--r-- | src/lib/server/db/schema.ts | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/lib/server/db/schema.ts b/src/lib/server/db/schema.ts index 9113d9b..fae002d 100644 --- a/src/lib/server/db/schema.ts +++ b/src/lib/server/db/schema.ts @@ -10,7 +10,9 @@ export const groceries = sqliteTable('groceries', { 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), + categoryId: integer('category_id').references(() => categories.id, { + onDelete: 'set null', + }), }); export const references = sqliteTable('references', { |