Файловый менеджер - Редактировать - /var/softaculous/webtrees/webtrees.sql
Назад
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `webtrees2120` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]block` -- CREATE TABLE `[[dbprefix]]block` ( `block_id` int(11) NOT NULL AUTO_INCREMENT, `gedcom_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `xref` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `location` enum('main','side') COLLATE utf8_unicode_ci DEFAULT NULL, `block_order` int(11) NOT NULL, `module_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`block_id`), KEY `[[dbprefix]]block_module_name_index` (`module_name`), KEY `[[dbprefix]]block_gedcom_id_index` (`gedcom_id`), KEY `[[dbprefix]]block_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]block_setting` -- CREATE TABLE `[[dbprefix]]block_setting` ( `block_id` int(11) NOT NULL, `setting_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `setting_value` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`block_id`,`setting_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]change` -- CREATE TABLE `[[dbprefix]]change` ( `change_id` int(11) NOT NULL AUTO_INCREMENT, `change_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `status` enum('accepted','pending','rejected') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending', `gedcom_id` int(11) NOT NULL, `xref` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `old_gedcom` longtext COLLATE utf8_unicode_ci NOT NULL, `new_gedcom` longtext COLLATE utf8_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`change_id`), KEY `[[dbprefix]]change_gedcom_id_status_xref_index` (`gedcom_id`,`status`,`xref`), KEY `[[dbprefix]]change_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]dates` -- CREATE TABLE `[[dbprefix]]dates` ( `d_day` tinyint(4) NOT NULL, `d_month` char(5) COLLATE utf8_unicode_ci DEFAULT NULL, `d_mon` tinyint(4) NOT NULL, `d_year` smallint(6) NOT NULL, `d_julianday1` mediumint(9) NOT NULL, `d_julianday2` mediumint(9) NOT NULL, `d_fact` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `d_gid` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `d_file` int(11) NOT NULL, `d_type` enum('@#DGREGORIAN@','@#DJULIAN@','@#DHEBREW@','@#DFRENCH R@','@#DHIJRI@','@#DROMAN@','@#DJALALI@') COLLATE utf8_unicode_ci NOT NULL, KEY `[[dbprefix]]dates_d_day_index` (`d_day`), KEY `[[dbprefix]]dates_d_month_index` (`d_month`), KEY `[[dbprefix]]dates_d_mon_index` (`d_mon`), KEY `[[dbprefix]]dates_d_year_index` (`d_year`), KEY `[[dbprefix]]dates_d_julianday1_index` (`d_julianday1`), KEY `[[dbprefix]]dates_d_julianday2_index` (`d_julianday2`), KEY `[[dbprefix]]dates_d_gid_index` (`d_gid`), KEY `[[dbprefix]]dates_d_file_index` (`d_file`), KEY `[[dbprefix]]dates_d_type_index` (`d_type`), KEY `[[dbprefix]]dates_d_fact_d_gid_index` (`d_fact`,`d_gid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]dates` -- INSERT INTO `[[dbprefix]]dates` VALUES (1, 'JAN', 1, 1850, 2396759, 2396759, 'BIRT', 'X1', 1, '@#DGREGORIAN@'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]default_resn` -- CREATE TABLE `[[dbprefix]]default_resn` ( `default_resn_id` int(11) NOT NULL AUTO_INCREMENT, `gedcom_id` int(11) NOT NULL, `xref` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `tag_type` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL, `resn` enum('none','privacy','confidential','hidden') COLLATE utf8_unicode_ci NOT NULL, `comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`default_resn_id`), UNIQUE KEY `[[dbprefix]]default_resn_gedcom_id_xref_tag_type_unique` (`gedcom_id`,`xref`,`tag_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ; -- -- Dumping data for table `[[dbprefix]]default_resn` -- INSERT INTO `[[dbprefix]]default_resn` VALUES (1, -1, NULL, 'SSN', 'confidential', NULL, '[[regtime]]'), (2, -1, NULL, 'SOUR', 'privacy', NULL, '[[regtime]]'), (3, -1, NULL, 'REPO', 'privacy', NULL, '[[regtime]]'), (4, -1, NULL, 'SUBM', 'confidential', NULL, '[[regtime]]'), (5, -1, NULL, 'SUBN', 'confidential', NULL, '[[regtime]]'), (6, 1, NULL, 'SSN', 'confidential', NULL, '[[regtime]]'), (7, 1, NULL, 'SOUR', 'privacy', NULL, '[[regtime]]'), (8, 1, NULL, 'REPO', 'privacy', NULL, '[[regtime]]'), (9, 1, NULL, 'SUBM', 'confidential', NULL, '[[regtime]]'), (10, 1, NULL, 'SUBN', 'confidential', NULL, '[[regtime]]'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]families` -- CREATE TABLE `[[dbprefix]]families` ( `f_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `f_file` int(11) NOT NULL, `f_husb` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `f_wife` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `f_gedcom` longtext COLLATE utf8_unicode_ci NOT NULL, `f_numchil` int(11) NOT NULL, PRIMARY KEY (`f_id`,`f_file`), UNIQUE KEY `[[dbprefix]]families_f_file_f_id_unique` (`f_file`,`f_id`), KEY `[[dbprefix]]families_f_husb_index` (`f_husb`), KEY `[[dbprefix]]families_f_wife_index` (`f_wife`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]favorite` -- CREATE TABLE `[[dbprefix]]favorite` ( `favorite_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `gedcom_id` int(11) NOT NULL, `xref` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `favorite_type` enum('INDI','FAM','SOUR','REPO','OBJE','NOTE','URL') COLLATE utf8_unicode_ci NOT NULL, `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `note` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`favorite_id`), KEY `[[dbprefix]]favorite_user_id_index` (`user_id`), KEY `[[dbprefix]]favorite_gedcom_id_user_id_index` (`gedcom_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]gedcom` -- CREATE TABLE `[[dbprefix]]gedcom` ( `gedcom_id` int(11) NOT NULL AUTO_INCREMENT, `gedcom_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `sort_order` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`gedcom_id`), UNIQUE KEY `[[dbprefix]]gedcom_gedcom_name_unique` (`gedcom_name`), KEY `[[dbprefix]]gedcom_sort_order_index` (`sort_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]gedcom` -- INSERT INTO `[[dbprefix]]gedcom` VALUES (-1, 'DEFAULT_TREE', 0), (1, 'tree1', 0); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]gedcom_chunk` -- CREATE TABLE `[[dbprefix]]gedcom_chunk` ( `gedcom_chunk_id` int(11) NOT NULL AUTO_INCREMENT, `gedcom_id` int(11) NOT NULL, `chunk_data` longtext COLLATE utf8_unicode_ci NOT NULL, `imported` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`gedcom_chunk_id`), KEY `[[dbprefix]]gedcom_chunk_gedcom_id_imported_index` (`gedcom_id`,`imported`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]gedcom_setting` -- CREATE TABLE `[[dbprefix]]gedcom_setting` ( `gedcom_id` int(11) NOT NULL, `setting_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `setting_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`gedcom_id`,`setting_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]gedcom_setting` -- INSERT INTO `[[dbprefix]]gedcom_setting` VALUES (1, 'CONTACT_USER_ID', '1'), (1, 'imported', '1'), (1, 'LANGUAGE', 'en-GB'), (1, 'REQUIRE_AUTHENTICATION', ''), (1, 'title', '[[site_name]]'), (1, 'WEBMASTER_USER_ID', '1'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]hit_counter` -- CREATE TABLE `[[dbprefix]]hit_counter` ( `gedcom_id` int(11) NOT NULL, `page_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `page_parameter` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `page_count` int(11) NOT NULL, PRIMARY KEY (`gedcom_id`,`page_name`,`page_parameter`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]individuals` -- CREATE TABLE `[[dbprefix]]individuals` ( `i_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `i_file` int(11) NOT NULL, `i_rin` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `i_sex` enum('U','M','F') COLLATE utf8_unicode_ci NOT NULL, `i_gedcom` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`i_id`,`i_file`), UNIQUE KEY `[[dbprefix]]individuals_i_file_i_id_unique` (`i_file`,`i_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]individuals` -- INSERT INTO `[[dbprefix]]individuals` VALUES ('X1', 1, 'X1', 'M', '0 @X1@ INDI\n1 NAME Joe /BLOGGS/\n1 SEX M\n1 BIRT\n2 DATE 01 JAN 1850\n2 NOTE Edit this individual and replace their details with your own.'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]link` -- CREATE TABLE `[[dbprefix]]link` ( `l_file` int(11) NOT NULL, `l_from` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `l_type` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `l_to` varchar(20) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`l_from`,`l_file`,`l_type`,`l_to`), UNIQUE KEY `[[dbprefix]]link_l_to_l_file_l_type_l_from_unique` (`l_to`,`l_file`,`l_type`,`l_from`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]log` -- CREATE TABLE `[[dbprefix]]log` ( `log_id` int(11) NOT NULL AUTO_INCREMENT, `log_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `log_type` enum('auth','config','debug','edit','error','media','search') COLLATE utf8_unicode_ci NOT NULL, `log_message` longtext COLLATE utf8_unicode_ci NOT NULL, `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `user_id` int(11) DEFAULT NULL, `gedcom_id` int(11) DEFAULT NULL, PRIMARY KEY (`log_id`), KEY `[[dbprefix]]log_log_time_index` (`log_time`), KEY `[[dbprefix]]log_log_type_index` (`log_type`), KEY `[[dbprefix]]log_ip_address_index` (`ip_address`), KEY `[[dbprefix]]log_user_id_index` (`user_id`), KEY `[[dbprefix]]log_gedcom_id_index` (`gedcom_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=55 ; -- -- Dumping data for table `[[dbprefix]]log` -- INSERT INTO `[[dbprefix]]log` VALUES (1, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "1"', '[[clientip]]', NULL, NULL), (2, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "2"', '[[clientip]]', NULL, NULL), (3, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "3"', '[[clientip]]', NULL, NULL), (4, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "4"', '[[clientip]]', NULL, NULL), (5, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "5"', '[[clientip]]', NULL, NULL), (6, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "6"', '[[clientip]]', NULL, NULL), (7, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "7"', '[[clientip]]', NULL, NULL), (8, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "8"', '[[clientip]]', NULL, NULL), (9, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "9"', '[[clientip]]', NULL, NULL), (10, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "10"', '[[clientip]]', NULL, NULL), (11, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "11"', '[[clientip]]', NULL, NULL), (12, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "12"', '[[clientip]]', NULL, NULL), (13, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "13"', '[[clientip]]', NULL, NULL), (14, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "14"', '[[clientip]]', NULL, NULL), (15, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "15"', '[[clientip]]', NULL, NULL), (16, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "16"', '[[clientip]]', NULL, NULL), (17, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "17"', '[[clientip]]', NULL, NULL), (18, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "18"', '[[clientip]]', NULL, NULL), (19, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "19"', '[[clientip]]', NULL, NULL), (20, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "20"', '[[clientip]]', NULL, NULL), (21, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "21"', '[[clientip]]', NULL, NULL), (22, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "22"', '[[clientip]]', NULL, NULL), (23, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "23"', '[[clientip]]', NULL, NULL), (24, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "24"', '[[clientip]]', NULL, NULL), (25, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "25"', '[[clientip]]', NULL, NULL), (26, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "26"', '[[clientip]]', NULL, NULL), (27, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "27"', '[[clientip]]', NULL, NULL), (28, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "28"', '[[clientip]]', NULL, NULL), (29, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "29"', '[[clientip]]', NULL, NULL), (30, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "30"', '[[clientip]]', NULL, NULL), (31, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "31"', '[[clientip]]', NULL, NULL), (32, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "32"', '[[clientip]]', NULL, NULL), (33, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "33"', '[[clientip]]', NULL, NULL), (34, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "34"', '[[clientip]]', NULL, NULL), (35, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "35"', '[[clientip]]', NULL, NULL), (36, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "36"', '[[clientip]]', NULL, NULL), (37, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "37"', '[[clientip]]', NULL, NULL), (38, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "38"', '[[clientip]]', NULL, NULL), (39, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "39"', '[[clientip]]', NULL, NULL), (40, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "40"', '[[clientip]]', NULL, NULL), (41, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "41"', '[[clientip]]', NULL, NULL), (42, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "42"', '[[clientip]]', NULL, NULL), (43, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "43"', '[[clientip]]', NULL, NULL), (44, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "44"', '[[clientip]]', NULL, NULL), (45, '[[regtime]]', 'config', 'Site preference "WT_SCHEMA_VERSION" set to "45"', '[[clientip]]', NULL, NULL), (49, '[[regtime]]', 'config', 'Tree preference "imported" set to "1"', '[[clientip]]', 1, 1), (50, '[[regtime]]', 'config', 'Tree preference "title" set to "[[site_name]]"', '[[clientip]]', 1, 1), (51, '[[regtime]]', 'config', 'Tree preference "REQUIRE_AUTHENTICATION" set to ""', '[[clientip]]', 1, 1), (52, '[[regtime]]', 'config', 'Tree preference "CONTACT_USER_ID" set to "1"', '[[clientip]]', 1, 1), (53, '[[regtime]]', 'config', 'Tree preference "WEBMASTER_USER_ID" set to "1"', '[[clientip]]', 1, 1), (54, '[[regtime]]', 'config', 'Tree preference "LANGUAGE" set to "en-GB"', '[[clientip]]', 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]media` -- CREATE TABLE `[[dbprefix]]media` ( `m_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `m_file` int(11) NOT NULL, `m_gedcom` longtext COLLATE utf8_unicode_ci, PRIMARY KEY (`m_file`,`m_id`), UNIQUE KEY `[[dbprefix]]media_m_id_m_file_unique` (`m_id`,`m_file`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]media_file` -- CREATE TABLE `[[dbprefix]]media_file` ( `id` int(11) NOT NULL AUTO_INCREMENT, `m_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `m_file` int(11) NOT NULL, `multimedia_file_refn` varchar(248) COLLATE utf8_unicode_ci NOT NULL, `multimedia_format` varchar(4) COLLATE utf8_unicode_ci NOT NULL, `source_media_type` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `descriptive_title` varchar(248) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `[[dbprefix]]media_file_m_id_m_file_index` (`m_id`,`m_file`), KEY `[[dbprefix]]media_file_m_file_m_id_index` (`m_file`,`m_id`), KEY `[[dbprefix]]media_file_m_file_multimedia_file_refn_index` (`m_file`,`multimedia_file_refn`), KEY `[[dbprefix]]media_file_m_file_multimedia_format_index` (`m_file`,`multimedia_format`), KEY `[[dbprefix]]media_file_m_file_source_media_type_index` (`m_file`,`source_media_type`), KEY `[[dbprefix]]media_file_m_file_descriptive_title_index` (`m_file`,`descriptive_title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]message` -- CREATE TABLE `[[dbprefix]]message` ( `message_id` int(11) NOT NULL AUTO_INCREMENT, `sender` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `user_id` int(11) NOT NULL, `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `body` longtext COLLATE utf8_unicode_ci NOT NULL, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`message_id`), KEY `[[dbprefix]]message_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]module` -- CREATE TABLE `[[dbprefix]]module` ( `module_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `status` enum('enabled','disabled') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'enabled', `tab_order` int(11) DEFAULT NULL, `menu_order` int(11) DEFAULT NULL, `sidebar_order` int(11) DEFAULT NULL, `footer_order` int(11) DEFAULT NULL, PRIMARY KEY (`module_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]module` -- INSERT INTO `[[dbprefix]]module` VALUES ('ahnentafel_report', 'enabled', NULL, NULL, NULL, NULL), ('ancestors_chart', 'enabled', NULL, NULL, NULL, NULL), ('austrian-history', 'disabled', NULL, NULL, NULL, NULL), ('austrian-presidents', 'disabled', NULL, NULL, NULL, NULL), ('bdm_report', 'enabled', NULL, NULL, NULL, NULL), ('bing-maps', 'disabled', NULL, NULL, NULL, NULL), ('bing-webmaster-tools', 'disabled', NULL, NULL, NULL, NULL), ('birth_report', 'enabled', NULL, NULL, NULL, NULL), ('branches_list', 'enabled', NULL, NULL, NULL, NULL), ('british-monarchs', 'disabled', NULL, NULL, NULL, NULL), ('british-prime-ministers', 'disabled', NULL, NULL, NULL, NULL), ('british-social-history', 'disabled', NULL, NULL, NULL, NULL), ('calendar-menu', 'enabled', NULL, NULL, NULL, NULL), ('cemetery_report', 'enabled', NULL, NULL, NULL, NULL), ('change_report', 'enabled', NULL, NULL, NULL, NULL), ('charts', 'enabled', NULL, NULL, NULL, NULL), ('charts-menu', 'enabled', NULL, NULL, NULL, NULL), ('check-for-new-version', 'enabled', NULL, NULL, NULL, NULL), ('ckeditor', 'enabled', NULL, NULL, NULL, NULL), ('clippings', 'enabled', NULL, NULL, NULL, NULL), ('clouds', 'enabled', NULL, NULL, NULL, NULL), ('colors', 'enabled', NULL, NULL, NULL, NULL), ('compact-chart', 'enabled', NULL, NULL, NULL, NULL), ('contact-links', 'enabled', NULL, NULL, NULL, NULL), ('custom-css-js', 'disabled', NULL, NULL, NULL, NULL), ('czech-leaders', 'disabled', NULL, NULL, NULL, NULL), ('death_report', 'enabled', NULL, NULL, NULL, NULL), ('descendancy', 'enabled', NULL, NULL, NULL, NULL), ('descendancy_chart', 'enabled', NULL, NULL, NULL, NULL), ('descendancy_report', 'enabled', NULL, NULL, NULL, NULL), ('dutch_monarchs', 'disabled', NULL, NULL, NULL, NULL), ('dutch_prime_ministers', 'disabled', NULL, NULL, NULL, NULL), ('esri-maps', 'disabled', NULL, NULL, NULL, NULL), ('extra_info', 'enabled', NULL, NULL, NULL, NULL), ('fab', 'enabled', NULL, NULL, NULL, NULL), ('fact_sources', 'enabled', NULL, NULL, NULL, NULL), ('family_book_chart', 'enabled', NULL, NULL, NULL, NULL), ('family_group_report', 'enabled', NULL, NULL, NULL, NULL), ('family_list', 'enabled', NULL, NULL, NULL, NULL), ('family_nav', 'enabled', NULL, NULL, NULL, NULL), ('fan_chart', 'enabled', NULL, NULL, NULL, NULL), ('faq', 'enabled', NULL, NULL, NULL, NULL), ('fix-add-death', 'enabled', NULL, NULL, NULL, NULL), ('fix-ceme-tag', 'enabled', NULL, NULL, NULL, NULL), ('fix-duplicate-links', 'enabled', NULL, NULL, NULL, NULL), ('fix-name-slashes-spaces', 'enabled', NULL, NULL, NULL, NULL), ('fix-name-tags', 'enabled', NULL, NULL, NULL, NULL), ('fix-place-names', 'enabled', NULL, NULL, NULL, NULL), ('fix-prim-tag', 'enabled', NULL, NULL, NULL, NULL), ('fix-search-and-replace', 'enabled', NULL, NULL, NULL, NULL), ('fix-wt-obje-sort', 'enabled', NULL, NULL, NULL, NULL), ('french-history', 'disabled', NULL, NULL, NULL, NULL), ('gedcom_block', 'enabled', NULL, NULL, NULL, NULL), ('gedcom_favorites', 'enabled', NULL, NULL, NULL, NULL), ('gedcom_news', 'enabled', NULL, NULL, NULL, NULL), ('gedcom_stats', 'enabled', NULL, NULL, NULL, NULL), ('GEDFact_assistant', 'enabled', NULL, NULL, NULL, NULL), ('geonames', 'disabled', NULL, NULL, NULL, NULL), ('google-analytics', 'disabled', NULL, NULL, NULL, NULL), ('google-maps', 'disabled', NULL, NULL, NULL, NULL), ('google-webmaster-tools', 'disabled', NULL, NULL, NULL, NULL), ('here-maps', 'disabled', NULL, NULL, NULL, NULL), ('hit-counter', 'enabled', NULL, NULL, NULL, NULL), ('hourglass_chart', 'enabled', NULL, NULL, NULL, NULL), ('html', 'enabled', NULL, NULL, NULL, NULL), ('individual_ext_report', 'enabled', NULL, NULL, NULL, NULL), ('individual_list', 'enabled', NULL, NULL, NULL, NULL), ('individual_report', 'enabled', NULL, NULL, NULL, NULL), ('language-af', 'enabled', NULL, NULL, NULL, NULL), ('language-ar', 'enabled', NULL, NULL, NULL, NULL), ('language-bg', 'enabled', NULL, NULL, NULL, NULL), ('language-bs', 'enabled', NULL, NULL, NULL, NULL), ('language-ca', 'enabled', NULL, NULL, NULL, NULL), ('language-cs', 'enabled', NULL, NULL, NULL, NULL), ('language-cy', 'disabled', NULL, NULL, NULL, NULL), ('language-da', 'enabled', NULL, NULL, NULL, NULL), ('language-de', 'enabled', NULL, NULL, NULL, NULL), ('language-dv', 'disabled', NULL, NULL, NULL, NULL), ('language-el', 'enabled', NULL, NULL, NULL, NULL), ('language-en-AU', 'disabled', NULL, NULL, NULL, NULL), ('language-en-GB', 'enabled', NULL, NULL, NULL, NULL), ('language-en-US', 'enabled', NULL, NULL, NULL, NULL), ('language-es', 'enabled', NULL, NULL, NULL, NULL), ('language-et', 'enabled', NULL, NULL, NULL, NULL), ('language-eu', 'disabled', NULL, NULL, NULL, NULL), ('language-fa', 'disabled', NULL, NULL, NULL, NULL), ('language-fi', 'enabled', NULL, NULL, NULL, NULL), ('language-fo', 'disabled', NULL, NULL, NULL, NULL), ('language-fr', 'enabled', NULL, NULL, NULL, NULL), ('language-fr-CA', 'disabled', NULL, NULL, NULL, NULL), ('language-gl', 'enabled', NULL, NULL, NULL, NULL), ('language-he', 'enabled', NULL, NULL, NULL, NULL), ('language-hi', 'enabled', NULL, NULL, NULL, NULL), ('language-hr', 'enabled', NULL, NULL, NULL, NULL), ('language-hu', 'enabled', NULL, NULL, NULL, NULL), ('language-id', 'disabled', NULL, NULL, NULL, NULL), ('language-is', 'enabled', NULL, NULL, NULL, NULL), ('language-it', 'enabled', NULL, NULL, NULL, NULL), ('language-ja', 'disabled', NULL, NULL, NULL, NULL), ('language-jv', 'disabled', NULL, NULL, NULL, NULL), ('language-ka', 'enabled', NULL, NULL, NULL, NULL), ('language-kk', 'enabled', NULL, NULL, NULL, NULL), ('language-ko', 'disabled', NULL, NULL, NULL, NULL), ('language-ku', 'disabled', NULL, NULL, NULL, NULL), ('language-ln', 'disabled', NULL, NULL, NULL, NULL), ('language-lt', 'enabled', NULL, NULL, NULL, NULL), ('language-lv', 'disabled', NULL, NULL, NULL, NULL), ('language-mi', 'disabled', NULL, NULL, NULL, NULL), ('language-mr', 'disabled', NULL, NULL, NULL, NULL), ('language-ms', 'disabled', NULL, NULL, NULL, NULL), ('language-nb', 'disabled', NULL, NULL, NULL, NULL), ('language-ne', 'disabled', NULL, NULL, NULL, NULL), ('language-nl', 'enabled', NULL, NULL, NULL, NULL), ('language-nn', 'disabled', NULL, NULL, NULL, NULL), ('language-oc', 'disabled', NULL, NULL, NULL, NULL), ('language-pl', 'enabled', NULL, NULL, NULL, NULL), ('language-pt', 'enabled', NULL, NULL, NULL, NULL), ('language-pt-BR', 'disabled', NULL, NULL, NULL, NULL), ('language-ro', 'disabled', NULL, NULL, NULL, NULL), ('language-ru', 'enabled', NULL, NULL, NULL, NULL), ('language-sk', 'enabled', NULL, NULL, NULL, NULL), ('language-sl', 'disabled', NULL, NULL, NULL, NULL), ('language-sq', 'disabled', NULL, NULL, NULL, NULL), ('language-sr', 'disabled', NULL, NULL, NULL, NULL), ('language-sr-Latn', 'disabled', NULL, NULL, NULL, NULL), ('language-su', 'disabled', NULL, NULL, NULL, NULL), ('language-sv', 'enabled', NULL, NULL, NULL, NULL), ('language-sw', 'disabled', NULL, NULL, NULL, NULL), ('language-ta', 'disabled', NULL, NULL, NULL, NULL), ('language-th', 'disabled', NULL, NULL, NULL, NULL), ('language-tl', 'disabled', NULL, NULL, NULL, NULL), ('language-tr', 'enabled', NULL, NULL, NULL, NULL), ('language-tt', 'disabled', NULL, NULL, NULL, NULL), ('language-uk', 'enabled', NULL, NULL, NULL, NULL), ('language-ur', 'disabled', NULL, NULL, NULL, NULL), ('language-uz', 'disabled', NULL, NULL, NULL, NULL), ('language-vi', 'enabled', NULL, NULL, NULL, NULL), ('language-yi', 'disabled', NULL, NULL, NULL, NULL), ('language-zh-Hans', 'enabled', NULL, NULL, NULL, NULL), ('language-zh-Hant', 'enabled', NULL, NULL, NULL, NULL), ('legacy-urls', 'enabled', NULL, NULL, NULL, NULL), ('lifespans_chart', 'enabled', NULL, NULL, NULL, NULL), ('lightbox', 'enabled', NULL, NULL, NULL, NULL), ('lists-menu', 'enabled', NULL, NULL, NULL, NULL), ('location_list', 'enabled', NULL, NULL, NULL, NULL), ('logged_in', 'enabled', NULL, NULL, NULL, NULL), ('login_block', 'enabled', NULL, NULL, NULL, NULL), ('low_countries_rulers', 'disabled', NULL, NULL, NULL, NULL), ('map-link-bing', 'enabled', NULL, NULL, NULL, NULL), ('map-link-google', 'enabled', NULL, NULL, NULL, NULL), ('map-link-openstreetmap', 'enabled', NULL, NULL, NULL, NULL), ('map-location-geonames', 'disabled', NULL, NULL, NULL, NULL), ('map-location-nominatim', 'disabled', NULL, NULL, NULL, NULL), ('map-location-ors', 'disabled', NULL, NULL, NULL, NULL), ('mapbox', 'disabled', NULL, NULL, NULL, NULL), ('marriage_report', 'enabled', NULL, NULL, NULL, NULL), ('matomo-analytics', 'disabled', NULL, NULL, NULL, NULL), ('media', 'enabled', NULL, NULL, NULL, NULL), ('media_list', 'enabled', NULL, NULL, NULL, NULL), ('minimal', 'enabled', NULL, NULL, NULL, NULL), ('missing_facts_report', 'enabled', NULL, NULL, NULL, NULL), ('note_list', 'enabled', NULL, NULL, NULL, NULL), ('notes', 'enabled', NULL, NULL, NULL, NULL), ('occupation_report', 'enabled', NULL, NULL, NULL, NULL), ('openrouteservice', 'disabled', NULL, NULL, NULL, NULL), ('openstreetmap', 'enabled', NULL, NULL, NULL, NULL), ('pedigree_chart', 'enabled', NULL, NULL, NULL, NULL), ('pedigree_report', 'enabled', NULL, NULL, NULL, NULL), ('pedigree-map', 'enabled', NULL, NULL, NULL, NULL), ('personal_facts', 'enabled', NULL, NULL, NULL, NULL), ('places', 'enabled', NULL, NULL, NULL, NULL), ('places_list', 'enabled', NULL, NULL, NULL, NULL), ('powered-by-webtrees', 'enabled', NULL, NULL, NULL, NULL), ('privacy-policy', 'enabled', NULL, NULL, NULL, NULL), ('random_media', 'enabled', NULL, NULL, NULL, NULL), ('recent_changes', 'enabled', NULL, NULL, NULL, NULL), ('relationships_chart', 'enabled', NULL, NULL, NULL, NULL), ('relative_ext_report', 'enabled', NULL, NULL, NULL, NULL), ('relatives', 'enabled', NULL, NULL, NULL, NULL), ('reports-menu', 'enabled', NULL, NULL, NULL, NULL), ('repository_list', 'enabled', NULL, NULL, NULL, NULL), ('review_changes', 'enabled', NULL, NULL, NULL, NULL), ('search-menu', 'enabled', NULL, NULL, NULL, NULL), ('share-anniversary', 'enabled', NULL, NULL, NULL, NULL), ('share-url', 'enabled', NULL, NULL, NULL, NULL), ('sitemap', 'disabled', NULL, NULL, NULL, NULL), ('source_list', 'enabled', NULL, NULL, NULL, NULL), ('sources_tab', 'enabled', NULL, NULL, NULL, NULL), ('statcounter', 'disabled', NULL, NULL, NULL, NULL), ('statistics_chart', 'enabled', NULL, NULL, NULL, NULL), ('stories', 'enabled', NULL, NULL, NULL, NULL), ('submitter_list', 'disabled', NULL, NULL, NULL, NULL), ('theme_select', 'enabled', NULL, NULL, NULL, NULL), ('timeline_chart', 'enabled', NULL, NULL, NULL, NULL), ('todays_events', 'enabled', NULL, NULL, NULL, NULL), ('todo', 'enabled', NULL, NULL, NULL, NULL), ('top10_givnnames', 'enabled', NULL, NULL, NULL, NULL), ('top10_pageviews', 'enabled', NULL, NULL, NULL, NULL), ('top10_surnames', 'enabled', NULL, NULL, NULL, NULL), ('tree', 'enabled', NULL, NULL, NULL, NULL), ('trees-menu', 'enabled', NULL, NULL, NULL, NULL), ('upcoming_events', 'enabled', NULL, NULL, NULL, NULL), ('us-presidents', 'disabled', NULL, NULL, NULL, NULL), ('user_blog', 'enabled', NULL, NULL, NULL, NULL), ('user_favorites', 'enabled', NULL, NULL, NULL, NULL), ('user_messages', 'enabled', NULL, NULL, NULL, NULL), ('user_welcome', 'enabled', NULL, NULL, NULL, NULL), ('webtrees', 'enabled', NULL, NULL, NULL, NULL), ('xenea', 'enabled', NULL, NULL, NULL, NULL), ('yahrzeit', 'enabled', NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]module_privacy` -- CREATE TABLE `[[dbprefix]]module_privacy` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `module_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `gedcom_id` int(11) NOT NULL, `interface` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `access_level` tinyint(4) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `[[dbprefix]]module_privacy_ix1` (`gedcom_id`,`module_name`,`interface`), UNIQUE KEY `[[dbprefix]]module_privacy_ix2` (`module_name`,`gedcom_id`,`interface`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]module_setting` -- CREATE TABLE `[[dbprefix]]module_setting` ( `module_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `setting_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `setting_value` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`module_name`,`setting_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]name` -- CREATE TABLE `[[dbprefix]]name` ( `n_file` int(11) NOT NULL, `n_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `n_num` int(11) NOT NULL, `n_type` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `n_sort` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `n_full` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `n_surname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `n_surn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `n_givn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `n_soundex_givn_std` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `n_soundex_surn_std` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `n_soundex_givn_dm` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `n_soundex_surn_dm` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`n_id`,`n_file`,`n_num`), KEY `[[dbprefix]]name_n_full_n_id_n_file_index` (`n_full`,`n_id`,`n_file`), KEY `[[dbprefix]]name_n_surn_n_file_n_type_n_id_index` (`n_surn`,`n_file`,`n_type`,`n_id`), KEY `[[dbprefix]]name_n_givn_n_file_n_type_n_id_index` (`n_givn`,`n_file`,`n_type`,`n_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]name` -- INSERT INTO `[[dbprefix]]name` VALUES (1, 'X1', 0, 'NAME', 'BLOGGS,Joe', 'Joe BLOGGS', 'BLOGGS', 'BLOGGS', 'Joe', 'J000', 'B420', '100000:400000:500000', '785400:784540:784000'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]news` -- CREATE TABLE `[[dbprefix]]news` ( `news_id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `gedcom_id` int(11) DEFAULT NULL, `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `body` text COLLATE utf8_unicode_ci NOT NULL, `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`news_id`), KEY `[[dbprefix]]news_user_id_updated_index` (`user_id`,`updated`), KEY `[[dbprefix]]news_gedcom_id_updated_index` (`gedcom_id`,`updated`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]other` -- CREATE TABLE `[[dbprefix]]other` ( `o_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `o_file` int(11) NOT NULL, `o_type` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `o_gedcom` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`o_id`,`o_file`), UNIQUE KEY `[[dbprefix]]other_o_file_o_id_unique` (`o_file`,`o_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]other` -- INSERT INTO `[[dbprefix]]other` VALUES ('HEAD', 1, 'HEAD', '0 HEAD\n1 SOUR webtrees\n1 DEST webtrees\n1 GEDC\n2 VERS 5.5.1\n2 FORM LINEAGE-LINKED\n1 CHAR UTF-8\n1 DATE [[gedrec]]'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]placelinks` -- CREATE TABLE `[[dbprefix]]placelinks` ( `pl_p_id` int(11) NOT NULL, `pl_gid` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `pl_file` int(11) NOT NULL, PRIMARY KEY (`pl_p_id`,`pl_gid`,`pl_file`), KEY `[[dbprefix]]placelinks_pl_p_id_index` (`pl_p_id`), KEY `[[dbprefix]]placelinks_pl_gid_index` (`pl_gid`), KEY `[[dbprefix]]placelinks_pl_file_index` (`pl_file`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]places` -- CREATE TABLE `[[dbprefix]]places` ( `p_id` int(11) NOT NULL AUTO_INCREMENT, `p_place` varchar(150) COLLATE utf8_unicode_ci NOT NULL, `p_parent_id` int(11) DEFAULT NULL, `p_file` int(11) NOT NULL, `p_std_soundex` longtext COLLATE utf8_unicode_ci, `p_dm_soundex` longtext COLLATE utf8_unicode_ci, PRIMARY KEY (`p_id`), UNIQUE KEY `[[dbprefix]]places_p_parent_id_p_file_p_place_unique` (`p_parent_id`,`p_file`,`p_place`), KEY `[[dbprefix]]places_p_file_p_place_index` (`p_file`,`p_place`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]place_location` -- CREATE TABLE `[[dbprefix]]place_location` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) DEFAULT NULL, `place` varchar(120) COLLATE utf8_unicode_ci NOT NULL, `latitude` double DEFAULT NULL, `longitude` double DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `[[dbprefix]]place_location_parent_id_place_unique` (`parent_id`,`place`), UNIQUE KEY `[[dbprefix]]place_location_place_parent_id_unique` (`place`,`parent_id`), KEY `[[dbprefix]]place_location_latitude_index` (`latitude`), KEY `[[dbprefix]]place_location_longitude_index` (`longitude`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]session` -- CREATE TABLE `[[dbprefix]]session` ( `session_id` varchar(256) COLLATE utf8_unicode_ci NOT NULL, `session_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int(11) NOT NULL, `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL, `session_data` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`session_id`), KEY `[[dbprefix]]session_session_time_index` (`session_time`), KEY `[[dbprefix]]session_user_id_ip_address_index` (`user_id`,`ip_address`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]session` -- -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]site_setting` -- CREATE TABLE `[[dbprefix]]site_setting` ( `setting_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `setting_value` varchar(2000) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`setting_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]site_setting` -- INSERT INTO `[[dbprefix]]site_setting` VALUES ('LANGUAGE', '[[language]]'), ('WT_SCHEMA_VERSION', '45'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]sources` -- CREATE TABLE `[[dbprefix]]sources` ( `s_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `s_file` int(11) NOT NULL, `s_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `s_gedcom` longtext COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`s_id`,`s_file`), UNIQUE KEY `[[dbprefix]]sources_s_file_s_id_unique` (`s_file`,`s_id`), KEY `[[dbprefix]]sources_s_name_index` (`s_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user` -- CREATE TABLE `[[dbprefix]]user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `real_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `email` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `password` varchar(128) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`user_id`), UNIQUE KEY `[[dbprefix]]user_user_name_unique` (`user_name`), UNIQUE KEY `[[dbprefix]]user_email_unique` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `[[dbprefix]]user` -- INSERT INTO `[[dbprefix]]user` VALUES (-1, 'DEFAULT_USER', 'DEFAULT_USER', 'DEFAULT_USER', 'DEFAULT_USER'), (1, '[[admin_username]]', '[[admin_realname]]', '[[admin_email]]', '[[admin_pass]]'); -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_gedcom_setting` -- CREATE TABLE `[[dbprefix]]user_gedcom_setting` ( `user_id` int(11) NOT NULL, `gedcom_id` int(11) NOT NULL, `setting_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `setting_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`user_id`,`gedcom_id`,`setting_name`), KEY `[[dbprefix]]user_gedcom_setting_gedcom_id_index` (`gedcom_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `[[dbprefix]]user_setting` -- CREATE TABLE `[[dbprefix]]user_setting` ( `user_id` int(11) NOT NULL, `setting_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `setting_value` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`user_id`,`setting_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `[[dbprefix]]user_setting` -- INSERT INTO `[[dbprefix]]user_setting` VALUES (1, 'canadmin', '1'), (1, 'language', '[[language]]'), (1, 'sessiontime', '[[timestamp]]'), (1, 'verified', '1'), (1, 'verified_by_admin', '1'), (1, 'visibleonline', '1'); -- -- Constraints for dumped tables -- -- -- Constraints for table `[[dbprefix]]block` -- ALTER TABLE `[[dbprefix]]block` ADD CONSTRAINT `[[dbprefix]]block_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`), ADD CONSTRAINT `[[dbprefix]]block_module_name_foreign` FOREIGN KEY (`module_name`) REFERENCES `[[dbprefix]]module` (`module_name`), ADD CONSTRAINT `[[dbprefix]]block_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`); -- -- Constraints for table `[[dbprefix]]block_setting` -- ALTER TABLE `[[dbprefix]]block_setting` ADD CONSTRAINT `[[dbprefix]]block_setting_block_id_foreign` FOREIGN KEY (`block_id`) REFERENCES `[[dbprefix]]block` (`block_id`); -- -- Constraints for table `[[dbprefix]]change` -- ALTER TABLE `[[dbprefix]]change` ADD CONSTRAINT `[[dbprefix]]change_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`), ADD CONSTRAINT `[[dbprefix]]change_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`); -- -- Constraints for table `[[dbprefix]]default_resn` -- ALTER TABLE `[[dbprefix]]default_resn` ADD CONSTRAINT `[[dbprefix]]default_resn_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`); -- -- Constraints for table `[[dbprefix]]favorite` -- ALTER TABLE `[[dbprefix]]favorite` ADD CONSTRAINT `[[dbprefix]]favorite_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]favorite_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`) ON DELETE CASCADE; -- -- Constraints for table `[[dbprefix]]gedcom_chunk` -- ALTER TABLE `[[dbprefix]]gedcom_chunk` ADD CONSTRAINT `[[dbprefix]]gedcom_chunk_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`); -- -- Constraints for table `[[dbprefix]]gedcom_setting` -- ALTER TABLE `[[dbprefix]]gedcom_setting` ADD CONSTRAINT `[[dbprefix]]gedcom_setting_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`); -- -- Constraints for table `[[dbprefix]]hit_counter` -- ALTER TABLE `[[dbprefix]]hit_counter` ADD CONSTRAINT `[[dbprefix]]hit_counter_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`); -- -- Constraints for table `[[dbprefix]]log` -- ALTER TABLE `[[dbprefix]]log` ADD CONSTRAINT `[[dbprefix]]log_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`), ADD CONSTRAINT `[[dbprefix]]log_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`); -- -- Constraints for table `[[dbprefix]]message` -- ALTER TABLE `[[dbprefix]]message` ADD CONSTRAINT `[[dbprefix]]message_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`); -- -- Constraints for table `[[dbprefix]]module_privacy` -- ALTER TABLE `[[dbprefix]]module_privacy` ADD CONSTRAINT `[[dbprefix]]module_privacy_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]module_privacy_module_name_foreign` FOREIGN KEY (`module_name`) REFERENCES `[[dbprefix]]module` (`module_name`) ON DELETE CASCADE; -- -- Constraints for table `[[dbprefix]]module_setting` -- ALTER TABLE `[[dbprefix]]module_setting` ADD CONSTRAINT `[[dbprefix]]module_setting_module_name_foreign` FOREIGN KEY (`module_name`) REFERENCES `[[dbprefix]]module` (`module_name`); -- -- Constraints for table `[[dbprefix]]news` -- ALTER TABLE `[[dbprefix]]news` ADD CONSTRAINT `[[dbprefix]]news_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`) ON DELETE CASCADE, ADD CONSTRAINT `[[dbprefix]]news_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`) ON DELETE CASCADE; -- -- Constraints for table `[[dbprefix]]place_location` -- ALTER TABLE `[[dbprefix]]place_location` ADD CONSTRAINT `[[dbprefix]]place_location_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `[[dbprefix]]place_location` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `[[dbprefix]]user_gedcom_setting` -- ALTER TABLE `[[dbprefix]]user_gedcom_setting` ADD CONSTRAINT `[[dbprefix]]user_gedcom_setting_gedcom_id_foreign` FOREIGN KEY (`gedcom_id`) REFERENCES `[[dbprefix]]gedcom` (`gedcom_id`), ADD CONSTRAINT `[[dbprefix]]user_gedcom_setting_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`); -- -- Constraints for table `[[dbprefix]]user_setting` -- ALTER TABLE `[[dbprefix]]user_setting` ADD CONSTRAINT `[[dbprefix]]user_setting_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]user` (`user_id`); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка