mediamosa_asset_metadata_schema

Versions

mediamosa-21

mediamosa_asset_metadata_schema()

Implements hook_schema().

Code

sites/all/modules/mediamosa/core/asset/metadata/mediamosa_asset_metadata.install.inc, line 61

<?php
function mediamosa_asset_metadata_schema() {

  $a_schema[mediamosa_asset_metadata_db::TABLE_NAME] = array(
  'description' => t('The asset metadata table.'),
    'fields' => array(
      mediamosa_asset_metadata_db::ID => array(
        'type' => 'serial',
        'not null' => TRUE,
        'description' => t('Primary Key: Unique ID.'),
      ),
      mediamosa_asset_metadata_db::ASSET_ID => array(
        'type' => 'varchar',
        'length' => mediamosa_db::HASH_ID_LENGTH,
        'not null' => TRUE,
        'description' => t('The asset ID.'),
      ),
      mediamosa_asset_metadata_db::PROP_ID => array(
        'type' => 'int',
        'not null' => TRUE,
        'description' => t('The property ID of the metadata.'),
        'unsigned' => TRUE,
      ),
      mediamosa_asset_metadata_db::VAL_CHAR => array(
        'type' => 'text',
        'size' => 'big',
        'description' => t('The value of the property stored as an string.'),
      ),
      mediamosa_asset_metadata_db::VAL_CHAR_LFT => array(
        'type' => 'varchar',
        'length' => mediamosa_asset_metadata_db::VAL_CHAR_LFT_LENGTH,
        'description' => t('The first 50 string characters of the property value.'),
      ),
      mediamosa_asset_metadata_db::VAL_CHAR_RGHT => array(
        'type' => 'varchar',
        'length' => mediamosa_asset_metadata_db::VAL_CHAR_RGHT_LENGTH,
        'description' => t('The last 50 string characters of the property value in reverse order.'),
      ),
      mediamosa_asset_metadata_db::VAL_DATETIME => array(
        'type' => 'datetime',
        'description' => t('The date and time of the property value.'),
      ),
      mediamosa_asset_metadata_db::VAL_INT => array(
        'type' => 'int',
        'not null' => TRUE,
        'description' => t('The numeric value of the property.'),
        'default' => 0,
      ),
      mediamosa_asset_metadata_db::CREATED => array(
        'type' => 'datetime',
        'not null' => TRUE,
        'description' => t('The date and time when asset metadata was created.'),
      ),
      mediamosa_asset_metadata_db::CHANGED => array(
        'type' => 'datetime',
        'default' => NULL,
        'description' => t('The date and time when asset metadata was changed.'),
      ),
    ),
    'primary key' => array(mediamosa_asset_metadata_db::ID),
    'indexes' => array(
      'idx_assetid_propid_valcharlft' => array(mediamosa_asset_metadata_db::ASSET_ID, mediamosa_asset_metadata_db::PROP_ID, mediamosa_asset_metadata_db::VAL_CHAR_LFT),
      'idx_assetid_propid_valcharrght' => array(mediamosa_asset_metadata_db::ASSET_ID, mediamosa_asset_metadata_db::PROP_ID, mediamosa_asset_metadata_db::VAL_CHAR_RGHT),
    ),
    'foreign keys' => array(
      mediamosa_asset_metadata_db::ASSET_ID => array(mediamosa_asset_db::TABLE_NAME => mediamosa_asset_db::ID),
      mediamosa_asset_metadata_db::PROP_ID => array(mediamosa_asset_metadata_property_db::TABLE_NAME => mediamosa_asset_metadata_property_db::ID),
    ),
  );

  return $a_schema;
}
?>