kwresearch_google.install in Keyword Research 7

Install hooks for Keyword Research Google.

File

modules/kwresearch_google/kwresearch_google.install

<?php

// $Id: kwresearch_google.install,v 1.1.2.8 2011/01/05 20:42:59 tomdude48 Exp $

/**
 * @file
 * Install hooks for Keyword Research Google.
 */

/**
* Implements hook_schema
().
*/
function kwresearch_google_schema() {
  $schema['kwresearch_google_data'] = array(
    'description' => 'Creates database table to store google keyword data.',
    'fields' => array(
      'keyphrase' => array(
        'type' => 'varchar',
        'length' => '255',
        'not null' => TRUE,
        'default' => '',
        'description' => 'target keyphrase.',
      ),
      //keyphrase
      'updated' => array(
        'type' => 'int',
        'unsigned' => TRUE,
        'not null' => FALSE,
        'description' => 'timestamp of last data update',
      ),
      //updated
      'monthly_searches' => array(
        'type' => 'int',
        'not null' => TRUE,
        'default' => 0,
        'description' => 'monthly search volume.',
      ),
      //score
      'competition' => array(
        'type' => 'int',
        'size' => 'tiny',
        'not null' => TRUE,
        'default' => 0,
        'description' => 'competivness of the keyword.',
      ),
      //competition
      'avg_cpc' => array(
        'type' => 'float',
        'not null' => TRUE,
        'default' => 0,
        'description' => 'competivness of the keyword.',
      ),
      //competition
      'global_monthly_searches' => array(
        'type' => 'int',
        'not null' => FALSE,
        'description' => 'global monthly search volume from Google AdWords tool.',
      ),
      //global_monthly_searches
      'local_monthly_searches' => array(
        'type' => 'int',
        'not null' => FALSE,
        'description' => 'local monthly search volume from Google AdWords tool.',
      ),
      //local_monthly_searches
      'sktool_monthly_searches' => array(
        'type' => 'int',
        'not null' => FALSE,
        'description' => 'local monthly search volume from Google Search Keyword tool.',
      ),
    ),
    'primary key' => array(
      'keyphrase',
    ),
  );
  return $schema;
}

Functions

Name	Description
kwresearch_google_schema	Implements hook_schema ().