function help_update_10200

Install search index table for help topics.

File

core/modules/help/help.install, line 56

Code

function help_update_10200(&$sandbox = NULL) {
    $connection = \Drupal::database();
    if (!$connection->schema()
        ->tableExists('help_search_items')) {
        $table = [
            'description' => 'Stores information about indexed help search items',
            'fields' => [
                'sid' => [
                    'description' => 'Numeric index of this item in the search index',
                    'type' => 'serial',
                    'unsigned' => TRUE,
                    'not null' => TRUE,
                ],
                'section_plugin_id' => [
                    'description' => 'The help section the item comes from',
                    'type' => 'varchar_ascii',
                    'length' => 255,
                    'not null' => TRUE,
                    'default' => '',
                ],
                'permission' => [
                    'description' => 'The permission needed to view this item',
                    'type' => 'varchar_ascii',
                    'length' => 255,
                    'not null' => TRUE,
                    'default' => '',
                ],
                'topic_id' => [
                    'description' => 'The topic ID of the item',
                    'type' => 'varchar_ascii',
                    'length' => 255,
                    'not null' => TRUE,
                    'default' => '',
                ],
            ],
            'primary key' => [
                'sid',
            ],
            'indexes' => [
                'section_plugin_id' => [
                    'section_plugin_id',
                ],
                'topic_id' => [
                    'topic_id',
                ],
            ],
        ];
        $connection->schema()
            ->createTable('help_search_items', $table);
    }
}