generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "sqlite"
url = env("DATABASE_URL")
}
model roles {
id Int @id @default(autoincrement())
name String
icon String?
description String?
admin_access Boolean? @default(false)
app_access Boolean? @default(false)
users users[]
}
model sessions {
session_token String @unique
user_id String
created_at Int @default(dbgenerated("strftime('%s', 'now')"))
expires_at Int
users users @relation(fields: [user_id], references: [id])
@@id([user_id, session_token])
@@index([user_id], map: "idx_sessions_user_id")
@@index([session_token], map: "idx_sessions_token")
}
model users {
id String @id
first_name String?
last_name String?
display_name String
email String @unique(map: "sqlite_autoindex_users_2")
password_hash String
tfa_secret String?
location String?
title String?
description String?
avatar String?
language String? @default("en-US")
appearance String? @default("auto")
status String? @default("draft")
created_at String @default("datetime('now', 'localtime')")
created_by String
updated_at String?
updated_by String?
last_online String?
role_id Int?
sessions sessions[]
roles roles? @relation(fields: [role_id], references: [id], onDelete: NoAction, onUpdate: NoAction)
@@index([email], map: "idx_users_email")
}
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "sqlite"
url = env("DATABASE_URL")
}
model roles {
id Int @id @default(autoincrement())
name String
icon String?
description String?
admin_access Boolean? @default(false)
app_access Boolean? @default(false)
users users[]
}
model sessions {
session_token String @unique
user_id String
created_at Int @default(dbgenerated("strftime('%s', 'now')"))
expires_at Int
users users @relation(fields: [user_id], references: [id])
@@id([user_id, session_token])
@@index([user_id], map: "idx_sessions_user_id")
@@index([session_token], map: "idx_sessions_token")
}
model users {
id String @id
first_name String?
last_name String?
display_name String
email String @unique(map: "sqlite_autoindex_users_2")
password_hash String
tfa_secret String?
location String?
title String?
description String?
avatar String?
language String? @default("en-US")
appearance String? @default("auto")
status String? @default("draft")
created_at String @default("datetime('now', 'localtime')")
created_by String
updated_at String?
updated_by String?
last_online String?
role_id Int?
sessions sessions[]
roles roles? @relation(fields: [role_id], references: [id], onDelete: NoAction, onUpdate: NoAction)
@@index([email], map: "idx_users_email")
}