diff options
| author | Dhravya <[email protected]> | 2024-04-13 11:40:01 -0700 |
|---|---|---|
| committer | Dhravya <[email protected]> | 2024-04-13 11:40:01 -0700 |
| commit | 6f4792cab8643dacd651c3cb1b069ad7aedd33fb (patch) | |
| tree | 88f03e31212bbf8b3ebff55f0ca93d2dff4e190f /apps/web/src/server/db | |
| parent | added browser rendering for getting clean page content (diff) | |
| parent | fix notes (diff) | |
| download | supermemory-6f4792cab8643dacd651c3cb1b069ad7aedd33fb.tar.xz supermemory-6f4792cab8643dacd651c3cb1b069ad7aedd33fb.zip | |
resolved conflicts
Diffstat (limited to 'apps/web/src/server/db')
| -rw-r--r-- | apps/web/src/server/db/schema.ts | 16 |
1 files changed, 10 insertions, 6 deletions
diff --git a/apps/web/src/server/db/schema.ts b/apps/web/src/server/db/schema.ts index 4ca4332f..cd2756f1 100644 --- a/apps/web/src/server/db/schema.ts +++ b/apps/web/src/server/db/schema.ts @@ -34,7 +34,7 @@ export const accounts = createTable( id: integer("id").notNull().primaryKey({ autoIncrement: true }), userId: text("userId", { length: 255 }) .notNull() - .references(() => users.id), + .references(() => users.id, { onDelete: "cascade" }), type: text("type", { length: 255 }).notNull(), provider: text("provider", { length: 255 }).notNull(), providerAccountId: text("providerAccountId", { length: 255 }).notNull(), @@ -60,7 +60,7 @@ export const sessions = createTable( sessionToken: text("sessionToken", { length: 255 }).notNull(), userId: text("userId", { length: 255 }) .notNull() - .references(() => users.id), + .references(() => users.id, { onDelete: "cascade" }), expires: int("expires", { mode: "timestamp" }).notNull(), }, (session) => ({ @@ -94,7 +94,9 @@ export const storedContent = createTable( "page", ), image: text("image", { length: 255 }), - user: text("user", { length: 255 }).references(() => users.id), + user: text("user", { length: 255 }).references(() => users.id, { + onDelete: "cascade", + }), }, (sc) => ({ urlIdx: index("storedContent_url_idx").on(sc.url), @@ -109,10 +111,10 @@ export const contentToSpace = createTable( { contentId: integer("contentId") .notNull() - .references(() => storedContent.id), + .references(() => storedContent.id, { onDelete: "cascade" }), spaceId: integer("spaceId") .notNull() - .references(() => space.id), + .references(() => space.id, { onDelete: "cascade" }), }, (cts) => ({ compoundKey: primaryKey({ columns: [cts.contentId, cts.spaceId] }), @@ -124,7 +126,9 @@ export const space = createTable( { id: integer("id").notNull().primaryKey({ autoIncrement: true }), name: text("name").notNull().unique().default("none"), - user: text("user", { length: 255 }).references(() => users.id), + user: text("user", { length: 255 }).references(() => users.id, { + onDelete: "cascade", + }), }, (space) => ({ nameIdx: index("spaces_name_idx").on(space.name), |