<?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_name_value' => array(
        'description' => t('Please enter the name of your broadcasting service.'),
        'type' => 'varchar',
        'length' => '100',
        'not null' => FALSE,
      ),
      'affiliate_address_value' => array(
        'description' => t('Please enter your mailing address (Unit, Street, City, Country, if applicable)'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_postalcode_value' => array(
        'description' => t('Please enter your postal code (ZIP)'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_telephone_value' => array(
        'description' => t('Please enter your telephone number: 999-999-9999'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_extension_value' => array(
        'description' => t('Please enter your extension (if not direct-dial)'),
        'type' => 'int',
        'not null' => FALSE,
      ),
      'affiliate_fax_value' => array(
        'description' => t('Please enter your fax number (if any)'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_url_value' => array(
        'description' => t('Please enter your web-site URL (if any)'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_email_value' => array(
        'description' => t('Please enter your e-mail address '),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_contact_value' => array(
        'description' => t('Please enter the name of the primary contact for your service.'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_contact_title_value' => array(
        'description' => t('Please enter the title of the primary contact'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_type_value' => array(
        'description' => t('Please select the item that best describes your service'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_accept_value' => array(
        'description' => t('Check to accept the conditions stated in the Release and Clearance above.'),
        'type' => 'text',
        'size' => 'big',
        'not null' => FALSE,
      ),
      'affiliate_survey_total_users_value' => array(
        'description' => t('How many users do you serve?'),
        'type' => 'int',
        'not null' => FALSE,
      ),
      'affiliate_survey_indiv_value' => array(
        'description' => t('How many individuals?'),
        'type' => 'int',
        'not null' => FALSE,
      ),
    ),
    'primary key' => array('uid'),
  );
  return $schema;
}