mediamosa_asset_delete_schema

Versions

mediamosa-21

mediamosa_asset_delete_schema()

Implements hook_schema().

Code

sites/all/modules/mediamosa/core/asset/delete/mediamosa_asset_delete.install.inc, line 53

<?php
function mediamosa_asset_delete_schema() {

  $a_schema[mediamosa_asset_delete_db::TABLE_NAME] = array(
  'description' => t('The asset collection link table.'),
    'fields' => array(
      mediamosa_asset_delete_db::ID => array(
        'type' => 'varchar',
        'length' => mediamosa_db::HASH_ID_LENGTH,
        'not null' => TRUE,
        'description' => t('Link to asset table.'),
      ),
      mediamosa_asset_delete_db::APP_ID => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => t('The application ID of the asset.'),
      ),
      mediamosa_asset_delete_db::VIDEOTIMESTAMPMODIFIED => array(
        'type' => 'datetime',
        'default' => NULL,
        'description' => t('The modified time and date of the asset.'),
      ),
      mediamosa_asset_delete_db::COLL_ID => array(
        'type' => 'varchar',
        'length' => mediamosa_db::HASH_ID_LENGTH,
        'description' => t('Link to collection table.'),
        'default' => NULL,
      ),
    ),
    'primary key' => array(mediamosa_asset_delete_db::ID),
    'indexes' => array(
      'fk_app_videotimestamp' => array(mediamosa_asset_delete_db::APP_ID, mediamosa_asset_delete_db::VIDEOTIMESTAMPMODIFIED),
    ),
    // Defined as unique and not as primary because drupal will undo the NULL option on coll_id.
    'unique keys' => array(
      'uni_id_collid' => array(mediamosa_asset_delete_db::COLL_ID, mediamosa_asset_delete_db::ID),
    )
  );

  return $a_schema;
}
?>