diff options
Diffstat (limited to 'drizzle')
| -rw-r--r-- | drizzle/0001_dear_bastion.sql | 1 | ||||
| -rw-r--r-- | drizzle/meta/0001_snapshot.json | 63 | ||||
| -rw-r--r-- | drizzle/meta/_journal.json | 7 |
3 files changed, 71 insertions, 0 deletions
diff --git a/drizzle/0001_dear_bastion.sql b/drizzle/0001_dear_bastion.sql new file mode 100644 index 0000000..ecc896d --- /dev/null +++ b/drizzle/0001_dear_bastion.sql @@ -0,0 +1 @@ +CREATE UNIQUE INDEX `groceries_name_unique` ON `groceries` (`name`);
\ No newline at end of file diff --git a/drizzle/meta/0001_snapshot.json b/drizzle/meta/0001_snapshot.json new file mode 100644 index 0000000..92fe548 --- /dev/null +++ b/drizzle/meta/0001_snapshot.json @@ -0,0 +1,63 @@ +{ + "version": "6", + "dialect": "sqlite", + "id": "b20afe62-9a50-42b6-bb34-1be35863e817", + "prevId": "265bc06f-5de9-43a2-9427-39ce061f134c", + "tables": { + "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 + } + }, + "indexes": { + "groceries_name_unique": { + "name": "groceries_name_unique", + "columns": ["name"], + "isUnique": true + } + }, + "foreignKeys": {}, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "checkConstraints": {} + } + }, + "views": {}, + "enums": {}, + "_meta": { + "schemas": {}, + "tables": {}, + "columns": {} + }, + "internal": { + "indexes": {} + } +} diff --git a/drizzle/meta/_journal.json b/drizzle/meta/_journal.json index 77a9b2e..7e6fb0d 100644 --- a/drizzle/meta/_journal.json +++ b/drizzle/meta/_journal.json @@ -8,6 +8,13 @@ "when": 1785163537728, "tag": "0000_known_scarecrow", "breakpoints": true + }, + { + "idx": 1, + "version": "6", + "when": 1785165400399, + "tag": "0001_dear_bastion", + "breakpoints": true } ] } |