social_stats.install

<?php

/**
 * @file
 * Table schema for the tables used by Social Stats module.
 */

/**
 * Implementation of hook_schema().
 */
function social_stats_schema() {
  $schema['social_stats_facebook'] = array(
    'description' => 'Table containing stats from Facebook for Social Stats module.',
    'fields' => array(
      'nid' => array(
        'description' => 'Node id of a node.',
        'type' => 'int',
        'not null' => TRUE,
      ),
      'fb_likes' => array(
        'description' => 'Number of facebook likes for this node.',
        'type' => 'int',
        'default' => 0,
      ),
      'fb_shares' => array(
        'description' => 'Number of facebook shares for this node.',
        'type' => 'int',
        'default' => 0,
      ),
      'fb_comments' => array(
        'description' => 'Number of facebook comments for this node.',
        'type' => 'int',
        'default' => 0,
      ),
      'fb_total' => array(
        'description' => 'Facebook likes + shares + comments for this node.',
        'type' => 'int',
        'default' => 0,
      ),
    ),
    'primary key' => array('nid'),
  );

  $schema['social_stats_twitter'] = array(
    'description' => 'Table containing Twitter data for Social Stats module.',
    'fields' => array(
      'nid' => array(
        'description' => 'Node id of a node.',
        'type' => 'int',
        'not null' => TRUE,
      ),
      'tweets' => array(
        'description' => 'Number of times this node has been tweeted.',
        'type' => 'int',
        'default' => 0,
      ),
    ),
    'primary key' => array('nid'),
  );

  $schema['social_stats_gplus'] = array(
    'description' => 'Table containing stats from Google Plus for Social Stats module.',
    'fields' => array(
      'nid' => array(
        'description' => 'Node id of a node.',
        'type' => 'int',
        'not null' => TRUE,
      ),
      'plusone' => array(
        'description' => 'Number of times this node has been plus oned.',
        'type' => 'int',
        'default' => 0,
      ),
      'share' => array(
        'type' => 'int',
        'description' => "GooglePlus Shares",
        'not null' => FALSE,
      ),
      'total' => array(
        'type' => 'int',
        'description' => "GooglePlus Total",
        'not null' => FALSE,
      ),
    ),
    'primary key' => array('nid'),
  );

  $schema['social_stats_linkedin'] = array(
    'description' => 'Table containing stats from LinkedIn for Social Stats module.',
    'fields' => array(
      'nid' => array(
        'description' => 'Node id of a node.',
        'type' => 'int',
        'not null' => TRUE,
      ),
      'linkedin_shares' => array(
        'description' => 'Number of this node has been shared on LinkedIn.',
        'type' => 'int',
        'default' => 0,
      ),
    ),
    'primary key' => array('nid'),
  );

  $schema['social_stats_total'] = array(
    'description' => 'Value of (Facebook total + Twitter Shares + LinkedIn Shares + Google plus shares).',
    'fields' => array(
      'nid' => array(
        'description' => 'Node id of a node.',
        'type' => 'int',
        'not null' => TRUE,
      ),
      'total_virality' => array(
        'description' => '(Facebook total + Twitter Shares + LinkedIn Shares + Google plus shares)',
        'type' => 'int',
        'default' => 0,
      ),
    ),
    'primary key' => array('nid'),
  );
  return $schema;
}

/**
 * Implementation of hook_install().
 */
function social_stats_install() {
  drupal_install_schema('social_stats');
}

/**
 * Implementation of hook_uninstall().
 */
function social_stats_uninstall() {
  drupal_uninstall_schema('social_stats');
  $result = db_query("SELECT name FROM {variable} WHERE name like 'social_stats%'");
  while ($row = db_fetch_array($result)) {
    variable_del($row['name']);
  }
}