[Summary view] [Print] [Text view]

   1  <?php
   2  // $Id$
   3  //  Affiliate module install file
   4  
   5  /**
   6   * Implementation of hook_install().
   7   */
   8  function affiliate_install() {
   9    // Create tables.
  10    drupal_install_schema('affiliate');
  11    watchdog("affiliate","Installed affiliate",$variables = array(), $severity = WATCHDOG_NOTICE, $link = NULL);
  12  
  13  }
  14  
  15  
  16  /**
  17   * Implementation of hook_uninstall().
  18   */
  19  function affiliate_uninstall() {
  20    drupal_uninstall_schema('affiliate');
  21    watchdog("affiliate","Un-Installed affiliate",$variables = array(), $severity = WATCHDOG_NOTICE, $link = NULL);
  22  
  23  }
  24  
  25  
  26  /**
  27   * Implementation of hook_schema().
  28   */
  29  function affiliate_schema() {
  30    $schema['affiliate'] = array(
  31      'description' => t('Affiliate sign-up info and survey'),
  32      'fields' => array(
  33        'uid' => array(
  34          'description' => t('User id of creator'),
  35          'type' => 'int',
  36          'unsigned' => TRUE,
  37          'not null' => TRUE,
  38          'default' => 0,
  39        ),
  40        'affiliate_application_status' => array(
  41          'description' => t('Application status'),
  42          'mysql_type' => 'set(\'pending\',\'approved\',\'inactive\')',
  43          'type' => 'set',
  44          'not null' => TRUE,
  45          'default' => 'pending',
  46        ),
  47        'affiliate_accept_value' => array(
  48          'description' => t('accept conditions checkbox value'),
  49          'type' => 'text',
  50          'size' => 'big',
  51          'not null' => TRUE,
  52        ),
  53        'affiliate_type_value' => array(
  54          'description' => t('type of broadcasting service'),
  55          'type' => 'text',
  56          'size' => 'big',
  57          'not null' => FALSE,
  58        ),
  59        'affiliate_name_value' => array(
  60          'description' => t('name of broadcasting service'),
  61          'type' => 'varchar',
  62          'length' => '100',
  63          'not null' => FALSE,
  64        ),
  65        'affiliate_address_value' => array(
  66          'description' => t('mailing address'),
  67          'type' => 'text',
  68          'size' => 'big',
  69          'not null' => FALSE,
  70        ),
  71        'affiliate_postalcode_value' => array(
  72          'description' => t('postal code'),
  73          'type' => 'text',
  74          'size' => 'big',
  75          'not null' => FALSE,
  76        ),
  77        'affiliate_fax_value' => array(
  78          'description' => t('fax number'),
  79          'type' => 'text',
  80          'size' => 'big',
  81          'not null' => TRUE,
  82        ),
  83        'affiliate_url_value' => array(
  84          'description' => t('web-site URL'),
  85          'type' => 'text',
  86          'size' => 'big',
  87          'not null' => FALSE,
  88        ),
  89        'affiliate_contact_title_value' => array(
  90          'description' => t('title of primary contact'),
  91          'type' => 'text',
  92          'size' => 'big',
  93          'not null' => TRUE,
  94        ),
  95        'affiliate_contact_name_value' => array(
  96          'description' => t('name of primary contact'),
  97          'type' => 'text',
  98          'size' => 'big',
  99          'not null' => FALSE,
 100        ),
 101        'affiliate_contact_telephone_value' => array(
 102          'description' => t('telephone number'),
 103          'type' => 'text',
 104          'size' => 'big',
 105          'not null' => TRUE,
 106        ),
 107        'affiliate_contact_extension_value' => array(
 108          'description' => t('extension'),
 109          'type' => 'text',
 110          'size' => 'big',
 111          'not null' => TRUE,
 112        ),
 113        'affiliate_contact_email_value' => array(
 114          'description' => t('e-mail address'),
 115          'type' => 'text',
 116          'size' => 'big',
 117          'not null' => TRUE,
 118        ),
 119        'affiliate_survey_indiv_value' => array(
 120          'description' => t('survey individuals'),
 121          'type' => 'int',
 122          'not null' => FALSE,
 123        ),
 124        'affiliate_survey_hosp_value' => array(
 125          'description' => t('survey hospitals'),
 126          'type' => 'int',
 127          'not null' => TRUE,
 128        ),
 129        'affiliate_survey_lic_beds_value' => array(
 130          'description' => t('survey lic beds'),
 131          'type' => 'int',
 132          'not null' => TRUE,
 133        ),
 134        'affiliate_survey_nurse_homes_value' => array(
 135          'description' => t('survey nurse homes'),
 136          'type' => 'int',
 137          'not null' => TRUE,
 138        ),
 139        'affiliate_survey_nurse_or_resid_units_value' => array(
 140          'description' => t('survey nurse - resid units'),
 141          'type' => 'int',
 142          'not null' => TRUE,
 143        ),
 144        'affiliate_survey_have_website_value' => array(
 145          'description' => t('survey has website'),
 146          'type' => 'int',
 147          'size' => 'tiny',
 148          'not null' => TRUE,
 149        ),
 150        'affiliate_survey_website_users_value' => array(
 151          'description' => t('survey website reg users'),
 152          'type' => 'int',
 153          'not null' => TRUE,
 154        ),
 155        'affiliate_survey_total_users_value' => array(
 156          'description' => t('survey total users'),
 157          'type' => 'int',
 158          'not null' => TRUE,
 159        ),
 160      ),
 161      'primary key' => array('uid'),
 162    );
 163  }