webmaster@1: <?php
webmaster@1: // $Id: user.install,v 1.5 2008/01/08 07:46:41 goba Exp $
webmaster@1: 
webmaster@1: /**
webmaster@1:  * Implementation of hook_schema().
webmaster@1:  */
webmaster@1: function user_schema() {
webmaster@1:   $schema['access'] = array(
webmaster@1:     'description' => t('Stores site access rules.'),
webmaster@1:     'fields' => array(
webmaster@1:       'aid' => array(
webmaster@1:         'type' => 'serial',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'description' => t('Primary Key: Unique access ID.'),
webmaster@1:       ),
webmaster@1:       'mask' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 255,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Text mask used for filtering access.'),
webmaster@1:       ),
webmaster@1:       'type' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 255,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Type of access rule: name, mail or host.'),
webmaster@1:       ),
webmaster@1:       'status' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'size' => 'tiny',
webmaster@1:         'description' => t('Whether rule is to allow(1) or deny(0) access.'),
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'primary key' => array('aid'),
webmaster@1:   );
webmaster@1: 
webmaster@1:   $schema['authmap'] = array(
webmaster@1:     'description' => t('Stores distributed authentication mapping.'),
webmaster@1:     'fields' => array(
webmaster@1:       'aid' => array(
webmaster@1:         'description' => t('Primary Key: Unique authmap ID.'),
webmaster@1:         'type' => 'serial',
webmaster@1:         'unsigned' => TRUE,
webmaster@1:         'not null' => TRUE,
webmaster@1:       ),
webmaster@1:       'uid' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t("User's {users}.uid."),
webmaster@1:       ),
webmaster@1:       'authname' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 128,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Unique authentication name.'),
webmaster@1:       ),
webmaster@1:       'module' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 128,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Module which is controlling the authentication.'),
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'unique keys' => array('authname' => array('authname')),
webmaster@1:     'primary key' => array('aid'),
webmaster@1:   );
webmaster@1: 
webmaster@1:   $schema['permission'] = array(
webmaster@1:     'description' => t('Stores permissions for users.'),
webmaster@1:     'fields' => array(
webmaster@1:       'pid' => array(
webmaster@1:         'type' => 'serial',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'description' => t('Primary Key: Unique permission ID.'),
webmaster@1:       ),
webmaster@1:       'rid' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'unsigned' => TRUE,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('The {role}.rid to which the permissions are assigned.'),
webmaster@1:       ),
webmaster@1:       'perm' => array(
webmaster@1:         'type' => 'text',
webmaster@1:         'not null' => FALSE,
webmaster@1:         'size' => 'big',
webmaster@1:         'description' => t('List of permissions being assigned.'),
webmaster@1:       ),
webmaster@1:       'tid' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'unsigned' => TRUE,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Originally intended for taxonomy-based permissions, but never used.'),
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'primary key' => array('pid'),
webmaster@1:     'indexes' => array('rid' => array('rid')),
webmaster@1:   );
webmaster@1: 
webmaster@1:   $schema['role'] = array(
webmaster@1:     'description' => t('Stores user roles.'),
webmaster@1:     'fields' => array(
webmaster@1:       'rid' => array(
webmaster@1:         'type' => 'serial',
webmaster@1:         'unsigned' => TRUE,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'description' => t('Primary Key: Unique role id.'),
webmaster@1:       ),
webmaster@1:       'name' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 64,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Unique role name.'),
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'unique keys' => array('name' => array('name')),
webmaster@1:     'primary key' => array('rid'),
webmaster@1:   );
webmaster@1: 
webmaster@1:   $schema['users'] = array(
webmaster@1:     'description' => t('Stores user data.'),
webmaster@1:     'fields' => array(
webmaster@1:       'uid' => array(
webmaster@1:         'type' => 'serial',
webmaster@1:         'unsigned' => TRUE,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'description' => t('Primary Key: Unique user ID.'),
webmaster@1:       ),
webmaster@1:       'name' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 60,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Unique user name.'),
webmaster@1:       ),
webmaster@1:       'pass' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 32,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t("User's password (md5 hash)."),
webmaster@1:       ),
webmaster@1:       'mail' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 64,
webmaster@1:         'not null' => FALSE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t("User's email address."),
webmaster@1:       ),
webmaster@1:       'mode' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'size' => 'tiny',
webmaster@1:         'description' => t('Per-user comment display mode (threaded vs. flat), used by the {comment} module.'),
webmaster@1:       ),
webmaster@1:       'sort' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => FALSE,
webmaster@1:         'default' => 0,
webmaster@1:         'size' => 'tiny',
webmaster@1:         'description' => t('Per-user comment sort order (newest vs. oldest first), used by the {comment} module.'),
webmaster@1:       ),
webmaster@1:       'threshold' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => FALSE,
webmaster@1:         'default' => 0,
webmaster@1:         'size' => 'tiny',
webmaster@1:         'description' => t('Previously used by the {comment} module for per-user preferences; no longer used.'),
webmaster@1:       ),
webmaster@1:       'theme' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 255,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t("User's default theme."),
webmaster@1:       ),
webmaster@1:       'signature' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 255,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t("User's signature."),
webmaster@1:       ),
webmaster@1:       'created' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Timestamp for when user was created.'),
webmaster@1:       ),
webmaster@1:       'access' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Timestamp for previous time user accessed the site.'),
webmaster@1:       ),
webmaster@1:       'login' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t("Timestamp for user's last login."),
webmaster@1:       ),
webmaster@1:       'status' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'size' => 'tiny',
webmaster@1:         'description' => t('Whether the user is active(1) or blocked(0).'),
webmaster@1:       ),
webmaster@1:       'timezone' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 8,
webmaster@1:         'not null' => FALSE,
webmaster@1:         'description' => t("User's timezone."),
webmaster@1:       ),
webmaster@1:       'language' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 12,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t("User's default language."),
webmaster@1:       ),
webmaster@1:       'picture' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 255,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t("Path to the user's uploaded picture."),
webmaster@1:       ),
webmaster@1:       'init' => array(
webmaster@1:         'type' => 'varchar',
webmaster@1:         'length' => 64,
webmaster@1:         'not null' => FALSE,
webmaster@1:         'default' => '',
webmaster@1:         'description' => t('Email address used for initial account creation.'),
webmaster@1:       ),
webmaster@1:       'data' => array(
webmaster@1:         'type' => 'text',
webmaster@1:         'not null' => FALSE,
webmaster@1:         'size' => 'big',
webmaster@1:         'description' => t('A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored and are loaded into the $user object during user_load(). Use of this field is discouraged and it will likely disappear in a future version of Drupal.'),
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'indexes' => array(
webmaster@1:       'access' => array('access'),
webmaster@1:       'created' => array('created'),
webmaster@1:       'mail' => array('mail'),
webmaster@1:     ),
webmaster@1:     'unique keys' => array(
webmaster@1:       'name' => array('name'),
webmaster@1:     ),
webmaster@1:     'primary key' => array('uid'),
webmaster@1:   );
webmaster@1: 
webmaster@1:   $schema['users_roles'] = array(
webmaster@1:     'description' => t('Maps users to roles.'),
webmaster@1:     'fields' => array(
webmaster@1:       'uid' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'unsigned' => TRUE,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Primary Key: {users}.uid for user.'),
webmaster@1:       ),
webmaster@1:       'rid' => array(
webmaster@1:         'type' => 'int',
webmaster@1:         'unsigned' => TRUE,
webmaster@1:         'not null' => TRUE,
webmaster@1:         'default' => 0,
webmaster@1:         'description' => t('Primary Key: {role}.rid for role.'),
webmaster@1:       ),
webmaster@1:     ),
webmaster@1:     'primary key' => array('uid', 'rid'),
webmaster@1:     'indexes' => array(
webmaster@1:       'rid' => array('rid'),
webmaster@1:     ),
webmaster@1:   );
webmaster@1: 
webmaster@1:   return $schema;
webmaster@1: }
webmaster@1: