client_applications_schema

Versions

mediamosa-174

client_applications_schema()

Implementation of hook_schema().

Return value

array Nested array with a database creation schema

Code

client_applications/client_applications.install, line 167

<?php
function client_applications_schema() {
  $schema = array();

  $schema['client_applications'] = array(
    'description' => t('TODO: please describe this table!'),
    'fields' => array(
      'caid' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'serial',
        'not null' => TRUE,
        'disp-width' => '11',
      ),
      'version' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'disp-width' => '11',
      ),
      'name' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '30',
        'not null' => TRUE,
      ),
      'id' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'not null' => TRUE,
        'disp-width' => '20',
      ),
      'transcoding_position_from' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
        'default' => 0,
        'disp-width' => '3',
      ),
      'transcoding_position_to' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
        'disp-width' => '4',
      ),
      'stable_testing' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '10',
        'not null' => TRUE,
      ),
      'quota' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'not null' => TRUE,
        'disp-width' => '10',
      ),
      'quota_used' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'size' => 'big',
        'not null' => TRUE,
        'disp-width' => '20',
      ),
      'shared_key' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '100',
        'not null' => FALSE,
      ),
      'active' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
        'default' => 0,
        'disp-width' => '1',
      ),
      'description' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
      ),
      'owner' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '50',
        'not null' => FALSE,
      ),
      'technical_name' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '100',
        'not null' => FALSE,
      ),
      'technical_phone' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '40',
        'not null' => FALSE,
      ),
      'technical_email' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '50',
        'not null' => FALSE,
      ),
      'administrative_name' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '100',
        'not null' => FALSE,
      ),
      'administrative_phone' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '40',
        'not null' => FALSE,
      ),
      'administrative_email' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '50',
        'not null' => FALSE,
      ),
      'play_proxy_url' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
      ),
      'view_asset_url' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
      ),
      'preview_profile_id' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'not null' => FALSE,
        'disp-width' => '11',
      ),
      'download_url' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
      ),
      'stream_url' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
      ),
      'still_url' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
      ),

      'active_version' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '25',
        'not null' => TRUE,
      ),

      'allow_masterslave' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
        'default' => 0,
      ),
    ),

    'primary key' => array('caid'),
    'unique keys' => array(
      'id' => array('id')
    ),
  );

  $schema['webservice_management_capp'] = array(
    'description' => t('TODO: please describe this table!'),
    'fields' => array(
      'wmcaid' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'disp-width' => '11',
      ),
      'webservice_management_handle' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'varchar',
        'length' => '50',
        'not null' => TRUE,
      ),
      'caid' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'disp-width' => '11',
      ),
/*
      // Enum is not supported in schema
      'status' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'enum',
        'not null' => TRUE,
      ),
 */
    ),
    'primary key' => array('wmcaid'),
  );

  return $schema;
}
?>