diff options
Diffstat (limited to 'drizzle/meta')
| -rw-r--r-- | drizzle/meta/0000_snapshot.json | 64 | ||||
| -rw-r--r-- | drizzle/meta/0001_snapshot.json | 172 | ||||
| -rw-r--r-- | drizzle/meta/_journal.json | 11 |
3 files changed, 65 insertions, 182 deletions
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 } ] |