mediamosa_collection_schema

Versions

mediamosa-21

mediamosa_collection_schema()

Implements hook_schema().

Code

sites/all/modules/mediamosa/core/collection/mediamosa_collection.install.inc, line 53

<?php
function mediamosa_collection_schema() {

  $a_schema[mediamosa_collection_db::TABLE_NAME] = array(
  'description' => t('The collection table.'),
    'fields' => array(
      mediamosa_collection_db::ID => array(
        'type' => 'varchar',
        'length' => mediamosa_db::HASH_ID_LENGTH,
        'not null' => TRUE,
        'description' => t('Primary Key: Unique ID.'),
      ),
      mediamosa_collection_db::TITLE => array(
        'type' => 'varchar',
        'length' => mediamosa_collection_db::TITLE_LENGTH,
        'default' => NULL,
        'description' => t('The collection title.'),
      ),
      mediamosa_collection_db::DESCRIPTION => array(
        'type' => 'varchar',
        'length' => mediamosa_collection_db::DESCRIPTION_LENGTH,
        'default' => NULL,
        'description' => t('The collection description.'),
      ),
      mediamosa_collection_db::APP_ID => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => t('The application ID of the asset.'),
      ),
      mediamosa_collection_db::OWNER_ID => array(
        'type' => 'varchar',
        'length' => mediamosa_collection_db::OWNER_ID_LENGTH,
        'default' => NULL,
        'description' => t('The owner ID.'),
      ),
      mediamosa_collection_db::GROUP_ID => array(
        'type' => 'varchar',
        'length' => mediamosa_collection_db::GROUP_ID_LENGTH,
        'default' => NULL,
        'description' => t('The group ID.'),
      ),
      mediamosa_collection_db::ISPRIVATE => array(
        'description' => t('The collection is private.'),
        'type' => "enum('" . implode("','", array(mediamosa_collection_db::ISPRIVATE_FALSE, mediamosa_collection_db::ISPRIVATE_TRUE)) . "')",
        'not null' => TRUE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_collection_db::ISPRIVATE_FALSE, mediamosa_collection_db::ISPRIVATE_TRUE)) . "')",
        'default' => mediamosa_collection_db::ISPRIVATE_FALSE,
      ),
      mediamosa_collection_db::PRIVATE_ => array(
        'description' => t('The collection is private.'),
        'type' => "enum('" . implode("','", array(mediamosa_collection_db::PRIVATE_FALSE, mediamosa_collection_db::PRIVATE_TRUE)) . "')",
        'not null' => TRUE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_collection_db::PRIVATE_FALSE, mediamosa_collection_db::PRIVATE_TRUE)) . "')",
        'default' => mediamosa_collection_db::PRIVATE_FALSE,
      ),
      mediamosa_collection_db::_PUBLIC => array(
        'description' => t('The collection is public.'),
        'type' => "enum('" . implode("','", array(mediamosa_collection_db::PUBLIC_FALSE, mediamosa_collection_db::PUBLIC_TRUE)) . "')",
        'not null' => TRUE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_collection_db::PUBLIC_FALSE, mediamosa_collection_db::PUBLIC_TRUE)) . "')",
        'default' => mediamosa_collection_db::PUBLIC_TRUE,
      ),
      mediamosa_collection_db::CATEGORY => array(
        'description' => t('The collection\'s category.'),
        'type' => "enum('" . implode("','", array(mediamosa_collection_db::CATEGORY_FALSE, mediamosa_collection_db::CATEGORY_TRUE)) . "')",
        'not null' => TRUE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_collection_db::CATEGORY_FALSE, mediamosa_collection_db::CATEGORY_TRUE)) . "')",
        'default' => mediamosa_collection_db::CATEGORY_FALSE,
      ),
      mediamosa_collection_db::CREATED => array(
        'type' => 'datetime',
        'not null' => TRUE,
        'description' => t('The date and time when asset was created.'),
      ),
      mediamosa_collection_db::CHANGED => array(
        'type' => 'datetime',
        'default' => NULL,
        'description' => t('The date and time when asset was changed last.'),
      ),
      mediamosa_collection_db::IS_UNAPPROPRIATE => array(
        'description' => t('If the collection has unappropieate contents.'),
        'type' => "enum('" . implode("','", array(mediamosa_collection_db::IS_UNAPPROPRIATE_FALSE, mediamosa_collection_db::IS_UNAPPROPRIATE_TRUE)) . "')",
        'not null' => TRUE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_collection_db::IS_UNAPPROPRIATE_FALSE, mediamosa_collection_db::IS_UNAPPROPRIATE_TRUE)) . "')",
        'default' => mediamosa_collection_db::IS_UNAPPROPRIATE_FALSE,
      ),
      mediamosa_collection_db::PUBLIC_ASSIGN => array(
        'description' => t('If the collection public assigned.'),
        'type' => "enum('" . implode("','", array(mediamosa_collection_db::PUBLIC_ASSIGN_FALSE, mediamosa_collection_db::PUBLIC_ASSIGN_TRUE)) . "')",
        'not null' => TRUE,
        'mysql_type' => "enum('" . implode("','", array(mediamosa_collection_db::PUBLIC_ASSIGN_FALSE, mediamosa_collection_db::PUBLIC_ASSIGN_TRUE)) . "')",
        'default' => mediamosa_collection_db::PUBLIC_ASSIGN_FALSE,
      ),
    ),
    'primary key' => array(mediamosa_collection_db::ID),
    'indexes' => array(
      'idx_' . mediamosa_collection_db::TITLE => array(mediamosa_collection_db::TITLE),
      'idx_' . mediamosa_collection_db::APP_ID => array(mediamosa_collection_db::APP_ID),
      'idx_' . mediamosa_collection_db::OWNER_ID => array(mediamosa_collection_db::OWNER_ID),
      'idx_' . mediamosa_collection_db::GROUP_ID => array(mediamosa_collection_db::GROUP_ID),
      'idx_' . mediamosa_collection_db::CREATED => array(mediamosa_collection_db::CREATED),
      'idx_' . mediamosa_collection_db::CHANGED => array(mediamosa_collection_db::CHANGED),
      'idx_' . mediamosa_collection_db::IS_UNAPPROPRIATE => array(mediamosa_collection_db::IS_UNAPPROPRIATE),
    ),
  );

  return $a_schema;
}
?>