Comparing versions
Version 1Current version
'id_rin_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'individuals', 'cols' => 'i_rin', 'opts' => array( 'UNIQUE' ) ),
'indi_id_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'individuals', 'cols' => 'i_id, 'opts' => array( 'UNIQUE' ) ),
'indi_name_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'individuals', 'cols' => 'i_name, 'opts' => array( 'UNIQUE' ) ),
'indi_letter_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'individuals', 'cols' => 'i_letter, 'opts' => array( 'UNIQUE' ) ),
'indi_file_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'individuals', 'cols' => 'i_file, 'opts' => array( 'UNIQUE' ) ),
'indi_surn_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'individuals', 'cols' => 'i_surname, 'opts' => array( 'UNIQUE' ) ),
'fam_id_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'families', 'cols' => 'f_id, 'opts' => array( 'UNIQUE' ) ),
'fam_file_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'families', 'cols' => 'f_file, 'opts' => array( 'UNIQUE' ) ),
'sour_id_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'sources', 'cols' => 's_id, 'opts' => array( 'UNIQUE' ) ),
'sour_name_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'sources', 'cols' => 's_name, 'opts' => array( 'UNIQUE' ) ),
'sour_file_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'sources', 'cols' => 's_file, 'opts' => array( 'UNIQUE' ) ),
'other_id_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'other', 'cols' => 'o_id, 'opts' => array( 'UNIQUE' ) ),
'other_file_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'other', 'cols' => 'o_file, 'opts' => array( 'UNIQUE' ) ),
'place_place_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'places', 'cols' => 'p_place, 'opts' => array( 'UNIQUE' ) ),
'place_level_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'places', 'cols' => 'p_level, 'opts' => array( 'UNIQUE' ) ),
'place_parent_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'places', 'cols' => 'p_parent_id, 'opts' => array( 'UNIQUE' ) ),
'place_file_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'places', 'cols' => 'p_file, 'opts' => array( 'UNIQUE' ) ),
'plindex_place_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'placelinks', 'cols' => 'pl_p_id, 'opts' => array( 'UNIQUE' ) ),
'plindex_gid_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'placelinks', 'cols' => 'pl_gid, 'opts' => array( 'UNIQUE' ) ),
'plindex_file_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'placelinks', 'cols' => 'pl_file, 'opts' => array( 'UNIQUE' ) ),
'm_media_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'media', 'cols' => 'm_media, 'opts' => array( 'UNIQUE' ) ),
'mm_mediamapping_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'media_mapping', 'cols' => 'mm_media, 'opts' => array( 'UNIQUE' ) ),
'place_place_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'places', 'cols' => 'p_place, 'opts' => array( 'UNIQUE' ) ),
'place_level_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'places', 'cols' => 'p_level, 'opts' => array( 'UNIQUE' ) ),
'place_parent_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'places', 'cols' => 'p_parent_id, 'opts' => array( 'UNIQUE' ) ),
'place_file_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'places', 'cols' => 'p_file, 'opts' => array( 'UNIQUE' ) ),
'plindex_place_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'placelinks', 'cols' => 'pl_p_id, 'opts' => array( 'UNIQUE' ) ),
'plindex_gid_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'placelinks', 'cols' => 'pl_gid, 'opts' => array( 'UNIQUE' ) ),
'plindex_file_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'placelinks', 'cols' => 'pl_file, 'opts' => array( 'UNIQUE' ) ),
'name_gid_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'names', 'cols' => 'n_gid, 'opts' => array( 'UNIQUE' ) ),
'name_name_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'names', 'cols' => 'n_name, 'opts' => array( 'UNIQUE' ) ),
'name_letter_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'names', 'cols' => 'n_letter, 'opts' => array( 'UNIQUE' ) ),
'name_type_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'names', 'cols' => 'n_type, 'opts' => array( 'UNIQUE' ) ),
'name_surn_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'names', 'cols' => 'n_surname, 'opts' => array( 'UNIQUE' ) ),
'indi_surn_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'individuals', 'cols' => 'i_surname, 'opts' => array( 'UNIQUE' ) ),
'name_surn_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'names', 'cols' => 'n_surname, 'opts' => array( 'UNIQUE' ) ),
'date_day_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'dates', 'cols' => 'd_day, 'opts' => array( 'UNIQUE' ) ),
'date_month_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'dates', 'cols' => 'd_month, 'opts' => array( 'UNIQUE' ) ),
'date_mon_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'dates', 'cols' => 'd_mon, 'opts' => array( 'UNIQUE' ) ),
'date_year_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'dates', 'cols' => 'd_year, 'opts' => array( 'UNIQUE' ) ),
'date_datestamp_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'dates', 'cols' => 'd_datestamp, 'opts' => array( 'UNIQUE' ) ),
'date_fact_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'dates', 'cols' => 'd_fact, 'opts' => array( 'UNIQUE' ) ),
'date_gid_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'dates', 'cols' => 'd_gid, 'opts' => array( 'UNIQUE' ) ),
'date_file_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'dates', 'cols' => 'd_file, 'opts' => array( 'UNIQUE' ) ),
'date_type_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'dates', 'cols' => 'd_type, 'opts' => array( 'UNIQUE' ) ),
'm_media_id_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'media', 'cols' => 'm_media, 'opts' => array( 'UNIQUE' ) ),
'mm_media_id_idx' => array( 'table' => PHPGEDVIEW_DB_PREFIX.'media_mapping', 'cols' => 'mm_media, 'opts' => array( 'UNIQUE' ) ),

 
NameTableColumnOptions
id_rin_idxpgv_individualsi_rin
indi_id_idxpgv_individualsi_id
indi_name_idxpgv_individualsi_name
indi_letter_idxpgv_individualsi_letter
indi_file_idxpgv_individualsi_file
indi_surn_idxpgv_individualsi_surname
fam_id_idxpgv_familiesf_id
fam_file_idxpgv_familiesf_file
sour_id_idxpgv_sourcess_id
sour_name_idxpgv_sourcess_name
sour_file_idxpgv_sourcess_file
other_id_idxpgv_othero_id
other_file_idxpgv_othero_file
place_place_idxpgv_placesp_place
place_level_idxpgv_placesp_level
place_parent_idxpgv_placesp_parent_id
place_file_idxpgv_placesp_file
plindex_place_idxpgv_placelinkspl_p_id
plindex_gid_idxpgv_placelinkspl_gid
plindex_file_idxpgv_placelinkspl_file
m_media_idxpgv_mediam_media
mm_mediamapping_idxpgv_media_mappingmm_media
place_place_idxpgv_placesp_place
place_level_idxpgv_placesp_level
place_parent_idxpgv_placesp_parent_id
place_file_idxpgv_placesp_file
plindex_place_idxpgv_placelinkspl_p_id
plindex_gid_idxpgv_placelinkspl_gid
plindex_file_idxpgv_placelinkspl_file
name_gid_idxpgv_namesn_gid
name_name_idxpgv_namesn_name
name_letter_idxpgv_namesn_letter
name_type_idxpgv_namesn_type
name_surn_idxpgv_namesn_surname
indi_surn_idxpgv_individualsi_surname
name_surn_idxpgv_namesn_surname
date_day_idxpgv_datesd_day
date_month_idxpgv_datesd_month
date_mon_idxpgv_datesd_mon
date_year_idxpgv_datesd_year
date_datestamp_idxpgv_datesd_datestamp
date_fact_idxpgv_datesd_fact
date_gid_idxpgv_datesd_gid
date_file_idxpgv_datesd_file
date_type_idxpgv_datesd_type
m_media_id_idxpgv_mediam_media
mm_media_id_idxpgv_media_mappingmm_media


PhpgedviewPackage
Page History
Date/CommentUserIPVersion
02 Jan 2006 (08:38 UTC)
Lester Caine81.138.11.1363
Current • Source
Lester Caine81.138.11.1362
View • Compare • Difference • Source
Lester Caine81.138.11.1361
View • Compare • Difference • Source