<?php
function career_tracking_schema() {
  // Table for positions and types of the challenges.
  $schema['career_tracking_points'] = array(
    'description' => 'This table stores career query data.',
    'fields' => array(
      'nid' => array(
        'description' => 'The primary identifier for a record.',
        'type' => 'serial',
        'unsigned' => TRUE,
        'not null' => TRUE
      ),
      'date' => array(
        'description' => 'store the date',
        'type' => 'varchar',
        'length' => 64,
        'not null' => TRUE,
        'default' => '',
      ),
      'type' => array(
        'description' => 'store query type',
        'type' => 'varchar',
        'length' => 64,
        'not null' => TRUE,
        'default' => '',
      ),
      'ip_address' => array(
        'description' => 'store the IP',
        'type' => 'varchar',
        'length' => 64,
        'not null' => TRUE,
        'default' => '',
      ),
      'query' => array(
        'description' => 'store the query',
        'type' => 'varchar',
        'length' => 128,
      ),
    ),
    'unique keys' => array(
      'nid' => array('nid')
    ),
    'primary key' => array('nid'),
  );


  return $schema;
}