mediamosa_ftp_user_schema

Versions

mediamosa-21

mediamosa_ftp_user_schema()

Implements hook_schema().

Code

sites/all/modules/mediamosa/core/ftp_user/mediamosa_ftp_user.install.inc, line 52

<?php
function mediamosa_ftp_user_schema() {
  $a_schema[mediamosa_ftp_user_db::TABLE_NAME] = array(
    'description' => t('This FTP User table.'),
    'fields' => array(
      mediamosa_ftp_user_db::ID => array(
        'type' => 'serial',
        'not null' => TRUE,
        'description' => t('Primary key.'),
      ),
      mediamosa_ftp_user_db::APP_ID => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'description' => t('The application ID of the FTP user.'),
      ),
      mediamosa_ftp_user_db::USERID => array(
        'type' => 'varchar',
        'length' => mediamosa_ftp_user_db::USERID_LENGTH,
        'description' => t('The User ID.'),
        'not null' => TRUE,
      ),
      mediamosa_ftp_user_db::PASSWD => array(
        'type' => 'varchar',
        'length' => mediamosa_ftp_user_db::PASSWD_LENGTH,
        'description' => t('The Password.'),
        'not null' => TRUE,
      ),
      mediamosa_ftp_user_db::UID => array(
        'type' => 'int',
        'size' => 'small',
        'not null' => TRUE,
        'description' => t('The linux user ID of the FTP user.'),
        'default' => '200',
      ),
      mediamosa_ftp_user_db::GID => array(
        'type' => 'int',
        'size' => 'small',
        'not null' => TRUE,
        'description' => t('The linux group ID of the FTP user.'),
        'default' => '200',
      ),
      mediamosa_ftp_user_db::HOMEDIR => array(
        'type' => 'varchar',
        'length' => mediamosa_ftp_user_db::HOMEDIR_LENGTH,
        'description' => t('The home directory path.'),
        'not null' => TRUE,
      ),
      mediamosa_ftp_user_db::SHELL => array(
        'type' => 'varchar',
        'length' => mediamosa_ftp_user_db::SHELL_LENGTH,
        'description' => t('The home directory path.'),
        'not null' => TRUE,
        'default' => '/bin/false',
      ),
      mediamosa_ftp_user_db::ACTIVE => array(
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
        'description' => t('Active setting.'),
        'default' => '0',
      ),
      mediamosa_ftp_user_db::COUNT => array(
        'type' => 'int',
        'not null' => TRUE,
        'description' => t('The login count.'),
        'default' => '0',
      ),
      mediamosa_ftp_user_db::ACCESSED => array(
        'type' => 'datetime',
        'description' => t('The access time.'),
      ),
      mediamosa_ftp_user_db::MODIFIED => array(
        'type' => 'datetime',
        'description' => t('The modified time.'),
      ),
    ),
    'primary key' => array(mediamosa_ftp_user_db::ID),
    'indexes' => array(
      'idx_userid' => array(mediamosa_ftp_user_db::USERID),
    ),
  );

  return $a_schema;
}
?>