function history_update_8101 in Drupal 8

Change {history}.nid to an unsigned int in order to match {node}.nid.

File

core/modules/history/history.install, line 49

Installation functions for History module.

Code

function history_update_8101() {
  $schema = Database::getConnection()
    ->schema();
  $schema
    ->dropPrimaryKey('history');
  $schema
    ->dropIndex('history', 'nid');
  $schema
    ->changeField('history', 'nid', 'nid', [
    'description' => 'The {node}.nid that was read.',
    'type' => 'int',
    'unsigned' => TRUE,
    'not null' => TRUE,
    'default' => 0,
  ]);
  $schema
    ->addPrimaryKey('history', [
    'uid',
    'nid',
  ]);
  $spec = [
    'description' => 'A record of which {users} have read which {node}s.',
    'fields' => [
      'uid' => [
        'description' => 'The {users}.uid that read the {node} nid.',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ],
      'nid' => [
        'description' => 'The {node}.nid that was read.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ],
      'timestamp' => [
        'description' => 'The Unix timestamp at which the read occurred.',
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
      ],
    ],
    'primary key' => [
      'uid',
      'nid',
    ],
    'indexes' => [
      'nid' => [
        'nid',
      ],
    ],
  ];
  $schema
    ->addIndex('history', 'nid', [
    'nid',
  ], $spec);
}