<?php
/**
 * Implementation of hook_install().
 */
  function user_points_by_role_install() {
    drupal_install_schema('user_points_by_role');
  }
  
/**
 * Implementation of hook_uninstall().
 */
  function user_points_by_role_uninstall() {
    drupal_uninstall_schema('user_points_by_role');
   
    $userpoints_vocab_name = db_query("SELECT vid FROM {vocabulary} WHERE name = 'Userpoints'");
    while ($row = db_fetch_array($userpoints_vocab_name)) {
    $row_vid = $row['vid'];
    }
    variable_del('user_role_point_categories', $form_state['values']['fd_boxes']);
   
    $result = db_query("SELECT name, rid FROM  {role} WHERE  name <>  'anonymous user' AND  name <>  'authenticated user'");
    while ($row = db_fetch_array($result)) {
      $role_id = $row['rid'];
      $role_id_uncate = $role_id . "--0";   
    
      $result_term = db_query("SELECT name, tid  FROM {term_data} WHERE  vid ='%d'", $row_vid );
      variable_del($role_id_uncate, $form_state['values'][$role_id_uncate]);
      while ($row_term = db_fetch_array($result_term)) { 
        $cat_tid = $row_term['tid'];
        $cat_tid_field = $role_id . '--' . $cat_tid;
        variable_del($cat_tid_field, $form_state['values'][$cat_tid_field]);
      }
    }
  }

/**
 * Implementation of hook_schema.
 */
  function user_points_by_role_schema() {

  $schema['user_points_by_role'] = array(
  'fields' => array(
  'pid'  => array('type' => 'serial', 'length' => 11, 'not null' => TRUE, AUTO_INCREMENT, ),
  'uid' => array('type' => 'int', 'length' => 11, 'not null' => TRUE),
  'role' => array('type' => 'int', 'length' => 11, 'not null' => TRUE),
  'tid' => array('type' => 'int', 'length' => 11, 'not null' => TRUE),
  'points' => array('type' => 'int', 'length' => 11, 'not null' => TRUE)
  ),
  'primary key' => array('pid'),
  );
  return $schema;
 }