WSOD error - Unable to uninstall due to SQL Integrity Constraint Violation

Hi everyone, I would suggest the following hook to update your database

** you should replace N by 8002, 9002
** after adding ->setRevisionable(TRUE), old users must re-install the module :/ which is not good (data loss). We should't add a hook to update table for old users

function translatable_menu_link_uri_update_N() {
  $database = \Drupal::database();

  $columns_schema = [
    'link_override__uri' => [
      'type' => 'varchar',
      'length' => 2048,
      'not null' => FALSE,
      'description' => 'The URI of the link.',
    ],
    'link_override__title' => [
      'type' => 'varchar',
      'length' => 255,
      'not null' => FALSE,
      'description' => 'The link text.',
    ],
    'link_override__options' => [
      'type' => 'blob',
      'not null' => FALSE,
      'size' => 'big',
      'description' => 'Serialized array of options for the link.',
    ],
  ];

  foreach ($columns_schema as $field_name => $column_schema) {
    // Create fields if they don't already exist.
    if (!$database->schema()->fieldExists('menu_link_content_field_revision', $field_name)) {
      $database->schema()
        ->addField('menu_link_content_field_revision', $field_name, $column_schema);
    }
  }
}