<?php
// implementation attempt of hook_views_tables
function family_views_tables() {
$tables['family_individual'] = array(
  'name' => 'family_individual',
  'join' => array(
   'left' => array(
      'table' => 'node',
      'field' => 'nid',
    ),
    'right' => array(
      'field' => 'nid',
    ),
  ),
  'fields' => array(
      'firstname' => array(
        'name' => t('Family: Forename'),
        'sortable'=>TRUE,
        'help' => t('Family individuals Forename'),
      ),
      'middlename' => array(
        'name' => t('Family: Middlename'),
        'sortable'=>TRUE,
        'help' => t('Family individuals Middlename'),
        
      ),
      'lastname' => array(
        'name' => t('Family: Lastname'),
        'sortable'=>TRUE,
        'help' => t('Family individuals Surname'),
        
      ),
      'gender' => array(
        'name' => t('Family: Gender'),
        'help' => t('Family individuals Gender'),
      ),
      'birthdate' => array(
        'name' => t('Family: Birth date'),
        'sortable'=>TRUE,
        'help' => t('Family individuals Brith Date'),
      ),
      'deathdate' => array(
        'name' => t('Family: Deathdate'),
        'sortable'=>TRUE,
        'help' => t('Family individuals Death Date'),
      ),
    ),
  );
  return $tables;
}
function family_views_default_views() {
  $view = new stdClass();
  $view->name = 'family_list_indi';
  
  $view->description = 'List of all individuals';
  $view->access = array (
);
  $view->view_args_php = '';
  $view->page = TRUE;
  $view->page_title = 'Individuals List';
  $view->page_header = '';
  $view->page_header_format = '1';
  $view->page_footer = '';
  $view->page_footer_format = '1';
  $view->page_empty = '';
  $view->page_empty_format = '1';
  $view->page_type = 'table';
  $view->url = 'family/indilist';
  $view->use_pager = TRUE;
  $view->nodes_per_page = '10';
  $view->sort = array (
  );
  $view->argument = array (
  );
  $view->field = array (
    array (
      'tablename' => 'family_individual',
      'field' => 'lastname',
      'label' => 'Surname',
      'sortable' => '1',
      'defaultsort' => 'DESC',
    ),
    array (
      'tablename' => 'family_individual',
      'field' => 'firstname',
      'label' => 'Forename',
      'sortable' => '1',
    ),
    array (
      'tablename' => 'family_individual',
      'field' => 'middlename',
      'label' => 'Middlename(s)',
    ),
    array (
      'tablename' => 'family_individual',
      'field' => 'gender',
      'label' => 'Gender',
    ),
    array (
      'tablename' => 'family_individual',
      'field' => 'birthdate',
      'label' => 'Birth Date',
      'sortable' => '1',
    ),
    array (
      'tablename' => 'family_individual',
      'field' => 'deathdate',
      'label' => 'Death Date',
      'sortable' => '1',
    ),
  );
  $view->filter = array (
    array (
      'tablename' => 'node',
      'field' => 'type',
      'operator' => 'OR',
      'options' => '',
      'value' => array (
  0 => 'family_individual',
),
    ),
  );
  $view->exposed_filter = array (
  );
  $view->requires = array(family_individual, node);
  $views[$view->name] = $view;

}