> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Released database changes in version 9.8.7717.1401

> What's new in the latest database version.

# Released database changes in version 9.8.7717.1401

## SuperOffice

* [Modify table CacheTables](/en/database/tables/cachetables)
  subKeyId
* [Modify table ImportRelation](/en/database/tables/importrelation)
  foreignKey
* Remove table HeadingTemp

**Step 18**

Clear out orphan person records (contact\_id != 0, no such contact record exists), as well as email, phone, address and udef records that point to nonexistent parents

* [Modify table person](/en/database/tables/person)
* [Modify table phone](/en/database/tables/phone)

**Step 19**

Add fields and attributes to support the Soft Delete feature on person and contact tables

* [Modify table Contact](/en/database/tables/contact)
  DeletedDate
* [Modify table Person](/en/database/tables/person)
  DeletedDate

**Step 20**

Support Saint V2, with more entities and enable/disable

* [Add table SaintConfiguration](/en/database/tables/saintconfiguration)
* [Modify table StatusDef](/en/database/tables/statusdef)
  generationStart, lastGenerated

**Step 23**

Add UserName to Associate

* [Modify table Associate](/en/database/tables/associate)
  userName

**Step 26**

Minor update in ZipCity; update of preference descriptions; update of FI address layout; update of SuperOffice data for SW, DA, GE

**Step 27**

Preference Description update with Service mappings and new rank/group fields; also cleanup of obsolete Counter preferences (#63450)

* [Modify table PrefDesc](/en/database/tables/prefdesc)
  rank, subGroup, minLevel

**Step 28**

Add the Tags MDO list, a new Function Right to directly define tags, and assign that right to List and General admins

* [Add table Tags](/en/database/tables/tags)
* [Add table TagsGroupLink](/en/database/tables/tagsgrouplink)
* [Add table TagsHeadingLink](/en/database/tables/tagsheadinglink)

**Step 29**

Reload the CacheTabs table, to add new lists

**Step 30**

It is now possible to turn off trailing-whitespace trimming of string fields in the database; and specify this and TimeZone processing in a generic manner

* [Modify table appointment](/en/database/tables/appointment)
  do\_By, done, endDate, activeDate
* [Modify table recurrenceRule](/en/database/tables/recurrencerule)
  startDate, endDate
* [Modify table email\_folder](/en/database/tables/email-folder)
  name

**Step 31**

Preference descriptions for the R project

**Step 32**

Transfer any password rules set in the now-obsolete preference System/PasswordPolicy into the password\_rules table with id=1

**Step 33**

Add 4 fields to DocTemplate table to support Email-templates and prime in 1 row in UdListDefinition table to declare Email templates as a list

* [Modify table DocTmpl](/en/database/tables/doctmpl)
  includeSignature, showCurrents, senderEmailMode, senderEmailAddress

**Step 34**

Re-add the Tags MDO list in UdListDefinition table.

**Step 35**

Preference descriptions for the R project

**Step 36**

New classifier fields to enabled personalized and source-bound archive layouts

* [Modify table SuperListColumnSize](/en/database/tables/superlistcolumnsize)
  ownerTable, ownerRecord, group\_id, configurationName

**Step 37**

Preference descriptions for invitation support

**Step 38**

Preference descriptions for invitation support and cleanup of UserPreference table

**Step 39**

New preference: default appointment type for incoming invitations

**Step 40**

This step has been made obsolete by later changes

**Step 41**

This step has been made obsolete by later changes

**Step 42**

Updated preferences, and translated name of functional right to create Tags

**Step 43**

Updated ZipCity for Norway

**Step 44**

Add a table to keep historical information related to deleted associates

* [Add table AssociateHistory](/en/database/tables/associatehistory)

**Step 45**

Add a field snum to table document, and cautionWarning to appointment

* [Modify table Document](/en/database/tables/document)
  snum
* [Modify table Appointment](/en/database/tables/appointment)
  cautionWarning

**Step 46**

Updated preferences

**Step 47**

Update preferences priming; add a virtual field on person (dotsyntax); populate the new Main Contact field on all contact records

* [Modify table person](/en/database/tables/person)
  emailBounceCount
* [Modify table contact](/en/database/tables/contact)

**Step 48**

Add fields for language and sentiment to ej\_message; Update preferences priming: move the EmailBounceThreshold preference from the System section to the Mail section

* [Modify table ej\_message](/en/database/tables/ej-message)
  language, sentiment, sentimentConfidence

**Step 49**

Add fields for language and sentiment to ej\_message; Update preferences priming: move the EmailBounceThreshold preference from the System section to the Mail section

* [Modify table ej\_message](/en/database/tables/ej-message)
  suggestedCategory\_id

**Step 50**

Fix inconsistent Main Contact (supportPersonId) after bug in Sales.Web GUI

**Step 51**

Add a virtual field on contact (dotsyntax)

* [Modify table contact](/en/database/tables/contact)
  emailBounceCount

**Step 52**

Add 1 field to DocTemplate table to support Invitation type templates

* [Modify table DocTmpl](/en/database/tables/doctmpl)
  invitationDocType, privacyDocType

**Step 53**

Update Red Letter Days, table is overwritten, adding Red days for 2005-2030 for 23 countries

**Step 54**

Add a virtual field on person and contact (dotsyntax): emailLastBounce

* [Modify table contact](/en/database/tables/contact)
  emailLastBounce
* [Modify table person](/en/database/tables/person)
  emailLastBounce

**Step 55**

Reset bounceCount and lastBounce on the Email table for rows where lastBounce is before the start of year 2020

**Step 56**

Remove several sections and some individual preferences, that were only relevant to the Windows client.
Remove never-used fields in searchcriterionvalue and replace with a string field for valueType

* [Modify table searchcriterionvalue](/en/database/tables/searchcriterionvalue)
  valueType, valueDataType
* [Modify table searchcriterionvalue](/en/database/tables/searchcriterionvalue)
  valueType

**Step 57**

Add TimeSpan=Minutes markers to relevant fields on the ticket, ej\_message, invoice and ticket\_priority tables; controls behaviour in Archives including Selection

* [Modify table ticket](/en/database/tables/ticket)
* [Modify table ej\_message](/en/database/tables/ej-message)
  time\_spent, time\_charge
* [Modify table invoice](/en/database/tables/invoice)
  time\_charged
* [Modify table ticket\_priority](/en/database/tables/ticket-priority)
  deadline
* [Modify table ticket\_status\_history](/en/database/tables/ticket-status-history)
  timespan, real\_timespan
* [Modify table appointment](/en/database/tables/appointment)
  done, do\_by, activeDate, endDate
* [Modify table text](/en/database/tables/text)
  updatedCount

**Step 58**

Update SOCompany information for new Online databases based on what is in the template and what data is wanted spring 2020

**Step 60**

Add mother\_associate\_id to appointments to optimize logic that depends on the owner of the mother appointment

* [Modify table appointment](/en/database/tables/appointment)
  mother\_associate\_id

**Step 61**

Add soundex field to freetext words table to enable soundex searching

* [Modify table freetextwords](/en/database/tables/freetextwords)
  word, soundEx
* [Modify table freetextindex](/en/database/tables/freetextindex)
  contact\_id

**Step 62**

New preference for disabling Image editor in Unlayer mailings editor

**Step 63**

New functional right for hiding Service and Mailings button and screen

**Step 64**

New preference for invitations, no tentative appointments for others

**Step 65**

New preference for mailing, disable image library for royalty-free images

**Step 66**

Add starting 0 to german zipcodes where it missed. Update N\_List for US, remove duplicate MrMrs.

**Step 67**

, Remove duplicate of LowerLimitsaletypecat, new preference for mailing, disable image library for royalty-free images, translations

**Step 68**

, New preference for document dialog in SOFO (and possible later OML, GmailLink and WEB)

## chat

* [Modify table chat\_topic](/en/database/tables/chat-topic)
* [Modify table chat\_topic\_user](/en/database/tables/chat-topic-user)
  can\_respond, notifications, can\_listen, manager
* [Modify table chat\_session](/en/database/tables/chat-session)
  name, company\_name, email, phone, first\_message, last\_message, flags
* [Modify table chat\_message](/en/database/tables/chat-message)
  created\_by
* [Modify table ejuser](/en/database/tables/ejuser)
  chat\_status

**Step 2**

* [Modify table chat\_topic](/en/database/tables/chat-topic)
  widget\_language
* [Modify table cust\_lang](/en/database/tables/cust-lang)
  iso\_code

**Step 3**

* [Modify table chat\_session](/en/database/tables/chat-session)
  project\_id, sale\_id, ticket\_id, contact\_id, transfer\_to
* [Modify table config](/en/database/tables/config)
  feature\_toggle

**Step 4**

* [Modify table login\_customer](/en/database/tables/login-customer)
  created\_at
* [Add table quick\_reply](/en/database/tables/quick-reply)

**Step 6**

* [Modify table chat\_session](/en/database/tables/chat-session)
  consented

**Step 7**

* [Modify table chat\_topic](/en/database/tables/chat-topic)

**Step 8**

Adding field for using a custom message in the chat widget queue message

* [Modify table chat\_topic](/en/database/tables/chat-topic)
  custom\_queue\_text

**Step 9**

Add CS language to chat\_session table. Specify displayField to chat\_topic table.

* [Modify table chat\_session](/en/database/tables/chat-session)
* [Modify table chat\_topic](/en/database/tables/chat-topic)

**Step 10**

Add index on the chat\_session table, to optimize the 'anything happening now?' requests that come in every 15 seconds, per service rep

* [Modify table chat\_session](/en/database/tables/chat-session)

**Step 11**

* [Modify table chat\_topic](/en/database/tables/chat-topic)
  flags

**Step 12**

* [Modify table chat\_session](/en/database/tables/chat-session)
  status
* [Modify table chat\_message](/en/database/tables/chat-message)
  type, special\_type

**Step 13**

* [Modify table chat\_topic](/en/database/tables/chat-topic)
  bot\_enabled, bot\_name, bot\_register\_trigger\_id, bot\_newsession\_trigger\_id, bot\_statechange\_trigger\_id, bot\_newmessage\_trigger\_id
* [Modify table chat\_session](/en/database/tables/chat-session)
  chatbot\_isactive

**Step 14**

* [Modify table chat\_topic](/en/database/tables/chat-topic)
  bot\_register\_trigger\_id, bot\_newsession\_trigger\_id, bot\_statechange\_trigger\_id, bot\_newmessage\_trigger\_id, bot\_register\_scriptid, bot\_session\_created\_scriptid, bot\_session\_changed\_scriptid, bot\_message\_received\_scriptid

## ConsentManagement

* [Modify table category](/en/database/tables/category)
  family\_id

**Step 6**

* [Modify table Category](/en/database/tables/category)
  family\_id
* Remove table consent\_person
* Remove table consent\_purpose
* Remove table ConsentSource
* Remove table LegalBase
* Remove table category\_family
* [Add table ConsentPurpose](/en/database/tables/consentpurpose)
* [Add table LegalBase](/en/database/tables/legalbase)
* [Add table ConsentSource](/en/database/tables/consentsource)
* [Add table ConsentPerson](/en/database/tables/consentperson)
* [Add table CategoryFamily](/en/database/tables/categoryfamily)
* [Modify table DocTmpl](/en/database/tables/doctmpl)
  privacyDocType, emailSubject
* [Modify table Category](/en/database/tables/category)
  CategoryFamily\_id

**Step 7**

* [Modify table outbox](/en/database/tables/outbox)
  rfc822\_content

**Step 10**

* [Modify table ConsentPerson](/en/database/tables/consentperson)

**Step 11**

* [Modify table ConsentPerson](/en/database/tables/consentperson)
* [Modify table ConsentPerson](/en/database/tables/consentperson)
* [Modify table ShipmentTypeReservation](/en/database/tables/shipmenttypereservation)
* [Modify table ConsentPurpose](/en/database/tables/consentpurpose)
* [Modify table ConsentSource](/en/database/tables/consentsource)
* [Modify table LegalBase](/en/database/tables/legalbase)
* [Modify table ShipmentType](/en/database/tables/shipmenttype)

**Step 12**

* [Modify table ErpConnection](/en/database/tables/erpconnection)
  ConsentSourceId, LegalBaseId

**Step 13**

* [Modify table ErpConnection](/en/database/tables/erpconnection)
  ConsentSourceId, LegalBaseId

**Step 14**

Set the #STORE consent on all person records that do not already have it; we assume that all persons in the customers database are there for a legitimate reason

**Step 16**

As we now set the #STORE consent on all person records that do not already have it, we also set a default consent and legal base for new persons, thus we set the Default legal base preference.

**Step 22**

Remove confirmation mail links for consent sources where SuperOffice does not send privacy confirmation email by design.

**Step 23**

Update document template to sync emailmode with privacytype

## CRMScript

* [Add table script\_trace](/en/database/tables/script-trace)
* [Add table script\_trace\_run](/en/database/tables/script-trace-run)
* [Modify table screen\_chooser](/en/database/tables/screen-chooser)
  description, enabled

**Step 2**

* [Modify table ejscript](/en/database/tables/ejscript)
  extra\_menus\_id

**Step 3**

* [Modify table ejscript](/en/database/tables/ejscript)
  unique\_identifier, registered, registered\_associate\_id, updated, updated\_associate\_id, updatedCount
* [Modify table screen\_chooser](/en/database/tables/screen-chooser)
  unique\_identifier, registered, registered\_associate\_id, updated, updated\_associate\_id, updatedCount

**Step 4**

Flag unique\_identfier fields that they should be auto-populated with a GUID on creation; and populate existing rows with GUID's

* [Modify table ejscript](/en/database/tables/ejscript)
  unique\_identifier
* [Modify table screen\_chooser](/en/database/tables/screen-chooser)
  unique\_identifier

**Step 5**

Create unique indexes for GUID identifiers

* [Modify table ejscript](/en/database/tables/ejscript)
  unique\_identifier
* [Modify table screen\_chooser](/en/database/tables/screen-chooser)
  unique\_identifier

**Step 6**

New flag field in screen\_definition: autosave

* [Modify table screen\_definition](/en/database/tables/screen-definition)
  autosave

## CS

* [Modify table ticket](/en/database/tables/ticket)
  from\_address

**Step 3**

* [Modify table s\_message](/en/database/tables/s-message)
  long\_description

**Step 4**

* [Modify table ticket\_status](/en/database/tables/ticket-status)
  status
* [Modify table ticket\_priority](/en/database/tables/ticket-priority)
  status, flags, ticket\_read, changed\_owner, ticket\_newinfo, ticket\_closed, ticket\_changed\_priority, ticket\_new
* [Modify table ej\_category](/en/database/tables/ej-category)
  delegate\_method, closing\_status, msg\_closing\_status, flags

**Step 5**

* [Modify table ticket](/en/database/tables/ticket)
  status, slevel, origin, read\_status
* [Modify table ticket\_status](/en/database/tables/ticket-status)
  status

**Step 6**

* [Modify table ej\_message](/en/database/tables/ej-message)
  slevel, type, message\_category

**Step 7**

Adding a field to ej\_message, allowing the user to filter and view only important messages

* [Modify table ej\_message](/en/database/tables/ej-message)
  important

**Step 8**

Add a ForeignKeyArray field to the ticket table as the first entity to use Tags; and add a contact\_id to start off that project

* [Modify table Ticket](/en/database/tables/ticket)
  tags, contact\_id

**Step 9**

Transfer mobile phone from ticket to person if no phone on person

**Step 10**

Set ticket.contact\_id to be consistent with ticket.cust\_id.contact\_id; and copy the person classifiers (associate\_id, group\_id, business\_idx, category\_idx) from contact to person unless person.contact\_id = 0

**Step 11**

Add flags to s\_list\_element table.

* [Modify table s\_list\_element](/en/database/tables/s-list-element)
  status

**Step 12**

Create new table, attachment\_location, to be able to store attachments in multiple locations

* [Add table attachment\_location](/en/database/tables/attachment-location)
* [Modify table attachment](/en/database/tables/attachment)
  attachment\_location\_id

**Step 13**

Create and enable password rules if they have not been changed from the default

**Step 14**

Add field for storing Mailgun DSN setting for each mailbox

* [Modify table mail\_in\_filter](/en/database/tables/mail-in-filter)
  mailgun\_dsn

**Step 15**

Add sentiment and language values to ticket table. Add index on ej\_message.created\_at

* [Modify table ej\_message](/en/database/tables/ej-message)
* [Modify table ticket](/en/database/tables/ticket)
  language, sentiment, sentimentConfidence

**Step 16**

Move ej\_message.suggestedCategory\_id to the ticket table. Add ticket.orig\_human\_category\_id

* [Modify table ej\_message](/en/database/tables/ej-message)
  suggestedCategory\_id
* [Modify table ticket](/en/database/tables/ticket)
  suggestedCategory\_id, origHumanCategory\_id

**Step 17**

Add details clob to ticket\_log\_action table for JSON logging

* [Modify table ticket\_log\_action](/en/database/tables/ticket-log-action)
  details

**Step 18**

Change type of mail\_in\_filter.server\_type to a defined enum called MailboxType

* [Modify table mail\_in\_filter](/en/database/tables/mail-in-filter)
  server\_type

## customerCenter

Create new table for storing customer center styling and configuration options

* [Add table cust\_config](/en/database/tables/cust-config)

**Step 2**

Prime in default Customer Center Config

## forms

* [Add table form](/en/database/tables/form)
* [Add table form\_submission](/en/database/tables/form-submission)

**Step 2**

* [Modify table form](/en/database/tables/form)
  active, expires, maxSubmits

**Step 3**

* [Modify table form](/en/database/tables/form)
  type

**Step 4**

* [Modify table form](/en/database/tables/form)
  recipe

**Step 5**

* [Modify table form\_submission](/en/database/tables/form-submission)
  is\_submitted

**Step 6**

* [Modify table form\_submission](/en/database/tables/form-submission)
  is\_submitted, status, processing\_log

**Step 7**

* [Modify table form](/en/database/tables/form)
  group\_id

**Step 8**

* [Modify table ticket](/en/database/tables/ticket)
  form\_submission\_id

**Step 9**

* [Modify table form](/en/database/tables/form)
  form\_key

**Step 10**

Create new field to be able to filter out forms that are used to creating tickets

* [Modify table form](/en/database/tables/form)
  new\_ticket

## inbox

* [Add table email\_account](/en/database/tables/email-account)
* [Add table email\_folder](/en/database/tables/email-folder)
* [Add table service\_auth](/en/database/tables/service-auth)
* [Add table email\_item](/en/database/tables/email-item)

**Step 2**

* [Modify table email\_item](/en/database/tables/email-item)

**Step 3**

* [Modify table email\_item](/en/database/tables/email-item)
  replied\_at, in\_reply\_to, messageId
* [Modify table email\_account](/en/database/tables/email-account)
  default

**Step 4**

* [Modify table email\_account](/en/database/tables/email-account)
  account\_status
* [Modify table email\_item](/en/database/tables/email-item)
  cc
* [Modify table service\_auth](/en/database/tables/service-auth)
  associate\_id, auth\_status

**Step 5**

* [Modify table timestamps](/en/database/tables/timestamps)
  mailsync

**Step 6**

* [Modify table email\_account](/en/database/tables/email-account)
  email\_address
* [Modify table email\_folder](/en/database/tables/email-folder)
  account\_id

**Step 7**

* [Modify table email\_account](/en/database/tables/email-account)
  encryptedCheck, associate\_id, incoming\_auth, outgoing\_auth
* [Modify table service\_auth](/en/database/tables/service-auth)
  encryptedCheck, associate\_id, server, port, auth\_type, username, password

**Step 8**

* [Modify table email\_account](/en/database/tables/email-account)
  error\_count, error\_reason
* [Modify table email\_item](/en/database/tables/email-item)
* [Add table email\_attachment](/en/database/tables/email-attachment)

**Step 9**

* [Modify table email\_folder](/en/database/tables/email-folder)
  folder\_separator

**Step 10**

* [Modify table email\_item](/en/database/tables/email-item)
  cal\_data

**Step 11**

Ensure all email-IDs used as foreignkeys in the foreignkey-table are enclosed in tags. Update all rows as needed, in one operation

## invitation

Adds support for invitations (iCal) leading to appointments

* [Add table invitation](/en/database/tables/invitation)
* [Modify table email](/en/database/tables/email)
  appointment\_id

**Step 2**

Allows for storage of the organizer's email and full name in the table; Adds support for recurring invitations.

* [Modify table invitation](/en/database/tables/invitation)
  organizer\_email, organizer\_fullname, recurring\_end\_date

**Step 3**

Set preference "Diary sync active" if Infobridge synchronizer seem to be in use.

**Step 4**

Adds support for modifications of single appointments in a recurring series.

* [Modify table invitation](/en/database/tables/invitation)
  recurring\_start\_date
* [Modify table erpexternalkey](/en/database/tables/erpexternalkey)

**Step 5**

Adds better support for modifications of single appointments in a recurring series.

* [Modify table appointment](/en/database/tables/appointment)
  original\_start\_date

## Mailings

Adding field to store the document mailing recipient sort order

* [Modify table s\_shipment](/en/database/tables/s-shipment)
  sorting

**Step 2**

Add fields for storing the design of a mailing message and mailing design type

* [Modify table s\_message](/en/database/tables/s-message)
  design, designtype
* [Add table s\_messageblock](/en/database/tables/s-messageblock)
* [Modify table s\_message](/en/database/tables/s-message)
  flags

**Step 3**

Remove the old SOEditor mailing templates for new Online installations

**Step 4**

Change type of S\_Shipment.Status to a defined enum called ShipmentStatus and change type of (S\_Link\_Customer/S\_Link\_Customer\_Statical).LinkType to ShipmentLinkType.

* [Modify table s\_shipment](/en/database/tables/s-shipment)
  status
* [Modify table s\_link\_customer](/en/database/tables/s-link-customer)
  link\_type
* [Modify table s\_link\_customer\_statical](/en/database/tables/s-link-customer-statical)
  link\_type

## NewSelection

The typical search table is an owner of a set of predefined selection criteria

**Step 2**

Cleanup after initial (obsolete) table definition

* Remove table TypicalSearch

**Step 3**

Define the TypicalSearch table from scratch

* [Add table TypicalSearch](/en/database/tables/typicalsearch)

**Step 4**

Cleanup 'temporary selection' marking by introducing the IsTemporary field

* [Modify table selection](/en/database/tables/selection)
  SystemType

**Step 5**

Add fields to table selection for more functionality. Also update the default sidepanel view for all pages, in userpreference

* [Modify table selection](/en/database/tables/selection)
  chartKey, lastLoaded, lastLoadedBy, lastMembershipChange, lastMembershipChangeBy

**Step 6**

SelectionForFind creates a dynamic selection for each entity/associate as needed; they were missing the required VisibleFor row; those are added here

**Step 7**

Update targetTableNumber to 5 where it was 0, and reset membercounts to -1 where we have no recent data

**Step 8**

Due to limitations in the Windows code stack, the chartKey field is shortened to 254 characters

* [Modify table selection](/en/database/tables/selection)
  chartKey

## Online

Add table OnlineApp, to echo information about authorizations and usage. Optimize indexes for userpreference table, based on Ops data

* [Add table OnlineApp](/en/database/tables/onlineapp)
* [Modify table userpreference](/en/database/tables/userpreference)
* [Modify table userpreference](/en/database/tables/userpreference)

## Optimization

* [Modify table TravelTransactionLog](/en/database/tables/traveltransactionlog)
* [Modify table ForeignKey](/en/database/tables/foreignkey)

**Step 2**

Deleting obsolete counter-preferences

## Pocket

* [Add table PushNotificationService](/en/database/tables/pushnotificationservice)

**Step 2**

* [Modify table PushNotificationService](/en/database/tables/pushnotificationservice)
  Language

**Step 3**

* [Modify table PushNotificationService](/en/database/tables/pushnotificationservice)
  PocketVersion, OSVersion

**Step 5**

Adding rank field to favourites

* [Modify table Favourite](/en/database/tables/favourite)
  Rank

## R\_Service

Add field for storing flags on a service login session

* [Modify table login](/en/database/tables/login)
  flags

**Step 2**

Change value of registry entry for maximum width of components

**Step 3**

Make sure the row with id=1 in ejuser contains the '(System)' user

## SubscriptionMgmt

* Add table MailingType
* Add table MailingTypeReservation
* [Modify table s\_shipment](/en/database/tables/s-shipment)
  mailingtype\_id

**Step 3**

* [Add table TemporaryKey](/en/database/tables/temporarykey)

**Step 5**

* Modify table MailingTypeReservation
  MailingType\_id
* [Modify table s\_shipment](/en/database/tables/s-shipment)
  mailingtype\_id
* Rename table MailingType to ShipmentType
* [Modify table ShipmentType](/en/database/tables/shipmenttype)
  MailingType\_id
* Rename table MailingTypeReservation to ShipmentTypeReservation
* [Modify table ShipmentTypeReservation](/en/database/tables/shipmenttypereservation)
  MailingTypeReservation\_id, MailingType\_id
* [Modify table s\_shipment](/en/database/tables/s-shipment)
  mailingtype\_id

**Step 6**

* [Modify table ShipmentTypeReservation](/en/database/tables/shipmenttypereservation)

## SuperId

* [Modify table associate](/en/database/tables/associate)
  waiting\_for\_approval

**Step 2**

* [Modify table associate](/en/database/tables/associate)
  waiting\_for\_approval

**Step 3**

* [Modify table associate](/en/database/tables/associate)
  waiting\_for\_approval

## Webhooks

The **Webhook** table keeps track of the **Target\_URL** where we will dispatch HTTP POST notificationsof events that happen in SuperOffice. The webhook state should be ACTIVE(1). If too many errors are received when we try to POST to the TargetUrl, then the webhook state is changed to TOO-MANY-ERRORS(3).

* [Add table Webhook](/en/database/tables/webhook)


## Related topics

- [Released database changes in version 11.2.664.0](/release-notes/database/changes-11.2.664.md)
- [What's new in SuperOffice](/release-notes/index.md)
- [API changes](/release-notes/12/api/index.md)
- [Tested browser versions](/en/onsite/compatibility/browser.md)
- [Change tracking](/en/online/mirroring/change-tracking.md)
- [What's new in version 11.7.727.0](/release-notes/database/changes-11.7.727.md)