aboutsummaryrefslogtreecommitdiff
path: root/drizzle
diff options
context:
space:
mode:
Diffstat (limited to 'drizzle')
-rw-r--r--drizzle/0000_greedy_masked_marvel.sql (renamed from drizzle/0000_youthful_mercury.sql)11
-rw-r--r--drizzle/0001_dry_meteorite.sql9
-rw-r--r--drizzle/meta/0000_snapshot.json64
-rw-r--r--drizzle/meta/0001_snapshot.json172
-rw-r--r--drizzle/meta/_journal.json11
5 files changed, 75 insertions, 192 deletions
diff --git a/drizzle/0000_youthful_mercury.sql b/drizzle/0000_greedy_masked_marvel.sql
index 6dde7ff..45556f1 100644
--- a/drizzle/0000_youthful_mercury.sql
+++ b/drizzle/0000_greedy_masked_marvel.sql
@@ -13,4 +13,13 @@ CREATE TABLE `groceries` (
FOREIGN KEY (`category_id`) REFERENCES `categories`(`id`) ON UPDATE no action ON DELETE no action
);
--> statement-breakpoint
-CREATE UNIQUE INDEX `groceries_name_unique` ON `groceries` (`name`); \ No newline at end of file
+CREATE UNIQUE INDEX `groceries_name_unique` ON `groceries` (`name`);--> statement-breakpoint
+CREATE TABLE `references` (
+ `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
+ `grocery_id` integer NOT NULL,
+ `reference` text NOT NULL,
+ `price` real,
+ `unit` text,
+ `quality_score` integer,
+ FOREIGN KEY (`grocery_id`) REFERENCES `groceries`(`id`) ON UPDATE no action ON DELETE cascade
+);
diff --git a/drizzle/0001_dry_meteorite.sql b/drizzle/0001_dry_meteorite.sql
deleted file mode 100644
index ae22f4b..0000000
--- a/drizzle/0001_dry_meteorite.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-CREATE TABLE `references` (
- `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
- `grocery_id` integer NOT NULL,
- `brand` text NOT NULL,
- `price` real,
- `unit` text,
- `quality_score` integer,
- FOREIGN KEY (`grocery_id`) REFERENCES `groceries`(`id`) ON UPDATE no action ON DELETE cascade
-);
diff --git a/drizzle/meta/0000_snapshot.json b/drizzle/meta/0000_snapshot.json
index 6e33354..5f30c67 100644
--- a/drizzle/meta/0000_snapshot.json
+++ b/drizzle/meta/0000_snapshot.json
@@ -1,7 +1,7 @@
{
"version": "6",
"dialect": "sqlite",
- "id": "54c7ae45-9838-4ffb-ad46-29995def7272",
+ "id": "be05d3e6-4ab4-4a59-a592-6459b19b440f",
"prevId": "00000000-0000-0000-0000-000000000000",
"tables": {
"categories": {
@@ -95,6 +95,68 @@
"compositePrimaryKeys": {},
"uniqueConstraints": {},
"checkConstraints": {}
+ },
+ "references": {
+ "name": "references",
+ "columns": {
+ "id": {
+ "name": "id",
+ "type": "integer",
+ "primaryKey": true,
+ "notNull": true,
+ "autoincrement": true
+ },
+ "grocery_id": {
+ "name": "grocery_id",
+ "type": "integer",
+ "primaryKey": false,
+ "notNull": true,
+ "autoincrement": false
+ },
+ "reference": {
+ "name": "reference",
+ "type": "text",
+ "primaryKey": false,
+ "notNull": true,
+ "autoincrement": false
+ },
+ "price": {
+ "name": "price",
+ "type": "real",
+ "primaryKey": false,
+ "notNull": false,
+ "autoincrement": false
+ },
+ "unit": {
+ "name": "unit",
+ "type": "text",
+ "primaryKey": false,
+ "notNull": false,
+ "autoincrement": false
+ },
+ "quality_score": {
+ "name": "quality_score",
+ "type": "integer",
+ "primaryKey": false,
+ "notNull": false,
+ "autoincrement": false
+ }
+ },
+ "indexes": {},
+ "foreignKeys": {
+ "references_grocery_id_groceries_id_fk": {
+ "name": "references_grocery_id_groceries_id_fk",
+ "tableFrom": "references",
+ "tableTo": "groceries",
+ "columnsFrom": ["grocery_id"],
+ "columnsTo": ["id"],
+ "onDelete": "cascade",
+ "onUpdate": "no action"
+ }
+ },
+ "compositePrimaryKeys": {},
+ "uniqueConstraints": {},
+ "checkConstraints": {}
}
},
"views": {},
diff --git a/drizzle/meta/0001_snapshot.json b/drizzle/meta/0001_snapshot.json
deleted file mode 100644
index 21f509e..0000000
--- a/drizzle/meta/0001_snapshot.json
+++ /dev/null
@@ -1,172 +0,0 @@
-{
- "version": "6",
- "dialect": "sqlite",
- "id": "52dffa39-fdb4-4a7c-8688-136e0ad485fc",
- "prevId": "54c7ae45-9838-4ffb-ad46-29995def7272",
- "tables": {
- "categories": {
- "name": "categories",
- "columns": {
- "id": {
- "name": "id",
- "type": "integer",
- "primaryKey": true,
- "notNull": true,
- "autoincrement": true
- },
- "name": {
- "name": "name",
- "type": "text",
- "primaryKey": false,
- "notNull": true,
- "autoincrement": false
- }
- },
- "indexes": {
- "categories_name_unique": {
- "name": "categories_name_unique",
- "columns": ["name"],
- "isUnique": true
- }
- },
- "foreignKeys": {},
- "compositePrimaryKeys": {},
- "uniqueConstraints": {},
- "checkConstraints": {}
- },
- "groceries": {
- "name": "groceries",
- "columns": {
- "id": {
- "name": "id",
- "type": "integer",
- "primaryKey": true,
- "notNull": true,
- "autoincrement": true
- },
- "name": {
- "name": "name",
- "type": "text",
- "primaryKey": false,
- "notNull": true,
- "autoincrement": false
- },
- "checked": {
- "name": "checked",
- "type": "integer",
- "primaryKey": false,
- "notNull": true,
- "autoincrement": false,
- "default": false
- },
- "created_at": {
- "name": "created_at",
- "type": "text",
- "primaryKey": false,
- "notNull": true,
- "autoincrement": false
- },
- "category_id": {
- "name": "category_id",
- "type": "integer",
- "primaryKey": false,
- "notNull": false,
- "autoincrement": false
- }
- },
- "indexes": {
- "groceries_name_unique": {
- "name": "groceries_name_unique",
- "columns": ["name"],
- "isUnique": true
- }
- },
- "foreignKeys": {
- "groceries_category_id_categories_id_fk": {
- "name": "groceries_category_id_categories_id_fk",
- "tableFrom": "groceries",
- "tableTo": "categories",
- "columnsFrom": ["category_id"],
- "columnsTo": ["id"],
- "onDelete": "no action",
- "onUpdate": "no action"
- }
- },
- "compositePrimaryKeys": {},
- "uniqueConstraints": {},
- "checkConstraints": {}
- },
- "references": {
- "name": "references",
- "columns": {
- "id": {
- "name": "id",
- "type": "integer",
- "primaryKey": true,
- "notNull": true,
- "autoincrement": true
- },
- "grocery_id": {
- "name": "grocery_id",
- "type": "integer",
- "primaryKey": false,
- "notNull": true,
- "autoincrement": false
- },
- "brand": {
- "name": "brand",
- "type": "text",
- "primaryKey": false,
- "notNull": true,
- "autoincrement": false
- },
- "price": {
- "name": "price",
- "type": "real",
- "primaryKey": false,
- "notNull": false,
- "autoincrement": false
- },
- "unit": {
- "name": "unit",
- "type": "text",
- "primaryKey": false,
- "notNull": false,
- "autoincrement": false
- },
- "quality_score": {
- "name": "quality_score",
- "type": "integer",
- "primaryKey": false,
- "notNull": false,
- "autoincrement": false
- }
- },
- "indexes": {},
- "foreignKeys": {
- "references_grocery_id_groceries_id_fk": {
- "name": "references_grocery_id_groceries_id_fk",
- "tableFrom": "references",
- "tableTo": "groceries",
- "columnsFrom": ["grocery_id"],
- "columnsTo": ["id"],
- "onDelete": "cascade",
- "onUpdate": "no action"
- }
- },
- "compositePrimaryKeys": {},
- "uniqueConstraints": {},
- "checkConstraints": {}
- }
- },
- "views": {},
- "enums": {},
- "_meta": {
- "schemas": {},
- "tables": {},
- "columns": {}
- },
- "internal": {
- "indexes": {}
- }
-}
diff --git a/drizzle/meta/_journal.json b/drizzle/meta/_journal.json
index 9872346..10dce89 100644
--- a/drizzle/meta/_journal.json
+++ b/drizzle/meta/_journal.json
@@ -5,15 +5,8 @@
{
"idx": 0,
"version": "6",
- "when": 1785169427572,
- "tag": "0000_youthful_mercury",
- "breakpoints": true
- },
- {
- "idx": 1,
- "version": "6",
- "when": 1785170535526,
- "tag": "0001_dry_meteorite",
+ "when": 1785179210259,
+ "tag": "0000_greedy_masked_marvel",
"breakpoints": true
}
]
generated by cgit v1.3 (git 2.53.0) at 2026-10-18 15:52:50 +0000