mediamosa_aut_object_schema

Versions

mediamosa-21

mediamosa_aut_object_schema()

Implements hook_schema().

Code

sites/all/modules/mediamosa/core/aut/object/mediamosa_aut_object.install.inc, line 52

<?php
function mediamosa_aut_object_schema() {
  $a_schema[mediamosa_aut_object_db::TABLE_NAME] = array(
    'description' => t('This table stores authorization links between named/group entities to objects.'),
    'fields' => array(
      mediamosa_aut_object_db::AUT_OBJECT_ID => array(
        'type' => 'varchar',
        'length' => mediamosa_aut_object_db::AUT_OBJECT_ID_LENGTH,
        'not null' => TRUE,
        'default' => '',
        'description' => t('The object ID, links to mediamosa_asset_mediafile, mediamosa_asset or mediamosa_collection.'),
      ),
      mediamosa_aut_object_db::AUT_OBJECT_TYPE => array(
        'type' => "enum('" . implode("','", array(mediamosa_aut_object_db::AUT_OBJECT_TYPE_MEDIAFILE, mediamosa_aut_object_db::AUT_OBJECT_TYPE_ASSET, mediamosa_aut_object_db::AUT_OBJECT_TYPE_COLLECTION)) . "')",
        'not null' => FALSE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_aut_object_db::AUT_OBJECT_TYPE_MEDIAFILE, mediamosa_aut_object_db::AUT_OBJECT_TYPE_ASSET, mediamosa_aut_object_db::AUT_OBJECT_TYPE_COLLECTION)) . "')",
        'default' => mediamosa_aut_object_db::AUT_OBJECT_TYPE_MEDIAFILE,
        'description' => t('The type of object, links to mediamosa_asset_mediafile, mediamosa_asset or mediamosa_collection.'),
      ),
      mediamosa_aut_object_db::AUT_ID => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => t('The entity ID, links to aut_name or aut_group.'),
      ),
      mediamosa_aut_object_db::AUT_TYPE => array(
        'type' => "enum('" . implode("','", array(mediamosa_aut_object_db::AUT_TYPE_NAME, mediamosa_aut_object_db::AUT_TYPE_GROUP)) . "')",
        'not null' => FALSE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_aut_object_db::AUT_TYPE_NAME, mediamosa_aut_object_db::AUT_TYPE_GROUP)) . "')",
        'default' => NULL,
        'description' => t('The type of entity, links to aut_name or aut_group.'),
      ),
    ),
    'unique keys' => array(
      'uni_link_to_obj' => array(mediamosa_aut_object_db::AUT_OBJECT_TYPE, mediamosa_aut_object_db::AUT_OBJECT_ID, mediamosa_aut_object_db::AUT_TYPE, mediamosa_aut_object_db::AUT_ID),
    ),
    'indexes' => array(
      'idx_type_id' => array(mediamosa_aut_object_db::AUT_TYPE, mediamosa_aut_object_db::AUT_ID),
      'idx_objid' => array(mediamosa_aut_object_db::AUT_OBJECT_ID)
    ),
  );

  return $a_schema;
}
?>