- Add PBKDF2 + AES-256-GCM encryption for credentials - Update Prisma schema to include MarketplaceCredential - Implement comprehensive SSRF utility with IP pinning - Harden /api/camera/proxy and stream proxy with safeFetch - Fix openid-client PKCE generator usage - Update workspace configurations and ADRs - Bump version to 2.10.0 (Minor)
105 lines
2.6 KiB
Plaintext
105 lines
2.6 KiB
Plaintext
generator client {
|
|
provider = "prisma-client-js"
|
|
output = "../src/generated/prisma"
|
|
}
|
|
|
|
datasource db {
|
|
provider = "postgresql"
|
|
}
|
|
|
|
model User {
|
|
id String @id @default(uuid())
|
|
tenantId String?
|
|
email String
|
|
name String
|
|
hashedPassword String
|
|
role String @default("user")
|
|
createdAt DateTime @default(now())
|
|
favorites Favorite[]
|
|
memberships WorkspaceMember[]
|
|
|
|
@@unique([tenantId, email])
|
|
@@map("users")
|
|
}
|
|
|
|
model Favorite {
|
|
id String @id @default(uuid())
|
|
tenantId String?
|
|
entityId String
|
|
pluginId String
|
|
label String
|
|
pluginName String
|
|
lastSeen DateTime @default(now())
|
|
userId String
|
|
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
|
|
|
|
@@unique([userId, entityId])
|
|
@@map("favorites")
|
|
}
|
|
|
|
model InstalledPlugin {
|
|
id String @id @default(uuid())
|
|
tenantId String?
|
|
pluginId String
|
|
version String
|
|
config String @default("{}")
|
|
enabled Boolean @default(true)
|
|
installedAt DateTime @default(now())
|
|
updatedAt DateTime @updatedAt
|
|
|
|
@@unique([tenantId, pluginId])
|
|
@@map("installed_plugins")
|
|
}
|
|
|
|
model Setting {
|
|
id String @id @default(uuid())
|
|
tenantId String?
|
|
key String
|
|
value String
|
|
|
|
@@unique([tenantId, key])
|
|
@@map("settings")
|
|
}
|
|
|
|
model Workspace {
|
|
id String @id @default(uuid())
|
|
name String
|
|
subdomain String @unique
|
|
status String @default("trialing")
|
|
plan String @default("basic")
|
|
stripeCustomerId String?
|
|
stripeSubscriptionId String?
|
|
createdAt DateTime @default(now())
|
|
updatedAt DateTime @updatedAt
|
|
members WorkspaceMember[]
|
|
|
|
@@map("workspaces")
|
|
}
|
|
|
|
model WorkspaceMember {
|
|
id String @id @default(uuid())
|
|
userId String
|
|
workspaceId String
|
|
role String @default("member")
|
|
joinedAt DateTime @default(now())
|
|
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
|
|
workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
|
|
|
|
@@unique([userId, workspaceId])
|
|
@@map("workspace_members")
|
|
}
|
|
|
|
model MarketplaceCredential {
|
|
id String @id @default(uuid())
|
|
tenantId String?
|
|
version String
|
|
salt String
|
|
nonce String
|
|
ciphertext String
|
|
createdAt DateTime @default(now())
|
|
updatedAt DateTime @updatedAt
|
|
|
|
@@unique([tenantId])
|
|
@@map("marketplace_credentials")
|
|
}
|