wp.prisma.schema

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "mysql"
  url      = env("DATABASE_URL")
}

model wp_commentmeta {
  meta_id    Int     @default(autoincrement()) @id
  comment_id Int     @default(0)
  meta_key   String?
  meta_value String?

  @@index([comment_id], name: "comment_id")
  @@index([meta_key], name: "meta_key")
}

model wp_comments {
  comment_ID           Int      @default(autoincrement()) @id
  comment_post_ID      Int      @default(0)
  comment_author       String
  comment_author_email String   @default("")
  comment_author_url   String   @default("")
  comment_author_IP    String   @default("")
  comment_date         DateTime @default(dbgenerated())
  comment_date_gmt     DateTime @default(dbgenerated())
  comment_content      String
  comment_karma        Int      @default(0)
  comment_approved     String   @default("1")
  comment_agent        String   @default("")
  comment_type         String   @default("")
  comment_parent       Int      @default(0)
  user_id              Int      @default(0)

  @@index([comment_approved, comment_date_gmt], name: "comment_approved_date_gmt")
  @@index([comment_author_email], name: "comment_author_email")
  @@index([comment_date_gmt], name: "comment_date_gmt")
  @@index([comment_parent], name: "comment_parent")
  @@index([comment_post_ID], name: "comment_post_ID")
}

model wp_links {
  link_id          Int      @default(autoincrement()) @id
  link_url         String   @default("")
  link_name        String   @default("")
  link_image       String   @default("")
  link_target      String   @default("")
  link_description String   @default("")
  link_visible     String   @default("Y")
  link_owner       Int      @default(1)
  link_rating      Int      @default(0)
  link_updated     DateTime @default(dbgenerated())
  link_rel         String   @default("")
  link_notes       String
  link_rss         String   @default("")

  @@index([link_visible], name: "link_visible")
}

model wp_oauth_access_tokens {
  id           Int      @default(autoincrement()) @id
  access_token String   @unique
  client_id    String
  user_id      String?
  expires      DateTime @default(now())
  scope        String?
}

model wp_oauth_authorization_codes {
  authorization_code String   @id
  client_id          String?
  user_id            String?
  redirect_uri       String?
  expires            DateTime @default(now())
  scope              String?
  id_token           String?
}

model wp_oauth_jwt {
  client_id  String  @default("") @id
  subject    String?
  public_key String
}

model wp_oauth_public_keys {
  client_id            String  @default("") @id
  public_key           String?
  private_key          String?
  encryption_algorithm String? @default("RS256")
}

model wp_oauth_refresh_tokens {
  refresh_token String   @default("") @id
  client_id     String?
  user_id       String?
  expires       DateTime @default(now())
  scope         String?
}

model wp_oauth_scopes {
  id         Int      @default(autoincrement()) @id
  scope      String
  is_default Boolean?
}

model wp_options {
  option_id    Int    @default(autoincrement()) @id
  option_name  String @default("") @unique
  option_value String
  autoload     String @default("yes")

  @@index([autoload], name: "autoload")
}

model wp_postmeta {
  meta_id    Int     @default(autoincrement()) @id
  post_id    Int     @default(0)
  meta_key   String?
  meta_value String?

  @@index([meta_key], name: "meta_key")
  @@index([meta_value], name: "meta_value_idx")
  @@index([post_id], name: "post_id")
}

model wp_posts {
  ID                    Int      @default(autoincrement()) @id
  post_author           Int      @default(0)
  post_date             DateTime @default(dbgenerated())
  post_date_gmt         DateTime @default(dbgenerated())
  post_content          String
  post_title            String
  post_excerpt          String
  post_status           String   @default("publish")
  comment_status        String   @default("open")
  ping_status           String   @default("open")
  post_password         String   @default("")
  post_name             String   @default("")
  to_ping               String
  pinged                String
  post_modified         DateTime @default(dbgenerated())
  post_modified_gmt     DateTime @default(dbgenerated())
  post_content_filtered String
  post_parent           Int      @default(0)
  guid                  String   @default("")
  menu_order            Int      @default(0)
  post_type             String   @default("post")
  post_mime_type        String   @default("")
  comment_count         Int      @default(0)

  @@index([post_author], name: "post_author")
  @@index([post_name], name: "post_name")
  @@index([post_parent], name: "post_parent")
  @@index([post_type, post_status, post_date, ID], name: "type_status_date")
}

model wp_termmeta {
  meta_id    Int     @default(autoincrement()) @id
  term_id    Int     @default(0)
  meta_key   String?
  meta_value String?

  @@index([meta_key], name: "meta_key")
  @@index([term_id], name: "term_id")
}

model wp_terms {
  term_id    Int    @default(autoincrement()) @id
  name       String @default("")
  slug       String @default("")
  term_group Int    @default(0)

  @@index([name], name: "name")
  @@index([slug], name: "slug")
}

model wp_term_relationships {
  object_id        Int @default(0)
  term_taxonomy_id Int @default(0)
  term_order       Int @default(0)

  @@id([object_id, term_taxonomy_id])
  @@index([term_taxonomy_id], name: "term_taxonomy_id")
}

model wp_term_taxonomy {
  term_taxonomy_id Int    @default(autoincrement()) @id
  term_id          Int    @default(0)
  taxonomy         String @default("")
  description      String
  parent           Int    @default(0)
  count            Int    @default(0)

  @@index([taxonomy], name: "taxonomy")
  @@unique([term_id, taxonomy], name: "term_id_taxonomy")
}