<?php

/**
 * @file
 * Install, update and uninstall functions for the hello module.
 */

use Drupal\Core\Database\Database;

/**
 * Implements hook_schema().
 */
function hello_schema() {
  $schema['hello_node_history'] = [
    'description' => 'Stores node update history.',
    'fields' => [
      'hid' => [
        'description' => 'Primary Key: Unique history ID.',
        'type'        => 'serial',
        'unsigned'    => TRUE,
        'not null'    => TRUE,
      ],
      'nid' => [
        'description' => 'Node ID.',
        'type'        => 'int',
        'unsigned'    => TRUE,
        'not null'    => TRUE,
      ],
      'uid' => [
        'description' => 'Node ID.',
        'type'        => 'int',
        'unsigned'    => TRUE,
        'not null'    => TRUE,
      ],
      'update_time' => [
        'description' => 'Timestamp of node update.',
        'type'        => 'int',
        'unsigned'    => TRUE,
        'not null'    => TRUE,
      ],
    ],
    'primary key' => ['hid'],
    'indexes' => ['nid' => ['nid']],
  ];

  return $schema;
}

/**
 * Implements hook_update_N().
 */
/**
 * Add a 'uid' field to the hello_node_history table.
 */
function hello_update_8100() {
  $field_spec = [
    'type'        => 'int',
    'description' => "Store user ID.",
    'unsigned'    => TRUE,
    'not null'    => TRUE,
  ];
  $schema = Database::getConnection()->schema();
  $schema->addField('hello_node_history', 'uid', $field_spec);
}