diff options
| author | yxshv <[email protected]> | 2024-04-13 23:14:06 +0530 |
|---|---|---|
| committer | yxshv <[email protected]> | 2024-04-13 23:14:06 +0530 |
| commit | a7d72c798d18ae55f9a5de13fa8a94346346779d (patch) | |
| tree | dd21d39bd0f95446c12d25edb7aaea61ac38f529 /apps/web/src/server/db | |
| parent | order by savedAt (diff) | |
| download | supermemory-a7d72c798d18ae55f9a5de13fa8a94346346779d.tar.xz supermemory-a7d72c798d18ae55f9a5de13fa8a94346346779d.zip | |
delete spaces and memories
Diffstat (limited to 'apps/web/src/server/db')
| -rw-r--r-- | apps/web/src/server/db/schema.ts | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/apps/web/src/server/db/schema.ts b/apps/web/src/server/db/schema.ts index f36e7740..f3eafb94 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,7 @@ 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 +109,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 +124,7 @@ 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), |