123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990 |
- <?php
- /**
- * @file
- * Installation functions for History module.
- */
- use Drupal\Core\Database\Database;
- /**
- * Implements hook_schema().
- */
- function history_schema() {
- $schema['history'] = [
- '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'],
- ],
- ];
- return $schema;
- }
- /**
- * Change {history}.nid to an unsigned int in order to match {node}.nid.
- */
- 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);
- }
|