Differences from version 1 to 3



@@ -1,48 +1,51 @@

- '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' ) ),
+||Name|Table|Column|Options
+id_rin_idx|pgv_individuals|i_rin|
+indi_id_idx|pgv_individuals|i_id|
+indi_name_idx|pgv_individuals|i_name|
+indi_letter_idx|pgv_individuals|i_letter|
+indi_file_idx|pgv_individuals|i_file|
+indi_surn_idx|pgv_individuals|i_surname|
+fam_id_idx|pgv_families|f_id|
+fam_file_idx|pgv_families|f_file|
+sour_id_idx|pgv_sources|s_id|
+sour_name_idx|pgv_sources|s_name|
+sour_file_idx|pgv_sources|s_file|
+other_id_idx|pgv_other|o_id|
+other_file_idx|pgv_other|o_file|
+place_place_idx|pgv_places|p_place|
+place_level_idx|pgv_places|p_level|
+place_parent_idx|pgv_places|p_parent_id|
+place_file_idx|pgv_places|p_file|
+plindex_place_idx|pgv_placelinks|pl_p_id|
+plindex_gid_idx|pgv_placelinks|pl_gid|
+plindex_file_idx|pgv_placelinks|pl_file|
+m_media_idx|pgv_media|m_media|
+mm_mediamapping_idx|pgv_media_mapping|mm_media|
+place_place_idx|pgv_places|p_place|
+place_level_idx|pgv_places|p_level|
+place_parent_idx|pgv_places|p_parent_id|
+place_file_idx|pgv_places|p_file|
+plindex_place_idx|pgv_placelinks|pl_p_id|
+plindex_gid_idx|pgv_placelinks|pl_gid|
+plindex_file_idx|pgv_placelinks|pl_file|
+name_gid_idx|pgv_names|n_gid|
+name_name_idx|pgv_names|n_name|
+name_letter_idx|pgv_names|n_letter|
+name_type_idx|pgv_names|n_type|
+name_surn_idx|pgv_names|n_surname|
+indi_surn_idx|pgv_individuals|i_surname|
+name_surn_idx|pgv_names|n_surname|
+date_day_idx|pgv_dates|d_day|
+date_month_idx|pgv_dates|d_month|
+date_mon_idx|pgv_dates|d_mon|
+date_year_idx|pgv_dates|d_year|
+date_datestamp_idx|pgv_dates|d_datestamp|
+date_fact_idx|pgv_dates|d_fact|
+date_gid_idx|pgv_dates|d_gid|
+date_file_idx|pgv_dates|d_file|
+date_type_idx|pgv_dates|d_type|
+m_media_id_idx|pgv_media|m_media|
+mm_media_id_idx|pgv_media_mapping|mm_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