aboutsummaryrefslogtreecommitdiff
path: root/src/lib/server/db/schema.ts
diff options
context:
space:
mode:
authorMartin Kagamino Lehoux <martin@lehoux.net>2026-07-29 15:01:38 +0200
committerMartin Kagamino Lehoux <martin@lehoux.net>2026-07-29 15:01:38 +0200
commit63e003a718782e2ca3ffcb2d11b0be97560a7259 (patch)
treee38ed25161981ec33aebc7d76e9303e547d42768 /src/lib/server/db/schema.ts
parent684d3c954e3577a6488101bf5ee85e36439fd53c (diff)
feat: drag-to-reorder categories with persistent order
Diffstat (limited to 'src/lib/server/db/schema.ts')
-rw-r--r--src/lib/server/db/schema.ts1
1 files changed, 1 insertions, 0 deletions
diff --git a/src/lib/server/db/schema.ts b/src/lib/server/db/schema.ts
index fae002d..31c2f65 100644
--- a/src/lib/server/db/schema.ts
+++ b/src/lib/server/db/schema.ts
@@ -3,6 +3,7 @@ import { sqliteTable, text, integer, real } from 'drizzle-orm/sqlite-core';
export const categories = sqliteTable('categories', {
id: integer('id').primaryKey({ autoIncrement: true }),
name: text('name').notNull().unique(),
+ order: integer('order').notNull().default(0),
});
export const groceries = sqliteTable('groceries', {