uc_crowdfunding.install

<?php
/**
 * @file
 * Install, update, and uninstall tables for the 
 * Ubercart Crowdfunding Feature module.
 * 
 * By Arlina E. Rhoton ("Arlina", http://drupal.org/user/1055344)
 */

/**
 * Implements hook_schema().
 */
function uc_crowdfunding_schema() {
  $schema = array();

  $schema['uc_crowdfunding_products'] = array(
    'description' => 'Crowdfunding configuration per product feature.',
    'fields' => array(
      'cfid' => array(
        'description' => 'Crowdfunding feature id',
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE,
      ),
      'pfid' => array(
        'description' => 'Product feature id, references {uc_product_features}.pfid.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'dateline' => array(
        'description' => 'Unix timestamp of the dateline to close the funding.',
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 0,
      ),
      'target' => array(
        'description' => 'Target amount to raise.',
        'type' => 'numeric',
        'precision' => 10,
        'scale' => 2,
        'not null' => TRUE,
        'default' => 0.0,
      ),
      'type' => array(
        'description' => 'How the product checks if it is available.',
        'type' => 'int',
        'size' => 'tiny',
        'unsigned' => TRUE,
        'not null' => TRUE,
        'default' => 1,
      ),
    ),
    'indexes' => array(
      'pfid' => array('pfid'),
    ),
    'primary key' => array('cfid'),
  );

  return $schema;
}

/**
 * Implements hook_uninstall().
 */
function uc_crowdfunding_uninstall() {
  db_delete('uc_product_features')
    ->condition('fid', 'crowdfunding')
    ->execute();
  db_delete('variable')
    ->condition('name', 'uc_crowdfunding_%%', 'LIKE')
    ->execute();
  cache_clear_all('variables', 'cache');
}