1<?php 2/** 3 * webtrees: online genealogy 4 * Copyright (C) 2018 webtrees development team 5 * This program is free software: you can redistribute it and/or modify 6 * it under the terms of the GNU General Public License as published by 7 * the Free Software Foundation, either version 3 of the License, or 8 * (at your option) any later version. 9 * This program is distributed in the hope that it will be useful, 10 * but WITHOUT ANY WARRANTY; without even the implied warranty of 11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 12 * GNU General Public License for more details. 13 * You should have received a copy of the GNU General Public License 14 * along with this program. If not, see <http://www.gnu.org/licenses/>. 15 */ 16declare(strict_types=1); 17 18namespace Fisharebest\Webtrees\Schema; 19 20use Fisharebest\Webtrees\Auth; 21use Fisharebest\Webtrees\Database; 22use Fisharebest\Webtrees\Webtrees; 23 24/** 25 * Upgrade the database schema from version 30 to version 31. 26 */ 27class Migration30 implements MigrationInterface 28{ 29 /** 30 * Upgrade to to the next version 31 * 32 * @return void 33 */ 34 public function upgrade() 35 { 36 $WEBTREES_EMAIL = 'webtrees-noreply@' . preg_replace('/^www\./i', '', $_SERVER['SERVER_NAME'] ?? ''); 37 38 // Default settings for new trees. No defaults for: 39 // imported, title, CONTACT_USER_ID, WEBMASTER_USER_ID 40 // The following settings have defaults, but may need overwriting: 41 // LANGUAGE, SURNAME_TRADITION 42 Database::prepare( 43 "INSERT IGNORE INTO `##gedcom_setting` (gedcom_id, setting_name, setting_value) VALUES" . 44 "(-1, 'ADVANCED_NAME_FACTS', 'NICK,_AKA')," . 45 "(-1, 'ADVANCED_PLAC_FACTS', '')," . 46 "(-1, 'ALLOW_THEME_DROPDOWN', '1')," . 47 "(-1, 'CALENDAR_FORMAT', 'gregorian')," . 48 "(-1, 'CHART_BOX_TAGS', '')," . 49 "(-1, 'COMMON_NAMES_ADD', '')," . 50 "(-1, 'COMMON_NAMES_REMOVE', '')," . 51 "(-1, 'COMMON_NAMES_THRESHOLD', '40')," . 52 "(-1, 'DEFAULT_PEDIGREE_GENERATIONS', '4')," . 53 "(-1, 'EXPAND_RELATIVES_EVENTS', '0')," . 54 "(-1, 'EXPAND_SOURCES', '0')," . 55 "(-1, 'FAM_FACTS_ADD', 'CENS,MARR,RESI,SLGS,MARR_CIVIL,MARR_RELIGIOUS,MARR_PARTNERS,RESN')," . 56 "(-1, 'FAM_FACTS_QUICK', 'MARR,DIV,_NMR')," . 57 "(-1, 'FAM_FACTS_UNIQUE', 'NCHI,MARL,DIV,ANUL,DIVF,ENGA,MARB,MARC,MARS,_NMR')," . 58 "(-1, 'FAM_ID_PREFIX', 'F')," . 59 "(-1, 'FORMAT_TEXT', 'markdown')," . 60 "(-1, 'FULL_SOURCES', '0')," . 61 "(-1, 'GEDCOM_ID_PREFIX', 'I')," . 62 "(-1, 'GEDCOM_MEDIA_PATH', '')," . 63 "(-1, 'GENERATE_UIDS', '0')," . 64 "(-1, 'HIDE_GEDCOM_ERRORS', '1')," . 65 "(-1, 'HIDE_LIVE_PEOPLE', '1')," . 66 "(-1, 'INDI_FACTS_ADD', 'AFN,BIRT,DEAT,BURI,CREM,ADOP,BAPM,BARM,BASM,BLES,CHRA,CONF,FCOM,ORDN,NATU,EMIG,IMMI,CENS,PROB,WILL,GRAD,RETI,DSCR,EDUC,IDNO,NATI,NCHI,NMR,OCCU,PROP,RELI,RESI,SSN,TITL,BAPL,CONL,ENDL,SLGC,_MILI,ASSO,RESN')," . 67 "(-1, 'INDI_FACTS_QUICK', 'BIRT,BURI,BAPM,CENS,DEAT,OCCU,RESI')," . 68 "(-1, 'INDI_FACTS_UNIQUE', '')," . 69 "(-1, 'KEEP_ALIVE_YEARS_BIRTH', '')," . 70 "(-1, 'KEEP_ALIVE_YEARS_DEATH', '')," . 71 "(-1, 'LANGUAGE', 'en-US')," . 72 "(-1, 'MAX_ALIVE_AGE', '120')," . 73 "(-1, 'MAX_DESCENDANCY_GENERATIONS', '15')," . 74 "(-1, 'MAX_PEDIGREE_GENERATIONS', '10')," . 75 "(-1, 'MEDIA_DIRECTORY', 'media/')," . 76 "(-1, 'MEDIA_ID_PREFIX', 'M')," . 77 "(-1, 'MEDIA_UPLOAD', :MEDIA_UPLOAD)," . 78 "(-1, 'META_DESCRIPTION', '')," . 79 "(-1, 'META_TITLE', :META_TITLE)," . 80 "(-1, 'NOTE_FACTS_ADD', 'SOUR,RESN')," . 81 "(-1, 'NOTE_FACTS_QUICK', '')," . 82 "(-1, 'NOTE_FACTS_UNIQUE', '')," . 83 "(-1, 'NOTE_ID_PREFIX', 'N')," . 84 "(-1, 'NO_UPDATE_CHAN', '0')," . 85 "(-1, 'PEDIGREE_LAYOUT', '1')," . 86 "(-1, 'PEDIGREE_ROOT_ID', '')," . 87 "(-1, 'PEDIGREE_SHOW_GENDER', '0')," . 88 "(-1, 'PREFER_LEVEL2_SOURCES', '1')," . 89 "(-1, 'QUICK_REQUIRED_FACTS', 'BIRT,DEAT')," . 90 "(-1, 'QUICK_REQUIRED_FAMFACTS', 'MARR')," . 91 "(-1, 'REPO_FACTS_ADD', 'PHON,EMAIL,FAX,WWW,RESN')," . 92 "(-1, 'REPO_FACTS_QUICK', '')," . 93 "(-1, 'REPO_FACTS_UNIQUE', 'NAME,ADDR')," . 94 "(-1, 'REPO_ID_PREFIX', 'R')," . 95 "(-1, 'REQUIRE_AUTHENTICATION', '0')," . 96 "(-1, 'SAVE_WATERMARK_IMAGE', '0')," . 97 "(-1, 'SHOW_AGE_DIFF', '0')," . 98 "(-1, 'SHOW_COUNTER', '1')," . 99 "(-1, 'SHOW_DEAD_PEOPLE', :SHOW_DEAD_PEOPLE)," . 100 "(-1, 'SHOW_EST_LIST_DATES', '0')," . 101 "(-1, 'SHOW_FACT_ICONS', '1')," . 102 "(-1, 'SHOW_GEDCOM_RECORD', '0')," . 103 "(-1, 'SHOW_HIGHLIGHT_IMAGES', '1')," . 104 "(-1, 'SHOW_LDS_AT_GLANCE', '0')," . 105 "(-1, 'SHOW_LEVEL2_NOTES', '1')," . 106 "(-1, 'SHOW_LIVING_NAMES', :SHOW_LIVING_NAMES)," . 107 "(-1, 'SHOW_MEDIA_DOWNLOAD', '0')," . 108 "(-1, 'SHOW_NO_WATERMARK', :SHOW_NO_WATERMARK)," . 109 "(-1, 'SHOW_PARENTS_AGE', '1')," . 110 "(-1, 'SHOW_PEDIGREE_PLACES', '9')," . 111 "(-1, 'SHOW_PEDIGREE_PLACES_SUFFIX', '0')," . 112 "(-1, 'SHOW_PRIVATE_RELATIONSHIPS', '1')," . 113 "(-1, 'SHOW_RELATIVES_EVENTS', '_BIRT_CHIL,_BIRT_SIBL,_MARR_CHIL,_MARR_PARE,_DEAT_CHIL,_DEAT_PARE,_DEAT_GPAR,_DEAT_SIBL,_DEAT_SPOU')," . 114 "(-1, 'SOURCE_ID_PREFIX', 'S')," . 115 "(-1, 'SOUR_FACTS_ADD', 'NOTE,REPO,SHARED_NOTE,RESN')," . 116 "(-1, 'SOUR_FACTS_QUICK', 'TEXT,NOTE,REPO')," . 117 "(-1, 'SOUR_FACTS_UNIQUE', 'AUTH,ABBR,TITL,PUBL,TEXT')," . 118 "(-1, 'SUBLIST_TRIGGER_I', '200')," . 119 "(-1, 'SURNAME_LIST_STYLE', 'style2')," . 120 "(-1, 'SURNAME_TRADITION', 'paternal')," . 121 "(-1, 'THUMBNAIL_WIDTH', '100')," . 122 "(-1, 'USE_RIN', '0')," . 123 "(-1, 'USE_SILHOUETTE', '1')," . 124 "(-1, 'WEBTREES_EMAIL', :WEBTREES_EMAIL)," . 125 "(-1, 'WORD_WRAPPED_NOTES', '0')" 126 )->execute([ 127 'MEDIA_UPLOAD' => Auth::PRIV_USER, 128 'META_TITLE' => Webtrees::NAME, 129 'SHOW_DEAD_PEOPLE' => Auth::PRIV_PRIVATE, 130 'SHOW_LIVING_NAMES' => Auth::PRIV_USER, 131 'SHOW_NO_WATERMARK' => Auth::PRIV_USER, 132 'WEBTREES_EMAIL' => $WEBTREES_EMAIL, 133 ]); 134 135 // Previous versions of webtrees allowed this setting to be empty. 136 Database::prepare( 137 "DELETE FROM `##gedcom_setting` WHERE setting_name ='WEBTREES_EMAIL' AND setting_value = ''" 138 )->execute(); 139 140 Database::prepare( 141 "INSERT IGNORE INTO `##gedcom_setting` (gedcom_id, setting_name, setting_value)" . 142 " SELECT gedcom_id, 'WEBTREES_EMAIL', :WEBTREES_EMAIL" . 143 " FROM `##gedcom` WHERE gedcom_id > 0" 144 )->execute([ 145 'WEBTREES_EMAIL' => $WEBTREES_EMAIL, 146 ]); 147 148 // Default restrictions 149 Database::prepare( 150 "INSERT IGNORE INTO `##default_resn` (gedcom_id, tag_type, resn) VALUES " . 151 "(-1, 'SSN', 'confidential')," . 152 "(-1, 'SOUR', 'privacy')," . 153 "(-1, 'REPO', 'privacy')," . 154 "(-1, 'SUBM', 'confidential')," . 155 "(-1, 'SUBN', 'confidential')" 156 )->execute(); 157 } 158} 159