hook_schema.php

<?php 
/**
 * Implements hook_schema().
 */
function JwLanalytics_schema() {
 $schema = array();
 // this has been moveed to the communications manager
  $schema['users_logins_data'] = array(
   'description' => 'This is where we hold the users login data',
   'fields' => array(
     'lid' => array(
       'description' => 'login id',
       'type' => 'serial',
       'unsigned' => TRUE,
       'not null' => TRUE,
     ),
     'uid' => array(
       'description' => 'The primary identifier for a user',
       'type' => 'int',
       'not null' => TRUE
     ),
     'timestamp' => array(
       'description' => 'timestamp of login',
       'type' => 'text',
       'not null' => TRUE,
     ),
   ),
   'primary key' => array('lid')
 );
 return $schema;
}