email_changelog-8.x-1.0-alpha1/email_changelog.install

<?php

/**
 * @file
 * Install file for Email Changelog.
 */

/**
 * Implements hook_schema().
 */
function email_changelog_schema() {
  $schema['email_changelog'] = [
    'description' => 'Stores log of all email changes.',
    'fields' => [
      'id' => [
        'description' => 'ID of the history entry.',
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ],
      'uid' => [
        'description' => 'User ID of account which is changed.',
        'type' => 'int',
        'unsigned' => 1,
        'not null' => TRUE,
      ],
      'old_email_address' => [
        'description' => 'Previous Email Address.',
        'type' => 'varchar',
        'length' => 254,
        'not null' => TRUE,
      ],
      'new_email_address' => [
        'description' => 'New Email Address.',
        'type' => 'varchar',
        'length' => 254,
        'not null' => TRUE,
      ],
      'data' => [
        'type' => 'blob',
        'not null' => TRUE,
        'size' => 'big',
        'description' => 'Url of the page/form where email change was performed and other info.',
      ],
      'location' => [
        'type' => 'text',
        'not null' => TRUE,
        'description' => 'URL of the origin of the event.',
      ],
      'logged_in_uid' => [
        'description' => 'User ID of user who changed email.',
        'type' => 'int',
        'unsigned' => 1,
        'not null' => TRUE,
      ],
      'timestamp' => [
        'description' => 'Time action performed.',
        'type' => 'int',
        'not null' => TRUE,
      ],
    ],
    'indexes' => [
      'uid' => array('uid'),
      'logged_in_uid' => array('logged_in_uid'),
    ],
    'primary key' => ['id'],
  ];

  return $schema;
}