mediamosa_integrity_check_schema

Versions

mediamosa-21

mediamosa_integrity_check_schema()

Implements hook_schema().

Code

sites/all/modules/mediamosa/modules/integrity_check/mediamosa_integrity_check.install, line 56

<?php
function mediamosa_integrity_check_schema() {
  $schema[mediamosa_integrity_check_db::TABLE_NAME] = array(
    'description' => t('The integrity check table.'),
    'fields' => array(
      mediamosa_integrity_check_db::ID => array(
        'type' => 'serial',
        'not null' => TRUE,
        'unsigned' => TRUE,
        'description' => t('Primary Key: Unique ID.'),
      ),
      mediamosa_integrity_check_db::TYPE => array(
        'description' => t('The type of the integrity check problem.'),
        'type' => "enum('" . implode("','", array(mediamosa_integrity_check_db::TYPE_ERROR, mediamosa_integrity_check_db::TYPE_MISSING_MEDIAFILE, mediamosa_integrity_check_db::TYPE_MISSING_MEDIARECORD, mediamosa_integrity_check_db::TYPE_MISSING_STILLFILE, mediamosa_integrity_check_db::TYPE_MISSING_STILLRECORD)) . "')",
        'not null' => TRUE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_integrity_check_db::TYPE_ERROR, mediamosa_integrity_check_db::TYPE_MISSING_MEDIAFILE, mediamosa_integrity_check_db::TYPE_MISSING_MEDIARECORD, mediamosa_integrity_check_db::TYPE_MISSING_STILLFILE, mediamosa_integrity_check_db::TYPE_MISSING_STILLRECORD)) . "')",
      ),
      mediamosa_integrity_check_db::OBJECT_ID => array(
        'type' => 'varchar',
        'length' => mediamosa_integrity_check_db::OBJECT_ID_LENGTH,
        'not null' => TRUE,
        'description' => t('The ojbect ID.'),
      ),
      mediamosa_integrity_check_db::APP_ID => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'description' => t('The application ID.'),
      ),
      mediamosa_integrity_check_db::OWNER_ID => array(
        'type' => 'varchar',
        'length' => mediamosa_integrity_check_db::OWNER_ID_LENGTH,
        'not null' => FALSE,
        'description' => t('The owner ID.'),
      ),
      mediamosa_integrity_check_db::CREATED => array(
        'type' => 'datetime',
        'not null' => TRUE,
        'description' => t('The date and time when integrity check was created.'),
      ),
      mediamosa_integrity_check_db::CHANGED => array(
        'type' => 'datetime',
        'default' => NULL,
        'description' => t('The date and time when integrity was changed last.'),
      ),
      mediamosa_integrity_check_db::SIZE => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'description' => t('The file size.'),
      ),
      mediamosa_integrity_check_db::MTIME => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'description' => t('The file modify time.'),
      ),
      mediamosa_integrity_check_db::CTIME => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'description' => t('The file change time.'),
      ),
      mediamosa_integrity_check_db::DETAILS => array(
        'type' => 'varchar',
        'length' => mediamosa_integrity_check_db::DETAILS_LENGTH,
        'not null' => FALSE,
        'description' => t('The details of the integrity check.'),
      ),
    ),
    'primary key' => array(mediamosa_integrity_check_db::ID),
    'indexes' => array(
      'idx_object_id' => array(mediamosa_integrity_check_db::OBJECT_ID),
      'idx_app_id' => array(mediamosa_integrity_check_db::APP_ID),
      'idx_owner_id' => array(mediamosa_integrity_check_db::OWNER_ID),
      'idx_size' => array(mediamosa_integrity_check_db::SIZE),
    ),
  );

  return $schema;
}
?>