language-tools
language-tools copied to clipboard
Published
20 hours ago •
prisma
prisma
Syntax Highlighting fails after `@default("\"")`
This is the schema:
generator client {
provider = "prisma-client-js"
previewFeatures = ["extendedIndexes", "fullTextIndex"]
}
datasource db {
provider = "mysql"
url = "..."
}
model index_5e404df0a4aa1 {
id Int @id @default(autoincrement())
object_type String @db.VarChar(15)
object_id String @db.VarChar(235)
title String? @db.Text
creation_date DateTime? @db.DateTime(0)
modification_date DateTime? @db.DateTime(0)
date DateTime? @db.DateTime(0)
description String? @db.Text
language String? @db.Text
gallery_id String? @db.Text
view_permission String? @db.Text
attachments String? @db.Text
primary_image String? @db.Text
geo_located String? @db.Text
geo_location String? @db.Text
allowed_groups String? @db.Text
allowed_users String? @db.Text
relations String? @db.Text
relation_types String? @db.Text
relation_count String? @db.Text
title_initial String? @db.Text
title_firstword String? @db.Text
searchable String? @db.Text
url String? @db.Text
contents String? @db.MediumText
user_country String? @db.Text
user_gender String? @db.Text
user_homepage String? @db.Text
user_realName String? @db.Text
user_allowmsgs String? @db.Text
user_language String? @db.Text
user_style String? @db.Text
user_page String? @db.Text
groups String? @db.Text
addongroup String? @db.Text
addonleadergroup String? @db.Text
addonpendinggroup String? @db.Text
@@index([object_type, object_id(length: 160)], map: "object_type")
}
model messu_archive {
msgId Int @id @default(autoincrement())
user String @default("") @db.VarChar(40)
user_from String @default("") @db.VarChar(40)
user_to String? @db.Text
user_cc String? @db.Text
user_bcc String? @db.Text
subject String? @db.VarChar(255)
body String? @db.Text
hash String? @db.VarChar(32)
replyto_hash String? @db.VarChar(32)
date Int?
isRead String? @db.Char(1)
isReplied String? @db.Char(1)
isFlagged String? @db.Char(1)
priority Int?
}
model messu_messages {
msgId Int @id @default(autoincrement())
user String @default("") @db.VarChar(200)
user_from String @default("") @db.VarChar(200)
user_to String? @db.Text
user_cc String? @db.Text
user_bcc String? @db.Text
subject String? @db.VarChar(255)
body String? @db.Text
hash String? @db.VarChar(32)
replyto_hash String? @db.VarChar(32)
date Int?
isRead String? @db.Char(1)
isReplied String? @db.Char(1)
isFlagged String? @db.Char(1)
priority Int?
@@index([user(length: 190), isRead], map: "userIsRead")
}
model messu_sent {
msgId Int @id @default(autoincrement())
user String @default("") @db.VarChar(40)
user_from String @default("") @db.VarChar(40)
user_to String? @db.Text
user_cc String? @db.Text
user_bcc String? @db.Text
subject String? @db.VarChar(255)
body String? @db.Text
hash String? @db.VarChar(32)
replyto_hash String? @db.VarChar(32)
date Int?
isRead String? @db.Char(1)
isReplied String? @db.Char(1)
isFlagged String? @db.Char(1)
priority Int?
}
model sessions {
sesskey String @id @db.Char(32)
expiry Int @db.UnsignedInt
expireref String? @db.VarChar(64)
data String @db.Text
@@index([expiry], map: "expiry")
}
model tiki_acct_account {
accountBookId Int @db.UnsignedInt
accountId Int @default(0) @db.UnsignedInt
accountName String @db.VarChar(255)
accountNotes String @db.Text
accountBudget Float @default(0)
accountLocked Int @default(0)
accountTax Int @default(0)
accountUserId Int @default(0)
@@id([accountBookId, accountId])
@@index([accountTax], map: "accountTax")
}
model tiki_acct_bankaccount {
bankBookId Int @db.UnsignedInt
bankAccountId Int @db.UnsignedInt
externalNumber Int
bankCountry String @db.VarChar(2)
bankCode String @db.VarChar(11)
bankIBAN String @db.VarChar(63)
bankBIC String @db.VarChar(63)
bankDelimeter String @default(";") @db.VarChar(15)
bankDecPoint String @default(",") @db.VarChar(1)
bankThousand String @default(".") @db.VarChar(1)
bankHasHeader Boolean @default(true)
fieldNameAccount String @db.VarChar(63)
fieldNameBookingDate String @db.VarChar(63)
formatBookingDate String @db.VarChar(31)
fieldNameValueDate String @db.VarChar(63)
formatValueDate String @db.VarChar(31)
fieldNameBookingText String @db.VarChar(63)
fieldNameReason String @db.VarChar(63)
fieldNameCounterpartName String @db.VarChar(63)
fieldNameCounterpartAccount String @db.VarChar(63)
fieldNameCounterpartBankCode String @db.VarChar(63)
fieldNameAmount String @db.VarChar(63)
amountType Int @db.UnsignedInt
fieldNameAmountSign String @db.VarChar(63)
SignPositive String @db.VarChar(7)
SignNegative String @db.VarChar(7)
@@id([bankBookId, bankAccountId])
}
model tiki_acct_book {
bookId Int @id @default(autoincrement()) @db.UnsignedInt
bookName String @db.VarChar(255)
bookClosed tiki_acct_book_bookClosed @default(n)
bookStartDate DateTime? @db.Date
bookEndDate DateTime? @db.Date
bookCurrency String @default("EUR") @db.VarChar(3)
bookCurrencyPos Int
bookDecimals Int @default(2)
bookDecPoint String @default(",") @db.VarChar(1)
bookThousand String @default(".") @db.VarChar(1)
exportSeparator String @default(";") @db.VarChar(4)
exportEOL String @default("LF") @db.VarChar(4)
exportQuote String @default("\"") @db.VarChar(4)
bookAutoTax tiki_acct_book_bookAutoTax @default(y)
}
model tiki_acct_item {
itemId Int @id @default(autoincrement())
itemBookId Int @db.UnsignedInt
itemJournalId Int @default(0) @db.UnsignedInt
itemAccountId Int @default(0) @db.UnsignedInt
itemType Int @default(-1)
itemAmount Float @default(0)
itemText String @default("") @db.VarChar(255)
itemTs DateTime @default(now()) @db.Timestamp(0)
}
model tiki_acct_journal {
journalBookId Int @db.UnsignedInt
journalId Int @id @default(autoincrement()) @db.UnsignedInt
journalDate DateTime? @db.Date
journalDescription String @db.VarChar(255)
journalCancelled Int @default(0)
journalTs DateTime @default(now()) @db.Timestamp(0)
}
model tiki_acct_stack {
stackBookId Int @db.UnsignedInt
stackId Int @id @default(autoincrement()) @db.UnsignedInt
stackDate DateTime? @db.Date
stackDescription String @db.VarChar(255)
stackTs DateTime @default(now()) @db.Timestamp(0)
}
model tiki_acct_stackitem {
stackBookId Int @db.UnsignedInt
stackItemStackId Int @default(0) @db.UnsignedInt
stackItemAccountId Int @default(0) @db.UnsignedInt
stackItemType Int @default(-1)
stackItemAmount Float @default(0)
stackItemText String @default("") @db.VarChar(255)
@@id([stackBookId, stackItemStackId, stackItemAccountId, stackItemType])
}
model tiki_acct_statement {
statementBookId Int @db.UnsignedInt
statementAccountId Int @default(0) @db.UnsignedInt
statementId Int @id @default(autoincrement()) @db.UnsignedInt
statementBookingDate DateTime? @db.Date
statementValueDate DateTime? @db.Date
statementBookingText String @db.VarChar(255)
statementReason String @db.VarChar(255)
statementCounterpart String @db.VarChar(63)
statementCounterpartAccount String @db.VarChar(63)
statementCounterpartBankCode String @db.VarChar(63)
statementAmount Float
statementJournalId Int @default(0) @db.UnsignedInt
statementStackId Int
}
model tiki_acct_tax {
taxBookId Int @db.UnsignedInt
taxId Int @id @default(autoincrement()) @db.UnsignedInt
taxText String @db.VarChar(63)
taxAmount Float @default(0)
taxIsFix tiki_acct_tax_taxIsFix @default(n)
}
model tiki_actionlog {
actionId Int @id @default(autoincrement())
action String @default("") @db.VarChar(255)
lastModif Int?
object String? @db.VarChar(255)
objectType String @default("") @db.VarChar(32)
user String? @default("") @db.VarChar(200)
ip String? @db.VarChar(39)
comment String? @db.Text
categId Int @default(0)
client String? @db.VarChar(200)
log String? @db.LongText
@@index([lastModif], map: "lastModif")
@@index([object(length: 100), objectType, action(length: 100)], map: "object")
}
model tiki_actionlog_conf {
id Int @default(autoincrement())
action String @default("") @db.VarChar(32)
objectType String @default("") @db.VarChar(32)
status String? @default("") @db.Char(1)
@@id([action, objectType])
@@index([id], map: "id")
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_actionlog_params {
actionId Int
name String @db.VarChar(40)
value String? @db.Text
@@index([actionId], map: "actionId")
@@index([name, value(length: 151)], map: "nameValue")
@@ignore
}
model tiki_activity_stream {
activityId Int @id @default(autoincrement())
eventType String @db.VarChar(100)
eventDate Int
arguments Bytes? @db.Blob
}
model tiki_activity_stream_mapping {
field_name String @id @db.VarChar(50)
field_type String @db.VarChar(15)
}
model tiki_activity_stream_rules {
ruleId Int @id @default(autoincrement())
eventType String @db.VarChar(100)
ruleType String @db.VarChar(20)
rule String? @db.Text
notes String? @db.Text
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_areas {
categId Int
perspectives String? @db.Text
exclusive String @default("n") @db.Char(1)
share_common String @default("y") @db.Char(1)
enabled String @default("y") @db.Char(1)
@@index([categId], map: "categId")
@@ignore
}
model tiki_article_types {
type String @id @db.VarChar(50)
use_ratings String? @db.VarChar(1)
show_pre_publ String? @db.VarChar(1)
show_post_expire String? @default("y") @db.VarChar(1)
heading_only String? @db.VarChar(1)
allow_comments String? @default("y") @db.VarChar(1)
show_image String? @default("y") @db.VarChar(1)
show_avatar String? @db.VarChar(1)
show_author String? @default("y") @db.VarChar(1)
show_pubdate String? @default("y") @db.VarChar(1)
show_expdate String? @db.VarChar(1)
show_reads String? @default("y") @db.VarChar(1)
show_size String? @default("n") @db.VarChar(1)
show_topline String? @default("n") @db.VarChar(1)
show_subtitle String? @default("n") @db.VarChar(1)
show_linkto String? @default("n") @db.VarChar(1)
show_image_caption String? @default("n") @db.VarChar(1)
creator_edit String? @db.VarChar(1)
comment_can_rate_article String? @db.Char(1)
@@index([show_post_expire], map: "show_post_expire")
@@index([show_pre_publ], map: "show_pre_publ")
}
model tiki_articles {
articleId Int @id @default(autoincrement())
topline String? @db.VarChar(255)
title String? @db.VarChar(255)
subtitle String? @db.VarChar(255)
linkto String? @db.VarChar(255)
lang String? @db.VarChar(16)
state String? @default("s") @db.Char(1)
authorName String? @db.VarChar(60)
topicId Int?
topicName String? @db.VarChar(40)
size Int?
useImage String? @db.Char(1)
image_name String? @db.VarChar(80)
image_caption String? @db.Text
image_type String? @db.VarChar(80)
image_size Int?
image_x Int?
image_y Int?
list_image_x Int?
list_image_y Int?
image_data Bytes?
publishDate Int?
expireDate Int?
created Int?
heading String? @db.Text
body String? @db.Text
author String? @db.VarChar(200)
nbreads Int?
votes Int?
points Int?
type String? @db.VarChar(50)
rating Decimal? @db.Decimal(3, 2)
isfloat String? @db.Char(1)
ispublished String @default("y") @db.Char(1)
@@index([author(length: 32)], map: "author")
@@index([body(length: 191)], map: "body")
@@index([expireDate], map: "expireDate")
@@index([heading(length: 191)], map: "heading")
@@index([nbreads], map: "nbreads")
@@index([publishDate], map: "publishDate")
@@index([title(length: 191)], map: "title")
@@index([topicId], map: "topicId")
@@index([type], map: "type")
}
model tiki_auth_tokens {
tokenId Int @id @default(autoincrement())
creation DateTime @default(now()) @db.Timestamp(0)
timeout Int @default(0)
hits Int @default(1)
maxhits Int @default(1)
token String? @db.Char(32)
entry String? @db.VarChar(50)
email String @db.VarChar(255)
parameters String? @db.VarChar(255)
groups String? @db.Text
createUser String? @default("n") @db.Char(1)
userPrefix String? @default("_token") @db.VarChar(200)
@@index([token], map: "tiki_auth_tokens_token")
}
model tiki_banners {
bannerId Int @id @default(autoincrement())
client String @default("") @db.VarChar(200)
url String? @db.VarChar(255)
title String? @db.VarChar(255)
alt String? @db.VarChar(250)
which String? @db.VarChar(50)
imageData Bytes?
imageType String? @db.VarChar(200)
imageName String? @db.VarChar(100)
HTMLData String? @db.Text
fixedURLData String? @db.VarChar(255)
textData String? @db.Text
fromDate Int?
toDate Int?
useDates String? @db.Char(1)
mon String? @db.Char(1)
tue String? @db.Char(1)
wed String? @db.Char(1)
thu String? @db.Char(1)
fri String? @db.Char(1)
sat String? @db.Char(1)
sun String? @db.Char(1)
hourFrom String? @db.VarChar(4)
hourTo String? @db.VarChar(4)
created Int?
maxImpressions Int?
impressions Int?
maxUserImpressions Int? @default(-1)
maxClicks Int?
clicks Int?
zone String? @db.VarChar(40)
onlyInURIs String? @db.Text
exceptInURIs String? @db.Text
@@index([zone, useDates, impressions, maxImpressions, hourFrom, hourTo, fromDate, toDate, mon, tue, wed, thu, fri, sat, sun], map: "ban1")
}
model tiki_banning {
banId Int @id @default(autoincrement())
mode tiki_banning_mode?
title String? @db.VarChar(200)
ip1 String? @db.Char(3)
ip2 String? @db.Char(3)
ip3 String? @db.Char(3)
ip4 String? @db.Char(3)
user String? @default("") @db.VarChar(200)
date_from DateTime? @db.Timestamp(0)
date_to DateTime? @db.Timestamp(0)
use_dates String? @db.Char(1)
created Int?
message String? @db.Text
@@index([use_dates, date_from, date_to], map: "ban")
}
model tiki_banning_sections {
banId Int @default(0)
section String @default("") @db.VarChar(100)
@@id([banId, section])
}
model tiki_blog_activity {
blogId Int @default(0)
day Int @default(0)
posts Int?
@@id([blogId, day])
}
model tiki_blog_posts {
postId Int @id @default(autoincrement())
blogId Int @default(0)
data String? @db.Text
data_size Int @default(0) @db.UnsignedInt
excerpt String? @db.Text
created Int?
user String? @default("") @db.VarChar(200)
hits BigInt? @default(0)
trackbacks_to String? @db.Text
trackbacks_from String? @db.Text
title String? @db.VarChar(255)
priv String? @default("n") @db.VarChar(1)
wysiwyg String? @db.VarChar(1)
@@index([blogId], map: "blogId")
@@index([created], map: "created")
@@index([data(length: 191)], map: "data")
}
model tiki_blog_posts_images {
imgId Int @id @default(autoincrement())
postId Int @default(0)
filename String? @db.VarChar(80)
filetype String? @db.VarChar(80)
filesize Int?
data Bytes?
}
model tiki_blogs {
blogId Int @id @default(autoincrement())
created Int?
lastModif Int?
title String? @db.VarChar(200)
description String? @db.Text
user String? @default("") @db.VarChar(200)
public String? @db.Char(1)
posts Int?
maxPosts Int?
hits Int?
activity Decimal? @db.Decimal(4, 2)
heading String? @db.Text
post_heading String? @db.Text
use_find String? @db.Char(1)
use_title String? @default("y") @db.Char(1)
use_title_in_post String? @default("y") @db.Char(1)
use_description String? @default("y") @db.Char(1)
use_breadcrumbs String? @default("n") @db.Char(1)
use_author String? @db.Char(1)
use_excerpt String? @db.Char(1)
add_date String? @db.Char(1)
add_poster String? @db.Char(1)
allow_comments String? @db.Char(1)
show_avatar String? @db.Char(1)
always_owner String? @db.Char(1)
show_related String? @db.Char(1)
related_max Int? @default(5)
@@index([description(length: 191)], map: "description")
@@index([hits], map: "hits")
@@index([title(length: 191)], map: "title")
}
model tiki_calendar_categories {
calcatId Int @id @default(autoincrement())
calendarId Int @default(0)
name String @default("") @db.VarChar(255)
@@unique([calendarId, name(length: 16)], map: "catname")
}
model tiki_calendar_items {
calitemId Int @id @default(autoincrement())
calendarId Int @default(0)
start Int @default(0)
end Int @default(0)
locationId Int?
categoryId Int?
nlId Int @default(0)
priority tiki_calendar_items_priority? @default(dbgenerated("0"))
status tiki_calendar_items_status @default(dbgenerated("0"))
url String? @db.VarChar(255)
lang String @default("en") @db.Char(16)
name String @default("") @db.VarChar(255)
description String? @db.Text
recurrenceId Int?
changed Boolean? @default(false)
user String? @default("") @db.VarChar(200)
created Int @default(0)
lastmodif Int @default(0)
allday Boolean @default(false)
@@index([calendarId], map: "calendarId")
}
model tiki_calendar_locations {
callocId Int @id @default(autoincrement())
calendarId Int @default(0)
name String @default("") @db.VarChar(255)
description Bytes? @db.Blob
@@unique([calendarId, name(length: 16)], map: "locname")
}
model tiki_calendar_options {
calendarId Int @default(0)
optionName String @default("") @db.VarChar(120)
value String? @db.VarChar(255)
@@id([calendarId, optionName])
}
model tiki_calendar_recurrence {
recurrenceId Int @id @default(autoincrement())
calendarId Int @default(0)
start Int @default(0)
end Int @default(2359)
allday Boolean @default(false)
locationId Int?
categoryId Int?
nlId Int @default(0)
priority tiki_calendar_recurrence_priority @default(dbgenerated("1"))
status tiki_calendar_recurrence_status @default(dbgenerated("0"))
url String? @db.VarChar(255)
lang String @default("en") @db.Char(16)
name String @default("") @db.VarChar(255)
description Bytes? @db.Blob
weekly Boolean? @default(false)
weekday Boolean?
monthly Boolean? @default(false)
dayOfMonth Int?
yearly Boolean? @default(false)
dateOfYear Int?
nbRecurrences Int?
startPeriod Int?
endPeriod Int?
user String? @default("") @db.VarChar(200)
created Int @default(0)
lastmodif Int @default(0)
@@index([calendarId], map: "calendarId")
}
model tiki_calendar_roles {
calitemId Int @default(0)
username String @default("") @db.VarChar(200)
role tiki_calendar_roles_role @default(dbgenerated("0"))
@@id([calitemId, username(length: 16), role])
}
model tiki_calendars {
calendarId Int @id @default(autoincrement())
name String @default("") @db.VarChar(80)
description String? @db.VarChar(255)
user String @default("") @db.VarChar(200)
customlocations tiki_calendars_customlocations @default(n)
customcategories tiki_calendars_customcategories @default(n)
customlanguages tiki_calendars_customlanguages @default(n)
custompriorities tiki_calendars_custompriorities @default(n)
customparticipants tiki_calendars_customparticipants @default(n)
customsubscription tiki_calendars_customsubscription @default(n)
customstatus tiki_calendars_customstatus @default(y)
created Int @default(0)
lastmodif Int @default(0)
personal tiki_calendars_personal @default(n)
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_cart_inventory_hold {
productId Int
quantity Int
timeHeld Int
hash String @db.Char(32)
@@ignore
}
model tiki_categories {
categId Int @id @default(autoincrement())
name String? @db.VarChar(200)
description String? @db.VarChar(500)
parentId Int?
rootId Int @default(0)
hits Int?
}
model tiki_categorized_objects {
catObjectId Int @id @default(0)
}
model tiki_category_objects {
catObjectId Int @default(0)
categId Int @default(0)
@@id([catObjectId, categId])
}
model tiki_category_sites {
categId Int @default(0)
siteId Int @default(0)
@@id([categId, siteId])
}
model tiki_chat_channels {
channelId Int @id @default(autoincrement())
name String? @db.VarChar(30)
description String? @db.VarChar(250)
max_users Int?
mode String? @db.Char(1)
moderator String? @db.VarChar(200)
active String? @db.Char(1)
refresh Int?
}
model tiki_chat_messages {
messageId Int @id @default(autoincrement())
channelId Int @default(0)
data String? @db.VarChar(255)
poster String @default("anonymous") @db.VarChar(200)
timestamp Int?
}
model tiki_chat_users {
nickname String @default("") @db.VarChar(200)
channelId Int @default(0)
timestamp Int?
@@id([nickname(length: 183), channelId])
}
model tiki_comments {
threadId Int @id @default(autoincrement())
object String @default("") @db.VarChar(255)
objectType String @default("") @db.VarChar(32)
parentId Int?
userName String? @default("") @db.VarChar(200)
commentDate Int?
hits Int?
type String? @db.Char(1)
points Decimal? @db.Decimal(8, 2)
votes Int?
average Decimal? @db.Decimal(8, 4)
title String? @db.VarChar(255)
data String? @db.Text
hash String? @db.VarChar(32)
email String? @db.VarChar(200)
website String? @db.VarChar(200)
user_ip String? @db.VarChar(39)
summary String? @db.VarChar(240)
smiley String? @db.VarChar(80)
message_id String? @db.VarChar(128)
in_reply_to String? @db.VarChar(128)
comment_rating Int? @db.TinyInt
archived String? @db.Char(1)
approved String @default("y") @db.Char(1)
locked String @default("n") @db.Char(1)
@@unique([parentId, userName(length: 40), title(length: 43), commentDate, message_id(length: 40), in_reply_to(length: 40)], map: "no_repeats")
@@index([commentDate], map: "commentDate")
@@index([data(length: 191)], map: "data")
@@index([hits], map: "hits")
@@index([object(length: 160), objectType], map: "objectType")
@@index([parentId], map: "tc_pi")
@@index([message_id(length: 89), in_reply_to(length: 88), parentId], map: "threaded")
@@index([title(length: 191)], map: "title")
}
model tiki_connect {
id Int @id @default(autoincrement()) @db.UnsignedInt
created DateTime @default(now()) @db.Timestamp(0)
type String @default("") @db.VarChar(64)
data String? @db.Text
guid String? @db.VarChar(64)
server Boolean @default(false)
@@index([server], map: "server")
}
model tiki_content {
contentId Int @id @default(autoincrement())
description String? @db.Text
contentLabel String @default("") @db.VarChar(255)
}
model tiki_content_templates {
templateId Int @id @default(autoincrement())
template_type String @default("static") @db.VarChar(20)
content Bytes?
name String? @db.VarChar(200)
created Int?
}
model tiki_content_templates_sections {
templateId Int @default(0)
section String @default("") @db.VarChar(250)
@@id([templateId, section(length: 181)])
}
model tiki_contributions {
contributionId Int @id @default(autoincrement())
name String? @db.VarChar(100)
description String? @db.VarChar(250)
}
model tiki_contributions_assigned {
contributionId Int
objectId Int
@@id([objectId, contributionId])
}
model tiki_cookies {
cookieId Int @id @default(autoincrement())
cookie String? @db.Text
}
model tiki_copyrights {
copyrightId Int @id @default(autoincrement())
page String? @db.VarChar(200)
title String? @db.VarChar(200)
year Int?
authors String? @db.VarChar(200)
holder String? @db.VarChar(200)
copyright_order Int?
userName String? @default("") @db.VarChar(200)
}
model tiki_credits {
creditId Int @id @default(autoincrement()) @db.UnsignedInt
userId Int
credit_type String @db.VarChar(25)
creation_date DateTime @default(now()) @db.Timestamp(0)
expiration_date DateTime? @db.Timestamp(0)
total_amount Float @default(0) @db.Float
used_amount Float @default(0) @db.Float
product_id Int?
@@index([userId, credit_type], map: "userId")
}
model tiki_credits_types {
credit_type String @id @db.VarChar(25)
display_text String? @db.VarChar(50)
unit_text String? @db.VarChar(25)
is_static_level String? @default("n") @db.Char(1)
scaling_divisor Float @default(1) @db.Float
}
model tiki_credits_usage {
usageId Int @id @default(autoincrement())
userId Int
usage_date DateTime @default(now()) @db.Timestamp(0)
credit_type String @db.VarChar(25)
used_amount Float @default(0) @db.Float
product_id Int?
}
model tiki_custom_route {
id Int @id @default(autoincrement())
description String? @db.VarChar(255)
type String @db.VarChar(255)
from String @db.VarChar(255)
redirect String @db.Text
active Boolean @default(true)
short_url Boolean? @default(false)
}
model tiki_db_status {
id Int @id @default(autoincrement())
objectId String @db.VarChar(100)
tableName String @db.VarChar(100)
status String @db.VarChar(100)
other String? @db.VarChar(100)
}
model tiki_directory_categories {
categId Int @id @default(autoincrement())
parent Int?
name String? @db.VarChar(240)
description String? @db.Text
childrenType String? @db.Char(1)
sites Int?
viewableChildren Int?
allowSites String? @db.Char(1)
showCount String? @db.Char(1)
editorGroup String? @db.VarChar(200)
hits Int?
}
model tiki_directory_search {
term String @id(length: 191) @default("") @db.VarChar(250)
hits Int?
}
model tiki_directory_sites {
siteId Int @id @default(autoincrement())
name String? @db.VarChar(240)
description String? @db.Text
url String? @db.VarChar(255)
country String? @db.VarChar(255)
hits Int?
isValid String? @db.Char(1)
created Int?
lastModif Int?
cache Bytes?
cache_timestamp Int?
@@index([isValid], map: "isValid")
@@index([url(length: 191)], map: "url")
}
model tiki_discount {
id Int @id @default(autoincrement())
code String? @db.VarChar(255)
value String? @db.VarChar(255)
max Int?
comment String? @db.Text
@@index([code(length: 191)], map: "code")
}
model tiki_download {
id Int @id @default(autoincrement())
object String @default("") @db.VarChar(255)
userId Int @default(0)
type String @default("") @db.VarChar(20)
date Int @default(0)
IP String @default("") @db.VarChar(50)
@@index([date], map: "date")
@@index([object(length: 163), userId, type], map: "object")
@@index([type], map: "type")
@@index([userId], map: "userId")
}
model tiki_dsn {
dsnId Int @id @default(autoincrement())
name String @default("") @db.VarChar(200)
dsn String? @db.VarChar(255)
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_dynamic_variables {
name String @db.VarChar(40)
data String? @db.Text
lang String? @db.VarChar(16)
@@ignore
}
model tiki_extwiki {
extwikiId Int @id @default(autoincrement())
name String @default("") @db.VarChar(200)
extwiki String? @db.VarChar(255)
indexname String? @db.VarChar(255)
groups String? @db.VarChar(1024)
}
model tiki_faq_questions {
questionId Int @id @default(autoincrement())
faqId Int?
position Int?
question String? @db.Text
answer String? @db.Text
created Int?
@@index([answer(length: 191)], map: "answer")
@@index([created], map: "created")
@@index([faqId], map: "faqId")
@@index([question(length: 191)], map: "question")
}
model tiki_faqs {
faqId Int @id @default(autoincrement())
title String? @db.VarChar(200)
description String? @db.Text
created Int?
questions Int?
hits Int?
canSuggest String? @db.Char(1)
@@index([description(length: 191)], map: "description")
@@index([hits], map: "hits")
@@index([title(length: 191)], map: "title")
}
model tiki_feature {
feature_id Int @id @default(autoincrement()) @db.MediumInt
feature_name String @db.VarChar(150)
parent_id Int @db.MediumInt
status String @default("active") @db.VarChar(12)
setting_name String? @db.VarChar(50)
feature_type String @default("feature") @db.VarChar(30)
template String? @db.VarChar(50)
permission String? @db.VarChar(50)
ordinal Int @default(1) @db.MediumInt
depends_on Int? @db.MediumInt
keyword String? @db.VarChar(30)
tip String? @db.Text
feature_count Int @default(0) @db.MediumInt
feature_path String @default("0") @db.VarChar(20)
}
model tiki_featured_links {
url String @id(length: 191) @default("") @db.VarChar(200)
title String? @db.VarChar(200)
description String? @db.Text
hits Int?
position Int?
type String? @db.Char(1)
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_file_backlinks {
fileId Int
objectId Int
@@index([fileId], map: "fileId")
@@index([objectId], map: "objectId")
@@ignore
}
model tiki_file_drafts {
fileId Int
filename String? @db.VarChar(80)
filesize Int?
filetype String? @db.VarChar(250)
data Bytes?
user String @default("") @db.VarChar(200)
path String? @db.VarChar(255)
hash String? @db.VarChar(32)
metadata String? @db.LongText
lastModif Int?
lockedby String? @default("") @db.VarChar(200)
@@id([fileId, user(length: 177)])
}
model tiki_file_galleries {
galleryId Int @id @default(autoincrement())
name String @default("") @db.VarChar(80)
type String @default("default") @db.VarChar(20)
template Int?
description String? @db.Text
created Int?
visible String? @db.Char(1)
lastModif Int?
user String? @default("") @db.VarChar(200)
hits Int?
votes Int?
points Decimal? @db.Decimal(8, 2)
maxRows Int?
public String? @db.Char(1)
show_id String? @db.Char(1)
show_icon String? @db.Char(1)
show_name String? @db.Char(1)
show_size String? @db.Char(1)
show_description String? @db.Char(1)
max_desc Int?
show_created String? @db.Char(1)
show_hits String? @db.Char(1)
show_lastDownload String? @db.Char(1)
parentId Int @default(-1)
lockable String? @default("n") @db.Char(1)
show_lockedby String? @db.Char(1)
archives Int? @default(0)
sort_mode String? @db.Char(20)
show_modified String? @db.Char(1)
show_author String? @db.Char(1)
show_creator String? @db.Char(1)
subgal_conf String? @db.VarChar(200)
show_last_user String? @db.Char(1)
show_comment String? @db.Char(1)
show_files String? @db.Char(1)
show_explorer String? @db.Char(1)
show_path String? @db.Char(1)
show_slideshow String? @db.Char(1)
default_view String? @db.VarChar(20)
quota Int? @default(0)
size Int?
wiki_syntax String? @db.VarChar(200)
backlinkPerms String? @default("n") @db.Char(1)
show_backlinks String? @db.Char(1)
show_deleteAfter String? @db.Char(1)
show_checked String? @db.Char(1)
show_share String? @db.Char(1)
image_max_size_x Int @default(0)
image_max_size_y Int @default(0)
show_source String @default("o") @db.Char(1)
icon_fileId Int? @db.UnsignedInt
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_file_handlers {
mime_type String? @db.VarChar(128)
cmd String? @db.VarChar(238)
@@ignore
}
model tiki_files {
fileId Int @id @default(autoincrement())
galleryId Int @default(0)
name String @default("") @db.VarChar(200)
description String? @db.Text
created Int?
filename String? @db.VarChar(80)
filesize Int?
filetype String? @db.VarChar(250)
data Bytes?
user String? @default("") @db.VarChar(200)
author String? @db.VarChar(40)
hits Int?
maxhits Int?
lastDownload Int?
votes Int?
points Decimal? @db.Decimal(8, 2)
path String? @db.VarChar(255)
reference_url String? @db.VarChar(250)
is_reference String? @db.Char(1)
hash String? @db.VarChar(32)
search_data String? @db.LongText
metadata String? @db.LongText
lastModif Int?
lastModifUser String? @db.VarChar(200)
lockedby String? @default("") @db.VarChar(200)
comment String? @db.VarChar(200)
archiveId Int? @default(0)
deleteAfter Int?
ocr_state Boolean?
ocr_lang String? @db.VarChar(11)
ocr_data String? @db.MediumText
@@index([archiveId], map: "archiveId")
@@index([created], map: "created")
@@index([description(length: 191)], map: "description")
@@index([galleryId], map: "galleryId")
@@index([hits], map: "hits")
@@index([name(length: 191)], map: "name")
}
model tiki_forum_attachments {
attId Int @id @default(autoincrement())
threadId Int @default(0)
qId Int @default(0)
forumId Int?
filename String? @db.VarChar(250)
filetype String? @db.VarChar(250)
filesize Int?
data Bytes?
dir String? @db.VarChar(200)
created Int?
path String? @db.VarChar(250)
@@index([threadId], map: "threadId")
}
model tiki_forum_reads {
user String @default("") @db.VarChar(200)
threadId Int @default(0)
forumId Int?
timestamp Int?
@@id([user(length: 177), threadId])
}
model tiki_forums {
forumId Int @id @default(autoincrement())
name String? @db.VarChar(255)
description String? @db.Text
created Int?
lastPost Int?
threads Int?
comments Int?
controlFlood String? @db.Char(1)
floodInterval Int?
moderator String? @db.VarChar(200)
hits Int?
mail String? @db.VarChar(200)
useMail String? @db.Char(1)
section String? @db.VarChar(200)
usePruneUnreplied String? @db.Char(1)
pruneUnrepliedAge Int?
usePruneOld String? @db.Char(1)
pruneMaxAge Int?
topicsPerPage Int?
topicOrdering String? @db.VarChar(100)
threadOrdering String? @db.VarChar(100)
att String? @db.VarChar(80)
att_store String? @db.VarChar(4)
att_store_dir String? @db.VarChar(250)
att_max_size Int?
att_list_nb String? @db.Char(1)
ui_level String? @db.Char(1)
forum_password String? @db.VarChar(32)
forum_use_password String? @db.Char(1)
moderator_group String? @db.VarChar(200)
approval_type String? @db.VarChar(20)
outbound_address String? @db.VarChar(250)
outbound_mails_for_inbound_mails String? @db.Char(1)
outbound_mails_reply_link String? @db.Char(1)
outbound_from String? @db.VarChar(250)
inbound_pop_server String? @db.VarChar(250)
inbound_pop_port Int?
inbound_pop_user String? @db.VarChar(200)
inbound_pop_password String? @db.VarChar(80)
topic_smileys String? @db.Char(1)
ui_avatar String? @db.Char(1)
ui_rating_choice_topic String? @db.Char(1)
ui_flag String? @db.Char(1)
ui_posts String? @db.Char(1)
ui_email String? @db.Char(1)
ui_online String? @db.Char(1)
topic_summary String? @db.Char(1)
show_description String? @db.Char(1)
topics_list_replies String? @db.Char(1)
topics_list_reads String? @db.Char(1)
topics_list_pts String? @db.Char(1)
topics_list_lastpost String? @db.Char(1)
topics_list_lastpost_title String? @db.Char(1)
topics_list_lastpost_avatar String? @db.Char(1)
topics_list_author String? @db.Char(1)
topics_list_author_avatar String? @db.Char(1)
vote_threads String? @db.Char(1)
forum_last_n Int? @default(0)
threadStyle String? @db.VarChar(100)
commentsPerPage String? @db.VarChar(100)
is_flat String? @db.Char(1)
mandatory_contribution String? @db.Char(1)
forumLanguage String? @db.VarChar(255)
}
model tiki_forums_queue {
qId Int @id @default(autoincrement())
object String? @db.VarChar(32)
parentId Int?
forumId Int?
timestamp Int?
user String? @default("") @db.VarChar(200)
title String? @db.VarChar(240)
data String? @db.Text
type String? @db.VarChar(60)
hash String? @db.VarChar(32)
topic_smiley String? @db.VarChar(80)
topic_title String? @db.VarChar(240)
summary String? @db.VarChar(240)
in_reply_to String? @db.VarChar(128)
tags String? @db.VarChar(255)
email String? @db.VarChar(255)
}
model tiki_forums_reported {
threadId Int @default(0)
forumId Int @default(0)
parentId Int @default(0)
user String @default("") @db.VarChar(200)
timestamp Int?
reason String? @db.VarChar(250)
@@id([threadId, forumId, parentId, user(length: 182)])
}
model tiki_freetagged_objects {
tagId Int @default(autoincrement())
objectId Int @default(0)
user String @default("") @db.VarChar(200)
created Int @default(0)
@@id([tagId, user(length: 168), objectId])
@@index([objectId], map: "objectId")
@@index([tagId], map: "tagId")
@@index([user(length: 191)], map: "user")
}
model tiki_freetags {
tagId Int @id @default(autoincrement()) @db.UnsignedInt
tag String @default("") @db.VarChar(128)
raw_tag String @default("") @db.VarChar(150)
lang String? @db.VarChar(16)
}
model tiki_galleries {
galleryId Int @id @default(autoincrement())
name String @default("") @db.VarChar(80)
description String? @db.Text
created Int?
lastModif Int?
visible String? @db.Char(1)
geographic String? @db.Char(1)
theme String? @db.VarChar(60)
user String? @default("") @db.VarChar(200)
hits Int?
maxRows Int?
rowImages Int?
thumbSizeX Int?
thumbSizeY Int?
public String? @db.Char(1)
sortorder String @default("created") @db.VarChar(20)
sortdirection String @default("desc") @db.VarChar(4)
galleryimage String @default("first") @db.VarChar(20)
parentgallery Int @default(-1)
showname String @default("y") @db.Char(1)
showimageid String @default("n") @db.Char(1)
showdescription String @default("n") @db.Char(1)
showcreated String @default("n") @db.Char(1)
showuser String @default("n") @db.Char(1)
showhits String @default("y") @db.Char(1)
showxysize String @default("y") @db.Char(1)
showfilesize String @default("n") @db.Char(1)
showfilename String @default("n") @db.Char(1)
defaultscale String @default("o") @db.VarChar(10)
showcategories String @default("n") @db.Char(1)
@@index([description(length: 191)], map: "description")
@@index([hits], map: "hits")
@@index([name], map: "name")
@@index([parentgallery], map: "parentgallery")
@@index([visible, user(length: 190)], map: "visibleUser")
}
model tiki_galleries_scales {
galleryId Int @default(0)
scale Int @default(0)
@@id([galleryId, scale])
}
model tiki_goal_events {
eventId Int @id @default(autoincrement())
eventDate Int
eventType String @db.VarChar(50)
targetType String? @db.VarChar(50)
targetObject String? @db.VarChar(255)
user String @db.VarChar(200)
groups Bytes @db.Blob
}
model tiki_goals {
goalId Int @id @default(autoincrement())
name String @db.VarChar(50)
type String @default("user") @db.VarChar(10)
description String? @db.Text
enabled Int @default(0)
daySpan Int @default(14)
from DateTime? @db.DateTime(0)
to DateTime? @db.DateTime(0)
eligible Bytes? @db.Blob
conditions Bytes? @db.Blob
rewards Bytes? @db.Blob
}
model tiki_group_inclusion {
groupName String @default("") @db.VarChar(255)
includeGroup String @default("") @db.VarChar(255)
@@id([groupName(length: 120), includeGroup(length: 120)])
}
model tiki_group_watches {
watchId Int @id @default(autoincrement())
group String @default("") @db.VarChar(200)
event String @default("") @db.VarChar(40)
object String @default("") @db.VarChar(200)
title String? @db.VarChar(250)
type String? @db.VarChar(200)
url String? @db.VarChar(250)
@@index([event, object(length: 100), group(length: 50)], map: "event-object-group")
}
model tiki_groupalert {
groupName String @default("") @db.VarChar(255)
objectType String @default("") @db.VarChar(20)
objectId String @default("") @db.VarChar(10)
displayEachuser String? @db.Char(1)
@@id([groupName(length: 161), objectType, objectId])
}
model tiki_h5p_contents {
id Int @id @default(autoincrement()) @db.UnsignedInt
file_id Int @unique(map: "fileId") @db.UnsignedInt
created_at DateTime? @db.Timestamp(0)
updated_at DateTime? @db.Timestamp(0)
user_id Int @db.UnsignedInt
title String @db.VarChar(255)
library_id Int @db.UnsignedInt
parameters String @db.LongText
filtered String? @db.LongText
slug String @db.VarChar(127)
embed_type String @db.VarChar(127)
disable Int @default(0) @db.UnsignedInt
content_type String? @db.VarChar(127)
authors String? @db.MediumText
license String? @db.VarChar(32)
keywords String? @db.Text
description String? @db.Text
source String? @db.VarChar(2083)
year_from Int? @db.UnsignedInt
year_to Int? @db.UnsignedInt
license_version String? @db.VarChar(10)
license_extras String? @db.LongText
author_comments String? @db.LongText
changes String? @db.MediumText
}
model tiki_h5p_contents_libraries {
content_id Int @db.UnsignedInt
library_id Int @db.UnsignedInt
dependency_type String @db.VarChar(31)
weight Int @default(0) @db.UnsignedSmallInt
drop_css Int @db.UnsignedTinyInt
@@id([content_id, library_id, dependency_type])
}
model tiki_h5p_libraries {
id Int @id @default(autoincrement()) @db.UnsignedInt
created_at DateTime? @db.Timestamp(0)
updated_at DateTime? @db.Timestamp(0)
name String @db.VarChar(127)
title String @db.VarChar(255)
major_version Int @db.UnsignedInt
minor_version Int @db.UnsignedInt
patch_version Int @db.UnsignedInt
runnable Int @db.UnsignedInt
restricted Int @default(0) @db.UnsignedInt
fullscreen Int @db.UnsignedInt
embed_types String @db.VarChar(255)
preloaded_js String? @db.Text
preloaded_css String? @db.Text
drop_library_css String? @db.Text
semantics String @db.Text
tutorial_url String @db.VarChar(1023)
has_icon Int @default(0) @db.UnsignedInt
metadata_settings String? @db.Text
add_to String? @db.Text
@@index([name, major_version, minor_version, patch_version], map: "name_version")
@@index([runnable], map: "runnable")
}
model tiki_h5p_libraries_cachedassets {
library_id Int @db.UnsignedInt
hash String @db.VarChar(64)
@@id([library_id, hash])
}
model tiki_h5p_libraries_hub_cache {
id Int @id @default(autoincrement()) @db.UnsignedInt
machine_name String @db.VarChar(127)
major_version Int @db.UnsignedInt
minor_version Int @db.UnsignedInt
patch_version Int @db.UnsignedInt
h5p_major_version Int? @db.UnsignedInt
h5p_minor_version Int? @db.UnsignedInt
title String @db.VarChar(255)
summary String @db.Text
description String @db.Text
icon String @db.VarChar(511)
created_at Int @db.UnsignedInt
updated_at Int @db.UnsignedInt
is_recommended Int @db.UnsignedInt
popularity Int @db.UnsignedInt
screenshots String? @db.Text
license String? @db.Text
example String @db.VarChar(511)
tutorial String? @db.VarChar(511)
keywords String? @db.Text
categories String? @db.Text
owner String? @db.VarChar(511)
@@index([machine_name, major_version, minor_version, patch_version], map: "name_version")
}
model tiki_h5p_libraries_languages {
library_id Int @db.UnsignedInt
language_code String @db.VarChar(31)
translation String @db.Text
@@id([library_id, language_code])
}
model tiki_h5p_libraries_libraries {
library_id Int @db.UnsignedInt
required_library_id Int @db.UnsignedInt
dependency_type String @db.VarChar(31)
@@id([library_id, required_library_id])
}
model tiki_h5p_results {
id Int @id @default(autoincrement()) @db.UnsignedInt
content_id Int @db.UnsignedInt
user_id Int @db.UnsignedInt
score Int @db.UnsignedInt
max_score Int @db.UnsignedInt
opened Int @db.UnsignedInt
finished Int @db.UnsignedInt
time Int @db.UnsignedInt
@@index([content_id, user_id], map: "content_user")
}
model tiki_h5p_tmpfiles {
id Int @id @default(autoincrement()) @db.UnsignedInt
path String @db.VarChar(255)
created_at Int @db.UnsignedInt
@@index([created_at], map: "created_at")
@@index([path(length: 191)], map: "path")
}
model tiki_history {
historyId Int @default(autoincrement())
pageName String @default("") @db.VarChar(160)
version Int @default(0)
version_minor Int @default(0)
lastModif Int?
description String? @db.VarChar(200)
user String @default("") @db.VarChar(200)
ip String? @db.VarChar(39)
comment String? @db.VarChar(255)
data Bytes?
type String? @db.VarChar(50)
is_html Boolean @default(false)
@@id([pageName, version])
@@index([historyId], map: "historyId")
@@index([user(length: 191)], map: "user")
}
model tiki_hotwords {
word String @id(length: 191) @default("") @db.VarChar(255)
url String @default("") @db.VarChar(255)
}
model tiki_html_pages {
pageName String @id(length: 191) @default("") @db.VarChar(200)
content Bytes?
refresh Int?
type String? @db.Char(1)
created Int?
}
model tiki_html_pages_dynamic_zones {
pageName String @default("") @db.VarChar(40)
zone String @default("") @db.VarChar(80)
type String? @db.Char(2)
content String? @db.Text
@@id([pageName, zone])
}
model tiki_images {
imageId Int @id @default(autoincrement())
galleryId Int @default(0)
name String @default("") @db.VarChar(200)
description String? @db.Text
lon Float? @db.Float
lat Float? @db.Float
created Int?
user String? @default("") @db.VarChar(200)
hits Int?
path String? @db.VarChar(255)
@@index([description(length: 191)], map: "description")
@@index([hits], map: "hits")
@@index([name(length: 191)], map: "name")
@@index([created], map: "ti_cr")
@@index([galleryId], map: "ti_gId")
@@index([user(length: 191)], map: "ti_us")
}
model tiki_images_data {
imageId Int @default(0)
xsize Int @default(0)
ysize Int @default(0)
type String @default("") @db.Char(1)
filesize Int?
filetype String? @db.VarChar(80)
filename String? @db.VarChar(80)
data Bytes?
etag String? @db.VarChar(32)
@@id([imageId, xsize, ysize, type])
@@index([imageId, type], map: "t_i_d_it")
}
model tiki_integrator_reps {
repID Int @id @default(autoincrement())
name String @default("") @db.VarChar(255)
path String @default("") @db.VarChar(255)
start_page String @default("") @db.VarChar(255)
css_file String @default("") @db.VarChar(255)
visibility String @default("y") @db.Char(1)
cacheable String @default("y") @db.Char(1)
expiration Int @default(0)
description String @db.Text
}
model tiki_integrator_rules {
ruleID Int @id @default(autoincrement())
repID Int @default(0)
ord Int @default(0) @db.UnsignedInt
srch Bytes @db.Blob
repl Bytes @db.Blob
type String @default("n") @db.Char(1)
casesense String @default("y") @db.Char(1)
rxmod String @default("") @db.VarChar(20)
enabled String @default("n") @db.Char(1)
description String @db.Text
@@index([repID], map: "repID")
}
model tiki_invite {
id Int @id @default(autoincrement())
inviter String @db.VarChar(200)
groups String? @db.VarChar(255)
ts Int
emailsubject String @db.VarChar(255)
emailcontent String @db.Text
wikicontent String? @db.Text
wikipageafter String? @db.VarChar(255)
}
model tiki_invited {
id Int @id @default(autoincrement())
id_invite Int
email String @db.VarChar(255)
firstname String @db.VarChar(24)
lastname String @db.VarChar(24)
used tiki_invited_used
used_on_user String? @db.VarChar(200)
@@index([id_invite], map: "id_invite")
@@index([used_on_user(length: 191)], map: "used_on_user")
}
model tiki_language {
id Int @id @default(autoincrement())
source String @db.Text
lang String @default("") @db.Char(16)
tran String? @db.Text
changed Boolean?
general Boolean?
userId Int?
lastModif Int?
}
model tiki_link_cache {
cacheId Int @id @default(autoincrement())
url String? @db.VarChar(250)
data Bytes?
refresh Int?
@@index([url(length: 191)], map: "url")
@@index([url(length: 191)], map: "urlindex")
}
model tiki_links {
fromPage String @default("") @db.VarChar(160)
toPage String @default("") @db.VarChar(160)
@@id([fromPage(length: 96), toPage(length: 95)])
@@index([toPage], map: "toPage")
}
model tiki_live_support_events {
eventId Int @id @default(autoincrement())
reqId String @default("") @db.VarChar(32)
type String? @db.VarChar(40)
seqId Int?
senderId String? @db.VarChar(32)
data String? @db.Text
timestamp Int?
}
model tiki_live_support_message_comments {
cId Int @id @default(autoincrement())
msgId Int?
data String? @db.Text
timestamp Int?
}
model tiki_live_support_messages {
msgId Int @id @default(autoincrement())
data String? @db.Text
timestamp Int?
user String @default("") @db.VarChar(200)
username String? @db.VarChar(200)
priority Int?
status String? @db.Char(1)
assigned_to String? @db.VarChar(200)
resolution String? @db.VarChar(100)
title String? @db.VarChar(200)
module Int?
email String? @db.VarChar(250)
}
model tiki_live_support_modules {
modId Int @id @default(autoincrement())
name String? @db.VarChar(90)
}
model tiki_live_support_operators {
user String @id(length: 191) @default("") @db.VarChar(200)
accepted_requests Int?
status String? @db.VarChar(20)
longest_chat Int?
shortest_chat Int?
average_chat Int?
last_chat Int?
time_online Int?
votes Int?
points Int?
status_since Int?
}
model tiki_live_support_requests {
reqId String @id @default("") @db.VarChar(32)
user String @default("") @db.VarChar(200)
tiki_user String? @db.VarChar(200)
email String? @db.VarChar(200)
operator String? @db.VarChar(200)
operator_id String? @db.VarChar(32)
user_id String? @db.VarChar(32)
reason String? @db.Text
req_timestamp Int?
timestamp Int?
status String? @db.VarChar(40)
resolution String? @db.VarChar(40)
chat_started Int?
chat_ended Int?
}
model tiki_logs {
logId Int @id @default(autoincrement())
logtype String @db.VarChar(20)
logmessage String @db.Text
loguser String @db.VarChar(40)
logip String? @db.VarChar(200)
logclient String @db.Text
logtime Int
@@index([logtype], map: "logtype")
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_mail_events {
event String? @db.VarChar(200)
object String? @db.VarChar(200)
email String? @db.VarChar(200)
@@ignore
}
model tiki_mail_queue {
messageId Int @id @default(autoincrement())
message String? @db.Text
attempts Int @default(0)
}
model tiki_mailin_accounts {
accountId Int @id @default(autoincrement())
user String @default("") @db.VarChar(200)
account String @default("") @db.VarChar(50)
protocol String @default("pop") @db.VarChar(10)
host String? @db.VarChar(255)
port Int?
username String? @db.VarChar(100)
pass String? @db.VarChar(100)
active String? @db.Char(1)
type String? @db.VarChar(40)
anonymous String @default("y") @db.Char(1)
admin String @default("y") @db.Char(1)
attachments String @default("n") @db.Char(1)
routing String @default("y") @db.Char(1)
article_topicId Int?
article_type String? @db.VarChar(50)
discard_after String? @db.VarChar(255)
show_inlineImages String? @db.Char(1)
save_html String? @default("y") @db.Char(1)
categoryId Int?
namespace String? @db.VarChar(20)
respond_email String @default("y") @db.Char(1)
leave_email String @default("n") @db.Char(1)
}
model tiki_menu_languages {
menuId Int @default(autoincrement())
language String @default("") @db.Char(16)
@@id([menuId, language])
}
model tiki_menu_options {
optionId Int @id @default(autoincrement())
menuId Int?
type String? @db.Char(1)
name String? @db.VarChar(200)
url String? @db.VarChar(255)
position Int?
section String? @db.Text
perm String? @db.Text
groupname String? @db.Text
userlevel Int? @default(0)
icon String? @db.VarChar(200)
class String? @db.Text
@@unique([menuId, name(length: 30), url(length: 50), position, section(length: 60), perm(length: 50), groupname(length: 50)], map: "uniq_menu")
}
model tiki_menus {
menuId Int @id @default(autoincrement())
name String @default("") @db.VarChar(200)
description String? @db.Text
type String? @db.Char(1)
icon String? @db.VarChar(200)
use_items_icons String @default("n") @db.Char(1)
parse String @default("n") @db.Char(1)
}
model tiki_minical_events {
user String? @default("") @db.VarChar(200)
eventId Int @id @default(autoincrement())
title String? @db.VarChar(250)
description String? @db.Text
start Int?
end Int?
security String? @db.Char(1)
duration Int?
topicId Int?
reminded String? @db.Char(1)
}
model tiki_minical_topics {
user String? @default("") @db.VarChar(200)
topicId Int @id @default(autoincrement())
name String? @db.VarChar(250)
filename String? @db.VarChar(200)
filetype String? @db.VarChar(200)
filesize String? @db.VarChar(200)
data Bytes?
path String? @db.VarChar(250)
isIcon String? @db.Char(1)
}
model tiki_minichat {
id Int @id @default(autoincrement()) @db.UnsignedInt
channel String? @db.VarChar(31)
ts Int @db.UnsignedInt
user String? @db.VarChar(31)
nick String? @db.VarChar(31)
msg String @db.VarChar(255)
@@index([channel], map: "channel")
}
model tiki_modules {
moduleId Int @id @default(autoincrement())
name String @default("") @db.VarChar(200)
position String @default("") @db.VarChar(20)
ord Int @default(0)
type String? @db.Char(1)
title String? @db.VarChar(255)
cache_time Int?
rows Int?
params String? @db.Text
groups String? @db.Text
@@index([name(length: 100), position, ord, params(length: 120)], map: "namePosOrdParam")
@@index([position, type], map: "positionType")
}
model tiki_newsletter_groups {
nlId Int @default(0)
groupName String @default("") @db.VarChar(255)
code String? @db.VarChar(32)
include_groups String? @default("y") @db.Char(1)
@@id([nlId, groupName(length: 179)])
}
model tiki_newsletter_included {
nlId Int @default(0)
includedId Int @default(0)
@@id([nlId, includedId])
}
model tiki_newsletter_pages {
nlId Int
wikiPageName String @db.VarChar(160)
validateAddrs String @default("n") @db.Char(1)
addToList String @default("n") @db.Char(1)
@@id([nlId, wikiPageName])
}
model tiki_newsletter_subscriptions {
nlId Int @default(0)
email String @default("") @db.VarChar(255)
code String? @db.VarChar(32)
valid String? @db.Char(1)
subscribed Int?
isUser String @default("n") @db.Char(1)
included String @default("n") @db.Char(1)
@@id([nlId, email(length: 178), isUser])
}
model tiki_newsletters {
nlId Int @id @default(autoincrement())
name String? @db.VarChar(200)
description String? @db.Text
created Int?
lastSent Int?
editions Int?
users Int?
allowUserSub String? @default("y") @db.Char(1)
allowAnySub String? @db.Char(1)
unsubMsg String? @default("y") @db.Char(1)
validateAddr String? @default("y") @db.Char(1)
frequency Int?
allowTxt String? @default("y") @db.Char(1)
author String? @db.VarChar(200)
allowArticleClip String? @default("y") @db.Char(1)
autoArticleClip String? @default("n") @db.Char(1)
articleClipTypes String? @db.Text
articleClipRange Int?
emptyClipBlocksSend String? @default("n") @db.Char(1)
}
model tiki_oauthserver_clients {
id Int @id @default(autoincrement())
name String @default("") @db.VarChar(128)
client_id String @unique(map: "client_id") @default("") @db.VarChar(128)
client_secret String @default("") @db.VarChar(255)
redirect_uri String @default("") @db.VarChar(255)
}
model tiki_object_attributes {
attributeId Int @id @default(autoincrement())
type String @db.VarChar(50)
itemId String @db.VarChar(160)
attribute String @db.VarChar(70)
value String? @db.VarChar(255)
comment String? @db.VarChar(255)
@@unique([type, itemId(length: 91), attribute(length: 50)], map: "item_attribute_uq")
@@index([attribute, value(length: 121)], map: "attribute_lookup_ix")
}
model tiki_object_ratings {
catObjectId Int @default(0)
pollId Int @default(0)
@@id([catObjectId, pollId])
}
model tiki_object_relations {
relationId Int @id @default(autoincrement())
relation String @db.VarChar(70)
source_type String @db.VarChar(50)
source_itemId String @db.VarChar(160)
target_type String @db.VarChar(50)
target_itemId String @db.VarChar(160)
@@index([source_type, source_itemId], map: "relation_source_ix")
@@index([target_type, target_itemId], map: "relation_target_ix")
}
model tiki_object_scores {
id Int @id @default(autoincrement()) @db.UnsignedInt
triggerObjectType String @db.VarChar(255)
triggerObjectId String @db.VarChar(255)
triggerUser String @db.VarChar(255)
triggerEvent String @db.VarChar(255)
ruleId String @db.VarChar(255)
recipientObjectType String @db.VarChar(255)
recipientObjectId String @db.VarChar(255)
pointsAssigned Int
pointsBalance Int
date Int
reversalOf Int? @db.UnsignedInt
}
model tiki_objects {
objectId Int @id @default(autoincrement())
type String? @db.VarChar(50)
itemId String? @db.VarChar(255)
description String? @db.Text
created Int?
name String? @db.VarChar(200)
href String? @db.VarChar(256)
hits Int?
comments_locked String @default("n") @db.Char(1)
@@index([itemId(length: 141), type], map: "itemId")
@@index([type, objectId], map: "type")
}
model tiki_output {
entityId String @default("") @db.VarChar(160)
objectType String @default("") @db.VarChar(32)
outputType String @default("") @db.VarChar(32)
version Int @default(0)
outputId Int @id @default(autoincrement())
}
model tiki_page_footnotes {
user String @default("") @db.VarChar(200)
pageName String @default("") @db.VarChar(250)
data String? @db.Text
@@id([user(length: 150), pageName(length: 100)])
}
model tiki_page_references {
ref_id Int @id @default(autoincrement())
page_id Int?
biblio_code String? @db.VarChar(50)
author String? @db.VarChar(255)
title String? @db.VarChar(255)
part String? @db.VarChar(255)
uri String? @db.VarChar(255)
code String? @db.VarChar(255)
year String? @db.VarChar(255)
publisher String? @db.VarChar(255)
location String? @db.VarChar(255)
style String? @db.VarChar(30)
template String? @db.VarChar(255)
last_modified DateTime @default(now()) @db.Timestamp(0)
@@unique([page_id, biblio_code], map: "uk1_tiki_page_ref_biblio_code")
@@index([page_id], map: "PageId")
@@index([author(length: 191)], map: "idx_tiki_page_ref_author")
@@index([title(length: 191)], map: "idx_tiki_page_ref_title")
}
model tiki_pages {
page_id Int @id @default(autoincrement())
pageName String @unique(map: "pageName") @default("") @db.VarChar(160)
pageSlug String? @unique(map: "pageSlug") @db.VarChar(160)
hits Int?
data String? @db.MediumText
description String? @db.VarChar(200)
lastModif Int?
comment String? @db.VarChar(255)
version Int @default(0)
version_minor Int @default(0)
user String? @default("") @db.VarChar(200)
ip String? @db.VarChar(39)
flag String? @db.Char(1)
points Int?
votes Int?
cache String? @db.LongText
wiki_cache Int?
cache_timestamp Int?
pageRank Decimal? @db.Decimal(4, 3)
creator String? @db.VarChar(200)
page_size Int? @default(0) @db.UnsignedInt
lang String? @db.VarChar(16)
lockedby String? @db.VarChar(200)
is_html Boolean? @default(false)
created Int?
wysiwyg String? @db.Char(1)
wiki_authors_style String? @default("") @db.VarChar(20)
comments_enabled String? @db.Char(1)
keywords String? @db.Text
@@index([data(length: 191)], map: "data")
@@index([lastModif], map: "lastModif")
@@index([pageRank], map: "pageRank")
}
model tiki_pages_changes {
page_id Int @default(0)
version Int @default(0)
segments_added Int?
segments_removed Int?
segments_total Int?
@@id([page_id, version])
}
model tiki_pages_translation_bits {
translation_bit_id Int @id @default(autoincrement())
page_id Int
version Int
source_translation_bit Int?
original_translation_bit Int?
flags String? @default("")
@@index([original_translation_bit], map: "original_translation_bit")
@@index([page_id], map: "page_id")
@@index([source_translation_bit], map: "source_translation_bit")
}
model tiki_pageviews {
day Int @id @default(0)
pageviews Int?
}
model tiki_payment_received {
paymentReceivedId Int @id @default(autoincrement())
paymentRequestId Int
payment_date DateTime @default(now()) @db.Timestamp(0)
amount Decimal? @db.Decimal(7, 2)
type String? @db.VarChar(15)
status String @default("paid") @db.VarChar(15)
details String? @db.Text
userId Int?
@@index([paymentRequestId], map: "payment_request_ix")
}
model tiki_payment_requests {
paymentRequestId Int @id @default(autoincrement())
amount Decimal @db.Decimal(7, 2)
amount_paid Decimal @default(0.00) @db.Decimal(7, 2)
currency String @db.Char(3)
request_date DateTime @default(now()) @db.Timestamp(0)
due_date DateTime? @db.Timestamp(0)
authorized_until DateTime? @db.Timestamp(0)
cancel_date DateTime? @db.Timestamp(0)
description String @db.VarChar(100)
actions String? @db.Text
detail String? @db.Text
userId Int?
}
model tiki_perspective_preferences {
perspectiveId Int
pref String @db.VarChar(40)
value String? @db.Text
@@id([perspectiveId, pref])
}
model tiki_perspectives {
perspectiveId Int @id @default(autoincrement())
name String @db.VarChar(100)
}
model tiki_plugin_security {
fingerprint String @id(length: 191) @db.VarChar(200)
status String @db.VarChar(10)
added_by String? @db.VarChar(200)
approval_by String? @db.VarChar(200)
last_update DateTime @default(now()) @db.Timestamp(0)
last_objectType String @db.VarChar(20)
last_objectId String @db.VarChar(200)
@@index([last_objectType, last_objectId(length: 171)], map: "last_object")
}
model tiki_poll_objects {
catObjectId Int @default(0)
pollId Int @default(0)
title String? @db.VarChar(255)
@@id([catObjectId, pollId])
}
model tiki_poll_options {
pollId Int @default(0)
optionId Int @id @default(autoincrement())
title String? @db.VarChar(200)
position Int @default(0)
votes Int?
}
model tiki_polls {
pollId Int @id @default(autoincrement())
title String? @db.VarChar(200)
votes Int?
active String? @db.Char(1)
publishDate Int?
voteConsiderationSpan Int? @default(0)
@@index([active, title(length: 190)], map: "tiki_poll_lookup")
}
model tiki_preferences {
name String @id(length: 191) @default("") @db.VarChar(255)
value String? @db.Text
}
model tiki_private_messages {
messageId Int @id @default(autoincrement())
toNickname String @default("") @db.VarChar(200)
poster String @default("anonymous") @db.VarChar(200)
timestamp Int?
received Boolean @default(false)
message String? @db.VarChar(255)
@@index([received], map: "received")
@@index([timestamp], map: "timestamp")
}
model tiki_profile_symbols {
domain String @db.VarChar(50)
profile String @db.VarChar(100)
object String @db.VarChar(150)
type String @db.VarChar(20)
value String @db.VarChar(160)
named tiki_profile_symbols_named
creation_date DateTime @default(now()) @db.Timestamp(0)
@@id([domain, profile(length: 70), object(length: 71)])
@@index([named], map: "named")
}
model tiki_programmed_content {
pId Int @id @default(autoincrement())
contentId Int @default(0)
content_type String @default("static") @db.VarChar(20)
publishDate Int @default(0)
data String? @db.Text
}
model tiki_queue {
entryId Int @id @default(autoincrement())
queue String @db.VarChar(25)
timestamp Int
handler String? @db.VarChar(64)
message String @db.Text
@@index([handler], map: "queue_handler_ix")
@@index([queue], map: "queue_name_ix")
}
model tiki_quiz_question_options {
optionId Int @id @default(autoincrement())
questionId Int?
optionText String? @db.Text
points Int?
}
model tiki_quiz_questions {
questionId Int @id @default(autoincrement())
quizId Int?
question String? @db.Text
position Int?
type String? @db.Char(1)
maxPoints Int?
}
model tiki_quiz_results {
resultId Int @id @default(autoincrement())
quizId Int?
fromPoints Int?
toPoints Int?
answer String? @db.Text
}
model tiki_quiz_stats {
quizId Int @default(0)
questionId Int @default(0)
optionId Int @default(0)
votes Int?
@@id([quizId, questionId, optionId])
}
model tiki_quiz_stats_sum {
quizId Int @id @default(0)
quizName String? @db.VarChar(255)
timesTaken Int?
avgpoints Decimal? @db.Decimal(5, 2)
avgavg Decimal? @db.Decimal(5, 2)
avgtime Decimal? @db.Decimal(5, 2)
}
model tiki_quizzes {
quizId Int @id @default(autoincrement())
name String? @db.VarChar(255)
description String? @db.Text
canRepeat String? @db.Char(1)
storeResults String? @db.Char(1)
questionsPerPage Int?
timeLimited String? @db.Char(1)
timeLimit Int?
created Int?
taken Int?
immediateFeedback String? @db.Char(1)
showAnswers String? @db.Char(1)
shuffleQuestions String? @db.Char(1)
shuffleAnswers String? @db.Char(1)
publishDate Int?
expireDate Int?
bDeleted String? @db.Char(1)
nAuthor Int?
bOnline String? @db.Char(1)
bRandomQuestions String? @db.Char(1)
nRandomQuestions Int? @db.TinyInt
bLimitQuestionsPerPage String? @db.Char(1)
nLimitQuestionsPerPage Int? @db.TinyInt
bMultiSession String? @db.Char(1)
nCanRepeat Int? @db.TinyInt
sGradingMethod String? @db.VarChar(80)
sShowScore String? @db.VarChar(80)
sShowCorrectAnswers String? @db.VarChar(80)
sPublishStats String? @db.VarChar(80)
bAdditionalQuestions String? @db.Char(1)
bForum String? @db.Char(1)
sForum String? @db.VarChar(80)
sPrologue String? @db.Text
sData String? @db.Text
sEpilogue String? @db.Text
passingperct Int? @default(0)
}
model tiki_rating_configs {
ratingConfigId Int @id @default(autoincrement())
name String @db.VarChar(50)
expiry Int @default(3600)
formula String @db.Text
callbacks String? @db.Text
}
model tiki_rating_obtained {
ratingId Int @id @default(autoincrement())
ratingConfigId Int
type String @db.VarChar(50)
object Int
expire Int
value Float @db.Float
@@unique([type, object, ratingConfigId], map: "tiki_obtained_rating_uq")
}
model tiki_received_articles {
receivedArticleId Int @id @default(autoincrement())
receivedFromSite String? @db.VarChar(200)
receivedFromUser String? @db.VarChar(200)
receivedDate Int?
title String? @db.VarChar(80)
authorName String? @db.VarChar(60)
size Int?
useImage String? @db.Char(1)
image_name String? @db.VarChar(80)
image_type String? @db.VarChar(80)
image_size Int?
image_x Int?
image_y Int?
image_data Bytes?
publishDate Int?
expireDate Int?
created Int?
heading String? @db.Text
body Bytes?
hash String? @db.VarChar(32)
author String? @db.VarChar(200)
type String? @db.VarChar(50)
rating Decimal? @db.Decimal(3, 2)
}
model tiki_received_pages {
receivedPageId Int @id @default(autoincrement())
pageName String @default("") @db.VarChar(160)
data Bytes?
description String? @db.VarChar(200)
comment String? @db.VarChar(200)
receivedFromSite String? @db.VarChar(200)
receivedFromUser String? @db.VarChar(200)
receivedDate Int?
parent String? @db.VarChar(255)
position Int? @db.UnsignedTinyInt
alias String? @db.VarChar(255)
structureName String? @db.VarChar(250)
parentName String? @db.VarChar(250)
page_alias String? @default("") @db.VarChar(250)
pos Int?
@@index([structureName(length: 191)], map: "structureName")
}
model tiki_referer_stats {
referer String @id(length: 191) @default("") @db.VarChar(255)
hits Int?
last Int?
lasturl String? @db.Text
}
model tiki_registration_fields {
id Int @id @default(autoincrement())
field String @default("") @db.VarChar(255)
name String? @db.VarChar(255)
type String @default("text") @db.VarChar(255)
show Boolean @default(true)
size String? @default("10") @db.VarChar(10)
}
model tiki_related_categories {
categId Int @default(0)
relatedTo Int @default(0)
@@id([categId, relatedTo])
}
model tiki_rss_feeds {
name String @default("") @db.VarChar(60)
rssVer String @default("1") @db.Char(1)
refresh Int? @default(300)
lastUpdated Int?
cache Bytes?
@@id([name, rssVer])
}
model tiki_rss_items {
rssItemId Int @id @default(autoincrement())
rssId Int
guid String @db.VarChar(255)
url String @db.Text
publication_date Int @db.UnsignedInt
title String @db.VarChar(255)
author String? @db.VarChar(255)
description String? @db.Text
content String? @db.Text
categories String? @db.Text
@@index([rssId, guid(length: 177)], map: "tiki_rss_items_item")
@@index([rssId], map: "tiki_rss_items_rss")
}
model tiki_rss_modules {
rssId Int @id @default(autoincrement())
name String @default("") @db.VarChar(30)
description String? @db.Text
url String @default("") @db.VarChar(255)
refresh Int?
lastUpdated Int?
showTitle String? @default("n") @db.Char(1)
showPubDate String? @default("n") @db.Char(1)
sitetitle String? @db.VarChar(255)
siteurl String? @db.VarChar(255)
actions String? @db.Text
@@index([name], map: "name")
}
model tiki_scheduler {
id Int @id @default(autoincrement())
name String? @db.VarChar(255)
description String? @db.VarChar(255)
task String? @db.VarChar(255)
params String? @db.Text
run_time String? @db.VarChar(255)
status String? @db.VarChar(10)
re_run Int? @db.TinyInt
creation_date Int?
}
model tiki_scheduler_run {
id Int @id @default(autoincrement())
scheduler_id Int
start_time Int?
end_time Int?
status String? @db.VarChar(10)
output String? @db.Text
stalled Int? @default(0) @db.TinyInt
healed Int? @default(0) @db.TinyInt
}
model tiki_schema {
patch_name String @id @db.VarChar(100)
install_date DateTime @default(now()) @db.Timestamp(0)
}
model tiki_score {
event String @id(length: 191) @default("") @db.VarChar(255)
data String? @db.Text
reversalEvent String? @db.VarChar(255)
}
model tiki_search_queries {
queryId Int @id @default(autoincrement())
userId Int
lastModif Int?
label String @db.VarChar(100)
priority String @db.VarChar(15)
query Bytes? @db.Blob
description String? @db.Text
@@unique([userId, label], map: "tiki_user_query_uq")
@@index([userId], map: "query_userId")
}
model tiki_search_stats {
term String @id @default("") @db.VarChar(50)
hits Int?
}
model tiki_secdb {
md5_value String @db.VarChar(32)
filename String @db.VarChar(250)
tiki_version String @db.VarChar(60)
severity Int @default(0)
@@id([filename(length: 171), tiki_version(length: 20)])
@@index([filename(length: 191)], map: "sdb_fn")
}
model tiki_sefurl_regex_out {
id Int @id @default(autoincrement())
left String @unique(map: "left", length: 128) @db.VarChar(256)
right String? @db.VarChar(256)
type String? @db.VarChar(32)
silent String? @default("n") @db.Char(1)
feature String? @db.VarChar(256)
comment String? @db.VarChar(256)
order Int? @default(0)
@@index([silent, type, feature(length: 30)], map: "idx1")
}
model tiki_semantic_tokens {
token String @id @db.VarChar(15)
label String @db.VarChar(25)
invert_token String? @db.VarChar(15)
}
model tiki_semaphores {
semName String @id(length: 191) @default("") @db.VarChar(250)
objectType String? @default("wiki page") @db.VarChar(20)
user String @default("") @db.VarChar(200)
timestamp Int?
value String? @db.VarChar(255)
}
model tiki_sent_newsletters {
editionId Int @id @default(autoincrement())
nlId Int @default(0)
users Int?
sent Int?
subject String? @db.VarChar(200)
data Bytes?
datatxt Bytes?
wysiwyg String? @db.Char(1)
is_html String? @db.VarChar(2)
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_sent_newsletters_errors {
editionId Int?
email String? @db.VarChar(255)
login String? @default("") @db.VarChar(40)
error String? @default("") @db.Char(1)
@@index([editionId], map: "editionId")
@@ignore
}
model tiki_sent_newsletters_files {
id Int @id @default(autoincrement())
editionId Int
name String @db.VarChar(256)
type String @db.VarChar(64)
size Int
filename String @db.VarChar(256)
@@index([editionId], map: "editionId")
}
model tiki_sessions {
sessionId String @id @default("") @db.VarChar(32)
user String? @default("") @db.VarChar(200)
timestamp Int?
tikihost String? @db.VarChar(200)
@@index([timestamp], map: "timestamp")
@@index([user(length: 191)], map: "user")
}
model tiki_sheet_layout {
sheetId Int @default(0)
begin Int @default(0)
end Int?
headerRow Int @default(0)
footerRow Int @default(0)
className String? @db.VarChar(64)
parseValues String @default("n") @db.Char(1)
clonedSheetId Int?
metadata Bytes?
@@unique([sheetId, begin], map: "sheetId")
}
model tiki_sheet_values {
sheetId Int @default(0)
begin Int @default(0)
end Int?
rowIndex Int @default(0)
columnIndex Int @default(0)
value String? @db.VarChar(255)
calculation String? @db.VarChar(255)
width Int @default(1)
height Int @default(1)
format String? @db.VarChar(255)
user String? @default("") @db.VarChar(200)
style String? @default("") @db.VarChar(255)
class String? @default("") @db.VarChar(255)
clonedSheetId Int?
@@unique([sheetId, begin, rowIndex, columnIndex], map: "sheetId")
@@index([sheetId, rowIndex, columnIndex], map: "sheetId_2")
}
model tiki_sheets {
sheetId Int @id @default(autoincrement())
title String @default("") @db.VarChar(200)
description String? @db.Text
author String @default("") @db.VarChar(200)
parentSheetId Int?
clonedSheetId Int?
}
model tiki_shoutbox {
msgId Int @id @default(autoincrement())
message String? @db.VarChar(255)
timestamp Int?
user String? @default("") @db.VarChar(200)
hash String? @db.VarChar(32)
tweetId BigInt @default(0) @db.UnsignedBigInt
}
model tiki_shoutbox_words {
word String @id @db.VarChar(40)
qty Int @default(0)
}
model tiki_source_auth {
identifier String @id @db.VarChar(50)
scheme String @db.VarChar(20)
domain String @db.VarChar(200)
path String @db.VarChar(200)
method String @db.VarChar(20)
arguments String @db.Text
@@index([scheme, domain(length: 171)], map: "tiki_source_auth_ix")
}
model tiki_stats {
object String @default("") @db.VarChar(255)
type String @default("") @db.VarChar(20)
day Int @default(0)
hits Int @default(0)
@@id([object(length: 157), type, day])
}
model tiki_structure_versions {
structure_id Int @id @default(autoincrement())
version Int?
}
model tiki_structures {
page_ref_id Int @id @default(autoincrement())
structure_id Int
parent_id Int?
page_id Int
page_version Int?
page_alias String? @default("") @db.VarChar(240)
pos Int?
@@index([page_id], map: "page_id")
@@index([page_id, parent_id], map: "pidpaid")
}
model tiki_submissions {
subId Int @id @default(autoincrement())
topline String? @db.VarChar(255)
title String? @db.VarChar(255)
subtitle String? @db.VarChar(255)
linkto String? @db.VarChar(255)
lang String? @db.VarChar(16)
authorName String? @db.VarChar(60)
topicId Int?
topicName String? @db.VarChar(40)
size Int?
useImage String? @db.Char(1)
image_name String? @db.VarChar(80)
image_caption String? @db.Text
image_type String? @db.VarChar(80)
image_size Int?
image_x Int?
image_y Int?
image_data Bytes?
publishDate Int?
expireDate Int?
created Int?
bibliographical_references String? @db.Text
resume String? @db.Text
heading String? @db.Text
body String? @db.Text
author String? @db.VarChar(200)
nbreads Int?
votes Int?
points Int?
type String? @db.VarChar(50)
rating Decimal? @db.Decimal(3, 2)
isfloat String? @db.Char(1)
}
model tiki_suggested_faq_questions {
sfqId Int @id @default(autoincrement())
faqId Int @default(0)
question String? @db.Text
answer String? @db.Text
created Int?
user String @default("") @db.VarChar(200)
}
model tiki_survey_question_options {
optionId Int @id @default(autoincrement())
questionId Int @default(0)
qoption String? @db.Text
votes Int?
}
model tiki_survey_questions {
questionId Int @id @default(autoincrement())
surveyId Int @default(0)
question String? @db.Text
options String? @db.Text
type String? @db.Char(1)
position Int?
votes Int? @default(0)
value Int? @default(0)
average Decimal? @db.Decimal(4, 2)
mandatory String @default("n") @db.Char(1)
max_answers Int @default(0)
min_answers Int @default(0)
}
model tiki_surveys {
surveyId Int @id @default(autoincrement())
name String? @db.VarChar(200)
description String? @db.Text
taken Int?
lastTaken Int?
created Int?
status String? @db.Char(1)
}
model tiki_tabular_formats {
tabularId Int @id @default(autoincrement())
trackerId Int
name String @db.VarChar(255)
format_descriptor String? @db.Text
filter_descriptor String? @db.Text
config String? @db.Text
@@index([trackerId], map: "tabular_tracker_ix")
}
model tiki_tags {
tagName String @default("") @db.VarChar(80)
pageName String @default("") @db.VarChar(160)
hits Int?
description String? @db.VarChar(200)
data Bytes?
lastModif Int?
comment String? @db.VarChar(200)
version Int @default(0)
user String @default("") @db.VarChar(200)
ip String? @db.VarChar(39)
flag String? @db.Char(1)
@@id([tagName, pageName])
}
model tiki_theme_control_categs {
categId Int @id @default(0)
theme String @default("") @db.VarChar(250)
}
model tiki_theme_control_objects {
objId String @default("") @db.VarChar(250)
type String @default("") @db.VarChar(250)
name String @default("") @db.VarChar(250)
theme String @default("") @db.VarChar(250)
@@id([objId(length: 100), type(length: 100)])
}
model tiki_theme_control_sections {
section String @id(length: 191) @default("") @db.VarChar(250)
theme String @default("") @db.VarChar(250)
}
model tiki_todo {
todoId Int @id @default(autoincrement())
after Int
event String @db.VarChar(50)
objectType String? @db.VarChar(50)
objectId String? @db.VarChar(255)
from String? @db.VarChar(255)
to String? @db.VarChar(255)
@@index([after], map: "after")
@@index([objectType, objectId(length: 141)], map: "what")
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_todo_notif {
todoId Int
objectType String? @db.VarChar(50)
objectId String? @db.VarChar(255)
@@index([objectId(length: 191)], map: "objectId")
@@index([todoId], map: "todoId")
@@ignore
}
model tiki_topics {
topicId Int @id @default(autoincrement())
name String? @db.VarChar(40)
image_name String? @db.VarChar(80)
image_type String? @db.VarChar(80)
image_size Int?
image_data Bytes?
active String? @db.Char(1)
created Int?
}
model tiki_tracker_fields {
fieldId Int @id @default(autoincrement())
trackerId Int @default(0)
name String? @db.VarChar(255)
permName String? @db.VarChar(100)
options String? @db.Text
type String? @db.VarChar(15)
isMain String? @db.Char(1)
isTblVisible String? @db.Char(1)
position Int?
isSearchable String @default("y") @db.Char(1)
isPublic String @default("n") @db.Char(1)
isHidden String @default("n") @db.Char(1)
isMandatory String @default("n") @db.Char(1)
description String? @db.Text
isMultilingual String? @default("n") @db.Char(1)
itemChoices String? @db.Text
errorMsg String? @db.Text
visibleBy String? @db.Text
editableBy String? @db.Text
descriptionIsParsed String? @default("n") @db.Char(1)
validation String? @default("") @db.VarChar(255)
validationParam String? @default("") @db.VarChar(255)
validationMessage String? @default("") @db.VarChar(255)
@@unique([permName, trackerId], map: "permName")
@@index([trackerId], map: "trackerId")
}
model tiki_tracker_item_attachments {
attId Int @id @default(autoincrement())
itemId Int @default(0)
filename String? @db.VarChar(80)
filetype String? @db.VarChar(80)
filesize Int?
user String? @db.VarChar(200)
data Bytes?
path String? @db.VarChar(255)
hits Int?
created Int?
comment String? @db.VarChar(250)
longdesc Bytes? @db.Blob
version String? @db.VarChar(40)
@@index([itemId], map: "itemId")
}
/// The underlying table does not contain a valid unique identifier and can therefore currently not be handled by the Prisma Client.
model tiki_tracker_item_field_logs {
version Int
itemId Int @default(0)
fieldId Int @default(0)
value String? @db.Text
@@index([fieldId], map: "fieldId")
@@index([itemId], map: "itemId")
@@index([version], map: "version")
@@ignore
}
model tiki_tracker_item_fields {
itemId Int @default(0)
fieldId Int @default(0)
value String? @db.Text
@@id([itemId, fieldId])
@@index([fieldId], map: "fieldId")
@@index([value(length: 191)], map: "value")
}
model tiki_tracker_items {
itemId Int @id @default(autoincrement())
trackerId Int @default(0)
created Int?
createdBy String? @db.VarChar(200)
status String? @db.Char(1)
lastModif Int?
lastModifBy String? @db.VarChar(200)
@@index([trackerId], map: "trackerId")
}
model tiki_tracker_options {
trackerId Int @default(0)
name String @default("") @db.VarChar(80)
value String? @db.Text
@@id([trackerId, name(length: 30)])
}
model tiki_trackers {
trackerId Int @id @default(autoincrement())
name String? @db.VarChar(255)
description String? @db.Text
descriptionIsParsed String? @default("0") @db.VarChar(1)
created Int?
lastModif Int?
items Int?
}
model tiki_transitions {
transitionId Int @id @default(autoincrement())
preserve Int @default(0)
name String? @db.VarChar(50)
type String @db.VarChar(20)
from String @db.VarChar(255)
to String @db.VarChar(255)
guards String? @db.Text
@@index([type, from(length: 171)], map: "transition_lookup")
}
model tiki_translated_objects {
traId Int @default(autoincrement())
type String @db.VarChar(50)
objId String @db.VarChar(255)
lang String? @db.VarChar(16)
@@id([type, objId(length: 141)])
@@index([traId], map: "traId")
}
model tiki_translations_in_progress {
page_id Int
language String @db.Char(2)
@@unique([page_id, language], map: "page_id_2")
@@index([language], map: "language")
@@index([page_id], map: "page_id")
}
model tiki_untranslated {
id Int @unique(map: "id") @default(autoincrement())
source Bytes @db.TinyBlob
lang String @default("") @db.Char(16)
@@id([source(length: 255), lang])
@@index([id], map: "id_2")
}
model tiki_url_shortener {
urlId Int @id @default(autoincrement()) @db.UnsignedInt
user String @db.VarChar(200)
longurl String @db.TinyText
longurl_hash String @db.VarChar(32)
service String @db.VarChar(32)
shorturl String @unique(map: "shorturl") @db.VarChar(63)
@@index([longurl_hash], map: "longurl_hash")
}
model tiki_user_answers {
userResultId Int @default(0)
quizId Int @default(0)
questionId Int @default(0)
optionId Int @default(0)
@@id([userResultId, quizId, questionId, optionId])
}
model tiki_user_answers_uploads {
answerUploadId Int @id @default(autoincrement())
userResultId Int @default(0)
questionId Int @default(0)
filename String @default("") @db.VarChar(255)
filetype String @default("") @db.VarChar(64)
filesize String @default("") @db.VarChar(255)
filecontent Bytes
}
enum tiki_acct_book_bookClosed {
y
n
}
enum tiki_acct_book_bookAutoTax {
y
n
}
enum tiki_acct_tax_taxIsFix {
y
n
}
enum tiki_banning_mode {
user
ip
}
enum tiki_calendar_items_priority {
// 0 @map("0")
// 1 @map("1")
// 2 @map("2")
// 3 @map("3")
// 4 @map("4")
// 5 @map("5")
// 6 @map("6")
// 7 @map("7")
// 8 @map("8")
// 9 @map("9")
}
enum tiki_calendar_items_status {
// 0 @map("0")
// 1 @map("1")
// 2 @map("2")
}
enum tiki_calendar_recurrence_priority {
// 1 @map("1")
// 2 @map("2")
// 3 @map("3")
// 4 @map("4")
// 5 @map("5")
// 6 @map("6")
// 7 @map("7")
// 8 @map("8")
// 9 @map("9")
}
enum tiki_calendar_recurrence_status {
// 0 @map("0")
// 1 @map("1")
// 2 @map("2")
}
enum tiki_calendar_roles_role {
// 0 @map("0")
// 1 @map("1")
// 2 @map("2")
// 3 @map("3")
// 6 @map("6")
}
enum tiki_calendars_customlocations {
n
y
}
enum tiki_calendars_customcategories {
n
y
}
enum tiki_calendars_customlanguages {
n
y
}
enum tiki_calendars_custompriorities {
n
y
}
enum tiki_calendars_customparticipants {
n
y
}
enum tiki_calendars_customsubscription {
n
y
}
enum tiki_calendars_customstatus {
n
y
}
enum tiki_calendars_personal {
n
y
}
enum tiki_invited_used {
no
registered
logged
}
enum tiki_profile_symbols_named {
y
n
}
After line 176 with the default, the highlighting does not work any more.
Schema as file: https://github.com/prisma/migrations-ci/blob/d7ce7788e3fa66e99bb5553a1b5ded75048e81df/results/mariadb/tikiwiki/1-before-introspected.prisma (internal link)
More minimal repro:
generator client {
provider = "prisma-client-js"
}
datasource db {
provider = "mysql"
url = "..."
}
model telephone {
id Int @id @default(autoincrement()) @db.UnsignedInt
foo String @default("\"") @db.VarChar(4)
bar String @db.UnsignedInt
}
I think the same is happening here in the GitHub syntax highlighting (Update: Unsurprisingly, as it links to this repo and probably includes the same grammar file: https://github.com/github/linguist/tree/master/vendor/grammars)