workspaces.php

<?php

// phpcs:ignoreFile
use Drupal\Core\Database\Database;
use Drupal\Core\Entity\EntityTypeInterface;
$connection = Database::getConnection();
// Set the schema version.
$connection->merge('key_value')
    ->fields([
    'value' => 'i:10000;',
    'name' => 'workspaces',
    'collection' => 'system.schema',
])
    ->condition('collection', 'system.schema')
    ->condition('name', 'workspaces')
    ->execute();
// Update core.extension.
$extensions = $connection->select('config')
    ->fields('config', [
    'data',
])
    ->condition('collection', '')
    ->condition('name', 'core.extension')
    ->execute()
    ->fetchField();
$extensions = unserialize($extensions);
$extensions['module']['workspaces'] = 0;
$connection->update('config')
    ->fields([
    'data' => serialize($extensions),
])
    ->condition('collection', '')
    ->condition('name', 'core.extension')
    ->execute();
// Add all workspaces_removed_post_updates() as existing updates.
require_once __DIR__ . '/../../../../workspaces/workspaces.post_update.php';
$existing_updates = $connection->select('key_value')
    ->fields('key_value', [
    'value',
])
    ->condition('collection', 'post_update')
    ->condition('name', 'existing_updates')
    ->execute()
    ->fetchField();
$existing_updates = unserialize($existing_updates);
$existing_updates = array_merge($existing_updates, array_keys(workspaces_removed_post_updates()));
$connection->update('key_value')
    ->fields([
    'value' => serialize($existing_updates),
])
    ->condition('collection', 'post_update')
    ->condition('name', 'existing_updates')
    ->execute();
// Create the 'workspace_association' table.
$spec = [
    'description' => 'Stores the association between entity revisions and their workspace.',
    'fields' => [
        'workspace' => [
            'type' => 'varchar_ascii',
            'length' => 128,
            'not null' => TRUE,
            'default' => '',
            'description' => 'The workspace ID.',
        ],
        'target_entity_type_id' => [
            'type' => 'varchar_ascii',
            'length' => EntityTypeInterface::ID_MAX_LENGTH,
            'not null' => TRUE,
            'default' => '',
            'description' => 'The ID of the associated entity type.',
        ],
        'target_entity_id' => [
            'type' => 'int',
            'unsigned' => TRUE,
            'not null' => TRUE,
            'description' => 'The ID of the associated entity.',
        ],
        'target_entity_revision_id' => [
            'type' => 'int',
            'unsigned' => TRUE,
            'not null' => TRUE,
            'description' => 'The revision ID of the associated entity.',
        ],
    ],
    'indexes' => [
        'target_entity_revision_id' => [
            'target_entity_revision_id',
        ],
    ],
    'primary key' => [
        'workspace',
        'target_entity_type_id',
        'target_entity_id',
    ],
];
$connection->schema()
    ->createTable('workspace_association', $spec);