mediamosa_asset_supplement_schema

Versions

mediamosa-21

mediamosa_asset_supplement_schema()

Implements hook_schema().

Code

sites/all/modules/mediamosa/core/asset/supplement/mediamosa_asset_supplement.install.inc, line 51

<?php
function mediamosa_asset_supplement_schema() {

  $a_schema[mediamosa_asset_supplement_db::TABLE_NAME] = array(
  'description' => t('The asset supplement table.'),
    'fields' => array(
      mediamosa_asset_supplement_db::ID => array(
        'type' => 'varchar',
        'length' => mediamosa_db::HASH_ID_LENGTH,
        'not null' => TRUE,
        'description' => t('Primary Key: Unique ID.'),
      ),
      mediamosa_asset_supplement_db::ASSET_ID => array(
        'type' => 'varchar',
        'length' => mediamosa_db::HASH_ID_LENGTH,
        'not null' => TRUE,
        'description' => t('Primary Key: Unique ID.'),
      ),
      mediamosa_asset_supplement_db::SUPPLEMENT => array(
        'type' => 'blob',
        'description' => t('Contens of the supplement.'),
      ),
      mediamosa_asset_supplement_db::TAG => array(
        'type' => 'varchar',
        'length' => mediamosa_asset_supplement_db::TAG_LENGTH,
        'description' => t('Tag for fast search and lookup.'),
      ),
      mediamosa_asset_supplement_db::OAI_PREFIX => array(
        'type' => 'varchar',
        'length' => mediamosa_asset_supplement_db::OAI_PREFIX_LENGTH,
        'description' => t('OAI Prefix.'),
      ),
      mediamosa_asset_supplement_db::OAI_NAMESPACEURI => array(
        'type' => 'varchar',
        'length' => mediamosa_asset_supplement_db::OAI_NAMESPACEURI_LENGTH,
        'description' => t('OAI namespace URI.'),
      ),
      mediamosa_asset_supplement_db::OAI_SCHEMALOCATION => array(
        'type' => 'varchar',
        'length' => mediamosa_asset_supplement_db::OAI_SCHEMALOCATION_LENGTH,
        'description' => t('OAI Schema location.'),
      ),
      mediamosa_asset_supplement_db::CREATED => array(
        'type' => 'datetime',
        'not null' => TRUE,
        'description' => t('The date and time when supplement was created.'),
      ),
      mediamosa_asset_supplement_db::CHANGED => array(
        'type' => 'datetime',
        'default' => NULL,
        'description' => t('The date and time when supplement was changed last.'),
      ),
    ),
    'primary key' => array(mediamosa_asset_supplement_db::ID),
    'indexes' => array(
      'idx_' . mediamosa_asset_supplement_db::TAG => array(mediamosa_asset_supplement_db::TAG),
    ),
    'foreign keys' => array(
      mediamosa_asset_supplement_db::ASSET_ID => array(mediamosa_asset_db::TABLE_NAME => mediamosa_asset_db::ID),
    ),
  );

  return $a_schema;
}
?>