<?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'),
    'fields' => array(
      'aaid' => array(
        'description' => t('affiliate application id'),
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'uid' => array(
        'description' => t('User id of creator'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'affiliate_application_status' => array(
        'description' => t('Application status'),
        'type' => 'varchar',
        'length' => 10,
        'not null' => TRUE,
        'default' => 'pending',
      ),
      'affiliate_accept' => array(
        'description' => t('accept conditions checkbox value'),
        'type' => 'int',
        'size' => 'tiny',
      ),
      'affiliate_type' => array(
        'description' => t('type of broadcasting service'),
        'type' => 'varchar',
        'length' => '40',
        'not null' => TRUE,
      ),
      'affiliate_name' => array(
        'description' => t('name of broadcasting service'),
        'type' => 'varchar',
        'length' => '128',
        'not null' => TRUE,
      ),
      'affiliate_address' => array(
        'description' => t('mailing address'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'affiliate_postalcode' => array(
        'description' => t('postal code'),
        'type' => 'char',
        'length' => '10',
        'not null' => TRUE,
      ),
      'affiliate_fax' => array(
        'description' => t('fax number'),
        'type' => 'char',
        'length' => '16',
        'not null' => TRUE,
      ),
      'affiliate_url' => array(
        'description' => t('web-site URL'),
        'type' => 'varchar',
        'length' => '128',
        'not null' => FALSE,
      ),
      'affiliate_contact_title' => array(
        'description' => t('title of primary contact'),
        'type' => 'varchar',
        'length' => '128',
        'not null' => TRUE,
      ),
      'affiliate_contact_name' => array(
        'description' => t('name of primary contact'),
        'type' => 'varchar',
        'length' => '128',
        'not null' => TRUE,
      ),
      'affiliate_contact_telephone' => array(
        'description' => t('telephone number'),
        'type' => 'char',
        'length' => '16',
        'not null' => TRUE,
      ),
      'affiliate_contact_extension' => array(
        'description' => t('extension'),
        'type' => 'char',
        'length' => '8',
        'not null' => TRUE,
      ),
      'affiliate_contact_email' => array(
        'description' => t('e-mail address'),
        'type' => 'varchar',
        'length' => '128',
        'not null' => TRUE,
      ),
      'affiliate_logo' =>  array(
        'description' => t('image cache id'),
        'type' => 'int',
        'unsigned' => TRUE,
       ),       
      'affiliate_update_date' => array(
        'description' => t('creation date'),
        'mysql_type' => 'timestamp',
        'type' => 'datetime',
        'not null' => TRUE,
        'default' => 'CURRENT_TIMESTAMP',
       ),
      'affiliate_creation_date' => array(
        'description' => t('creation date'),
        'type' => 'datetime',
        'not null' => TRUE,
       ),
     ),
    'primary key' => array('aaid'),
    'unique keys' => array(
            'uid' => array('uid'),
     ),       
    );
  
   $schema['affiliate_survey'] = array(
    'description' => t('Affiliate user survey'),
    'fields' => array(
      'sid' => array(
        'description' => t('affiliate application id'),
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'aaid' => array(
        'description' => t('affiliate application id'),
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'affiliate_survey_date' => array(
        'description' => t('creation date'),
        'mysql_type' => 'timestamp',
        'type' => 'datetime',
        'not null' => TRUE,
        'default' => 'CURRENT_TIMESTAMP',
      ),
      'affiliate_survey_indiv' => array(
        'description' => t('survey individuals'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_hosp' => array(
        'description' => t('survey hospitals'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_lic_beds' => array(
        'description' => t('survey lic beds'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_nurse_homes' => array(
        'description' => t('survey nurse homes'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_nurse_or_resid_units' => array(
        'description' => t('survey nurse - resid units'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_have_website' => array(
        'description' => t('survey has website'),
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
      ),
      'affiliate_survey_website_users' => array(
        'description' => t('survey website reg users'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_total_users' => array(
        'description' => t('survey total users'),
        'type' => 'int',
        'not null' => TRUE,
      ),
      'affiliate_survey_acc_sat' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
       ),
      'affiliate_survey_acc_ftp' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
       ),
      'affiliate_survey_acc_stream' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
      ),
      'affiliate_survey_prog_daily' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'int',
        'not null' => TRUE,
       ),
      'affiliate_survey_prog_names' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'affiliate_survey_additions' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
      'affiliate_survey_comments' => array(
        'description' => t('TODO: please describe this field!'),
        'type' => 'text',
        'size' => 'big',
        'not null' => TRUE,
      ),
    ),
    'primary key' => array('sid'),
    'indexes' => array(
        'aaid' => array('aaid'),
    ),
  );
  return $schema;
}