prisma / language-tools

🌐 Prisma Language Tools = Language Server and Prisma's VS Code extension.
https://marketplace.visualstudio.com/items?itemName=Prisma.prisma
Apache License 2.0
250 stars 34 forks source link

Syntax Highlighting fails after `@default("\"")` #983

Open janpio opened 2 years ago

janpio commented 2 years ago

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)

Jolg42 commented 2 years ago

I can reproduce with v31.0.375 of Insider version

Screen Shot 2021-12-02 at 14 19 56
janpio commented 2 years ago

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
}

image

janpio commented 2 years ago

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)

RedCMD commented 4 weeks ago

"double_quoted_string" currently doesn't support escaped characters \" https://github.com/prisma/language-tools/blob/cd4f20f2ca7fc558800fa2c85e04c2d10839f484/packages/vscode/syntaxes/prisma.tmLanguage.json#L394-L417 image