function regcode_mailer_schema in Registration codes 6

Same name and namespace in other branches

1. 6.2 regcode_mailer/regcode_mailer.install \regcode_mailer_schema()
2. 7.2 regcode_mailer/regcode_mailer.install \regcode_mailer_schema()
3. 7 regcode_mailer/regcode_mailer.install \regcode_mailer_schema()

Implementation of hook_schema().

File

regcode_mailer/regcode_mailer.install, line 39

Install, uninstall and scheme functions for the regcode_mailer module.

Code

function regcode_mailer_schema() {
  $schema['regcode_mailer'] = array(
    'description' => t('Registration code mailer information'),
    'fields' => array(
      'id' => array(
        'description' => t('Mail ID'),
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'disp-width' => '11',
      ),
      'rid' => array(
        'description' => t('Regcode ID'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'disp-width' => '11',
      ),
      'is_sent' => array(
        'description' => t('Whether the code is sent'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'disp-width' => '11',
      ),
      'mailed' => array(
        'description' => t('The date code was mailed'),
        'type' => 'datetime',
        'not null' => FALSE,
      ),
      'recipient' => array(
        'description' => t('The address the code was mailed to'),
        'type' => 'varchar',
        'length' => '255',
        'not null' => FALSE,
      ),
    ),
    'primary key' => array(
      'id',
    ),
  );
  return $schema;
}