From 57f5faa7b5ba7a43bb09555741a207c0113e9d62 Mon Sep 17 00:00:00 2001 From: MohamedBassem Date: Sat, 28 Sep 2024 22:24:42 +0000 Subject: deps: Upgrade drizzle-kit --- packages/db/drizzle.config.ts | 2 +- packages/db/drizzle/meta/0000_snapshot.json | 144 +- packages/db/drizzle/meta/0001_snapshot.json | 63 +- packages/db/drizzle/meta/0002_snapshot.json | 81 +- packages/db/drizzle/meta/0003_snapshot.json | 81 +- packages/db/drizzle/meta/0004_snapshot.json | 81 +- packages/db/drizzle/meta/0005_snapshot.json | 81 +- packages/db/drizzle/meta/0006_snapshot.json | 81 +- packages/db/drizzle/meta/0007_snapshot.json | 81 +- packages/db/drizzle/meta/0008_snapshot.json | 81 +- packages/db/drizzle/meta/0009_snapshot.json | 81 +- packages/db/drizzle/meta/0010_snapshot.json | 87 +- packages/db/drizzle/meta/0011_snapshot.json | 99 +- packages/db/drizzle/meta/0012_snapshot.json | 87 +- packages/db/drizzle/meta/0013_snapshot.json | 87 +- packages/db/drizzle/meta/0014_snapshot.json | 87 +- packages/db/drizzle/meta/0015_snapshot.json | 87 +- packages/db/drizzle/meta/0016_snapshot.json | 87 +- packages/db/drizzle/meta/0017_snapshot.json | 87 +- packages/db/drizzle/meta/0018_snapshot.json | 87 +- packages/db/drizzle/meta/0019_snapshot.json | 93 +- packages/db/drizzle/meta/0020_snapshot.json | 93 +- packages/db/drizzle/meta/0021_snapshot.json | 93 +- packages/db/drizzle/meta/0022_snapshot.json | 93 +- packages/db/drizzle/meta/0023_snapshot.json | 2041 +++++++++++++-------------- packages/db/drizzle/meta/0024_snapshot.json | 99 +- packages/db/drizzle/meta/0025_snapshot.json | 99 +- packages/db/drizzle/meta/0026_snapshot.json | 99 +- packages/db/package.json | 2 +- 29 files changed, 2195 insertions(+), 2169 deletions(-) (limited to 'packages/db') diff --git a/packages/db/drizzle.config.ts b/packages/db/drizzle.config.ts index 25a7675f..dca30914 100644 --- a/packages/db/drizzle.config.ts +++ b/packages/db/drizzle.config.ts @@ -7,9 +7,9 @@ const databaseURL = serverConfig.dataDir : "./db.db"; export default { + dialect: "sqlite", schema: "./schema.ts", out: "./drizzle", - driver: "better-sqlite", dbCredentials: { url: databaseURL, }, diff --git a/packages/db/drizzle/meta/0000_snapshot.json b/packages/db/drizzle/meta/0000_snapshot.json index a61b516d..24ec7d2a 100644 --- a/packages/db/drizzle/meta/0000_snapshot.json +++ b/packages/db/drizzle/meta/0000_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "926e135f-db63-4273-b193-4eb2b5c1784d", - "prevId": "00000000-0000-0000-0000-000000000000", "tables": { "account": { "name": "account", @@ -90,16 +88,23 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", + "columnsFrom": [ + "userId" + ], "tableTo": "user", - "columnsFrom": ["userId"], - "columnsTo": ["id"], - "onDelete": "cascade", - "onUpdate": "no action" + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { "account_provider_providerAccountId_pk": { - "columns": ["provider", "providerAccountId"], + "columns": [ + "provider", + "providerAccountId" + ], "name": "account_provider_providerAccountId_pk" } }, @@ -154,17 +159,24 @@ "indexes": { "apiKey_name_unique": { "name": "apiKey_name_unique", - "columns": ["name"], + "columns": [ + "name" + ], "isUnique": true }, "apiKey_keyId_unique": { "name": "apiKey_keyId_unique", - "columns": ["keyId"], + "columns": [ + "keyId" + ], "isUnique": true }, "apiKey_name_userId_unique": { "name": "apiKey_name_userId_unique", - "columns": ["name", "userId"], + "columns": [ + "name", + "userId" + ], "isUnique": true } }, @@ -172,11 +184,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", + "columnsFrom": [ + "userId" + ], "tableTo": "user", - "columnsFrom": ["userId"], - "columnsTo": ["id"], - "onDelete": "cascade", - "onUpdate": "no action" + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -240,11 +256,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", + "columnsFrom": [ + "id" + ], "tableTo": "bookmarks", - "columnsFrom": ["id"], - "columnsTo": ["id"], - "onDelete": "cascade", - "onUpdate": "no action" + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -285,7 +305,10 @@ "indexes": { "bookmarkTags_userId_name_unique": { "name": "bookmarkTags_userId_name_unique", - "columns": ["userId", "name"], + "columns": [ + "userId", + "name" + ], "isUnique": true } }, @@ -293,11 +316,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", + "columnsFrom": [ + "userId" + ], "tableTo": "user", - "columnsFrom": ["userId"], - "columnsTo": ["id"], - "onDelete": "cascade", - "onUpdate": "no action" + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -349,11 +376,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", + "columnsFrom": [ + "userId" + ], "tableTo": "user", - "columnsFrom": ["userId"], - "columnsTo": ["id"], - "onDelete": "cascade", - "onUpdate": "no action" + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -389,11 +420,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", + "columnsFrom": [ + "userId" + ], "tableTo": "user", - "columnsFrom": ["userId"], - "columnsTo": ["id"], - "onDelete": "cascade", - "onUpdate": "no action" + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -436,25 +471,36 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", + "columnsFrom": [ + "bookmarkId" + ], "tableTo": "bookmarks", - "columnsFrom": ["bookmarkId"], - "columnsTo": ["id"], - "onDelete": "cascade", - "onUpdate": "no action" + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", + "columnsFrom": [ + "tagId" + ], "tableTo": "bookmarkTags", - "columnsFrom": ["tagId"], - "columnsTo": ["id"], - "onDelete": "cascade", - "onUpdate": "no action" + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { "tagsOnBookmarks_bookmarkId_tagId_pk": { - "columns": ["bookmarkId", "tagId"], + "columns": [ + "bookmarkId", + "tagId" + ], "name": "tagsOnBookmarks_bookmarkId_tagId_pk" } }, @@ -509,7 +555,9 @@ "indexes": { "user_email_unique": { "name": "user_email_unique", - "columns": ["email"], + "columns": [ + "email" + ], "isUnique": true } }, @@ -546,7 +594,10 @@ "foreignKeys": {}, "compositePrimaryKeys": { "verificationToken_identifier_token_pk": { - "columns": ["identifier", "token"], + "columns": [ + "identifier", + "token" + ], "name": "verificationToken_identifier_token_pk" } }, @@ -555,8 +606,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } -} + }, + "id": "926e135f-db63-4273-b193-4eb2b5c1784d", + "prevId": "00000000-0000-0000-0000-000000000000" +} \ No newline at end of file diff --git a/packages/db/drizzle/meta/0001_snapshot.json b/packages/db/drizzle/meta/0001_snapshot.json index 16915666..7b68e66b 100644 --- a/packages/db/drizzle/meta/0001_snapshot.json +++ b/packages/db/drizzle/meta/0001_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "30b63cde-0b6e-42fd-8755-edb258b04dd0", - "prevId": "926e135f-db63-4273-b193-4eb2b5c1784d", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -186,15 +184,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -258,15 +256,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -318,15 +316,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -355,15 +353,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -415,15 +413,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -459,15 +457,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -510,28 +508,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -645,8 +643,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "30b63cde-0b6e-42fd-8755-edb258b04dd0", + "prevId": "926e135f-db63-4273-b193-4eb2b5c1784d" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0002_snapshot.json b/packages/db/drizzle/meta/0002_snapshot.json index 7e682a9f..c85727c6 100644 --- a/packages/db/drizzle/meta/0002_snapshot.json +++ b/packages/db/drizzle/meta/0002_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "e0b3dd84-57d4-4adb-97da-98a6ff5d7d34", - "prevId": "30b63cde-0b6e-42fd-8755-edb258b04dd0", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -186,15 +184,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -258,15 +256,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -325,15 +323,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -385,15 +383,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -422,15 +420,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -482,15 +480,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -526,28 +524,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -591,15 +589,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -642,28 +640,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -777,8 +775,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "e0b3dd84-57d4-4adb-97da-98a6ff5d7d34", + "prevId": "30b63cde-0b6e-42fd-8755-edb258b04dd0" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0003_snapshot.json b/packages/db/drizzle/meta/0003_snapshot.json index 5b75ceb2..c72c34e8 100644 --- a/packages/db/drizzle/meta/0003_snapshot.json +++ b/packages/db/drizzle/meta/0003_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "28b3c23e-65eb-44b4-bf9c-8573a6ccde8a", - "prevId": "e0b3dd84-57d4-4adb-97da-98a6ff5d7d34", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -186,15 +184,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -258,15 +256,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -325,15 +323,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -385,15 +383,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -422,15 +420,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -482,15 +480,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -526,28 +524,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -591,15 +589,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -642,28 +640,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -785,8 +783,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "28b3c23e-65eb-44b4-bf9c-8573a6ccde8a", + "prevId": "e0b3dd84-57d4-4adb-97da-98a6ff5d7d34" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0004_snapshot.json b/packages/db/drizzle/meta/0004_snapshot.json index 50f21cf3..3386c482 100644 --- a/packages/db/drizzle/meta/0004_snapshot.json +++ b/packages/db/drizzle/meta/0004_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "c8e820c3-3f51-4109-a4b8-b11741e956b4", - "prevId": "28b3c23e-65eb-44b4-bf9c-8573a6ccde8a", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -186,15 +184,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -265,15 +263,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -332,15 +330,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -392,15 +390,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -429,15 +427,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -489,15 +487,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -533,28 +531,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -598,15 +596,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -649,28 +647,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -792,8 +790,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "c8e820c3-3f51-4109-a4b8-b11741e956b4", + "prevId": "28b3c23e-65eb-44b4-bf9c-8573a6ccde8a" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0005_snapshot.json b/packages/db/drizzle/meta/0005_snapshot.json index 3fcba2fb..db7f8968 100644 --- a/packages/db/drizzle/meta/0005_snapshot.json +++ b/packages/db/drizzle/meta/0005_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "cf381349-a0ec-420a-8719-fe1d2d8a6882", - "prevId": "c8e820c3-3f51-4109-a4b8-b11741e956b4", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -258,15 +256,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -325,15 +323,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -385,15 +383,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -422,15 +420,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -482,15 +480,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -526,28 +524,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -591,15 +589,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -642,28 +640,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -785,8 +783,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "cf381349-a0ec-420a-8719-fe1d2d8a6882", + "prevId": "c8e820c3-3f51-4109-a4b8-b11741e956b4" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0006_snapshot.json b/packages/db/drizzle/meta/0006_snapshot.json index 33adf4b2..39d804c2 100644 --- a/packages/db/drizzle/meta/0006_snapshot.json +++ b/packages/db/drizzle/meta/0006_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "e07f4785-769a-41bc-b7d1-be6cf996a106", - "prevId": "cf381349-a0ec-420a-8719-fe1d2d8a6882", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -258,15 +256,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -325,15 +323,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -385,15 +383,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -422,15 +420,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -490,15 +488,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -534,28 +532,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -599,15 +597,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -650,28 +648,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -793,8 +791,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "e07f4785-769a-41bc-b7d1-be6cf996a106", + "prevId": "cf381349-a0ec-420a-8719-fe1d2d8a6882" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0007_snapshot.json b/packages/db/drizzle/meta/0007_snapshot.json index 41eb56de..285a0850 100644 --- a/packages/db/drizzle/meta/0007_snapshot.json +++ b/packages/db/drizzle/meta/0007_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "a8e7f612-a65b-4988-90fb-175723d8aaec", - "prevId": "e07f4785-769a-41bc-b7d1-be6cf996a106", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -265,15 +263,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -332,15 +330,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -392,15 +390,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -429,15 +427,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -497,15 +495,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -541,28 +539,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -606,15 +604,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -657,28 +655,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -800,8 +798,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "a8e7f612-a65b-4988-90fb-175723d8aaec", + "prevId": "e07f4785-769a-41bc-b7d1-be6cf996a106" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0008_snapshot.json b/packages/db/drizzle/meta/0008_snapshot.json index fd7efb69..ae9d91fc 100644 --- a/packages/db/drizzle/meta/0008_snapshot.json +++ b/packages/db/drizzle/meta/0008_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "0ec154ac-9cca-4621-b8d8-215c6ce22154", - "prevId": "a8e7f612-a65b-4988-90fb-175723d8aaec", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -265,15 +263,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -339,15 +337,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -413,15 +411,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -450,15 +448,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -540,15 +538,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -599,28 +597,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -664,15 +662,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -730,28 +728,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -873,8 +871,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "0ec154ac-9cca-4621-b8d8-215c6ce22154", + "prevId": "a8e7f612-a65b-4988-90fb-175723d8aaec" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0009_snapshot.json b/packages/db/drizzle/meta/0009_snapshot.json index 72f3aa99..d089c804 100644 --- a/packages/db/drizzle/meta/0009_snapshot.json +++ b/packages/db/drizzle/meta/0009_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "11bbea06-c80c-4030-9a54-7dd9f1d13235", - "prevId": "0ec154ac-9cca-4621-b8d8-215c6ce22154", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -265,15 +263,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -339,15 +337,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -413,15 +411,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -450,15 +448,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -547,15 +545,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -606,28 +604,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -671,15 +669,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -737,28 +735,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -880,8 +878,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "11bbea06-c80c-4030-9a54-7dd9f1d13235", + "prevId": "0ec154ac-9cca-4621-b8d8-215c6ce22154" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0010_snapshot.json b/packages/db/drizzle/meta/0010_snapshot.json index f3557a33..3a57873d 100644 --- a/packages/db/drizzle/meta/0010_snapshot.json +++ b/packages/db/drizzle/meta/0010_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "3c99cddb-9a13-42a5-a5e3-3b42cc33bad5", - "prevId": "11bbea06-c80c-4030-9a54-7dd9f1d13235", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -252,15 +250,15 @@ "assets_userId_user_id_fk": { "name": "assets_userId_user_id_fk", "tableFrom": "assets", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -338,15 +336,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -412,15 +410,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -486,15 +484,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -523,15 +521,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -620,15 +618,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -679,28 +677,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -744,15 +742,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -810,28 +808,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -953,8 +951,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "3c99cddb-9a13-42a5-a5e3-3b42cc33bad5", + "prevId": "11bbea06-c80c-4030-9a54-7dd9f1d13235" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0011_snapshot.json b/packages/db/drizzle/meta/0011_snapshot.json index f55a875d..cb732b4e 100644 --- a/packages/db/drizzle/meta/0011_snapshot.json +++ b/packages/db/drizzle/meta/0011_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "a5520e12-3a85-4783-af68-fc4c14ab5485", - "prevId": "3c99cddb-9a13-42a5-a5e3-3b42cc33bad5", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -252,15 +250,15 @@ "assets_userId_user_id_fk": { "name": "assets_userId_user_id_fk", "tableFrom": "assets", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -296,28 +294,28 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarkAssets_assetId_assets_id_fk": { "name": "bookmarkAssets_assetId_assets_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "assets", "columnsFrom": [ "assetId" ], + "tableTo": "assets", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -395,15 +393,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -469,15 +467,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -543,15 +541,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -580,15 +578,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -677,15 +675,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -736,28 +734,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -801,15 +799,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -867,28 +865,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -1010,8 +1008,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "a5520e12-3a85-4783-af68-fc4c14ab5485", + "prevId": "3c99cddb-9a13-42a5-a5e3-3b42cc33bad5" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0012_snapshot.json b/packages/db/drizzle/meta/0012_snapshot.json index 4c1d2c5e..fd199add 100644 --- a/packages/db/drizzle/meta/0012_snapshot.json +++ b/packages/db/drizzle/meta/0012_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "1bfe76b3-a1df-4d6b-aed3-fa27a33eceed", - "prevId": "a5520e12-3a85-4783-af68-fc4c14ab5485", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -223,15 +221,15 @@ "bookmarkAssets2_id_bookmarks_id_fk": { "name": "bookmarkAssets2_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets2", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -309,15 +307,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -383,15 +381,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -457,15 +455,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -494,15 +492,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -591,15 +589,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -650,28 +648,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -715,15 +713,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -781,28 +779,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -924,8 +922,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "1bfe76b3-a1df-4d6b-aed3-fa27a33eceed", + "prevId": "a5520e12-3a85-4783-af68-fc4c14ab5485" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0013_snapshot.json b/packages/db/drizzle/meta/0013_snapshot.json index 750baf37..dd07dfeb 100644 --- a/packages/db/drizzle/meta/0013_snapshot.json +++ b/packages/db/drizzle/meta/0013_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "fe8beb72-9585-4552-b636-a06f08c63cf8", - "prevId": "1bfe76b3-a1df-4d6b-aed3-fa27a33eceed", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -223,15 +221,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -309,15 +307,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -383,15 +381,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -457,15 +455,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -494,15 +492,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -591,15 +589,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -650,28 +648,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -715,15 +713,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -781,28 +779,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -924,10 +922,11 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": { "\"bookmarkAssets2\"": "\"bookmarkAssets\"" }, "columns": {} - } + }, + "id": "fe8beb72-9585-4552-b636-a06f08c63cf8", + "prevId": "1bfe76b3-a1df-4d6b-aed3-fa27a33eceed" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0014_snapshot.json b/packages/db/drizzle/meta/0014_snapshot.json index ccb88221..db578ff5 100644 --- a/packages/db/drizzle/meta/0014_snapshot.json +++ b/packages/db/drizzle/meta/0014_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "55a06f75-6b46-41d9-9f39-d842f065551d", - "prevId": "fe8beb72-9585-4552-b636-a06f08c63cf8", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -223,15 +221,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -309,15 +307,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -383,15 +381,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -457,15 +455,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -494,15 +492,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -598,15 +596,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -657,28 +655,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -722,15 +720,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -788,28 +786,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -931,8 +929,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "55a06f75-6b46-41d9-9f39-d842f065551d", + "prevId": "fe8beb72-9585-4552-b636-a06f08c63cf8" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0015_snapshot.json b/packages/db/drizzle/meta/0015_snapshot.json index 0726ee73..f536c9df 100644 --- a/packages/db/drizzle/meta/0015_snapshot.json +++ b/packages/db/drizzle/meta/0015_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "72cbe030-48d3-4cd6-ae90-8897291cd711", - "prevId": "55a06f75-6b46-41d9-9f39-d842f065551d", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -244,15 +242,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -330,15 +328,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -404,15 +402,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -478,15 +476,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -515,15 +513,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -619,15 +617,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -678,28 +676,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -743,15 +741,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -809,28 +807,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -952,8 +950,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "72cbe030-48d3-4cd6-ae90-8897291cd711", + "prevId": "55a06f75-6b46-41d9-9f39-d842f065551d" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0016_snapshot.json b/packages/db/drizzle/meta/0016_snapshot.json index b6780914..04510de7 100644 --- a/packages/db/drizzle/meta/0016_snapshot.json +++ b/packages/db/drizzle/meta/0016_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "72b4a92d-dcf7-4a16-9f58-14dca905cbd4", - "prevId": "72cbe030-48d3-4cd6-ae90-8897291cd711", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -244,15 +242,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -330,15 +328,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -404,15 +402,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -478,15 +476,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -515,15 +513,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -619,15 +617,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -678,28 +676,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -743,15 +741,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -809,28 +807,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -952,8 +950,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "72b4a92d-dcf7-4a16-9f58-14dca905cbd4", + "prevId": "72cbe030-48d3-4cd6-ae90-8897291cd711" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0017_snapshot.json b/packages/db/drizzle/meta/0017_snapshot.json index 7bff464b..a66acd5f 100644 --- a/packages/db/drizzle/meta/0017_snapshot.json +++ b/packages/db/drizzle/meta/0017_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "58699146-ac61-4f68-94d3-645566b26b52", - "prevId": "72b4a92d-dcf7-4a16-9f58-14dca905cbd4", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -244,15 +242,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -338,15 +336,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -412,15 +410,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -486,15 +484,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -523,15 +521,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -627,15 +625,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -686,28 +684,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -751,15 +749,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -817,28 +815,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -960,8 +958,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "58699146-ac61-4f68-94d3-645566b26b52", + "prevId": "72b4a92d-dcf7-4a16-9f58-14dca905cbd4" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0018_snapshot.json b/packages/db/drizzle/meta/0018_snapshot.json index 331b2773..e01d0a03 100644 --- a/packages/db/drizzle/meta/0018_snapshot.json +++ b/packages/db/drizzle/meta/0018_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "ca4ff2bd-aed3-474d-92a1-68e3a8349e01", - "prevId": "58699146-ac61-4f68-94d3-645566b26b52", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -244,15 +242,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -338,15 +336,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -412,15 +410,15 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -486,15 +484,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -523,15 +521,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -634,15 +632,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -693,28 +691,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -758,15 +756,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -824,28 +822,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -967,8 +965,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "ca4ff2bd-aed3-474d-92a1-68e3a8349e01", + "prevId": "58699146-ac61-4f68-94d3-645566b26b52" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0019_snapshot.json b/packages/db/drizzle/meta/0019_snapshot.json index b60ba498..9a48148d 100644 --- a/packages/db/drizzle/meta/0019_snapshot.json +++ b/packages/db/drizzle/meta/0019_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "3e975d6c-1289-487f-8e78-6f4eda5243d2", - "prevId": "ca4ff2bd-aed3-474d-92a1-68e3a8349e01", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -244,15 +242,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -338,15 +336,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -411,28 +409,28 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarkLists_parentId_bookmarkLists_id_fk": { "name": "bookmarkLists_parentId_bookmarkLists_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "parentId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "set null", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "set null" } }, "compositePrimaryKeys": {}, @@ -498,15 +496,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -535,15 +533,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -646,15 +644,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -705,28 +703,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -770,15 +768,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -836,28 +834,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -979,8 +977,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "3e975d6c-1289-487f-8e78-6f4eda5243d2", + "prevId": "ca4ff2bd-aed3-474d-92a1-68e3a8349e01" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0020_snapshot.json b/packages/db/drizzle/meta/0020_snapshot.json index a64a7229..7374c8e2 100644 --- a/packages/db/drizzle/meta/0020_snapshot.json +++ b/packages/db/drizzle/meta/0020_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "cdb3562b-0d7a-4f1d-bbc9-71b1119d8d88", - "prevId": "3e975d6c-1289-487f-8e78-6f4eda5243d2", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -244,15 +242,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -352,15 +350,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -425,28 +423,28 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarkLists_parentId_bookmarkLists_id_fk": { "name": "bookmarkLists_parentId_bookmarkLists_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "parentId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "set null", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "set null" } }, "compositePrimaryKeys": {}, @@ -512,15 +510,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -549,15 +547,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -660,15 +658,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -719,28 +717,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -784,15 +782,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -850,28 +848,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -993,8 +991,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "cdb3562b-0d7a-4f1d-bbc9-71b1119d8d88", + "prevId": "3e975d6c-1289-487f-8e78-6f4eda5243d2" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0021_snapshot.json b/packages/db/drizzle/meta/0021_snapshot.json index f634f740..3317b423 100644 --- a/packages/db/drizzle/meta/0021_snapshot.json +++ b/packages/db/drizzle/meta/0021_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "35f45396-0455-4384-b42c-e9eb62cb3128", - "prevId": "cdb3562b-0d7a-4f1d-bbc9-71b1119d8d88", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -244,15 +242,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -360,15 +358,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -433,28 +431,28 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarkLists_parentId_bookmarkLists_id_fk": { "name": "bookmarkLists_parentId_bookmarkLists_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "parentId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "set null", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "set null" } }, "compositePrimaryKeys": {}, @@ -520,15 +518,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -557,15 +555,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -668,15 +666,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -727,28 +725,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -792,15 +790,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -858,28 +856,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -1001,8 +999,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "35f45396-0455-4384-b42c-e9eb62cb3128", + "prevId": "cdb3562b-0d7a-4f1d-bbc9-71b1119d8d88" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0022_snapshot.json b/packages/db/drizzle/meta/0022_snapshot.json index 3d8c7441..995c1b27 100644 --- a/packages/db/drizzle/meta/0022_snapshot.json +++ b/packages/db/drizzle/meta/0022_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "f2897961-faba-4fc4-9d82-85e7cf316218", - "prevId": "35f45396-0455-4384-b42c-e9eb62cb3128", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -244,15 +242,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -367,15 +365,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -440,28 +438,28 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarkLists_parentId_bookmarkLists_id_fk": { "name": "bookmarkLists_parentId_bookmarkLists_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "parentId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "set null", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "set null" } }, "compositePrimaryKeys": {}, @@ -527,15 +525,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -564,15 +562,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -675,15 +673,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -734,28 +732,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -799,15 +797,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -865,28 +863,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -1008,8 +1006,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "f2897961-faba-4fc4-9d82-85e7cf316218", + "prevId": "35f45396-0455-4384-b42c-e9eb62cb3128" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0023_snapshot.json b/packages/db/drizzle/meta/0023_snapshot.json index 8cb65488..503c83de 100644 --- a/packages/db/drizzle/meta/0023_snapshot.json +++ b/packages/db/drizzle/meta/0023_snapshot.json @@ -1,1022 +1,1021 @@ -{ - "version": "5", - "dialect": "sqlite", - "id": "d33de747-6acb-4160-a5ec-a4a7adee3023", - "prevId": "f2897961-faba-4fc4-9d82-85e7cf316218", - "tables": { - "account": { - "name": "account", - "columns": { - "userId": { - "name": "userId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "type": { - "name": "type", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "provider": { - "name": "provider", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "providerAccountId": { - "name": "providerAccountId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "refresh_token": { - "name": "refresh_token", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "access_token": { - "name": "access_token", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "expires_at": { - "name": "expires_at", - "type": "integer", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "token_type": { - "name": "token_type", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "scope": { - "name": "scope", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "id_token": { - "name": "id_token", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "session_state": { - "name": "session_state", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - } - }, - "indexes": {}, - "foreignKeys": { - "account_userId_user_id_fk": { - "name": "account_userId_user_id_fk", - "tableFrom": "account", - "tableTo": "user", - "columnsFrom": [ - "userId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": { - "account_provider_providerAccountId_pk": { - "columns": [ - "provider", - "providerAccountId" - ], - "name": "account_provider_providerAccountId_pk" - } - }, - "uniqueConstraints": {} - }, - "apiKey": { - "name": "apiKey", - "columns": { - "id": { - "name": "id", - "type": "text", - "primaryKey": true, - "notNull": true, - "autoincrement": false - }, - "name": { - "name": "name", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "createdAt": { - "name": "createdAt", - "type": "integer", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "keyId": { - "name": "keyId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "keyHash": { - "name": "keyHash", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "userId": { - "name": "userId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - } - }, - "indexes": { - "apiKey_keyId_unique": { - "name": "apiKey_keyId_unique", - "columns": [ - "keyId" - ], - "isUnique": true - }, - "apiKey_name_userId_unique": { - "name": "apiKey_name_userId_unique", - "columns": [ - "name", - "userId" - ], - "isUnique": true - } - }, - "foreignKeys": { - "apiKey_userId_user_id_fk": { - "name": "apiKey_userId_user_id_fk", - "tableFrom": "apiKey", - "tableTo": "user", - "columnsFrom": [ - "userId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": {}, - "uniqueConstraints": {} - }, - "bookmarkAssets": { - "name": "bookmarkAssets", - "columns": { - "id": { - "name": "id", - "type": "text", - "primaryKey": true, - "notNull": true, - "autoincrement": false - }, - "assetType": { - "name": "assetType", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "assetId": { - "name": "assetId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "content": { - "name": "content", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "metadata": { - "name": "metadata", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "fileName": { - "name": "fileName", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "sourceUrl": { - "name": "sourceUrl", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - } - }, - "indexes": {}, - "foreignKeys": { - "bookmarkAssets_id_bookmarks_id_fk": { - "name": "bookmarkAssets_id_bookmarks_id_fk", - "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", - "columnsFrom": [ - "id" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": {}, - "uniqueConstraints": {} - }, - "bookmarkLinks": { - "name": "bookmarkLinks", - "columns": { - "id": { - "name": "id", - "type": "text", - "primaryKey": true, - "notNull": true, - "autoincrement": false - }, - "url": { - "name": "url", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "title": { - "name": "title", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "description": { - "name": "description", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "imageUrl": { - "name": "imageUrl", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "favicon": { - "name": "favicon", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "content": { - "name": "content", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "htmlContent": { - "name": "htmlContent", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "screenshotAssetId": { - "name": "screenshotAssetId", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "fullPageArchiveAssetId": { - "name": "fullPageArchiveAssetId", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "imageAssetId": { - "name": "imageAssetId", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "crawledAt": { - "name": "crawledAt", - "type": "integer", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "crawlStatus": { - "name": "crawlStatus", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false, - "default": "'pending'" - } - }, - "indexes": { - "bookmarkLinks_url_idx": { - "name": "bookmarkLinks_url_idx", - "columns": [ - "url" - ], - "isUnique": false - } - }, - "foreignKeys": { - "bookmarkLinks_id_bookmarks_id_fk": { - "name": "bookmarkLinks_id_bookmarks_id_fk", - "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", - "columnsFrom": [ - "id" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": {}, - "uniqueConstraints": {} - }, - "bookmarkLists": { - "name": "bookmarkLists", - "columns": { - "id": { - "name": "id", - "type": "text", - "primaryKey": true, - "notNull": true, - "autoincrement": false - }, - "name": { - "name": "name", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "icon": { - "name": "icon", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "createdAt": { - "name": "createdAt", - "type": "integer", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "userId": { - "name": "userId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "parentId": { - "name": "parentId", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - } - }, - "indexes": { - "bookmarkLists_userId_idx": { - "name": "bookmarkLists_userId_idx", - "columns": [ - "userId" - ], - "isUnique": false - } - }, - "foreignKeys": { - "bookmarkLists_userId_user_id_fk": { - "name": "bookmarkLists_userId_user_id_fk", - "tableFrom": "bookmarkLists", - "tableTo": "user", - "columnsFrom": [ - "userId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - }, - "bookmarkLists_parentId_bookmarkLists_id_fk": { - "name": "bookmarkLists_parentId_bookmarkLists_id_fk", - "tableFrom": "bookmarkLists", - "tableTo": "bookmarkLists", - "columnsFrom": [ - "parentId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "set null", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": {}, - "uniqueConstraints": {} - }, - "bookmarkTags": { - "name": "bookmarkTags", - "columns": { - "id": { - "name": "id", - "type": "text", - "primaryKey": true, - "notNull": true, - "autoincrement": false - }, - "name": { - "name": "name", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "createdAt": { - "name": "createdAt", - "type": "integer", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "userId": { - "name": "userId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - } - }, - "indexes": { - "bookmarkTags_name_idx": { - "name": "bookmarkTags_name_idx", - "columns": [ - "name" - ], - "isUnique": false - }, - "bookmarkTags_userId_idx": { - "name": "bookmarkTags_userId_idx", - "columns": [ - "userId" - ], - "isUnique": false - }, - "bookmarkTags_userId_name_unique": { - "name": "bookmarkTags_userId_name_unique", - "columns": [ - "userId", - "name" - ], - "isUnique": true - } - }, - "foreignKeys": { - "bookmarkTags_userId_user_id_fk": { - "name": "bookmarkTags_userId_user_id_fk", - "tableFrom": "bookmarkTags", - "tableTo": "user", - "columnsFrom": [ - "userId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": {}, - "uniqueConstraints": {} - }, - "bookmarkTexts": { - "name": "bookmarkTexts", - "columns": { - "id": { - "name": "id", - "type": "text", - "primaryKey": true, - "notNull": true, - "autoincrement": false - }, - "text": { - "name": "text", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - } - }, - "indexes": {}, - "foreignKeys": { - "bookmarkTexts_id_bookmarks_id_fk": { - "name": "bookmarkTexts_id_bookmarks_id_fk", - "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", - "columnsFrom": [ - "id" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": {}, - "uniqueConstraints": {} - }, - "bookmarks": { - "name": "bookmarks", - "columns": { - "id": { - "name": "id", - "type": "text", - "primaryKey": true, - "notNull": true, - "autoincrement": false - }, - "createdAt": { - "name": "createdAt", - "type": "integer", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "title": { - "name": "title", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "archived": { - "name": "archived", - "type": "integer", - "primaryKey": false, - "notNull": true, - "autoincrement": false, - "default": false - }, - "favourited": { - "name": "favourited", - "type": "integer", - "primaryKey": false, - "notNull": true, - "autoincrement": false, - "default": false - }, - "userId": { - "name": "userId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "taggingStatus": { - "name": "taggingStatus", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false, - "default": "'pending'" - }, - "note": { - "name": "note", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - } - }, - "indexes": { - "bookmarks_userId_idx": { - "name": "bookmarks_userId_idx", - "columns": [ - "userId" - ], - "isUnique": false - }, - "bookmarks_archived_idx": { - "name": "bookmarks_archived_idx", - "columns": [ - "archived" - ], - "isUnique": false - }, - "bookmarks_favourited_idx": { - "name": "bookmarks_favourited_idx", - "columns": [ - "favourited" - ], - "isUnique": false - }, - "bookmarks_createdAt_idx": { - "name": "bookmarks_createdAt_idx", - "columns": [ - "createdAt" - ], - "isUnique": false - } - }, - "foreignKeys": { - "bookmarks_userId_user_id_fk": { - "name": "bookmarks_userId_user_id_fk", - "tableFrom": "bookmarks", - "tableTo": "user", - "columnsFrom": [ - "userId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": {}, - "uniqueConstraints": {} - }, - "bookmarksInLists": { - "name": "bookmarksInLists", - "columns": { - "bookmarkId": { - "name": "bookmarkId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "listId": { - "name": "listId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "addedAt": { - "name": "addedAt", - "type": "integer", - "primaryKey": false, - "notNull": false, - "autoincrement": false - } - }, - "indexes": { - "bookmarksInLists_bookmarkId_idx": { - "name": "bookmarksInLists_bookmarkId_idx", - "columns": [ - "bookmarkId" - ], - "isUnique": false - }, - "bookmarksInLists_listId_idx": { - "name": "bookmarksInLists_listId_idx", - "columns": [ - "listId" - ], - "isUnique": false - } - }, - "foreignKeys": { - "bookmarksInLists_bookmarkId_bookmarks_id_fk": { - "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", - "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", - "columnsFrom": [ - "bookmarkId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - }, - "bookmarksInLists_listId_bookmarkLists_id_fk": { - "name": "bookmarksInLists_listId_bookmarkLists_id_fk", - "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", - "columnsFrom": [ - "listId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": { - "bookmarksInLists_bookmarkId_listId_pk": { - "columns": [ - "bookmarkId", - "listId" - ], - "name": "bookmarksInLists_bookmarkId_listId_pk" - } - }, - "uniqueConstraints": {} - }, - "session": { - "name": "session", - "columns": { - "sessionToken": { - "name": "sessionToken", - "type": "text", - "primaryKey": true, - "notNull": true, - "autoincrement": false - }, - "userId": { - "name": "userId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "expires": { - "name": "expires", - "type": "integer", - "primaryKey": false, - "notNull": true, - "autoincrement": false - } - }, - "indexes": {}, - "foreignKeys": { - "session_userId_user_id_fk": { - "name": "session_userId_user_id_fk", - "tableFrom": "session", - "tableTo": "user", - "columnsFrom": [ - "userId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": {}, - "uniqueConstraints": {} - }, - "tagsOnBookmarks": { - "name": "tagsOnBookmarks", - "columns": { - "bookmarkId": { - "name": "bookmarkId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "tagId": { - "name": "tagId", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "attachedAt": { - "name": "attachedAt", - "type": "integer", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "attachedBy": { - "name": "attachedBy", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - } - }, - "indexes": { - "tagsOnBookmarks_tagId_idx": { - "name": "tagsOnBookmarks_tagId_idx", - "columns": [ - "bookmarkId" - ], - "isUnique": false - }, - "tagsOnBookmarks_bookmarkId_idx": { - "name": "tagsOnBookmarks_bookmarkId_idx", - "columns": [ - "bookmarkId" - ], - "isUnique": false - } - }, - "foreignKeys": { - "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { - "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", - "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", - "columnsFrom": [ - "bookmarkId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - }, - "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { - "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", - "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", - "columnsFrom": [ - "tagId" - ], - "columnsTo": [ - "id" - ], - "onDelete": "cascade", - "onUpdate": "no action" - } - }, - "compositePrimaryKeys": { - "tagsOnBookmarks_bookmarkId_tagId_pk": { - "columns": [ - "bookmarkId", - "tagId" - ], - "name": "tagsOnBookmarks_bookmarkId_tagId_pk" - } - }, - "uniqueConstraints": {} - }, - "user": { - "name": "user", - "columns": { - "id": { - "name": "id", - "type": "text", - "primaryKey": true, - "notNull": true, - "autoincrement": false - }, - "name": { - "name": "name", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "email": { - "name": "email", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "emailVerified": { - "name": "emailVerified", - "type": "integer", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "image": { - "name": "image", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "password": { - "name": "password", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false - }, - "role": { - "name": "role", - "type": "text", - "primaryKey": false, - "notNull": false, - "autoincrement": false, - "default": "'user'" - } - }, - "indexes": { - "user_email_unique": { - "name": "user_email_unique", - "columns": [ - "email" - ], - "isUnique": true - } - }, - "foreignKeys": {}, - "compositePrimaryKeys": {}, - "uniqueConstraints": {} - }, - "verificationToken": { - "name": "verificationToken", - "columns": { - "identifier": { - "name": "identifier", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "token": { - "name": "token", - "type": "text", - "primaryKey": false, - "notNull": true, - "autoincrement": false - }, - "expires": { - "name": "expires", - "type": "integer", - "primaryKey": false, - "notNull": true, - "autoincrement": false - } - }, - "indexes": {}, - "foreignKeys": {}, - "compositePrimaryKeys": { - "verificationToken_identifier_token_pk": { - "columns": [ - "identifier", - "token" - ], - "name": "verificationToken_identifier_token_pk" - } - }, - "uniqueConstraints": {} - } - }, - "enums": {}, - "_meta": { - "schemas": {}, - "tables": {}, - "columns": {} - } +{ + "version": "6", + "dialect": "sqlite", + "tables": { + "account": { + "name": "account", + "columns": { + "userId": { + "name": "userId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "type": { + "name": "type", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "provider": { + "name": "provider", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "providerAccountId": { + "name": "providerAccountId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "refresh_token": { + "name": "refresh_token", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "access_token": { + "name": "access_token", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "expires_at": { + "name": "expires_at", + "type": "integer", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "token_type": { + "name": "token_type", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "scope": { + "name": "scope", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "id_token": { + "name": "id_token", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "session_state": { + "name": "session_state", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + } + }, + "indexes": {}, + "foreignKeys": { + "account_userId_user_id_fk": { + "name": "account_userId_user_id_fk", + "tableFrom": "account", + "columnsFrom": [ + "userId" + ], + "tableTo": "user", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": { + "account_provider_providerAccountId_pk": { + "columns": [ + "provider", + "providerAccountId" + ], + "name": "account_provider_providerAccountId_pk" + } + }, + "uniqueConstraints": {} + }, + "apiKey": { + "name": "apiKey", + "columns": { + "id": { + "name": "id", + "type": "text", + "primaryKey": true, + "notNull": true, + "autoincrement": false + }, + "name": { + "name": "name", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "createdAt": { + "name": "createdAt", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "keyId": { + "name": "keyId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "keyHash": { + "name": "keyHash", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "userId": { + "name": "userId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + } + }, + "indexes": { + "apiKey_keyId_unique": { + "name": "apiKey_keyId_unique", + "columns": [ + "keyId" + ], + "isUnique": true + }, + "apiKey_name_userId_unique": { + "name": "apiKey_name_userId_unique", + "columns": [ + "name", + "userId" + ], + "isUnique": true + } + }, + "foreignKeys": { + "apiKey_userId_user_id_fk": { + "name": "apiKey_userId_user_id_fk", + "tableFrom": "apiKey", + "columnsFrom": [ + "userId" + ], + "tableTo": "user", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {} + }, + "bookmarkAssets": { + "name": "bookmarkAssets", + "columns": { + "id": { + "name": "id", + "type": "text", + "primaryKey": true, + "notNull": true, + "autoincrement": false + }, + "assetType": { + "name": "assetType", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "assetId": { + "name": "assetId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "content": { + "name": "content", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "metadata": { + "name": "metadata", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "fileName": { + "name": "fileName", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "sourceUrl": { + "name": "sourceUrl", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + } + }, + "indexes": {}, + "foreignKeys": { + "bookmarkAssets_id_bookmarks_id_fk": { + "name": "bookmarkAssets_id_bookmarks_id_fk", + "tableFrom": "bookmarkAssets", + "columnsFrom": [ + "id" + ], + "tableTo": "bookmarks", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {} + }, + "bookmarkLinks": { + "name": "bookmarkLinks", + "columns": { + "id": { + "name": "id", + "type": "text", + "primaryKey": true, + "notNull": true, + "autoincrement": false + }, + "url": { + "name": "url", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "title": { + "name": "title", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "description": { + "name": "description", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "imageUrl": { + "name": "imageUrl", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "favicon": { + "name": "favicon", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "content": { + "name": "content", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "htmlContent": { + "name": "htmlContent", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "screenshotAssetId": { + "name": "screenshotAssetId", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "fullPageArchiveAssetId": { + "name": "fullPageArchiveAssetId", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "imageAssetId": { + "name": "imageAssetId", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "crawledAt": { + "name": "crawledAt", + "type": "integer", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "crawlStatus": { + "name": "crawlStatus", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false, + "default": "'pending'" + } + }, + "indexes": { + "bookmarkLinks_url_idx": { + "name": "bookmarkLinks_url_idx", + "columns": [ + "url" + ], + "isUnique": false + } + }, + "foreignKeys": { + "bookmarkLinks_id_bookmarks_id_fk": { + "name": "bookmarkLinks_id_bookmarks_id_fk", + "tableFrom": "bookmarkLinks", + "columnsFrom": [ + "id" + ], + "tableTo": "bookmarks", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {} + }, + "bookmarkLists": { + "name": "bookmarkLists", + "columns": { + "id": { + "name": "id", + "type": "text", + "primaryKey": true, + "notNull": true, + "autoincrement": false + }, + "name": { + "name": "name", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "icon": { + "name": "icon", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "createdAt": { + "name": "createdAt", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "userId": { + "name": "userId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "parentId": { + "name": "parentId", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + } + }, + "indexes": { + "bookmarkLists_userId_idx": { + "name": "bookmarkLists_userId_idx", + "columns": [ + "userId" + ], + "isUnique": false + } + }, + "foreignKeys": { + "bookmarkLists_userId_user_id_fk": { + "name": "bookmarkLists_userId_user_id_fk", + "tableFrom": "bookmarkLists", + "columnsFrom": [ + "userId" + ], + "tableTo": "user", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + }, + "bookmarkLists_parentId_bookmarkLists_id_fk": { + "name": "bookmarkLists_parentId_bookmarkLists_id_fk", + "tableFrom": "bookmarkLists", + "columnsFrom": [ + "parentId" + ], + "tableTo": "bookmarkLists", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "set null" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {} + }, + "bookmarkTags": { + "name": "bookmarkTags", + "columns": { + "id": { + "name": "id", + "type": "text", + "primaryKey": true, + "notNull": true, + "autoincrement": false + }, + "name": { + "name": "name", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "createdAt": { + "name": "createdAt", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "userId": { + "name": "userId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + } + }, + "indexes": { + "bookmarkTags_name_idx": { + "name": "bookmarkTags_name_idx", + "columns": [ + "name" + ], + "isUnique": false + }, + "bookmarkTags_userId_idx": { + "name": "bookmarkTags_userId_idx", + "columns": [ + "userId" + ], + "isUnique": false + }, + "bookmarkTags_userId_name_unique": { + "name": "bookmarkTags_userId_name_unique", + "columns": [ + "userId", + "name" + ], + "isUnique": true + } + }, + "foreignKeys": { + "bookmarkTags_userId_user_id_fk": { + "name": "bookmarkTags_userId_user_id_fk", + "tableFrom": "bookmarkTags", + "columnsFrom": [ + "userId" + ], + "tableTo": "user", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {} + }, + "bookmarkTexts": { + "name": "bookmarkTexts", + "columns": { + "id": { + "name": "id", + "type": "text", + "primaryKey": true, + "notNull": true, + "autoincrement": false + }, + "text": { + "name": "text", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + } + }, + "indexes": {}, + "foreignKeys": { + "bookmarkTexts_id_bookmarks_id_fk": { + "name": "bookmarkTexts_id_bookmarks_id_fk", + "tableFrom": "bookmarkTexts", + "columnsFrom": [ + "id" + ], + "tableTo": "bookmarks", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {} + }, + "bookmarks": { + "name": "bookmarks", + "columns": { + "id": { + "name": "id", + "type": "text", + "primaryKey": true, + "notNull": true, + "autoincrement": false + }, + "createdAt": { + "name": "createdAt", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "title": { + "name": "title", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "archived": { + "name": "archived", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false, + "default": false + }, + "favourited": { + "name": "favourited", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false, + "default": false + }, + "userId": { + "name": "userId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "taggingStatus": { + "name": "taggingStatus", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false, + "default": "'pending'" + }, + "note": { + "name": "note", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + } + }, + "indexes": { + "bookmarks_userId_idx": { + "name": "bookmarks_userId_idx", + "columns": [ + "userId" + ], + "isUnique": false + }, + "bookmarks_archived_idx": { + "name": "bookmarks_archived_idx", + "columns": [ + "archived" + ], + "isUnique": false + }, + "bookmarks_favourited_idx": { + "name": "bookmarks_favourited_idx", + "columns": [ + "favourited" + ], + "isUnique": false + }, + "bookmarks_createdAt_idx": { + "name": "bookmarks_createdAt_idx", + "columns": [ + "createdAt" + ], + "isUnique": false + } + }, + "foreignKeys": { + "bookmarks_userId_user_id_fk": { + "name": "bookmarks_userId_user_id_fk", + "tableFrom": "bookmarks", + "columnsFrom": [ + "userId" + ], + "tableTo": "user", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {} + }, + "bookmarksInLists": { + "name": "bookmarksInLists", + "columns": { + "bookmarkId": { + "name": "bookmarkId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "listId": { + "name": "listId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "addedAt": { + "name": "addedAt", + "type": "integer", + "primaryKey": false, + "notNull": false, + "autoincrement": false + } + }, + "indexes": { + "bookmarksInLists_bookmarkId_idx": { + "name": "bookmarksInLists_bookmarkId_idx", + "columns": [ + "bookmarkId" + ], + "isUnique": false + }, + "bookmarksInLists_listId_idx": { + "name": "bookmarksInLists_listId_idx", + "columns": [ + "listId" + ], + "isUnique": false + } + }, + "foreignKeys": { + "bookmarksInLists_bookmarkId_bookmarks_id_fk": { + "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", + "tableFrom": "bookmarksInLists", + "columnsFrom": [ + "bookmarkId" + ], + "tableTo": "bookmarks", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + }, + "bookmarksInLists_listId_bookmarkLists_id_fk": { + "name": "bookmarksInLists_listId_bookmarkLists_id_fk", + "tableFrom": "bookmarksInLists", + "columnsFrom": [ + "listId" + ], + "tableTo": "bookmarkLists", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": { + "bookmarksInLists_bookmarkId_listId_pk": { + "columns": [ + "bookmarkId", + "listId" + ], + "name": "bookmarksInLists_bookmarkId_listId_pk" + } + }, + "uniqueConstraints": {} + }, + "session": { + "name": "session", + "columns": { + "sessionToken": { + "name": "sessionToken", + "type": "text", + "primaryKey": true, + "notNull": true, + "autoincrement": false + }, + "userId": { + "name": "userId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "expires": { + "name": "expires", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false + } + }, + "indexes": {}, + "foreignKeys": { + "session_userId_user_id_fk": { + "name": "session_userId_user_id_fk", + "tableFrom": "session", + "columnsFrom": [ + "userId" + ], + "tableTo": "user", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {} + }, + "tagsOnBookmarks": { + "name": "tagsOnBookmarks", + "columns": { + "bookmarkId": { + "name": "bookmarkId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "tagId": { + "name": "tagId", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "attachedAt": { + "name": "attachedAt", + "type": "integer", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "attachedBy": { + "name": "attachedBy", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + } + }, + "indexes": { + "tagsOnBookmarks_tagId_idx": { + "name": "tagsOnBookmarks_tagId_idx", + "columns": [ + "bookmarkId" + ], + "isUnique": false + }, + "tagsOnBookmarks_bookmarkId_idx": { + "name": "tagsOnBookmarks_bookmarkId_idx", + "columns": [ + "bookmarkId" + ], + "isUnique": false + } + }, + "foreignKeys": { + "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { + "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", + "tableFrom": "tagsOnBookmarks", + "columnsFrom": [ + "bookmarkId" + ], + "tableTo": "bookmarks", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + }, + "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { + "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", + "tableFrom": "tagsOnBookmarks", + "columnsFrom": [ + "tagId" + ], + "tableTo": "bookmarkTags", + "columnsTo": [ + "id" + ], + "onUpdate": "no action", + "onDelete": "cascade" + } + }, + "compositePrimaryKeys": { + "tagsOnBookmarks_bookmarkId_tagId_pk": { + "columns": [ + "bookmarkId", + "tagId" + ], + "name": "tagsOnBookmarks_bookmarkId_tagId_pk" + } + }, + "uniqueConstraints": {} + }, + "user": { + "name": "user", + "columns": { + "id": { + "name": "id", + "type": "text", + "primaryKey": true, + "notNull": true, + "autoincrement": false + }, + "name": { + "name": "name", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "email": { + "name": "email", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "emailVerified": { + "name": "emailVerified", + "type": "integer", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "image": { + "name": "image", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "password": { + "name": "password", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "role": { + "name": "role", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false, + "default": "'user'" + } + }, + "indexes": { + "user_email_unique": { + "name": "user_email_unique", + "columns": [ + "email" + ], + "isUnique": true + } + }, + "foreignKeys": {}, + "compositePrimaryKeys": {}, + "uniqueConstraints": {} + }, + "verificationToken": { + "name": "verificationToken", + "columns": { + "identifier": { + "name": "identifier", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "token": { + "name": "token", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "expires": { + "name": "expires", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false + } + }, + "indexes": {}, + "foreignKeys": {}, + "compositePrimaryKeys": { + "verificationToken_identifier_token_pk": { + "columns": [ + "identifier", + "token" + ], + "name": "verificationToken_identifier_token_pk" + } + }, + "uniqueConstraints": {} + } + }, + "enums": {}, + "_meta": { + "tables": {}, + "columns": {} + }, + "id": "d33de747-6acb-4160-a5ec-a4a7adee3023", + "prevId": "f2897961-faba-4fc4-9d82-85e7cf316218" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0024_snapshot.json b/packages/db/drizzle/meta/0024_snapshot.json index e72605ad..949ba3a8 100644 --- a/packages/db/drizzle/meta/0024_snapshot.json +++ b/packages/db/drizzle/meta/0024_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "8a080f45-d358-465e-80b7-ae0c557e3872", - "prevId": "d33de747-6acb-4160-a5ec-a4a7adee3023", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -238,15 +236,15 @@ "assets_bookmarkId_bookmarks_id_fk": { "name": "assets_bookmarkId_bookmarks_id_fk", "tableFrom": "assets", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -310,15 +308,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -412,15 +410,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -485,28 +483,28 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarkLists_parentId_bookmarkLists_id_fk": { "name": "bookmarkLists_parentId_bookmarkLists_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "parentId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "set null", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "set null" } }, "compositePrimaryKeys": {}, @@ -572,15 +570,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -609,15 +607,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -720,15 +718,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -779,28 +777,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -844,15 +842,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -910,28 +908,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -1053,8 +1051,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "8a080f45-d358-465e-80b7-ae0c557e3872", + "prevId": "d33de747-6acb-4160-a5ec-a4a7adee3023" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0025_snapshot.json b/packages/db/drizzle/meta/0025_snapshot.json index 2f496fd9..c6a674e9 100644 --- a/packages/db/drizzle/meta/0025_snapshot.json +++ b/packages/db/drizzle/meta/0025_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "e3541a64-2e1d-407a-a6b0-7384f402da4d", - "prevId": "8a080f45-d358-465e-80b7-ae0c557e3872", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -238,15 +236,15 @@ "assets_bookmarkId_bookmarks_id_fk": { "name": "assets_bookmarkId_bookmarks_id_fk", "tableFrom": "assets", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -310,15 +308,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -412,15 +410,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -485,28 +483,28 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarkLists_parentId_bookmarkLists_id_fk": { "name": "bookmarkLists_parentId_bookmarkLists_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "parentId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "set null", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "set null" } }, "compositePrimaryKeys": {}, @@ -572,15 +570,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -609,15 +607,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -727,15 +725,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -786,28 +784,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -851,15 +849,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -917,28 +915,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -1060,8 +1058,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "e3541a64-2e1d-407a-a6b0-7384f402da4d", + "prevId": "8a080f45-d358-465e-80b7-ae0c557e3872" } \ No newline at end of file diff --git a/packages/db/drizzle/meta/0026_snapshot.json b/packages/db/drizzle/meta/0026_snapshot.json index 91574303..72247be4 100644 --- a/packages/db/drizzle/meta/0026_snapshot.json +++ b/packages/db/drizzle/meta/0026_snapshot.json @@ -1,8 +1,6 @@ { - "version": "5", + "version": "6", "dialect": "sqlite", - "id": "472a0256-4c40-464f-a2ff-851cdebb63c9", - "prevId": "e3541a64-2e1d-407a-a6b0-7384f402da4d", "tables": { "account": { "name": "account", @@ -90,15 +88,15 @@ "account_userId_user_id_fk": { "name": "account_userId_user_id_fk", "tableFrom": "account", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -179,15 +177,15 @@ "apiKey_userId_user_id_fk": { "name": "apiKey_userId_user_id_fk", "tableFrom": "apiKey", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -238,15 +236,15 @@ "assets_bookmarkId_bookmarks_id_fk": { "name": "assets_bookmarkId_bookmarks_id_fk", "tableFrom": "assets", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -310,15 +308,15 @@ "bookmarkAssets_id_bookmarks_id_fk": { "name": "bookmarkAssets_id_bookmarks_id_fk", "tableFrom": "bookmarkAssets", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -412,15 +410,15 @@ "bookmarkLinks_id_bookmarks_id_fk": { "name": "bookmarkLinks_id_bookmarks_id_fk", "tableFrom": "bookmarkLinks", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -485,28 +483,28 @@ "bookmarkLists_userId_user_id_fk": { "name": "bookmarkLists_userId_user_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarkLists_parentId_bookmarkLists_id_fk": { "name": "bookmarkLists_parentId_bookmarkLists_id_fk", "tableFrom": "bookmarkLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "parentId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "set null", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "set null" } }, "compositePrimaryKeys": {}, @@ -572,15 +570,15 @@ "bookmarkTags_userId_user_id_fk": { "name": "bookmarkTags_userId_user_id_fk", "tableFrom": "bookmarkTags", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -609,15 +607,15 @@ "bookmarkTexts_id_bookmarks_id_fk": { "name": "bookmarkTexts_id_bookmarks_id_fk", "tableFrom": "bookmarkTexts", - "tableTo": "bookmarks", "columnsFrom": [ "id" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -727,15 +725,15 @@ "bookmarks_userId_user_id_fk": { "name": "bookmarks_userId_user_id_fk", "tableFrom": "bookmarks", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -786,28 +784,28 @@ "bookmarksInLists_bookmarkId_bookmarks_id_fk": { "name": "bookmarksInLists_bookmarkId_bookmarks_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "bookmarksInLists_listId_bookmarkLists_id_fk": { "name": "bookmarksInLists_listId_bookmarkLists_id_fk", "tableFrom": "bookmarksInLists", - "tableTo": "bookmarkLists", "columnsFrom": [ "listId" ], + "tableTo": "bookmarkLists", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -874,15 +872,15 @@ "session_userId_user_id_fk": { "name": "session_userId_user_id_fk", "tableFrom": "session", - "tableTo": "user", "columnsFrom": [ "userId" ], + "tableTo": "user", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": {}, @@ -940,28 +938,28 @@ "tagsOnBookmarks_bookmarkId_bookmarks_id_fk": { "name": "tagsOnBookmarks_bookmarkId_bookmarks_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarks", "columnsFrom": [ "bookmarkId" ], + "tableTo": "bookmarks", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" }, "tagsOnBookmarks_tagId_bookmarkTags_id_fk": { "name": "tagsOnBookmarks_tagId_bookmarkTags_id_fk", "tableFrom": "tagsOnBookmarks", - "tableTo": "bookmarkTags", "columnsFrom": [ "tagId" ], + "tableTo": "bookmarkTags", "columnsTo": [ "id" ], - "onDelete": "cascade", - "onUpdate": "no action" + "onUpdate": "no action", + "onDelete": "cascade" } }, "compositePrimaryKeys": { @@ -1083,8 +1081,9 @@ }, "enums": {}, "_meta": { - "schemas": {}, "tables": {}, "columns": {} - } + }, + "id": "472a0256-4c40-464f-a2ff-851cdebb63c9", + "prevId": "e3541a64-2e1d-407a-a6b0-7384f402da4d" } \ No newline at end of file diff --git a/packages/db/package.json b/packages/db/package.json index 2335d1f8..0387696f 100644 --- a/packages/db/package.json +++ b/packages/db/package.json @@ -24,7 +24,7 @@ "@hoarder/tsconfig": "workspace:^0.1.0", "@tsconfig/node21": "^21.0.1", "@types/better-sqlite3": "^7.6.9", - "drizzle-kit": "^0.20.14" + "drizzle-kit": "^0.24.02" }, "eslintConfig": { "root": true, -- cgit v1.3-1-g0d28