<?php
// $Id$
//  Affiliate module install file

/**
 * Implementation of hook_install().
 */
function affiliate_install() {
  // Create tables.
  drupal_install_schema('affiliate');
  watchdog("affiliate","Installed affiliate",$variables = array(), $severity = WATCHDOG_NOTICE, $link = NULL);

}


/**
 * Implementation of hook_uninstall().
 */
function affiliate_uninstall() {
  drupal_uninstall_schema('affiliate');
  watchdog("affiliate","Un-Installed affiliate",$variables = array(), $severity = WATCHDOG_NOTICE, $link = NULL);

}


/**
 * Implementation of hook_schema().
 */
function affiliate_schema() {
  $schema['affiliate'] = array(
    'description' => t('Affiliate sign-up info and survey'),
    'fields' => array(
      'uid' => array(
        'description' => t('User id of creator'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'affiliate_application_status' => array(
        'description' => t('Application status'),
        'mysql_type' => 'set(\'pending\',\'approved\',\'inactive\')',
        'type' => 'set',
        'not null' => TRUE,
        'default' => 'pending',
      ),
      'affiliate_accept_value' => array(
        'description' => t('accept conditions checkbox value'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'affiliate_type_value' => array(
        'description' => t('type of broadcasting service'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_name_value' => array(
        'description' => t('name of broadcasting service'),
        'type' => 'varchar',
        'length' => '100',
        'not null' => FALSE,
      ),
      'affiliate_address_value' => array(
        'description' => t('mailing address'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_postalcode_value' => array(
        'description' => t('postal code'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_fax_value' => array(
        'description' => t('fax number'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'affiliate_url_value' => array(
        'description' => t('web-site URL'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_contact_title_value' => array(
        'description' => t('title of primary contact'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'affiliate_contact_name_value' => array(
        'description' => t('name of primary contact'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_contact_telephone_value' => array(
        'description' => t('telephone number'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'affiliate_contact_extension_value' => array(
        'description' => t('extension'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'affiliate_contact_email_value' => array(
        'description' => t('e-mail address'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'affiliate_survey_indiv_value' => array(
        'description' => t('survey individuals'),
        'type' => 'int',
        'not null' => FALSE,
      ),
      'affiliate_survey_hosp_value' => array(
        'description' => t('survey hospitals'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_lic_beds_value' => array(
        'description' => t('survey lic beds'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_nurse_homes_value' => array(
        'description' => t('survey nurse homes'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_nurse_or_resid_units_value' => array(
        'description' => t('survey nurse - resid units'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_have_website_value' => array(
        'description' => t('survey has website'),
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
      ),
      'affiliate_survey_website_users_value' => array(
        'description' => t('survey website reg users'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_total_users_value' => array(
        'description' => t('survey total users'),
        'type' => 'int',
        'not null' => TRUE,
      ),
    ),
    'primary key' => array('uid'),
  );
}