mediamosa_ftp_batch_schema

Versions

mediamosa-21

mediamosa_ftp_batch_schema()

Implements hook_schema().

Code

sites/all/modules/mediamosa/core/ftp_batch/mediamosa_ftp_batch.install.inc, line 59

<?php
function mediamosa_ftp_batch_schema() {
  $a_schema[mediamosa_ftp_batch_db::TABLE_NAME] = array(
    'description' => t('This FTP Batch table.'),
    'fields' => array(
      mediamosa_ftp_batch_db::ID => array(
        'type' => 'serial',
        'not null' => TRUE,
        'description' => t('Primary key.'),
      ),
      mediamosa_ftp_batch_db::APP_ID => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => t('The application ID.'),
      ),
      mediamosa_ftp_batch_db::OWNER_ID => array(
        'description' => t('The owner of the batch.'),
        'type' => 'varchar',
        'length' => mediamosa_ftp_batch_db::OWNER_ID_LENGTH,
        'not null' => FALSE,
      ),
      mediamosa_ftp_batch_db::GROUP_ID => array(
        'description' => t('The group owner of the batch.'),
        'type' => 'varchar',
        'length' => mediamosa_ftp_batch_db::GROUP_ID_LENGTH,
        'not null' => FALSE,
      ),
      mediamosa_ftp_batch_db::VUF => array(
        'description' => t('The VUF file location.'),
        'type' => 'varchar',
        'length' => mediamosa_ftp_batch_db::VUF_LENGTH,
        'not null' => TRUE,
      ),
      mediamosa_ftp_batch_db::STARTED => array(
        'type' => 'datetime',
        'not null' => FALSE,
        'description' => t('The started datatime of batch.'),
      ),
      mediamosa_ftp_batch_db::FINISHED => array(
        'type' => 'datetime',
        'not null' => FALSE,
        'description' => t('The finished datatime of batch.'),
      ),
      mediamosa_ftp_batch_db::EMAIL_ADDRESS => array(
        'description' => t('The email address of creator.'),
        'type' => 'varchar',
        'length' => mediamosa_ftp_batch_db::EMAIL_ADDRESS_LENGTH,
        'not null' => FALSE,
      ),
      mediamosa_ftp_batch_db::EMAIL_CONTENTS => array(
        'description' => t('The email address of creator.'),
        'type' => 'text',
        'not null' => FALSE,
      ),
    ),
    'primary key' => array(mediamosa_ftp_batch_db::ID),
  );

  return $a_schema;
}
?>