l('module configuration page', 'admin/config/apachesolr/stats')))); } /** * Implements hook_schema(). */ function apachesolr_stats_schema() { $schema['apachesolr_stats'] = array( 'description' => 'Table that contains a log of Apache Solr queries and performance.', 'fields' => array( 'qid' => array( 'type' => 'serial', 'not null' => TRUE, 'description' => 'Primary Key: Unique log ID.', ), 'timestamp' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'Unix timestamp of when query occurred.', ), 'numfound' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'Number of results.', ), 'total_time' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'Total query time (miliseconds).', ), 'prepare_time' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'Time taken by Solr prepare phase for this query (miliseconds).', ), 'process_time' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'Time taken by Solr process phase for this query (miliseconds).', ), 'uid' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'The {users}.uid of the user who triggered the query.', ), 'sid' => array( 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, 'default' => '', 'description' => 'Session ID of user who triggered the query.', ), 'showed_suggestions' => array( 'type' => 'int', 'not null' => TRUE, 'default' => 0, 'description' => 'Indicates whether a spelling suggestion was shown.', ), 'page' => array( 'type' => 'varchar', 'length' => 10, 'not null' => TRUE, 'default' => '', 'description' => 'Current results page.', ), 'keywords' => array( 'type' => 'varchar', 'length' => 128, 'not null' => FALSE, 'default' => '', 'description' => 'Query keywords arguments.', ), 'filters' => array( 'type' => 'text', 'size' => 'normal', 'not null' => TRUE, 'description' => 'Query filter arguments.', ), 'sort' => array( 'type' => 'varchar', 'length' => 128, 'not null' => TRUE, 'description' => 'Query sort arguments.', ), 'env_id' => array( 'description' => 'Identifies the apachesolr environment', 'type' => 'varchar', 'length' => 64, 'not null' => TRUE, ), 'page_id' => array( 'description' => 'The machine readable name of the search page.', 'type' => 'varchar', 'length' => 32, 'not null' => TRUE, 'default' => '', ), ), 'primary key' => array('qid'), ); return $schema; }