mediamosa_transcode_profile_schema

Versions

mediamosa-21

mediamosa_transcode_profile_schema()

Implements hook_schema().

Code

sites/all/modules/mediamosa/core/transcode/profile/mediamosa_transcode_profile.install.inc, line 89

<?php
function mediamosa_transcode_profile_schema() {

  $a_schema[mediamosa_transcode_profile_db::TABLE_NAME] = array(
  'description' => t('The transcode profile table.'),
    'fields' => array(
      mediamosa_transcode_profile_db::NID => array(
        'description' => t('The Drupal node id.'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      mediamosa_transcode_profile_db::VID => array(
        'description' => t('The Drupal node revision id.'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      mediamosa_transcode_profile_db::ID => array(
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => t('Primary Key: Unique ID.'),
      ),
      mediamosa_transcode_profile_db::APP_ID => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => t('The application ID.'),
      ),
      mediamosa_transcode_profile_db::VERSION => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'default' => NULL,
        'description' => t('Version profile.'),
      ),
      mediamosa_transcode_profile_db::PROFILE => array(
        'type' => 'varchar',
        'length' => mediamosa_transcode_profile_db::PROFILE_LENGTH,
        'description' => t('Profile data.'),
      ),
      mediamosa_transcode_profile_db::IS_DEFAULT_PROFILE => array(
        'description' => t('The asset is private.'),
        'type' => "enum('" . implode("','", array(mediamosa_transcode_profile_db::IS_DEFAULT_PROFILE_FALSE, mediamosa_transcode_profile_db::IS_DEFAULT_PROFILE_TRUE)) . "')",
        'not null' => TRUE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_transcode_profile_db::IS_DEFAULT_PROFILE_FALSE, mediamosa_transcode_profile_db::IS_DEFAULT_PROFILE_TRUE)) . "')",
        'default' => mediamosa_transcode_profile_db::IS_DEFAULT_PROFILE_FALSE,
      ),
      mediamosa_transcode_profile_db::TOOL => array(
        'type' => 'varchar',
        'length' => mediamosa_transcode_profile_db::TOOL_LENGTH,
        'description' => t('Tool used.'),
      ),
      mediamosa_transcode_profile_db::FILE_EXTENSION => array(
        'type' => 'char',
        'length' => mediamosa_transcode_profile_db::FILE_EXTENSION_LENGTH,
        'description' => t('file extension.'),
      ),
      mediamosa_transcode_profile_db::COMMAND => array(
        'type' => 'text',
        'description' => t('Command.'),
      ),
      mediamosa_transcode_profile_db::CREATED => array(
        'type' => 'datetime',
        'not null' => TRUE,
        'description' => t('The date and time when transcode profile was created.'),
      ),
      mediamosa_transcode_profile_db::CHANGED => array(
        'type' => 'datetime',
        'default' => NULL,
        'description' => t('The date and time when transcode profile was changed last.'),
      ),
    ),
    'primary key' => array(mediamosa_transcode_profile_db::ID),
    'unique keys' => array(
      'uni_appid_profile' => array(mediamosa_transcode_profile_db::APP_ID, mediamosa_transcode_profile_db::PROFILE),
      'uni_nid' => array(mediamosa_transcode_profile_db::NID),
    ),
    'indexes' => array(
      'idx_app_isdefault' => array(mediamosa_transcode_profile_db::APP_ID, mediamosa_transcode_profile_db::IS_DEFAULT_PROFILE),
    ),
  );

  return $a_schema;
}
?>