db/config

Variables

default

default: {
  tables: unknown;
};

Defined in: studiocms/packages/studiocms/src/db/config.ts:212^

Type declaration

tables?

optional tables: unknown;

---

tsAPIKeys

const tsAPIKeys: Table<"StudioCMSAPIKeys", {
  creationDate: {
     type: "date";
    };
  description: {
     type: "text";
    };
  id: {
     type: "text";
    };
  key: {
     type: "text";
    };
  userId: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:237^

---

tsDiffTracking

const tsDiffTracking: Table<"StudioCMSDiffTracking", {
  diff: {
     type: "text";
    };
  id: {
     type: "text";
    };
  pageContentStart: {
     type: "text";
    };
  pageId: {
     type: "text";
    };
  pageMetaData: {
     type: "json";
    };
  timestamp: {
     type: "date";
    };
  userId: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:250^

---

tsEmailVerificationTokens

const tsEmailVerificationTokens: Table<"StudioCMSEmailVerificationTokens", {
  expiresAt: {
     type: "date";
    };
  id: {
     type: "text";
    };
  token: {
     type: "text";
    };
  userId: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:263^

---

tsMailerConfig

const tsMailerConfig: Table<"StudioCMSMailerConfig", {
  auth_pass: {
     type: "text";
    };
  auth_user: {
     type: "text";
    };
  default_sender: {
     type: "text";
    };
  host: {
     type: "text";
    };
  id: {
     type: "text";
    };
  port: {
     type: "number";
    };
  proxy: {
     type: "text";
    };
  secure: {
     type: "boolean";
    };
  tls_rejectUnauthorized: {
     type: "boolean";
    };
  tls_servername: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:258^

---

tsNotificationSettings

const tsNotificationSettings: Table<"StudioCMSNotificationSettings", {
  emailVerification: {
     type: "boolean";
    };
  id: {
     type: "text";
    };
  oAuthBypassVerification: {
     type: "boolean";
    };
  requireAdminVerification: {
     type: "boolean";
    };
  requireEditorVerification: {
     type: "boolean";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:259^

---

tsOAuthAccounts

const tsOAuthAccounts: Table<"StudioCMSOAuthAccounts", {
  provider: {
     type: "text";
    };
  providerUserId: {
     type: "text";
    };
  userId: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:242^

---

tsPageContent

const tsPageContent: Table<"StudioCMSPageContent", {
  content: {
     type: "text";
    };
  contentId: {
     type: "text";
    };
  contentLang: {
     type: "text";
    };
  id: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:256^

---

tsPageData

const tsPageData: Table<"StudioCMSPageData", {
  authorId: {
     type: "text";
    };
  categories: {
     type: "json";
    };
  contentLang: {
     type: "text";
    };
  contributorIds: {
     type: "json";
    };
  description: {
     type: "text";
    };
  draft: {
     type: "boolean";
    };
  heroImage: {
     type: "text";
    };
  id: {
     type: "text";
    };
  package: {
     type: "text";
    };
  parentFolder: {
     type: "text";
    };
  publishedAt: {
     type: "date";
    };
  showAuthor: {
     type: "boolean";
    };
  showContributors: {
     type: "boolean";
    };
  showOnNav: {
     type: "boolean";
    };
  slug: {
     type: "text";
    };
  tags: {
     type: "json";
    };
  title: {
     type: "text";
    };
  updatedAt: {
     type: "date";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:249^

---

tsPageDataCategories

const tsPageDataCategories: Table<"StudioCMSPageDataCategories", {
  description: {
     type: "text";
    };
  id: {
     type: "number";
    };
  meta: {
     type: "json";
    };
  name: {
     type: "text";
    };
  parent: {
     type: "number";
    };
  slug: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:252^

---

tsPageDataTags

const tsPageDataTags: Table<"StudioCMSPageDataTags", {
  description: {
     type: "text";
    };
  id: {
     type: "number";
    };
  meta: {
     type: "json";
    };
  name: {
     type: "text";
    };
  slug: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:251^

---

tsPageFolderStructure

const tsPageFolderStructure: Table<"StudioCMSPageFolderStructure", {
  id: {
     type: "text";
    };
  name: {
     type: "text";
    };
  parent: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:245^

---

tsPermissions

const tsPermissions: Table<"StudioCMSPermissions", {
  rank: {
     type: "text";
    };
  user: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:244^

---

tsPluginData

const tsPluginData: Table<"StudioCMSPluginData", {
  data: {
     type: "json";
    };
  id: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:267^

---

tsSessionTable

const tsSessionTable: Table<"StudioCMSSessionTable", {
  expiresAt: {
     type: "date";
    };
  id: {
     type: "text";
    };
  userId: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:243^

---

tsSiteConfig

const tsSiteConfig: Table<"StudioCMSSiteConfig", {
  defaultOgImage: {
     type: "text";
    };
  description: {
     type: "text";
    };
  diffPerPage: {
     type: "number";
    };
  enableDiffs: {
     type: "boolean";
    };
  enableMailer: {
     type: "boolean";
    };
  gridItems: {
     type: "json";
    };
  hideDefaultIndex: {
     type: "boolean";
    };
  id: {
     type: "number";
    };
  loginPageBackground: {
     type: "text";
    };
  loginPageCustomImage: {
     type: "text";
    };
  siteIcon: {
     type: "text";
    };
  title: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:257^

---

tsUserResetTokens

const tsUserResetTokens: Table<"StudioCMSUserResetTokens", {
  id: {
     type: "text";
    };
  token: {
     type: "text";
    };
  userId: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:238^

---

tsUsers

const tsUsers: Table<"StudioCMSUsers", {
  avatar: {
     type: "text";
    };
  createdAt: {
     type: "date";
    };
  email: {
     type: "text";
    };
  emailVerified: {
     type: "boolean";
    };
  id: {
     type: "text";
    };
  name: {
     type: "text";
    };
  notifications: {
     type: "text";
    };
  password: {
     type: "text";
    };
  updatedAt: {
     type: "date";
    };
  url: {
     type: "text";
    };
  username: {
     type: "text";
    };
}>;

Defined in: studiocms/packages/studiocms/src/db/config.ts:236^