aboutsummaryrefslogtreecommitdiff
path: root/drizzle/0000_known_scarecrow.sql
diff options
context:
space:
mode:
authorMartin Kagamino Lehoux <martin@lehoux.net>2026-07-27 18:31:26 +0200
committerMartin Kagamino Lehoux <martin@lehoux.net>2026-07-27 18:31:26 +0200
commite14717b2e7853705469275d64023bb902b195ebb (patch)
tree2e450f7b4e864e232d06df43ad1aba1b62be4f4c /drizzle/0000_known_scarecrow.sql
parent8224c7d6572db6ec76c4224eec1df8a538b47ad4 (diff)
feat: separate categories table + /categories management page
- Categories table (id, name unique) with FK from groceries.category_id - /categories page for add/delete categories - Main page uses native <select> dropdown for category - Categories grouped by name in list/catalog views - Regenerated drizzle migrations from scratch
Diffstat (limited to 'drizzle/0000_known_scarecrow.sql')
-rw-r--r--drizzle/0000_known_scarecrow.sql6
1 files changed, 0 insertions, 6 deletions
diff --git a/drizzle/0000_known_scarecrow.sql b/drizzle/0000_known_scarecrow.sql
deleted file mode 100644
index 7d70133..0000000
--- a/drizzle/0000_known_scarecrow.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-CREATE TABLE `groceries` (
- `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- `name` text NOT NULL,
- `checked` integer DEFAULT false NOT NULL,
- `created_at` text NOT NULL
-);